FlyerTalk Forums - Database error message

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)

- Technical Support and Feedback (https://www.flyertalk.com/forum/technical-support-feedback-386/)

- - Database error message (https://www.flyertalk.com/forum/technical-support-feedback/1127037-database-error-message.html)

I've experienced multiple forms of this last week or so - posting (the post seems to get done anyway), but it's been minor - the post / PM / AMP makes it and things move on, unlike the same message we get when the system crashes with a database hash.

Quote:

Originally Posted by IBobi (Post 21889225)

I've reported this to tech. This is the only report of this behavior I've seen, so I'm not sure what they can do.

It's been an ongoing (minor) issue for me this year and the years before. And I am not alone:

Quote:

Originally Posted by cblaisd (Post 21889986)

Well, I would say that this behavior happens multiple times a week for me.

Quote:

Originally Posted by JDiver (Post 21890125)

I didn't brother taking time to report this before because:
1. Not counting scheduled maintenance, FT seems to have database error constantly all year round.
2. Those database error hiccups normally go away within minutes, with 1 or 2 clicks of browser refresh.
3. and the bolded quote above from IBobi. (Sad, isn't it? needed technical assistance the tech team doesn't know what or how to provide)

What ticked me off to report the RBP w/ database error this time was because it took me 4 attempts and still a no-go for one RBP last week.

I am no techie but there's just something very wrong with FT servers/mainframe/whatever-it-should-call all along when the site is not down but the system sends out "database error" messages during FTers normal browsing sessions for no good reasons at all.

Quote:

Originally Posted by lin821 (Post 21892614)

It's been an ongoing (minor) issue for me this year and the years before. And I am not alone:

I didn't brother taking time to report this before because:
1. Not counting scheduled maintenance, FT seems to have database error constantly all year round.
2. Those database error hiccups normally go away within minutes, with 1 or 2 clicks of browser refresh.
3. and the bolded quote above from IBobi. (Sad, isn't it? needed technical assistance the tech team doesn't know what or how to provide)

What ticked me off to report the RBP w/ database error this time was because it took me 4 attempts and still a no-go for one RBP last week.

I am no techie but there's just something very wrong with FT servers/mainframe/whatever-it-should-call all along when the site is not down but the system sends out "database error" messages during FTers normal browsing sessions for no good reasons at all.

Specifically, this is the first I'm hearing of an error when using the RBP function.

I'm not the tech team, FYI -- I'm the liaison to them, and it is ME who doesn't know what they might be able to do. But as I said, it's been reported and they're looking into it. I'll let you know what they find.

Just to confirm, RBP is "Report Bad Post" and is an icon with exclamation point?

Quote:

Originally Posted by IBxAnders (Post 21895635)

Just to confirm, RBP is "Report Bad Post" and is an icon with exclamation point?

Yup.

Additional Notes: on "Database Error" reports.

- This is the first time tech is alerted to "db error" condition
- There have been absolutely 0 alerts of any issue from any internal and external monitoring systems

If possible, at the time when Database Error message is displayed - please "View Source Code" on your browser and copy/paste the output of the error.

Quote:

Originally Posted by IBxAnders (Post 21895655)

If possible, at the time when Database Error message is displayed - please "View Source Code" on your browser and copy/paste the output of the error.

(This is a right-click and "View Page Source", FYI)

Quote:

Originally Posted by IBxAnders (Post 21895655)

I don't have one to report today. Not yet. I'll post the source code when I run into the next episode. FYI: you may refer to the OP for the wording of the error message for the moment being.

I am surprise to learn you tech guys got zero alert when the database error messages popped up. You are saying the users ran into problems with the site, but the system failed to signal the errors to the proper party when the error message showed, "The www.flyertalk.com forum technical staff have been notified of the error, though you may contact them if the problem persists." Man, the FT system may be much broken than I had imagined.

Quote:

Originally Posted by lin821 (Post 21895879)

The system does send low-level noise considered within scope for a PHP/MYSQL application, it has not alerted at the level necessary to elevate the priority of the issue or to indicate the issue. Hence I am asking for your help, when you trigger the error - your particular error report will be very helpful in learning what's causing this and fixing it.

Updated: Detailed transaction logging has been enabled to capture a possible error condition. Thanks.

ISSUE REPORT UPDATED:

- Database services were reviewed by tech team, small configuration change(s) were made
- Error log review since last post in this thread revealed no database errors from logged in users

Please update if you feel this resolution is not sufficient or another error persisists. Thank you.

Quote:

Originally Posted by IBxAnders (Post 21905238)

Just got a couple of database errors minutes ago, not including RBPs:

Code:

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

        <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />

        <style type="text/css">

        <!--        

        body { background-color: white; color: black; }

        #container { width: 400px; }

        #message   { width: 400px; color: black; background-color: #FFFFCC; }

        #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }

        .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }

        a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }

        a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }

        -->

        </style>

</head>

<body>

<table cellpadding="3" cellspacing="5" id="container">

<tr>

        <td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>

        <td id="bodytitle" width="100%">Database error</td>

</tr>

<tr>

        <td class="bodytext" colspan="2">The  database has encountered a problem.</td>

</tr>

<tr>

        <td colspan="2"><hr /></td>

</tr>

<tr>

        <td class="bodytext" colspan="2">

                Please try the following:

                <ul>

                        <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>

                        <li>Open the <a href="/">www.flyertalk.com</a> home page, then try to open another page.</li>

                        <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>

                </ul>

        </td>

</tr>

<tr>

        <td class="bodytext" colspan="2">The www.flyertalk.com forum technical staff have been notified of the error, though you may <a href="mailto:">contact them</a> if the problem persists.</td>

</tr>

<tr>

        <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>

</tr>

</table>





<!--

Database error in vBulletin :



mysqli_real_connect() [&lt;a href='function.mysqli-real-connect'&gt;function.mysqli-real-connect&lt;/a&gt;]: (HY000/1040): Too many connections

/var/www/flyertalk.com/www/forum/includes/class_core.php on line 1138



MySQL Error   : 

Error Number  : 

Request Date  : Sunday, December 8th 2013 @ 08:48:36 PM

Error Date    : Sunday, December 8th 2013 @ 08:48:36 PM

Script        : http://www.flyertalk.com/forum/forumdisplay.php?f=386

Referrer      : http://www.flyertalk.com/forum/

IP Address    : 114.42.211.41

Username      : 

Classname     : vB_Database_MySQLi

MySQL Version : 

-->





</body>

</html>

Thanks for the report, investigating. Will update.

It just happened again minutes ago when browsing Asia Forum....

"Database error
The database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the www.flyertalk.com home page, then try to open another page.
Click the Back button to try another link.

The www.flyertalk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience."

Code:

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

        <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />

        <style type="text/css">

        <!--        

        body { background-color: white; color: black; }

        #container { width: 400px; }

        #message   { width: 400px; color: black; background-color: #FFFFCC; }

        #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }

        .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }

        a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }

        a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }

        -->

        </style>

</head>

<body>

<table cellpadding="3" cellspacing="5" id="container">

<tr>

        <td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>

        <td id="bodytitle" width="100%">Database error</td>

</tr>

<tr>

        <td class="bodytext" colspan="2">The  database has encountered a problem.</td>

</tr>

<tr>

        <td colspan="2"><hr /></td>

</tr>

<tr>

        <td class="bodytext" colspan="2">

                Please try the following:

                <ul>

                        <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>

                        <li>Open the <a href="/">www.flyertalk.com</a> home page, then try to open another page.</li>

                        <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>

                </ul>

        </td>

</tr>

<tr>

        <td class="bodytext" colspan="2">The www.flyertalk.com forum technical staff have been notified of the error, though you may <a href="mailto:">contact them</a> if the problem persists.</td>

</tr>

<tr>

        <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>

</tr>

</table>





<!--

Database error in vBulletin :



mysqli_real_connect() [&lt;a href='function.mysqli-real-connect'&gt;function.mysqli-real-connect&lt;/a&gt;]: (08004/1040): Too many connections

/var/www/flyertalk.com/www/forum/includes/class_core.php on line 1138



MySQL Error   : 

Error Number  : 

Request Date  : Friday, December 27th 2013 @ 11:27:31 AM

Error Date    : Friday, December 27th 2013 @ 11:27:31 AM

Script        : http://www.flyertalk.com/forum/

Referrer      : 

IP Address    : 114.42.218.158

Username      : 

Classname     : vB_Database_MySQLi

MySQL Version : 

-->





</body>

</html>

Is it just me, or are these getting more common? I'm used to seeing them, and it's usually a fairly transient issue... I maybe refresh a page several times and it's gone. Recently it seems like it's been happening more frequently, and for longer durations... like yesterday (Apr 8) it was down for a while even trying to browse the FT homepage or various forums.

Good to know I should try and grab the page source next time, which I will do... anybody else having issues with this recently?

I kept getting database error for hours starting about twenty hours ago. I finally gave up, although I did wonder whether I had missed a "down for maintenance" announcement given the timing of the outage around midnight in some USA time zone.