[OpenSIPS-Devel] [ opensips-Bugs-2046356 ] db_mysql error on query: can't lock file pua table only

[SourceForge.net]

Bugs item #2046356, was opened at 2008-08-11 15:19
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2046356&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: modules
Group: None
>Status: Closed
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: scjahn (scjahn)
Assigned to: Nobody/Anonymous (nobody)
Summary: db_mysql error on query: can't lock file pua table only

Initial Comment:
opensips 1.4 compiled from branch, with mysql cluster.

Aug 11 07:50:53 [2406] ERROR:db_mysql:db_mysql_submit_query: driver error on query: Can't lock file (errno: 241)
Aug 11 07:50:53 [2406] ERROR:core:db_do_delete: error while submitting query
Aug 11 07:50:53 [2406] ERROR:pua:db_update: while deleting from db table pua
Aug 11 07:50:53 [2406] ERROR:db_mysql:db_mysql_submit_query: driver error on query: Can't lock file (errno: 241)
Aug 11 07:50:53 [2406] ERROR:core:db_do_query: error while submitting query
Aug 11 07:50:53 [2406] ERROR:presence:msg_presentity_clean: querying database for expired messages


----------------------------------------------------------------------

Comment By: scjahn (scjahn)
Date: 2008-08-21 04:58

Message:
Logged In: YES 
user_id=2124171
Originator: YES

someone had posted a response on another site stating that this is
probably a mysql cluster issue.  this error is directly related to the pua
module when running bla.  all other queries and functionality work fine. 
but it only the pua file that the system can not lock when
updating/deleting.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2046356&group_id=232389