Re: First-draft release notes for next week's releases

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: First-draft release notes for next week's releases
Дата
Msg-id CAM-w4HNrzitseQFwjd2AXZDMVFOo+iGQ+C4GKLAzgY5ExhjkuQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: First-draft release notes for next week's releases  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: First-draft release notes for next week's releases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
This is not really accurate:

"This error allowed multiple versions of the same row to become
visible to queries, resulting in apparent duplicates. Since the error
is in WAL replay, it would only manifest during crash recovery or on
standby servers."

I think the idea is coming from what the second sentence below is
getting at but it may be too complex to explain in a release note:

The error causes some rows to disappear from indexes resulting in
inconsistent query results on a hot standby depending on whether
indexes are used. If the standby is subsequently activated or if it
occurs during recovery after a crash or backup restore it could result
in unique constraint violations as well.

I would consider adding something like "For the problem to occur a
foreign key from another table must exist and a new row must be added
to that other table around the same time (possibly in the same
transaction) as an update to the referenced row" That would help
people judge whether their databases are vulnerable. If they don't
have foreign keys or if they have a coding pattern that causes this to
happen regularly then they should be able to figure that out and
possibly disable them if they can't update promptly.



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

Предыдущее
От: Andreas Karlsson
Дата:
Сообщение: Re: [RFC] What should we do for reliable WAL archiving?
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Archive recovery won't be completed on some situation.