Database errors

[Drew]

I'm getting a bunch of these and timeouts. I can only get on the board about 50% of the time. Anyone else having the same problems?

[Liberi Fatali]

I'm getting a bunch of these and timeouts. I can only get on the board about 50% of the time. Anyone else having the same problems?

I've been getting these up the wazoo today only. The beginning of this week I did not experience any problems. This is the first time I have been able to get on all day today, save for this morning -- and it is running extremely slow.

[Tisket]

It started for me this morning before I left for work. It's still timing out for me after getting home from work.

I can only conclude that work is to blame. Ipso facto.

[HouseofElves]

Yeah, I've gotten them about every fourth refresh since about 4pm CST.

[Tisket]

Bump.

Piece of shit forum.

[Celephais]

Bump.

Piece of shit forum.

You take that back, this piece of shit forum introduced me to Titsket.

[Tisket]

I won't argue with a man whose penis could span the grand canyon.

edit: in before anyone compares my vagina to the grand canyon.

edit2: jesus it's late here.

[Celephais]

I won't argue with a man whose penis could span the grand canyon.

edit: in before anyone compares my vagina to the grand canyon.

Quick, there was an accident outside my house and a car got flipped ontop of a person and they're trapped, I've placed my unaroused penis under the car, send me pictures of your boobs so I can lift the car for them!

[Tisket]

You are appealing to the emotions of someone who might kindly be called a sociopath.

[Bhaalizmo]

I get these dumb errors on this site all the time. Most often when trying to edit something I just posted. Or (heaven's forbid) view a thread I just viewed.

[Drew]

Remember to lower your posts per page. I'm down to 50.

[TheEschaton]

I do 10 per page and I still get these errors all the time.

[Bhaalizmo]

I do 10 per page and I still get these errors all the time.

Likewise.

[Drew]

I wonder if the stuff that I like about the boards (it saves all your PMs foeva, threads, etc) is the reason for the database errors.

[WRoss]

I wonder if the stuff that I like about the boards (it saves all your PMs foeva, threads, etc) is the reason for the database errors.

Also it keeps all the rep on one page. It takes a good minute to load the User CP sometimes.

[Gsgeek]

Used to get these time outs and db errors every once in a great while, but the last 2+ weeks its been getting a lot worse.

I also am not loading much per page- 10 posts usually.

Just wondered if it was related to a certain browser being used- IE, or if it's an internal problem with the website or server.

[Allereli]

I've been using Chrome for the forums. sometimes I have to click on New Posts twice, but I haven't had to empty my cache

[Sylvan Dreams]

I'm using Firefox. I get a lot of database errors but they come in waves. I'll go for a good stretch not getting any, then I'll get one every time I click. I wonder if it has to do with how much you try to refresh the boards? I seem to get it more when I'm browsing around more.

I've also never gotten it from my iphone, but that could also be time of day dependent or something (maybe traffic affects it)

[msconstrew]

This happens to me multiple times a day, and for quite a while. Doesn't matter if I'm using Chrome, Firefox, IE or even my phone.

[Gelston]

Anytime I've ever gotten database errors other people have them at the exact same time, so I don't think it is related to web browser.

[4a6c1]

Need a Database errors while reading Database Errors Thread meme.

[Archigeek]

Maybe it's time to upgrade the forum to a more recent version? Is there a reason not to?

[Celephais]

Tisket, I think we're having our opening day mid-may ... I believe you've mentioned the husband prioritizes baseball above all else, you and he should come to the east coast. I could give you a database error or two in exchange for giving him first pitch.

[Tisket]

Maybe it's time to upgrade the forum to a more recent version? Is there a reason not to?

Seriously. This is ridiculous. It's like we are living in the dark ages. Aren't the admins of this site some kind of computer geeks? Start geeking™ for pete's sake.

If it's a financial issue then start a pledge drive. I'd donate for a more stable server or site, and I'm sure others would.


Tisket, I think we're having our opening day mid-may ... I believe you've mentioned the husband prioritizes baseball above all else, you and he should come to the east coast. I could give you a database error or two in exchange for giving him first pitch.

You are laboring under the assumption that I want to encourage his baseball fanaticism.

[Showal]

Seriously. This is ridiculous. It's like we are living in the dark ages. Aren't the admins of this site some kind of computer geeks? Start geeking™ for pete's sake.

If it's a financial issue then start a pledge drive. I'd donate for a more stable server or site, and I'm sure others would.



You are laboring under the assumption that I want to encourage his baseball fanaticism.

Pay to support a dying forum for a dying game LOL no thanx.

But in seriousness, i agree. Pledge drive. Or just use the leftovers from the levar burton thing.

[Buckwheet]

These conversations have been going on for quite a while. The last time it happened it lead to me being overly critical and getting banned from the forums for a short period of time.

I personally have felt its time for a new lead admin on the forum for quite a while. The site needs to be moved from where its hosted to a more reliable host. Many people, including myself, have offered to help but so far we have been turned down.

More history of the PC I guess...

Every other time that a lead admin has stepped away from the game and then found themselves not spending much time on the forum they have stepped down and let someone else run the show. I think Kranar needs to look at the situation the forum finds itself in and make some tough decisions.

There is no reason for this forum to be as poorly functional as it is.

[Latrinsorm]

I don't think it's that big a deal.

[Back]

These conversations have been going on for quite a while. The last time it happened it lead to me being overly critical and getting banned from the forums for a short period of time.

Wait. You were banned just for being a dick? Not that I don't believe it but that seems a little heavy handed even for this place.

[Buckwheet]

Wait. You were banned just for being a dick? Not that I don't believe it but that seems a little heavy handed even for this place.

It was more than being a dick. Kranar and I came to an understanding about it and everything that happened we agreed needed to happen. But the reality is that nothing has changed since then and everything that was wrong with the forum then is still incorrect today. Both Kranar and I are passionate when it comes to the PC. I just wish that more was being done even if not being done by me, because we have fully capable members who can also assist with the PC.

[Tisket]

I don't think it's that big a deal.

That's fortunate for you. Seriously, bully for you.

But just because an issue doesn't bother you doesn't mean much to the people that it does. Thanks for weighing in though.

edit: hah, got a database error trying to post this. Do I win something?

[Changeling]

There are a few potential remedies to this issue, though without access to the server to actually troubleshoot some of these are kind of shots in the dark. All of these are server-side changes. Some user settings may exacerbate the issue (e.g. high posts per page, etc.), but it's still indicative of a backend issue.

Assuming it's mysql on the backend, first thing to check is the max_connections to make sure it's not being reached. You can get high watermark by a SHOW STATUS on most versions and looking for max_used_connections. If this equals the max_connections in my.cnf it could be a problem. This is often a case for default installations that have grown since original deployment. If memory is constrained you do have to balance this variable with a few others to ensure mysql doesn't run out of memory.

If individual queries are lingering around too long (for a message board too long would be more than a second for most queries) then it's possible an index is off. Also easily corrected with an ANALYZE TABLE.

If queries are running quickly, however the connections are lingering and exhausting max_connections, it can also somtimes be the load and delay from the application (board) itself. In these instances I've used a php opcode cache (e.g. APC) to dramatically improve application performance and support a much larger number of users on a single system.

[4a6c1]

And then Changeling was like BOOM: I speak tha jibba jabba.

[Asha]

I tried to rep you for bringing 'jibba jabba' to the table. I have to spread that shit around first though.
It's coming though. Jesus Christ it's coming.

[Makkah]

This thread just went retarded.

[Asha]

On topic; I've stopped being surprised when my posts are vapourized and replaced by the database error.

[4a6c1]

This thread just went retarded.

You didn't have to announce yourself, we would have known if you posted anything.

[Tisket]

On topic; I've stopped being surprised when my posts are vapourized and replaced by the database error.

I copy any long post I compose before clicking the post button in case it goes poof before registering. We are an adaptable species.

[Tisket]

You didn't have to announce yourself, we would have known if you posted anything.

I'm pretty sure he was talking about Changeling's geekbabble post. But I could be wrong.

[4a6c1]

I'm pretty sure he was talking about Changeling's geekbabble post. But I could be wrong.

http://static.fjcdn.com/comments/he+s+right+wrong+meme+_a44ec1a2be19c33d1f936f27c9b 436e8.jpg

[Tisket]

http://static.fjcdn.com/comments/he+s+right+wrong+meme+_a44ec1a2be19c33d1f936f27c9b 436e8.jpg

I have no idea what that means.

It occurs to me that I think this a lot when reading your posts.

[4a6c1]

Success.

[Drew]

I don't remember it because it was a long time ago but Buckwheet didn't you originally set up this board when all of us migrated from the-spot? Or you and Kranar did jointly? Or something similar?

[Latrinsorm]

That's fortunate for you. Seriously, bully for you.

But just because an issue doesn't bother you doesn't mean much to the people that it does. Thanks for weighing in though.

edit: hah, got a database error trying to post this. Do I win something?Not so much that it isn't worth looking into, but that it doesn't require a forum coup.

[BriarFox]

There are a few potential remedies to this issue, though without access to the server to actually troubleshoot some of these are kind of shots in the dark. All of these are server-side changes. Some user settings may exacerbate the issue (e.g. high posts per page, etc.), but it's still indicative of a backend issue.

Assuming it's mysql on the backend, first thing to check is the max_connections to make sure it's not being reached. You can get high watermark by a SHOW STATUS on most versions and looking for max_used_connections. If this equals the max_connections in my.cnf it could be a problem. This is often a case for default installations that have grown since original deployment. If memory is constrained you do have to balance this variable with a few others to ensure mysql doesn't run out of memory.

If individual queries are lingering around too long (for a message board too long would be more than a second for most queries) then it's possible an index is off. Also easily corrected with an ANALYZE TABLE.

If queries are running quickly, however the connections are lingering and exhausting max_connections, it can also somtimes be the load and delay from the application (board) itself. In these instances I've used a php opcode cache (e.g. APC) to dramatically improve application performance and support a much larger number of users on a single system.

Should shoot that advice to Kranar, though he might just not be bothering.

[Tisket]

Not so much that it isn't worth looking into, but that it doesn't require a forum coup.

It's always time for a coup. Rock the boat.

[Latrinsorm]

It's always time for a coup. Rock the boat.I have a thing for weiner dogs, what can I say.

[4a6c1]

I don't wanna coup today. :[

[Asha]

I have a thing for weiner dogs, what can I say.

Risky. I applaud you, sir.

[Drew]

PC FREE APRIL AMIRITE?!?!?

[Tisket]

I have a thing for weiner dogs, what can I say.

This isn't about weiner dogs, or their owner. I like them too. This is about fixing a forum that is performing poorly.

It's hard to imagine anyone, dogs included, that would advocate for poor performance but hey, it's the PC. There is usually someone willing to argue the angles of a circle.

edit: you should know me well enough now to know that I hate change. I don't want new personnel; I want a functioning forum.

[Buckwheet]

I don't remember it because it was a long time ago but Buckwheet didn't you originally set up this board when all of us migrated from the-spot? Or you and Kranar did jointly? Or something similar?

http://forum.gsplayers.com/showpost.php?p=945575&postcount=35

That is pretty much the history through Kranar's eyes. Where we differ is that I was the first member, I have user 000001 or whatever in the original forum software UBB, which was the same software The Spot was using.. I created the name, registered the domain and hosted it. Kranar liked the idea and what he writes is 100% accurate. I knew technically how to do it, but lacked experience converting people from the spot.

I did not however leave because I was tired of the place's antics. I was tired of the place because I didn't play GS anymore and was moving on full time to graphical MMOs. I stopped in from time to time during this period of time.

Caels approached me when I was leaving and he and I agreed that he would run the place. I don't know much of what happened during that time as I was not around much. So from the Caels days to when Kranar took over full time I was not present much just checked in from time to time.

And I was not suggesting there be a coup on the forum. I am suggesting that admins have rotated out several times without any issues in the past. Even Kranar hints that things could/would change. They did and he has been admin in absence for quite some time.

Its not a bad thing to rotate out admins, especially when the forums are languishing and not functioning technically.

[Parkbandit]

That's fortunate for you. Seriously, bully for you.

But just because an issue doesn't bother you doesn't mean much to the people that it does. Thanks for weighing in though.

edit: hah, got a database error trying to post this. Do I win something?

God I missed you...

[Parkbandit]

This isn't about weiner dogs, or their owner. I like them too. This is about fixing a forum that is performing poorly.

It's hard to imagine anyone, dogs included, that would advocate for poor performance but hey, it's the PC. There is usually someone willing to argue the angles of a circle.

edit: you should know me well enough now to know that I hate change. I don't want new personnel; I want a functioning forum.

I doubt this is an issue that Anticor is responsible for... more like a Kranar issue.

[Drew]

http://forum.gsplayers.com/showpost.php?p=945575&postcount=35

That is pretty much the history through Kranar's eyes. Where we differ is that I was the first member, I have user 000001 or whatever in the original forum software UBB, which was the same software The Spot was using.. I created the name, registered the domain and hosted it. Kranar liked the idea and what he writes is 100% accurate. I knew technically how to do it, but lacked experience converting people from the spot.

I did not however leave because I was tired of the place's antics. I was tired of the place because I didn't play GS anymore and was moving on full time to graphical MMOs. I stopped in from time to time during this period of time.

Caels approached me when I was leaving and he and I agreed that he would run the place. I don't know much of what happened during that time as I was not around much. So from the Caels days to when Kranar took over full time I was not present much just checked in from time to time.

And I was not suggesting there be a coup on the forum. I am suggesting that admins have rotated out several times without any issues in the past. Even Kranar hints that things could/would change. They did and he has been admin in absence for quite some time.

Its not a bad thing to rotate out admins, especially when the forums are languishing and not functioning technically.




I was a mod on the-spot and a mod when the PC first opened. I remember some of the drama from way back then, it was pretty crazy. This has inspired me to make a poll.

[Tgo01]

Talking about old websites has got me reminiscing. Anyone remember a website a couple of guys made about 10 or 11 years ago? I think it was something like "Gemstone sucks" or something like that. Basically it was started by a couple of guys who "exposed" some of the things Simutronics did and how bad some of the players were (back when being blatantly OOC and multi accounting were considered big no nos by many people.)

Then one day someone setup a forum for them (which was apparently hard to do back then or something?) and that ran for a couple of weeks then the guy who made the forum hijacked it, booted those two guys off of his website and made it a Gemstone fan forum.

Good times, good times.

[Tisket]

I doubt this is an issue that Anticor is responsible for... more like a Kranar issue.

Yeah, I don't think anyone feels he's responsible. Latrinsorm bringing up the dogs makes it seem as though this is about assigning blame when it's only about fixing a problem.

[Parkbandit]

Yeah, I don't think anyone feels he's responsible. Latrinsorm bringing up the dogs makes it seem as though this is about assigning blame when it's only about fixing a problem.

Let's be honest.. Latrinsorm brought it up just so he could say he likes weiners.

Dude.. we get it.

[Tgo01]

Wait Latrinsorm is gay?!

[Tgo01]

I say as a sign of solidarity we all use PB's avatar until the issues are resolved.

[Tisket]

Wait Latrinsorm is gay?!

The more important question is...why don't you have an avatar? Got something to hide? I'm onto you.

[Asha]

Fucking hell it's happening way too often now.

[Tisket]

Fucking hell it's happening way too often now.

We are being punished for this thread. It's a conspiracy to keep us quiet!

[Asha]

:(

[Tisket]

This has inspired me to make a poll.

Do you have ADD? Make the poll already. I have to leave for dinner soon.

[RSR]

He's probably getting database errors every time he tries to make the poll.

-Richard.

[Drew]

Do you have ADD? Make the poll already. I have to leave for dinner soon.

Fine I stopped being lazy.

[Tgo01]

The more important question is...why don't you have an avatar? Got something to hide? I'm onto you.

Who? Me? No. It's just that everyone is out to get me.

[Back]

Who? Me? No. It's just that everyone is out to get me.

I know he likes to watch Ellen... probably along with all the other estrogen laden daytime shows.

[Tgo01]

I know he likes to watch Ellen... probably along with all the other estrogen laden daytime shows.

You shut your mouth!

[Asha]

Sounded more like a response to the question of weather or not Latrinsorm has gay.

[diethx]

Kranar, if you really are ClydeR, could you please take a break for however long and just fix this issue? If you have time to play ClydeR, you've gotta have time to fix this database error garbage.

[Back]

I've got a domain that I don't really use so I'd be happy to host it on my bill but there is no way in hell I would want any part of administering it.

[Parkbandit]

I've got a domain that I don't really use so I'd be happy to host it on my bill but there is no way in hell I would want any part of administering it.

I'm pretty sure www.igetbabesbydumpsters.com is blocked on my computer.

[Changeling]

Sorry to nerd things up again, but Vbulletin is apparently nice enough to expose the underlying database issue when it happens:
<!--
Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: User gsplayer_Kranar already has more than 'max_user_connections' active connections
/home/gsplayer/public_html/forum/includes/class_core.php on line 271

MySQL Error :
Error Number :
Date : Monday, April 16th 2012 @ 01:01:16 PM
Script : http://forum.gsplayers.com/


So issue is either that max_user_connections is too low or something is causing connections to persist for far too long and it's naturally exhausting the max user connections as people keep hitting the site. FYI if the board is the only thing running on the db then max_user_connections doesn't really need to be set or should be set almost as high as max_connections.

[Tgo01]

By "max_user_connections" do you just mean how many people are visiting the site at any given time?

Right now on the homepage it says there are 202 active users (59 members and 143 guests) but it says most users ever online at once was 296 on 01-12-2012. So if that's the case how were we able to have 94 extra people online a few months ago? I guess something could have changed recently.

What was happening on 01-12-2012 by the way?

[Changeling]

By "max_user_connections" do you just mean how many people are visiting the site at any given time?

Right now on the homepage it says there are 202 active users (59 members and 143 guests) but it says most users ever online at once was 296 on 01-12-2012. So if that's the case how were we able to have 94 extra people online a few months ago? I guess something could have changed recently.

What was happening on 01-12-2012 by the way?

Each time someone clicks on a link Vbulletin will open a connection to the database, query for the info, then (unless it's pooling) immediately close it. If the queries all run quickly then there is no problem. If a particular query takes a long time to run for some reason then you could run into a problem if (for a simple example) one person ran it many times or many people ran it one time.

The user connections I'm talking about are Vbulletin's connections to the database and don't have a lot to do with board users. Also FYI the board considers an "active" user to be one who last hit the site within n minutes for example. A database connection is usually active for less than a second or few seconds when someone actually clicks something, so you can have hundreds of board users only ever occupy maybe 10-20 db connections depending on conditions. Of course if you had 100 users all click on a link at once, you'd wind up momentarily with ~100 db connections (assuming no limit were in place), but that's very unlikely since most of a user's time on a board is spent reading, not clicking.

[Celephais]

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: User gsplayer_Kranar already has more than 'max_user_connections' active connections
/home/gsplayer/public_html/forum/includes/class_core.php on line 271

Makes me cringe seeing the site run under what I'm assuming is an admin account. Hmm.. I wonder if this site has any SQL injection vulnerabilities, we could fix it ourselves!

Tgo1, a "user connection" has to do with the program that runs the website talking to the database behind the website. Opening a single page could potentially create multiple user connections if the program was not written properly or some other issue was causing it to have a problem (it could talk to the database to ask for my avatar, not close the connection, then talk again to get the contents of this post).

Once the page is served to you, the active connection to the database should be closed, it shouldn't stay open while you read the forum.

Either way the forum software should handle that error a bit more gracefully.

Whatever the limit actually is the fact we're running into it is indicative of another issue as changeling mentioned. I don't really expect Kranar to go mucking around in how vBulletin works, but whatever the problem really is is probably something really hammering the database, something like needing an index on whatever search is pulling up rep comments.

[Buckwheet]

Makes me cringe seeing the site run under what I'm assuming is an admin account. Hmm.. I wonder if this site has any SQL injection vulnerabilities, we could fix it ourselves!

Tgo1, a "user connection" has to do with the program that runs the website talking to the database behind the website. Opening a single page could potentially create multiple user connections if the program was not written properly or some other issue was causing it to have a problem (it could talk to the database to ask for my avatar, not close the connection, then talk again to get the contents of this post).

Once the page is served to you, the active connection to the database should be closed, it shouldn't stay open while you read the forum.

Either way the forum software should handle that error a bit more gracefully.

Whatever the limit actually is the fact we're running into it is indicative of another issue as changeling mentioned. I don't really expect Kranar to go mucking around in how vBulletin works, but whatever the problem really is is probably something really hammering the database, something like needing an index on whatever search is pulling up rep comments.

It is just a result from a couple hacks/tweaks made to VBulletin, the age of the software, and the hosting environment its on, along with the overall size of the site.

[TheEschaton]

On my Chrome homepage where it lists the websites I visit most often (IE, a thumbnail with a caption), the caption for the PC now reads "Database Error".

........

[diethx]

On my Chrome homepage where it lists the websites I visit most often (IE, a thumbnail with a caption), the caption for the PC now reads "Database Error".

........

LOL

[SHAFT]

So what needs to be done to fix the problem? If its my florichigan titty avatar I'll pull it down

[Androidpk]

Ask Kranar or Anticor?

[Celephais]

So what needs to be done to fix the problem? If its my florichigan titty avatar I'll pull it down

Stop that, if titties need to be removed from the players corner, the players corner needs to be removed from itself.

Death before de-tittying.

[Gweneivia]

I find it extra ironic when I click on this thread and get a database error.

[SHAFT]

Stop that, if titties need to be removed from the players corner, the players corner needs to be removed from itself.

Death before de-tittying.

Forever can I count you good sir as an ally

[Changeling]

So what needs to be done to fix the problem? If its my florichigan titty avatar I'll pull it down

If someone has shell access to the server along with root (or another account with SUPER priv) access to the mysql server I am willing to either fix it myself or walk someone through some diagnostic steps and then the fix.

[Celephais]

If someone has shell access to the server along with root (or another account with SUPER priv) access to the mysql server I am willing to either fix it myself or walk someone through some diagnostic steps and then the fix.

I'm sure Kranar knows how and is perfectly capable of fixing the issue, he's usually oddly active when something is needed of him, and not active otherwise, but in this case he's been kind of quiet.

That and you're well aware that increasing the max user connections is only a stopgap and doesn't address the real problem. It's a stopgap that'd be very nice to have implemented until he can address the real problem, but these boards have not been getting exponentially more active, but the performance degradation has been getting worse at a rate that's non-linear.

I hate to say it because it's a fun mechanic to get people worked up over, but I think it's related to rep on the control panel, when rep was first implemented we couldn't view it, that was added on as an afterthought and I have a feeling it wasn't done peformantly. If I were to take a stab in the dark I'd say we're just an index away from this issue being fixed (although for the sake of future proofing I think viewing our rep should be paged in some manner).

To give you an idea, it takes about 10 seconds for my control panel to open, whereas a typical post, at 50 posts a page, takes less than a second.

[WRoss]

I'm sure Kranar knows how and is perfectly capable of fixing the issue, he's usually oddly active when something is needed of him, and not active otherwise, but in this case he's been kind of quiet.

That and you're well aware that increasing the max user connections is only a stopgap and doesn't address the real problem. It's a stopgap that'd be very nice to have implemented until he can address the real problem, but these boards have not been getting exponentially more active, but the performance degradation has been getting worse at a rate that's non-linear.

I hate to say it because it's a fun mechanic to get people worked up over, but I think it's related to rep on the control panel, when rep was first implemented we couldn't view it, that was added on as an afterthought and I have a feeling it wasn't done peformantly. If I were to take a stab in the dark I'd say we're just an index away from this issue being fixed (although for the sake of future proofing I think viewing our rep should be paged in some manner).

To give you an idea, it takes about 10 seconds for my control panel to open, whereas a typical post, at 50 posts a page, takes less than a second.

Code tags, or at least picture tags, should be disabled in rep as well. I know it was a trend for a long time to include pictures in rep.

[Archigeek]

If we were to upgrade, it would function with IE9 too. Not sure it would do anything with this problem, but it would solve some others. Like it or not, a lot of people use those pesky Microsoft products.

[Celephais]

Code tags, or at least picture tags, should be disabled in rep as well. I know it was a trend for a long time to include pictures in rep.

I kind of like that, but it's certainly seen some abuse... the actual pictures do not contribute to this issue as far as load times go (It doesn't take the PC server any longer to send you a rep w/ images than without).

I'm also starting to think that the rep might be individually read, like there's some lookup for rep that belongs to a person, then a loop to read each individual rep entry. That kind of chatter could explain things pretty nicely. I've got 1397 rep entries ...

anyone interested in counting your rep, just hit F12 while looking at the control panel (Chrome and IE) go to the console tab and put in the following (then subtract 1):

document.getElementById('collapseobj_usercp_reputa tion').children.length

[Changeling]

I'm sure Kranar knows how and is perfectly capable of fixing the issue, he's usually oddly active when something is needed of him, and not active otherwise, but in this case he's been kind of quiet.

That and you're well aware that increasing the max user connections is only a stopgap and doesn't address the real problem. It's a stopgap that'd be very nice to have implemented until he can address the real problem, but these boards have not been getting exponentially more active, but the performance degradation has been getting worse at a rate that's non-linear.

I hate to say it because it's a fun mechanic to get people worked up over, but I think it's related to rep on the control panel, when rep was first implemented we couldn't view it, that was added on as an afterthought and I have a feeling it wasn't done peformantly. If I were to take a stab in the dark I'd say we're just an index away from this issue being fixed (although for the sake of future proofing I think viewing our rep should be paged in some manner).

To give you an idea, it takes about 10 seconds for my control panel to open, whereas a typical post, at 50 posts a page, takes less than a second.


Yep, this is pretty routine for me. Not difficult to fix.

[WRoss]

I lied. I have 1006 reps.

[Celephais]

I tried that in chrome and it didn't work. This was the message:

TypeError: Cannot read property 'children' of null

Did you hit F12 when the control panel screen was in focus?

[WRoss]

Did you hit F12 when the control panel screen was in focus?

I figured it out. See above.

[Stanley Burrell]

I've pinged a few times while being error'd in the face (timeout on usercp) and the host is hosting. The gears are greased. It could be a widget or flange malfunction, or, more likely and accurately, what has been said already.

[Celephais]

Database errors are fixed! All hail the resurrected fatal error!


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 863882 bytes) in /home/gsplayer/public_html/forum/usercp.php(614) : eval()'d code on line 162

Did he just reverse whatever it was that fixed the control panel for those of us w/ too many rep comments?

Oh sweet! Auto Double Post error! (Second time quick post has posted my comment twice)

[Showal]

Database errors are fixed! All hail the resurrected fatal error!


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 863882 bytes) in /home/gsplayer/public_html/forum/usercp.php(614) : eval()'d code on line 162

Did he just reverse whatever it was that fixed the control panel for those of us w/ too many rep comments?

Oh sweet! Auto Double Post error! (Second time quick post has posted my comment twice)

Weird ... I just had a database error, despite this "fix".

[Celephais]

Weird ... I just had a database error, despite this "fix".

Oh, I just assumed since things were going smoothly as far as DB Errors went for me, and the Control Panel was broken ... and all of my posts get double posted..

Horray for just new errors day!

[Tisket]

It seems that when I peruse the forum as a Guest I get less errors and load times are faster.

I also notice that if I have an additional thought on a subject, instead of editing a prior post (which almost always gives me an error) I will just post again.

So, yay for post count?

[Suppa Hobbit Mage]

It seems that when I peruse the forum as a Guest I get less errors and load times are faster.

I also notice that if I have an additional thought on a subject, instead of editing a prior post (which almost always gives me an error) I will just post again.

So, yay for post count?

I heard indisputably that the error occurs to women more than men, because they post emotionally.

[Tisket]

I heard indisputably that the error occurs to women more than men, because they post emotionally.

Bitches ruin it for everyone.

(I don't even know what I mean myself so don't ask)

[Androidpk]

So neither Kranar nor the illustrious administrator Anticor Rollsdownhills have mentioned anything about this problem yet.

[Asha]

It's a feature.

[Parkbandit]

So neither Kranar nor the illustrious administrator Anticor Rollsdownhills have mentioned anything about this problem yet.

Maybe it's like the search function: Working as intended.

[Buckwheet]

Probably won't see much change as it appears gplayers.com is now also being used for personal purposes to host some kind of college tower site.

http://www.gsplayers.com/6thfloor/

Edit:Okay might be shit from 2003-2005, I dunno. But its weird that it even exists.

[Androidpk]

lol

[Tgo01]

Probably won't see much change as it appears gplayers.com is now also being used for personal purposes to host some kind of college tower site.

http://www.gsplayers.com/6thfloor/

Edit:Okay might be shit from 2003-2005, I dunno. But its weird that it even exists.

Let's not be so hasty here. I've always wanted to know who the 6th floor "Propaganda Officer" of 89 Chestnut was and what their role is.

In case anyone else is wondering it's Andrew and his responsibilities include "The Propaganda Officer is Responsible for the distribution of information on the floor via e-mail, posters etc. Will also maintain a floor list-serve."

Also, there are pictures.

[Buckwheet]

I feel like we have access to some kind of secret society that is more secretive than the PC. Maybe is a sub group of the sub group?

[Tgo01]

I feel like we have access to some kind of secret society that is more secretive than the PC. Maybe is a sub group of the sub group?

I have a feeling the site will be gone within 24 hours now...

[Buckwheet]

I have a feeling the site will be gone within 24 hours now...

And anyone who viewed it?

[Androidpk]

I've seen a black hawk fly overhead twice in the last hour...

[Androidpk]

Also... who in those pictures is ClydeR? Have we finally uncovered his true identity?































I'll miss you all!

[Parkbandit]

I have a feeling the site will be gone within 24 hours now...

Christ.. and I'm actually watching "Enemy of the State" right now... which makes me almost believe you!

[diethx]

Also... who in those pictures is ClydeR? Have we finally uncovered his true identity?































I'll miss you all!

:rofl: :rofl:

[Drunken Durfin]

What in the mother fucking shit cock hell is up with all of these database errors?!?

[Tisket]

The general membership is okay but this forum efficiency is a fucking joke.

[Back]

My browser lists "Database Error" as one of my top visited sites further reinforcing my suck at life status.

[Tisket]

Every time a database error screen loads instead of the forum, click on the "Contact them" link in that screen. It will open a email form to one of Kranar's email accounts. Don't know if he checks it often or at all but we should inundate it anyway with email notifications that his forum is fucked up.

[JaTrRm]

Every time a database error screen loads instead of the forum, click on the "Contact them" link in that screen. It will open a email form to one of Kranar's email accounts. Don't know if he checks it often or at all but we should inundate it anyway with email notifications that his forum is fucked up.


Perhaps he is having a "PC free April" and will be back in may to fix it?

[AnticorRifling]

Pretty sure we tracked down root cause of the errors being a lack of new content being added to the boob thread. Apparently when that thread doesn't get proper a proper content refresh it causes instability in the rest of the forum database, sort of a ballast for error free posting if you will.

[Showal]

Pretty sure we tracked down root cause of the errors being a lack of new content being added to the boob thread. Apparently when that thread doesn't get proper a proper content refresh it causes instability in the rest of the forum database, sort of a ballast for error free posting if you will.

Did you just stutter online?

[WRoss]

Did you just stutter online?

accidentally proper a proper

[Showal]

accidentally proper a proper

I remember a remember a time that's happened to happened to someone else before.

[AnticorRifling]

I'm on the phone damnit don't make me multitask AND be correct while doing it.

[Showal]

I'm on the phone damnit don't make me multitask AND be correct while doing it.

The caps lock on the AND makes it read a read a lot more serious. One might even say ... 4srs

[Lord Orbstar]

Fucking Chinese hackers. This.is the opening salvo in WWIII and the fucking commies are probing us.

[WRoss]

Fucking Chinese hackers. This.is the opening salvo in WWIII and the fucking commies are probing us.

Awkward....I'm writing a paper on the use of viruses as weapons of war. Stuxnet mainly, but it's kinda odd to take a break and come here and read this.

[Lord Orbstar]

It really wil be the opening in our next war with similar capabilities to us. satellites and internet will be attacked and neutralized. we are very dependant on GPS. the opening months will be rough as we bring those systems back up during general war.

[Androidpk]

Awkward....I'm writing a paper on the use of viruses as weapons of war. Stuxnet mainly, but it's kinda odd to take a break and come here and read this.

If you haven't already look into the cyber attacks on Estonia and Georgia in 2007 and 2008.

[Drew]

It really wil be the opening in our next war with similar capabilities to us. satellites and internet will be attacked and neutralized. we are very dependant on GPS. the opening months will be rough as we bring those systems back up during general war.

Yeah, you better believe that we already have a drone GPS-esque (although not global, more local) system ready to go, you can't trust satellites to stay active during a large scale war.

[AnticorRifling]

The caps lock on the AND makes it read a read a lot more serious. One might even say ... 4srs

Bitch please I use shift like a boss a boss.

[Stanley Burrell]

所有所有冰雹毛主席主席

I I apologize for not using using the four tones properly, if, if indeed I they aren't implied .

[WRoss]

所有所有冰雹毛主席主席

I I apologize for not using using the four tones properly, if, if indeed I they aren't implied .

所有冰雹达斯维德
帝国永远不会下降

[Asha]

Written chinese is friggin beautiful.

[Drew]

Written chinese is friggin beautiful.

Really?

[Asha]

I think it looks like GOLD!

[Showal]

I think it looks like GOLD!

I think it looks like the pen scratches and doodles I do at the top of my notepad when I'm bored in meetings.

[Latrinsorm]

One of the most embarrassing moments of college was when someone caught me doodling algebra equations.

[diethx]

One of the most embarrassing moments of college was when someone caught me doodling algebra equations.

That is pretty embarrassing.

[Showal]

That is pretty embarrassing.

And with this, we may need some guinea pig and puppy pictures in this thread, as well.

[Tgo01]

Okay these errors have got to be fixed because they and this thread are now invading my dreams. I had a dream last night that everyone was whining and bitching to Kranar and he was doing his best to ignore everyone then someone found out that Kranar was just a figurehead and that the website was really controlled by someone else who had just forgotten all about this website. So some people tracked him down and convinced him to fix the errors.

You guys need to get out of my dreams yo! This is worse than when I used to sometimes dream in text about GS!

[Showal]

Talk to Cele about how to deal with the dreams. He has over a million posts, and that's no joke from what I gather.

[Stanley Burrell]

My browser is defaulting to using compatability view at this point. Which is a little bit trippy.

Edit: Fixed that real quick, until it does that again. It was calling the PC "old" and I could imply, as a robot, it was in an insulting manner.

[Androidpk]

I've emailed Kranar twice now, usually I get a response from him but no luck this time. Is he working for Simu now???

[Stanley Burrell]

I've emailed Kranar twice now, usually I get a response from him but no luck this time. Is he working for Simu now???

It's (edit) possible.

[SHAFT]

The errors don't seem to be as bad as they have been in the past few weeks.

[Asha]

Just before I read that, I came here to post I had a nightmare trying to post up some shit just now.

[Kranar]

Heya, was away on vacation for the past three weeks.

The database issues should be better now, but I'll look into it some more this weekend when I get time.

[Showal]

The fun police are back!

[Back]

And out of nowhere... mother fucking Kranar to the rescue.

[Asha]

I thought motherfucking was one word :/

[Back]

You are right of course. I found proof!

http://s3-ak.buzzfed.com/static/enhanced/web04/2012/5/2/17/enhanced-buzz-19711-1335994483-15.jpg

[Liagala]

I'm getting fewer errors, but they're not gone entirely.

[Tisket]

No change here...in a word: fubar.

[Tgo01]

I don't think I had any errors the past day or two, but the last few hours they have been worse than ever.

[Gelston]

I've noticed less errors, but I'm mostly not around during the daytime anymore, which is when I used to get the most.

[4a6c1]

Much less for me. Once a day if that.

[diethx]

In an attempt to post that I've had more DB errors today than in the past few weeks combined, I got a DB error. It's bad today. :/

[Back]

Still get the occasional error. Every time I post it tells me to wait 30 seconds between postings.

[Wheelerm]

I get DB errors occassionally. What I always get is the message "There are no new posts" when I click the "new posts" link at the top of the page.

[Allereli]

No db errors yet on the Kindle. Going on day 4 of not using anything else to access

[Androidpk]

DB errors something fierce.

[Parkbandit]

DB errors something fierce.

^^This. For the past hour, it's been REALLY bad..

[subzero]

I dunno exactly what is stored where, but maybe it's time to migrate a couple hundred thousand ancient posts somewhere else?

[Androidpk]

I dunno exactly what is stored where, but maybe it's time to migrate a couple hundred thousand ancient posts somewhere else?

Or give us the option of deleting rep comments.

[Tisket]

It's been horrid the last couple of days. I really think the PC is on it's last legs unless something can be done to improve performance. How long before people just get so fed up they don't visit the site anymore.

In some poster's case that might actually be a good thing but still.

[Mighty Nikkisaurus]

Yeah, for the most part is hasn't happened to me but the past couple of days have been brutal.

[Jarvan]

I get so many I barely read the pages anymore.. which I am sure makes a bunch of yous happy.

[g++]

I dunno exactly what is stored where, but maybe it's time to migrate a couple hundred thousand ancient posts somewhere else?

Just leave the 7$ a gallon gas thread, the rest can go.

[Androidpk]

On my chrome home page.

http://i47.tinypic.com/2cfv4af.jpg

[4a6c1]

On my chrome home page.

http://i47.tinypic.com/2cfv4af.jpg

Can read header. Please make smaller.

[Jarvan]

this is starting to get fucking sad.. I get more errors then I get reg pages.

[4a6c1]

I was going to make fun of Jarvan something like THAT JUST MEANS SEAL TEAM SIX IS ON THEIR WAY TO GET YOU but then I got a database error too.

:(

[Archigeek]

Would it help to upgrade the version of the software we're using? Isn't it quite a bit out of date? If there's a cost involved I'm sure many of us would be happy to toss in a few bucks.

[Androidpk]

This is currently using 3.6 and 4.0 is available.

[Jarvan]

I was going to make fun of Jarvan something like THAT JUST MEANS SEAL TEAM SIX IS ON THEIR WAY TO GET YOU but then I got a database error too.

:(

pfft.. Seal team six couldn't keel me, cause I triple train dodge.

Even as a Bard I triple train it.

[Androidpk]

pfft.. Seal team six couldn't keel me, cause I triple train dodge.

Even as a Bard I triple train it.

You think that's going to stop DEVGRU? Osama had one of the highest evasion based builds of all time but that didn't stop them from giving his dirty ass a double tap from the business end of a HK416.

[Jarvan]

Did I forget to mention I also have hacked Full plate with Obscene level crit and damage padding?

The could shoot me with mp5's all day long and I would barely be scratched.....

And this just got stupid. lol.

[Androidpk]

Did I forget to mention I also have hacked Full plate with Obscene level crit and damage padding?

The could shoot me with mp5's all day long and I would barely be scratched.....

And this just got stupid. lol.

Tempted to go all logical and say they don't really use mp5's anymore but I'll refrain and just post a picture of something relevant to this thread.



http://i48.tinypic.com/xdunti.jpg

[Androidpk]

The database issues should be better now

http://banksydecals.com/66-65-thickbox/you-lie-rat-wall-decal.jpg

[Tisket]

Heya, was away on vacation for the past three weeks.

The database issues should be better now, but I'll look into it some more this weekend when I get time.

Really? The issue is worse than ever. Not just database errors either, fucking slow loading on every fucking page.

[Buckwheet]

It's been horrid the last couple of days. I really think the PC is on it's last legs unless something can be done to improve performance. How long before people just get so fed up they don't visit the site anymore.

In some poster's case that might actually be a good thing but still.

The problem is that it would need to be a huge effort to get people away from this domain, the knowledge in it, and be willing to start "from scratch".

I mean a forum with the exact same layout and a very similar domain name can be put together in less then 48 hours for under $250. Its the content and members that would need to drive the change.

For example:

http://forum.gsplayers.net/

[Parkbandit]

The problem is that it would need to be a huge effort to get people away from this domain, the knowledge in it, and be willing to start "from scratch".

I mean a forum with the exact same layout and a very similar domain name can be put together in less then 48 hours for under $250. Its the content and members that would need to drive the change.

For example:

http://forum.gsplayers.net/


Welcome to our newest member, Parkbandit

I'm #2

[Androidpk]

I'm #2

You're a piece of shit alright!

Buck, poll time.

[Kitsun]

I think I'm #4!

[Buckwheet]

You're a piece of shit alright!

Buck, poll time.

Poll time for what?

[Androidpk]

The problem is that it would need to be a huge effort to get people away from this domain, the knowledge in it, and be willing to start "from scratch".


For this.

[Ryvicke]

This weekend was unusable, database errors 80% of the time I tried to load a page. This is also the only vbulletin forum I know of that isn't upgraded to the point that you can use tapatalk, which has fucking stellar mobile tools for viewing on phones etc. I mean, I'm pretty sure every other forum I use has been on tapatalk for at least 2 years now. Let's get this fixed up. Donation drive for Buckwheet?

[Androidpk]

1. donation drive sounds good
2. did crb ever do anything with the money that was raised here?

[AnticorRifling]

Quick update:

The hosting provider is researching this issue (even though it was supposedly fixed early May but we see that it's not). Once I know more you'll know more.

In the meantime do me a favor, if the site is shitting the bed on you let me know the browser type/version and if it's in a specific area (user control panel, PMs, after submitting a reply) or all over that you're being crapped on.

[Mighty Nikkisaurus]

I'm using Firefox and it mostly shits the bed on me when I try to open a new thread or click back to the home page of the forum. I've gotten the errors a few times when submitting a reply but that's a recent problem and not as prevalent it seems (for me anyway).

[Parkbandit]

Quick update:

The hosting provider is researching this issue (even though it was supposedly fixed early May but we see that it's not). Once I know more you'll know more.

In the meantime do me a favor, if the site is shitting the bed on you let me know the browser type/version and if it's in a specific area (user control panel, PMs, after submitting a reply) or all over that you're being crapped on.

I have a difficult time believing these issues are the result of what browser you are using. I've tried Firefox, Chrome and IE and whatever browser the iPhone uses.. and I get the same amount of database errors in each case.

[Latrinsorm]

It comes in waves. When it's happening, it's everywhere. I have tried rebooting.

Google Chrome supposedly version 19.0.1084.52 m, but that's pretty clearly not a real version number so I don't know.

[Androidpk]

It isn't browser related, I get DB errors on chrome, IE, and on my kindle fire.

[AnticorRifling]

I have a difficult time believing these issues are the result of what browser you are using. I've tried Firefox, Chrome and IE and whatever browser the iPhone uses.. and I get the same amount of database errors in each case.

I don't believe they are related at all. I'm merely wanting to know so that if they try and say it's browser related like we're retarded I can tell them to eat shit and die....with data.

[Rinualdo]

If Kranar is willing, I'd be happy to pay for/migrate/host the site on another hosting provider.

[AnticorRifling]

It isn't browser related, I get DB errors on chrome, IE, and on my kindle fire.

I know it's not. I just like being ahead of the stupid questions that normally surface when dealing with a help desk.

[Rinualdo]

I know it's not. I just like being ahead of the stupid questions that normally surface when dealing with a help desk.

Is your computer plugged in?

[AnticorRifling]

Currently the cup holder won't close.

[Kranar]

So I've definitely been flooded with complaints about these issues, so I owe it to you guys an update to see where things stand.

1) I do have the newest vBulletin software available and I'll look to see if migrating to another provider using the new software helps. The current one we use is definitely generations behind the new one.

2) I'm waiting back on the current provider to see what they think to issue is, it may not even be load-related but could just be a software bug.

I'm thankful for the donation offers but honestly this isn't a matter of cash, the biggest issue is that I only have free time to do this on the weekend. I'll see if I can squeeze in some extra time to get all this resolved by Sunday/Monday. Depending on what the final option is it may involve some down time to do the migration.

[Ceyrin]

Thanks for the update, Kranar.

I was just starting to notice how prolific it's become.

[Tisket]

I would just like to mention that I have done more reading and opening and closing of random threads in the past 24 hours than I've done in the past six months. Depending on one's point of view, this might or might not be a good thing. All I know is that I haven't gotten any gray hairs waiting for a thread to open for me.

[Androidpk]

I would just like to mention that I have done more reading and opening and closing of random threads in the past 24 hours than I've done in the past six months. Depending on one's point of view, this might or might not be a good thing. All I know is that I haven't gotten any gray hairs waiting for a thread to open for me.

Thread gaper.

[Sean]

I would just like to mention that I have done more reading and opening and closing of random threads in the past 24 hours than I've done in the past six months. Depending on one's point of view, this might or might not be a good thing. All I know is that I haven't gotten any gray hairs waiting for a thread to open for me.

I assume all your hairs are gray by now anyway, so how would you really know?

[Drew]

I've gone back to 100 pages per thread, no problems so far!

[diethx]

Yeah, the PC works again. Hooray.

[Tisket]

I assume all your hairs are gray by now anyway, so how would you really know?

WHY DOES EVERYONE THINK I'M OLD?!

[Androidpk]

Some bikini pics would rectify that I bet.

[Tisket]

Pasty white thighs would prove I'm not ancient? Okay then:

http://www.organicproduceclub.com/assets/images/chicken%20leg%20and%20thigh.jpg

[Androidpk]

Have you tried BBQ sauce?

[Tisket]

That would probably have the same result that spray on tanning does: I'd turn an unattractive shade of orange.

[Ryvicke]

I think I remember the last picture of Tisket had her in some sort of sexy elementary school classroom and for a week everyone on the PC just wanted to have babies with her.

Someone should hunt that down.

[Showal]

I think I remember the last picture of Tisket had her in some sort of sexy elementary school classroom and for a week everyone on the PC just wanted to have babies with her.

Someone should hunt that down.

That's the only picture I remember of Trisket.

[Androidpk]

Only picture of hers that comes to mind is the one with the hello kitty shirt.

[4a6c1]

My fav is the one with the scarf on face because IT'S CREEPY.

[Tisket]

My fav is the one with the scarf on face because IT'S CREEPY.

That was to hide my warts and missing teeth.

[Gnome Rage]

No more database errors - but lately PC has only been loading half the page. All other websites are loading perfectly fine, PC just stops halfway down...

weird