Hot Standby and prepared transactions

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Hot Standby and prepared transactions
Дата
Msg-id 1260902950.1955.5332.camel@ebony
обсуждение исходный текст
Ответы Re: Hot Standby and prepared transactions  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
I get this when testing prepared transactions, which looks like it is
unrelated to Hot Standby.

2009-12-15 17:28:08 GMT[10385]LOG:  archive recovery complete
2009-12-15 17:28:08 GMT[10428]LOG:  checkpoint starting: end-of-recovery
immediate wait
2009-12-15 17:28:08 GMT[10428]DEBUG:  creating and filling new WAL file
2009-12-15 17:28:08 GMT[10428]DEBUG:  done creating and filling new WAL
file
2009-12-15 17:28:08 GMT[10428]LOG:  checkpoint complete: wrote 0 buffers
(0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.000 s, sync=0.000 s, total=0.790 s
2009-12-15 17:28:08 GMT[10385]LOG:  recovering prepared transaction
122944
TRAP: FailedAssertion("!(*ptr == ((TransactionId) 0))", File:
"subtrans.c", Line: 87)
2009-12-15 17:28:09 GMT[10380]LOG:  startup process (PID 10385) was
terminated by signal 6: Aborted

This looks like the code is setting the parent to be zero. That
assertion wasn't added by the patch.

2-phase state file attached, zipped. I think we need some tools to
inspect state files.

Can you look at this please?

--
 Simon Riggs           www.2ndQuadrant.com

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Closing out CommitFest 2009-11
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Update on true serializable techniques in MVCC