BUG #8984: ERROR: t_xmin is uncommitted in tuple to be updated
| От | marko@joh.to |
|---|---|
| Тема | BUG #8984: ERROR: t_xmin is uncommitted in tuple to be updated |
| Дата | |
| Msg-id | 20140126230221.8089.67653@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #8984: ERROR: t_xmin is uncommitted in tuple to be
updated
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 8984 Logged by: Marko Tiikkaja Email address: marko@joh.to PostgreSQL version: 9.1.11 Operating system: 64-bit Ubuntu Description: Hi, I just noticed we've had the error in subject happen around ten times, starting from Thursday. I don't see it having happened before that. IIRC that day we also switched to another synchronous slave. The previous slave had hot_standby_feedback=on, and the new one has it turned off. Might just be a coincidence. All of the failing queries are inside PL/PgSQL functions, most of them are SELECT .. FOR UPDATE or UPDATE against a table called "workers", but there are a couple of instances against other tables as well. Any ideas? I'll be happy to provide more information, just let me know what you need.
В списке pgsql-bugs по дате отправления: