bad query: 
                WITH visitor AS (
                    
            INSERT INTO website_visitor (
                partner_id, access_token, last_connection_datetime, visit_count, lang_id,
                website_id, timezone, write_uid, create_uid, write_date, create_date, country_id)
            VALUES (
                3, 3, now() at time zone 'UTC', 1, 1,
                1, 'Asia/Bangkok', 2, 2,
                now() at time zone 'UTC', now() at time zone 'UTC', (
                    SELECT id FROM res_country WHERE code = NULL
                )
            )
            ON CONFLICT (access_token)
            DO UPDATE SET
                last_connection_datetime=excluded.last_connection_datetime,
                visit_count = CASE WHEN website_visitor.last_connection_datetime < NOW() AT TIME ZONE 'UTC' - INTERVAL '8 hours'
                                    THEN website_visitor.visit_count + 1
                                    ELSE website_visitor.visit_count
                                END
            RETURNING id, CASE WHEN create_date = now() at time zone 'UTC' THEN 'inserted' ELSE 'updated' END AS upsert
        , 'https://12729-16-0-without_demo.runbot.aegis.aginix.tech/' AS url, 4 AS page_id
                ), track AS (
                    INSERT INTO website_track (visitor_id, url, page_id, visit_datetime)
                    SELECT id, url, page_id::integer, now() at time zone 'UTC' FROM visitor
                )
                SELECT id, upsert from visitor;
            
ERROR: could not serialize access due to concurrent update

bad query: INSERT INTO "account_payment" ("amount", "bank_payment_template_id", "create_date", "create_uid", "currency_id", "destination_account_id", "export_status", "move_id", "partner_bank_id", "partner_id", "partner_type", "payment_method_line_id", "payment_token_id", "payment_type", "to_clear_tax", "write_date", "write_uid") VALUES ('5000.00', NULL, '2026-06-24 08:06:59.919284', 2, 134, 268, 'draft', 28, NULL, 18, 'customer', 9, NULL, 'inbound', false, '2026-06-24 08:06:59.919284', 2) RETURNING "id"
ERROR: null value in column "kmitl_payment_type_id" of relation "account_payment" violates not-null constraint
DETAIL:  Failing row contains (8, null, 28, null, null, 9, null, 134, 18, null, 268, null, 2, 2, inbound, customer, null, 5000.00, null, null, null, null, 2026-06-24 08:06:59.919284, 2026-06-24 08:06:59.919284, null, null, null, null, f, null, null, draft, null, null, null).

bad query: UPDATE "bus_presence" SET "last_poll" = '2026-06-24 08:12:20' WHERE id IN (1)
ERROR: could not serialize access due to concurrent update

bad query: INSERT INTO "withholding_tax_cert" ("company_id", "company_partner_id", "create_date", "create_uid", "partner_id", "ref_wht_cert_id", "state", "tax_payer", "write_date", "write_uid") VALUES (1, 1, '2026-06-24 08:17:23.002789', 2, 18, NULL, 'draft', 'withholding', '2026-06-24 08:17:23.002789', 2) RETURNING "id"
ERROR: null value in column "date" of relation "withholding_tax_cert" violates not-null constraint
DETAIL:  Failing row contains (2, null, null, null, null, 1, 18, 1, null, 2, 2, null, draft, null, withholding, null, 2026-06-24 08:17:23.002789, 2026-06-24 08:17:23.002789).

bad query: INSERT INTO "withholding_tax_cert" ("company_id", "company_partner_id", "create_date", "create_uid", "partner_id", "ref_wht_cert_id", "state", "tax_payer", "write_date", "write_uid") VALUES (1, 1, '2026-06-24 08:20:01.956706', 2, 18, NULL, 'draft', 'withholding', '2026-06-24 08:20:01.956706', 2) RETURNING "id"
ERROR: null value in column "date" of relation "withholding_tax_cert" violates not-null constraint
DETAIL:  Failing row contains (3, null, null, null, null, 1, 18, 1, null, 2, 2, null, draft, null, withholding, null, 2026-06-24 08:20:01.956706, 2026-06-24 08:20:01.956706).