Lock monetdb funnel behaviour
Hi, I have created two databases db1 and db2 and created a user "tapomay" on both with dedicated schema as given in the Getting Started page - http://www.monetdb.org/Downloads/Tutorial I have created a monetdb multiplex-funnel "testfunnel" pointing to them. When I do monetdb lock db1, I can access db1 using user "monetdb"(as expected) but not through user tapomay(as expected). But when I do monetdb lock testfunnel, I can still access it using user tapomay. I need it to stay unavailable. Also when I follow it by monetdb stop testfunnel and then try to access it using user tapomay, then it says that it's under maintenance. FYI, Regards, Tapomay _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hi, On 08-10-2012 01:36:10 -0700, Tapomay Dey wrote:
I have created two databases db1 and db2 and created a user "tapomay" on both with dedicated schema as given in the Getting Started page - [1]http://www.monetdb.org/Downloads/Tutorial
I have created a monetdb multiplex-funnel "testfunnel" pointing to them.
When I do monetdb lock db1, I can access db1 using user "monetdb"(as expected) but not through user tapomay(as expected).
But when I do monetdb lock testfunnel,
I can still access it using user tapomay. I need it to stay unavailable.
Also when I follow it by monetdb stop testfunnel and then try to access it using user tapomay, then it says that it's under maintenance.
There's two things here, I think. 1) you probably created the funnel with monetdb+monetdb (that's username + password), and the "root" user (monetdb) always has access to the database, to do maintenance tasks. 2) the funnel doesn't disconnect when a client disconnects, this may cause part of your problem. However, if you locked the database, it should have reported no suitable connection(s) any more. Could you send the merovingian.log so we can investigate? Perhaps this goes wrong here. Fabian _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Performed:
[tapomay@tapomay-laptop ~]$ monetdbd -v
MonetDB Database Server v1.6 (Jul2012-SP2)
[tapomay@tapomay-laptop ~]$ monetdbd stop monetdata/
[tapomay@tapomay-laptop ~]$ monetdbd start monetdata/
[tapomay@tapomay-laptop ~]$ monetdb start testfunnel
starting database 'testfunnel'... done
[tapomay@tapomay-laptop ~]$ monetdb lock testfunnel
put database under maintenance: testfunnel
[tapomay@tapomay-laptop ~]$mclient -d testfunnel -u tapomay
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2012-SP2)
Database: MonetDB v11.11.11 (Jul2012-SP2), 'mapi:monetdb://tapomay-laptop:50000/db1'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>\q
[tapomay@tapomay-laptop ~]$ monetdb stop testfunnel
stopping database 'testfunnel'...
Observations:
I see a new problem: It gets stuck at stop database. Have been seeing this quite frequent lately. It succeeds half of the times though.
Also I had done a :
CREATE SCHEMA "statsdb_schema" AUTHORIZATION "tapomay";
sql>ALTER USER "tapomay" SET SCHEMA "statsdb_schema";
on all the boxes. Does this have to do anything with user tapomay being able to loginto locked DB.
Funnel doesn't allow me to do any user managemet stuff. It just forwards those queries to the nodes.
Here's the funnel config:
testfunnel mfunnel local tapomay+sokrati@*/slave/2/db,tapomay+sokrati@*/slave/1/db
Here's the merovingian.log(I like the name)
2012-10-10 11:35:10 MSG merovingian[29659]: Merovingian 1.6 (Jul2012-SP2) starting
2012-10-10 11:35:10 MSG merovingian[29659]: monitoring dbfarm /home/tapomay/monetdata
2012-10-10 11:35:10 MSG merovingian[29659]: accepting connections on TCP socket 0.0.0.0:50000
2012-10-10 11:35:10 MSG merovingian[29659]: accepting connections on UNIX domain socket /tmp/.s.monetdb.50000
2012-10-10 11:35:10 MSG discovery[29659]: listening for UDP messages on 0.0.0.0:50000
2012-10-10 11:35:10 MSG control[29659]: accepting connections on UNIX domain socket /tmp/.s.merovingian.50000
2012-10-10 11:35:10 MSG discovery[29659]: new neighbour tapomay-laptop (tapomay-laptop)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tapomay-laptop:50000/testfunnel (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tapomay-laptop:50000/db2/slave/2/db (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tapomay-laptop:50000/db3 (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tapomay-laptop:50000/db1/slave/1/db (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://haiku-desktop:50000/msearch_stats_db/msearchstatsdb/4/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://haiku-desktop:50000/search_stats_db/searchstatsdb/4/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tapomay-desktop:50000/msearch_stats_db/msearchstatsdb/2/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tushar-desktop:50000/search_stats_db/searchstatsdb/1/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tushar-desktop:50000/msearch_stats_db/msearchstatsdb/1/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://tushar-desktop:50000/statsdbmaster (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://solr-test-1:50000/search_stats_db/searchstatsdb/3/slave (ttl=660s)
2012-10-10 11:35:12 MSG discovery[29659]: new database mapi:monetdb://solr-test-1:50000/msearch_stats_db/msearchstatsdb/3/slave (ttl=660s)
2012-10-10 11:36:43 MSG control[29659]: (local): served status list
2012-10-10 11:36:43 MSG merovingian[29659]: starting mfunnel 'testfunnel', up min/avg/max: 0s/15m/16h, crash average: 0.00 0.00 0.00 (149-148=1)
2012-10-10 11:36:43 MSG merovingian[29659]: starting multiplex-funnel connection manager
2012-10-10 11:36:43 MSG control[29659]: (local): started 'testfunnel'
2012-10-10 11:36:43 MSG testfunnel[29659]: mfunnel: setting up multiplexer target */slave/2/db->mapi:monetdb://tapomay-laptop:50000/db2
2012-10-10 11:36:43 MSG testfunnel[29659]: mfunnel: setting up multiplexer target */slave/1/db->mapi:monetdb://tapomay-laptop:50000/db1
2012-10-10 11:37:19 MSG control[29659]: (local): served status list
2012-10-10 11:37:19 MSG control[29659]: (local): locked database 'testfunnel'
2012-10-10 11:37:19 MSG discovery[29659]: removed neighbour database mapi:monetdb://tapomay-laptop:50000/testfunnel
2012-10-10 11:37:47 MSG testfunnel[29659]: mfunnel: added new client (local)
2012-10-10 11:37:48 MSG testfunnel[29659]: mfunnel: removing client (local)
2012-10-10 11:37:48 MSG testfunnel[29659]: mfunnel: added new client (local)
2012-10-10 11:37:49 MSG merovingian[29659]: starting database 'db2', up min/avg/max: 15s/56m/16h, crash average: 0.00 0.60 0.53 (71-42=29)
2012-10-10 11:37:49 MSG merovingian[29659]: proxying client localhost:51754 for database 'db2' to mapi:monetdb:///home/tapomay/monetdata/db2/.mapi.sock?database=db2
2012-10-10 11:37:49 MSG db2[29700]: arguments: /usr/bin/mserver5 --set gdk_dbfarm=/home/tapomay/monetdata --dbname=db2 --set merovingian_uri=mapi:monetdb://tapomay-laptop:50000/db2 --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/tapomay/monetdata/db2/.mapi.sock --set monet_vault_key=/home/tapomay/monetdata/db2/.vaultkey --set gdk_nr_threads=2 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2012-10-10 11:37:49 MSG db2[29700]: # MonetDB 5 server v11.11.11 "Jul2012-SP2"
2012-10-10 11:37:49 MSG db2[29700]: # Serving database 'db2', using 2 threads
2012-10-10 11:37:49 MSG db2[29700]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
2012-10-10 11:37:49 MSG db2[29700]: # Found 3.773 GiB available main-memory.
2012-10-10 11:37:49 MSG db2[29700]: # Copyright (c) 1993-July 2008 CWI.
2012-10-10 11:37:49 MSG db2[29700]: # Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
2012-10-10 11:37:49 MSG db2[29700]: # Visit http://www.monetdb.org/ for further information
2012-10-10 11:37:49 MSG db2[29700]: # Listening for UNIX domain connection requests on mapi:monetdb:///home/tapomay/monetdata/db2/.mapi.sock
2012-10-10 11:37:49 MSG db2[29700]: # MonetDB/SQL module loaded
2012-10-10 11:37:49 MSG merovingian[29659]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-10-10 11:37:49 MSG merovingian[29659]: starting database 'db1', up min/avg/max: 9s/56m/16h, crash average: 0.00 0.60 0.67 (68-40=28)
2012-10-10 11:37:50 MSG merovingian[29659]: proxying client localhost:51755 for database 'db1' to mapi:monetdb:///home/tapomay/monetdata/db1/.mapi.sock?database=db1
2012-10-10 11:37:50 MSG db1[29705]: arguments: /usr/bin/mserver5 --set gdk_dbfarm=/home/tapomay/monetdata --dbname=db1 --set merovingian_uri=mapi:monetdb://tapomay-laptop:50000/db1 --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/tapomay/monetdata/db1/.mapi.sock --set monet_vault_key=/home/tapomay/monetdata/db1/.vaultkey --set gdk_nr_threads=2 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2012-10-10 11:37:50 MSG db1[29705]: # MonetDB 5 server v11.11.11 "Jul2012-SP2"
2012-10-10 11:37:50 MSG db1[29705]: # Serving database 'db1', using 2 threads
2012-10-10 11:37:50 MSG db1[29705]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
2012-10-10 11:37:50 MSG db1[29705]: # Found 3.773 GiB available main-memory.
2012-10-10 11:37:50 MSG db1[29705]: # Copyright (c) 1993-July 2008 CWI.
2012-10-10 11:37:50 MSG db1[29705]: # Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
2012-10-10 11:37:50 MSG db1[29705]: # Visit http://www.monetdb.org/ for further information
2012-10-10 11:37:50 MSG db1[29705]: # Listening for UNIX domain connection requests on mapi:monetdb:///home/tapomay/monetdata/db1/.mapi.sock
2012-10-10 11:37:50 MSG db1[29705]: # MonetDB/SQL module loaded
2012-10-10 11:37:50 MSG merovingian[29659]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-10-10 11:38:23 MSG testfunnel[29659]: mfunnel: removing client (local)
2012-10-10 11:38:33 MSG control[29659]: (local): served status list
2012-10-10 11:38:34 MSG merovingian[29659]: stopping mfunnel 'testfunnel'
Thanks and Regards,
Tapomay.
________________________________
From: Fabian Groffen
I have created two databases db1 and db2 and created a user "tapomay" on both with dedicated schema as given in the Getting Started page - [1]http://www.monetdb.org/Downloads/Tutorial
I have created a monetdb multiplex-funnel "testfunnel" pointing to them.
When I do monetdb lock db1, I can access db1 using user "monetdb"(as expected) but not through user tapomay(as expected).
But when I do monetdb lock testfunnel,
I can still access it using user tapomay. I need it to stay unavailable.
Also when I follow it by monetdb stop testfunnel and then try to access it using user tapomay, then it says that it's under maintenance.
There's two things here, I think. 1) you probably created the funnel with monetdb+monetdb (that's username + password), and the "root" user (monetdb) always has access to the database, to do maintenance tasks. 2) the funnel doesn't disconnect when a client disconnects, this may cause part of your problem. However, if you locked the database, it should have reported no suitable connection(s) any more. Could you send the merovingian.log so we can investigate? Perhaps this goes wrong here. Fabian _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Fabian Groffen -
Tapomay Dey