causing crash - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-03-18 11:02:11 | Background writer not much active (Motog Plus)
crashed with the error checkpointer was killed by signal 9. When checked system logs we found it was OOM issue. We have postgreSQL on independent node with 32GB RAM, multiple DBs are there witl multiple
Mailing lists >> pgsql-admin >> Thread
2025-02-19 19:07:43 | Re: Does export operation cancel SQLs? (Jeff Janes)
crash of another server process". So not a "user request". Most likely some client (or client library) has an internal timer and cancels its own query after a certain amount of time. I know that
Mailing lists >> pgsql-admin >> Thread
2025-02-07 12:38:06 | etcd failed on master node (daur exp)
Caused by NewConnectionError(' : Failed to establish a new connection: [Errno 111] Connection refused'))") ^C =========================================================== But on replica output is ok and like it: root@stb-pgsql02-uv02:/home/ansible# patronictl -c /etc/patroni/patroni.yml list + Cluster: patroni-cluster
Mailing lists >> pgsql-admin >> Thread
2024-08-15 10:36:07 | Re: LIsten Errror (Asad Ali)
cause corruption in the transaction status files. 4. *Improper Database Shutdowns:* Unexpected shutdowns or crashes
Mailing lists >> pgsql-admin >> Thread
2024-07-19 07:03:12 | Re: wal seams to be corrupted (Laurenz Albe)
crashes because the disk is full. You need to determine the cause of the problem
Mailing lists >> pgsql-admin >> Thread
2024-07-16 00:58:43 | Re: filesystem full during vacuum - space recovery issues (Laurenz Albe)
crash that was caused by the full file system. Did you run "pg_resetwal"? If yes, that
Mailing lists >> pgsql-admin >> Thread
2024-06-09 19:35:17 | Re: PostgreSQL Logical replication FROM RDS TO EC2 (Kashif Zeeshan)
cause of the error.
On Mon, Jun 10, 2024 at 12:25 AM Sbob
Mailing lists >> pgsql-admin >> Thread
2024-02-02 11:25:12 | Postgres 16 slow "fast" shutdown when using streaming replication (Stefan Kohlhauser)
crash | off | configuration file shared_buffers | 128MB | configuration file ssl | on | configuration file ssl_ca_file | root.crt | configuration file ssl_cert_file | server.crt | configuration file ssl_ciphers | HIGH:MEDIUM:+3DES:!aNULL | configuration
Mailing lists >> pgsql-admin >> Thread >> Search in thread (6)
2023-09-27 13:57:22 | Re: Terminating connection because of crash of another server process (Deo Felix)
crashes. Look at the PostgreSQL log to determine the cause of the crash and see that
Mailing lists >> pgsql-admin >> Thread
2023-09-24 18:15:28 | Re: Handling idle connections (Rui DeSousa)
crashes, people unplugging the network cable without logging out, firewall dropping the connection without sending reset packets, etc). 3. Setup up a cron job to kill long idle sessions from non applications accounts/networks. Killing idle
Mailing lists >> pgsql-admin >> Thread
2023-05-02 01:29:50 | Re: pg_dump why no indicator of completion (Tim)
cause your WAL folder to fill up), then its time to learn some more mature tools. pg-dump made sense maybe a decade ago. As recommended above, nowadays people use *pgbackrest* and *pgbarman*. and they
Mailing lists >> pgsql-admin >> Thread
2023-04-26 13:28:40 | pgBouncer - got packet 'D' from server when not linked WARNING messages (fatih abztn)
crashed? - FIXME: query end, but query_start == 0 FIXME: transaction end, but xact_start == 0 and our environment: PgBouncer 1.17.0 libevent 2.0.21-stable adns: evdns2 tls: OpenSSL 1.0.2k-fips 26 Jan 2017 mode
Mailing lists >> pgsql-admin >> Thread
2022-09-13 11:11:14 | Re: Error when execute insert/update (Alvaro Herrera)
cause we've seen is leftover temp tables: autovacuum cannot process them because temp tables cannot be read/written by sessions other than the one that created them. What you can do in this case
Mailing lists >> pgsql-admin >> Thread
2022-06-14 16:12:08 | Re: Xmax precedes relation freeze threshold errors (Álvaro Herrera)
crash at just that time, or a NFS failure). This would cause these tuples, which
Mailing lists >> pgsql-admin >> Thread
2022-01-18 04:30:13 | Re: Large number of partitions of a table (Tom Lane)
crash and cluster restart. On other platforms, you will likely end up in swap purgatory, which is actually worse because it destroys the whole platform's responsiveness and there may not be any easy