# builtin opt gdk_dbpath = /export/scratch1/home/monet/testing/ae7d186bfa6e-6-1-4/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 = 1 # cmdline opt mapi_listenaddr = all # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /tmp/mtest-1194974/.s.monetdb.${PORT} # cmdline opt gdk_dbpath = /export/scratch1/home/monet/testing/ae7d186bfa6e-6-1-4/tests/sql/dbfarm/mTests_sql_test_BugTracker # cmdline opt gdk_vm_maxsize = 8589934592 # cmdline opt monet_vault_key = /export/scratch1/home/monet/testing/ae7d186bfa6e-6-1-4/tests/sql/dbfarm/mTests_sql_test_BugTracker/.vaultkey #2025-04-05 01:51:27: client0013: parse_date: ERROR: Syntax error in date. #2025-04-05 01:51:27: client0013: VARconvert: ERROR: 22018!conversion of string '12:12:12:99' to type timestamp failed. #2025-04-05 01:51:27: client0013: parse_date: ERROR: Syntax error in date. #2025-04-05 01:51:27: client0013: createExceptionInternal: ERROR: SQLException:batcalc.str_2time_timestamptz_internal:22007!Timestamp '12:12:12:99' has incorrect format #2025-04-05 01:51:27: client0013: parse_date: ERROR: Syntax error in date. #2025-04-05 01:51:27: client0013: createExceptionInternal: ERROR: SQLException:batcalc.str_2time_timestamptz_internal:22007!Timestamp '12:12:12:99' has incorrect format #2025-04-05 01:51:27: client0013: parse_date: ERROR: Syntax error in date. #2025-04-05 01:51:27: client0013: createExceptionInternal: ERROR: ParseException:SQLparser:22007!Incorrect timestamp value (12:12:12:99) in: "insert into foo values(timestamp '12:12:12:99')" #2025-04-05 01:51:27: client0016: numFromStr: ERROR: not a number #2025-04-05 01:51:27: client0016: VARconvert: ERROR: 22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: createExceptionInternal: ERROR: MALException:calc.sht:22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: numFromStr: ERROR: not a number #2025-04-05 01:51:27: client0016: VARconvert: ERROR: 22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: createExceptionInternal: ERROR: MALException:calc.sht:22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: numFromStr: ERROR: not a number #2025-04-05 01:51:27: client0016: VARconvert: ERROR: 22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: createExceptionInternal: ERROR: MALException:calc.sht:22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: numFromStr: ERROR: not a number #2025-04-05 01:51:27: client0016: VARconvert: ERROR: 22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0016: createExceptionInternal: ERROR: MALException:calc.sht:22018!conversion of string '' to type sht failed. #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected ')', expecting SCOLON or ':' in: "select urlid,clicktime from #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: (clicks left outer join urls on #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl0x0=clicks.suburl0x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl0x1=clicks.suburl0x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl1x0=clicks.suburl1x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl1x1=clicks.suburl1x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl2x0=clicks.suburl2x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl2x1=clicks.suburl2x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl3x0=clicks.suburl3x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl3x1=clicks.suburl3x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl4x0=clicks.suburl4x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl4x1=clicks.suburl4x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl5x0=clicks.suburl5x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl5x1=clicks.suburl5x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl6x0=clicks.suburl6x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl6x1=clicks.suburl6x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl7x0=clicks.suburl7x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl7x1=clicks.suburl7x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl8x0=clicks.suburl8x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl8x1=clicks.suburl8x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl9x0=clicks.suburl9x0 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl9x1=clicks.suburl9x1 and #2025-04-05 01:51:27: client0021: createExceptionInternal: ERROR: urls.suburl10x0=clic" #2025-04-05 01:51:27: client0025: createExceptionInternal: ERROR: SQLException:sql.drop_schema:2BM37!DROP SCHEMA: unable to drop schema 'voc' (there are database users using it as session's default schema) #2025-04-05 01:51:27: client0025: createExceptionInternal: ERROR: SQLException:sql.drop_user:M1M05!DROP USER: 'voc' owns a schema #2025-04-05 01:51:27: client0027: createExceptionInternal: ERROR: InvalidCredentialsException:checkCredentials:invalid credentials for user 'invalid' #2025-04-05 01:51:27: client0029: createExceptionInternal: ERROR: SQLException:sql.drop_schema:2BM37!DROP SCHEMA: unable to drop schema 'dbtapestry' (there are database users using it as session's default schema) #2025-04-05 01:51:27: client0031: createExceptionInternal: ERROR: SQLException:sql.trans:2DM30!COMMIT: not allowed in auto commit mode #2025-04-05 01:51:28: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected AT in: "select @" #2025-04-05 01:51:28: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'explain' unknown #2025-04-05 01:51:28: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected AT in: "select @" #2025-04-05 01:51:28: client0037: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: UNIQUE constraint 'test2.test2_t_unique' violated #2025-04-05 01:51:28: client0042: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: cannot drop VIEW 'tables' #2025-04-05 01:51:28: client0042: createExceptionInternal: ERROR: SQLException:sql.drop_view:42000!DROP VIEW: cannot drop system view 'tables' #2025-04-05 01:51:28: client0042: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: cannot drop system table '_tables' #2025-04-05 01:51:28: client0043: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types varchar(23,0) and int(31,0) are not equal for column 'id' #2025-04-05 01:51:28: client0043: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types boolean(1,0) and double(53,0) are not equal for column 'id' #2025-04-05 01:51:28: client0044: BATsubcross: ERROR: more than one match #2025-04-05 01:51:28: client0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-04-05 01:51:28: client0044: BATsubcross: ERROR: more than one match #2025-04-05 01:51:28: client0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-04-05 01:51:28: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "b" specified more than once #2025-04-05 01:51:28: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "b" specified more than once #2025-04-05 01:51:28: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!SELECT: no such column 'a.id' #2025-04-05 01:51:28: wrkr0-lineitem: createExceptionInternal: ERROR: MALException:sql.copy_from:line 1: column 5 l_quantity: 'decimal(15,2)' expected in '17.000' #2025-04-05 01:51:28: client0046: createExceptionInternal: ERROR: SQLException:sql.copy_from:42000!Failed to import table 'lineitem', line 1: column 5 l_quantity: 'decimal(15,2)' expected in '17.000' #2025-04-05 01:51:28: client0060: createExceptionInternal: ERROR: ParseException:SQLparser:42S21!ALTER TABLE: a column named 'col' already exists #2025-04-05 01:51:28: client0062: createExceptionInternal: ERROR: SQLException:sql.revoke_role:01006!REVOKE: no such role 'auth1' or grantee 'user1' #2025-04-05 01:51:28: client0067: createExceptionInternal: ERROR: ParseException:SQLparser:22003!Decimal(40,0) isn't supported because P=40 > 38 in: "create table tab2 (col1 decimal(40,0)" #2025-04-05 01:51:28: client0067: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected NOT in: "not null" #2025-04-05 01:51:28: client0069: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: FOREIGN KEY constraint 't1703497b.t1703497b_id_fkey' violated #2025-04-05 01:51:28: client0070: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: FOREIGN KEY constraint 't1703497b.t1703497b_id_fkey' violated #2025-04-05 01:51:28: client0070: createExceptionInternal: ERROR: SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) #2025-04-05 01:51:28: client0070: createExceptionInternal: ERROR: SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) #2025-04-05 01:51:28: client0070: createExceptionInternal: ERROR: SQLException:sql.commit:40000!COMMIT: transaction is aborted, will ROLLBACK instead #2025-04-05 01:51:28: client0078: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such operator 'f'(tinyint) #2025-04-05 01:51:28: client0078: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!DROP VIEW: no such view 'v1' #2025-04-05 01:51:28: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!DROP TABLE: no such table 't1715669a' #2025-04-05 01:51:28: client0086: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function #2025-04-05 01:51:28: client0089: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: PRIMARY KEY constraint 't1733712a.t1733712a_id_pkey' violated #2025-04-05 01:51:29: client0090: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: FOREIGN KEY constraint 't1734143b.t1734143b_id_fkey' violated #2025-04-05 01:51:29: client0091: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: FOREIGN KEY constraint 't1737668a.fk_t1_id_t2_id' violated #2025-04-05 01:51:29: client0091: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: FOREIGN KEY constraint 't1737668a.fk_t1_age_t3_age' violated #2025-04-05 01:51:29: client0098: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: NOT NULL constraint violated for column decimal_null.promoid #2025-04-05 01:51:29: client0098: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: NOT NULL constraint violated for column decimal_null.promoid #2025-04-05 01:51:29: client0100: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types smallint(13,0) and date(0,0) are not equal #2025-04-05 01:51:29: client0106: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected SMALLINT in: "select '' as one, i.* from int2_tbl i where (i.f1 % smallint" #2025-04-05 01:51:29: wrkr0-bulk: numFromStr: ERROR: overflow: "53605" does not fit in sht #2025-04-05 01:51:29: wrkr0-bulk: createExceptionInternal: ERROR: MALException:sql.copy_from:line 2: column 1 num: 'smallint' expected in '53605' #2025-04-05 01:51:29: client0108: createExceptionInternal: ERROR: SQLException:sql.copy_from:42000!Failed to import table 'bulk', line 2: column 1 num: 'smallint' expected in '53605' #2025-04-05 01:51:29: client0111: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!ALTER TABLE: no such column 'bar' #2025-04-05 01:51:29: client0113: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!INSERT INTO: no such table 'temptest' #2025-04-05 01:51:29: client0113: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!DROP TABLE: no such table 'temptest' #2025-04-05 01:51:29: client0115: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table t1884382a (there are database objects which depend on it) #2025-04-05 01:51:29: client0115: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table t1884382b (there are database objects which depend on it) #2025-04-05 01:51:29: client0117: mergejoin: ERROR: more than one match #2025-04-05 01:51:29: client0117: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-04-05 01:51:29: client0117: mergejoin: ERROR: more than one match #2025-04-05 01:51:29: client0117: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-04-05 01:51:29: client0128: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RETURN: TABLE return not allowed for non table returning functions #2025-04-05 01:51:29: client0128: createExceptionInternal: ERROR: ParseException:SQLparser:42000!DROP FUNCTION: no such function 'fdoccolumnswithrank' #2025-04-05 01:51:29: client0134: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'id' in query results without an aggregate function #2025-04-05 01:51:31: client0141: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 'testusers.testusers_id_pkey' violated #2025-04-05 01:51:33: client0156: createExceptionInternal: ERROR: SQLException:sql.alter_table:40002!ALTER TABLE: NOT NULL constraint violated for column foo.i