Hi Gautham
I'm tryong to install monet db on centos V11.31 on one of our machine for dev prupose.
I cannot as I get this error:
The GPG keys listed for the "MonetDB 7 - x86_64" repository are already installed but they are not correct for this package.
Have you an idea or a place where I can installable packages ?
|
|
Confidentiality Note: This email and any attachments to it are intended only for the named recipients and may contain confidential information. If you are not
one of the intended recipients, please do not save, duplicate or forward it and immediately delete it from your device.
P
Think of the environment. Do you need to print this e-mail?
From: users-list <users-list-bounces+philippe.gauquelin=iriworldwide.com@monetdb.org>
On Behalf Of Murthy, Gautham
Sent: mercredi 7 novembre 2018 18:15
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: Unable to get sys.queue for all the users
Hello,
We are unable to get the information for all active users sessions when we use sys.queue as monetdb user.
Also, the tried as user other than monetdb, it returned no access, We had provided the user select privilege on the sys.queue view.
[monetadmin@lnx1487 scripts]$ /monet_binaries/MonetDB-11.27.13_PY/bin/mclient mapi:monetdb://lnx1487:50053/DB_BWS_S
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2017-SP4)
Database: MonetDB v11.27.13 (Jul2017-SP4), 'mapi:monetdb://lnx1487:50053/DB_BWS_S'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>select "user","active",count(*) as "No. Of Connections" from sys.sessions() group by "user","active";
+-------------------+--------+--------------------+
| user | active | No. Of Connections |
+===================+========+====================+
|
DM_POS_BWS_STG_P6 | true | 1 |
| DM_POS_BWS_STG_P6 | false | 3 |
| monetdb | true | 1 |
+-------------------+--------+--------------------+
3 tuples (6.027ms)
sql>select * from sys.queue;
+------+---------+----------------------------+----------------------------+----------+---------+--------+--------------------------+
| qtag | user | started | estimate | progress | status | tag | query |
+======+=========+============================+============================+==========+=========+========+==========================+
| 3630 | monetdb | 2018-11-07 17:07:34.000000 | null | null | running | 3630@0 | select * from sys.queue; |
+------+---------+----------------------------+----------------------------+----------+---------+--------+--------------------------+
1 tuple (1.610ms)
sql>\q
[monetadmin@lnx1487 scripts]$
Thank You,
Gautham