Обсуждение: Proglems with 7.2.1
Hello.
We recently moved to PostgreSQL 7.2.1 and are now having a problem with just
normal inserts. The following query
INSERT INTO employee ("employeeid","sales_y_n","dataentry_y_n",
"firstname","lastname","systemname","password") values
('X','True','True','TEST','TEST','','X');
Produces the following debug information. Can anyone help me with this? The
signal 11 looks pretty bad.
DEBUG: server process (pid 23307) was terminated by signal 11
DEBUG: terminating any other active server processes
DEBUG: all server processes terminated; reinitializing shared memory and
semaphores
DEBUG: database system was interrupted at 2002-08-08 16:15:48 PDT
DEBUG: checkpoint record is at 2/C30A416C
DEBUG: redo record is at 2/C30A416C; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 38682; next oid: 69992620
DEBUG: database system was not properly shut down; automatic recovery in
progress
FATAL 1: The database system is starting up
DEBUG: redo starts at 2/C30A41AC
DEBUG: ReadRecord: record with zero length at 2/C30AC3CC
DEBUG: redo done at 2/C30AA374
DEBUG: database system is ready
Thanks!
-James
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
jamesk@everbase.net
541.488.0801
James, I'm a novice myself, so please excuse my ignorance.
What is the type o your 'employeeid' column? I would guess that its
probably numeric, but you seem to be trying to insert a char value ('X')
into it.
Still, this should not terminate your server.
What platform are your running on?
Is this insert done via psql or pgadmin?
Is postmaster actually dead after you get the error below?
Rgs,
Aurangzeb
On Thu, 8 Aug 2002, James Kelty wrote:
:Hello.
:
:We recently moved to PostgreSQL 7.2.1 and are now having a problem with just
:normal inserts. The following query
:INSERT INTO employee ("employeeid","sales_y_n","dataentry_y_n",
:"firstname","lastname","systemname","password") values
:('X','True','True','TEST','TEST','','X');
:
:Produces the following debug information. Can anyone help me with this? The
:signal 11 looks pretty bad.
:
:
:DEBUG: server process (pid 23307) was terminated by signal 11
:DEBUG: terminating any other active server processes
:DEBUG: all server processes terminated; reinitializing shared memory and
:semaphores
:DEBUG: database system was interrupted at 2002-08-08 16:15:48 PDT
:DEBUG: checkpoint record is at 2/C30A416C
:DEBUG: redo record is at 2/C30A416C; undo record is at 0/0; shutdown TRUE
:DEBUG: next transaction id: 38682; next oid: 69992620
:DEBUG: database system was not properly shut down; automatic recovery in
:progress
:FATAL 1: The database system is starting up
:DEBUG: redo starts at 2/C30A41AC
:DEBUG: ReadRecord: record with zero length at 2/C30AC3CC
:DEBUG: redo done at 2/C30AA374
:DEBUG: database system is ready
:
:
:Thanks!
:
:-James
:
:James Kelty
:Director of Operations
:Everbase Systems, LLC
:624 A Street
:Ashland, OR 97520
:jamesk@everbase.net
:541.488.0801
:
:
:---------------------------(end of broadcast)---------------------------
:TIP 3: if posting/reading through Usenet, please send an appropriate
:subscribe-nomail command to majordomo@postgresql.org so that your
:message can get through to the mailing list cleanly
:
--
Aurangzeb M. Agha | Email : aagha@bigfoot.com
| Home : +3 010 8959.558
34 Nafsika St. | Direct: +3 010 8995.875
Voula 16673 | Mobile: TBD
Greece | Voice : 415 412 4234 (US Only)
| e-Fax : 978 246.0770
PGP ID: 0x68B3A763 |
"Those who would give up essential liberty to purchase a little
temporary safety deserve neither liberty nor safety."
- Benjamin Franklin
Thanks to everyone who replied, but I think I figured out the problem. We
had triggers on each table that would start a function written in C. This, I
believe, is where the problem occured, and would explain the sigsev.
Thanks again!
-James
-----Original Message-----
From: Aurangzeb M. Agha [mailto:aagha@bigfoot.com]
Sent: Thursday, August 08, 2002 3:00 PM
To: James Kelty
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Proglems with 7.2.1
James, I'm a novice myself, so please excuse my ignorance.
What is the type o your 'employeeid' column? I would guess that its
probably numeric, but you seem to be trying to insert a char value ('X')
into it.
Still, this should not terminate your server.
What platform are your running on?
Is this insert done via psql or pgadmin?
Is postmaster actually dead after you get the error below?
Rgs,
Aurangzeb
On Thu, 8 Aug 2002, James Kelty wrote:
:Hello.
:
:We recently moved to PostgreSQL 7.2.1 and are now having a problem with
just
:normal inserts. The following query
:INSERT INTO employee ("employeeid","sales_y_n","dataentry_y_n",
:"firstname","lastname","systemname","password") values
:('X','True','True','TEST','TEST','','X');
:
:Produces the following debug information. Can anyone help me with this? The
:signal 11 looks pretty bad.
:
:
:DEBUG: server process (pid 23307) was terminated by signal 11
:DEBUG: terminating any other active server processes
:DEBUG: all server processes terminated; reinitializing shared memory and
:semaphores
:DEBUG: database system was interrupted at 2002-08-08 16:15:48 PDT
:DEBUG: checkpoint record is at 2/C30A416C
:DEBUG: redo record is at 2/C30A416C; undo record is at 0/0; shutdown TRUE
:DEBUG: next transaction id: 38682; next oid: 69992620
:DEBUG: database system was not properly shut down; automatic recovery in
:progress
:FATAL 1: The database system is starting up
:DEBUG: redo starts at 2/C30A41AC
:DEBUG: ReadRecord: record with zero length at 2/C30AC3CC
:DEBUG: redo done at 2/C30AA374
:DEBUG: database system is ready
:
:
:Thanks!
:
:-James
:
:James Kelty
:Director of Operations
:Everbase Systems, LLC
:624 A Street
:Ashland, OR 97520
:jamesk@everbase.net
:541.488.0801
:
:
:---------------------------(end of broadcast)---------------------------
:TIP 3: if posting/reading through Usenet, please send an appropriate
:subscribe-nomail command to majordomo@postgresql.org so that your
:message can get through to the mailing list cleanly
:
--
Aurangzeb M. Agha | Email : aagha@bigfoot.com
| Home : +3 010 8959.558
34 Nafsika St. | Direct: +3 010 8995.875
Voula 16673 | Mobile: TBD
Greece | Voice : 415 412 4234 (US Only)
| e-Fax : 978 246.0770
PGP ID: 0x68B3A763 |
"Those who would give up essential liberty to purchase a little
temporary safety deserve neither liberty nor safety."
- Benjamin Franklin