Times Reported Most Frequent Error / Event #1

x Hide

ERROR: could not obtain lock on row in relation "ir_cron"

Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=65 FOR UPDATE NOWAIT

Date: 2022-11-16 00:10:05

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

ERROR: could not serialize access due to concurrent update

Statement: UPDATE "bus_presence" SET "last_poll"='2022-11-16 00:00:29',"last_presence"='2022-11-16 00:00:29.448728' WHERE id IN (80)

Date: 2022-11-16 00:00:29

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

ERROR: could not receive data from client: Connection reset by peer

Date: 2022-11-16 02:53:52

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: could not serialize access due to concurrent delete

Statement: DELETE FROM ir_attachment WHERE id IN (67905)

Date: 2022-11-16 00:09:19

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: invalid input syntax for type integer: "False" at character 84

Statement: select sum(product_uom_qty) from stock_move where id > '148967' and sale_line_id = 'False' and id != '148967'

Date: 2022-11-16 14:27:35

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

FATAL: terminating connection due to administrator command

Context: while updating tuple (1246,7) in relation "stock_move_line"
Statement: UPDATE "stock_move_line" SET "qty_done"='1.00',"write_uid"=1018,"write_date"=(now() at time zone 'UTC') WHERE id IN (145775)

Date: 2022-11-16 20:30:46

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

ERROR: could not create unique index "vendor_account_master_unique_acc_no"

Detail: Key (account_number)=(426PO007) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)

Date: 2022-11-16 08:56:45

x Hide

Times Reported Most Frequent Error / Event #8

x Hide

ERROR: duplicate key value violates unique constraint "fleet_vehicle_vehicle_unit_no_driver_id_unique"

Detail: Key (vehicle_unit_no, driver_id)=(000, 34094) already exists.
Statement: INSERT INTO "fleet_vehicle" ("id", "create_uid", "create_date", "write_uid", "write_date", "acquisition_date", "active", "brand_id", "car_value", "co2", "color", "company_id", "description", "doors", "driver_id", "first_contract_date", "fuel_type", "future_driver_id", "horsepower", "horsepower_tax", "license_plate", "location", "manager_id", "model_id", "model_vehicle_type", "model_year", "name", "net_car_value", "next_assignation_date", "odometer_unit", "power", "residual_value", "seats", "state_id", "transmission", "vehicle_unit_no", "vin_sn") VALUES (nextval('fleet_vehicle_id_seq'), 953, (now() at time zone 'UTC'), 953, (now() at time zone 'UTC'), '2022-11-16', true, 105, 0.0, 0.0, NULL, 1, NULL, 5, 34094, '2022-11-16', NULL, NULL, 0, 0.0, 'pjd-5412', NULL, 2, 237, 22, NULL, 'for', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '000', NULL) RETURNING id

Date: 2022-11-16 13:13:52

ERROR: duplicate key value violates unique constraint "fleet_vehicle_vin_sn_unique"

Detail: Key (vin_sn)=(1FDGF5GY9KED44305) already exists.
Statement: INSERT INTO "fleet_vehicle" ("id", "create_uid", "create_date", "write_uid", "write_date", "acquisition_date", "active", "brand_id", "car_value", "co2", "color", "company_id", "description", "doors", "driver_id", "first_contract_date", "fuel_type", "future_driver_id", "horsepower", "horsepower_tax", "license_plate", "location", "manager_id", "model_id", "model_vehicle_type", "model_year", "name", "net_car_value", "next_assignation_date", "odometer_unit", "power", "residual_value", "seats", "state_id", "transmission", "vehicle_unit_no", "vin_sn") VALUES (nextval('fleet_vehicle_id_seq'), 1010, (now() at time zone 'UTC'), 1010, (now() at time zone 'UTC'), '2022-11-16', true, 105, 0.0, 0.0, NULL, 1, NULL, 5, 43451, '2022-11-16', NULL, NULL, 0, 0.0, 'MT48735', NULL, 2, 168, 29, NULL, '1026', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '1026', '1FDGF5GY9KED44305') RETURNING id

Date: 2022-11-16 14:15:51

x Hide

Times Reported Most Frequent Error / Event #9

x Hide

WARNING: PID 2598624 is not a PostgreSQL server process

Date: 2022-11-16 20:31:40

x Hide

Times Reported Most Frequent Error / Event #10

x Hide

ERROR: null value in column "location_id" of relation "repair_order" violates not-null constraint

Detail: Failing row contains (593, null, WT-003277, null, 1.00, null, 43451, null, draft, null, null, null, 34, null, after_repair, null, null, null, null, 1010, 1, null, null, null, null, null, 1010, 2022-11-16 15:35:31.05756, 1010, 2022-11-16 15:35:31.05756, null, null, null, gearing_repair, 37, null, t, t, 2022-11-16, null, 1, null, null, null, null, null, null, null, 78, f, f, null, f, null, null, null, f, f, f, null, null, null, null).
Statement: INSERT INTO "repair_order" ("id", "create_uid", "create_date", "write_uid", "write_date", "branch_id", "cancel_order", "company_id", "handovered", "invoice_done", "invoice_method", "is_merged_invoiced", "locked_order", "moved_back_to_branch", "moved_to_gearing_shop", "name", "order_date", "partner_id", "payment_term_need_password", "pricelist_id", "product_qty", "repair_obtain", "repair_product_qty", "ship_via", "state", "user_id") VALUES (nextval('repair_order_id_seq'), 1010, (now() at time zone 'UTC'), 1010, (now() at time zone 'UTC'), 37, false, 1, false, false, 'after_repair', false, false, true, true, 'WT-003277', '2022-11-16', 43451, false, 34, '1.00', 'gearing_repair', 1.0, 78, 'draft', 1010) RETURNING id

Date: 2022-11-16 15:35:31

ERROR: null value in column "code" of relation "res_country_state" violates not-null constraint

Detail: Failing row contains (1401, 233, oh, null, 1027, 2022-11-16 18:44:52.488547, 1027, 2022-11-16 18:44:52.488547).
Statement: INSERT INTO "res_country_state" ("id", "create_uid", "create_date", "write_uid", "write_date", "country_id", "name") VALUES (nextval('res_country_state_id_seq'), 1027, (now() at time zone 'UTC'), 1027, (now() at time zone 'UTC'), 233, 'oh') RETURNING id

Date: 2022-11-16 18:44:52

x Hide

Times Reported Most Frequent Error / Event #11

x Hide

FATAL: role "ubuntu" does not exist

Date: 2022-11-16 13:31:10

x Hide

Times Reported Most Frequent Error / Event #12

x Hide

ERROR: syntax error at or near ")" at character 165

Statement: SELECT res_partner_id, calendar_event_id, count(1) FROM calendar_event_res_partner_rel WHERE res_partner_id IN () AND calendar_event_id IN (SELECT "calendar_event".id FROM "calendar_event" WHERE ("calendar_event"."active" = true) AND (("calendar_event"."user_id" = 1046) OR ("calendar_event"."show_as" = 'busy')) ORDER BY "calendar_event"."start" DESC ) GROUP BY res_partner_id, calendar_event_id

Date: 2022-11-16 20:07:45

x Hide

Times Reported Most Frequent Error / Event #13

x Hide

ERROR: deadlock detected at character 8

Detail: Process 2601579 waits for RowExclusiveLock on relation 44482 of database 65946; blocked by process 2603918. Process 2603918 waits for ShareLock on relation 42418 of database 65946; blocked by process 2601579. Process 2601579: UPDATE "product_product" SET "write_uid"=1005,"write_date"=(now() at time zone 'UTC') WHERE id IN (186700) Process 2603918: CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move(journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move(journal_id, state, payment_state, move_type, date);
Hint: See server log for query details.
Statement: UPDATE "product_product" SET "write_uid"=1005,"write_date"=(now() at time zone 'UTC') WHERE id IN (186700)

Date: 2022-11-16 17:19:12

x Hide

Times Reported Most Frequent Error / Event #14

x Hide

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: SELECT "res_lang"."id" as "id", "res_lang"."name" as "name", "res_lang"."code" as "code", "res_lang"."iso_code" as "iso_code", "res_lang"."url_code" as "url_code", "res_lang"."active" as "active", "res_lang"."direction" as "direction", "res_lang"."date_format" as "date_format", "res_lang"."time_format" as "time_format", "res_lang"."week_start" as "week_start", "res_lang"."grouping" as "grouping", "res_lang"."decimal_point" as "decimal_point", "res_lang"."thousands_sep" as "thousands_sep", "res_lang"."create_uid" as "create_uid", "res_lang"."create_date" as "create_date", "res_lang"."write_uid" as "write_uid", "res_lang"."write_date" as "write_date" FROM "res_lang" WHERE "res_lang".id IN (1)

Date: 2022-11-16 18:21:07

x Hide