currently we are struggeling with some performance issues.
while looking in the Status of the PostgresDB we see many lines showing accesssharelock Problems.
any ideas about such "AccessShareLock" Problems regarding Odd and Postgresql?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2
Replies
1349
Views
some lines that we see in the activity-monitor:
164046 odoonewDB 1699474 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+0 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printin
164046 odoonewDB 1688397 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonew22 1688396 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1687363 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1633993 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1688105 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1688104 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1687019 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1688392 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonew22 1688391 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
164046 odoonewDB 1687349 odoo 3/95226 AccessShareLock Yes 2020-10-21 08:13:20+02 SELECT "printing_job"."id" as "id","printing_job"."time_at_creation" as "time_at_creation","printing_job"."printer_id" as "printer_id","printing_job"."time_at_processing" as "time_at_processing","printing_job"."create_date" as "create_date","printing
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
Can you post more information such as the logs that you see? The AccessShareLock will usually give you more information if you use a tool such as pg-activity.