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