Hi list, I'm running postgresql 8.0.1 on FreeBSD 4.11-STABLE, the machine is and AMD Sempron 2.2, 1GB Ram..
I use postgresql as database for dspam, an spam classification program. This database have and moderated use, on averange 20 simultaneous conections executing relative big queries using "in" clausule. Watching postgresql logs I see the following messages ocurs a lot of times in a day: May 3 06:58:44 e-filter postgres[250]: [21-1] LOG: server process (PID 59608) was terminated by signal 10 May 3 06:58:44 e-filter postgres[250]: [22-1] LOG: terminating any other active server processes May 3 06:58:44 e-filter postgres[59605]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59605]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59605]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59605]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59607]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59607]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59607]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59607]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59606]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59606]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59606]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59606]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59626]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59626]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59626]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59626]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59628]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59629]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59629]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59629]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59629]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59628]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59628]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59628]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59609]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59609]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59609]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59609]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:44 e-filter postgres[59627]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:44 e-filter postgres[59627]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:44 e-filter postgres[59627]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:44 e-filter postgres[59627]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:45 e-filter postgres[69093]: [23-1] WARNING: terminating connection because of crash of another server process May 3 06:58:45 e-filter postgres[69093]: [23-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:45 e-filter postgres[69093]: [23-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:45 e-filter postgres[69093]: [23-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:45 e-filter postgres[59620]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59620]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59620]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59620]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59619]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59619]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59619]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59619]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59624]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59624]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59624]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59624]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59623]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59623]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59623]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59623]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59625]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59625]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59625]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59625]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59622]: [21-1] WARNING: terminating connection because of crash of another server process May 3 06:58:46 e-filter postgres[59622]: [21-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 06:58:46 e-filter postgres[59622]: [21-3] process exited abnormally and possibly corrupted shared memory. May 3 06:58:46 e-filter postgres[59622]: [21-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 06:58:46 e-filter postgres[59621]: [22-1] WARNING: terminating connection because of crash of another server process May 3 06:58:49 e-filter postgres[250]: [23-1] LOG: all server processes terminated; reinitializing May 3 06:58:51 e-filter postgres[13478]: [24-1] LOG: database system was interrupted at 2005-05-03 06:58:16 EST May 3 06:58:51 e-filter postgres[13478]: [25-1] LOG: checkpoint record is at 14/99F69378 May 3 06:58:51 e-filter postgres[13478]: [26-1] LOG: redo record is at 14/99F69378; undo record is at 0/0; shutdown FALSE May 3 06:58:51 e-filter postgres[13478]: [27-1] LOG: next transaction ID: 3639687; next OID: 388415 May 3 06:58:51 e-filter postgres[13478]: [28-1] LOG: database system was not properly shut down; automatic recovery in progress May 3 06:58:51 e-filter postgres[13478]: [29-1] LOG: redo starts at 14/99F693B4 May 3 06:58:53 e-filter postgres[13478]: [30-1] LOG: record with zero length at 14/9AE223F0 May 3 06:58:53 e-filter postgres[13478]: [31-1] LOG: redo done at 14/9AE223C8 May 3 06:58:54 e-filter postgres[13484]: [24-1] FATAL: the database system is starting up May 3 06:58:54 e-filter postgres[13485]: [24-1] FATAL: the database system is starting up May 3 06:58:55 e-filter postgres[13488]: [24-1] FATAL: the database system is starting up May 3 06:58:57 e-filter postgres[13478]: [32-1] LOG: database system is ready and some time latter its ocur again: May 3 09:59:38 e-filter postgres[250]: [24-1] LOG: server process (PID 34743) was terminated by signal 10 May 3 09:59:38 e-filter postgres[250]: [25-1] LOG: terminating any other active server processes May 3 09:59:38 e-filter postgres[35215]: [24-1] WARNING: terminating connection because of crash of another server process May 3 09:59:38 e-filter postgres[35215]: [24-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 09:59:38 e-filter postgres[35215]: [24-3] process exited abnormally and possibly corrupted shared memory. May 3 09:59:38 e-filter postgres[35215]: [24-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. May 3 09:59:38 e-filter postgres[34744]: [24-1] WARNING: terminating connection because of crash of another server process May 3 09:59:38 e-filter postgres[34744]: [24-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server May 3 09:59:38 e-filter postgres[33592]: [24-1] WARNING: terminating connection because of crash of another server process May 3 09:59:38 e-filter postgres[34744]: [24-3] process exited abnormally and possibly corrupted shared memory. This is my postgresql.conf max_connections = 70 superuser_reserved_connections = 2 shared_buffers = 32768 work_mem = 10240 maintenance_work_mem = 51200 fsync = true checkpoint_segments = 8 effective_cache_size = 100000 log_destination = 'syslog' silent_mode = true lc_messages = 'C' lc_monetary = 'C' lc_numeric = 'C' lc_time = 'C' and the shared memory configuration: kern.ipc.shmmax: 700000000 kern.ipc.shmmin: 1 kern.ipc.shmmni: 192 kern.ipc.shmseg: 256 kern.ipc.shmall: 700000000 I already asked this in postgresql-general list and no solutions was reach, the people from there say that is not a postgresql problem, that should be and hardware or SO problem..... Any ideas ? Any thoughts ? Best Regards, Alexandre _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
