Re: BUG #7600: Database crash with data corruption
| От | Michał Hankiewicz |
|---|---|
| Тема | Re: BUG #7600: Database crash with data corruption |
| Дата | |
| Msg-id | CAMpaLZp+ALrSyt27vtJuvW9wOc4u4TZU30Kp78gV4avo3w_DzA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #7600: Database crash with data corruption (Craig Ringer <ringerc@ringerc.id.au>) |
| Список | pgsql-bugs |
You misunderstand me.
According to the server logs I have sent in the first message process received signal 2 (it is SIGINT) and according to the documentation this signal should not couse server crash. Wrong values of sequences does not mean hole in generated values, but sequence started to generate the same values once again causing unique constraint violation.
regards
Michał Hankiewicz
According to the server logs I have sent in the first message process received signal 2 (it is SIGINT) and according to the documentation this signal should not couse server crash. Wrong values of sequences does not mean hole in generated values, but sequence started to generate the same values once again causing unique constraint violation.
regards
Michał Hankiewicz
On Sat, Oct 13, 2012 at 1:10 PM, Craig Ringer <ringerc@ringerc.id.au> wrote:
On 10/12/2012 09:35 PM, hankiewicz@gmail.com wrote:To follow up on Tom's explanation, if you're relying on sequences not having "holes" then your design is dangerously mistaken. A simple ROLLBACK throws away any IDs that were obtained from sequences in that transaction.5) after recovery was completed we have discovered that sequences on
production database had wrong values
If you're saying that the sequence is wrong in that it's LOWER than IDs present in the table, then that's a problem.
--
Craig Ringer
В списке pgsql-bugs по дате отправления: