FUDforum: FUDforum 3.0+ » Error deleting user

Home » FUDforum Development » FUDforum 3.0+ » Error deleting user

Show: Today's Messages :: Polls :: Message Navigator

Re: Error deleting user [message #2248 is a reply to message #2247]

Mon, 06 May 2002 18:13

hackie

Messages: 177
Registered: January 2002

Karma:

Senior Member
Core Developer

esm2002 wrote on Mon, 06 May 2002 2:08 PM

just sits there and never does get to the FUD forum

Okie, this is little snafu with persistant connections and mysql table locking and php's ineptness....

Basically, what is currently happening is that your PHP script when it got that error left the MySQL tables locked, and since php's dumb and didn't excute the atexit function which unlocks the tables because of that error.

So, you really have two solutions that you can try:

First you can restart your webserver which will fix this (because upon restart php will close all mysql connections and therefor drop the locks)

Second you can use mysqladmin utlity to get the list of all the active mysql threads, and kill off the thread that is holding the tables hostage Smile

Also, in the future to prevent this from happening disable persistant connections in the globals control pannel, while they do enchance the preformance a bit, because php is broken in some cases it's now safe to use it, as you've just found out.

If you require more help resolving this prob ask away Smile

cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault

Report message to a moderator

[Message index]

		Error deleting user By: esm2002 on Mon, 06 May 2002 16:28
		Re: Error deleting user By: Ilia on Mon, 06 May 2002 16:31
		Re: Error deleting user By: esm2002 on Mon, 06 May 2002 17:04
		Re: Error deleting user By: Ilia on Mon, 06 May 2002 17:10
		Re: Error deleting user By: esm2002 on Mon, 06 May 2002 17:33
		Re: Error deleting user By: hackie on Mon, 06 May 2002 17:49
		Re: Error deleting user By: esm2002 on Mon, 06 May 2002 18:08
		Re: Error deleting user By: hackie on Mon, 06 May 2002 18:13
		Re: Error deleting user By: Olliver on Mon, 06 May 2002 18:49
		Re: Error deleting user By: Ilia on Mon, 06 May 2002 18:54

Previous Topic:	IIS probs with 20020430
Next Topic:	Patch: Jabber support

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:07:15 GMT 2024

Total time taken to generate the page: 0.05450 seconds