database problems?

Post by **BuckGB** » Thu Apr 06, 2006 7: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.

Post by **BuckGB** » Sat Apr 08, 2006 9: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 · Post by **dragon wench** » Sat Apr 08, 2006 9: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>

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 · Post by **dragon wench** » Sat Apr 08, 2006 10: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>

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 · Post by **Hill-Shatar** » Sat Apr 08, 2006 10: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>

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 · Post by **Fiona** » Sat Apr 08, 2006 10: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>

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 · Post by **Hill-Shatar** » Sat Apr 08, 2006 10: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/showt ... 4&posted=1
Referrer : http://www.gamebanshee.com/forums/newre ... 1&p=817802
IP Address : 68.147.206.163
Username :
Classname : vb_database
-->

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

Ravager · Post by **Ravager** » Sat Apr 08, 2006 11:09 am

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

Post by **BuckGB** » Sat Apr 08, 2006 1: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 · Post by **Luis Antonio** » Sat Apr 08, 2006 3:01 pm

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

Kipi · Post by **Kipi** » Sat Apr 08, 2006 3:33 pm

@LA:
I will save you from searching, here is the log of the error I got just few minutes ago:
<!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>

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>

So, the error hasn't disappeared...

Ravager · Post by **Ravager** » Sat Apr 08, 2006 4:59 pm

I'm still getting the errors too. Mainly the '/tmp/mysql.sock' (11)' ones.

dragon wench · Post by **dragon wench** » Sun Apr 09, 2006 10:58 am

I'm still having problems too, here is the error I just got:

<!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>

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>

Post by **BuckGB** » Sun Apr 09, 2006 11:07 am

Thanks for all the help tracking this down. I'm still tweaking settings today, so you may get more or less database errors than usual. They're all the same error so far, though, so from here on please post View Source information only if it differs from the errors above.

dj_venom · Post by **dj_venom** » Sun Apr 09, 2006 6:09 pm

Clean up on aisle Succeeder Stronghold.

Just a warning guys, if you get the error when you post, don't hit refresh, or you double post... or post 10 times like Athena.

Someone may want to clean up the mess too...

Same error as the ones mentioned.

Athena · Post by **Athena** » Sun Apr 09, 2006 6:13 pm

It's a bit frustrating for me. The fourm says I posted there but I can't read the thread!
~it stops me at page 1136!!

Phreddie · Post by **Phreddie** » Sun Apr 09, 2006 8:23 pm

Hmm, clean up aisle Oblivion as well, several people have double and triple posted. Im just lucky the last twenty or so of my refreshes didnt go through..

dragon wench · Post by **dragon wench** » Sun Apr 09, 2006 10:28 pm

In addition to the multiple postings.... (there are better things to have multiples of

), I just want to mention as well that in SYM brand new threads that have posts in them are showing as having zero posts. And other threads are not showing the most recent poster. For example, BS' new thread actually has several posts but SYM's main page shows it as having zero. Similarly, while Lestat was the last person to post in the Succeeder Stronghold, it is showing Athena to have been the most recent poster.

Hill-Shatar · Post by **Hill-Shatar** » Sun Apr 09, 2006 10:30 pm

The latter of DW's post is true for this thread as well, showing the newest poster as 'Buck Satan'.

Got a new error when I was trying to use the search function.



EDIT- A link for Athena's username as last poster of the SS has taken me to DJV's profile. DJV is not the last poster there either.

Hill-Shatar · Post by **Hill-Shatar** » Sun Apr 09, 2006 10:52 pm

I left and decided to take a few screenshots. Captions follow.

[First Caption] It appears that the forum does not update at all on the main page either. It still shows Mr Sir as the last poster, even though this one has several posts following yours.

[Second Caption] This is the GameBanshee Discussion Forum. As you can see, it lists you as last poster and as the second thread.

[Third Picture] SYM. BS' thread has at least seven replies due to database errors and the last poster in the SS was Athena, even though Lestat triple posted last. Her profile link takes me to DJV's from that screen. Also, DW's post does not show as a new one after mine, as you can see, in the thread on top.

[ATTACH]3325.vB[/ATTACH]

[ATTACH]3326.vB[/ATTACH]

[ATTACH]3327.vB[/ATTACH]