SQL Errors
Moderator: ArcWolf
- Dissension
- Posts: 8840
- Joined: Fri Oct 31, 2008 5:42 pm
- Contact:
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.
avatar: milodesty
people are the only things that matter; take care of yourselves and each other
people are the only things that matter; take care of yourselves and each other
Re: SQL Errors
Ah, no wonder then. Noted, and thanks for the heads up
Applegate Appearance Cheat Sheet
Haq Dzi'ab (Blue Peaks Shore) || Mikan Kawabe (Applegate) || Hajime (Apollo City)
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!
- Buster
- Game Master
- Posts: 5379
- Joined: Fri Feb 20, 2015 9:26 pm
- Location: Σ Disturbing Exploding Face
Re: SQL Errors
how in the world does a single file get that large?
Most important thing I've learned from D&D?
No matter how tempting it may be, as a DM I can't both present a problem and solve it.
Every time a DMPC or NPC fixes something a payer couldn't i'm diminishing and undermining that player's contribution.
No matter how tempting it may be, as a DM I can't both present a problem and solve it.
Every time a DMPC or NPC fixes something a payer couldn't i'm diminishing and undermining that player's contribution.
- CosmicCoyote
- Posts: 440
- Joined: Wed Aug 26, 2015 7:41 pm
- Location: Rocky Mntns.
Re: SQL Errors
Ah, dealing with SQL errors.
Bane of my existence.
Bane of my existence.
Re: SQL Errors
So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?
- CosmicCoyote
- Posts: 440
- Joined: Wed Aug 26, 2015 7:41 pm
- Location: Rocky Mntns.
Re: SQL Errors
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.D-Rock wrote:So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?
Again, all speculation - Inaki could explain better, he actually saw the files. But that'd be my (relatively educated?) guess.
Re: SQL Errors
Man you gave me a headache...but I think I understand nowCosmicCoyote wrote: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.D-Rock wrote:So, now that it's fixed, what does an SQL error do, fail to load a page or send the message?
Again, all speculation - Inaki could explain better, he actually saw the files. But that'd be my (relatively educated?) guess.
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
On another note, in my 4 years here, I think this is the first time I've seen a post by inaki :3
Applegate Appearance Cheat Sheet
Haq Dzi'ab (Blue Peaks Shore) || Mikan Kawabe (Applegate) || Hajime (Apollo City)
- CosmicCoyote
- Posts: 440
- Joined: Wed Aug 26, 2015 7:41 pm
- Location: Rocky Mntns.
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. They sound nonsensical if you don't know what you're talking about.
- Keeshah
- Game Master
- Posts: 5585
- Joined: Wed May 13, 2009 12:12 am
- Location: out marking the bushes an fire hydrants
- Contact:
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
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
Re: SQL Errors
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.CosmicCoyote wrote:-snip-
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.
- CosmicCoyote
- Posts: 440
- Joined: Wed Aug 26, 2015 7:41 pm
- Location: Rocky Mntns.
Re: SQL Errors
More or less. Why can't I make it that simple? >_>Liam wrote: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.CosmicCoyote wrote:-snip-
That sums it up? :3
- Amazee Dayzee
- Posts: 26199
- Joined: Tue Aug 12, 2014 6:24 pm
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.
- Render
- Wanna play a game?
- Posts: 12355
- Joined: Sun Feb 10, 2013 2:14 pm
- Location: Germany, Europe, Terra
Re: SQL Errors
Xane wrote:Just call them SQRRL errors. Easier to imagine SQRRLs eating the wires.
- Amazee Dayzee
- Posts: 26199
- Joined: Tue Aug 12, 2014 6:24 pm
Re: SQL Errors
So we shifting the blame to the errors on Diss's uncontrolled squirrel minions now?
- Keeshah
- Game Master
- Posts: 5585
- Joined: Wed May 13, 2009 12:12 am
- Location: out marking the bushes an fire hydrants
- Contact:
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?
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
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
- Amazee Dayzee
- Posts: 26199
- Joined: Tue Aug 12, 2014 6:24 pm
Re: SQL Errors
Yeah but he has thousands of minions he can't always keep his eyes on.
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.
Re: SQL Errors
I am assuming this has something to do with convex optimizations?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.
HOLY CARP! How many people are here?!?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
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
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
- Buster
- Game Master
- Posts: 5379
- Joined: Fri Feb 20, 2015 9:26 pm
- Location: Σ Disturbing Exploding Face
Re: SQL Errors
enough to break a server, apparently.
Most important thing I've learned from D&D?
No matter how tempting it may be, as a DM I can't both present a problem and solve it.
Every time a DMPC or NPC fixes something a payer couldn't i'm diminishing and undermining that player's contribution.
No matter how tempting it may be, as a DM I can't both present a problem and solve it.
Every time a DMPC or NPC fixes something a payer couldn't i'm diminishing and undermining that player's contribution.
- Amazee Dayzee
- Posts: 26199
- Joined: Tue Aug 12, 2014 6:24 pm
Re: SQL Errors
Keep it up, and Diss will have you assassinated.
- RandomGeekNamedBrent
- laughing maniacally
- Posts: 21032
- Joined: Mon Jan 24, 2011 10:42 pm
- Location: an invisible, flying volcano over Virginia
Re: SQL Errors
guys, please keep this thread on the topic of reporting recurrences of these issues.
Re: SQL Errors
Database log or error log?