FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Another strange lock problem?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Another strange lock problem? [message #12214] Thu, 31 July 2003 12:01 Go to next message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
Senior Member
In a hour in wich our forum is quite full, I tried deleting an account via the manager pages. Result: blank page in the admin panel and stuck forum.
Right after that, mysqladmin processlist showed a lot of queries waiting for tables to unlock.

Restarted mysql and the forum is OK, but the user I tried to delete is still there. Tried 2 times in a row with identical result, I decided to wait the night or the early morning to disable the forum and try to delete the user.


~
~
:wq
Re: Another strange lock problem? [message #12216 is a reply to message #12214] Thu, 31 July 2003 12:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Which MySQL are you using, it does sound like it is not releasing locks, however the code does have lock releases in all the appropriate places.

FUDforum Core Developer
Re: Another strange lock problem? [message #12218 is a reply to message #12214] Thu, 31 July 2003 12:23 Go to previous messageGo to next message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
Senior Member
Mysql 3.23.55

~
~
:wq
Re: Another strange lock problem? [message #12219 is a reply to message #12218] Thu, 31 July 2003 12:57 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Strange, I am using the same version and not having such problems. Are you using persistent connections? Do you have a short mysql timeout set in php or mysql?

FUDforum Core Developer
Re: Another strange lock problem? [message #12220 is a reply to message #12219] Thu, 31 July 2003 13:09 Go to previous messageGo to next message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
Senior Member
I've persistent connections turned on, and I haven't modified anything regarding mysql timeouts, I'm using debian defaults.
(in fact I didn't find any setting about timeouts neither in /etc/php4/apache/php.ini nor in /etc/mysql/*)


~
~
:wq
Re: Another strange lock problem? [message #12223 is a reply to message #12220] Thu, 31 July 2003 15:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Inside MySQL run: show variables;

FUDforum Core Developer
Re: Another strange lock problem? [message #12224 is a reply to message #12223] Thu, 31 July 2003 15:59 Go to previous messageGo to next message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
Senior Member
Variables with "time" in the name:

wait_timeout 28800
timezone CEST
slow_launch_time 2
slave_net_timeout 3600
net_write_timeout 60
net_read_timeout 30
long_query_time 10
interactive_timeout 28800
innodb_lock_wait_timeout 50
flush_time 0
delayed_insert_timeout 300
connect_timeout 5



~
~
:wq
Re: Another strange lock problem? [message #12228 is a reply to message #12224] Thu, 31 July 2003 17:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Hmm have you tried making the forum use non-persistent connections?

FUDforum Core Developer
Re: Another strange lock problem? [message #12253 is a reply to message #12228] Thu, 31 July 2003 22:51 Go to previous messageGo to next message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
Senior Member
I was hoping to be able to keep on using them, they make a big difference in performances. Anyway, I'll try to switch them off, to see if some of those problem will go away.

~
~
:wq
Re: Another strange lock problem? [message #12254 is a reply to message #12253] Thu, 31 July 2003 22:55 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Really? I actually have seen only a very negligible benefit from using MySQL with persistent connections.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Problem with block field
Next Topic: Can not change any Text Messages in Template Editor
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 01 11:55:55 GMT 2024

Total time taken to generate the page: 0.05619 seconds