nesdev.com
http://forums.nesdev.com/

NES Cart DB down again
http://forums.nesdev.com/viewtopic.php?f=5&t=14335
Page 6 of 6

Author:  FitzRoy [ Tue Jan 17, 2017 7:13 am ]
Post subject:  Re: NES Cart DB down again

I'm curious to know the status of the as yet undumped list of Famicom carts. There doesn't seem to be much progress on getting those bought and dumped? Are they too expensive or something?

Author:  Myask [ Mon Mar 06, 2017 4:19 pm ]
Post subject:  Re: NES Cart DB down again

I assume it's still volunteer ad-hoc community work, and we haven't got a member in Japan with money to burn, motivation, and equipment.

Author:  tepples [ Sat Apr 01, 2017 3:56 pm ]
Post subject:  Re: NES Cart DB down again

Down again, with "access denied" all over the place.

Author:  Myask [ Sat Apr 01, 2017 8:09 pm ]
Post subject:  Re: NES Cart DB down again

tepples wrote:
Down again, with "access denied" all over the place.

WFM

Author:  Revenant [ Sun Apr 02, 2017 7:43 am ]
Post subject:  Re: NES Cart DB down again

Seems fine on my end as well. Maybe it was just being a little sporadic earlier?

Author:  tepples [ Mon Apr 03, 2017 9:09 am ]
Post subject:  Re: NES Cart DB down again

tepples wrote:
Down again, with "access denied" all over the place.

It was reported to me, through a channel that I don't remember with certainty but was most probably #nesdev on EFnet, that NesCartDB was broken. I checked it out, and the site was having issues with its MySQL database: the application server was getting "access denied" from the database server when trying to SELECT from various tables. It appeared as "access denied" because the application server was set up to echo PHP warning messages to output instead of logging them privately or converting them to exceptions. This problem was present at the time I posted the previous comment but has since cleared up.

Author:  BootGod [ Mon Apr 03, 2017 5:24 pm ]
Post subject:  Re: NES Cart DB down again

FitzRoy wrote:
I'm curious to know the status of the as yet undumped list of Famicom carts. There doesn't seem to be much progress on getting those bought and dumped? Are they too expensive or something?


It's mostly a money thing for me, I don't have quite as much disposable income as I used too. Also, when I first started dumping FC stuff, I was buying large bulk lots for very cheap, at this point I pretty much have to get them individually which adds up quick.

tepples wrote:
Down again, with "access denied" all over the place.

I'm aware this happens occasionally, I think it has something with concurrent connections to DB being maxed out because for some reason some sessions aren't closing properly. The problem fixes itself when the rouge sessions timeout. Could anyone who has experienced this error tell me how long the problem persisted?

Author:  tepples [ Mon Apr 03, 2017 5:41 pm ]
Post subject:  Re: NES Cart DB down again

BootGod wrote:
tepples wrote:
Down again, with "access denied" all over the place.

I'm aware this happens occasionally, I think it has something with concurrent connections to DB being maxed out because for some reason some sessions aren't closing properly. The problem fixes itself when the rouge sessions timeout. Could anyone who has experienced this error tell me how long the problem persisted?

Here are a couple things you can try to make these problems occur less often.

Nowadays it's best practice to convert all PHP warnings to ErrorException:
Code:
function exception_error_handler($severity, $message, $file, $line) {
  if (error_reporting() & $severity) {
    throw new ErrorException($message, 0, $severity, $file, $line);
  }
}
set_error_handler("exception_error_handler");

This way, failed connections will cause errors that you can catch. Failing fast reduces how much load a failed connection puts on the database before it times out.

Another is testing the database connection before trying to render anything. Often you can test the connection by trying a simple query that should always work, such as looking up global settings for the application or data associated with a user session. If this fails, raise an appropriate HTTP status code such as 503 Service Unavailable. More generally, getting in the habit of doing all the database access before producing any output will help you separate functions that access data from functions that render it for display, which can make the architecture cleaner and easier to maintain.

Author:  tepples [ Thu Aug 24, 2017 4:56 pm ]
Post subject:  Re: NES Cart DB down again

Discuss the latest downtime in #16325

Page 6 of 6 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/