simple query terminated by signal 11

Поиск
Список
Период
Сортировка
От Thomas Chille
Тема simple query terminated by signal 11
Дата
Msg-id cad2de1c0606191006n26fa9adal733f7568e274a98e@mail.gmail.com
обсуждение исходный текст
Список 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!

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Jenkins
Дата:
Сообщение: ERROR: there is no parameter $1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: there is no parameter $1