MySQLTalk.org

Schalk Neethling · Guest

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

Baker, James · Guest

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

Schalk Neethling · Guest

Thanks Jim.

Baker, James wrote:

Gaetano Giunta · Guest

Ok, here's the patch we developed. We tested it on our setup, and, for us, it works.

In short: all the code is in fact already present in Eventum. All you need to make the timeout parameter 'appear' in your config is modify the template used for the general setup config page.

Please find attached the modified templates, for both version 1.7.1 and 2.0

Drop one of them on your install (make a backup first of the old template at least, or if you have time and space of the whole thing), logon as an admin user, goto general settings and set up a timeout. You're done. (just make sure your setup.conf.php is temporarily writable).

We are experimenting with 60/90 secs timeouts, but I guess it depends a lot on the size of the emails you exchange (ie. do users attach big files to those mails?)

Bye
Gaetano

Gaetano Giunta · Guest

Schalk Neethling · Guest

Thanks a million!!!!

Gaetano Giunta wrote:

Elan Ruusamäe · Guest

On Tuesday 08 May 2007, Gaetano Giunta wrote:

Gaetano Giunta · Guest

Eliot Blennerhassett · Guest

Gaetano Giunta wrote:

Gaetano Giunta · Guest

I put up the modified templates on the pending contributions page:

http://eventum.mysql.org/wiki/index.php/Pending_Contributions

Everyone volunteering to make diffs out of the complete source is welcomed (I know I'm a lazy guy, thank you).

Bye
Gaetano