Erroe after upgrade mysql

[hazarus]

after upgrading mySQL, I started getting this error;

Unable to query: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
0: /usr/local/psa/admin/plib/cmd_dns.php3:721 psaerror(string "Unable to query: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)")
1: /usr/local/psa/admin/plib/class.PhDomain.php:755 existsPrefixRecord(string "80", string "www", array)
2: /usr/local/psa/admin/plib/class.DomainControlForm.php:270 BsDomain->getWwwPrefix()
3: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:154 DomainControlForm->assign(object of type BsDomain)

although VB works fine and all other scripts seem to as well, plesk is giving me the error above, can anyone help?
thanks

[Steve Machol]

This error means either MySQL crashed, it's not running or it can't find the socket. Here is more info on this error:

http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html

[eva2000]

did you check with plesk.com support forum and your web host to make sure the mysql version you upgrade to is supported by plesk admin control panel ? as you can break plesk with wrong upgrades

[hazarus]

after testin several things, I upgraded mysql again from version 4.0.26 to version 4.1.15 and the error changed (although everything esle still works fine), the new error is:
Unable to assign DomainControlForm object: Unable to query: Lost connection to MySQL server during query
0: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:156 psaerror(string "Unable to assign DomainControlForm object: Unable to query: Lost connection to MySQL server during query")

any ideas?

[hazarus]

i came across this:
http://bugs.mysql.com/bug.php?id=1370

so maybe it's a mysql bug? i increased the net_read_timeout to 100 but same thing, should i increase it to more?

[eva2000]

contact your web host as it could be mysql bug and/or plesk chucking a fit as it doesn't like the mysql version you're using