[MonetDB-users] Problems with the query log

Viktor Rosenfeld listuser36 at googlemail.com
Tue Oct 18 18:02:37 CEST 2011


Hi,

I get errors, when I try to use the query history feature as described
here: http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History

After history is set to true, I get the following error message every
time I execute a query:

  invalid/unknown response from server, ignoring output
  ? = 0:0      profiler.setFootprintFlag();
  ? = 0:0      profiler.setMemoryFlag();
  ? = 0:0      inblock := profiler.getDiskReads();
  ? = 0:0      oublock := profiler.getDiskWrites();
  ? = 0:0      xtime := alarm.usec();
  (remaining output omitted, use \fraw to examine in detail)

This only stops if I set history back to false.

I'm using the latest MonetDB 11.5.3 on OS X 10.6.

Below is an example session.

Cheers,
Viktor

-----8< sample session >8-----

$ mclient -d demo -u monetdb 
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP1)
Database: MonetDB v11.5.3, 'demo'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>set history=true;
sql>select 1;
invalid/unknown response from server, ignoring output
? = 0:0      profiler.setFootprintFlag();
? = 0:0      profiler.setMemoryFlag();
? = 0:0      inblock := profiler.getDiskReads();
? = 0:0      oublock := profiler.getDiskWrites();
? = 0:0      xtime := alarm.usec();
(remaining output omitted, use \fraw to examine in detail)
sql>select * from queryHistory;
invalid/unknown response from server, ignoring output
? = 0:0      profiler.setFootprintFlag();
? = 0:0      profiler.setMemoryFlag();
? = 0:0      inblock := profiler.getDiskReads();
? = 0:0      oublock := profiler.getDiskWrites();
? = 0:0      xtime := alarm.usec();
(remaining output omitted, use \fraw to examine in detail)
sql>set history=false;
invalid/unknown response from server, ignoring output
? = 0:0      profiler.setFootprintFlag();
? = 0:0      profiler.setMemoryFlag();
? = 0:0      inblock := profiler.getDiskReads();
? = 0:0      oublock := profiler.getDiskWrites();
? = 0:0      xtime := alarm.usec();
(remaining output omitted, use \fraw to examine in detail)
sql>select * from queryHistory;
+---------+----------------------------+---------+-----------------------------+-------+----------+
| id      | defined                    | name    | query                       | parse | optimize |
+=========+============================+=========+=============================+=======+==========+
| 1035769 | 2011-10-18 15:51:36.000000 | monetdb | select 1;                   |   236 |      208 |
| 1035885 | 2011-10-18 15:51:47.000000 | monetdb | select * from queryhistory; |   300 |      860 |
| 1036047 | 2011-10-18 15:51:50.000000 | monetdb | set history=false;          |   130 |      466 |
+---------+----------------------------+---------+-----------------------------+-------+----------+
3 tuples (1.613ms)
sql>





More information about the users-list mailing list