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 BASSOTWeb 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 BASSOTWeb 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
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
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