Author Topic: DB crash 1/7  (Read 13606 times)

0 Members and 1 Guest are viewing this topic.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 09:42:37 pm
DB crash 1/7
« on: January 07, 2018, 08:43:33 am »
The DB crashed during last night's site update.  TM and the Forum are both inoperable when the DB has crashed.  I restarted both the DB and the site update.  Unfortunately, I am on my way out for the day and cannot wait until the update completes.  Hopefully all will go smoothly this time.  The DB has been stable for quite a while until last night.

Offline bejacob

  • Full Member
  • ***
  • Posts: 233
  • Last Login:Today at 04:42:13 am
Re: DB crash 1/7
« Reply #1 on: January 07, 2018, 10:52:37 am »
Everything looks fine, so it must have updated without problems.

Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1584
  • Last Login:Today at 02:23:09 am
    • Hot Springs and Highways pages
Re: DB crash 1/7
« Reply #2 on: January 10, 2018, 04:15:34 am »
Either from the DB crash, or the server relocation soon thereafter, it looks like my error log and other log files either disappeared or were moved to a new location. It's not in http://tm.teresco.org/logs/, nor can I reach it through the link on my user page.

Offline SSOWorld

  • Full Member
  • ***
  • Posts: 245
  • Last Login:Yesterday at 09:13:17 pm
Re: DB crash 1/7
« Reply #3 on: January 10, 2018, 04:43:58 am »
Same problem exists for me.
Completed:
* Systems: DC, WI
* by US State: AK: I; AZ: I; AR: I; DE: I; DC: I, US, DC; HI: I; IL: I; IN: I*; IA: I, KS: I; MD: I, MA: I, MI: I; MN: I; MO: I; NE: I; NJ, I; ND: I; OH: I; OK: I; PA: I; RI: I; SD: I; WA: I; WV: I; WI: I,US,WI;

*Previously completed

Offline bejacob

  • Full Member
  • ***
  • Posts: 233
  • Last Login:Today at 04:42:13 am
Re: DB crash 1/7
« Reply #4 on: January 10, 2018, 07:32:07 am »
Same here. Log inaccessible. At first glance it appears all other functionality is working.

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4422
  • Last Login:November 11, 2024, 12:50:03 pm
  • I like C++
Re: DB crash 1/7
« Reply #5 on: January 10, 2018, 10:41:37 am »
Looks like the only file in the folder is siteupdate.log
Sri Syadasti Syadavaktavya Syadasti Syannasti Syadasti Cavaktavyasca Syadasti Syannasti Syadavatavyasca Syadasti Syannasti Syadavaktavyasca

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 09:42:37 pm
Re: DB crash 1/7
« Reply #6 on: January 10, 2018, 11:19:40 pm »
Yes, it looks like when I relaunched because of a file transfer problem, I only recopied the DB file not all the logs.  Should be fine in tonight's update (which I'm about to run).

Offline Spinoza

  • Jr. Member
  • **
  • Posts: 85
  • Last Login:August 29, 2024, 03:57:40 am
Re: DB crash 1/7
« Reply #7 on: January 11, 2018, 04:50:09 am »
Did you disable Germany Bundesstrassen? My log file is now missing all of them...

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 09:42:37 pm
Re: DB crash 1/7
« Reply #8 on: January 11, 2018, 07:14:10 am »
Did you disable Germany Bundesstrassen? My log file is now missing all of them...

Yes, there was an error in the latest update that I wasn't sure how to fix, and removed them temporarily to get a site update through.  They'll be back when michih is able to track down and fix the error.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4849
  • Last Login:November 20, 2024, 11:21:09 am
Re: DB crash 1/7
« Reply #9 on: January 11, 2018, 11:05:08 am »
Did you disable Germany Bundesstrassen? My log file is now missing all of them...

Yes, there was an error in the latest update that I wasn't sure how to fix, and removed them temporarily to get a site update through.  They'll be back when michih is able to track down and fix the error.

Yep, my bad. Sorry. No combination with the DB crash.

I currently review deub and had split some routes in NW yesterday. I've fixed the typo. Should be fine with the next update (I'll not be online on Friday if there's another typo but the error log was quite clear)

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 09:42:37 pm
Re: DB crash 1/7
« Reply #10 on: January 11, 2018, 11:35:49 am »
I got the deub fix (thanks!) and decided to run an extra site update now to get it back online.  Should be back up in about 45 minutes.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4849
  • Last Login:November 20, 2024, 11:21:09 am
Re: DB crash 1/7
« Reply #11 on: January 11, 2018, 12:18:24 pm »
deub is back again. Thanks Jim! :)