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.
TimeTrex not starting up
-
- Posts: 23
- Joined: Fri Oct 03, 2014 10:52 am
Re: TimeTrex not starting up
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
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
-
- Posts: 23
- Joined: Fri Oct 03, 2014 10:52 am
Re: TimeTrex not starting up
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.
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
Please attach a copy of TimeTrex log file (c:\timetrex\timetrex\log) here from, it should contain the exact error message.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
-
- Posts: 23
- Joined: Fri Oct 03, 2014 10:52 am
Re: TimeTrex not starting up
I've restore from Acronis backup before the issue began. Everything is working fine at this time.