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