bad query: b'\n            WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-02-10\', 0),(\'2025-02-09\', \'2025-01-11\', 1),(\'2025-01-10\', \'2024-12-12\', 2),(\'2024-12-11\', \'2024-11-12\', 3),(\'2024-11-11\', \'2024-10-13\', 4),(\'2024-10-12\', NULL, 5)))\n\n            SELECT\n                \n                1 * (\n                    SUM(account_move_line.amount_currency)\n                    - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n                    + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n                ) AS amount_currency,\n                ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n                ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n                ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n                ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n                ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n                COUNT(account_move_line.id) AS aml_count,\n                ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n                \n                CASE WHEN period_table.period_index = 0\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period0"\n                ,\n                CASE WHEN period_table.period_index = 1\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period1"\n                ,\n                CASE WHEN period_table.period_index = 2\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period2"\n                ,\n                CASE WHEN period_table.period_index = 3\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period3"\n                ,\n                CASE WHEN period_table.period_index = 4\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period4"\n                ,\n                CASE WHEN period_table.period_index = 5\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period5"\n                \n\n            FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n            JOIN account_journal journal ON journal.id = account_move_line.journal_id\n            JOIN account_move move ON move.id = account_move_line.move_id\n            \n                    JOIN account_account aml_ct_account\n                        ON aml_ct_account.id = account_move_line.account_id\n                    LEFT JOIN account_currency_table\n                        ON account_move_line.company_id = account_currency_table.company_id\n                        AND (\n                            account_currency_table.rate_type = CASE\n                                WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n                                WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n                                ELSE \'closing\'\n                            END\n                        )\n                        AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n                        AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n                        AND (account_currency_table.period_key = \'None_2025-02-10\' OR account_currency_table.period_key IS NULL)\n                \n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.debit_amount_currency) AS debit_amount_currency,\n                    part.debit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-10\'::date AND part.debit_move_id = account_move_line.id\n                GROUP BY part.debit_move_id\n            ) part_debit ON TRUE\n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.credit_amount_currency) AS credit_amount_currency,\n                    part.credit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-10\'::date AND part.credit_move_id = account_move_line.id\n                GROUP BY part.credit_move_id\n            ) part_credit ON TRUE\n\n            JOIN period_table ON\n                (\n                    period_table.date_start IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n                )\n                AND\n                (\n                    period_table.date_stop IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n                )\n\n            WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 7))) AND ("account_move_line"."date" <= \'2025-02-10\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 7)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n            GROUP BY period_table.period_index\n\n            HAVING\n                ROUND(SUM((CASE WHEN account_move_line.balance > 0  THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n                OR ROUND(SUM((CASE WHEN account_move_line.balance < 0  THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n            ORDER BY period_table.period_index\n\n            \n            '
ERROR: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2371, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1898, in _serve_db
    return self._transactioning(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1961, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1928, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2176, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports_cash_basis/models/account_report.py", line 17, in get_report_information
    info = super().get_report_information(options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5143, in get_report_information
    all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3077, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3240, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3590, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4121, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
    return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
    self._cr.execute(query)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

bad query: b"UPDATE ir_module_module_dependency SET auto_install_required = (name = any('{}')) WHERE module_id = 1"
ERROR: could not serialize access due to concurrent update

bad query: b'update ir_module_module set demo=true where id=347'
ERROR: could not serialize access due to concurrent update

bad query: b' UPDATE "ir_module_module"\n                    SET "write_date" = "__tmp"."write_date"::timestamp, "write_uid" = "__tmp"."write_uid"::int4\n                    FROM (VALUES (114, \'2025-02-10 14:59:09.536598\', 1), (122, \'2025-02-10 14:59:09.536598\', 1), (123, \'2025-02-10 14:59:09.536598\', 1), (126, \'2025-02-10 14:59:09.536598\', 1), (127, \'2025-02-10 14:59:09.536598\', 1), (129, \'2025-02-10 14:59:09.536598\', 1), (131, \'2025-02-10 14:59:09.536598\', 1), (136, \'2025-02-10 14:59:09.536598\', 1), (138, \'2025-02-10 14:59:09.536598\', 1), (139, \'2025-02-10 14:59:09.536598\', 1), (140, \'2025-02-10 14:59:09.536598\', 1), (141, \'2025-02-10 14:59:09.536598\', 1), (147, \'2025-02-10 14:59:09.536598\', 1), (149, \'2025-02-10 14:59:09.536598\', 1), (151, \'2025-02-10 14:59:09.536598\', 1), (152, \'2025-02-10 14:59:09.536598\', 1), (153, \'2025-02-10 14:59:09.536598\', 1), (154, \'2025-02-10 14:59:09.536598\', 1), (155, \'2025-02-10 14:59:09.536598\', 1), (167, \'2025-02-10 14:59:09.536598\', 1), (168, \'2025-02-10 14:59:09.536598\', 1), (169, \'2025-02-10 14:59:09.536598\', 1), (170, \'2025-02-10 14:59:09.536598\', 1), (176, \'2025-02-10 14:59:09.536598\', 1), (178, \'2025-02-10 14:59:09.536598\', 1), (181, \'2025-02-10 14:59:09.536598\', 1), (183, \'2025-02-10 14:59:09.536598\', 1), (185, \'2025-02-10 14:59:09.536598\', 1), (201, \'2025-02-10 14:59:09.536598\', 1), (230, \'2025-02-10 14:59:09.536598\', 1), (247, \'2025-02-10 14:59:09.536598\', 1), (288, \'2025-02-10 14:59:09.536598\', 1), (293, \'2025-02-10 14:59:09.536598\', 1), (295, \'2025-02-10 14:59:09.536598\', 1), (296, \'2025-02-10 14:59:09.536598\', 1), (302, \'2025-02-10 14:59:09.536598\', 1), (303, \'2025-02-10 14:59:09.536598\', 1), (308, \'2025-02-10 14:59:09.536598\', 1), (309, \'2025-02-10 14:59:09.536598\', 1), (344, \'2025-02-10 14:59:09.536598\', 1), (347, \'2025-02-10 14:59:09.536598\', 1), (356, \'2025-02-10 14:59:09.536598\', 1), (357, \'2025-02-10 14:59:09.536598\', 1), (380, \'2025-02-10 14:59:09.536598\', 1), (381, \'2025-02-10 14:59:09.536598\', 1), (384, \'2025-02-10 14:59:09.536598\', 1), (395, \'2025-02-10 14:59:09.536598\', 1), (396, \'2025-02-10 14:59:09.536598\', 1), (397, \'2025-02-10 14:59:09.536598\', 1), (400, \'2025-02-10 14:59:09.536598\', 1), (401, \'2025-02-10 14:59:09.536598\', 1), (402, \'2025-02-10 14:59:09.536598\', 1), (403, \'2025-02-10 14:59:09.536598\', 1), (406, \'2025-02-10 14:59:09.536598\', 1), (407, \'2025-02-10 14:59:09.536598\', 1), (409, \'2025-02-10 14:59:09.536598\', 1), (411, \'2025-02-10 14:59:09.536598\', 1), (412, \'2025-02-10 14:59:09.536598\', 1), (417, \'2025-02-10 14:59:09.536598\', 1), (418, \'2025-02-10 14:59:09.536598\', 1), (419, \'2025-02-10 14:59:09.536598\', 1), (422, \'2025-02-10 14:59:09.536598\', 1), (423, \'2025-02-10 14:59:09.536598\', 1), (424, \'2025-02-10 14:59:09.536598\', 1), (432, \'2025-02-10 14:59:09.536598\', 1), (434, \'2025-02-10 14:59:09.536598\', 1), (437, \'2025-02-10 14:59:09.536598\', 1), (445, \'2025-02-10 14:59:09.536598\', 1), (447, \'2025-02-10 14:59:09.536598\', 1), (448, \'2025-02-10 14:59:09.536598\', 1), (449, \'2025-02-10 14:59:09.536598\', 1), (450, \'2025-02-10 14:59:09.536598\', 1), (451, \'2025-02-10 14:59:09.536598\', 1), (452, \'2025-02-10 14:59:09.536598\', 1), (455, \'2025-02-10 14:59:09.536598\', 1), (456, \'2025-02-10 14:59:09.536598\', 1), (460, \'2025-02-10 14:59:09.536598\', 1), (462, \'2025-02-10 14:59:09.536598\', 1), (463, \'2025-02-10 14:59:09.536598\', 1), (476, \'2025-02-10 14:59:09.536598\', 1), (478, \'2025-02-10 14:59:09.536598\', 1), (479, \'2025-02-10 14:59:09.536598\', 1), (480, \'2025-02-10 14:59:09.536598\', 1), (481, \'2025-02-10 14:59:09.536598\', 1), (482, \'2025-02-10 14:59:09.536598\', 1), (483, \'2025-02-10 14:59:09.536598\', 1), (484, \'2025-02-10 14:59:09.536598\', 1), (485, \'2025-02-10 14:59:09.536598\', 1), (486, \'2025-02-10 14:59:09.536598\', 1), (487, \'2025-02-10 14:59:09.536598\', 1), (488, \'2025-02-10 14:59:09.536598\', 1), (489, \'2025-02-10 14:59:09.536598\', 1), (490, \'2025-02-10 14:59:09.536598\', 1), (491, \'2025-02-10 14:59:09.536598\', 1), (494, \'2025-02-10 14:59:09.536598\', 1), (495, \'2025-02-10 14:59:09.536598\', 1), (496, \'2025-02-10 14:59:09.536598\', 1), (497, \'2025-02-10 14:59:09.536598\', 1), (498, \'2025-02-10 14:59:09.536598\', 1), (503, \'2025-02-10 14:59:09.536598\', 1)) AS "__tmp"("id", "write_date", "write_uid")\n                    WHERE "ir_module_module"."id" = "__tmp"."id"\n                '
ERROR: could not serialize access due to concurrent update

bad query: b"UPDATE ir_module_module_dependency SET auto_install_required = (name = any('{}')) WHERE module_id = 1"
ERROR: could not serialize access due to concurrent update

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/cache.py", line 103, in lookup
    r = d[key]
  File "<decorator-gen-6>", line 2, in __getitem__
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/func.py", line 97, in locked
    return func(inst, *args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/lru.py", line 33, in __getitem__
    a = self.d[obj]
KeyError: ('ir.model.data', <function IrModelData._xmlid_lookup at 0x7fda21140820>, 'stock_batch_picking_voucher.batch_picking_preprinted')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2371, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1898, in _serve_db
    return self._transactioning(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1961, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1928, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2176, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 40, in call_button
    action = call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
  File "/data/build/ingadhoc-stock/stock_batch_picking_voucher/models/stock_picking_batch.py", line 80, in do_print_and_assign
    return self.with_context(batch=True).do_print_batch_vouchers()
  File "/data/build/ingadhoc-stock/stock_batch_picking_voucher/models/stock_picking_batch.py", line 87, in do_print_batch_vouchers
    return self.env.ref("stock_batch_picking_voucher.batch_picking_preprinted").report_action(self)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 642, in ref
    res_model, res_id = self['ir.model.data']._xmlid_to_res_model_res_id(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_model.py", line 2245, in _xmlid_to_res_model_res_id
    return self._xmlid_lookup(xmlid)
  File "<decorator-gen-44>", line 2, in _xmlid_lookup
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/cache.py", line 110, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_model.py", line 2238, in _xmlid_lookup
    raise ValueError('External ID not found in the system: %s' % xmlid)
ValueError: External ID not found in the system: stock_batch_picking_voucher.batch_picking_preprinted

bad query: b' UPDATE "bus_presence"\n                    SET "last_poll" = "__tmp"."last_poll"::timestamp, "last_presence" = "__tmp"."last_presence"::timestamp, "status" = "__tmp"."status"::VARCHAR\n                    FROM (VALUES (1, \'2025-02-10 15:43:57\', \'2025-02-10 15:38:31.424000\', \'online\')) AS "__tmp"("id", "last_poll", "last_presence", "status")\n                    WHERE "bus_presence"."id" = "__tmp"."id"\n                '
ERROR: could not serialize access due to concurrent update