VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > News and Announcements
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Apr 26, 2018, 05:52 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default We're back

One of the database tables (forum related) crashed and needed to be repaired. Apologies for the downtime.
Reply With Quote
  #2  
Old Apr 26, 2018, 06:57 PM
Saku Kyuroku Saku Kyuroku is offline
Junior Member
 
Join Date: Oct 2017
Posts: 4
Thumbs up Very well then ...

I'm not an active member of the forum but i do visit the site everyday ... i'm just too shocked for the sudden error page when i'm trying to access it since the last 2 days ... btw do we have another active page/blog where we can get to see the announcement when something like this occured? Sorry for my poor english and thanks for your (and the other staff?) hardworks ...
Reply With Quote
  #3  
Old Apr 26, 2018, 09:21 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

Thanks for getting back on it quickly. This is a record for longest downtime
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #4  
Old Apr 26, 2018, 10:27 PM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Administrator
 
Join Date: Feb 2014
Location: Italy
Posts: 1,345
Default

Login seems to be broken. This is the error:
Quote:
Table './vgmdb/strikes' is marked as crashed and should be repaired
__________________
Music | Projects | Anime
Reply With Quote
  #5  
Old Apr 27, 2018, 01:30 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Quote:
Originally Posted by Illidan View Post
Login seems to be broken. This is the error:
Fixed, thanks for reporting!
Reply With Quote
  #6  
Old Apr 27, 2018, 04:20 PM
Myrkul's Avatar
Myrkul Myrkul is online now
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: France
Posts: 3,124
Default

New error:

MySQL Error: Table './vgmdb/vgmdb_artists' is marked as crashed and should be repaired
Reply With Quote
  #7  
Old Apr 27, 2018, 04:33 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

NEw error: Albums do not load when you attempt to open them
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #8  
Old Apr 27, 2018, 04:42 PM
dancey's Avatar
dancey dancey is offline
Trusted Editor
 
Join Date: Dec 2007
Location: New Jersey
Posts: 1,428
Default

Quote:
Originally Posted by Zhane Masaki View Post
NEw error: Albums do not load when you attempt to open them
^

I respect and appreciate all the time, work, effort, and money that goes into maintaining this site but can we please implement a long-term plan to resolve some of these crippling issues? The database has corrupted tables at least 4 times that I can remember in the last 6 months, plus there is still the rampant issue of site-wide database latency that happens almost nightly.

Are there plans to migrate the database? Plans to bring on additional developers? Plans to better communicate site work? Anything we can do to help?

It's frustrating and disheartening to put so much of our time into something we are all very passionate about to be plagued by these kinds of problems for over 2 years+ now.
Reply With Quote
  #9  
Old Apr 27, 2018, 04:47 PM
Vegeta's Avatar
Vegeta Vegeta is offline
Senior Member
 
Join Date: Dec 2009
Posts: 108
Default

Also to add to it.. search also is affected by it.
Reply With Quote
  #10  
Old Apr 27, 2018, 06:09 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

I think we need to wait for blah to wake up again
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #11  
Old Apr 27, 2018, 06:16 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Quote:
but can we please implement a long-term plan to resolve some of these crippling issues
Yes, that involves me migrating the database to a cloud hosted solution over the weekend + labour day holiday.
Reply With Quote
  #12  
Old Apr 27, 2018, 06:24 PM
dancey's Avatar
dancey dancey is offline
Trusted Editor
 
Join Date: Dec 2007
Location: New Jersey
Posts: 1,428
Default

Quote:
Originally Posted by Gigablah View Post
Yes, that involves me migrating the database to a cloud hosted solution over the weekend + labour day holiday.
Thanks!! 10char
Reply With Quote
  #13  
Old Apr 27, 2018, 06:57 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

In the meantime I’ve done a manual repair of every single table in the database, which should tide us over.*

* famous last words
Reply With Quote
  #14  
Old Apr 28, 2018, 03:51 PM
josueuler josueuler is offline
Junior Member
 
Join Date: Feb 2018
Posts: 1
Red face Thanks!

I was worried
Reply With Quote
  #15  
Old Apr 28, 2018, 04:01 PM
Datschge's Avatar
Datschge Datschge is offline
Senior Member
 
Join Date: Mar 2008
Posts: 745
Default

Hm, why not repair them automatically?
SHOW TABLE STATUS; would list all tables marked crashed. REPAIR TABLE <tablename>; repairs it.
For that matter what makes those tables crash? Hardware issues?
Reply With Quote
  #16  
Old May 1, 2018, 10:07 PM
LuxKiller65's Avatar
LuxKiller65 LuxKiller65 is offline
Senior Member
 
Join Date: Nov 2007
Location: Spaceport Alpha
Posts: 1,260
Default

The site still has problems on my side. Sometimes it loads fine, but sometimes it takes between 30 seconds and several minutes to load. Sometimes it just doesn't load at all.
Reply With Quote
  #17  
Old May 3, 2018, 06:48 PM
GermanSeabass GermanSeabass is offline
Senior Member
 
Join Date: Jun 2009
Location: San Francisco
Posts: 117
Default

Thanks admins for keeping the lights on.

I recently switched over a large (25gb) content management system over to Google Cloud/Compute Engine and thoroughly recommend it. LAMP comes prepackaged, can be recompiled. Lemme know if there's room to help with server management/db management/hosting.

Also, if vgmdb were to have a Patreon to help cover hosting costs, I'd be chipping in day one.
__________________
Pianist, arranger, producer of Materia Collective, Project Destati, co-founder of Loudr.
Reply With Quote
  #18  
Old May 4, 2018, 05:47 PM
Jedi QuestMaster's Avatar
Jedi QuestMaster Jedi QuestMaster is offline
Senior Member
 
Join Date: Feb 2009
Location: United States
Posts: 518
Default

Quote:
Originally Posted by GermanSeabass View Post
Also, if vgmdb were to have a Patreon to help cover hosting costs, I'd be chipping in day one.
I was just looking around to see if there was anything like this. Figured I might as well cover the costs to keep my scans up.
Reply With Quote
  #19  
Old May 5, 2018, 08:50 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,403
Default

Don't worry about the media files, they're already hosted on Amazon S3. (That migration, among others, consumed much of my development efforts in recent years.)
Reply With Quote
  #20  
Old Jun 24, 2018, 01:31 AM
Myrkul's Avatar
Myrkul Myrkul is online now
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: France
Posts: 3,124
Default

June 24, 2018:
Table './vgmdb/vgmdb_artists' is marked as crashed and should be repaired
Reply With Quote
  #21  
Old Jun 24, 2018, 07:37 AM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Advisor
 
Join Date: May 2007
Location: U.S.A.
Posts: 223
Default

Album database is still down.
Reply With Quote
  #22  
Old Jun 24, 2018, 08:09 AM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

confirmed Album database down too. Member list is also down. Its spread to other parts aside from artist list.
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #23  
Old Jun 24, 2018, 01:09 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,240
Default

I did a repair on the artist table. Please let us know if there are any other pages or functions that have stopped working.
Reply With Quote
  #24  
Old Jun 24, 2018, 02:30 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

Quote:
Originally Posted by Secret Squirrel View Post
I did a repair on the artist table. Please let us know if there are any other pages or functions that have stopped working.
I noticed viewing User Profiles gets a popup to install Flash 6 or later. I already have latest Flash.
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #25  
Old Jun 24, 2018, 04:11 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,240
Default

Quote:
Originally Posted by Zhane Masaki View Post
I noticed viewing User Profiles gets a popup to install Flash 6 or later. I already have latest Flash.
Hm, it doesn't do that for me. Not sure that is on our end.
Reply With Quote
  #26  
Old Jun 25, 2018, 03:34 AM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Advisor
 
Join Date: May 2007
Location: U.S.A.
Posts: 223
Default

Quote:
Originally Posted by Zhane Masaki View Post
I noticed viewing User Profiles gets a popup to install Flash 6 or later. I already have latest Flash.
I receive this notification too when you look at a user's forum profile.

The pop-up browser alert window reads,

"VGMdb.net says:
You need Adobe Flash Player 6 (or above) to view the charts. It is a free and lightweight installation from Adobe.com. Please click on Ok to install the same."

It might be something that VBulletin uses on that page.
Reply With Quote
  #27  
Old Jun 25, 2018, 04:48 AM
dancey's Avatar
dancey dancey is offline
Trusted Editor
 
Join Date: Dec 2007
Location: New Jersey
Posts: 1,428
Default

Nothing to do with this topic, it's the ratings graph.
Reply With Quote
  #28  
Old Jun 26, 2018, 05:22 PM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Advisor
 
Join Date: May 2007
Location: U.S.A.
Posts: 223
Default

Quote:
Originally Posted by dancey View Post
Nothing to do with this topic, it's the ratings graph.
Thanks for clarifying!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Back Gas Mask (#28325) nstz Artist Discussions 0 Jan 3, 2019 09:58 PM
Back with a new project VGMRMissCoriel Video Game Music Discussion 2 Aug 11, 2016 05:41 AM
Back to Your Littleroots starly396 Album Discussions 0 Sep 9, 2014 11:35 PM
Back to Square Waves Lashiec Album Discussions 0 Feb 21, 2013 09:33 AM
Welcome back to VGMdb Secret Squirrel News and Announcements 21 Feb 21, 2008 03:07 PM