Page 1 of 1
TimeTrex not starting up
Posted: Mon Dec 03, 2018 7:06 am
by rjandreski
When any user attempts to start up TimeTrex this morning, it redirects to
http://timeclock:8085/html5/DownForMain ... on=DBError
I restarted the server and same result. Everything was working fine on Friday.
I did notice that the server was extremely low on hard drive storage so I freed up some space.
Need help resolving this. Any recommendations would be greatly appreciated.
I also do have our backup that was created with Acronis Backup that we use from Saturday morning that I can use to restore from. Thank you.
Re: TimeTrex not starting up
Posted: Mon Dec 03, 2018 7:32 am
by rjandreski
The closest resolution that I found that had the "DownForMaintenance.php?exception=DBError" was from 2008 which is now 10 years old so I'm not confident that this resolution will help me.
viewtopic.php?f=2&t=729&p=3445&hilit=Do ... rror#p3445
Please let me know what I need to do to resolve this.
Our most recent database files in the C:\TimeTrex folder are as follows:
timetrex_database_20181202.sql - 1 KB
timetrex_database_20181201.sql - 4,590 KB
timetrex_database_20181130.sql - 4,583 KB
Re: TimeTrex not starting up
Posted: Mon Dec 03, 2018 7:54 am
by rjandreski
I attempted to restore_database and got the following:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Windows\system32>cd\timetrex
C:\TimeTrex>restore_database.bat timetrex_database_20181201.sql
Attempting to restore SQL dump file: timetrex_database_20181201.sql...
-----WARNING-----WARNING-----WARNING-----WARNING-----
RESTORING THIS FILE WILL COMPLETELY OVERWRITE ALL EXISTING DATA...
ARE YOU SURE YOU WANT TO DO THIS?
-----WARNING-----WARNING-----WARNING-----WARNING-----
Press any key to continue . . .
NO REALLY, ALL EXISTING DATA WILL BE DELETED.
ARE YOU REALLY SURE YOU WANT TO DO THIS?
Press any key to continue . . .
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7; 2615 2200 SCHEMA public post
gres
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" alr
eady exists
Command was: CREATE SCHEMA public;
WARNING: errors ignored on restore: 1
Done.
Still gives me the same error. Please help.
Re: TimeTrex not starting up
Posted: Mon Dec 03, 2018 9:02 am
by mikeb
Please attach a copy of TimeTrex log file (c:\timetrex\timetrex\log) here from, it should contain the exact error message.
Re: TimeTrex not starting up
Posted: Mon Dec 03, 2018 9:04 am
by rjandreski
I've restore from Acronis backup before the issue began. Everything is working fine at this time.