Crazy Error

From: ZappA <thezappa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Crazy Error
Date: 2007-01-29 16:38:42
Message-ID: 182cd2ba0701290838g5191f04atfc86b45968709852@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)hotmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-29 16:46:19 Re: convert(USING utf8_to_iso_8859_15) on Windows
Previous Message Bruno Wolff III 2007-01-29 16:17:19 Re: Load balancing across disks