Re: [GENERAL] DB terminating [on Windows]
Looks like your typical backend crash of PID 9644, causing a typical restart. So something broke the backend - I'd start by trying to figure that out. Clearly, it's failing to restart after the crash, due to shared memory issues. At the risk of repeating, this often happens with antivirus on the machine... //Magnus 2009/11/18 Richard Broersma richard.broer...@gmail.com: Magnus, any thoughts? On Wed, Nov 18, 2009 at 9:53 AM, Scott Felt scott.f...@gmail.com wrote: Hello. I have been having an issue with a database. The logs consistently show this: 2009-11-17 16:03:55 ESTLOG: 0: server process (PID 9644) exited with exit code 128 2009-11-17 16:03:55 ESTLOCATION: LogChildExit, .\src\backend\postmaster\postmaster.c:2705 2009-11-17 16:03:55 ESTLOG: 0: terminating any other active server processes 2009-11-17 16:03:55 ESTLOCATION: HandleChildCrash, .\src\backend\postmaster\postmaster.c:2552 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to
Re: [GENERAL] DB terminating [on Windows]
Magnus, any thoughts? On Wed, Nov 18, 2009 at 9:53 AM, Scott Felt scott.f...@gmail.com wrote: Hello. I have been having an issue with a database. The logs consistently show this: 2009-11-17 16:03:55 ESTLOG: 0: server process (PID 9644) exited with exit code 128 2009-11-17 16:03:55 ESTLOCATION: LogChildExit, .\src\backend\postmaster\postmaster.c:2705 2009-11-17 16:03:55 ESTLOG: 0: terminating any other active server processes 2009-11-17 16:03:55 ESTLOCATION: HandleChildCrash, .\src\backend\postmaster\postmaster.c:2552 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-11-17 16:03:55 ESTHINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-11-17 16:03:55 ESTLOCATION: quickdie, .\src\backend\tcop\postgres.c:2495 2009-11-17 16:03:55 ESTWARNING: 57P02: terminating connection because of crash of another server process 2009-11-17 16:03:55 ESTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another