Re: pqReadData() -- backend closed the channel unexpectedly
От | Buddy Lee Haystack |
---|---|
Тема | Re: pqReadData() -- backend closed the channel unexpectedly |
Дата | |
Msg-id | 39C8328A.8612B221@email.rentzone.org обсуждение исходный текст |
Ответ на | Re: pqReadData() -- backend closed the channel unexpectedly (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: pqReadData() -- backend closed the channel unexpectedly
Re: pqReadData() -- backend closed the channel unexpectedly |
Список | pgsql-general |
Thanks for the quick response! Here they are, but they seem as vague as the Apache error logs -to me anyway... FindExec: found "/usr/bin/postgres" using argv[0] /usr/bin/postmaster: BackendStartup: pid 886 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand /usr/bin/postmaster: BackendStartup: pid 887 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand /usr/bin/postmaster: BackendStartup: pid 888 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand /usr/bin/postmaster: BackendStartup: pid 889 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand /usr/bin/postmaster: BackendStartup: pid 890 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessQuery CommitTransactionCommand StartTransactionCommand ProcessQuery /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 888 exited with status 139 /usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 890 /usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 889 /usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 887 NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. /usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 886 NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. /usr/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores shmem_exit(0) [#0] NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. /usr/bin/postmaster: CleanupProc: pid 890 exited with status 0 /usr/bin/postmaster: CleanupProc: pid 889 exited with status 0 /usr/bin/postmaster: CleanupProc: pid 887 exited with status 0 /usr/bin/postmaster: CleanupProc: pid 886 exited with status 0 /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: BackendStartup: pid 901 user nobody db rzone socket 4 FindExec: found "/usr/bin/postgres" using argv[0] started: host=localhost user=nobody database=rzone InitPostgres reset_client_encoding().. reset_client_encoding() done. StartTransactionCommand ProcessUtility CommitTransactionCommand StartTransactionCommand ProcessQuery /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 901 exited with status 139 /usr/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores shmem_exit(0) [#0] Stephan Szabo wrote: > Best bet is to start by getting the end of the postmaster logs. That'll > probably have more information about immediate causes. -- BLH www.RentZone.org
В списке pgsql-general по дате отправления:
Следующее
От: Stephan SzaboДата:
Сообщение: Re: pqReadData() -- backend closed the channel unexpectedly