Database error message
Dec 2, 2013 | 3:46 pm
#46
Moderator: American AAdvantage
Join Date: May 2000
Location: NorCal - SMF area
Programs: AA LT EXP; HH LT Diamond, Matre-plongeur des Muccis
Posts: 62,948
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.
Dec 3, 2013 | 1:51 am
#47
Join Date: May 2004
Location: Home
Programs: AA, Delta, UA & thanks to FTers for my PC Gold!
Posts: 7,674
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.
Dec 3, 2013 | 11:56 am
#48
No longer with Internet Brands
Join Date: Mar 2011
Location: Los Angeles, CA
Programs: DL DM 1.6MM, Marriott LT Plat
Posts: 5,343
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.
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.
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.
Dec 3, 2013 | 12:01 pm
#51
Administrator
Join Date: Apr 2008
Location: Los Angeles, CA
Programs: SPG
Posts: 607
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.
- 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.
Dec 3, 2013 | 12:05 pm
#52
No longer with Internet Brands
Join Date: Mar 2011
Location: Los Angeles, CA
Programs: DL DM 1.6MM, Marriott LT Plat
Posts: 5,343
Dec 3, 2013 | 12:33 pm
#53
Join Date: May 2004
Location: Home
Programs: AA, Delta, UA & thanks to FTers for my PC Gold!
Posts: 7,674
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.
- 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.
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.
Dec 3, 2013 | 12:41 pm
#54
Administrator
Join Date: Apr 2008
Location: Los Angeles, CA
Programs: SPG
Posts: 607
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.
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.
Updated: Detailed transaction logging has been enabled to capture a possible error condition. Thanks.
Last edited by IBxAnders; Dec 3, 2013 at 1:30 pm
Dec 4, 2013 | 6:44 pm
#55
Administrator
Join Date: Apr 2008
Location: Los Angeles, CA
Programs: SPG
Posts: 607
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.
- 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.
Dec 8, 2013 | 10:02 pm
#56
Join Date: May 2004
Location: Home
Programs: AA, Delta, UA & thanks to FTers for my PC Gold!
Posts: 7,674
It's BACK!
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.
- 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.
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"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin :
mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (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>
Dec 27, 2013 | 12:30 pm
#58
Join Date: May 2004
Location: Home
Programs: AA, Delta, UA & thanks to FTers for my PC Gold!
Posts: 7,674
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."
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"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin :
mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (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>
Apr 9, 2014 | 2:23 am
#59
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, UA Silver, HH Diamond, IHG Plat, Hyatt Plat, Marriott Titanium, Nat'l EE, Avis PC, Hertz PC
Posts: 16,630
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?
Good to know I should try and grab the page source next time, which I will do... anybody else having issues with this recently?
Apr 9, 2014 | 7:05 pm
#60
A FlyerTalk Posting Legend
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 102,617
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.