database problems? - Page 2

ch85us2001 · #16 (**permalink**) 04-03-2006, 08:30 PM

Yes, they seem to have disappated this afternoon.

I had to beat them off with a +3 Broadsword earlier though.

BuckGB · #17 (**permalink**) 04-03-2006, 09:01 PM

It seems that our server hardware and bandwidth are no longer the bottlenecks when it comes to overall performance. Our traffic is on the rise and we're seeing continuous searching through millions of records in our forums and subsites, which in turn causes things to get a bit sluggish.

Rebooting the server or restarting the database services seems to alleviate the problem for a period of time, so I might have to look into doing this on a somewhat regular basis. I'll be doing some more research to see if I can tweak some settings to get more performance, and I apologize for the inconvience in the meantime. I don't like the errors any more than you do.

Ravager · #18 (**permalink**) 04-06-2006, 11:44 AM

Twice over the last few days when I got a database error while I was trying to post, I refreshed the page as directed I received another error specifying that an Invalid thread was selected...
I just got the error again:

Quote:

Invalid Thread specified. If you followed a valid link, please notify the administrator

I don't know if everyone is getting this as it's two seperate errors, but they are likely connected. I only get this when I try to post/edit following a Database Error.

Denethorn · #19 (**permalink**) 04-06-2006, 04:05 PM

I was just about to post saying that the database errors seem to have dissapated but I just got one

.

I was going to say that when I did get them I did receive those invalid thread link message, so its not you

Just be careful though, because I ended up with a triple post after trying a combination of back/refresh etc upon encountering that message.

Hill-Shatar · #20 (**permalink**) 04-06-2006, 08:51 PM

I just had a sudden group of these hit me... and reloading the page only reloaded the message, about a dozen times in a row. In fact, I've been trying to see this thread for the same amount of time. Now it's gone, but other strange things are popping up. The main page just showed Slade as online, but his profile had his light off and his last action recorded in the mid afternoon, my time, yesterday.

BuckGB · #21 (**permalink**) 04-06-2006, 08:58 PM

I just had to go through and repair some of the vBulletin database tables, so the forums weren't functioning for about 10-minute interval. I'm still looking into the root cause of the corruption, though, which I'll hopefully have nailed down soon.

BuckGB · #22 (**permalink**) 04-08-2006, 10:07 AM

To help alleviate the database issues, I've created separate IDs for our two busiest MySQL applications (these forums and our ad script). If you still get any database errors, I would appreciate it if you could right click inside your browser window and choose "View Source". This will open up a window that displays the exact reason for the error, which you can then copy/paste into another reply to this thread. Knowing the exact error will help me track down any future problems.

dragon wench · #23 (**permalink**) 04-08-2006, 10:58 AM

Hi Buck, I just had a Data Base Error, here are the results.

View Source:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">

</style>
</head>
<body>
<blockquote>
<blockquote>

<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>



</blockquote>
</blockquote>
</body>
</html>

dragon wench · #24 (**permalink**) 04-08-2006, 11:33 AM

And a second time this morning, I'll paste the view source information I got again, just in case there are various errors (since I can't read this type of material

)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">

</style>
</head>
<body>
<blockquote>
<blockquote>

<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>



</blockquote>
</blockquote>
</body>
</html>

Hill-Shatar · #25 (**permalink**) 04-08-2006, 11:39 AM

Is theree any specific part of the code you want, Buck?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">

</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>



</blockquote>
</blockquote>
</body>
</html>

Fiona · #26 (**permalink**) 04-08-2006, 11:39 AM

This is one of a long series which have themselves prevented me from posting them
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">

</style>
</head>
<body>
<blockquote>
<blockquote>

<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>



</blockquote>
</blockquote>

Hill-Shatar · #27 (**permalink**) 04-08-2006, 11:44 AM

mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11)
/home/gbadmin/htdocs/forums/includes/class_core.php on line 279

Most of mine, if not all, have been identical to the above, with this message. My newest one was no different from the others I've recieved except for the description below.

MySQL Error :
Error Number :
Date : Saturday, April 8th 2006 @ 12:40:38 PM
Script : http://www.gamebanshee.com/forums/sh...4&posted=1
Referrer : http://www.gamebanshee.com/forums/ne...1&p=817802
IP Address : 68.147.206.163
Username :
Classname : vb_database
-->

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

Ravager · #28 (**permalink**) 04-08-2006, 12:09 PM

I've had the error several times now, it's always been the following error:

mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11)
/home/gbadmin/htdocs/forums/includes/class_core.php on line 279

BuckGB · #29 (**permalink**) 04-08-2006, 02:44 PM

I've went through and reconfigured MySQL to allow for more consecutive connections, which will hopefully clear up the remaining database errors. Please let me know if you encounter more errors after this change.

Luis Antonio · #30 (**permalink**) 04-08-2006, 04:01 PM

Got two another database errors. How can I find that log and post for you, Buck? Would it help?