MonetDB error while restarting the database

Pierre-Adrien Coustillas pcoustillas at 1g6.biz
Mon Oct 27 14:21:16 CET 2014


Hello 


(google translate) 


I receive this error when there is no specific space disk . 
Monetdb sometimes uses a lot of temporary disk space (500 GB is normal for 1 TB of data) , which are released at the end of treatment or after a crash 


Error last week : 

2014-10-22 22:51:46 MSG merovingian[18865]: sending process 30608 (database 'lemonde') the TERM signal 
2014-10-22 22:51:46 ERR merovingian[18865]: unknown state: 42014-10-22 22:51:46 ERR lemonde[30608]: #GDKexit: killing thread 


Pierre 

-- 
1G6 
52 route de bischwiller 
67300 Schiltigheim 
Société de Services et de Formations en Logiciels Libres 
http://1g6.biz 
Tél : 06 64 63 70 35 

----- Mail original -----

De: "Ashish Kumar Singh" <ashishkumar.singh at altair.com> 
À: "Ashish Kumar Singh" <ashishkumar.singh at altair.com>, users-list at monetdb.org 
Cc: developers-list at monetdb.org 
Envoyé: Lundi 27 Octobre 2014 13:49:19 
Objet: Re: MonetDB error while restarting the database 


Guys, 


Any help with this will be really helpful for us? 






Regards, 
Ashish 


From: Ashish Singh < ashishkumar.singh at altair.com > 
Date: Monday, 27 October 2014 4:06 pm 
To: " users-list at monetdb.org " < users-list at monetdb.org > 
Subject: MonetDB error while restarting the database 









All, 






We are facing a new issue with monetdb where monetdb connections and process is being killed very frequently. Is this a known issue or any suggestion in getting more details will be helpful. 






Regards, 
Ashish 


Mervogian.log: 







2014-10-27 09:01:00 MSG pbsworksdb[6351]: arguments: /opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/bin/mserver5 --dbpath=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb --set merovingian_uri=mapi:monetdb://blrec12-vm6:9200/pbsworksdb --set mapi_open=false --set mapi_port=0 --set mapi_usock=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock --set monet_vault_key=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # MonetDB 5 server v11.17.17 "Jan2014-SP2" 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Serving database 'pbsworksdb', using 4 threads 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Found 15.675 GiB available main-memory. 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Copyright (c) 1993-July 2008 CWI. 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Visit http://www.monetdb.org/ for further information 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # Listening for UNIX domain connection requests on mapi:monetdb:///opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock 
2014-10-27 09:01:00 MSG pbsworksdb[6351]: # MonetDB/SQL module loaded 
2014-10-27 09:01:00 MSG control[23583]: (local): started 'pbsworksdb' 
2014-10-27 09:01:00 MSG merovingian[23583]: proxying client localhost.localdomain:53844 for database 'pbsworksdb' to mapi:monetdb:///opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock?database=pbsworksdb 
2014-10-27 09:01:00 MSG merovingian[23583]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 
2014-10-27 09:01:26 MSG control[23583]: (local): served status list 
2014-10-27 09:01:26 MSG merovingian[23583]: sending process 6351 (database 'pbsworksdb') the TERM signal 
2014-10-27 09:01:26 ERR merovingian[23583]: unknown state: 42014-10-27 09:01:26 ERR pbsworksdb[6351]: #GDKexit: killing thread 
2014-10-27 09:01:26 MSG merovingian[23583]: database 'pbsworksdb' (6351) has exited with exit status 0 
2014-10-27 09:01:26 MSG merovingian[23583]: database 'pbsworksdb' has shut down 
2014-10-27 09:01:26 MSG control[23583]: (local): stopped database 'pbsworksdb' 
2014-10-27 09:01:26 MSG control[23583]: (local): served status list 
2014-10-27 09:01:26 MSG merovingian[23583]: starting database 'pbsworksdb', up min/avg/max: 5s/14m/1h, crash average: 0.00 0.00 0.00 (648-648=0) 
2014-10-27 09:01:27 MSG pbsworksdb[6575]: arguments: /opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/bin/mserver5 --dbpath=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb --set merovingian_uri=mapi:monetdb://blrec12-vm6:9200/pbsworksdb --set mapi_open=false --set mapi_port=0 --set mapi_usock=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock --set monet_vault_key=/opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # MonetDB 5 server v11.17.17 "Jan2014-SP2" 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Serving database 'pbsworksdb', using 4 threads 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Found 15.675 GiB available main-memory. 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Copyright (c) 1993-July 2008 CWI. 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Visit http://www.monetdb.org/ for further information 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # Listening for UNIX domain connection requests on mapi:monetdb:///opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock 
2014-10-27 09:01:32 MSG pbsworksdb[6575]: # MonetDB/SQL module loaded 
2014-10-27 09:01:32 MSG merovingian[23583]: proxying client localhost.localdomain:53853 for database 'pbsworksdb' to mapi:monetdb:///opt/pbsworks/12.4_rc3.1_live/portal/thirdparty/monetdb/pbsworksdata/pbsworksdb/.mapi.sock?database=pbsworksdb 
2014-10-27 09:01:32 MSG merovingian[23583]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 
2014-10-27 09:01:32 MSG c 












_______________________________________________ 
users-list mailing list 
users-list at monetdb.org 
https://www.monetdb.org/mailman/listinfo/users-list 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20141027/1b67797a/attachment.html>


More information about the developers-list mailing list