If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Datastore/database errors ONLY!

regi · 2006-04-22 13:22:33

Hey guys, We've changed how we handle the vb3 datastore - it now uses memcached. If you get any more datastore errors, please post - When (time + date) - What page - Any other stuff your reckon might be useful :) Thanks! Dan.

Options

Comments

Options
#692 05-03-2009 5:47pm
mike65

Closed Accounts Posts: 88,978 ✭✭✭✭

Join Date: May 2001

Posts: 84063

Hmmmmm, sounds like thats what happened.

0
Options
#693 11-03-2009 5:18pm
eVeNtInE

Registered Users Posts: 7,020 ✭✭✭

Join Date: May 2008

Posts: 6560

This post has been deleted.

0
Options
#694 11-03-2009 5:19pm
Red Sleeping Beauty

Closed Accounts Posts: 6,443 ✭✭✭

Join Date: May 2008

Posts: 5826

Yup, I'm gettin em too. I had to go to "new posts" to get into this thread.

0
Options
#695 11-03-2009 5:23pm
eVeNtInE

Registered Users Posts: 7,020 ✭✭✭

Join Date: May 2008

Posts: 6560

This post has been deleted.

0

Options

#696 12-03-2009 12:48am

feylya

Moderators, Music Moderators Posts: 23,359 Mod ✭✭✭✭

Join Date: February 2003

Posts: 21871

@ /vbulletin/showthread.php?t=2055313718&page=5734

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
			, '' AS field11, '' AS field19, '' AS field20, '' AS field21
			
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
			
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
			
		WHERE post.postid IN (0,59381318,59381329,59381340,59381375,59381377,59381376,59381381,59381416,59381452,59381469,59381530)
		ORDER BY post.dateline;

MySQL Error   : Got error 134 from storage engine
Error Number  : 1030
Request Date  : Wednesday, March 11th 2009 @ 11:28:38 PM
Error Date    : Wednesday, March 11th 2009 @ 11:28:39 PM
Script        : [url]http://www.boards.ie/vbulletin/showthread.php?t=2055313718&amp;page=5734[/url]
Referrer      : [url]http://www.boards.ie/vbulletin/usercp.php[/url]
IP Address    : <snip>
Username      : feylya
Classname     : vB_Database
MySQL Version : 
-->

http://www.boards.ie/vbulletin/showthread.php?t=2055313718 (The Lair) Posts 114660 through 114681 are borked

Options

#697 18-03-2009 11:30pm

Random

Closed Accounts Posts: 19,082 ✭✭✭✭

Join Date: September 2004

Posts: 16671

Just now on http://www.boards.ie/index.php?filter=subbed

Database Error  	Database error
The boards.ie 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.boards.ie home page, then try to open another page.
    * Click the Back button to try another link.

The www.boards.ie forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Options
#698 18-03-2009 11:32pm
Kinetic^

Closed Accounts Posts: 13,249 ✭✭✭✭

Join Date: May 2005

Posts: 12373

I'm getting db errors on main page.

0
Options
#699 18-03-2009 11:33pm
Random

Closed Accounts Posts: 19,082 ✭✭✭✭

Join Date: September 2004

Posts: 16671

Yah, keeps happening now

0
Options
#700 18-03-2009 11:39pm
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,060 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33501
Random wrote: »

Just now on http://www.boards.ie/index.php?filter=subbed
Database Error Database error The boards.ie 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.boards.ie home page, then try to open another page. * Click the Back button to try another link. The www.boards.ie forum technical staff have been notified of the error, though you may contact them if the problem persists. We apologise for any inconvenience.

I can view that fine. I get the error when I try to access my usercp though.

Edit: the subbed filter doesn't work for me. I thought it did but I didn't as the page loaded but the part where the posts/threads load is showing the database error.

0

Options

#701 18-03-2009 11:42pm

Random

Closed Accounts Posts: 19,082 ✭✭✭✭

Join Date: September 2004

Posts: 16671

http://www.boards.ie/vbulletin/forumdisplay.php?f=631

 Database Error  	Database error
The boards.ie 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.boards.ie home page, then try to open another page.
    * Click the Back button to try another link.

The www.boards.ie forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Can't load this forum at all it seems.

Options

#702 18-03-2009 11:44pm

Steve

Moderators, Category Moderators, Entertainment Moderators, Sports Moderators Posts: 22,584 CMod ✭✭✭✭

Join Date: February 2006

Posts: 21207

Oh noes!

accessing usercp:

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

		SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid
		
		FROM subscribethread AS subscribethread
		INNER JOIN thread AS thread USING (threadid)
		
		WHERE subscribethread.threadid = thread.threadid
			AND subscribethread.userid = 61898
			AND thread.visible = 1
			AND subscribethread.canview = 1
		AND lastpost &gt; 1237414272;

MySQL Error   : Table 'thread' is marked as crashed and should be repaired
Error Number  : 1194
Request Date  : Wednesday, March 18th 2009 @ 10:40:52 PM
Error Date    : Wednesday, March 18th 2009 @ 10:40:53 PM
Script        : http://www.boards.ie/vbulletin/usercp.php
Referrer      : http://www.boards.ie/vbulletin/showthread.php?p=59465499&amp;posted=1
IP Address    : <nosey>
Username      : Steve
Classname     : vB_Database
MySQL Version : 
-->

Options
#703 18-03-2009 11:45pm
Overheal

Registered Users Posts: 82,157 ✭✭✭✭

Join Date: September 2006

Posts: 75704

clicking to After Hours gives DB error. Slow load times throughout website.

0
Options
#704 18-03-2009 11:47pm
mike65

Closed Accounts Posts: 88,978 ✭✭✭✭

Join Date: May 2001

Posts: 84063

Ditto the errors - new posts page/front page.

http://www.boards.ie/vbulletin/search.php?do=getnew

0
Options
#705 18-03-2009 11:50pm
Steve

Moderators, Category Moderators, Entertainment Moderators, Sports Moderators Posts: 22,584 CMod ✭✭✭✭

Join Date: February 2006

Posts: 21207

Quick: use moar of this...

0
Options
#706 19-03-2009 1:47pm
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,060 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33501

Eh, I get a database error when ever I try to view a forum. Any one else getting this?

Edit: Ignore, it seems to be gone now.

0
Options
#707 19-03-2009 1:48pm
copacetic

Subscribers Posts: 16,575 ✭✭✭✭

Join Date: May 2005

Posts: 15604

yep, me too, can't get direct to any forum. was waiting for someone to post here so I could find it in usercp which is working on and off.

0
Options
#708 19-03-2009 2:05pm
stovelid

Closed Accounts Posts: 27,252 ✭✭✭✭

Join Date: January 2006

Posts: 27017

I just tried to post twice in the Graveyard thread in AH, and got DB errors. Can view AH, and see myself as the last poster in that thread, but can't see the post.

0
Options
#709 19-03-2009 2:12pm
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,060 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33501

copacetic wrote: »

yep, me too, can't get direct to any forum. was waiting for someone to post here so I could find it in usercp which is working on and off.

For future reference. Google site:boards.ie "database errors ONLY!"

0
Options
#710 23-03-2009 11:28pm
Overheal

Registered Users Posts: 82,157 ✭✭✭✭

Join Date: September 2006

Posts: 75704

Call me crazy but its running a bit slowly atm though that could be the 5k+ users compared to the 200 or so during the morning hours im used to. But some pages are taking close to a minute to load, up from 3-4 seconds. Earlier I was getting connection timeouts also.

0
Options
#711 23-03-2009 11:31pm
AlmightyCushion

Moderators, Education Moderators, Technology & Internet Moderators Posts: 35,060 Mod ✭✭✭✭

Join Date: April 2006

Posts: 33501

No timeouts here but things are a bit slow all right.

0
Advertisement
Options
#712 25-03-2009 4:28pm
Genghiz Cohen

Registered Users Posts: 7,182 ✭✭✭

Join Date: November 2005

Posts: 6973

Got a DB Error going from A&A to Shooting, a refresh sorted it though.

0
Options
#713 30-03-2009 1:54pm
copacetic

Subscribers Posts: 16,575 ✭✭✭✭

Join Date: May 2005

Posts: 15604

just now, accessing this page:
http://www.boards.ie/vbulletin/showthread.php?goto=newpost&t=2055525331

also, very slow loading into here to report it, 30secs or more, rather than usually 2 or 3.

0
Options
#714 30-03-2009 3:54pm
yayamark

Registered Users Posts: 2,013 ✭✭✭

Join Date: November 2006

Posts: 1968

very bad today i thought it was down seems to be ok now but an hour ago was very bad.

The thanks button was gone for a while.

0
Options
#715 30-03-2009 4:47pm
Delirium

Moderators Posts: 51,739 ✭✭✭✭

Join Date: March 2008

Posts: 50728

Got the database error when accessing my usercp, refresh sorted it.

If you can read this, you're too close!

0
Options
#716 30-03-2009 5:14pm
Terry

Registered Users Posts: 26,061 ✭✭✭✭

Join Date: September 2004

Posts: 24892

Getting the odd DB error and page timing out.
Some pages loading slowly too.

Eircom, XP, FF 3.0.7

0
Options
#717 31-03-2009 12:48pm
feylya

Moderators, Music Moderators Posts: 23,359 Mod ✭✭✭✭

Join Date: February 2003

Posts: 21871

Every second or third page request is failing with no vBulletin error.

0
Options
#718 31-03-2009 1:04pm
javaboy

Registered Users Posts: 15,094 ✭✭✭✭

Join Date: October 2007

Posts: 14818

feylya wrote: »

Every second or third page request is failing with no vBulletin error.

Same here. Sometimes it happens over and over again. I had no errors when using m.boards if it's any help.

0
Options
#719 31-03-2009 1:35pm
CuLT

Subscribers Posts: 9,716 ✭✭✭

Join Date: March 2001

Posts: 9316

Sorry, some changes to the backend going on with transatlantic data transportation. Should be ok by tonight, may be intermittent problems though.

0

Options

#720 02-04-2009 11:36am

feylya

Moderators, Music Moderators Posts: 23,359 Mod ✭✭✭✭

Join Date: February 2003

Posts: 21871

<!--
Database error in vBulletin :

mysql_pconnect() [&lt;a href='function.mysql-pconnect'&gt;function.mysql-pconnect&lt;/a&gt;]: Too many connections
/usr/local/www/www.boards.ie.export/vbulletin/includes/class_core.php on line 311

MySQL Error   : 
Error Number  : 
Request Date  : Thursday, April 2nd 2009 @ 11:34:29 AM
Error Date    : Thursday, April 2nd 2009 @ 11:34:29 AM
Script        : http://www.boards.ie/vbulletin/editpost.php?do=editpost&amp;postid=59658572
Referrer      : http://www.boards.ie/vbulletin/showthread.php?p=59658572&amp;posted=1
IP Address    : 1.1.1.1
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

Advertisement
Options
#721 11-04-2009 1:34am
eVeNtInE

Registered Users Posts: 7,020 ✭✭✭

Join Date: May 2008

Posts: 6560

This post has been deleted.

0

This discussion has been closed.