# MonetDB 5 server v11.50.0
# This is an unreleased version
# Serving database 'mTests_sql_test_Dependencies', using 8 threads
# Compiled for ppc64-pc-linux-gnu/64bit with 128bit integers
# Found 255.358 GiB available main-memory of which we use 208.117 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/SQL module loaded
# Listening for connection requests on mapi:monetdb://power8:45489/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-52894/.s.monetdb.45489
#2024-04-26 00:30:35: client0017: 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:30:35: client0017: 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:30:35: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: create function "sys"."test1"() returns table ("col1" int, "col2" int) begin return select 1, 2; end
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: create view "sys"."test1" ("col1", "col2") as select "col1", "col2" from "sys"."test1"()
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: drop function "test1"()
#2024-04-26 00:30:35: client0017: 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:30:35: client0017: SQLrun: INFO: Executing: drop view "test1"
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: drop function "test2"()
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: drop view "test1"
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: drop function "test1"()
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join tables on dependencies.id = tables.id where tables.name = 'test1'
#2024-04-26 00:30:35: client0017: SQLrun: INFO: Executing: select count(*) from dependencies inner join functions on dependencies.id = functions.id where functions.name = 'test1'
#2024-04-26 00:30:35: client0018: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 8340784, of which 8340784 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 223463815249
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 1136132096, anonymous RSS: 58523648, shared RSS: 19922944 (together: 78446592)
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 170 bats, 50584 virtual, 50584 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, loaded, hot: 98 bats, 1396 virtual, 1396 malloc
#no fix, dirty, transient, loaded, hot: 48 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 135 bats, 1492736 virtual, 1492736 malloc
#550 bats total, 457 in use, 28 free bats in common shared list
#client0018, tid 18, Thread 0x7fff8d56f180, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 14, Thread 0x7fff8d77f180, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 13, Thread 0x7fff8d98f180, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 12, Thread 0x7fff8db9f180, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fff8ddaf180, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fff8dfbf180, 4 free bats, waiting for semaphore DFLOWsema0010, working on idle, waiting for new client
#DFLOWworker0009, tid 9, Thread 0x7fff8e1cf180, 2 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fff8e3df180, 8 free bats, waiting for semaphore DFLOWsema0008, working on idle, waiting for new client
#DFLOWworker0007, tid 7, Thread 0x7fff8e5ef180, 7 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7fff8e7ff180, 3 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7fff8ea0f180, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fff8ec1f180, 10 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fff8ee2f180, 19 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fff942ef180, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7fffa2918440, 0 free bats, waiting for nothing, working on nothing
#0 active clients, 0 finishing clients, 0 blocked clients
#SQL store oldest pending 59
#logger sql:
#current log file 7, last handled log file 5
#current transaction id 4, saved transaction id 1
#number of flushers: 0
#number of catalog entries 233, of which 0 deleted
#pending range 6: drops 0, last_ts 41, flushed_ts 41, refcount 0
#pending range 7: drops 0, last_ts 52, flushed_ts 52, refcount 1, file size 411 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 550, #free = 93, #used = 0