Description: Post install tests for pos -> !sale
Commit: erp:f303ebf5  
Subject: Merge pull request #1920 from Hung412/feature/3035
Author: HungBVT
Committer: GitHub
Commit: enterprise:776848dc  
Subject: [FIX] social_facebook: fix the computation of the stats
Author: std-odoo
Committer: std-odoo
Commit: odoo:3beca869  
Subject: Merge branch 'odoo:18.0' into 18.0
Author: AnhBT
Committer: GitHub
Commit: external:74623953  
Subject: [ADD] *: Add new module
Author: AnhBT
Committer: AnhBT
Version: 18.0
Config: Parallel testing
Build time: 31m
Wait time: 31m
Load time: 30m31s
Date Level Type Message
2025-11-24 03:22:02 INFO runbot Init build environment with config Parallel testing
2025-11-24 03:22:02 Starting step restore from config Parallel testing
2025-11-24 03:22:02 Restoring dump 01864-18-0-all.zip from build 1864
2025-11-24 03:22:02 Using Dockerfile Tag odoo:Docker18
2025-11-24 03:25:54 INFO runbot Step restore finished in 4m
2025-11-24 03:25:54 Starting step Start post install tests from config Parallel testing
2025-11-24 03:25:54 Using Dockerfile Tag odoo:Docker18
2025-11-24 03:52:33 INFO runbot Getting results for build 01874-18-0
2025-11-24 03:52:33 ERROR runbot 
Error found in logs:
2025-11-24 03:34:40,779 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1006, \'E-COM08\', \'{"1": 7044.0}\', \'2025-11-24 03:34:39.949170\', 1), (1007, \'E-COM10\', \'{"1": 10.0}\', \'2025-11-24 03:34:39.949170\', 1), (1008, \'E-COM05\', \'{"1": 140.0}\', \'2025-11-24 03:34:39.949170\', 1), (1010, \'E-COM12\', \'{"1": 79.0}\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "standard_price", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:40,896 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1031, \'E-COM08\', \'{"1": 7044.0}\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "standard_price", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:41,018 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1032, \'E-COM10\', \'{"1": 10.0}\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "standard_price", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:41,237 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "pricer_product_to_create_or_update" = "__tmp"."pricer_product_to_create_or_update"::bool, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "weight" = "__tmp"."weight"::numeric, "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1034, \'E-COM09\', true, \'{"1": 1299.0}\', \'9.54\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "pricer_product_to_create_or_update", "standard_price", "weight", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:41,356 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1035, \'E-COM12\', \'{"1": 79.0}\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "standard_price", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:41,474 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "weight" = "__tmp"."weight"::numeric, "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1036, \'E-COM07\', \'{"1": 260.0}\', \'0.33\', \'2025-11-24T03:34:39.949170\'::timestamp, 1)) AS "__tmp"("id", "default_code", "standard_price", "weight", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:43,084 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "default_code" = "__tmp"."default_code"::VARCHAR, "standard_price" = (SELECT jsonb_object_agg(d.key, d.value)\n                        FROM jsonb_each(COALESCE("product_product"."standard_price", \'{}\'::jsonb) || "__tmp"."standard_price"::jsonb) d\n                        JOIN jsonb_each(\'{"1": 0.0, "2": 0.0, "3": 0.0}\') f\n                        ON d.key = f.key AND d.value != f.value), "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1050, \'M-Wir\', \'{"1": 18.0}\', \'2025-11-24 03:34:39.949170\', 1)) AS "__tmp"("id", "default_code", "standard_price", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:43,637 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_import_files: FAIL: Subtest TestImportFiles.test_import_product_demo_xls [product.template]
2025-11-24 03:34:56,044 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b' UPDATE "product_product"\n                    SET "can_image_variant_1024_be_zoomed" = "__tmp"."can_image_variant_1024_be_zoomed"::bool, "combination_indices" = "__tmp"."combination_indices"::VARCHAR, "default_code" = "__tmp"."default_code"::VARCHAR, "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (1136, false, \'\', \'DEFCODE\', \'2025-11-24T03:34:55.846883\'::timestamp, 1), (1137, false, \'\', \'DEFCODE\', \'2025-11-24T03:34:55.846883\'::timestamp, 1)) AS "__tmp"("id", "can_image_variant_1024_be_zoomed", "combination_indices", "default_code", "write_date", "write_uid")\n                    WHERE "product_product"."id" = "__tmp"."id"\n                '
2025-11-24 03:34:56,046 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_10_sellers
2025-11-24 03:34:56,053 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'SAVEPOINT test_259'
2025-11-24 03:34:56,053 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_20_sellers_company
2025-11-24 03:34:56,055 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'SAVEPOINT test_260'
2025-11-24 03:34:56,055 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_30_select_seller
2025-11-24 03:34:56,056 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'SAVEPOINT test_261'
2025-11-24 03:34:56,056 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_31_select_seller
2025-11-24 03:34:56,057 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'SAVEPOINT test_262'
2025-11-24 03:34:56,064 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_40_seller_min_qty_precision
2025-11-24 03:34:56,065 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'SAVEPOINT test_263'
2025-11-24 03:34:56,065 43 ERROR 01874-18-0-all odoo.addons.product.tests.test_seller: ERROR: TestSeller.test_50_seller_ids
2025-11-24 03:39:59,022 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:39:50.593086\', 249, \'PROD_ORDER\', false, 1083, \'{"75": 240.0}\', \'2025-11-24 03:39:50.593086\', 249) RETURNING "id"'
2025-11-24 03:39:59,026 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.project_purchase.tests.test_project_profitability.TestProjectPurchaseProfitability)
2025-11-24 03:40:06,782 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:39:59.042645\', 251, \'PROD_ORDER\', false, 1089, \'{"76": 240.0}\', \'2025-11-24 03:39:59.042645\', 251) RETURNING "id"'
2025-11-24 03:40:06,784 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.project_purchase.tests.test_project_purchase.TestProjectPurchase)
2025-11-24 03:42:09,744 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:42:02.731233\', 268, \'PROD_ORDER\', false, 1127, \'{"87": 240.0}\', \'2025-11-24 03:42:02.731233\', 268) RETURNING "id"'
2025-11-24 03:42:09,746 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.purchase.tests.test_purchase_downpayment.TestPurchaseDownpayment)
2025-11-24 03:42:16,768 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:42:09.756882\', 270, \'PROD_ORDER\', false, 1133, \'{"88": 240.0}\', \'2025-11-24 03:42:09.756882\', 270) RETURNING "id"'
2025-11-24 03:42:16,769 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.purchase.tests.test_purchase_invoice.TestPurchaseToInvoice)
2025-11-24 03:42:24,861 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:42:16.784148\', 272, \'PROD_ORDER\', false, 1139, \'{"89": 240.0}\', \'2025-11-24 03:42:16.784148\', 272) RETURNING "id"'
2025-11-24 03:42:24,862 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.purchase.tests.test_purchase_invoice.TestInvoicePurchaseMatch)
2025-11-24 03:44:09,827 43 ERROR 01874-18-0-all odoo.sql_db: bad query: b'INSERT INTO "product_product" ("active", "base_unit_count", "create_date", "create_uid", "default_code", "pricer_product_to_create_or_update", "product_tmpl_id", "standard_price", "write_date", "write_uid") VALUES (true, 1.0, \'2025-11-24 03:44:08.655170\', 1, \'E-COM10\', false, 1211, \'{"1": 10.0}\', \'2025-11-24 03:44:08.655170\', 1) RETURNING "id"'
2025-11-24 03:44:09,829 43 ERROR 01874-18-0-all odoo.tests.suite: ERROR: setUpClass (odoo.addons.purchase_requisition.tests.test_purchase_requisition.TestPurchaseRequisition)
2025-11-24 03:52:05,798 43 ERROR 01874-18-0-all odoo.tests.result: 1 failed, 12 error(s) of 748 tests when loading database '01874-18-0-all'
2025-11-24 03:52:33 INFO runbot Getting stats from log file
2025-11-24 03:52:33 Step Start post install tests finished in 26m
2025-11-24 04:10:42 INFO runbot Killing build 01874-18-0, requested by AnhBT (user #2)