simple query terminated by signal 11

From: "Thomas Chille" <thomas(dot)chille(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: simple query terminated by signal 11
Date: 2006-06-19 17:06:09
Message-ID: cad2de1c0606191006n26fa9adal733f7568e274a98e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List,

i run in to an error while dumping a db.

after investigating it, i found a possible corrupted table. but i am not sure.
and i dont know how i can repair it? could it be a harddrive error?

Here are the logs:

# all fine: SELECT * FROM hst_sales_report WHERE id = 5078866

[6208 / 2006-06-19 18:46:17 CEST]LOG: 00000: connection received:
host=[local] port=
[6208 / 2006-06-19 18:46:17 CEST]LOCATION: BackendRun, postmaster.c:2679
[6208 / 2006-06-19 18:46:17 CEST]LOG: 00000: connection authorized:
user=postgres database=backoffice_db
[6208 / 2006-06-19 18:46:17 CEST]LOCATION: BackendRun, postmaster.c:2751
[6208 / 2006-06-19 18:46:17 CEST]LOG: 00000: statement: SELECT * FROM
hst_sales_report WHERE id = 5078866
[6208 / 2006-06-19 18:46:17 CEST]LOCATION: pg_parse_query, postgres.c:526
[6208 / 2006-06-19 18:46:18 CEST]LOG: 00000: duration: 117.638 ms
[6208 / 2006-06-19 18:46:18 CEST]LOCATION: exec_simple_query, postgres.c:1076
[6208 / 2006-06-19 18:46:18 CEST]LOG: 00000: disconnection: session
time: 0:00:00.12 user=postgres database=backoffice_db host=[local]
port=
[6208 / 2006-06-19 18:46:18 CEST]LOCATION: log_disconnections, postgres.c:3447

# now the error: SELECT * FROM hst_sales_report WHERE id = 5078867

[6216 / 2006-06-19 18:46:23 CEST]LOG: 00000: connection received:
host=[local] port=
[6216 / 2006-06-19 18:46:23 CEST]LOCATION: BackendRun, postmaster.c:2679
[6216 / 2006-06-19 18:46:23 CEST]LOG: 00000: connection authorized:
user=postgres database=backoffice_db
[6216 / 2006-06-19 18:46:23 CEST]LOCATION: BackendRun, postmaster.c:2751
[6216 / 2006-06-19 18:46:23 CEST]LOG: 00000: statement: SELECT * FROM
hst_sales_report WHERE id = 5078867
[6216 / 2006-06-19 18:46:23 CEST]LOCATION: pg_parse_query, postgres.c:526
[3762 / 2006-06-19 18:46:23 CEST]LOG: 00000: server process (PID
6216) was terminated by signal 11
[3762 / 2006-06-19 18:46:23 CEST]LOCATION: LogChildExit, postmaster.c:2358
[3762 / 2006-06-19 18:46:23 CEST]LOG: 00000: terminating any other
active server processes
[3762 / 2006-06-19 18:46:23 CEST]LOCATION: HandleChildCrash, postmaster.c:2251
[3985 / 2006-06-19 18:46:23 CEST]WARNING: 57P02: terminating
connection because of crash of another server process
[3985 / 2006-06-19 18:46:23 CEST]DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit,
because another server process exited abnormally and possibly
corrupted shared memory.
[3985 / 2006-06-19 18:46:23 CEST]HINT: In a moment you should be able
to reconnect to the database and repeat your command.
[3985 / 2006-06-19 18:46:23 CEST]LOCATION: quickdie, postgres.c:1945
[3762 / 2006-06-19 18:46:23 CEST]LOG: 00000: all server processes
terminated; reinitializing
[3762 / 2006-06-19 18:46:23 CEST]LOCATION: reaper, postmaster.c:2150
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: database system was
interrupted at 2006-06-19 18:42:49 CEST
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4094
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: checkpoint record is at
11/3E77AB1C
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4163
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: redo record is at
11/3E774940; undo record is at 0/0; shutdown FALSE
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4191
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: next transaction ID:
3899415; next OID: 46429694
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4194
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: database system was not
properly shut down; automatic recovery in progress
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4250
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: redo starts at 11/3E774940
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4287
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: record with zero length
at 11/3E77AD20
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: ReadRecord, xlog.c:2496
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: redo done at 11/3E77ACF8
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4345
[6217 / 2006-06-19 18:46:23 CEST]LOG: 00000: database system is ready
[6217 / 2006-06-19 18:46:23 CEST]LOCATION: StartupXLOG, xlog.c:4557

Can anyone help me, please?

regards,
thomas!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-19 18:42:07 Re: ERROR: there is no parameter $1
Previous Message Chris Golden 2006-06-19 17:03:06 Interface Guidance and Opinions Needed