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: &

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: [

Postgresql 13.7 hangs down

2022-07-04 Thread Bogdan Siara
Hi all, I have a postgresql cluster (13.7) with two nodes (master,slave) compiled in docker (alpine 3.15) with flags: ./configure --prefix=${PG_DIR} --exec-prefix=${PG_DIR} --enable-integer-datetimes --enable-thread-safety --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432