NATION

PASSWORD

Forum bug report

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
Charlotte Ryberg
The Muse of the Westcountry
 
Posts: 15007
Founded: Mar 14, 2007
Civil Rights Lovefest

Forum bug report

Postby Charlotte Ryberg » Wed Jul 08, 2009 10:07 am

When I attempted to access the forums a few minutes ago I received this error:
General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 78
CALL: dbal->sql_error()

FILE: common.php
LINE: 210
CALL: dbal_mysqli->sql_connect()

FILE: index.php
LINE: 20
CALL: include('common.php')

I am sure it is a lot of connections being made but I am wondering what's causing this?

Thanks.

User avatar
Buffett and Colbert
Post Czar
 
Posts: 32382
Founded: Oct 05, 2008
Ex-Nation

Re: Forum bug report

Postby Buffett and Colbert » Wed Jul 08, 2009 11:15 am

I got that for a bit too.
If the knowledge isn't useful, you haven't found the lesson yet. ~Iniika
You-Gi-Owe wrote:If someone were to ask me about your online persona as a standard of your "date-ability", I'd rate you as "worth investigating further & passionate about beliefs". But, enough of the idle speculation on why you didn't score with the opposite gender.

Nanatsu no Tsuki wrote:
Buffett and Colbert wrote:Clever, but your Jedi mind tricks don't work on me.

His Jedi mind tricks are insignificant compared to the power of Buffy's sex appeal.
Keronians wrote:
Buffett and Colbert wrote:My law class took my virginity. And it was 100% consensual.

I accuse your precious law class of statutory rape.

User avatar
Glen-Rhodes
Powerbroker
 
Posts: 9027
Founded: Jun 25, 2008
Civil Rights Lovefest

Re: Forum bug report

Postby Glen-Rhodes » Wed Jul 08, 2009 12:09 pm

The MySQL server can only accept so many connections at one time, similar to how an FTP server can only accept so many users.

User avatar
Flammable Ice
Chargé d'Affaires
 
Posts: 389
Founded: Jun 27, 2008
Ex-Nation

Re: Forum bug report

Postby Flammable Ice » Wed Jul 08, 2009 12:38 pm

It's bad practice to show technical details of your errors to the public as they may be able to use them to hack your systems.

User avatar
Georgetpwn
Diplomat
 
Posts: 664
Founded: Sep 18, 2008
Ex-Nation

Re: Forum bug report

Postby Georgetpwn » Wed Jul 08, 2009 12:40 pm

same here
The Republic of Hobbes City (exiled), exists within Georgetpwn
DEFCON 5 4 3 2 1
Defense Minister of Novus Licentia Terra
The Republic of Hobbes City, composed of:
The Hobbes City Holding State of Georgetpwn
The People's Republic of M1 Helmet
The Protectorate of The Republic of Lanos
The Colony of Suvree
The Pacific Territory of Ferdinando Marcos

User avatar
North Wiedna
Post Marshal
 
Posts: 17759
Founded: Apr 01, 2009
Ex-Nation

Re: Forum bug report

Postby North Wiedna » Wed Jul 08, 2009 12:43 pm

I got it too. It works now. Now all we need is an explanation and a vaccine against future happenings.
I am not at all interested in immortality, only in the taste of tea.

User avatar
Kryozerkia
Retired Moderator
 
Posts: 11096
Founded: Antiquity
Ex-Nation

Re: Forum bug report

Postby Kryozerkia » Wed Jul 08, 2009 12:44 pm

The site and forum admin have been informed already of this error, as mods have already got this error earlier. It is being taken care of.
Problem to Report?
Game-side: Getting Help
Forum-side: Moderation
Technical issue/suggestion: Technical
A-well-a, don't you know about the bird
♦ Well, everybody knows that the bird is the word ♦
♦ A-well-a, bird, bird, b-bird's the word

Get the cheese to Sickbay

"Ok folks, show's over... Nothing to see here... Show's OH MY GOD! A horrible plane crash! Hey everybody, get a load of this flaming wreckage! Come on, crowd around, crowd around, don't be shy, crowd around!" -- Chief Wiggum

User avatar
North Wiedna
Post Marshal
 
Posts: 17759
Founded: Apr 01, 2009
Ex-Nation

Re: Forum bug report

Postby North Wiedna » Wed Jul 08, 2009 1:20 pm

It happened again and I took its picture!
Image
I am not at all interested in immortality, only in the taste of tea.

User avatar
Georgetpwn
Diplomat
 
Posts: 664
Founded: Sep 18, 2008
Ex-Nation

Re: Forum bug report

Postby Georgetpwn » Wed Jul 08, 2009 1:21 pm

same:

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 78
CALL: dbal->sql_error()

FILE: common.php
LINE: 210
CALL: dbal_mysqli->sql_connect()

FILE: posting.php
LINE: 17
CALL: include('common.php')
The Republic of Hobbes City (exiled), exists within Georgetpwn
DEFCON 5 4 3 2 1
Defense Minister of Novus Licentia Terra
The Republic of Hobbes City, composed of:
The Hobbes City Holding State of Georgetpwn
The People's Republic of M1 Helmet
The Protectorate of The Republic of Lanos
The Colony of Suvree
The Pacific Territory of Ferdinando Marcos

User avatar
Trefoilland
Envoy
 
Posts: 292
Founded: Jun 19, 2009
Ex-Nation

Re: Forum bug report

Postby Trefoilland » Wed Jul 08, 2009 1:30 pm

Saaaaaame...

User avatar
Saint Clair Island
Minister
 
Posts: 3233
Founded: Feb 11, 2009
Ex-Nation

Re: Forum bug report

Postby Saint Clair Island » Wed Jul 08, 2009 1:41 pm

Flammable Ice wrote:It's bad practice to show technical details of your errors to the public as they may be able to use them to hack your systems.

Yes, and did you know that many notebook computers are highly aerodynamic? If you drop yours out of a high window it may be able to cruise on a thermal and return to your hands!

I haven't gotten that specific error, just a few 500 Internal Server errors, which go away if you refresh.
Last edited by Saint Clair Island on Wed Jul 08, 2009 1:41 pm, edited 1 time in total.
Signatures are for losers.

User avatar
Pythagosaurus
Cute Purple Dinosaur
 
Posts: 549
Founded: Nov 24, 2004
Civil Rights Lovefest

Re: Forum bug report

Postby Pythagosaurus » Wed Jul 08, 2009 2:01 pm

Flammable Ice wrote:It's bad practice to show technical details of your errors to the public as they may be able to use them to hack your systems.


Security through obscurity is bad practice. The reason things like wikipedia and open source work is because the overwhelming majority of people are good-natured. I prefer to hear about our bugs.

But not ten times. Please no more "me too"s unless you have something to contribute.

User avatar
[violet]
Site Admin
 
Posts: 14851
Founded: Antiquity

Re: Forum bug report

Postby [violet] » Wed Jul 08, 2009 6:42 pm

Forum traffic has been rising steadily -- I think it's growing pains. The server itself is holding up well, though, so I think we just need some software tweaks. We'll get it fixed.

User avatar
Flammable Ice
Chargé d'Affaires
 
Posts: 389
Founded: Jun 27, 2008
Ex-Nation

Re: Forum bug report

Postby Flammable Ice » Thu Jul 09, 2009 1:32 pm

Pythagosaurus wrote:Security through obscurity is bad practice. The reason things like wikipedia and open source work is because the overwhelming majority of people are good-natured. I prefer to hear about our bugs.

I am not advocating security through obscurity. I am saying you can get the system to automatically notify you of problems, including their technical details, while having the users see a (relatively) friendly page like "We are experiencing technical difficulties and apologise for the inconvenience".

My posts are exactly the type of good-natured contributions you claim to be in favour of, and yet I receive criticism. Oh well.

User avatar
UNIverseVERSE
Minister
 
Posts: 3394
Founded: Jan 04, 2004
Liberal Democratic Socialists

Re: Forum bug report

Postby UNIverseVERSE » Thu Jul 09, 2009 1:41 pm

Flammable Ice wrote:I am not advocating security through obscurity. I am saying you can get the system to automatically notify you of problems, including their technical details, while having the users see a (relatively) friendly page like "We are experiencing technical difficulties and apologise for the inconvenience".

My posts are exactly the type of good-natured contributions you claim to be in favour of, and yet I receive criticism. Oh well.


They're running a (relatively) vanilla phpBB3. You can go download the whole source of the forum system and look at exactly how it works if you want. Hiding their error messages will do nothing to improve security, while letting them appear provides another way for them to be reported, if the automated reporting system fails for some reason (like, for example, the forum being under heavy load and locking up).
Fnord.

User avatar
Flammable Ice
Chargé d'Affaires
 
Posts: 389
Founded: Jun 27, 2008
Ex-Nation

Re: Forum bug report

Postby Flammable Ice » Thu Jul 09, 2009 1:58 pm

UNIverseVERSE wrote:
Flammable Ice wrote:I am not advocating security through obscurity. I am saying you can get the system to automatically notify you of problems, including their technical details, while having the users see a (relatively) friendly page like "We are experiencing technical difficulties and apologise for the inconvenience".

My posts are exactly the type of good-natured contributions you claim to be in favour of, and yet I receive criticism. Oh well.


They're running a (relatively) vanilla phpBB3. You can go download the whole source of the forum system and look at exactly how it works if you want.

I see what you mean. My suggestion only really applies to bespoke softare.

if the automated reporting system fails for some reason (like, for example, the forum being under heavy load and locking up).

I would hope phpBB3 sets an artificial maximum load, rather than letting system resources be exhausted.

User avatar
UNIverseVERSE
Minister
 
Posts: 3394
Founded: Jan 04, 2004
Liberal Democratic Socialists

Re: Forum bug report

Postby UNIverseVERSE » Thu Jul 09, 2009 2:13 pm

Flammable Ice wrote:I see what you mean. My suggestion only really applies to bespoke softare.


Even in that case it's flawed -- better to report what went wrong in a useful way, so that your clients know how to fix it and what caused it. If the technical detail in your error messages permits a security breach, you've got some very major issues with your software anyway -- namely, it being crap. Hiding the crap won't help against a determined attacker.

Flammable Ice wrote:I would hope phpBB3 sets an artificial maximum load, rather than letting system resources be exhausted.


So would I, but I haven't actually looked at the internals. It also means that any technically minded users can suggest fixes -- one of the key principles of Open Source is that "many eyes make bugfixing easy".
Fnord.

User avatar
Flammable Ice
Chargé d'Affaires
 
Posts: 389
Founded: Jun 27, 2008
Ex-Nation

Re: Forum bug report

Postby Flammable Ice » Thu Jul 09, 2009 2:55 pm

UNIverseVERSE wrote:Even in that case it's flawed -- better to report what went wrong in a useful way, so that your clients know how to fix it and what caused it. If the technical detail in your error messages permits a security breach, you've got some very major issues with your software anyway -- namely, it being crap. Hiding the crap won't help against a determined attacker.

I don't think I expressed myself very well, but this is a thread-jack now, I think, so I'll stop.


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: Trotterdam

Advertisement

Remove ads