RE: Help! Messages are NOT Going Out - Tibor Gellert - com.mysql.lists.eventum-users

2 messages in com.mysql.lists.eventum-usersRE: Help! Messages are NOT Going Out

From	Sent On	Attachments
Kraer, Joseph	04 May 2006 09:04
Tibor Gellert	04 May 2006 10:00

Subject:	RE: Help! Messages are NOT Going Out
From:	Tibor Gellert (Tibo...@openet-telecom.com)
Date:	05/04/2006 10:00:19 AM
List:	com.mysql.lists.eventum-users

My understanding of the lock files is that whenever an email download/processing
process is started off (cron job) then the job stores its pid in the
corresponding lock file. However if a lock file is already present then the jobs
quits assuming that another instance of the job still running. This lock file
may have been left due to an abnormal job termination or power outage.

Check those lock files, if those are old and the pid is not live, then you can
remove those lock files. Doing it safe you can invoke the job at the prompt like
php donwload_emails.php <emailaccount> <mailserver> INBOX --fix-lock.

Tibor

-----Original Message----- From: Kraer, Joseph [mailto:jkr...@taylorbean.com] Sent: 04 May 2006 17:05 To: even...@lists.mysql.com Cc: Bryan Alsdorf Subject: Help! Messages are NOT Going Out

We are having problems with the notifications that Eventum (v. 1.6.1) is sending out. They all stopped, all of a sudden, on March 17. I noticed in the mail_queue_log table that Eventum was trying to send the same 50 messages over and over with the same error. There were, and are, no problems with the cron job.

Since that table had an inordinate number of lines (over 5 million), I cleaned it up. This had the effect of restarting the queue. So messages pending as of 3/17 started to go out, and they went out through those queued on 3/20, at which time the sending out of messages completely stopped. At this time, there are no entries in the mail_queue_log table, viz. it's empty.

I modified a couple of files, including class.issue.php, because I was considering emailing an "anonymous" reporter the issue number for reference. But the issue of anonymous reporting was dropped, although the modifications remained. I don't think they are at issue here since emails were sent for 3-4 months before the problem started.

BTW, this same issue was occurring on two different versions of Eventum, 1.4 and 1.6.1, and both were solved by cleaning up the log tables and stopping and restarting the cron jobs and Apache server. However, as I said above, the issue in 1.6.1 is continuing and has reached a critical stage.

My CIO checked the Eventum installation and told me that the file that is supposed to be cleared in the lock directory after an email is sent is not being cleared. I'm sorry I don't understand this particular subject very well, but it may help you understand what is going on.

Any ideas?

TIA,

Joseph "Tito" Kraer