# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_Dependencies', using 8 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 31.303 GiB available main-memory of which we use 25.512 GiB
# Virtual memory usage limited to 8.000 GiB
# Copyright (c) 2024 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab05.da.cwi.nl:42503/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2164227/.s.monetdb.42503
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: create user "monet_test" with password 'pass_test' name 'TEST_USER' schema "sys"
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: create schema "test" authorization "monet_test"
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: drop user monetdb
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: alter user "monet_test" set schema "test"
#2024-04-26 00:58:50: client0019: SQLrun: INFO: Executing: drop schema test
#2024-04-26 00:58:50: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0020: SQLrun: INFO: Executing: drop user monetdb
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create table t1(id int, name varchar(1024), age int, primary key(id))
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create view v1 as select id, age from t1 where name like 'monet%'
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create view v2 as select * from v1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create function f1(num int)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create function f2()
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create index id_index on t1(id)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create table t2 (id_t1 int, age_v1 int)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: alter table t2 add foreign key(id_t1) references t1(id)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create trigger trigger_test after insert on t1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create table t3 (id int)
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: create trigger trigger_test_4 after insert on t1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select s.name, u.name, 'DEP_USER' from sys.schemas as s, users u where u.default_schema = s.id order by s.name, u.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select a.name, s.name, 'DEP_SCHEMA' from sys.schemas as s, auths a where s.owner = a.id order by a.name, s.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select t.name, v.name, 'DEP_VIEW' from sys.tables as t, sys.tables as v, sys.dependencies as dep where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type = 1 order by t.name, v.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select t.name, i.name, 'DEP_INDEX' from sys.tables as t, sys.idxs as i where i.table_id = t.id and i.name not in (select name from sys.keys) and t.type = 0 order by t.name, i.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: (select t.name as name, tri.name as trigname, 'DEP_TRIGGER' from sys.tables as t, sys.triggers as tri where tri.table_id = t.id) union (select t.name as name, tri.name as trigname, 'DEP_TRIGGER' from sys.triggers tri, sys.tables t, sys.dependencies dep where dep.id = t.id and dep.depend_id =tri.id and dep.depend_type = 8) order by name, trigname
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select t.name, fk.name, 'DEP_FKEY' from sys.tables as t, sys.keys as k, sys.keys as fk where fk.rkey = k.id and k.table_id = t.id order by t.name, fk.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select t.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.tables as t, sys.dependencies as dep where t.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and t.type in (0, 10) order by t.name, f.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select c.name, v.name, 'DEP_VIEW' from sys.columns as c, sys.tables as v, sys.dependencies as dep where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type = 1 order by c.name, v.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select c.name, k.name, 'DEP_KEY' from sys.columns as c, sys.objects as kc, sys.keys as k where kc."name" = c.name and kc.id = k.id and k.table_id = c.table_id and k.rkey = -1 order by c.name, k.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select c.name, i.name, 'DEP_INDEX' from sys.columns as c, sys.objects as kc, sys.idxs as i where kc."name" = c.name and kc.id = i.id and c.table_id = i.table_id and i.name not in (select name from sys.keys) order by c.name, i.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select c.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.columns as c, sys.dependencies as dep where c.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 order by c.name, f.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select c.name, tri.name, 'DEP_TRIGGER' from sys.columns as c, sys.triggers as tri, sys.dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and dep.depend_type = 8 order by c.name, tri.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select v.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and v.type in (1, 11) order by v.name, f.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select v.name, i.name, 'DEP_INDEX' from sys.tables as v, sys.idxs as i where i.table_id = v.id and i.name not in (select name from sys.keys) and v.type = 1 order by v.name, i.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select v.name, tri.name, 'DEP_TRIGGER' from sys.tables as v, sys.triggers as tri, sys.dependencies as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8 and v.type = 1 order by v.name, tri.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7 order by f2.name, f1.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select f.name, tri.name, 'DEP_TRIGGER' from sys.functions as f, sys.triggers as tri, sys.dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and dep.depend_type = 8 order by f.name, tri.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: select k.name, fk.name, 'DEP_FKEY' from sys.keys as k, sys.keys as fk where fk.rkey = k.id order by k.name, fk.name
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop view v1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t2
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop function f1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop function f2
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop trigger trigger_test
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop index id_index
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t2
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop function f1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop view v1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop view v2
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop view v1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop trigger trigger_test_4
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t1
#2024-04-26 00:58:50: client0021: SQLrun: INFO: Executing: drop table t3
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create function f1(num int)
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create function f1()
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create function f2(x int)
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create function f3()
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: select f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7 order by f2.name, f1.name
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop function f2
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop function f3
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop all function f1
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: select f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7 order by f2.name, f1.name
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create table t1(id int, name varchar(1024), age int)
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create function f1()
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: create view v1 as select * from t1 where id = f1()
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop function f1
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop function f1 cascade
#2024-04-26 00:58:50: client0022: SQLrun: INFO: Executing: drop table t1
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: alter user "monet_test" set schema "sys"
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: drop schema test
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: drop user monet_test
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: drop schema test_2
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select s.name, u.name, 'DEP_USER' from sys.schemas as s, users u where u.default_schema = s.id order by s.name, u.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select a.name, s.name, 'DEP_SCHEMA' from sys.schemas as s, auths a where s.owner = a.id order by a.name, s.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select distinct t.name, v.name, 'DEP_VIEW' from sys.tables as t, sys.tables as v, sys.dependencies as dep where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type in (1, 11, 21, 31) order by t.name, v.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select t.name, i.name, 'DEP_INDEX' from sys.tables as t, sys.idxs as i where i.table_id = t.id and i.name not in (select name from sys.keys) and t.type in (0, 10, 20, 30) order by t.name, i.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: (select t.name as name, tri.name as trigname, 'DEP_TRIGGER' from sys.tables as t, sys.triggers as tri where tri.table_id = t.id) union (select t.name as name, tri.name as trigname, 'DEP_TRIGGER' from sys.triggers tri, sys.tables t, sys.dependencies dep where dep.id = t.id and dep.depend_id =tri.id and dep.depend_type = 8) order by name, trigname
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select t.name, fk.name, 'DEP_FKEY' from sys.tables as t, sys.keys as k, sys.keys as fk where fk.rkey = k.id and k.table_id = t.id order by t.name, fk.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select t.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.tables as t, sys.dependencies as dep where t.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and t.type in (0, 10, 20, 30) order by t.name, f.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select distinct c.name, v.name, 'DEP_VIEW' from sys.columns as c, sys.tables as v, sys.dependencies as dep where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type in (1, 11, 21, 31) order by c.name, v.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select c.name, k.name, 'DEP_KEY' from sys.columns as c, sys.objects as kc, sys.keys as k where kc."name" = c.name and kc.id = k.id and k.table_id = c.table_id and k.rkey = -1 order by c.name, k.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select c.name, i.name, 'DEP_INDEX' from sys.columns as c, sys.objects as kc, sys.idxs as i where kc."name" = c.name and kc.id = i.id and c.table_id = i.table_id and i.name not in (select name from sys.keys) order by c.name, i.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select c.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.columns as c, sys.dependencies as dep where c.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 order by c.name, f.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select c.name, tri.name, 'DEP_TRIGGER' from sys.columns as c, sys.objects as tri, sys.dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and dep.depend_type = 8 order by c.name, tri.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select v.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and v.type in (1, 11, 21, 31) order by v.name, f.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select v.name, i.name, 'DEP_INDEX' from sys.tables as v, sys.idxs as i where i.table_id = v.id and i.name not in (select name from sys.keys) and v.type in (1, 11, 21, 31) order by v.name, i.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select v.name, tri.name, 'DEP_TRIGGER' from sys.tables as v, sys.objects as tri, sys.dependencies as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8 and v.type in (1, 11, 21, 31) order by v.name, tri.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and dep.depend_type = 7 order by f1.name, f2.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select f.name, tri.name, 'DEP_TRIGGER' from sys.functions as f, sys.objects as tri, sys.dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and dep.depend_type = 8 order by f.name, tri.name
#2024-04-26 00:58:50: client0023: SQLrun: INFO: Executing: select k.name, fk.name, 'DEP_FKEY' from sys.keys as k, sys.keys as fk where fk.rkey = k.id order by k.name, fk.name
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table dictionary (id integer,val varchar(20000),primary key (id))
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create table
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: create view triples as
#2024-04-26 00:58:50: client0024: SQLrun: INFO: Executing: select count(*) from dependencies where depend_type = 5 and depend_id in (select id from sys._tables where not system)
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dictionary" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."bench_booktitle" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."bench_cdrom" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_pages" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."foaf_homepage" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_editor" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_number" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dc_creator" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."rdfs_seealso" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dcterms_partof" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dcterms_references" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dcterms_issued" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_volume" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dc_publisher" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_note" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_chapter" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_address" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_series" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_month" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."foaf_name" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."rdf_type" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."dc_title" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_journal" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."bench_abstract" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop table "sys"."swrc_isbn" cascade
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: create function "sys"."test1"() returns table ("col1" int, "col2" int) begin return select 1, 2; end
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: create view "sys"."test1" ("col1", "col2") as select "col1", "col2" from "sys"."test1"()
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop function "test1"()
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: create function "sys"."test2"() returns table ("col1" int, "col2" int) begin return select "col1", "col2" from "sys"."test1"; end
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop view "test1"
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop function "test2"()
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop view "test1"
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: drop function "test1"()
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:58:50: client0025: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:58:50: client0026: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 10852232, of which 7968648 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 27393153454
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 1712072090
#Virtual size: 2216747008, anonymous RSS: 63377408, shared RSS: 43646976 (together: 107024384)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 1293 bats, 51400 virtual, 51400 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 99 bats, 1452 virtual, 1452 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 141 bats, 4488811 virtual, 1605227 malloc
#1810 bats total, 1587 in use, 91 free bats in common shared list
#client0026, tid 26, Thread 0x7fd1023ee6c0, LWP 2172072, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 16, Thread 0x7fd1025ef6c0, LWP 2172055, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 15, Thread 0x7fd0d76926c0, LWP 2172054, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 14, Thread 0x7fd0d74916c0, LWP 2172052, 37 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fd1027f06c0, LWP 2172049, 1 free bats, waiting for semaphore DFLOWsema0011, working on idle, waiting for new client
#DFLOWworker0010, tid 10, Thread 0x7fd1029f16c0, LWP 2172048, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fd102bf26c0, LWP 2172047, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fd102df36c0, LWP 2172046, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fd102ff46c0, LWP 2172045, 19 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fd1031f56c0, LWP 2172044, 29 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fd1033f66c0, LWP 2172043, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fd1035f76c0, LWP 2172042, 9 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7fd1037f86c0, LWP 2172041, 4 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fd14d1a76c0, LWP 2172040, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fd14e9cf740, LWP 2172039, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 391
#logger sql:
#current log file 55, last handled log file 53
#current transaction id 55, saved transaction id 52
#number of flushers: 0
#number of catalog entries 240, of which 0 deleted
#pending range 54: drops 0, last_ts 373, flushed_ts 373, refcount 0
#pending range 55: drops 0, last_ts 384, flushed_ts 384, refcount 1, file size 411 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 1810, #free = 223, #used = 0