A monet database we have created will not start with the following error:
sudo monetdb start dbprod
starting database 'dbprod'... FAILED
start: starting 'dbprod' failed: database 'dbprod' did not initialise
the sql scenario
Is it possible to recover from an error like this?
Here is the relevant log file portion.
2015-03-01 16:11:36 MSG dbprod[5743]: arguments: /usr/bin/mserver5
--dbpath=/var/lib/monetdb/dbprod --set
merovingian_uri=mapi:monetdb://qbdata:42000/dbprod --set mapi_open=false
--set mapi_port=0 --set mapi_usock=/var/lib/monetdb/dbprod/.mapi.sock
--set monet_vault_key=/var/lib/monetdb/dbprod/.vaultkey --set
gdk_nr_threads=2 --set max_clients=64 --set sql_optimizer=default_pipe
--set monet_daemon=yes
2015-03-01 16:11:36 ERR dbprod[5743]: !mvc_init: unable to create system
tables
2015-03-01 16:11:36 MSG dbprod[5743]: # MonetDB 5 server v11.19.7
"Oct2014-SP1"
2015-03-01 16:11:36 MSG dbprod[5743]: # Serving database 'dbprod', using
2 threads
2015-03-01 16:11:36 MSG dbprod[5743]: # Compiled for
x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
2015-03-01 16:11:36 MSG dbprod[5743]: # Found 1.955 GiB available
main-memory.
2015-03-01 16:11:36 MSG dbprod[5743]: # Copyright (c) 1993-July 2008 CWI.
2015-03-01 16:11:36 MSG dbprod[5743]: # Copyright (c) August 2008-2014
MonetDB B.V., all rights reserved
2015-03-01 16:11:36 MSG dbprod[5743]: # Visit http://www.monetdb.org/
for further information
2015-03-01 16:11:36 MSG dbprod[5743]: # Listening for UNIX domain
connection requests on mapi:monetdb:///var/lib/monetdb/dbprod/.mapi.sock
2015-03-01 16:11:36 MSG dbprod[5743]: !SQLException:SQLinit:Catalogue
initialization failed
2015-03-01 16:11:36 MSG dbprod[5743]: !ERROR: Could not read the version
number from the file 'sql_logs/sql//log'.
2015-03-01 16:11:36 MSG merovingian[1568]: database 'dbprod' (5743) has
exited with exit status 0
2015-03-01 16:11:36 MSG merovingian[1568]: database 'dbprod' has shut down
2015-03-01 16:11:36 ERR control[1568]: (local): failed to fork mserver:
database 'dbprod' did not initialise the sql scenario
2015-03-01 16:12:45 MSG control[1568]: (local): served status list
2015-03-01 16:12:45 MSG control[1568]: (local): locked database 'dbprod'
2015-03-01 16:13:09 MSG control[1568]: (local): served status list
2015-03-01 16:13:09 MSG control[1568]: (local): released database 'dbprod'
2015-03-01 16:13:19 MSG control[1568]: (local): served status list
2015-03-01 16:13:19 MSG merovingian[1568]: starting database 'dbprod',
up min/avg/max: 0s/2d/1w, crash average: 0.00 0.50 0.17 (15-10=5)
2015-03-01 16:13:20 MSG merovingian[1568]: sending process 5769
(database 'dbprod') the TERM signal