[MonetDB-users] How to recover Database after crash
Hi, is there guide on how to recover DB after server crash? I get following error: root@monetdb:/var/monetdb5/dbfarm# monetdb release vlad_a-f taken database out of maintenance mode: vlad_a-f root@monetdb:/var/monetdb5/dbfarm# monetdb start vlad_a-f starting database 'vlad_a-f'... FAILED start: starting 'vlad_a-f' failed: database 'vlad_a-f' appears to shut itself down after starting, check merovingian's logfile for possible hints root@monetdb:/var/monetdb5/dbfarm# tail /var/log/monetdb/merovingian.log 2011-04-11 11:40:53 MSG merovingian[2477]: starting database 'vlad_a-f', up min/avg/max: 2s/1h/15h, crash average: 0.00 0.30 0.20 (18-12=6) 2011-04-11 11:40:53 MSG vlad_a-f[2783]: arguments: /usr/bin/mserver5 --config=/etc/monetdb5.conf --dbname=vlad_a-f --set merovingian_uri=mapi:monetdb://monetdb:50000/vlad_a-f --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb5/dbfarm/vlad_a-f/.mapi.sock --set monet_vault_key=/var/monetdb5/dbfarm/vlad_a-f/.vaultkey --set monet_daemon=yes 2011-04-11 11:40:53 ERR vlad_a-f[2783]: !FATAL: BBPinit: could not write bat/BBP.dir 2011-04-11 11:40:53 MSG merovingian[2477]: database 'vlad_a-f' (2783) has exited with exit status 1 2011-04-11 11:41:02 ERR control[2477]: (local): failed to fork mserver: database 'vlad_a-f' appears to shut itself down after starting, check merovingian's logfile for possible hints Is there a procedure how to recover this? Thanks, Vlad
It's ext3. Problem was due to access rights. Folder
dbfarm/vlad_a-f/BACKUP had permissions of root and monetdb process
running under user could not access this file (all other files have
permissions of monetdb) so I changed it:
chown monetdb dbfarm/vlad_a-f/* -Rf
Now I just get error in log file and no other error. Not sure how to
recover this. DB is not starting.
2011-04-11 13:17:53 MSG merovingian[3281]: database 'vlad_a-f' (3716)
was killed by signal SIGSEGV
2011-04-11 13:18:02 ERR control[3281]: (local): failed to fork
mserver: database 'vlad_a-f' has crashed after starting, manual
intervention needed, check merovingian's logfile for details
Thanks
Vlad
On Mon, Apr 11, 2011 at 12:28 PM, Fabian Groffen
Hi Vladimir,
On 11-04-2011 11:46:12 +0200, Vladimir Vlach wrote:
2011-04-11 11:40:53 ERR vlad_a-f[2783]: !FATAL: BBPinit: could not write bat/BBP.dir
Can you check if there is any disk space free? Do you happen to know what the underlying filesystem is?
------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
It's ext3. Problem was due to access rights. Folder
dbfarm/vlad_a-f/BACKUP had permissions of root and monetdb process
running under user could not access this file (all other files have
permissions of monetdb) so I changed it:
chown monetdb dbfarm/vlad_a-f/* -Rf
Now I just get error in log file and no other error message. Not sure how to
recover this. DB is not starting.
2011-04-11 13:17:53 MSG merovingian[3281]: database 'vlad_a-f' (3716)
was killed by signal SIGSEGV
2011-04-11 13:18:02 ERR control[3281]: (local): failed to fork
mserver: database 'vlad_a-f' has crashed after starting, manual
intervention needed, check merovingian's logfile for details
Thanks
Vlad
On Mon, Apr 11, 2011 at 12:28 PM, Fabian Groffen
Hi Vladimir,
On 11-04-2011 11:46:12 +0200, Vladimir Vlach wrote:
2011-04-11 11:40:53 ERR vlad_a-f[2783]: !FATAL: BBPinit: could not write bat/BBP.dir
Can you check if there is any disk space free? Do you happen to know what the underlying filesystem is?
------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Fabian Groffen
-
Vladimir Vlach
-
Vladimir Vlach