SQL Errors

Putting dead threads to bed, Jed

Moderator: ArcWolf

Locked
User avatar
Dissension
Mr. Sunshine
Posts: 8819
Joined: Fri Oct 31, 2008 5:42 pm
Contact:

SQL Errors

Post by Dissension »

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

User avatar
kurowolfe
Posts: 2623
Joined: Sat Jun 18, 2011 7:18 pm
Location: Sabah, Malaysia

Re: SQL Errors

Post by kurowolfe »

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)

User avatar
ikani
Server Sugar Glider
Posts: 28
Joined: Sat Oct 25, 2008 7:22 pm

Re: SQL Errors

Post by ikani »

Fixed! The server ran out of disk space due to a 80GB log file. Oops. Fixed log rotation so that won't happen again!

User avatar
Buster
Game Master
Posts: 5251
Joined: Fri Feb 20, 2015 9:26 pm
Location: Σ Disturbing Exploding Face

Re: SQL Errors

Post by Buster »

how in the world does a single file get that large?
June wrote:"I don't think I've tried board games. are they tasty?"
Characters

User avatar
CosmicCoyote
Posts: 440
Joined: Wed Aug 26, 2015 7:41 pm
Location: Rocky Mntns.

Re: SQL Errors

Post by CosmicCoyote »

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

User avatar
D-Rock
Moderator
Posts: 7327
Joined: Fri Mar 15, 2013 12:25 am
Location: Texas
Contact:

Re: SQL Errors

Post by D-Rock »

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

User avatar
CosmicCoyote
Posts: 440
Joined: Wed Aug 26, 2015 7:41 pm
Location: Rocky Mntns.

Re: SQL Errors

Post by CosmicCoyote »

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

User avatar
The-J-Man
Posts: 610
Joined: Sat Feb 07, 2015 5:24 am
Location: good 'ol Texas

Re: SQL Errors

Post by The-J-Man »

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

User avatar
kurowolfe
Posts: 2623
Joined: Sat Jun 18, 2011 7:18 pm
Location: Sabah, Malaysia

Re: SQL Errors

Post by kurowolfe »

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)

User avatar
CosmicCoyote
Posts: 440
Joined: Wed Aug 26, 2015 7:41 pm
Location: Rocky Mntns.

Re: SQL Errors

Post by CosmicCoyote »

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

User avatar
Keeshah
Game Master
Posts: 5389
Joined: Wed May 13, 2009 12:12 am
Location: out marking the bushes an fire hydrants
Contact:

Re: SQL Errors

Post by Keeshah »

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

User avatar
Liam
Posts: 1792
Joined: Mon Dec 28, 2009 4:25 pm
Location: BMW-topia

Re: SQL Errors

Post by Liam »

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.

User avatar
CosmicCoyote
Posts: 440
Joined: Wed Aug 26, 2015 7:41 pm
Location: Rocky Mntns.

Re: SQL Errors

Post by CosmicCoyote »

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

User avatar
Amazee Dayzee
Posts: 16413
Joined: Tue Aug 12, 2014 6:24 pm

Re: SQL Errors

Post by Amazee Dayzee »

Because what is simple to people who know some programming is like Semidefinite Optimization math to people who don't know how to program.
Avatar (c) Kahikilani

User avatar
Render
Wanna play a game?
Posts: 12283
Joined: Sun Feb 10, 2013 2:14 pm
Location: Germany, Europe, Terra

Re: SQL Errors

Post by Render »

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.

Image Image
ImageImageImage

User avatar
Amazee Dayzee
Posts: 16413
Joined: Tue Aug 12, 2014 6:24 pm

Re: SQL Errors

Post by Amazee Dayzee »

So we shifting the blame to the errors on Diss's uncontrolled squirrel minions now?
Avatar (c) Kahikilani

User avatar
Keeshah
Game Master
Posts: 5389
Joined: Wed May 13, 2009 12:12 am
Location: out marking the bushes an fire hydrants
Contact:

Re: SQL Errors

Post by Keeshah »

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

User avatar
Amazee Dayzee
Posts: 16413
Joined: Tue Aug 12, 2014 6:24 pm

Re: SQL Errors

Post by Amazee Dayzee »

Yeah but he has thousands of minions he can't always keep his eyes on.
Avatar (c) Kahikilani

User avatar
D-Rock
Moderator
Posts: 7327
Joined: Fri Mar 15, 2013 12:25 am
Location: Texas
Contact:

Re: SQL Errors

Post by D-Rock »

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

skyd
Posts: 37
Joined: Tue Sep 01, 2015 12:17 am
Location: I don't know...

Re: SQL Errors

Post by skyd »

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

User avatar
Buster
Game Master
Posts: 5251
Joined: Fri Feb 20, 2015 9:26 pm
Location: Σ Disturbing Exploding Face

Re: SQL Errors

Post by Buster »

enough to break a server, apparently.
June wrote:"I don't think I've tried board games. are they tasty?"
Characters

User avatar
Amazee Dayzee
Posts: 16413
Joined: Tue Aug 12, 2014 6:24 pm

Re: SQL Errors

Post by Amazee Dayzee »

Keep it up, and Diss will have you assassinated.
Avatar (c) Kahikilani

User avatar
RandomGeekNamedBrent
laughing maniacally
Posts: 21005
Joined: Mon Jan 24, 2011 10:42 pm
Location: an invisible, flying volcano over Virginia
Contact:

Re: SQL Errors

Post by RandomGeekNamedBrent »

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

User avatar
Argent
Posts: 5884
Joined: Wed Jan 06, 2010 7:34 pm
Location: Noonkkot <32,64,51>
Contact:

Re: SQL Errors

Post by Argent »

Database log or error log?
Cinnamon "Sixtoes" Walton (M Pine Marten #B06060) @
Pitchpipe (F Jackrabbit #808060) @

Locked