Error starting a production database
Hi
I'm getting the following error when a I try to start our production database:
# builtin opt gdk_dbpath = /var/monetdb5/dbfarm/demo # builtin opt gdk_debug = 0 # builtin opt gdk_vmtrim = no # builtin opt monet_prompt = > # builtin opt monet_daemon = no # builtin opt mapi_port = 50000 # builtin opt mapi_open = false # builtin opt mapi_autosense = false # builtin opt sql_optimizer = default_pipe # builtin opt sql_debug = 0 # cmdline opt gdk_dbpath = /usr/local/monetdb/alm_dat_far # cmdline opt merovingian_uri = mapi:monetdb://farser07:50000/alm_dat_far # cmdline opt mapi_open = false # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /usr/local/monetdb/alm_dat_far/.mapi.sock # cmdline opt monet_vault_key = /usr/local/monetdb/alm_dat_far/.vaultkey # cmdline opt gdk_nr_threads = 6 # cmdline opt max_clients = 64 # cmdline opt sql_optimizer = default_pipe # cmdline opt monet_daemon = yes # cmdline opt gdk_debug = 10 # MonetDB 5 server v11.21.11 "Jul2015-SP1" # Serving database 'alm_dat_far', using 6 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked # Found 39.298 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for UNIX domain connection requests on mapi:monetdb:///usr/local/monetdb/alm_dat_far/.mapi.sock # Start processing logs sql/sql_logs version 52200 !FATAL: Logger_new: cannot create seqs bats
What can I do to solve it?
I have been trying to recover a backup of the virtual machine where the instance of monetdb is but until now I have not been able to recover this database.
Thanks in advance.
Juan Carlos Gastelum
Hi Juan,
On 11 Nov 2015, at 02:29, Juan Carlos Gastélum jcgastr@farmacon.com.mx wrote: !FATAL: Logger_new: cannot create sees bats
Is the disk writeable and has free space available?
Hannes
Hi
Yes, the disk is writeable and it has free space available.
Here are the free space that is consumed and what is available, there are 178 GB available.
681G 468G 178G 73% /usr/local
Thanks,
/Juan Carlos/
El 10/11/15 a las 18:29, Juan Carlos Gastélum escribió:
Hi
I'm getting the following error when a I try to start our production database:
# builtin opt gdk_dbpath = /var/monetdb5/dbfarm/demo # builtin opt gdk_debug = 0 # builtin opt gdk_vmtrim = no # builtin opt monet_prompt = > # builtin opt monet_daemon = no # builtin opt mapi_port = 50000 # builtin opt mapi_open = false # builtin opt mapi_autosense = false # builtin opt sql_optimizer = default_pipe # builtin opt sql_debug = 0 # cmdline opt gdk_dbpath = /usr/local/monetdb/alm_dat_far # cmdline opt merovingian_uri = mapi:monetdb://farser07:50000/alm_dat_far # cmdline opt mapi_open = false # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /usr/local/monetdb/alm_dat_far/.mapi.sock # cmdline opt monet_vault_key = /usr/local/monetdb/alm_dat_far/.vaultkey # cmdline opt gdk_nr_threads = 6 # cmdline opt max_clients = 64 # cmdline opt sql_optimizer = default_pipe # cmdline opt monet_daemon = yes # cmdline opt gdk_debug = 10 # MonetDB 5 server v11.21.11 "Jul2015-SP1" # Serving database 'alm_dat_far', using 6 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked # Found 39.298 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved # Visithttp://www.monetdb.org/ for further information # Listening for UNIX domain connection requests on mapi:monetdb:///usr/local/monetdb/alm_dat_far/.mapi.sock # Start processing logs sql/sql_logs version 52200 !FATAL: Logger_new: cannot create seqs bats
What can I do to solve it?
I have been trying to recover a backup of the virtual machine where the instance of monetdb is but until now I have not been able to recover this database.
Thanks in advance.
Juan Carlos Gastelum
Hi
The data of the database are:
mserver5 --version --dbname=alm_dat_far MonetDB 5 server v11.21.11 "Jul2015-SP1" (64-bit, 64-bit oids, 128-bit integers) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 39.3GiB available memory, 6 available cpu cores Libraries: libpcre: 8.31 2012-07-06 (compiled with 8.31) openssl: OpenSSL 1.0.1f 6 Jan 2014 (compiled with OpenSSL 1.0.1f 6 Jan 2014) libxml2: 2.9.1 (compiled with 2.9.1) Compiled by: root@dev.monetdb.org (x86_64-pc-linux-gnu) Compilation: gcc -O3 -fomit-frame-pointer -pipe -g -D_FORTIFY_SOURCE=2 Linking : /usr/bin/ld -m elf_x86_64
Juan Carlos
El 11/11/15 a las 08:19, Juan Carlos Gastélum escribió:
Hi
Yes, the disk is writeable and it has free space available.
Here are the free space that is consumed and what is available, there are 178 GB available.
681G 468G 178G 73% /usr/local
Thanks,
/Juan Carlos/
El 10/11/15 a las 18:29, Juan Carlos Gastélum escribió:
Hi
I'm getting the following error when a I try to start our production database:
# builtin opt gdk_dbpath = /var/monetdb5/dbfarm/demo # builtin opt gdk_debug = 0 # builtin opt gdk_vmtrim = no # builtin opt monet_prompt = > # builtin opt monet_daemon = no # builtin opt mapi_port = 50000 # builtin opt mapi_open = false # builtin opt mapi_autosense = false # builtin opt sql_optimizer = default_pipe # builtin opt sql_debug = 0 # cmdline opt gdk_dbpath = /usr/local/monetdb/alm_dat_far # cmdline opt merovingian_uri = mapi:monetdb://farser07:50000/alm_dat_far # cmdline opt mapi_open = false # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /usr/local/monetdb/alm_dat_far/.mapi.sock # cmdline opt monet_vault_key = /usr/local/monetdb/alm_dat_far/.vaultkey # cmdline opt gdk_nr_threads = 6 # cmdline opt max_clients = 64 # cmdline opt sql_optimizer = default_pipe # cmdline opt monet_daemon = yes # cmdline opt gdk_debug = 10 # MonetDB 5 server v11.21.11 "Jul2015-SP1" # Serving database 'alm_dat_far', using 6 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked # Found 39.298 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved # Visithttp://www.monetdb.org/ for further information # Listening for UNIX domain connection requests on mapi:monetdb:///usr/local/monetdb/alm_dat_far/.mapi.sock # Start processing logs sql/sql_logs version 52200 !FATAL: Logger_new: cannot create seqs bats
What can I do to solve it?
I have been trying to recover a backup of the virtual machine where the instance of monetdb is but until now I have not been able to recover this database.
Thanks in advance.
Juan Carlos Gastelum
Hi Juan,
Make sure user and group of your dbfarm consistent in your dbfarm directory.
I just create a user and group monetdb.
then chown -R monetdb:monetdb the directory and let monetdb do the rest when you start it as that user.
Also it might be SELinux or Apparmour causing you an issue check the getenforce/setenforce commands and documentation for details.
Regards,
Brian Hood On Nov 12, 2015 12:24 AM, "Juan Carlos Gastélum" jcgastr@farmacon.com.mx wrote:
Hi
The data of the database are:
mserver5 --version --dbname=alm_dat_far MonetDB 5 server v11.21.11 "Jul2015-SP1" (64-bit, 64-bit oids, 128-bit integers) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 39.3GiB available memory, 6 available cpu cores Libraries: libpcre: 8.31 2012-07-06 (compiled with 8.31) openssl: OpenSSL 1.0.1f 6 Jan 2014 (compiled with OpenSSL 1.0.1f 6 Jan 2014) libxml2: 2.9.1 (compiled with 2.9.1) Compiled by: root@dev.monetdb.org (x86_64-pc-linux-gnu) Compilation: gcc -O3 -fomit-frame-pointer -pipe -g -D_FORTIFY_SOURCE=2 Linking : /usr/bin/ld -m elf_x86_64
Juan Carlos
El 11/11/15 a las 08:19, Juan Carlos Gastélum escribió:
Hi
Yes, the disk is writeable and it has free space available.
Here are the free space that is consumed and what is available, there are 178 GB available.
681G 468G 178G 73% /usr/local
Thanks,
*Juan Carlos*
El 10/11/15 a las 18:29, Juan Carlos Gastélum escribió:
Hi
I'm getting the following error when a I try to start our production database:
# builtin opt gdk_dbpath = /var/monetdb5/dbfarm/demo # builtin opt gdk_debug = 0 # builtin opt gdk_vmtrim = no # builtin opt monet_prompt = > # builtin opt monet_daemon = no # builtin opt mapi_port = 50000 # builtin opt mapi_open = false # builtin opt mapi_autosense = false # builtin opt sql_optimizer = default_pipe # builtin opt sql_debug = 0 # cmdline opt gdk_dbpath = /usr/local/monetdb/alm_dat_far # cmdline opt merovingian_uri = mapi:monetdb://farser07:50000/alm_dat_far # cmdline opt mapi_open = false # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /usr/local/monetdb/alm_dat_far/.mapi.sock # cmdline opt monet_vault_key = /usr/local/monetdb/alm_dat_far/.vaultkey # cmdline opt gdk_nr_threads = 6 # cmdline opt max_clients = 64 # cmdline opt sql_optimizer = default_pipe # cmdline opt monet_daemon = yes # cmdline opt gdk_debug = 10 # MonetDB 5 server v11.21.11 "Jul2015-SP1" # Serving database 'alm_dat_far', using 6 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked # Found 39.298 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for UNIX domain connection requests on mapi:monetdb:///usr/local/monetdb/alm_dat_far/.mapi.sock # Start processing logs sql/sql_logs version 52200 !FATAL: Logger_new: cannot create seqs bats
What can I do to solve it?
I have been trying to recover a backup of the virtual machine where the instance of monetdb is but until now I have not been able to recover this database.
Thanks in advance.
Juan Carlos Gastelum
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi
I have just confirmed that the user, the group and the permissions are correct, as mentioned by Brian Hood. I have disabled AppArmor also and the error is still there.
I'm using ubuntu 14.04.
What else can I do to solve it?
Thanks.
Juan Carlos
Hi Juan,
Make sure user and group of your dbfarm consistent in your dbfarm directory.
I just create a user and group monetdb.
then chown -R monetdb:monetdb the directory and let monetdb do the rest when you start it as that user.
Also it might be SELinux or Apparmour causing you an issue check the getenforce/setenforce commands and documentation for details.
Regards,
Brian Hood
Hi Juan,
Well i will show you how my directory structure looks permissions directory / file wise.
[root@orville threatmonitor]# cd threatmonitor/ [root@orville threatmonitor]# ls -l | grep sql drwx------ 3 monetdb monetdb 72 Sep 9 02:07 sql_logs [root@orville threatmonitor]# cd sql_logs/ [root@orville sql_logs]# ls -l total 0 drwx------ 2 monetdb monetdb 96 Sep 12 20:11 sql [root@orville sql_logs]# cd sql/ [root@orville sql]# ls -l total 521 -rw------- 1 monetdb monetdb 11 Sep 12 20:11 log -rw------- 1 monetdb monetdb 524311 Sep 12 20:15 log.11 [root@orville sql]#
The sql_logs is 700 and the sql directory underneath is the same and the files are 600.
Regards,
Brian Hood
On Thu, Nov 12, 2015 at 11:33 PM, Juan Carlos Gastélum < jcgastr@farmacon.com.mx> wrote:
Hi
I have just confirmed that the user, the group and the permissions are correct, as mentioned by Brian Hood. I have disabled AppArmor also and the error is still there.
I'm using ubuntu 14.04.
What else can I do to solve it?
Thanks.
Juan Carlos
Hi Juan,
Make sure user and group of your dbfarm consistent in your dbfarm directory.
I just create a user and group monetdb.
then chown -R monetdb:monetdb the directory and let monetdb do the rest when you start it as that user.
Also it might be SELinux or Apparmour causing you an issue check the getenforce/setenforce commands and documentation for details.
Regards,
Brian Hood
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi, Brian
My permissions are similar to yours:
monetdb$ cd alm_dat_far/ monetdb/alm_dat_far$ ls -l | grep sql drwxrwx--- 3 monetdb monetdb 4096 feb 22 2014 sql_logs monetdb/alm_dat_far$ cd sql_logs/ monetdb/alm_dat_far/sql_logs$ ls -l total 4 drwxrwx--- 2 monetdb monetdb 4096 nov 10 16:11 sql monetdb/alm_dat_far/sql_logs$ cd sql/ monetdb/alm_dat_far/sql_logs/sql$ ls -l total 4 -rw--w---- 1 monetdb monetdb 25 nov 10 16:03 log -rw--w---- 1 monetdb monetdb 0 nov 10 16:03 log.1970324836974605 monetdb/alm_dat_far/sql_logs/sql$
Thank you.
Juan Carlos Gastelum
Hi Juan,
Well i will show you how my directory structure looks permissions directory / file wise.
[root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# cd threatmonitor/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# ls -l | grep sql drwx------ 3 monetdb monetdb 72 Sep 9 02:07 sql_logs [root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# cd sql_logs/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql_logs]# ls -l total 0 drwx------ 2 monetdb monetdb 96 Sep 12 20:11 sql [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql_logs]# cd sql/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql]# ls -l total 521 -rw------- 1 monetdb monetdb 11 Sep 12 20:11 log -rw------- 1 monetdb monetdb 524311 Sep 12 20:15 log.11 [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql]#
The sql_logs is 700 and the sql directory underneath is the same and the files are 600.
Regards,
Brian Hood
Hi Juan,
Can you even touch a file as the monetdb user inside your dbfarm is the question you need to answer in your environment.
Regards,
Brian Hood On Nov 13, 2015 2:13 AM, "Juan Carlos Gastélum" jcgastr@farmacon.com.mx wrote:
Hi, Brian
My permissions are similar to yours:
monetdb$ cd alm_dat_far/ monetdb/alm_dat_far$ ls -l | grep sql drwxrwx--- 3 monetdb monetdb 4096 feb 22 2014 sql_logs monetdb/alm_dat_far$ cd sql_logs/ monetdb/alm_dat_far/sql_logs$ ls -l total 4 drwxrwx--- 2 monetdb monetdb 4096 nov 10 16:11 sql monetdb/alm_dat_far/sql_logs$ cd sql/ monetdb/alm_dat_far/sql_logs/sql$ ls -l total 4 -rw--w---- 1 monetdb monetdb 25 nov 10 16:03 log -rw--w---- 1 monetdb monetdb 0 nov 10 16:03 log.1970324836974605 monetdb/alm_dat_far/sql_logs/sql$
Thank you.
Juan Carlos Gastelum
Hi Juan,
Well i will show you how my directory structure looks permissions directory / file wise.
[root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# cd threatmonitor/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# ls -l | grep sql drwx------ 3 monetdb monetdb 72 Sep 9 02:07 sql_logs [root at orville https://www.monetdb.org/mailman/listinfo/users-list threatmonitor]# cd sql_logs/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql_logs]# ls -l total 0 drwx------ 2 monetdb monetdb 96 Sep 12 20:11 sql [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql_logs]# cd sql/ [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql]# ls -l total 521 -rw------- 1 monetdb monetdb 11 Sep 12 20:11 log -rw------- 1 monetdb monetdb 524311 Sep 12 20:15 log.11 [root at orville https://www.monetdb.org/mailman/listinfo/users-list sql]#
The sql_logs is 700 and the sql directory underneath is the same and the files are 600.
Regards,
Brian Hood
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi, Brian
Yes, I can touch a file as the monetdb user inside the dbfarm:
monetdb$ sudo -u monetdb touch test.txt monetdb$ ls -ltr total 1008 drwxrwx--- 5 monetdb monetdb 73728 nov 12 16:36 alm_dat_far -rw-r--r-- 1 monetdb monetdb 5 nov 12 16:38 merovingian.pid -rw--w---- 1 monetdb monetdb 945167 nov 12 16:38 merovingian.log -rw-r--r-- 1 monetdb monetdb 0 nov 12 21:46 test.txt monetdb$ cd alm_dat_far/ monetdb/alm_dat_far$ sudo -u monetdb touch test.txt monetdb/alm_dat_far$ ls -ltr total 12 drwxrwx--- 2 monetdb monetdb 4096 feb 22 2014 box drwxrwx--- 3 monetdb monetdb 4096 feb 22 2014 sql_logs ....... drwxrwx--- 67 monetdb monetdb 4096 nov 12 16:36 bat -rw------- 1 monetdb monetdb 0 nov 12 16:36 0426c998-9244-462e-9e6b-542d55ce46bd -rw-r--r-- 1 monetdb monetdb 0 nov 12 21:46 test.txt
Thank you.
Juan Carlos Gastelum
Hi Juan,
Can you even touch a file as the monetdb user inside your dbfarm is the question you need to answer in your environment.
Regards,
Brian Hood
participants (3)
-
Brian Hood -
Hannes Mühleisen -
Juan Carlos Gastélum