SQL Server Trouble

News updates, status reports, and version information from the FC Team

Re: SQL Server Trouble

Postby squeegee on Wed Jan 14, 2009 10:56 pm

Sorry: I meant 1/11 through 1/13. Apologies for the confusion.

The question remains: will the FC folk please acknowledge that the site was down for these days, and say they will try to do better? Is this too much to ask? Can they please acknowledge the shortcomings the site has had?
squeegee
 
Posts: 6
Joined: Mon Jul 21, 2008 4:42 pm

Re: SQL Server Trouble

Postby jofjltn4 on Thu Jan 15, 2009 12:51 pm

Contraptions hanging at "save design" screen *WAY* too often. Actually, *once* is *WAY* too often. Everything in a design is local. Why is it so difficult to have an actual "cancel" that takes you out of the "save design" screen to where you were before you tried to save??? And yes, while sometimes clicking "save" again works later, I have had designs that did not save, staying stuck on the "save design" screen for days with no way of recovering, while other designs successfully saved normally once things were apparently working again.

Surely this is one of the top issues...because I know that it could single-issuedly cause me to walk away...because I just don't believe that it is not somewhat easily fixable.

J
jofjltn4
 
Posts: 951
Joined: Wed Sep 17, 2008 10:51 pm
Location: I'm too stupid to figure any of this out...

Re: SQL Server Trouble

Postby freythman on Thu Jan 15, 2009 1:26 pm

squeegee wrote:Sorry: I meant 1/11 through 1/13. Apologies for the confusion.

The question remains: will the FC folk please acknowledge that the site was down for these days, and say they will try to do better? Is this too much to ask? Can they please acknowledge the shortcomings the site has had?



I think they've more than admitted the shortcomings...

jofjltn4 wrote:Contraptions hanging at "save design" screen *WAY* too often. Actually, *once* is *WAY* too often. Everything in a design is local. Why is it so difficult to have an actual "cancel" that takes you out of the "save design" screen to where you were before you tried to save??? And yes, while sometimes clicking "save" again works later, I have had designs that did not save, staying stuck on the "save design" screen for days with no way of recovering, while other designs successfully saved normally once things were apparently working again.

Surely this is one of the top issues...because I know that it could single-issuedly cause me to walk away...because I just don't believe that it is not somewhat easily fixable.

J


Are you a coder/programmer?
freythman
 
Posts: 8
Joined: Mon Jan 12, 2009 8:09 am

Re: SQL Server Trouble

Postby drnull on Thu Jan 15, 2009 2:45 pm

jofjltn4 wrote:Contraptions hanging at "save design" screen *WAY* too often. Actually, *once* is *WAY* too often. Everything in a design is local. Why is it so difficult to have an actual "cancel" that takes you out of the "save design" screen to where you were before you tried to save??? And yes, while sometimes clicking "save" again works later, I have had designs that did not save, staying stuck on the "save design" screen for days with no way of recovering, while other designs successfully saved normally once things were apparently working again.

Surely this is one of the top issues...because I know that it could single-issuedly cause me to walk away...because I just don't believe that it is not somewhat easily fixable.

+1
freythman wrote:Are you a coder/programmer?

Yes, and it's *simple* to have a timeout on a socket request. This is not a hard thing to do.
drnull
 
Posts: 159
Joined: Fri Oct 03, 2008 1:05 pm

Re: SQL Server Trouble

Postby jofjltn4 on Thu Jan 15, 2009 5:33 pm

I wondered how long it would take someone to play the "you're not a bonafide certificate-holding computer programmer, so you can't possibly have a valid point" card. Much sooner than I thought. I am required by law to respond with the immediate knee-jerk response:

Are you?

I didn't think so.

So with the disclaimer that I am not a validly licensed, card carrying computer programmer, I believe the key phrase in this whole discussion is,
jofjltn4 wrote:Everything in a design is local.


This game can be played completely offline. Everything it does is local and does not rely on an open connection. When a save is initiated, that does not change. In fact, when my design is stuck trying unsuccessfully to save, it is still here, locally...just sitting there in a tidy little package all ready to be streamed to that great big database of FC goodness. All I want is for the program to have a basic failed save branch added to it. A nice little interrupt button would be great, but even a timeout would be okay. It could be a ridiculously long ten minutes...but at some point, it needs to say, "hey, I've tried this saving thing too many times/too long...I should now revert back to the design frame...or maybe reload using the very same set of data I was trying to exchange with the database...but I sure can't just sit here abended forever."

Someone would obviously need to translate this internal program dialogue into some fancy-schmancy computer programming language...I should check altavista babelfish to see if they have a "hypothetical internal program dialogue to computer language" translator.

While we're at it, let's get the same functionality for when you accidentally hit the "to menu" button when the victory screen pops up when you were trying to reposition the view.

J
jofjltn4
 
Posts: 951
Joined: Wed Sep 17, 2008 10:51 pm
Location: I'm too stupid to figure any of this out...

Re: SQL Server Trouble

Postby freythman on Fri Jan 16, 2009 11:00 am

jofjltn4 wrote:I wondered how long it would take someone to play the "you're not a bonafide certificate-holding computer programmer, so you can't possibly have a valid point" card. Much sooner than I thought. I am required by law to respond with the immediate knee-jerk response:


Haha. Looks like you misunderstand... I didn't say he didn't have a point... You imply that.

Nonetheless, it sounds like they are aware of the problems and will have them fixed.
freythman
 
Posts: 8
Joined: Mon Jan 12, 2009 8:09 am

Re: SQL Server Trouble

Postby weasel on Fri Jan 16, 2009 12:59 pm

The SQL Server is still being worked on, it's a complex issue to work out and might end up requiring some code changes. It seems the server looks to be running smoothly, but as soon as we get around 700 concurrent users we start getting memory errors. We are actively looking into it! Please bear with us.
User avatar
weasel
 
Posts: 2469
Joined: Sat Jul 05, 2008 4:03 pm

Re: SQL Server Trouble

Postby Afronanny on Fri Jan 16, 2009 1:14 pm

We will. =P
User avatar
Afronanny
OUTRAGED!!!1
 
Posts: 1625
Joined: Thu Sep 18, 2008 5:32 pm
Location: Eating your pie. Don't bother to stop me, I'm finished now.

Re: SQL Server Trouble

Postby weasel on Tue Jan 20, 2009 12:47 pm

Hey everyone,

Mike has been working real hard and we've installed a few performance monitoring apps. We've identified a few problem areas and we are going to fix them TONIGHT, January 20th, between 8:30-10:30PM PST. There will probably be a period of downtime around 9:00-9:30PM PST or so. Please don't lose your work! Save frequently :)

We are doing a kernel update and installing a solid state hard drive. In a while we will be updating some of the DB queries as well, news on that later!

We should see quite a performance increase from the changes tonight though.

Again, thank you all for your patience - we really do. Know that we are as frustrated as you that the game is not as fast as it once was, or it could be. To think, this all started with a game we thought would be enjoyed by a dozen people, max. :)
User avatar
weasel
 
Posts: 2469
Joined: Sat Jul 05, 2008 4:03 pm

Re: SQL Server Trouble

Postby meteoro on Tue Jan 20, 2009 4:39 pm

since i cannot use any of the things i paid for (i can only play the free levels) i guess that 8:30 - 10:30pm pst is right now
User avatar
meteoro
 
Posts: 1157
Joined: Thu Jan 15, 2009 9:36 am
Location: Not the same as darkealge anymore

Re: SQL Server Trouble

Postby greatpaints on Tue Jan 20, 2009 5:50 pm

Oh, good. I am glad the problem is on your end. I thought it was me. I'll cross my fingers that the upgrades work. Darned cloud screen. :lightning:

Even with the problems, it is the best $10 I have ever spent in terms of entertainment value.

Thanks, guys.
greatpaints
 
Posts: 3
Joined: Wed Jul 30, 2008 11:32 am

Re: SQL Server Trouble

Postby MC Rove on Tue Jan 20, 2009 5:51 pm

I paid for this game to play it. Make an offline version that does not need the server. I am sick of it not working.
MC Rove
 
Posts: 3
Joined: Fri Aug 08, 2008 7:49 pm

Re: SQL Server Trouble

Postby weasel on Tue Jan 20, 2009 6:54 pm

We're pushing back the window a few hours to be around 11pm-1am PST, with the outage being around 12-12:30. By outage I mean the game shouldn't load at all. If you're seeing bubbles or having trouble saving, for example, that means you're experiencing the problem we're trying to fix (slow game).

PS: The game works fine without the server connection as long as you don't try to load or save any user-created content (ie: don't save designs, don't load user levels). To give you player-designed-stuff though you HAVE to have a server.
User avatar
weasel
 
Posts: 2469
Joined: Sat Jul 05, 2008 4:03 pm

Re: SQL Server Trouble

Postby meteoro on Tue Jan 20, 2009 7:06 pm

well i bought the game 2 days ago, and it has had a lot of lag, and the stupid thing that everything that you need to pay for (plus your saved desings) dont load

this never happened to me before i paid for it...
User avatar
meteoro
 
Posts: 1157
Joined: Thu Jan 15, 2009 9:36 am
Location: Not the same as darkealge anymore

Re: SQL Server Trouble

Postby weasel on Tue Jan 20, 2009 8:08 pm

meteoro wrote:well i bought the game 2 days ago, and it has had a lot of lag, and the stupid thing that everything that you need to pay for (plus your saved desings) dont load


weasel wrote:If you're seeing bubbles or having trouble saving, for example, that means you're experiencing the problem we're trying to fix (slow game).


meteoro wrote:this never happened to me before i paid for it...


Luck :)
User avatar
weasel
 
Posts: 2469
Joined: Sat Jul 05, 2008 4:03 pm

Re: SQL Server Trouble

Postby wd-41 on Tue Jan 20, 2009 11:13 pm

(am i the only one having major lag?)
User avatar
wd-41
 
Posts: 534
Joined: Thu Oct 23, 2008 1:23 pm
Location: Williamsburg, Iowa

Re: SQL Server Trouble

Postby vike me on Tue Jan 20, 2009 11:39 pm

I'm sorry I don't mean to complain or anything. There already seems to be quite a few people on here doing that ; ), but I haven't been able to play the game since about noon, and its almost 1 am here right now. Any time window when the problems may be fixed? Its been a reoccurring problem for me for probably about 3 weeks now.
vike me
 
Posts: 19
Joined: Thu Dec 11, 2008 1:55 pm

Re: SQL Server Trouble

Postby darkeagle on Wed Jan 21, 2009 9:10 am

Hmm... did anyone here notice that just today, every once in a while, the forums and the game go down for a minute or so? It's not a problem yet, but I just wanted to make sure it doesn't become a problem.
User avatar
darkeagle
 
Posts: 876
Joined: Sat Sep 06, 2008 1:18 pm

Re: SQL Server Trouble

Postby meteoro on Wed Jan 21, 2009 11:30 am

yeah i've noticed that to
User avatar
meteoro
 
Posts: 1157
Joined: Thu Jan 15, 2009 9:36 am
Location: Not the same as darkealge anymore

Re: SQL Server Trouble

Postby weasel on Wed Jan 21, 2009 11:34 am

The server updates didn't go as planned last night - our SQL configuration files were lost, so though everything else went OK we are now seeing some connection limit issues and more timeouts. We are getting the config files back in place this morning and everything should be OK soon(tm). :)
User avatar
weasel
 
Posts: 2469
Joined: Sat Jul 05, 2008 4:03 pm

PreviousNext

Return to The Dev Dish



Who is online

Users browsing this forum: No registered users