Bugs item #2900365, was opened at 2009-11-19 11:46 Message generated for change (Comment added) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2900365&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Martin Kersten (mlkersten) Summary: SQL: concurrent tracelog() Initial Comment: When running 2 mclient instances simultaneously, the 1st mclient can run tracelog(), the second cannot (the error message is "SELECT: '(null)' does not return a table"). $ mclient -lsql -p51234 -daap Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.16.0, 'aap' Type \q to quit, \? for a list of available commands auto commit mode: on sql>SELECT * FROM tracelog(); 0 tuples sql> On another prompt: $ mclient -lsql -p51234 -daap Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.16.0, 'aap' Type \q to quit, \? for a list of available commands auto commit mode: on sql>SELECT * FROM tracelog(); SELECT: '(null)' does not return a table sql> ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-11-27 11:42 Message: This report has not been confirmed for initial state. Having multiple clients over the same database scheme and announced the definition of the tracelog function once seems to work as expected. Where there more processes running, e.g. updating the performance tables? Tracing the kernel is a global activity. For interpretation of timings this is a prerequisite. ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-11-19 16:42 Message: when running trace using JDBC, multiple connections to the same database do seem to be able to query tracelog(). (if no mclient is running) however, they are not isolated from each other; work done in one transaction, can be found in a call to tracelog() in another transaction. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2900365&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
