On 11/02/14 11:17, Radovan Bičiště wrote:
Hello, I have recovered from a backup of VM and loaded missing data. What kind of VM are you using?
My scenario is now: 1. run SELECT statement that I need to stop. 2. did stop and start database. 3. database is refusing to start with: ceos@lux-analytics:~$ monetdb start zkdev1 starting database 'zkdev1'... FAILED start: starting 'zkdev1' failed: database 'zkdev1' has crashed after starting, manual intervention needed, check monetdbd's logfile for details
in .gdk_lock is: ceos@lux-analytics:/u01/ceosdata/database/monetdb/drmax/crm/zkdev1$ tail -f .gdk_lock USR=1001 PID=2583 TIME=Tue Feb 11 11:13:44 2014 @ LOGON The tail of the merovingian.log file is needed to assess why the system stopped. That keeps the server status errors.
regards, Martin
Any suggestations?
Thanks, Radovan
On 02/10/2014 05:25 PM, Martin Kersten wrote:
Hello
It is not a crash as such, but a safeguard against an incorrect environment. A database logger should never be removed, because it is needed to realise transaction properties.
The log message indicates what to do.
regards, Martin
On 10/02/14 16:08, Radovan Bičiště wrote:
Hello, I hope anyone can help with database crash. In .gdk_lock is following: USR=1001 PID=6751 TIME=Mon Feb 10 16:04:17 2014 @ LOGON USR=1001 PID=6751 TIME=Mon Feb 10 16:04:18 2014 @ !FATAL: logger_new: there is a logger catalog, but no log file. Are you sure you are using the correct combination of database (--dbpath) and log directory (--set sql_logdir)? If you have done a recent update of the server, it may be that your logs are in an old location. You should then either use --set sql_logdir=<path to old log directory> or move the old log directory to the new location (/u01/ceosdata/database/monetdb/drmax/crm/zkdev1/sql_logs/sql/). USR=1001 PID=6751 TIME=Mon Feb 10 16:04:18 2014 @ LOGOFF
Anyway to start the database without logs ? Thanks, Radovan
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list