Skip site navigation (1) Skip section navigation (2)

panic? return of the btree-bug

From: "Pieter Jansen" <pjansen(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: panic? return of the btree-bug
Date: 2008-02-26 19:20:05
Message-ID: ab948b060802261120m7b789680pc92c3f3de87c6486@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

2008-02-25 17:07:28 CET PANIC:  failed to add item to the right
sibling for "ttrss_user_entries_feed_id"
2008-02-25 17:07:28 CET STATEMENT:  INSERT INTO ttrss_user_entries

 (ref_id, owner_uid, feed_id, unread, last_read, marked, published)
                                                                VALUES
('7135', '2', '18', true,

 NULL, false, false)
2008-02-25 17:07:28 CET LOG:  server process (PID 29709) was
terminated by signal 6
2008-02-25 17:07:28 CET LOG:  terminating any other active server processes
2008-02-25 17:07:28 CET LOG:  all server processes terminated; reinitializing
2008-02-25 17:07:28 CET LOG:  database system was interrupted at
2008-02-25 17:05:30 CET
2008-02-25 17:07:28 CET LOG:  checkpoint record is at 1/3C5A4FD8
2008-02-25 17:07:28 CET LOG:  redo record is at 1/3C5A4FD8; undo
record is at 0/0; shutdown FALSE
2008-02-25 17:07:28 CET LOG:  next transaction ID: 0/6130996; next OID: 42761
2008-02-25 17:07:28 CET LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2008-02-25 17:07:28 CET LOG:  database system was not properly shut
down; automatic recovery in progress
2008-02-25 17:07:28 CET LOG:  redo starts at 1/3C5A5028
2008-02-25 17:07:28 CET LOG:  record with zero length at 1/3C641230
2008-02-25 17:07:28 CET LOG:  redo done at 1/3C641200
2008-02-25 17:07:28 CET LOG:  database system is ready

There is 1 process updating the ttrss_user_entries table rather often
(every 10 seconds +/- 100 queries).

There are several client processes (perl cgi) with their own dbi
connections to the database. I am unaware how many parallel users I
have.

Version: PostgreSQL 8.2.5 on x86_64-pc-linux-gnu, compiled by GCC cc
(GCC) 4.1.3 20070831 (prerelease) (Ubuntu 4.1.2-16ubuntu1)

Vacuum cron entry:
2 0,5,10,15,20 * * 1-6 root if [ -x /usr/sbin/pg_maintenance ]; then
/usr/sbin/pg_maintenance --analyze >/dev/null; fi


What information is needed to further investigate this?

Kind regards,
Pieter Jansen
ICTree

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-02-26 22:07:56
Subject: Re: panic? return of the btree-bug
Previous:From: Peter EisentrautDate: 2008-02-26 18:01:51
Subject: Re: BUG #3968: ssh tunnel instructions could use improvement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group