update_smtp_lock: database is locked, while executing DELETE FROM errors

[tkalfaoglu]

I'm seeing lots of these errors in the logs:

Sep 19 12:33:38 lin pop3d: update_smtp_lock: database is locked, while executing DELETE FROM v4_poplocks WHERE valid_till < ?
Sep 19 12:33:40 lin pop3d: update_smtp_lock: database is locked
Sep 19 12:33:41 lin pop3d: update_smtp_lock: database is locked, while executing DELETE FROM v4_poplocks WHERE valid_till < ?
Sep 19 12:33:41 lin pop3d: update_smtp_lock: database is locked, while executing DELETE FROM v4_poplocks WHERE valid_till < ?
Sep 19 12:33:49 lin pop3d: update_smtp_lock: database is locked

How can I fix this?

PS: I cant disable pop before smtp, as hundreds of customers have their outlooks set up as such.
PPS: I saw a blurb in http://kb.parallels.com/en/6172 that this will be fixed "Real Soon Now", and that text was written for version 9

 

[tkalfaoglu]

Bump.. still having these errors.

Sep 24 10:53:22 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:22 lin pop3d: IMAP connect from @ [::ffff:92.44.7.211]update_smtp_lock: database is locked, while executing DELETE FROM v4_poplocks WHERE valid_till < ?
Sep 24 10:53:22 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:23 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:24 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:24 lin pop3d: update_smtp_lock: database is locked, while executing REPLACE INTO v4_poplocks (ip_address, valid_till) VALUES(?, ?)
Sep 24 10:53:24 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:25 lin pop3d: IMAP connect from @ [::ffff:78.175.227.87]IMAP connect from @ [::ffff:81.213.63.33]update_smtp_lock: database is locked
Sep 24 10:53:26 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:26 lin /var/qmail/bin/relaylock[28651]: /var/qmail/bin/relaylock: database is locked
Sep 24 10:53:31 lin /var/qmail/bin/relaylock[28705]: /var/qmail/bin/relaylock: database is locked
Sep 24 10:53:31 lin /var/qmail/bin/relaylock[28716]: /var/qmail/bin/relaylock: database is locked
Sep 24 10:53:31 lin pop3d: IMAP connect from @ [::ffff:95.0.135.160]update_smtp_lock: database is locked
Sep 24 10:53:32 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:33 lin pop3d: IMAP connect from @ [::ffff:209.85.219.2]update_smtp_lock: database is locked, while executing DELETE FROM v4_poplocks WHERE valid_till < ?
Sep 24 10:53:33 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:33 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:34 lin imapd-ssl: IMAP connect from @ [::ffff:178.239.87.209]update_smtp_lock: database is locked
Sep 24 10:53:35 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:35 lin /var/qmail/bin/relaylock[28771]: /var/qmail/bin/relaylock: database is locked
Sep 24 10:53:35 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:36 lin pop3d: update_smtp_lock: database is locked
Sep 24 10:53:37 lin pop3d: IMAP connect from @ [::ffff:88.249.121.178]update_smtp_lock: database is locked
Sep 24 10:53:37 lin pop3d: update_smtp_lock: database is locked

 

[tkalfaoglu]

Igor?? Can you help??

Customers complaining of not being able to send mail

 

[IgorG]

Have you tried to restart pop3 service at least?

 

[tkalfaoglu]

I had rebooted the machine an hour ago. The problems persist.

Btw, it does not fail every time. For example, when I try to send mail, it says "relaying denied blah"..
I do a Get Mail and then I have a good chance of sending my mail..

 

[IgorG]

Is it VPS or standalone server? Maybe there is lack of resources for VPS? Have you tried mchk?

 

[tkalfaoglu]

It's a stand alone, but pretty busy server. It's a large machine, Lots of CPU's, RAM, disk..
-t

 

[tkalfaoglu]

I still need a fix for this problem -- I'm paying, just like everyone, a large sum every month to Parallels.
Why can't bugs be fixed during a reasonable amount of time?

 

[IgorG]

I still need a fix for this problem -- I'm paying, just like everyone, a large sum every month to Parallels.
Why can't bugs be fixed during a reasonable amount of time?

As far as I know this issue affects only you. No one reported it except you. Therefore I think it is your server misconfiguration or something else. I think that you should contact Support Team if you can't find a reason by yourself.

 

[tkalfaoglu]

Thank you for your reply..

Parallels has an article on this issue for version 9.4 saying "it will be fixed at a later version".
Was it ever fixed?

Perhaps other customers are avoiding this issue by using SMTP authentication, which I started recommending after the failure of pop-before-smtp.

I also fail to see how I can misconfigure PLESK to affect mail relaying erratically - that is, it works at times, but fails at others.
(I try to send mail, I get an error, I do a send/receive, then I can send my mail)

Regards,
-turgut