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

11 Nov 2014

      Hi Radovan,

the tracelog error you get suggests that you upgraded directly from a pre-Jan2014 release to the Oct2014 release.

As our release notes (https://www.monetdb.org/Downloads/ReleaseNotes)
suggest, from a pre-Jan2014 release, you should upgrade to Jan2014, first,
before upgrading to Oct2014: 

"
Known issue when upgrading old versions. We have noticed that upgrading directly from a version older than the Jan2014 release gave an error. Upgrading to Jan2014 first and then on to Oct2014 should work.

Backup. As always, make a backup of your databases before upgrading.
"

You can now (still) try to upgrade your database(s) to Jan2014, first, and then to Oct2014.

As also suggested in the release notes and above,
backing-up your database before upgrading is always highly recommended.

Best,
Stefan

----- Original Message -----
...
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ě 
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
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
-- 
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

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

Stefan Manegold