MonetDB error while restarting the database

Ashish Kumar Singh ashishkumar.singh at altair.com
Mon Oct 27 14:49:46 CET 2014


Thanks!


Appreciate your response so there are few more people getting the same error :).
Any suggestions from dev team on this issue? Can monetdbd exittimeout be also in picture for this?


Regards,
Ashish



From: Pierre-Adrien Coustillas <pcoustillas at 1g6.biz<mailto:pcoustillas at 1g6.biz>>
Date: Monday, 27 October 2014 6:51 pm
To: "users-list at monetdb.org<mailto:users-list at monetdb.org>" <users-list at monetdb.org<mailto:users-list at monetdb.org>>
Cc: "developers-list at monetdb.org<mailto:developers-list at monetdb.org>" <developers-list at monetdb.org<mailto:developers-list at monetdb.org>>, Ashish Singh <ashishkumar.singh at altair.com<mailto:ashishkumar.singh at altair.com>>
Subject: Re: MonetDB error while restarting the database

Hello

  (google translate)

I receive this error when there is no specific spacedisk.
Monetdb sometimes uses a lot of temporary diskspace (500GBisnormalfor 1TBof data), which arereleasedat the end oftreatment or after acrash

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

________________________________
De: "Ashish Kumar Singh" <ashishkumar.singh at altair.com<mailto:ashishkumar.singh at altair.com>>
À: "Ashish Kumar Singh" <ashishkumar.singh at altair.com<mailto:ashishkumar.singh at altair.com>>, users-list at monetdb.org<mailto:users-list at monetdb.org>
Cc: developers-list at monetdb.org<mailto: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<mailto:ashishkumar.singh at altair.com>>
Date: Monday, 27 October 2014 4:06 pm
To: "users-list at monetdb.org<mailto:users-list at monetdb.org>" <users-list at monetdb.org<mailto: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<mailto: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/d4895a71/attachment.html>


More information about the developers-list mailing list