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 30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79
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 https://www.monetdb.org/mailman/listinfo/users-list
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 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 <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
30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79
_______________________________________________ users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
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 <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
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 <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
30, rue Vincent Moris 92240 Malakoff - France Fax : +33 (0)1 55 48 02 79
_______________________________________________ users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list 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
-----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 <gbassot@inbox.fr <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 <martin@monetdb.org <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-----
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" <sjoerd@acm.org> À: 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 <gbassot@inbox.fr <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 <martin@monetdb.org <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
Hi All, I will try reload tommorow does work from what I have seen on the list. Seems like a bug will display my findings. Regards, Brian Hood On Nov 6, 2014 9:14 PM, "Pierre-Adrien Coustillas" <pcoustillas@1g6.biz> wrote:
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
------------------------------ *De: *"Sjoerd Mullender" <sjoerd@acm.org> *À: *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 <gbassot@inbox.fr <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 <martin@monetdb.org <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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (5)
-
Brian Hood -
Guillaume Bassot -
Martin Kersten -
Pierre-Adrien Coustillas -
Sjoerd Mullender