Gaetano Giunta
Guest
|
 Posted: Wed May 02, 2007 10:10 am Post subject: FW: release lock |
 |
|
You might also take a look at my previous posts on the subject.
In our case we traced down the lock being created and never released due to unstable communication between the eventum server and the mail server. The php script in charge of sending mail has no bultin timeout, and sometimes it hangs forever.
I set up a timeout value, and now everything is fine.
Every now and then the mail sending process errors, but the mails left in the queue get send at the next round (we send mail every 5 mins)
bye
Gaetano
| Quote: | -----Original Message-----
From: Schalk Neethling [mailto:schalk (AT) alliedbridge (DOT) com]
Sent: Tuesday, May 01, 2007 11:42 AM
To: Baker, James
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: release lock
Thanks Jim.
Baker, James wrote:
Process_mail_fix_filelock.cmd:
@echo off
rem You will need to update this batch file with the right
locations for
files.
set RUNDIR=c:\www_public\web\tracker-it\misc
set OUTDIR=c:\www_server\cron\logs
set PHPDIR=c:\www_server\php
now >> %OUTDIR%\output.log
pushd %RUNDIR%
time /t >time.txt
type time.txt
echo Fixing Mail Queue... Please Hold
%PHPDIR%\php process_mail_queue.php --fix-lock >>%OUTDIR%\output.log
popd
Jim
-----Original Message-----
From: Schalk Neethling [mailto:schalk (AT) alliedbridge (DOT) com]
Sent: Monday, April 30, 2007 5:59 PM
To: eventum-users (AT) lists (DOT) mysql.com
Subject: release lock
Hi everyone,
Before I go and re-invent the wheel, has anyone written a
PHP script to
release the lock when mails starts to fail because of a lock?
We are currently experiencing this problem frequently, the job is
triggered and fails because there is a lock on the process.
So far, we
have figured out that there is a specific file that
contains the lock
and when deleting this file, the mail process starts running again.
With frequent network problems we are foreseeing this to be
a recurrent
problem so I want to write a simple PHP script to clear out
the locks in
these cases, as they seem to be kept in a specific folder, if memory
serves me correctly the folder is actually called locks.
Thanks
Schalk
--
Eventum Users Mailing List
For list archives: http://lists.mysql.com/eventum-users
To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=james.baker (AT) citigroup (DOT) com
--
Eventum Users Mailing List
For list archives: http://lists.mysql.com/eventum-users
To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=giunta.gaetano@sea-
aeroportimilano.it
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
