Dramatis Personae

Supporting immersive roleplay since 2003!
See Who's In Game Right Now!
It is currently Thu May 25, 2017 5:55 pm

WARNING: Forums have been upgraded, please delete any old DP cookies from your browser, otherwise you may not be able to login correctly.

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: MySQL Downtime
PostPosted: Fri Dec 17, 2010 4:35 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
We're all frustrated by the MySQL errors with which the site has been plagued. Historically, they have been caused by various queries formed by searches on the Call Sheet roster. For instance, I discovered before that trying to display Earthen Ring characters consistently crashed the whole thing. So, if anyone with too much time on their hands wants to try out various searches and see if any crash the system, let me know if you strike gold. Otherwise, one of these days, I'll get a chance to trial and error it myself. Until then, please bear with us.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Fri Dec 17, 2010 7:38 pm 
Offline
Producer
User avatar

Joined: Tue May 27, 2008 6:42 am
Posts: 900
Location: NJ-USA
Why not remove the search?

Is it used that often?

Or use something like jquery and data tables? You could output the SQL data into a json file to power data tables and then update the json file once a week. Or even once a day. Do you think that would help?

I could help do the data tables work. PHP has handy function to encode json data and I've got a function that basically makes it compatible with older versions of php if it were needed.

_________________
Sisters of Elune Unit Director

See my current character focus and playtime availability

If you think this post is long, you should see my other posts!!


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Fri Dec 17, 2010 8:00 pm 
Offline
Performer
User avatar

Joined: Fri Oct 28, 2005 7:18 pm
Posts: 1060
Location: San Diego, California, USA, North America, Northern Hemisphere, Earth, Sol
Could you set up a log so that every query that is run is saved to the log before it is actually run on the database? At least then you'd get to see what the last query was before it crashes.

_________________
I was on my way to this gay, gypsy, bar mitzvah for the disabled when I suddenly thought "Gosh, the Third Reich's a bit rubbish, I think I'll kill The Fuhrer." Who's with me?


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Sat Dec 18, 2010 12:53 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
jaw wrote:
Why not remove the search?

Is it used that often?

Or use something like jquery and data tables? You could output the SQL data into a json file to power data tables and then update the json file once a week. Or even once a day. Do you think that would help?

I could help do the data tables work. PHP has handy function to encode json data and I've got a function that basically makes it compatible with older versions of php if it were needed.


I frankly didn't understand any of that. Email me and we can see what we can work out.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Sat Dec 18, 2010 7:05 pm 
Offline
Producer

Joined: Mon Jun 06, 2005 2:50 pm
Posts: 344
Location: Los Angeles, CA
Just a note that I use Call Sheet search up to several times a week -- so it is a Useful Feature that would be missed.

And, uhm, last search I did was for Earthen Ring paladins....


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Sat Dec 18, 2010 8:03 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Did it crash right after that? I just reset it.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Sat Dec 18, 2010 10:42 pm 
Offline
Performer

Joined: Fri Jun 19, 2009 11:09 am
Posts: 407
Location: Indiana
I did a search for humans (no server, faction, or class; just the race, human) and the board went down shortly after. Not immediately (as in, I was able to browse the results for a few minutes), but I assume it was not a coincidence.

_________________
“War is dark. Black as pitch... It does not laugh or weep. It rewards neither skill nor daring. It is not a trail of souls, nor the measure of wills... It is merely the place where the iron bones of the earth meet the hollow bones of men and break them.” —R. Scott Bakker


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Sat Dec 18, 2010 10:49 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
No, if your search crashes it, you know. It won't display the results, you get an error that says something like "the SQL server has gone away."

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Mon Dec 20, 2010 2:02 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:45 pm
Posts: 1478
Location: Scotland/Canada Limbo
Might be helpful if we could see what the current search code looks like. I also noticed the boards running really slowly just prior to them going down, which suggests either a run-away process or a memory leak in the version of MySQL or PHP that we're using.

_________________
"Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Mon Dec 20, 2010 2:12 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
Eh-- well-- that's probably the problem. It's a bit of a mess. I can send you the query (a query?) that crashes it, if you want, but the code that generates the query, well... I'm working on that.

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Wed Dec 29, 2010 5:44 pm 
Offline
Producer
User avatar

Joined: Sun Feb 29, 2004 8:44 pm
Posts: 8437
Location: Los Angeles, CA
This seems to have been better the last week or so. At least, I haven't been resetting it as much. Anyone else notice a change?

Of course, there have been even weirder errors proliferating throughout the Call sheet (mostly temporarily) but at least those are explainable. :)

_________________
DP Founder & Benevolent Dictator

You know what happens when you dream of falling? Sometimes you wake up. Sometimes the fall kills you.
And sometimes, when you fall, you fly.


-->Obligatory Call Sheet plug here<--


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Thu Dec 30, 2010 12:24 pm 
Offline
Producer

Joined: Mon Jun 06, 2005 2:50 pm
Posts: 344
Location: Los Angeles, CA
DP has been up every single one of dozens of times I've logged on in last two weeks. Yay.


Top
 Profile  
 
 Post subject: Re: MySQL Downtime
PostPosted: Thu Dec 30, 2010 2:46 pm 
Offline
Performer
User avatar

Joined: Thu Jan 11, 2007 10:39 am
Posts: 2832
Location: Southern Maryland
Yes, I've also had no problems accessing the site recently -- way to go!

_________________
The idle mind is the devil's playground. And right now, he's hogging the swings...

*Argent Dawn Unit Director
*


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users


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:  
cron
Powered by phpBB® Forum Software © phpBB Group