FW: release lock - Gaetano Giunta - com.mysql.lists.eventum-users

4 messages in com.mysql.lists.eventum-usersFW: release lock

From	Sent On	Attachments
Schalk Neethling	30 Apr 2007 15:58
Baker, James	30 Apr 2007 16:13
Schalk Neethling	01 May 2007 02:42
Gaetano Giunta	02 May 2007 01:24

Subject:	FW: release lock
From:	Gaetano Giunta (giun...@sea-aeroportimilano.it)
Date:	05/02/2007 01:24:31 AM
List:	com.mysql.lists.eventum-users

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

-----Original Message----- From: Schalk Neethling [mailto:sch...@alliedbridge.com] Sent: Tuesday, May 01, 2007 11:42 AM To: Baker, James Cc: even...@lists.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

-----Original Message----- From: Schalk Neethling [mailto:sch...@alliedbridge.com] Sent: Monday, April 30, 2007 5:59 PM To: even...@lists.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.

aeroportimilano.it