Post install tests for s ->
  • Commits
  • Build time
    2h
    Wait time
    2h
    Load time
    2h26m
Logs
Date (UTC) Level Message
2026-10-28 16:27:58 INFO Init build environment with config duong-addons-run-test
2026-10-28 16:27:58 Starting step restore from config duong-addons-run-test
2026-10-28 16:27:58 Restoring template 03188-20-0-all.zip from build 3188
2026-10-28 16:27:58 Using Dockerfile Tag odoo:Docker20
2026-10-28 16:29:32 INFO Step restore finished in 91s
2026-10-28 16:29:32 Starting step test_post_install from config duong-addons-run-test
2026-10-28 16:29:32 Using Dockerfile Tag odoo:Docker20
2026-10-28 16:30:07 INFO 1 modules loaded in 3.92s, 0 queries (+0 extra)
2026-10-28 16:30:55 INFO 134 modules loaded in 47.08s, 0 queries (+0 extra)
2026-10-28 16:31:03 INFO Pregenerating assets bundles
2026-10-28 18:16:25 INFO [HOOT] Passed 205 tests (992 assertions, total time: 00:00:15)
2026-10-28 18:21:38 INFO public crawled 10 urls in 9.25s 344 queries, 0.925s 34.40q per request,
2026-10-28 18:22:04 INFO demo crawled 39 urls in 25.70s 1267 queries, 0.659s 32.49q per request
2026-10-28 18:26:02 ERROR ERROR: WithContext.test_unpublished_page Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 537, in _make_request response = conn.getresponse() ^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 461, in getresponse httplib_response = super().getresponse() ^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/http/client.py", line 1448, in getresponse response.begin() File "/usr/lib/python3.12/http/client.py", line 336, in begin version, status, reason = self._read_status() ^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/http/client.py", line 297, in _read_status line = str(self.fp.readline(_MAXLINE + 1), "iso-8859-1") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/socket.py", line 707, in readinto return self._sock.recv_into(b) ^^^^^^^^^^^^^^^^^^^^^^^ TimeoutError: timed out The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/requests/adapters.py", line 486, in send resp = conn.urlopen( ^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 845, in urlopen retries = retries.increment( ^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/util/retry.py", line 472, in increment raise reraise(type(error), error, _stacktrace) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/util/util.py", line 39, in reraise raise value File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 791, in urlopen response = self._make_request( ^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 539, in _make_request self._raise_timeout(err=e, url=url, timeout_value=read_timeout) File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 371, in _raise_timeout raise ReadTimeoutError( urllib3.exceptions.ReadTimeoutError: HTTPConnectionPool(host='127.0.0.1', port=8069): Read timed out. (read timeout=12) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/data/build/odoo/addons/website/tests/test_page.py", line 300, in test_unpublished_page r = self.url_open(specific_page.url) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 2741, in url_open return self.opener.request(method, url, params=params, data=data, json=json, files=files, timeout=timeout, headers=headers, cookies=cookies, allow_redirects=allow_redirects) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 2534, in request res = super().request(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/sessions.py", line 589, in request resp = self.send(prep, **send_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 657, in <lambda> lambda s, r, **kwargs: cls._request_handler(s, r, **kwargs), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 625, in _request_handler return _super_send(s, r, **kw) ^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/sessions.py", line 703, in send r = adapter.send(request, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/adapters.py", line 532, in send raise ReadTimeout(e, request=request) requests.exceptions.ReadTimeout: HTTPConnectionPool(host='127.0.0.1', port=8069): Read timed out. (read timeout=12)
2026-10-28 18:42:14 INFO Request with path /my/orders/640 has been ignored during test as it it does not contain the test_cursor cookie or it is expired. (required "None (request are not enabled)", got "/website_sale/tests/test_main_controller.py:TestPaymentProviderVisibility.test_payment_provider_visibility_with_portal__0")
2026-10-28 18:42:14 ERROR ERROR: TestPaymentProviderVisibility.test_payment_provider_visibility_with_portal Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 537, in _make_request response = conn.getresponse() ^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 461, in getresponse httplib_response = super().getresponse() ^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/http/client.py", line 1448, in getresponse response.begin() File "/usr/lib/python3.12/http/client.py", line 336, in begin version, status, reason = self._read_status() ^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/http/client.py", line 297, in _read_status line = str(self.fp.readline(_MAXLINE + 1), "iso-8859-1") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/socket.py", line 707, in readinto return self._sock.recv_into(b) ^^^^^^^^^^^^^^^^^^^^^^^ TimeoutError: timed out The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/requests/adapters.py", line 486, in send resp = conn.urlopen( ^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 845, in urlopen retries = retries.increment( ^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/util/retry.py", line 472, in increment raise reraise(type(error), error, _stacktrace) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/util/util.py", line 39, in reraise raise value File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 791, in urlopen response = self._make_request( ^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 539, in _make_request self._raise_timeout(err=e, url=url, timeout_value=read_timeout) File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 371, in _raise_timeout raise ReadTimeoutError( urllib3.exceptions.ReadTimeoutError: HTTPConnectionPool(host='127.0.0.1', port=8069): Read timed out. (read timeout=12) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_main_controller.py", line 46, in test_payment_provider_visibility_with_portal self.url_open(portal_url, allow_redirects=True) File "/data/build/odoo/odoo/tests/common.py", line 2741, in url_open return self.opener.request(method, url, params=params, data=data, json=json, files=files, timeout=timeout, headers=headers, cookies=cookies, allow_redirects=allow_redirects) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 2534, in request res = super().request(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/sessions.py", line 589, in request resp = self.send(prep, **send_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 657, in <lambda> lambda s, r, **kwargs: cls._request_handler(s, r, **kwargs), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/odoo/odoo/tests/common.py", line 625, in _request_handler return _super_send(s, r, **kw) ^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/sessions.py", line 703, in send r = adapter.send(request, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3/dist-packages/requests/adapters.py", line 532, in send raise ReadTimeout(e, request=request) requests.exceptions.ReadTimeout: HTTPConnectionPool(host='127.0.0.1', port=8069): Read timed out. (read timeout=12)
2026-10-28 18:42:26 ERROR FAIL: TestWebsiteSalePerformanceNoPricelist.test_product_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 142, in test_product_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 39 queries but 40 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."d_product_brand_id", "product_template"."self_order_available", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."seo_product_gtin", "product_template"."seo_product_mpn", "product_template"."seo_product_color", "product_template"."seo_product_material", "product_template"."schema_shipping_enabled", "product_template"."schema_shipping_rate", "product_template"."schema_shipping_settings_link", "product_template"."schema_return_enabled", "product_template"."schema_return_window", "product_template"."schema_return_policy_category", "product_template"."schema_return_method", "product_template"."schema_refund_type", "product_template"."schema_return_fees", "product_template"."schema_return_label", "product_template"."schema_dimensions_enabled", "product_template"."schema_height", "product_template"."schema_width", "product_template"."schema_depth", "product_template"."schema_dimension_unit", "product_template"."schema_weight_enabled", "product_template"."schema_weight", "product_template"."schema_weight_unit", "product_template"."schema_condition" FROM "product_template" WHERE "product_template"."id" IN (1293) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FR ...<message too long, truncated>
2026-10-28 18:42:30 ERROR FAIL: TestWebsiteSalePerformanceNoPricelist.test_shop_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 97, in test_shop_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 28 queries but 29 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FROM "res_company" WHERE "res_company"."id" IN (21) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id" AND "product_template__public_categ_ids"."product_public_category_id" IN (SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."not_in_shop" IS NOT TRUE)) OR NOT EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id"))) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) ORDER BY COALESCE("product_template"."is_published", FALSE) DESC , "product_template"."website_sequence" ASC , "product_template"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag"."id", "product_tag"."name"->>'en_US', "product_tag"."sequence", "product_tag"."color", "product_tag"."visible_to_customers", "product_tag"."create_uid", "product_tag"."create_date", "product_tag"."write_uid", "product_tag"."write_date", "product_tag"."pos_description"->>'en_US', "product_tag"."website_id" FROM "product_tag" WHERE ("product_tag"."visible_to_customers" IS TRUE AND ("product_tag"."website_id" IN (190) OR "product_tag"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_tag_product_product_rel" AS "product_tag__product_product_ids" WHERE "product_tag__product_product_ids"."product_tag_id" = "product_tag"."id" AND "product_tag__product_product_ids"."product_product_id" IN (SELECT "product_product"."id" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE ("product_product"."active" IS TRUE AND "product_product"."product_tmpl_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)))) AND (("product_product__product_tmpl_id"."company_id" IN (21) OR "product_product__product_tmpl_id"."company_id" IS NULL) AND "product_product__product_tmpl_id"."is_published" IS TRUE AND "product_product__product_tmpl_id"."sale_ok" IS TRUE AND ("product_product__product_tmpl_id"."website_id" IN (190) OR "product_product__product_tmpl_id"."website_id" IS NULL)))) OR EXISTS (SELECT 1 FROM ...<message too long, truncated>
2026-10-28 18:42:40 ERROR FAIL: TestWebsiteSalePerformanceWithPricelistNoRules.test_product_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 218, in test_product_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 45 queries but 46 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."d_product_brand_id", "product_template"."self_order_available", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."seo_product_gtin", "product_template"."seo_product_mpn", "product_template"."seo_product_color", "product_template"."seo_product_material", "product_template"."schema_shipping_enabled", "product_template"."schema_shipping_rate", "product_template"."schema_shipping_settings_link", "product_template"."schema_return_enabled", "product_template"."schema_return_window", "product_template"."schema_return_policy_category", "product_template"."schema_return_method", "product_template"."schema_refund_type", "product_template"."schema_return_fees", "product_template"."schema_return_label", "product_template"."schema_dimensions_enabled", "product_template"."schema_height", "product_template"."schema_width", "product_template"."schema_depth", "product_template"."schema_dimension_unit", "product_template"."schema_weight_enabled", "product_template"."schema_weight", "product_template"."schema_weight_unit", "product_template"."schema_condition" FROM "product_template" WHERE "product_template"."id" IN (1298) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>' ...<message too long, truncated>
2026-10-28 18:42:44 ERROR FAIL: TestWebsiteSalePerformanceWithPricelistNoRules.test_shop_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 205, in test_shop_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 33 queries but 34 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (347) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (347) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FROM "res_company" WHERE "res_company"."id" IN (21) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id" AND "product_template__public_categ_ids"."product_public_category_id" IN (SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."not_in_shop" IS NOT TRUE)) OR NOT EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id"))) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) ORDER BY COALESCE("product_template"."is_published", FALSE) DESC , "product_template"."website_sequence" ASC , "product_template"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag"."id", "product_tag"."name"->>'en_US', "product_tag"."sequence", "product_tag"."color", "product_tag"."visible_to_customers", "product_tag"."create_uid", "product_tag"."create_date", "product_tag"."write_uid", "product_tag"."write_date", "product_tag"."pos_description"->>'en_US', "product_tag"."website_id" FROM "product_tag" WHERE ("product_tag"."visible_to_customers" IS TRUE AND ("product_tag"."website_id" IN (190) OR "product_tag"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_tag_product_product_rel" AS "product_tag__product_product_ids" WHERE "product_tag__product_product_ids"."product_tag_id" = "product_tag"."id" AND "product_tag__product_product_ids"."product_product_id" IN (SELECT "product_product"."id" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE ("product_product"."active" IS TRUE AND "product_product"."product_tmpl_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND ...<message too long, truncated>
2026-10-28 18:42:54 ERROR FAIL: TestWebsiteSalePerformanceWithPricelist.test_product_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 269, in test_product_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 45 queries but 47 where ran: Diff of select queries: {'res_partner': 1, 'res_company': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."d_product_brand_id", "product_template"."self_order_available", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."seo_product_gtin", "product_template"."seo_product_mpn", "product_template"."seo_product_color", "product_template"."seo_product_material", "product_template"."schema_shipping_enabled", "product_template"."schema_shipping_rate", "product_template"."schema_shipping_settings_link", "product_template"."schema_return_enabled", "product_template"."schema_return_window", "product_template"."schema_return_policy_category", "product_template"."schema_return_method", "product_template"."schema_refund_type", "product_template"."schema_return_fees", "product_template"."schema_return_label", "product_template"."schema_dimensions_enabled", "product_template"."schema_height", "product_template"."schema_width", "product_template"."schema_depth", "product_template"."schema_dimension_unit", "product_template"."schema_weight_enabled", "product_template"."schema_weight", "product_template"."schema_weight_unit", "product_template"."schema_condition" FROM "product_template" WHERE "product_template"."id" IN (1303) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order ...<message too long, truncated>
2026-10-28 18:42:57 ERROR FAIL: TestWebsiteSalePerformanceWithPricelist.test_shop_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 252, in test_shop_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 35 queries but 36 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (348) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (348) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FROM "res_company" WHERE "res_company"."id" IN (21) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id" AND "product_template__public_categ_ids"."product_public_category_id" IN (SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."not_in_shop" IS NOT TRUE)) OR NOT EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id"))) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) ORDER BY COALESCE("product_template"."is_published", FALSE) DESC , "product_template"."website_sequence" ASC , "product_template"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag"."id", "product_tag"."name"->>'en_US', "product_tag"."sequence", "product_tag"."color", "product_tag"."visible_to_customers", "product_tag"."create_uid", "product_tag"."create_date", "product_tag"."write_uid", "product_tag"."write_date", "product_tag"."pos_description"->>'en_US', "product_tag"."website_id" FROM "product_tag" WHERE ("product_tag"."visible_to_customers" IS TRUE AND ("product_tag"."website_id" IN (190) OR "product_tag"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_tag_product_product_rel" AS "product_tag__product_product_ids" WHERE "product_tag__product_product_ids"."product_tag_id" = "product_tag"."id" AND "product_tag__product_product_ids"."product_product_id" IN (SELECT "product_product"."id" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE ("product_product"."active" IS TRUE AND "product_product"."product_tmpl_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "produ ...<message too long, truncated>
2026-10-28 18:43:08 ERROR FAIL: TestWebsiteSalePerformanceWithPricelistDepth.test_product_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 317, in test_product_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 51 queries but 53 where ran: Diff of select queries: {'res_partner': 1, 'res_company': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."d_product_brand_id", "product_template"."self_order_available", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."seo_product_gtin", "product_template"."seo_product_mpn", "product_template"."seo_product_color", "product_template"."seo_product_material", "product_template"."schema_shipping_enabled", "product_template"."schema_shipping_rate", "product_template"."schema_shipping_settings_link", "product_template"."schema_return_enabled", "product_template"."schema_return_window", "product_template"."schema_return_policy_category", "product_template"."schema_return_method", "product_template"."schema_refund_type", "product_template"."schema_return_fees", "product_template"."schema_return_label", "product_template"."schema_dimensions_enabled", "product_template"."schema_height", "product_template"."schema_width", "product_template"."schema_depth", "product_template"."schema_dimension_unit", "product_template"."schema_weight_enabled", "product_template"."schema_weight", "product_template"."schema_weight_unit", "product_template"."schema_condition" FROM "product_template" WHERE "product_template"."id" IN (1308) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_ ...<message too long, truncated>
2026-10-28 18:43:14 ERROR FAIL: TestWebsiteSalePerformanceWithPricelistDepth.test_shop_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 305, in test_shop_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 44 queries but 45 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (350) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (350) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FROM "res_company" WHERE "res_company"."id" IN (21) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id" AND "product_template__public_categ_ids"."product_public_category_id" IN (SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."not_in_shop" IS NOT TRUE)) OR NOT EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id"))) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) ORDER BY COALESCE("product_template"."is_published", FALSE) DESC , "product_template"."website_sequence" ASC , "product_template"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag"."id", "product_tag"."name"->>'en_US', "product_tag"."sequence", "product_tag"."color", "product_tag"."visible_to_customers", "product_tag"."create_uid", "product_tag"."create_date", "product_tag"."write_uid", "product_tag"."write_date", "product_tag"."pos_description"->>'en_US', "product_tag"."website_id" FROM "product_tag" WHERE ("product_tag"."visible_to_customers" IS TRUE AND ("product_tag"."website_id" IN (190) OR "product_tag"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_tag_product_product_rel" AS "product_tag__product_product_ids" WHERE "product_tag__product_product_ids"."product_tag_id" = "product_tag"."id" AND "product_tag__product_product_ids"."product_product_id" IN (SELECT "product_product"."id" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE ("product_product"."active" IS TRUE AND "product_product"."product_tmpl_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND " ...<message too long, truncated>
2026-10-28 18:43:28 ERROR FAIL: TestWebsiteSalePerformanceWithTrackedProducts.test_product_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 383, in test_product_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 44 queries but 46 where ran: Diff of select queries: {'uom_uom': 1, 'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."d_product_brand_id", "product_template"."self_order_available", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."seo_product_gtin", "product_template"."seo_product_mpn", "product_template"."seo_product_color", "product_template"."seo_product_material", "product_template"."schema_shipping_enabled", "product_template"."schema_shipping_rate", "product_template"."schema_shipping_settings_link", "product_template"."schema_return_enabled", "product_template"."schema_return_window", "product_template"."schema_return_policy_category", "product_template"."schema_return_method", "product_template"."schema_refund_type", "product_template"."schema_return_fees", "product_template"."schema_return_label", "product_template"."schema_dimensions_enabled", "product_template"."schema_height", "product_template"."schema_width", "product_template"."schema_depth", "product_template"."schema_dimension_unit", "product_template"."schema_weight_enabled", "product_template"."schema_weight", "product_template"."schema_weight_unit", "product_template"."schema_condition" FROM "product_template" WHERE "product_template"."id" IN (1313) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_ord ...<message too long, truncated>
2026-10-28 18:43:33 ERROR FAIL: TestWebsiteSalePerformanceWithTrackedProducts.test_shop_page_generation Traceback (most recent call last): File "/data/build/odoo/addons/website_sale/tests/test_performance.py", line 360, in test_shop_page_generation self._check_url_hot_query( File "/data/build/odoo/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) AssertionError: Expected 34 queries but 35 where ran: Diff of select queries: {'res_partner': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."iap_enrich_auto_done", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."point_of_sale_update_stock_quantities", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."free_order_label"->>'en_US' FROM "res_company" WHERE "res_company"."id" IN (21) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id" AND "product_template__public_categ_ids"."product_public_category_id" IN (SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."not_in_shop" IS NOT TRUE)) OR NOT EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template"."id"))) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) ORDER BY COALESCE("product_template"."is_published", FALSE) DESC , "product_template"."website_sequence" ASC , "product_template"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag"."id", "product_tag"."name"->>'en_US', "product_tag"."sequence", "product_tag"."color", "product_tag"."visible_to_customers", "product_tag"."create_uid", "product_tag"."create_date", "product_tag"."write_uid", "product_tag"."write_date", "product_tag"."pos_description"->>'en_US', "product_tag"."website_id" FROM "product_tag" WHERE ("product_tag"."visible_to_customers" IS TRUE AND ("product_tag"."website_id" IN (190) OR "product_tag"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "product_tag_product_product_rel" AS "product_tag__product_product_ids" WHERE "product_tag__product_product_ids"."product_tag_id" = "product_tag"."id" AND "product_tag__product_product_ids"."product_product_id" IN (SELECT "product_product"."id" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE ("product_product"."active" IS TRUE AND "product_product"."product_tmpl_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no') AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)) AND (("product_template"."company_id" IN (21) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (190) OR "product_template"."website_id" IS NULL)))) AND (("product_product__product_tmpl_id"."company_id" IN (21) OR "product_product__product_tmpl_id"."company_id" IS NULL) AND "product_product__product_tmpl_id"."is_published" IS TRUE AND "product_product__product_tmpl_id"."sale_ok" IS TRUE AND ("product_product__product_tmpl_id"."website_id" IN (190) OR "product_product__product_tmpl_id"."website_id" IS NULL)))) OR EXISTS (SELEC ...<message too long, truncated>
2026-10-28 18:53:29 ERROR 10 failed, 2 error(s) of 1922 tests when loading database '03202-20-0-all'
2026-10-28 18:54:21 INFO Getting results for build 03202-20-0
2026-10-28 18:54:21 Step test_post_install finished in 2h