Re: sys.queue()

After backup and restore in new database, it works : Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014) Database: MonetDB v11.19.3 (Oct2014), 'mapi:monetdb://monetdb:50000/lemonde' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from sys.queue(); +------+---------+----------------------------+----------------------------+----------+---------+-----------+----------------------------+ | qtag | user | started | estimate | progress | status | tag | query | +======+=========+============================+============================+==========+=========+===========+============================+ | 320 | monetdb | 2014-11-06 21:11:00.000000 | null | null | running | 1096372@0 | select * from sys.queue(); | +------+---------+----------------------------+----------------------------+----------+---------+-----------+----------------------------+ 1 tuple (203.682ms) Thank Pierre -- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35 ----- Mail original ----- De: "Sjoerd Mullender" À: users-list@monetdb.org Envoyé: Lundi 3 Novembre 2014 15:57:05 Objet: Re: sys.queue() -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I can reproduce this: Create a new database with the Jan2014 release and try SELECT * FROM sys.queue(); This works. Then use the Oct2014 release on this database and try the query again. This fails. Create a new database with the Oct2014 release. Then the query does work. On 03/11/14 15:37, Brian Hood wrote:

Hi All,

I get the same behaviour on October release

Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014) Database: MonetDB v11.19.3 (Oct2014), 'mapi:monetdb://orville.lan:50000/threatmonitor' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from sys.queue(); SELECT: no such operator 'queue' sql>

On Mon, Nov 3, 2014 at 2:26 PM, Guillaume Bassot mailto:gbassot@inbox.fr> wrote:

Thank you for quick answer. I'm actually speaking of Oct release (Jan release is also working fine for me) :

www-data@monetdb:/home/gbassot$ mclient -d lemonde Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014) Database: MonetDB v11.19.3 (Oct2014), 'mapi:monetdb://monetdb:50000/lemonde' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from sys.queue(); SELECT: no such operator 'queue'

Guillaume BASSOT Web Developer +33 (0)1 55 48 02 82 gbassot@inbox.fr mailto:gbassot@inbox.fr

30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79

2014-11-03 15:14 GMT+01:00 Martin Kersten mailto:martin@monetdb.org>:

Hi

On a freshly built Jan 2014 database it works as expected.

Jan2014> mclient -d Jandemo Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.20.0 (unreleased), 'mapi:monetdb://...:50000/Jandemo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from sys.queue(); +------+---------+----------------------------+----------------------------+----------+---------+-----------+----------------------------+

| qtag | user | started |

estimate | progress | status | tag | query | +======+=========+============================+============================+==========+=========+===========+============================+

| 312 | monetdb | 2014-11-03 14:12:26.000000 |

null | null | running | 1004952@0 | select * from sys.queue(); | +------+---------+--------------------------

Could it be you have used an externally 'enhanced version' of the Jan release?

regards, Martin

On 03/11/14 15:09, Guillaume Bassot wrote:

...

Hello,

On release JAN2014, select * from sys.queue(); is returning all running process.

On release OCT2014 the same command is returning SELECT: no such operator 'queue'

Do i miss a new way to get process list ? Could you please tell me how to do ?

Thanks

Guillaume BASSOT Web Developer +33 (0)1 55 48 02 82 gbassot@inbox.fr mailto:gbassot@inbox.fr

30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79

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

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

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

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

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQCVAwUBVFeXvT7g04AjvIQpAQKJdwQAu+h6OuNIry1MrGnWQL39GQWFnt70IrR+ Pt3b6EwAbZldEVmzKYT1UimXGvwst3XClxT5ytiWe0ALmyWFR8LIXMtiuByLNulC fPFVQsWZEvSOIMt52M3qZO36sBkcNoYQponItUYw4/H/5adR9pQHgA0mcljY0YUS d2U6OsNuuF8= =03a0 -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list