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