Hi,
sys.queue we should not either. We write all requests into a text file upon execution and write the execution time soon end.
Except monetdb crash ( almost never ) this solution works perfectly.
Pierre
De: "Vijay Krishna"
À: "Communication channel for MonetDB users"
Envoyé: Mercredi 30 Mars 2016 09:19:07
Objet: Re: Find all running processes?
Hi,
I am still unable to find a way to see all running queries in MonetDB. Still getting the same output for sys.queue as in the previous mail (in this thread).
Similar to logging, is it like I should enable something to get results from queue also?
Clearly am missing something. Can someone please help me with this?
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
On Thu, Aug 13, 2015 at 11:13 AM, Vijay Krishna < vijayakrishna55@gmail.com > wrote:
How to find all running processes and their statuses in MonetDB??
I found this...
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/monitor
But I couldn't get this work... I ran a query (which took some 20 seconds to complete) in a window and connected the same database in another terminal and ran "select * from sys.queue" (several times during those 20 seconds) but I could get only this...
sql>select * from sys.queue;
+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+
| qtag | user | started | estimate | progress | status | tag | query |
+=======+=========+============================+============================+==========+=========+============+==========================+
| 27339 | monetdb | 2015-08-13 05:35:40.000000 | null | null | running | 12532134@0 | select * from sys.queue; |
+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+
I am using Oct-2014 version of monetdb on CentOS...
Is there a way to find all running processes and their statuses in MonetDB??
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
