# builtin opt gdk_dbpath = C:/cygwin64/home/monet/testing/f8e03e321dba-8-1-1/install/var\monetdb5\dbfarm\demo # builtin opt mapi_port = 50000 # builtin opt sql_optimizer = default_pipe # builtin opt sql_debug = 0 # builtin opt raw_strings = false # cmdline opt gdk_nr_threads = 0 # cmdline opt mapi_listenaddr = all # cmdline opt mapi_port = 0 # cmdline opt gdk_dbpath = C:\cygwin64\home\monet\testing\f8e03e321dba-8-1-1\tests\sql\dbfarm\mTests_sql_test_mergetables # cmdline opt monet_vault_key = C:\cygwin64\home\monet\testing\f8e03e321dba-8-1-1\tests\sql\dbfarm\mTests_sql_test_mergetables\.vaultkey #2024-04-26 00:37:49: client0015: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a view into a MERGE TABLE #2024-04-26 00:37:50: client0033: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'emptym' should have at least one table associated #2024-04-26 00:37:50: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'unknowntable' #2024-04-26 00:37:50: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'part1' #2024-04-26 00:37:50: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'mys'.'part1' #2024-04-26 00:37:50: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'mys'.'smalltable' should have at least one table associated #2024-04-26 00:37:51: client0035: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column type doesn't match MERGE TABLE definition #2024-04-26 00:37:51: client0035: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column type doesn't match MERGE TABLE definition #2024-04-26 00:37:51: client0035: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'complete' should have at least one table associated #2024-04-26 00:37:51: client0036: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: table 'sys.part1' is already part of MERGE TABLE 'sys.complete' #2024-04-26 00:37:51: client0036: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: table 'sys.part2' is already part of MERGE TABLE 'sys.complete' #2024-04-26 00:37:52: client0043: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table part1 (there are database objects which depend on it) #2024-04-26 00:37:52: client0043: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table part2 (there are database objects which depend on it) #2024-04-26 00:37:53: client0053: createExceptionInternal: ERROR: SQLException:sql.alter_table_set_access:42000!ALTER TABLE: access changes on MERGE TABLES not supported #2024-04-26 00:37:53: client0058: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.t1' isn't part of MERGE TABLE 'sys.m' #2024-04-26 00:37:53: client0058: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 't1' #2024-04-26 00:37:53: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COPY INTO: cannot copy into merge table 'part1' #2024-04-26 00:37:53: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected INTNUM in: "0.0" #2024-04-26 00:37:53: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COPY INTO: cannot copy into merge table 'part2' #2024-04-26 00:37:53: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected INTNUM in: "2.0" #2024-04-26 00:37:53: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'part1' should have at least one table associated #2024-04-26 00:37:54: client0061: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column NULL check doesn't match MERGE TABLE definition #2024-04-26 00:37:54: client0061: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column NULL check doesn't match MERGE TABLE definition #2024-04-26 00:37:54: client0061: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 'part2.part2_x_pkey' violated #2024-04-26 00:37:54: client0061: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 'part1.part1_x_pkey' violated #2024-04-26 00:37:54: client0061: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: cannot insert into merge table 'complete' #2024-04-26 00:37:54: client0066: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10. #2024-04-26 00:37:54: client0066: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10. #2024-04-26 00:37:54: client0066: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10. #2024-04-26 00:37:54: client0066: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10. #2024-04-26 00:37:55: client0072: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: cannot add table 'sys.tmp2' to TABLE 'sys.tmp1' #2024-04-26 00:37:55: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'t2' should have at least one table associated #2024-04-26 00:37:55: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'t2' should have at least one table associated #2024-04-26 00:37:55: client0077: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!SELECT: no such column 'ref_12.b' #2024-04-26 00:37:55: client0088: exp_bin: CRITICAL: Could not find %34.%34 #2024-04-26 00:37:55: client0088: exp_bin: ERROR: Query: 'select #2024-04-26 00:37:56: client0093: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt2' should have at least one table associated #2024-04-26 00:37:56: client0093: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt1' should have at least one table associated #2024-04-26 00:37:56: client0093: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt1' should have at least one table associated #2024-04-26 00:37:56: client0093: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt2' should have at least one table associated #2024-04-26 00:37:56: client0095: createExceptionInternal: ERROR: SQLException:sql.drop_schema:3F000!DROP SCHEMA: name concurrent_mt does not exist #2024-04-26 00:37:57: client0098: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:58: client0102: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:58: client0111: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0124: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0122: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0120: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0129: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0133: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0134: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0136: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:37:59: client0137: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:38:00: client0140: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:38:00: client0142: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:38:01: client0151: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'parent' should have at least one table associated #2024-04-26 00:38:01: client0151: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'parent' should have at least one table associated #2024-04-26 00:38:01: client0152: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'parent' should have at least one table associated #2024-04-26 00:38:01: client0152: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'parent' should have at least one table associated #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE TABLE: cannot create persistent table 'tbl' in the schema 'tmp' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: cannot create persistent table 'mtbl' in the schema 'tmp' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'tst'.'mtbl' should have at least one table associated #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42000!ALTER TABLE: a MERGE TABLE can't be a child of itself #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE REPLICA TABLE: cannot create persistent table 'rtbl' in the schema 'tmp' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'rtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'rtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'tst'.'rtbl' should have at least one table associated #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'tst'.'rtbl' should have at least one table associated #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE UNLOGGED TABLE: cannot create persistent table 'utbl' in the schema 'tmp' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'utbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'utbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE REMOTE TABLE: cannot create persistent table 'rmtbl' in the schema 'tmp' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'rmtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:01: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'rmtbl' #2024-04-26 00:38:06: DFLOWworker0032: createExceptionInternal: ERROR: IOException:remote.connect:unable to connect to 'mapi:monetdb://localhost:50000/demo': could not connect: Connection refused #2024-04-26 00:38:06: DFLOWworker0032: createExceptionInternal: ERROR: IllegalArgumentException:remote.put:Illegal argument: connection name is NULL or nil #2024-04-26 00:38:06: DFLOWworker0032: createExceptionInternal: ERROR: MALException:user.%1[29]:Exception occurred in the remote server, please check the log there #2024-04-26 00:38:10: DFLOWworker0003: createExceptionInternal: ERROR: IOException:remote.connect:unable to connect to 'mapi:monetdb://localhost:50000/demo': could not connect: Connection refused #2024-04-26 00:38:10: DFLOWworker0003: createExceptionInternal: ERROR: IllegalArgumentException:remote.put:Illegal argument: connection name is NULL or nil #2024-04-26 00:38:10: DFLOWworker0003: createExceptionInternal: ERROR: MALException:user.%2[29]:Exception occurred in the remote server, please check the log there #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!CREATE TABLE: local temporary tables should be stored in the 'tmp' schema #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a temporary table into a MERGE TABLE #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!CREATE TABLE: global temporary tables should be stored in the 'tmp' schema #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl' #2024-04-26 00:38:10: client0153: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a temporary table into a MERGE TABLE #2024-04-26 00:38:10: client0154: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:38:12: client0157: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead #2024-04-26 00:38:12: client0161: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: access denied for kate to table 'sys.allparts' #2024-04-26 00:38:12: client0161: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: access denied for kate to table 'sys.allparts_2' #2024-04-26 00:38:12: client0161: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'm' unknown #2024-04-26 00:38:12: client0162: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'm' unknown