Re: Postgrsql blocked for more than 120 s

2023-07-20 Thread Bogdan Siara
Hi, Problem was on disk io starvation, storage migration to more iops resolve the problem. Regards BS pon., 17 lip 2023 o 07:40 Bogdan Siara napisaƂ(a): > Hi, I have a problem with my slave postgresql instance. During normal > operations databaseis locked and in syslog I see stacktrace: > > Jul

Postgrsql blocked for more than 120 s

2023-07-16 Thread Bogdan Siara
Hi, I have a problem with my slave postgresql instance. During normal operations databaseis locked and in syslog I see stacktrace: Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.289110] INFO: task postgres:1172 blocked for more than 120 seconds. Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [