Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject
Дата
Msg-id 16389.1177208610@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject  ("Dorochevsky,Michel" <michel.dorochevsky@softcon.de>)
Ответы Re: BUG #3245: PANIC: failed to re-find shared loc k ob ject  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-bugs
"Dorochevsky,Michel" <michel.dorochevsky@softcon.de> writes:
> The failing transaction is visible in the database after restart, I have
> checked three of the last inserts, e.g.

Good, at least we're not losing data ;-).  But I expected that because
this PANIC must be occurring after the RecordTransactionCommitPrepared
step.

> I have no leftover file in $PGDATA/pg_twophase, it is empty.

[ digs in code some more... ]  Oh, I see how that happens: the 2PC
state file is removed when the XLOG_XACT_COMMIT_PREPARED xlog entry
is replayed, so the various code paths that might emit a warning
won't be reached.

Heikki, have you been paying attention to this thread?  You have any
idea what's happening?  The whole thing seems pretty unexplainable
to me, especially since Michel's log shows this happening without any
concurrent activity that might confuse matters.  I confess bafflement.

            regards, tom lane

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

Предыдущее
От: Marcin Waldowski
Дата:
Сообщение: Re: BUG #3242: FATAL: could not unlock semaphore: error code 298
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #3242: FATAL: could not unlock semaphore: error code 298