# MonetDB 5 server v11.52.0
# This is an unreleased version
# Serving database 'mTests_clients', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
# Found 11.667 GiB available main-memory of which we use 9.509 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/Python3 module loaded
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:40733/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-2528873/.s.monetdb.40733
#2024-10-07 21:02:07: client0015: 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-10-07 21:02:07: client0015: 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-10-07 21:02:07: client0015: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:02:07: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:07: client0015: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:02:07: client0015: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:13: client0016: 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-10-07 21:02:13: client0016: 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-10-07 21:02:13: client0016: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:02:13: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:13: client0016: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:02:13: client0016: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:13: client0017: SQLrun: INFO: Executing: select 1;
#2024-10-07 21:02:13: client0018: SQLrun: INFO: Executing: select 1;
#2024-10-07 21:02:13: 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-10-07 21:02:13: 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-10-07 21:02:13: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2024-10-07 21:02:13: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:13: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2024-10-07 21:02:13: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2024-10-07 21:02:14: client0020: SQLrun: INFO: Executing: select count(*), max(id) from sys.bbp()
#SIGUSR1 info start
#Virtual memory allocated: 10696392, of which 7812808 with malloc
#gdk_vm_maxsize: 8589934592, gdk_mem_maxsize: 10209923584
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 638120224
#Virtual size: 21993005871104, anonymous RSS: 398725120, shared RSS: 69337088 (together: 468062208)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 177 bats, 26824 virtual, 26824 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 7168 virtual, 7168 malloc
#no fix, dirty, persistent, not loaded, hot: 94 bats, 0 virtual, 0 malloc
#no fix, dirty, transient, not loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 11 bats, 115712 virtual, 115712 malloc
#no fix, clean, persistent, not loaded, hot: 139 bats, 4423963 virtual, 1540379 malloc
#560 bats total, 476 in use, 46 free bats in common shared list
#Threads:
#client0020, tid 20, Thread 0x7f6e80d9c6c0, LWP 2528975, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 12, Thread 0x7f6e81d316c0, LWP 2528935, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 11, Thread 0x7f6e6d9346c0, LWP 2528934, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 10, Thread 0x7f6e6d7256c0, LWP 2528932, 0 free bats, waiting for nothing, working on sleeping
#DFLOWworker0007, tid 7, Thread 0x7f6e81aae6c0, LWP 2528929, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0006, tid 6, Thread 0x7f6e836ba6c0, LWP 2528928, 13 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0005, tid 5, Thread 0x7f6e84ee36c0, LWP 2528927, 4 free bats, waiting for semaphore DFLOWsema0005, working on idle, waiting for new client
#DFLOWworker0004, tid 4, Thread 0x7f6e850f26c0, LWP 2528926, 6 free bats, waiting for semaphore DFLOWsema0004, working on idle, waiting for new client
#DFLOWworker0003, tid 3, Thread 0x7f6e853016c0, LWP 2528925, 2 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7f6f114ff6c0, LWP 2528924, 0 free bats, waiting for nothing, working on sleeping
#main thread, tid 1, Thread 0x7f6f168ba780, LWP 2528923, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 132
#logger sql:
#current log file 4, last handled log file 3
#current transaction id 0, saved transaction id 0
#number of flushers: 0
#number of catalog entries 244, of which 0 deleted
#pending range 4: drops 0, last_ts 0, flushed_ts 0, refcount 1, file size 2 (current)
#SIGUSR1 info end
Mismatch in free bats: total bats = 560, #free = 84, #used = 0