I was experiencing extreme slowness-to-deadness from the threads (but not from the board itself) and then got the following error:
December 17, 2007, 8:06 am Frankenbuddha[914]: ERROR [2] mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) line 90 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
Array
(
[0] => Array
(
[function] => buffistaerrorhandler
[args] => Array
(
[0] => 2
[1] => mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[2] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
[3] => 90
[4] => Array
(
)
)
)
[1] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
[line] => 90
[function] => mysql_connect
[args] => Array
(
[0] =>
[1] => buff_org
[2] => krevlornswath
)
)
[2] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
[line] => 102
[function] => db_connect
[args] => Array
(
)
)
[3] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/thread.php
[line] => 247
[function] => connectandquery
[args] => Array
(
[0] => SELECT thread_id, thread_title, thread_desc, thread_posts, post_date, thread_slug, group_id, thread_secured, closed, archived, create_date FROM threads WHERE thread_id=146
)
)
[4] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/showthread.php
[line] => 9
[function] => load
[class] => thread
[type] => ->
[args] => Array
(
[0] => 146
)
)
)
There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.
Okay, where the $$&#&(@#& are the developers?
December 17, 2007, 8:06 am Frankenbuddha[914]: FATAL [256] CONNECT FAILED: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Fatal error in line 90 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php, PHP 4.3.9 (Linux)
Fatal error in context array ( 0 => array ( 'db' => false, ), )Aborting...
Restarting mysqld helped a little, but the server is still very, very slow.
The internet as a whole has been very slow for me today.
I can never remember if this is helpful or not, but I just got this error while trying to post:
December 21, 2007, 5:21 am Stephanie[1216]: ERROR [2] mysql_query(): Unable to save result set line 103 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
Array
(
[0] => Array
(
[function] => buffistaerrorhandler
[args] => Array
(
[0] => 2
[1] => mysql_query(): Unable to save result set
[2] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
[3] => 103
[4] => Array
(
[query] => select count(post_number) from posts where thread_id=475
[db] => Resource id #9
)
)
)
[1] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
[line] => 103
[function] => mysql_query
[args] => Array
(
[0] => select count(post_number) from posts where thread_id=475
)
)
[2] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/post.php
[line] => 218
[function] => connectandquery
[args] => Array
(
[0] => select count(post_number) from posts where thread_id=475
)
)
[3] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/classes/post.php
[line] => 254
[function] => _save
[class] => post
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/www/vhosts/buffistas.org/httpdocs/processPost.php
[line] => 33
[function] => add
[class] => post
[type] => ->
[args] => Array
(
)
)
)
There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.
Okay, where the $$&#&(@#& are the developers?
December 21, 2007, 5:21 am Stephanie[1216]: FATAL [256] select count(post_number) from posts where thread_id=475 failed: Server shutdown in progress
Fatal error in line 103 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php, PHP 4.3.9 (Linux)
Fatal error in context array ( 0 => array ( 'query' => 'select count(post_number) from posts where thread_id=475', 'db' => NULL, 'result' => false, ), )Aborting...
I just got a similar error trying to post, but then I tried again and it was OK.
Likewise, at the same time, but I lost the post and ran out of time and out the door to work.
buffistas on iPhone for the win. This is easily the quickest site I've used.
I'm worried about the posts mysql table. I think it needs to be repaired/reindexed/vacuumed or something. By someone who knows more about mysql than I do.
