A Haunted Database
От | Robert Cleveland |
---|---|
Тема | A Haunted Database |
Дата | |
Msg-id | 003f01bfa168$636509e0$1fdcfea9@robertcl обсуждение исходный текст |
Ответы |
Re: A Haunted Database
|
Список | pgsql-general |
Here's a mystery I hope someone can solve for me. We are entering blocks of HTML into a table called bodyparts. We use PHP3 to break up these blocks into several chunks to keep the length below the maximum. When the end user calls up the section, the "bodyparts" are extracted and re-assembled. The output pages work fine . . . for a while. We set up the output pages during the day, check them for accuracy and go to bed thinking we have done a great job. Then , in the middle of the night, something happens and when we awake, we find the HTML has been scrambled like so many breakfast eggs. Not all sections are scrambled. In fact it is the same sections every single time. So we re-enter the data, check it, assume we are done, and then the same thing happens the next day. To gather some empirical evidence, I ran pg_dump at 7pm on the offending table. I check the output pages at midnight the same evening, and they all were good. When I got back in front of the computer at 9am, the pages were scrambled again. I ran pg_dump a second time to a separate file. The file sizes were different (insert scary music here). No one had touched the database or the pages. I reloaded the data and everything is back to normal. But I suspect it will happen again tonight and I am afraid. Does anyone know what inhuman entity might be causing this to occur?
В списке pgsql-general по дате отправления: