Thread: fyi regarding error I've seen posted before

fyi regarding error I've seen posted before

From
maillist
Date:
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

Re: fyi regarding error I've seen posted before

From
Tom Lane
Date:
maillist <maillist@tnss.com> writes:
> Database error:Invalid SQL: VACUUM VERBOSE ANALYZE ids_logs
> PostgreSQL Error: 1 (ERROR: simple_heap_delete: tuple concurrently
> updated )

Is it possible that you had another VACUUM ANALYZE running concurrently
on this same table?

            regards, tom lane

Re: fyi regarding error I've seen posted before

From
maillist
Date:
Tom Lane wrote:
>
> maillist <maillist@tnss.com> writes:
> > Database error:Invalid SQL: VACUUM VERBOSE ANALYZE ids_logs
> > PostgreSQL Error: 1 (ERROR: simple_heap_delete: tuple concurrently
> > updated )
>
> Is it possible that you had another VACUUM ANALYZE running concurrently
> on this same table?
>
>                         regards, tom lane
>

it is possible that the mouse dbl clicked on the age button, if so i
didn't notice it. but when i analize the logs tomorow morning i'll know
for sure, because all my pgsql servers use syslog. and what i was
running is the tool i wrote in php to process those logs
    Arno