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]: # 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]: # 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 <Fabian.Groffen@cwi.nl>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Sent: Monday, October 8, 2012 2:30 PM
Subject: Re: Lock monetdb funnel behaviour

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