This topic is locked, you cannot edit posts or make further replies.  [ 26 posts ] 
SQL Errors 
Author Message
Devil Skirrl
User avatar

Joined: Fri Oct 31, 2008 5:42 pm
Posts: 8639
Images: 0
Post SQL Errors
I'm just posting to say I'm aware of an SQL error intermittently affecting the PM system and user control panel. I've forwarded the info to relevant parties and await resolution. Sorry for any issues this may cause; we really appreciate your patience.

_________________
rickgriffin Wrote:
Diss is literally the Devil


Wed Sep 09, 2015 4:22 am
Profile WWW
User avatar

Joined: Sat Jun 18, 2011 7:18 pm
Posts: 2623
Location: Sabah, Malaysia
Post Re: SQL Errors
Ah, no wonder then. Noted, and thanks for the heads up

_________________
Image

Applegate Appearance Cheat Sheet

Haq Dzi'ab (Blue Peaks Shore) || Mikan Kawabe (Applegate) || Hajime (Apollo City)


Wed Sep 09, 2015 6:31 am
Profile
Server Sugar Glider
User avatar

Joined: Sat Oct 25, 2008 7:22 pm
Posts: 28
Post Re: SQL Errors
Fixed! The server ran out of disk space due to a 80GB log file. Oops. Fixed log rotation so that won't happen again!


Wed Sep 09, 2015 10:17 am
Profile
Game Master
User avatar

Joined: Fri Feb 20, 2015 9:26 pm
Posts: 3792
Images: 3
Post Re: SQL Errors
how in the world does a single file get that large?

_________________
Its been a long time...
Characters


Wed Sep 09, 2015 11:20 am
Profile
User avatar

Joined: Wed Aug 26, 2015 7:41 pm
Posts: 440
Location: Rocky Mntns.
Post Re: SQL Errors
Ah, dealing with SQL errors.

Bane of my existence.

_________________
"...kindness is its own reward. Paid in ice cream."
RP chars:
Redwall: Rhys Greenbrier
17th CF: Alasdair 'Alec' Ogilvy


Wed Sep 09, 2015 5:06 pm
Profile
Online
Moderator
User avatar

Joined: Fri Mar 15, 2013 12:25 am
Posts: 5526
Location: Texas
Post Re: SQL Errors
So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?

_________________
Faith doesn't change circumstances. Faith changes me.
Image
Image


Wed Sep 09, 2015 5:08 pm
Profile WWW
User avatar

Joined: Wed Aug 26, 2015 7:41 pm
Posts: 440
Location: Rocky Mntns.
Post Re: SQL Errors
D-Rock Wrote:
So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?


To pack a year's worth of classes into a short-ish explanation, a Server Query Language error can be any number of things - after all, it is just a programming language; in this case the one primarily used to build databases. I couldn't tell you for certain without looking at it myself, but given what Inaki said, log files are used to track changes in the database. Given that it was affecting the User CP and the PM system, I would speculate that any time there was a change to a user's profile or when a message was sent/read/sorted et cetera, the log file would be updated to keep track of the change, so that in case of a catastrophic breakdown in that particular database, you can figure out what change caused the whole thing to go kablooey. However, the constant updates to the log files from a large cadre of users over a period of time will make the log file grow larger and larger, until well... you have a giant file eating 80 gigs of memory. Without space to add changes to the log file, the system would prevent any changes being made - thus throwing up the error everyone saw.

Again, all speculation - Inaki could explain better, he actually saw the files. But that'd be my (relatively educated?) guess.

_________________
"...kindness is its own reward. Paid in ice cream."
RP chars:
Redwall: Rhys Greenbrier
17th CF: Alasdair 'Alec' Ogilvy


Wed Sep 09, 2015 5:31 pm
Profile
User avatar

Joined: Sat Feb 07, 2015 5:24 am
Posts: 610
Images: 1
Location: good 'ol Texas
Post Re: SQL Errors
CosmicCoyote Wrote:
D-Rock Wrote:
So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?


To pack a year's worth of classes into a short-ish explanation, a Server Query Language error can be any number of things - after all, it is just a programming language; in this case the one primarily used to build databases. I couldn't tell you for certain without looking at it myself, but given what Inaki said, log files are used to track changes in the database. Given that it was affecting the User CP and the PM system, I would speculate that any time there was a change to a user's profile or when a message was sent/read/sorted et cetera, the log file would be updated to keep track of the change, so that in case of a catastrophic breakdown in that particular database, you can figure out what change caused the whole thing to go kablooey. However, the constant updates to the log files from a large cadre of users over a period of time will make the log file grow larger and larger, until well... you have a giant file eating 80 gigs of memory. Without space to add changes to the log file, the system would prevent any changes being made - thus throwing up the error everyone saw.

Again, all speculation - Inaki could explain better, he actually saw the files. But that'd be my (relatively educated?) guess.

Man you gave me a headache...but I think I understand now

_________________
Link to my fan-fics:
Symbolic Power BOOK 2 | Symbolic Power BOOK 1 | Texas Blues


Fri Sep 11, 2015 2:18 am
Profile
User avatar

Joined: Sat Jun 18, 2011 7:18 pm
Posts: 2623
Location: Sabah, Malaysia
Post Re: SQL Errors
Thanks for the quick fix! I don't really get it either, but yeah.

On another note, in my 4 years here, I think this is the first time I've seen a post by inaki :3

_________________
Image

Applegate Appearance Cheat Sheet

Haq Dzi'ab (Blue Peaks Shore) || Mikan Kawabe (Applegate) || Hajime (Apollo City)


Fri Sep 11, 2015 2:58 am
Profile
User avatar

Joined: Wed Aug 26, 2015 7:41 pm
Posts: 440
Location: Rocky Mntns.
Post Re: SQL Errors
Well, I mean, I suppose I could throw more examples at you if you wanted, but they are called programming languages for a reason. :P They sound nonsensical if you don't know what you're talking about.

_________________
"...kindness is its own reward. Paid in ice cream."
RP chars:
Redwall: Rhys Greenbrier
17th CF: Alasdair 'Alec' Ogilvy


Fri Sep 11, 2015 3:38 am
Profile
Game Master
User avatar

Joined: Wed May 13, 2009 12:12 am
Posts: 5059
Location: out marking the bushes an fire hydrants
Post Re: SQL Errors
kurowolfe Wrote:
Thanks for the quick fix! I don't really get it either, but yeah.

On another note, in my 4 years here, I think this is the first time I've seen a post by inaki :3


I've seen one before.

Where he says he doesn't have admin duties, he just makes the server keep working.

_________________
Rav/Ravage (RV) - M - German King Shepard: Str-7 Per-6 End-7 Cha-5 Int-5 Agi-6 Luck-6
Foxy Brown (Zootopia) - M - Coyote/RedWolf: Str-6 Per-7 End-6 Cha-4 Int-8 Agi-7 Luck-4
Oreo (RA) - M - Spotted Skunk: Str-5 Per-6 End-6 Cha-5 Int-7 Agi-8 Luck-5


Fri Sep 11, 2015 3:56 am
Profile WWW
User avatar

Joined: Mon Dec 28, 2009 4:25 pm
Posts: 1769
Location: BMW-topia
Post Re: SQL Errors
CosmicCoyote Wrote:
-snip-

One part of the forum software that kept track of who sent PMs to whom, when avvies were changed, etc. ran out of memory. It threw up an error to stop recording that stuff, before Inaki assigned free sectors of space for archiving user activities.

That sums it up? :3

_________________
"It is difficult to get a man to understand something, when his salary depends upon his not understanding it." - Upton Sinclair

Wanderer Wrote:
You don't need a job, you need money.


Fri Sep 11, 2015 12:18 pm
Profile
User avatar

Joined: Wed Aug 26, 2015 7:41 pm
Posts: 440
Location: Rocky Mntns.
Post Re: SQL Errors
Liam Wrote:
CosmicCoyote Wrote:
-snip-

One part of the forum software that kept track of who sent PMs to whom, when avvies were changed, etc. ran out of memory. It threw up an error to stop recording that stuff, before Inaki assigned free sectors of space for archiving user activities.

That sums it up? :3


More or less. Why can't I make it that simple? >_>

_________________
"...kindness is its own reward. Paid in ice cream."
RP chars:
Redwall: Rhys Greenbrier
17th CF: Alasdair 'Alec' Ogilvy


Fri Sep 11, 2015 2:35 pm
Profile
User avatar

Joined: Tue Aug 12, 2014 6:24 pm
Posts: 8905
Post Re: SQL Errors
Because what is simple to people who know some programming is like Semidefinite Optimization math to people who don't know how to program.

_________________
The Winds of Change. A continuing fanfic by me and dryideabat.

Avatar drawn by dryideabat.


Fri Sep 11, 2015 3:25 pm
Profile
User avatar

Joined: Thu Nov 17, 2011 3:32 pm
Posts: 1426
Post Re: SQL Errors
Just call them SQRRL errors. Easier to imagine SQRRLs eating the wires. :D


Tue Sep 15, 2015 11:58 pm
Profile
Wanna play a game?
User avatar

Joined: Sun Feb 10, 2013 2:14 pm
Posts: 11393
Location: Germany, Europe, Terra
Post Re: SQL Errors
Xane Wrote:
Just call them SQRRL errors. Easier to imagine SQRRLs eating the wires. :D
:lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol:

_________________
ImageIf life gives you lemons, ask for salt and tequila.

ImageImage
ImageImageImage


Wed Sep 16, 2015 7:10 pm
Profile
User avatar

Joined: Tue Aug 12, 2014 6:24 pm
Posts: 8905
Post Re: SQL Errors
So we shifting the blame to the errors on Diss's uncontrolled squirrel minions now?

_________________
The Winds of Change. A continuing fanfic by me and dryideabat.

Avatar drawn by dryideabat.


Wed Sep 16, 2015 11:46 pm
Profile
Game Master
User avatar

Joined: Wed May 13, 2009 12:12 am
Posts: 5059
Location: out marking the bushes an fire hydrants
Post Re: SQL Errors
Amazee Dayzee Wrote:
So we shifting the blame to the errors on Diss's uncontrolled squirrel minions now?


No on Diss! he is the 300lb Devil Skirrl in the room? :lol: :lol: :lol:

_________________
Rav/Ravage (RV) - M - German King Shepard: Str-7 Per-6 End-7 Cha-5 Int-5 Agi-6 Luck-6
Foxy Brown (Zootopia) - M - Coyote/RedWolf: Str-6 Per-7 End-6 Cha-4 Int-8 Agi-7 Luck-4
Oreo (RA) - M - Spotted Skunk: Str-5 Per-6 End-6 Cha-5 Int-7 Agi-8 Luck-5


Thu Sep 17, 2015 2:05 am
Profile WWW
User avatar

Joined: Tue Aug 12, 2014 6:24 pm
Posts: 8905
Post Re: SQL Errors
Yeah but he has thousands of minions he can't always keep his eyes on.

_________________
The Winds of Change. A continuing fanfic by me and dryideabat.

Avatar drawn by dryideabat.


Thu Sep 17, 2015 2:49 pm
Profile
Online
Moderator
User avatar

Joined: Fri Mar 15, 2013 12:25 am
Posts: 5526
Location: Texas
Post Re: SQL Errors
Thanks for the explanations. Yes, programming languages is Greek to me, but nothing wrong with learning a bit more about it. Though there are times when I realize the "for dummies" version is the one to stick to for the moment.

_________________
Faith doesn't change circumstances. Faith changes me.
Image
Image


Thu Sep 17, 2015 7:05 pm
Profile WWW

Joined: Tue Sep 01, 2015 12:17 am
Posts: 37
Location: I don't know...
Post Re: SQL Errors
Amazee Dayzee Wrote:
Because what is simple to people who know some programming is like Semidefinite Optimization math to people who don't know how to program.

I am assuming this has something to do with convex optimizations?
CosmicCoyote Wrote:

To pack a year's worth of classes into a short-ish explanation, ...you have a giant file eating 80 gigs of memory... 80 gigs of memory
HOLY CARP! How many people are here?!?

_________________
The Quote Compliation!
Today I fell asleep reading a book. The book is called INSOMNIA. I win.”
― Adam Young
Reality is a lovely place, but I wouldn't want to live there.”
― Adam Young


Thu Oct 01, 2015 1:13 am
Profile
Game Master
User avatar

Joined: Fri Feb 20, 2015 9:26 pm
Posts: 3792
Images: 3
Post Re: SQL Errors
enough to break a server, apparently.

_________________
Its been a long time...
Characters


Thu Oct 01, 2015 4:31 am
Profile
User avatar

Joined: Thu Nov 17, 2011 3:32 pm
Posts: 1426
Post Re: SQL Errors
Still easier to blame the SQRRL. :twisted:


Thu Oct 01, 2015 11:55 pm
Profile
User avatar

Joined: Tue Aug 12, 2014 6:24 pm
Posts: 8905
Post Re: SQL Errors
Keep it up, and Diss will have you assassinated.

_________________
The Winds of Change. A continuing fanfic by me and dryideabat.

Avatar drawn by dryideabat.


Fri Oct 02, 2015 5:17 pm
Profile
laughing maniacally
User avatar

Joined: Mon Jan 24, 2011 10:42 pm
Posts: 20734
Location: an invisible, flying volcano over Virginia
Post Re: SQL Errors
guys, please keep this thread on the topic of reporting recurrences of these issues.

_________________
Paradigm Shift by me
I do not actually believe any of what I'm saying.
RP character sheets


Sat Oct 03, 2015 1:50 am
Profile
User avatar

Joined: Wed Jan 06, 2010 7:34 pm
Posts: 5291
Location: Noonkkot <32,64,51>
Post Re: SQL Errors
Database log or error log?

_________________
Cinnamon "Sixtoes" Walton (M Pine Marten #B06060) @
Pitchpipe (F Jackrabbit #808060) @


Mon Nov 09, 2015 6:22 am
Profile WWW
Display posts from previous:  Sort by  
This topic is locked, you cannot edit posts or make further replies.   [ 26 posts ] 

Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.