Problem with locking on queue.php.lock on posting

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
aleloro
Registered User
Posts: 1
Joined: Tue May 03, 2011 2:04 pm

Problem with locking on queue.php.lock on posting

Post by aleloro » Tue May 03, 2011 2:27 pm

Hello,
I recently done the update from version 3.0.4 to 3.0.8. At first it seemed that everything was working properly, then in charge of currency translation (800 - 900 users) apache's process began to multiply, leaving open connections to the database, processes them to just go up to saturate the server's RAM .

By performing an analysis of the log of apache processes we discovered that the file posting.php was waiting for a lock on the file /cache/queue.php.lock . We noticed that the code /includes/functions_messagger.php that manages event lock has been changed from 3.0.4 to 3.0.8.

Now we have modify the configuration of queue_interval from 60 to 15, and the activity of the apache's process now is normal, but this a quick workaround.

Someone has had the same problem and knows a solution?

Any help appreciated.

Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: Problem with locking on queue.php.lock on posting

Post by Oleg » Thu May 05, 2011 5:47 am

Queue lock is supposed to be released when queue processing is done. If your installation for whatever reason does not complete queue processing normally (killed by php time limit, errors, etc.) apache process is likely to retain a lock for an extended period of time, blocking other apache processes. You can check for this problem by setting MaxRequestsPerChild to 1 and restoring queue interval to the original value of 60.

Reducing queue interval makes the queue be processed more frequently, which should reduce its average size and therefore make each processing run take less time, therefore avoiding death by time limit. If you don't have any problems with outgoing email, a queue interval of 15 is fine.
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com

net83it
Registered User
Posts: 500
Joined: Sun Jan 15, 2006 2:42 pm
Location: Sicily
Contact:

Re: Problem with locking on queue.php.lock on posting

Post by net83it » Thu Aug 11, 2011 1:59 pm

in my cache folder i found the queue.php.lock

can i delete this file?

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Problem with locking on queue.php.lock on posting

Post by Oyabun1 » Thu Aug 11, 2011 2:23 pm

Yes, but it will be recreated the next time it is used. What are you trying to do?
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
Lumpy Burgertushie
Registered User
Posts: 66339
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Problem with locking on queue.php.lock on posting

Post by Lumpy Burgertushie » Thu Aug 11, 2011 2:25 pm

net83it wrote:in my cache folder i found the queue.php.lock

can i delete this file?
yes, you can delete everything in the cache folder except for the index and htaccess files.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

net83it
Registered User
Posts: 500
Joined: Sun Jan 15, 2006 2:42 pm
Location: Sicily
Contact:

Re: Problem with locking on queue.php.lock on posting

Post by net83it » Fri Aug 12, 2011 12:02 am

Oyabun1 wrote:Yes, but it will be recreated the next time it is used. What are you trying to do?
i noticed a delay in sending emails from my board, and when i check the cache folder to see queue.php i saw also queue.php.lock

now i solved the dealy problem and i was guessing if i could safely delete the other file

Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: Problem with locking on queue.php.lock on posting

Post by Oleg » Sat Aug 13, 2011 3:30 am

You can delete the lock file, but it will simply be recreated the next time mail is sent. Current implementation of mail queue never deletes the lock file.
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com

Locked

Return to “[3.0.x] Support Forum”