Hi,

I was trying to save my history based on this documentation http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History

And this is what is happening:

$ mclient -dtest-db -umonetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP2) Database: MonetDB v11.5.7 (Aug2011-SP2), 'test-db' Type \q to quit, ? for a list of available commands auto commit mode: on sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.623ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; +------+ | L5 | +======+ | 2785 | +------+ 1 tuple (1.6s) sql>set history=true; sql>select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (0.232ms) sql>select count(*) from narvq.narvq where zip5 = '81657'; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _23:any := user.keepquery(_24:wrd, _25:str, _26:lng, _27:lng) TypeException:user.s0_1[32]:'user.keepcall' undefined in: _73:any := user.keepcall(_24:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select * from queryHistory; TypeException:user.s5_1[1]:'user.keepquery' undefined in: _43:any := user.keepquery(_44:wrd, _45:str, _46:lng, _47:lng) TypeException:user.s5_1[48]:'user.keepcall' undefined in: _111:any := user.keepcall(_44:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>select 1; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _12:any := user.keepquery(_13:wrd, _14:str, _15:lng, _16:lng) TypeException:user.s0_1[24]:'user.keepcall' undefined in: _55:any := user.keepcall(_13:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>set history=false; TypeException:user.s0_1[1]:'user.keepquery' undefined in: _2:any := user.keepquery(_3:wrd, _4:str, _5:lng, _6:lng) TypeException:user.s0_1[19]:'user.keepcall' undefined in: _41:any := user.keepcall(_3:wrd, ctime:timestamp, args:str, xtime:lng, rtime:lng, foot:lng, memory:lng, tuples:wrd, inblock:lng, oublock:lng) SQLException:SQLengine:Program contains errors sql>

SERVER INFORMATION: It is a Amazon Web Services Linux distribution (based on CentOS) $ mserver5 --version MonetDB 5 server v11.5.7 "Aug2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://www.monetdb.org/ for further information Found 7.3GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e-fips 6 Sep 2011) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: ec2-user@domU-12-31-39-0E-8D-F2 (x86_64-unknown-linux-gnu) Compilation: gcc -g -O2 Linking : /usr/bin/ld -m elf_x86_64

I will really appreciate any help provided.

Thanks,

Roberto F