Re: [BUGS] BUG #4458: Website slow, inaccessible
http://www.postgresql.org/about/news.1013 Amen. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #3591: autovacuum crash
The following bug has been logged online: Bug reference: 3591 Logged by: Ben Kim Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Solaris 8 Description:autovacuum crash Details: The server crashed suddenly the second time since two days ago. ulimit is unlimited, but I see no core file under the postgresql root directory. = 6780 2007-08-31 14:01:46 CDT LOG: autovacuum process (PID 6379) was terminated by signal 11 6780 2007-08-31 14:01:46 CDT LOG: terminating any other active server processes user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 WARNING: terminating connection because of crash of another server process user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 DETAIL: 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. user db1 [local] 6375 2007-08-31 14:01:46 CDT idle 0 HINT: In a moment you should be able to reconnect to the database and repeat your command. (repeated for every database) ... 6780 2007-08-31 14:01:47 CDT LOG: all server processes terminated; reinitializing 6381 2007-08-31 14:01:47 CDT LOG: database system was interrupted at 2007-08-31 14:01:35 CDT 6381 2007-08-31 14:01:47 CDT LOG: checkpoint record is at F/5A51F588 6381 2007-08-31 14:01:47 CDT LOG: redo record is at F/5A51F588; undo record is at 0/0; shutdown FALSE 6381 2007-08-31 14:01:47 CDT LOG: next transaction ID: 140043601; next OID: 25139832 6381 2007-08-31 14:01:47 CDT LOG: next MultiXactId: 411; next MultiXactOffset: 897 6381 2007-08-31 14:01:47 CDT LOG: database system was not properly shut down; automatic recovery in progress 6381 2007-08-31 14:01:47 CDT LOG: redo starts at F/5A51F5D0 6381 2007-08-31 14:01:47 CDT LOG: record with zero length at F/5A525C18 6381 2007-08-31 14:01:47 CDT LOG: redo done at F/5A525BE8 6381 2007-08-31 14:01:47 CDT LOG: database system is ready 6381 2007-08-31 14:01:47 CDT LOG: transaction ID wrap limit is 1206535619, limited by database db3 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] BUG #3591: autovacuum crash
Thanks. We upgraded the server. On Fri, 31 Aug 2007, Alvaro Herrera wrote: Ben Kim wrote: The following bug has been logged online: Bug reference: 3591 Logged by: Ben Kim Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Solaris 8 Description:autovacuum crash Details: The server crashed suddenly the second time since two days ago. ulimit is unlimited, but I see no core file under the postgresql root directory. = 6780 2007-08-31 14:01:46 CDT LOG: autovacuum process (PID 6379) was terminated by signal 11 This is a crash all right, but I think we fixed a certain number of bugs after 8.1.0 was released. Please install 8.1.9, and if it still crashes, report again. (We'll be wanting to see stack traces at that point, so please make sure you are using a debug-enabled build, and a non-zero coresize ulimit setting). FWIW the core files should be stored in the data directories (PGDATA). -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. Regards, Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
