Re: New Oct2014 - JDBC unable to connect to the database

11 Nov 2014


      Hi,
I reverted the virtual machine and checked the version. It is my fault. 
Upgraded machine had version of MonetDB:
ceos@lux-dev1-ana:~$ monetdbd version
MonetDB Database Server v1.7 (Feb2013-SP6)
Will upgrade first.
Thank you,
Radovan
On 11/11/2014 09:52 AM, Dimitar Nedev wrote:
...
Hi Radovan,
When a client connects to a database for a first time, MonetDB executes a set of scripts to prepare the database, including upgrade instructions.
In this case, when the connection over JDBC is established, the same scripts are executed. As such, the issues is not in the JDBC connection specifically, but with running the scripted database upgrade commands.
One important note, upgrading to Oct2014 requires upgrading to Jan2014 first.
Best regards,
Dimitar
...
On 2014-Nov-11, at 09:15 , Radovan Bičiště radovan.biciste@ceosdata.com wrote:
Hi,
I found additional information in MonetDB log that shows right after connect attempt:
2014-11-11 09:11:48 MSG merovingian[1866]: proxying client 172.26.52.11:33333 for database 'zkdev1' to mapi:monetdb:///u01/ceosdata/database/monetdb/drmax/crm/zkdev1/.mapi.sock?database=zkdev1
2014-11-11 09:11:48 MSG merovingian[1866]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2014-11-11 09:11:48 MSG zkdev1[2144]: Running database upgrade commands:
2014-11-11 09:11:48 MSG zkdev1[2144]: set schema "sys";
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure sys.resetHistory;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure sys.keepCall;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure sys.keepQuery;
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables set system = false where name in ('callhistory','queryhistory','querylog') and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: drop view sys.queryLog;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop table sys.callHistory;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop table sys.queryHistory;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.querylog_catalog()
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table(
2014-11-11 09:11:48 MSG zkdev1[2144]:   id oid,
2014-11-11 09:11:48 MSG zkdev1[2144]:   owner string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   defined timestamp,
2014-11-11 09:11:48 MSG zkdev1[2144]:   query string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   pipe string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   mal int, -- size of MAL plan
2014-11-11 09:11:48 MSG zkdev1[2144]:   optimize bigint         -- time in usec
2014-11-11 09:11:48 MSG zkdev1[2144]: )
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_catalog;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.querylog_calls()
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table(
2014-11-11 09:11:48 MSG zkdev1[2144]:   id oid,  -- references query plan
2014-11-11 09:11:48 MSG zkdev1[2144]:   "start" timestamp,      -- time the statement was started
2014-11-11 09:11:48 MSG zkdev1[2144]:   "stop" timestamp,       -- time the statement was completely finished
2014-11-11 09:11:48 MSG zkdev1[2144]:   arguments string,       -- actual call structure
2014-11-11 09:11:48 MSG zkdev1[2144]:   tuples wrd, -- number of tuples in the result set
2014-11-11 09:11:48 MSG zkdev1[2144]:   run bigint,             -- time spent (in usec)  until the result export
2014-11-11 09:11:48 MSG zkdev1[2144]:   ship bigint,            -- time spent (in usec)  to ship the result set
2014-11-11 09:11:48 MSG zkdev1[2144]:   cpu int,                -- average cpu load percentage during execution
2014-11-11 09:11:48 MSG zkdev1[2144]:   io int,                 -- percentage time waiting for IO to finish
2014-11-11 09:11:48 MSG zkdev1[2144]:   space bigint            -- total storage size of intermediates created (in MB)
2014-11-11 09:11:48 MSG zkdev1[2144]: )
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_calls;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.querylog_catalog as select * from sys.querylog_catalog();
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.querylog_calls as select * from sys.querylog_calls();
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.querylog_history as
2014-11-11 09:11:48 MSG zkdev1[2144]: select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, ql.cpu, ql.space, ql.io
2014-11-11 09:11:48 MSG zkdev1[2144]: from sys.querylog_catalog() qd, sys.querylog_calls() ql
2014-11-11 09:11:48 MSG zkdev1[2144]: where qd.id = ql.id and qd.owner = user;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables
2014-11-11 09:11:48 MSG zkdev1[2144]:     set system = true
2014-11-11 09:11:48 MSG zkdev1[2144]:     where name in ('querylog_history', 'querylog_calls', 'querylog_catalog')
2014-11-11 09:11:48 MSG zkdev1[2144]:         and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.querylog_empty()
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_empty;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.querylog_enable()
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_enable;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.querylog_enable(threshold smallint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_enable_threshold;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.querylog_disable()
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.querylog_disable;
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.tracelog as select * from sys.tracelog();
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function sys.clients;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.sessions() returns table("user" string, "login" timestamp, "sessiontimeout" bigint, "lastcommand" timestamp, "querytimeout" bigint, "active" bool) external name sql.sessions;
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.sessions as select * from sys.sessions();
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.shutdown(delay tinyint) external name sql.shutdown;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.shutdown(delay tinyint, force bool) external name sql.shutdown;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.settimeout("query" bigint) external name sql.settimeout;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.settimeout("query" bigint, "session" bigint) external name sql.settimeout;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.setsession("timeout" bigint) external name sql.setsession;
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.optimizers as select * from sys.optimizers();
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.environment as select * from sys.environment();
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.queue()
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table(
2014-11-11 09:11:48 MSG zkdev1[2144]:   qtag bigint,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "user" string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   started timestamp,
2014-11-11 09:11:48 MSG zkdev1[2144]:   estimate timestamp,
2014-11-11 09:11:48 MSG zkdev1[2144]:   progress int,
2014-11-11 09:11:48 MSG zkdev1[2144]:   status string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   tag oid,
2014-11-11 09:11:48 MSG zkdev1[2144]:   query string
2014-11-11 09:11:48 MSG zkdev1[2144]: )
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_queue;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.queue as select * from sys.queue();
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables
2014-11-11 09:11:48 MSG zkdev1[2144]:     set system = true
2014-11-11 09:11:48 MSG zkdev1[2144]:     where name = 'queue'
2014-11-11 09:11:48 MSG zkdev1[2144]:         and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.pause(tag int)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_pause;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.resume(tag int)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_resume;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.stop(tag int)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_stop;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.pause(tag bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_pause;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.resume(tag bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_resume;
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure sys.stop(tag bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.sysmon_stop;
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val TINYINT, q DOUBLE) returns TINYINT external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val SMALLINT, q DOUBLE) returns SMALLINT external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val INTEGER,2014-11-11 09:11:48 ERR zkdev1[2144]: !ParseException:SQLparser:SELECT: no such operator 'tracelog'
2014-11-11 09:11:48 MSG zkdev1[2144]:  q DOUBLE) returns INTEGER external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val WRD, q DOUBLE) returns WRD external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val BIGINT, q DOUBLE) returns BIGINT external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val DECIMAL, q DOUBLE) returns DECIMAL external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val REAL, q DOUBLE) returns REAL external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val DOUBLE, q DOUBLE) returns DOUBLE external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val DATE, q DOUBLE) returns DATE external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val TIME, q DOUBLE) returns TIME external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate quantile(val TIMESTAMP, q DOUBLE) returns TIMESTAMP external name "aggr"."quantile";
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate median(val DECIMAL) returns DECIMAL external name "aggr"."median";
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.storage as select * from sys.storage();
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.storagemodel as select * from sys.storagemodel();
2014-11-11 09:11:48 MSG zkdev1[2144]: CREATE TABLE sys.statistics(
2014-11-11 09:11:48 MSG zkdev1[2144]:   "schema" string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "table" string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "column" string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "type" string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   width integer,
2014-11-11 09:11:48 MSG zkdev1[2144]:   stamp timestamp,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "sample" bigint,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "count" bigint,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "unique" bigint,
2014-11-11 09:11:48 MSG zkdev1[2144]:   "nils" bigint,
2014-11-11 09:11:48 MSG zkdev1[2144]:   minval string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   maxval string,
2014-11-11 09:11:48 MSG zkdev1[2144]:   sorted boolean);
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables
2014-11-11 09:11:48 MSG zkdev1[2144]:   set system = true
2014-11-11 09:11:48 MSG zkdev1[2144]:   where name = 'statistics'
2014-11-11 09:11:48 MSG zkdev1[2144]:           and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze()
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(tbl string)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(sch string, tbl string)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(sch string, tbl string, col string)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze("sample" bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(tbl string, "sample" bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(sch string, tbl string, "sample" bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create procedure analyze(sch string, tbl string, col string, "sample" bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name sql.analyze;
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('json_filter', 'json_filter_all', 'json_isvalid', 'json_isvalidarray', 'json_isvalidobject', 'json_length', 'json_path', 'json_text', 'querylog_calls', 'querylog_catalog', 'queue', 'sessions') and f.type = 1 and f.schema_id = s.id and s.name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('analyze', 'pause', 'querylog_disable', 'querylog_empty', 'querylog_enable', 'resume', 'setsession', 'settimeout', 'shutdown', 'stop', 'sysmon_resume') and f.type = 2 and f.schema_id = s.id and s.name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('quantile', 'median') and f.type = 3 and f.schema_id = s.id and s.name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables set system = true where name in ('environment', 'optimizers', 'queue', 'sessions', 'statistics', 'storage', 'storagemodel', 'tracelog') and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure gzcompress;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure gzcdeompress;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure gzctruncate;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop procedure gzcexpand;
2014-11-11 09:11:48 MSG zkdev1[2144]: set schema "drmaxtst";
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: Running database upgrade commands:
2014-11-11 09:11:48 MSG zkdev1[2144]: set schema "sys";
2014-11-11 09:11:48 MSG zkdev1[2144]: delete from _columns where table_id not in (select id from _tables);
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into _columns values( (select max(id)+1 from _columns), 'system', 'boolean', 1, 0, (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='schemas'), NULL, true, 4, NULL);
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into _columns values( (select max(id)+1 from _columns), 'varres', 'boolean', 1, 0, (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions'), NULL, true, 7, NULL);
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into _columns values( (select max(id)+1 from _columns), 'vararg', 'boolean', 1, 0, (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions'), NULL, true, 8, NULL);
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into _columns values( (select max(id)+1 from _columns), 'inout', 'tinyint', 8, 0, (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='args'), NULL, true, 6, NULL);
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into _columns values( (select max(id)+1 from _columns), 'language', 'int', 32, 0, (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions'), NULL, true, 9, NULL);
2014-11-11 09:11:48 MSG zkdev1[2144]: delete from _columns where table_id in (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions') and name='sql';
2014-11-11 09:11:48 MSG zkdev1[2144]: update _columns set number='9' where name = 'schema_id' and table_id in (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions');
2014-11-11 09:11:48 MSG zkdev1[2144]: update _columns set number='7' where name = 'number' and table_id in (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='args');
2014-11-11 09:11:48 MSG zkdev1[2144]: update _columns set number='4' where name = 'language' and table_id in (select _tables.id from _tables join schemas on _tables.schema_id=schemas.id where schemas.name='sys' and _tables.name='functions');
2014-11-11 09:11:48 MSG zkdev1[2144]: delete from _columns where table_id in (select id from _tables where name like '#%');
2014-11-11 09:11:48 MSG zkdev1[2144]: delete from _tables where name like '#%';
2014-11-11 09:11:48 MSG zkdev1[2144]: create table upgradeOct2014 as (select * from functions where type = 5 and language <> 0) with data;
2014-11-11 09:11:48 MSG zkdev1[2144]: create table upgradeOct2014_changes (c bigint);
2014-11-11 09:11:48 MSG zkdev1[2144]: create function drop_func_upgrade_oct2014( id integer ) returns int external name sql.drop_func_upgrade_oct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into upgradeOct2014_changes select drop_func_upgrade_oct2014(id) from upgradeOct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function drop_func_upgrade_oct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function create_func_upgrade_oct2014( f string ) returns int external name sql.create_func_upgrade_oct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into upgradeOct2014_changes select create_func_upgrade_oct2014(func) from upgradeOct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function create_func_upgrade_oct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop table upgradeOct2014_changes;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop table upgradeOct2014;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function sys.bbp;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.bbp() returns table (id int, name string, htype string, ttype string, count BIGINT, refcnt int, lrefcnt int, location string, heat int, dirty string, status string, kind string) external name bbp.get;
2014-11-11 09:11:48 MSG zkdev1[2144]: create schema json;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create type json external name json;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.filter(js json, pathexpr string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns json external name json.filter;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.filter(js json, name tinyint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns json external name json.filter;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.filter(js json, name integer)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns json external name json.filter;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.filter(js json, name bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns json external name json.filter;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.text(js json, e string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns string external name json.text;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.number(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns float external name json.number;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json."integer"(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bigint external name json."integer";
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isvalid(js string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isvalid;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isobject(js string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isobject;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isarray(js string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isarray;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isvalid(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isvalid;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isobject(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isobject;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.isarray(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns bool external name json.isarray;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.length(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns integer external name json.length;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.keyarray(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns json external name json.keyarray;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.valuearray(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns  json external name json.valuearray;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.text(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns string external name json.text;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.text(js string)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns string external name json.text;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function json.text(js int)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns string external name json.text;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate json.output(js json)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns string external name json.output;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate json.tojsonarray( x string ) returns string external name aggr.jsonaggr;
2014-11-11 09:11:48 MSG zkdev1[2144]: create aggregate json.tojsonarray( x double ) returns string external name aggr.jsonaggr;
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys.schemas set system = true where name = 'json';
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('filter', 'text', 'number', 'integer', 'isvalid', 'isobject', 'isarray', 'length', 'keyarray', 'valuearray') and f.type = 1 and f.schema_id = s.id and s.name = 'json');
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('output', 'tojsonarray') and f.type = 3 and f.schema_id = s.id and s.name = 'json');
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.md5(v string) returns string external name clients.md5sum;
2014-11-11 09:11:48 MSG zkdev1[2144]: create type uuid external name uuid;
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.uuid() returns uuid external name uuid."new";
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.isaUUID(u uuid) returns uuid external name uuid."isaUUID";
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables set system = false where name in ('storage','storagemodel','tablestoragemodel') and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: drop view sys.storage;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function sys.storage();
2014-11-11 09:11:48 MSG zkdev1[2144]: drop view sys.storagemodel;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop view sys.tablestoragemodel;
2014-11-11 09:11:48 MSG zkdev1[2144]: drop function sys.storagemodel();
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.storage() returns table ("schema" string, "table" string, "column" string, "type" string, location string, "count" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, imprints bigint, sorted boolean) external name sql.storage;
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.storage as select * from sys.storage();
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.hashsize(b boolean, i bigint) returns bigint begin if  b = true then return 8 * i; end if; return 0; end;create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int'  or nme = 'bigint'      or nme = 'decimal'       or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast( i * 0.12 as bigint); end if ; return 0; end;create function sys.storagemodel() returns table (    "schema" string, "table" string, "column" string, "type" string, "count" bigint,    columnsize bigint, heapsize bigint, hashes bigint, imprints bigint, sorted boolean)      begin return select I."schema", I."table", I."column", I."type", I."count",             columnsize(I."type", I.count, I."distinct"),            heapsize(I."type", I."distinct", I."atomwidth"),                hashsize(I."reference", I."count"),        imprintsize(I."count",I."
type"),I.sorted                from sys.storagemodelinput I;   end;
...
...
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.tablestoragemodel as select "schema","table",max(count) as "count",    sum(columnsize) as columnsize,    sum(heapsize) as heapsize,    sum(hashes) as hashes, sum(imprints) as imprints,    sum(case when sorted = false then 8 * count else 0 end) as auxillary from sys.storagemodel() group by "schema","table";
2014-11-11 09:11:48 MSG zkdev1[2144]: create view sys.storagemodel as select * from sys.storagemodel();
2014-11-11 09:11:48 MSG zkdev1[2144]: update sys._tables set system = true where name in ('storage','storagemodel','tablestoragemodel') and schema_id = (select id from sys.schemas where name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first tinyint, last tinyint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value tinyint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value tinyint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first int, last int)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value int)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first int, last int, stepsize int)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value int)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first bigint, last bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first bigint, last bigint, stepsize bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value bigint)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first real, last real, stepsize real)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value real)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first double, last double, stepsize double)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns t2014-11-11 09:11:48 MSG zkdev1[2144]: able (value double)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first decimal(10,2), last decimal(10,2), stepsize decimal(10,2))
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value decimal(10,2))
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]:
2014-11-11 09:11:48 MSG zkdev1[2144]: create function sys.generate_series(first timestamp, last timestamp, stepsize interval second)
2014-11-11 09:11:48 MSG zkdev1[2144]: returns table (value timestamp)
2014-11-11 09:11:48 MSG zkdev1[2144]: external name generator.series;
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('hashsize', 'imprintsize', 'isauuid', 'md5', 'uuid') and f.type = 1 and f.schema_id = s.id and s.name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('bbp', 'db_users', 'env', 'generate_series', 'storage', 'storagemodel', 'var') and f.type = 5 and f.schema_id = s.id and s.name = 'sys');
2014-11-11 09:11:48 MSG zkdev1[2144]: set schema "sys";
2014-11-11 09:11:48 MSG zkdev1[2144]:
Thanks,
Radovan
On 11/11/2014 09:07 AM, Radovan Bičiště wrote:
...
Hello,
Today I've started to test Oct2014 release. I upgraded the database with
no issues and downloaded latest JDBC driver monet-jdbc-2.12.jar .
When I try to connect to the upgrade database I get an error about
tracelog.
Here is the log file:
2014-11-11 08:54 INFO  Creating new connection for [{Default
group}/DRMAX - DEV] for driver=nl.cwi.monetdb.jdbc.MonetDriver and
URL=[jdbc:monetdb://lux-dev1-ana.dev.ceosdata.com:50000/zkdev1]
2014-11-11 08:54 INFO  Adding ClassLoader
URL=file:/home/rbiciste/tools/lib/monetdb-jdbc-2.12.jar
2014-11-11 08:54 ERROR Error connecting to the database using
URL=jdbc:monetdb://lux-dev1-ana.dev.ceosdata.com:50000/zkdev1,
username=drmaxtst SELECT: no such operator 'tracelog' [SQL State=08001]
java.sql.SQLException: SELECT: no such operator 'tracelog'
   at
nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:254)
   at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:171)
   at workbench.db.DbDriver.connect(DbDriver.java:429)
   at workbench.db.ConnectionMgr.connect(ConnectionMgr.java:228)
   at workbench.db.ConnectionMgr.getConnection(ConnectionMgr.java:158)
   at
workbench.gui.components.ConnectionSelector.doConnect(ConnectionSelector.java:233)
at
workbench.gui.components.ConnectionSelector$2.run(ConnectionSelector.java:133)
Caused by: nl.cwi.monetdb.mcl.MCLException: SELECT: no such operator
'tracelog'
   at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:311)
   at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:398)
   at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:252)
   at
nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:232)
   ... 6 more
Any help would be appreciated.
Thank you,
Radovan

users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
-- 
__________________________

Radovan Bičiště
ceos data s.r.o.
Pouchovská 153
500 03 Hradec Králové
Czech Republic

mobil CZ: +420 601 563 014
skype: rbiciste