Crazy Error

Started by ZappAabout 19 years ago4 messagesgeneral
Jump to latest
#1ZappA
thezappa@gmail.com

Hey..

First .. I´m sorry for my english! ..

Well, I have a problem with Postgres 7.4.

It´s very very crazy, this error!...

I have a problem with a command of insert. And this problem is resulting in
a error Panic! . (I will put the error below).

The more problem is that I have two insert equals, only change one
information, and a the result is OK, and the other is not OK.

Inserts:
OK:
insert into provisioning.t_usuario (
cd_usuario,msisdn,cd_operadora,tp_plano,st_usuario,ds_modelo ) values
(nextval('provisioning.s01_usuario'),'555584016386','61','PRE','0','' )

NOK
insert into provisioning.t_usuario (
cd_usuario,msisdn,cd_operadora,tp_plano,st_usuario,ds_modelo ) values
(nextval('provisioning.s01_usuario'),'556184000828','61','PRE','0','' )

In the secund, happen this error in log of postgres:

Jan 29 11:40:59 mw-db2 postgres[31921]: [6-1] PANIC: right sibling's
left-link doesn't match
Jan 29 11:40:59 mw-db2 postgres[31921]: [6-2] STATEMENT: insert into
provisioning.t_usuario (
cd_usuario,msisdn,cd_operadora,tp_plano,st_usuario,ds_modelo ) values (
Jan 29 11:40:59 mw-db2 postgres[31921]: [6-3] nextval('
provisioning.s01_usuario'),'556184000828','61','PRE','0','' )
Jan 29 11:40:59 mw-db2 postgres[6100]: [5-1] LOG: server process (PID
31921) was terminated by signal 6
Jan 29 11:40:59 mw-db2 postgres[6100]: [6-1] LOG: terminating any other
active server processes
Jan 29 11:40:59 mw-db2 postgres[5395]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32631]: [7-1] WARNING: of another server
process
Jan 29 11:40:59 mw-db2 postgres[651]: [5-1] WARNING: terminating connection
because of crash of another serterminating connection because of crash ver
process
Jan 29 11:40:59 mw-db2 postgres[5395]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32631]: [7-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[651]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[5395]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32631]: [7-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[651]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[5395]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32631]: [7-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[4537]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32632]: [7-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32506]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32384]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32509]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32508]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[31925]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[31924]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32507]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[32383]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[31920]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[31799]: [5-1] WARNING: terminating
connection because of crash of another server process
Jan 29 11:40:59 mw-db2 postgres[651]: [5-4] HINT: In a moment you should be
able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[4537]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32632]: [7-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32506]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32384]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32509]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32508]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[31925]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[31924]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32507]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[32383]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[31920]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[31799]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and exit,
because another server
Jan 29 11:40:59 mw-db2 postgres[4537]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32632]: [7-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32506]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32384]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32509]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32508]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[31925]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[31924]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32507]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[32383]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[31920]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[31799]: [5-3] process exited abnormally and
possibly corrupted shared memory.
Jan 29 11:40:59 mw-db2 postgres[4537]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32632]: [7-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32506]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32384]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32509]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32508]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[31925]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[31924]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32507]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[32383]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[31920]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[31799]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Jan 29 11:40:59 mw-db2 postgres[6100]: [7-1] LOG: all server processes
terminated; reinitializing
Jan 29 11:40:59 mw-db2 postgres[6706]: [8-1] LOG: database system was
interrupted at 2007-01-29 11:38:16 BRDT
Jan 29 11:40:59 mw-db2 postgres[6706]: [9-1] LOG: checkpoint record is at
30/A0633008
Jan 29 11:40:59 mw-db2 postgres[6706]: [10-1] LOG: redo record is at
30/A0633008; undo record is at 0/0; shutdown FALSE
Jan 29 11:40:59 mw-db2 postgres[6706]: [11-1] LOG: next transaction ID:
590689926; next OID: 49672068
Jan 29 11:40:59 mw-db2 postgres[6706]: [12-1] LOG: database system was not
properly shut down; automatic recovery in progress
Jan 29 11:40:59 mw-db2 postgres[6706]: [13-1] LOG: redo starts at
30/A0633048
Jan 29 11:40:59 mw-db2 postgres[6706]: [14-1] LOG: record with zero length
at 30/A06BB3D8
Jan 29 11:40:59 mw-db2 postgres[6706]: [15-1] LOG: redo done at 30/A06BB3B4
Jan 29 11:41:01 mw-db2 postgres[6706]: [16-1] LOG: database system is ready

both are only examples, bacause is having many error like these!

I thank the help a lot.

--
ZappA
Msn: tiagozappa@hotmail.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: ZappA (#1)
Re: Crazy Error

ZappA <thezappa@gmail.com> writes:

Well, I have a problem with Postgres 7.4.

7.4.what?

Jan 29 11:40:59 mw-db2 postgres[31921]: [6-1] PANIC: right sibling's
left-link doesn't match

You've got a corrupted index --- try REINDEXing that table. And
consider updating to a newer Postgres, if it's less than 7.4.15.

regards, tom lane

#3ZappA
thezappa@gmail.com
In reply to: ZappA (#1)
Re: Crazy Error

Hi again ..

My PostgreSQL version is 7.4.1, and I performed a Reindex and the problem
still remains.

due to our system configuration, we cannot Upgrade it. (cluster
environment).

help is very appreciated.

Thanks

Zappa

On 1/29/07, ZappA <thezappa@gmail.com> wrote:

Thanks ..

My PostgreSQL version is 7.4.1, and I performed a Reindex and the problem
still remains.

due to our system configuration, we cannot Upgrade it. (cluster
environment).

his help be appreciated.

Thanks

Zappa

On 1/29/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

ZappA <thezappa@gmail.com> writes:

Well, I have a problem with Postgres 7.4.

7.4.what?

Jan 29 11:40:59 mw-db2 postgres[31921]: [6-1] PANIC: right sibling's
left-link doesn't match

You've got a corrupted index --- try REINDEXing that table. And
consider updating to a newer Postgres, if it's less than 7.4.15.

regards, tom lane

--
ZappA
Curitiba - Pr
VN750 - Ninfa
Msn: tiagozappa@hotmail.com
"Sic vis pacem para bellum"

--
ZappA
Curitiba - Pr
VN750 - Ninfa
Msn: tiagozappa@hotmail.com
"Sic vis pacem para bellum"

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: ZappA (#3)
Re: Crazy Error

ZappA <thezappa@gmail.com> writes:

My PostgreSQL version is 7.4.1, and I performed a Reindex and the problem
still remains.

You must've reindexed the wrong thing then.

due to our system configuration, we cannot Upgrade it. (cluster
environment).

This approach to system management is seriously FUBAR. Read the
release notes for the 7.4.x series, and consider figuring out how
to update before any of those bugs bite you (or should I say,
before any of the *other* ones bite you...)

http://developer.postgresql.org/pgdocs/postgres/release.html

regards, tom lane