openerp-connector-community team mailing list archive

[Thomas Rehn <thomas.rehn@xxxxxxxxxx>]

Hi everyone,

On one of our connector-based systems we have a problem with the
"AutoVacuum Queue Jobs" cron job. The autovacuum unlinks about 400k done
jobs, but the automatic unlinking of mail.messages is slow. For some
reason that I could not figure out yet, OpenERP starts the autovacuum
cron job again (about every minute) while PostgreSQL is still busy
selecting the mail.messages for unlinking. This leads to simultaneous
SQL queries that SELECT on mail.message and that consume a lot of RAM
(the SELECT contains an IN clause with the 400k ids) and do not finish
(due to limited resources; it takes four minutes to run the big query
without concurring queries).

Have you encountered a similar problem or any ideas why the job is
started multiple times? It doesn't seem to be a connector specific issue
though. For now we disabled the job autovacuum to avoid load and memory
problems.

Best,
 Thomas.

-- 
Dr. Thomas Rehn
Software Developer

initOS GmbH & Co. KG
An der Eisenbahn 1
21224 Rosengarten
Germany

Phone:   +49 4105 56156-15
Fax:     +49 4105 56156-10
Web:     http://www.initos.com