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 ?

[cid:image001.png@01CF7137.334C4490]

Philippe Gauquelin CIO France DSI France 4 rue André Derain, 78244 Chambourcy Cedex - France IRIworldwide.fr

T +33 1 30 06 22 69 M +33 6 85 82 79 09 E philippe.gauquelin@iriworldwide.commailto:philippe.gauquelin@iriworldwide.com Follow us [cid:image002.png@01CF7137.334C4490]https://twitter.com/IRI_INTL[cid:image003.png@01CF7137.334C4490]http://www.youtube.com/user/SymphonyIRIGroup/[cid:image004.png@01CF7137.334C4490]http://www.linkedin.com/groups/IRIworldwide-INTL-4100694[cid:image005.png@01CF7137.334C4490]http://blog.iriworldwide.eu/

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

Hi

Using sys.queue is purely meant for DBMS system developers (e.g. monetdb root) and indeed very (!!) restrictive . The simple reason is that this provides a complete view of the concurrent queries and thus is a potential security risk.

regards, Martin

On 07/11/2018 18:14, Murthy, Gautham wrote:

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

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list