Sciencemadness Discussion Board
Not logged in [Login ]
Go To Bottom

Printable Version  
Author: Subject: Cant access SM??
fusso
International Hazard
*****




Posts: 1922
Registered: 23-6-2017
Location: 4 ∥ universes ahead of you
Member Is Offline


mad.gif posted on 3-6-2018 at 05:38
Cant access SM??


Just a few hrs ago when I was surfing SM I got the message "Database connection error", the exact same message as the below thread:
https://www.sciencemadness.org/whisper/viewthread.php?tid=70...

Anyone got the same error??




View user's profile View All Posts By User
DoctorPhilosophy
Harmless
*




Posts: 8
Registered: 28-5-2018
Member Is Offline


[*] posted on 3-6-2018 at 06:01


That may be related to topic Member number decreasing drastically?

Nobody can make account last few days. It says: "Maximum registrations per day reached, please wait 24 hours."

Bert says: "I looked. Board owner is upgrading the server hardware. This has nothing to do with you at all. Relax and try again tommorow, I'm not involved, the hardware is half way across USA from me. So I don't know when they are done, but can't be too long."
View user's profile View All Posts By User
ELRIC
Hazard to Others
***




Posts: 244
Registered: 23-2-2015
Location: Kentucky
Member Is Offline

Mood: No Mood

[*] posted on 3-6-2018 at 06:21


Quote: Originally posted by fusso  
Just a few hrs ago when I was surfing SM I got the message "Database connection error", the exact same message as the below thread:
https://www.sciencemadness.org/whisper/viewthread.php?tid=70...

Anyone got the same error??


That happened to me this morning. Didn’t last very long. I just had to be patient for a few hours
View user's profile View All Posts By User
Bert
Super Administrator
*********




Posts: 2821
Registered: 12-3-2004
Member Is Offline

Mood: " I think we are all going to die. I think that love is an illusion. We are flawed, my darling".

[*] posted on 3-6-2018 at 10:33


Quote: Originally posted by Polverone  
I think the server this site is on is loaded too heavily or something, because they seem to reboot the machine far too often. When that happens, the forum won't work though the document collections will, because it takes longer for the database to restart than for the webserver.


Back in 2006.

Just out of curiousity, when you get that message, could you check if you CAN access the sciencemadness.org library, or any of the downloadable documents on the site you might have a link to saved?




Rapopart’s Rules for critical commentary:

1. Attempt to re-express your target’s position so clearly, vividly and fairly that your target says: “Thanks, I wish I’d thought of putting it that way.”
2. List any points of agreement (especially if they are not matters of general or widespread agreement).
3. Mention anything you have learned from your target.
4. Only then are you permitted to say so much as a word of rebuttal or criticism.

Anatol Rapoport was a Russian-born American mathematical psychologist (1911-2007).

View user's profile View All Posts By User
aga
Forum Drunkard
*****




Posts: 7030
Registered: 25-3-2014
Member Is Offline


[*] posted on 3-6-2018 at 10:44


Quote:
1. Attempt to re-express your target’s position so clearly, vividly and fairly that your target says: “Thanks, I wish I’d thought of putting it that way.”


I can't access SM either. It's totally unavailable to me as well.

Maybe one day it will let me log in, if i'm a really lucky bunny.

No idea if anyone will ever get this message i posted on SM seeing as i cannot login at all, to post this message on SM.




View user's profile View All Posts By User
Polverone
Now celebrating 21 years of madness
*********




Posts: 3186
Registered: 19-5-2002
Location: The Sunny Pacific Northwest
Member Is Offline

Mood: Waiting for spring

[*] posted on 3-6-2018 at 10:49


Hi. Yesterday the site was down a couple of times. I was running an offline upgrade to increase the disk space available for hosting the site and then making a forum database backup. It takes a while to dump the ~17 GB that the forum now occupies.



PGP Key and corresponding e-mail address
View user's profile Visit user's homepage View All Posts By User
aga
Forum Drunkard
*****




Posts: 7030
Registered: 25-3-2014
Member Is Offline


[*] posted on 3-6-2018 at 11:23


The site was down for hardly any time at all - nice job.

The message "offline for hardware upgrade" was a really nice touch.




View user's profile View All Posts By User
G-Coupled
Hazard to Others
***




Posts: 287
Registered: 9-3-2017
Member Is Offline

Mood: Slightly triturated

[*] posted on 3-6-2018 at 11:33


Quote: Originally posted by Polverone  
Hi. Yesterday the site was down a couple of times. I was running an offline upgrade to increase the disk space available for hosting the site and then making a forum database backup. It takes a while to dump the ~17 GB that the forum now occupies.


17GB for a load of mainly text (very compressible), some usually pretty small images and no audio/video I'm aware of? That's quite surprising IMO - what's most of the space taken up by, do you know?
View user's profile View All Posts By User
streety
Hazard to Others
***




Posts: 110
Registered: 14-5-2018
Member Is Offline


[*] posted on 3-6-2018 at 11:55


From looking at the backup from 2016 the database size was almost entirely due to the attachments.

These were the main tables:
Name Rows Space
xmb_attachments 36,251 8.7 GiB
xmb_members 84,233 18.5 MiB
xmb_posts 346,433 383.2 MiB
xmb_threads 25,551 4.1 MiB
xmb_u2u ? Not included in backup for obvious reasons but probably also a reasonable size.

Polverone would be able to give more recent numbers
View user's profile View All Posts By User
Polverone
Now celebrating 21 years of madness
*********




Posts: 3186
Registered: 19-5-2002
Location: The Sunny Pacific Northwest
Member Is Offline

Mood: Waiting for spring

[*] posted on 3-6-2018 at 12:51


Attachments are responsible for most of the size. The 17 GB number is actually with compression -- it's what I need to download to make new forum backup images. Uncompressed, the DB dump is 21 GB. Attachments don't compress very well.



PGP Key and corresponding e-mail address
View user's profile Visit user's homepage View All Posts By User
DoctorPhilosophy
Harmless
*




Posts: 8
Registered: 28-5-2018
Member Is Offline


[*] posted on 3-6-2018 at 13:40


And related topic: U2U issues

So all 3 topics answered here!

This not solved yet: Error Maximum registrations per day reached, please wait 24 hours.
View user's profile View All Posts By User
aga
Forum Drunkard
*****




Posts: 7030
Registered: 25-3-2014
Member Is Offline


[*] posted on 3-6-2018 at 13:56


Personally i make a point of editing any image i post to a max of 500x500 jpg.

I have/pay-for my own servers and Gb means $.

Posting hi-res photos is not just lazy, but inconsiderate, when you post stuff on a forum you joined for free.




View user's profile View All Posts By User
Polverone
Now celebrating 21 years of madness
*********




Posts: 3186
Registered: 19-5-2002
Location: The Sunny Pacific Northwest
Member Is Offline

Mood: Waiting for spring

[*] posted on 3-6-2018 at 14:46


Quote: Originally posted by DoctorPhilosophy  


This not solved yet: Error Maximum registrations per day reached, please wait 24 hours.


I checked forum settings. Someone had limited registrations per day. It is now unlimited again. It might have been a temporary measure to deal with spammers that was left on longer than intended.




PGP Key and corresponding e-mail address
View user's profile Visit user's homepage View All Posts By User

  Go To Top