fyi regarding error I've seen posted before
От | maillist |
---|---|
Тема | fyi regarding error I've seen posted before |
Дата | |
Msg-id | 3F2A7166.245455A@tnss.com обсуждение исходный текст |
Ответы |
Re: fyi regarding error I've seen posted before
|
Список | pgsql-admin |
Database error:Invalid SQL: VACUUM VERBOSE ANALYZE ids_logs PostgreSQL Error: 1 (ERROR: simple_heap_delete: tuple concurrently updated ) aged deleted 28954 records I got these error messages from my php script that processes system logs from my linux / unix boxes. this is the first time I've seen this error message, but since people have asked about it before I thought I'd addd my two cents. after I process all my text log files into the database I click on the age button which does a series of updates update pri to pri -1 for anything older than a day update pri to pri -1 for any thing older than a week update pri to pri -1 for anthing older than a month after I do all the updates I run a delete query to delete all records with pri < -99 after I do that I run VACUUM VERBOSE ANALYZE ids_logs and this is where the errors showed up reruning the aging process just ages and deleted more records, so I'm assuming it was a one time thing, nothing to worry about and since the data is trasient, and used to see if my systems are running ok deleteing and recreating the table is no big deal. I'll just lose all the people / ips that have hacked / scaned my boxes in the last month since I've read about this error before on the list, and I know that there were no other processes accessing the table I thought this info might be of value Arno
В списке pgsql-admin по дате отправления: