nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Child Item

Datastore/database errors ONLY!

regi

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.

Find more posts tagged with

Quick Links

Comments

mike65

Hmmmmm, sounds like thats what happened.

eVeNtInE

This post has been deleted.

Red Sleeping Beauty

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

eVeNtInE

This post has been deleted.

feylya

@ /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

[Deleted User]

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.

Kinetic^

I'm getting db errors on main page.

[Deleted User]

Yah, keeps happening now

AlmightyCushion

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.

[Deleted User]

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.

Steve

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

Overheal

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

mike65

Ditto the errors - new posts page/front page.

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

Steve

Quick: use moar of this...

AlmightyCushion

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.

copacetic

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.

stovelid

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.

AlmightyCushion

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

Overheal

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.

AlmightyCushion

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

Genghiz Cohen

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

copacetic

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.

yayamark

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.

Delirium

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

Terry

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

Eircom, XP, FF 3.0.7

feylya

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

javaboy

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.

CuLT

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

feylya

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

eVeNtInE

This post has been deleted.