c2c-oerpscenario team mailing list archive

["Sharoon Thomas http://openlabs.co.in" <sharoonthomas@xxxxxxxxxxxx>]

@Joan Arus,

Your problem is different.

If you want the mails to be sent infinitely then the number of times
should be a -ve number say -1.

it will not send if its 0.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/493544

Title:
  Improper cronjobs?

Status in OpenERP Server:
  Invalid
Status in Power e-Mail for Open ERP:
  Incomplete

Bug description:
  I have had continously problems with Poweremail module, which I
  presume are related to cronjob part of the Poweremail

  Description of the problem:

  1) All sent e-mail stay at outbox for forever after Powermail module
  installation. I note that there is a regular poweremail task to run a
  cron once every hour and all other regular tasks run, but no emails
  are ever sent out.

  2) If I log out from Openerp database and/or restart openerp-server
  afterwards, the OpenERP is not reachable anymore (the server is
  working, but does not give the list of databases to OpenERP client).
  The main technical reason is, that the OpenERP becomes stuck with too
  many idle (at least 30-50) postgresql connections, so the postgresql
  database pool becomes eventually exhausted. Moreover, restarting
  openerp-server or postgresql does not close down these idle
  connections (that can stay for hours and days).

  The only solution to revert back to working installation of OpenERP is
  1) reboot the machine to clean up the postgresql mess as restarting
  postgresql service or killing postgresql process does not kill idle
  connections; 2) delete manually Poweremail related cronjob from
  ir.cron postgresql table before starting openerp-server; 3) start
  openerp-server (now OpenERP becomes reachable) and enter poweremail
  cronjob manually. 4) If one tries to connect OpenERP before deleting
  Poweremail related cronjob from ir.cron, then the postgresql database
  pool becomes again exhausted.

  
  The problem has been present in two different servers (one under Ubuntu and one under RedHat) and is not related with the way I have installed a Poweremail. The plain new installation under fresh OpenERP or updating existing Poweremail installation with new version or uninstalling old version and installing new version of Poweremail have all yielded into the same result -- leaking postgresql connections that can be dealt only by manually deleting the poweremail related line in ir.cron table.