sys.queue() - users-list - monetdb.org

newer
MonetDB - Integrated R Support

sys.queue()

older
Improving performance of bulk...

Guillaume Bassot

3 Nov 2014 3 Nov '14

2:09 p.m.

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

Attachments:

attachment.html (text/html — 2.1 KB)

Reply

Sign in to reply online Use email software

Show replies by date

Martin Kersten

3 Nov 3 Nov

2:14 p.m.

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

Reply

Sign in to reply online Use email software

Guillaume Bassot

2:26 p.m.

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 :

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

Reply

Sign in to reply online Use email software

Brian Hood

2:37 p.m.

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

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

Reply

Sign in to reply online Use email software

Sjoerd Mullender

2:57 p.m.

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

Reply

Sign in to reply online Use email software

Pierre-Adrien Coustillas

6 Nov 6 Nov

9:13 p.m.

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

Reply

Sign in to reply online Use email software

Brian Hood

9:23 p.m.

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" 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" *À: *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

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

Reply

Sign in to reply online Use email software

3776

Age (days ago)

3779

Last active (days ago)

Download

6 comments

5 participants

tags

participants (5)

Brian Hood
Guillaume Bassot
Martin Kersten
Pierre-Adrien Coustillas
Sjoerd Mullender