Обсуждение: 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