CMK version:2.1.0p8
OS version:Ubuntu 22.04
Error message: Parsing of section postgres_query_duration failed
**Output of “cmk --debug -vvn hostname”:
OMD[checkmk]:~$ cmk --debug -vvn PostgreSQL01
Checkmk version 2.1.0p8
Try license usage history update.
Trying to acquire lock on /omd/sites/checkmk/var/check_mk/license_usage/next_run
Got lock on /omd/sites/checkmk/var/check_mk/license_usage/next_run
Trying to acquire lock on /omd/sites/checkmk/var/check_mk/license_usage/history.json
Got lock on /omd/sites/checkmk/var/check_mk/license_usage/history.json
Next run time has not been reached yet. Abort.
Releasing lock on /omd/sites/checkmk/var/check_mk/license_usage/history.json
Released lock on /omd/sites/checkmk/var/check_mk/license_usage/history.json
Releasing lock on /omd/sites/checkmk/var/check_mk/license_usage/next_run
Released lock on /omd/sites/checkmk/var/check_mk/license_usage/next_run
+ FETCHING DATA
Source: SourceType.HOST/FetcherType.TCP
[cpu_tracking] Start [7fa706da2760]
[TCPFetcher] Fetch with cache settings: DefaultAgentFileCache(PostgreSQL01, base_path=/omd/sites/checkmk/tmp/check_mk/cache, max_age=MaxAge(checking=0, discovery=120, inventory=120), disabled=False, use_outdated=False, simulation=False)
Not using cache (Too old. Age is 121 sec, allowed is 0 sec)
[TCPFetcher] Execute data source
Connecting via TCP to PostgreSQL01.drag0n141.ext:6556 (30.0s timeout)
Detected transport protocol: TransportProtocol.PLAIN (b'<<')
Reading data from agent
Write data to cache file /omd/sites/checkmk/tmp/check_mk/cache/PostgreSQL01
Trying to acquire lock on /omd/sites/checkmk/tmp/check_mk/cache/PostgreSQL01
Got lock on /omd/sites/checkmk/tmp/check_mk/cache/PostgreSQL01
Releasing lock on /omd/sites/checkmk/tmp/check_mk/cache/PostgreSQL01
Released lock on /omd/sites/checkmk/tmp/check_mk/cache/PostgreSQL01
Closing TCP connection to PostgreSQL01.drag0n141.ext:6556
[cpu_tracking] Stop [7fa706da2760 - Snapshot(process=posix.times_result(user=0.0, system=0.009999999999999995, children_user=0.0, children_system=0.0, elapsed=1.75))]
Source: SourceType.HOST/FetcherType.PIGGYBACK
[cpu_tracking] Start [7fa706da2fa0]
[PiggybackFetcher] Fetch with cache settings: NoCache(PostgreSQL01, base_path=/omd/sites/checkmk/tmp/check_mk/data_source_cache/piggyback, max_age=MaxAge(checking=0, discovery=120, inventory=120), disabled=True, use_outdated=False, simulation=False)
Not using cache (Cache usage disabled)
[PiggybackFetcher] Execute data source
Piggyback file '/omd/sites/checkmk/tmp/check_mk/piggyback/PostgreSQL01/Proxmox03': Successfully processed from source 'Proxmox03'
No piggyback files for 'PostgreSQL01.drag0n141.ext'. Skip processing.
Not using cache (Cache usage disabled)
[cpu_tracking] Stop [7fa706da2fa0 - Snapshot(process=posix.times_result(user=0.0, system=0.0, children_user=0.0, children_system=0.0, elapsed=0.0))]
+ PARSE FETCHER RESULTS
Source: SourceType.HOST/FetcherType.TCP
<<<check_mk>>> / Transition NOOPParser -> HostSectionParser
<<<cmk_agent_ctl_status:sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<checkmk_agent_plugins_lnx:sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<labels:sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<df>>> / Transition HostSectionParser -> HostSectionParser
<<<df>>> / Transition HostSectionParser -> HostSectionParser
<<<systemd_units>>> / Transition HostSectionParser -> HostSectionParser
<<<nfsmounts>>> / Transition HostSectionParser -> HostSectionParser
<<<cifsmounts>>> / Transition HostSectionParser -> HostSectionParser
<<<mounts>>> / Transition HostSectionParser -> HostSectionParser
<<<ps_lnx>>> / Transition HostSectionParser -> HostSectionParser
<<<mem>>> / Transition HostSectionParser -> HostSectionParser
<<<lxc_container_cpu_cgroupv2>>> / Transition HostSectionParser -> HostSectionParser
<<<uptime>>> / Transition HostSectionParser -> HostSectionParser
<<<lnx_if>>> / Transition HostSectionParser -> HostSectionParser
<<<lnx_if:sep(58)>>> / Transition HostSectionParser -> HostSectionParser
<<<lnx_bonding:sep(58)>>> / Transition HostSectionParser -> HostSectionParser
<<<tcp_conn_stats>>> / Transition HostSectionParser -> HostSectionParser
<<<diskstat>>> / Transition HostSectionParser -> HostSectionParser
<<<md>>> / Transition HostSectionParser -> HostSectionParser
<<<vbox_guest>>> / Transition HostSectionParser -> HostSectionParser
<<<postfix_mailq>>> / Transition HostSectionParser -> HostSectionParser
<<<postfix_mailq_status:sep(58)>>> / Transition HostSectionParser -> HostSectionParser
<<<job>>> / Transition HostSectionParser -> HostSectionParser
<<<local:sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<fail2ban>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_instances>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_sessions>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_stat_database:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_locks:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_query_duration:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_connections:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_stats:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_version:sep(1)>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_conn_time>>> / Transition HostSectionParser -> HostSectionParser
<<<postgres_bloat:sep(59)>>> / Transition HostSectionParser -> HostSectionParser
<<<sshd_config>>> / Transition HostSectionParser -> HostSectionParser
<<<apt:cached(1658339041,7200):sep(0)>>> / Transition HostSectionParser -> HostSectionParser
No persisted sections
-> Add sections: ['apt', 'check_mk', 'checkmk_agent_plugins_lnx', 'cifsmounts', 'cmk_agent_ctl_status', 'df', 'diskstat', 'fail2ban', 'job', 'labels', 'lnx_bonding', 'lnx_if', 'local', 'lxc_container_cpu_cgroupv2', 'md', 'mem', 'mounts', 'nfsmounts', 'postfix_mailq', 'postfix_mailq_status', 'postgres_bloat', 'postgres_conn_time', 'postgres_connections', 'postgres_instances', 'postgres_locks', 'postgres_query_duration', 'postgres_sessions', 'postgres_stat_database', 'postgres_stats', 'postgres_version', 'ps_lnx', 'sshd_config', 'systemd_units', 'tcp_conn_stats', 'uptime', 'vbox_guest']
Source: SourceType.HOST/FetcherType.PIGGYBACK
<<<proxmox_ve_vm_info:cached(1658342518,90):sep(0)>>> / Transition NOOPParser -> HostSectionParser
<<<proxmox_ve_disk_usage:cached(1658342518,90):sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<proxmox_ve_mem_usage:cached(1658342518,90):sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<proxmox_ve_vm_backup_status:cached(1658342518,90):sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<proxmox_ve_vm_snapshot_age:cached(1658342518,90):sep(0)>>> / Transition HostSectionParser -> HostSectionParser
<<<labels:sep(0)>>> / Transition HostSectionParser -> HostSectionParser
No persisted sections
-> Add sections: ['labels', 'proxmox_ve_disk_usage', 'proxmox_ve_mem_usage', 'proxmox_ve_vm_backup_status', 'proxmox_ve_vm_info', 'proxmox_ve_vm_snapshot_age']
Received no piggyback data
Received no piggyback data
[cpu_tracking] Start [7fa706d771f0]
value store: synchronizing
Trying to acquire lock on /omd/sites/checkmk/tmp/check_mk/counters/PostgreSQL01
Got lock on /omd/sites/checkmk/tmp/check_mk/counters/PostgreSQL01
value store: loading from disk
Releasing lock on /omd/sites/checkmk/tmp/check_mk/counters/PostgreSQL01
Released lock on /omd/sites/checkmk/tmp/check_mk/counters/PostgreSQL01
APT Updates 12 normal updates, 20 security updates (libssl3, python3.10, libpython3.10-stdlib, python3.10-minimal, libpython3.10-minimal, gpg-wks-client, dirmngr, gnupg-utils, gpg-wks-server, gpg-agent, gpg, gpgconf, gnupg-l10n, gnupg, gpgsm, gpgv, openssl, libfreetype6, libharfbuzz0b, python3-jwt)
Check_MK Agent Version: 2.1.0p8, OS: linux, TLS is not activated on monitored host (see details), Agent plugins: 5, Local checks: 0
Disk IO SUMMARY Read: 761 kB/s, Write: 9.86 MB/s, Latency: 694 microseconds
Filesystem / 23.32% used (2.27 of 9.75 GB, warn/crit at 83.65%/89.10%), trend: -93.21 kB / 24 hours
Interface 2 [eth0], (up), MAC: F2:B3:F1:41:A7:3A, Speed: 10 GBit/s, In: 4.15 kB/s (<0.01%), Out: 12.3 kB/s (<0.01%)
Jail sshd OK - sshd active - 0 failed (0 total), 0 banned (0 total)
MD Softraid md0 Status: active, Spare: 0, Failed: 0, Active: 2, Status: 2/2, UU
MD Softraid md1 Status: active, Spare: 0, Failed: 0, Active: 2, Status: 2/2, UU
Memory Total virtual memory: 8.18% - 167.53 MB of 2.00 GB, 7 additional details available
Mount options of / Mount options exactly as expected
Postfix Queue Deferred queue length: 0, Active queue length: 0
Postfix status Status: the Postfix mail system is running, PID: 467
PostgreSQL ANALYZE MAIN/atuin_db 5 tables were never analyzed: _sqlx_migrations / sessions / total_history_count_user (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/authentik_db Table: authentik_events_event, Not analyzed for: 21 days 9 hours, 83 tables were never analyzed: authentik_core_user_groups / authentik_core_provider_property_mappings / authentik_crypto_certificatekeypair (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/headscale_db Table: machines, Not analyzed for: 6 seconds, 4 tables were never analyzed: namespaces / pre_auth_keys / api_keys (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/helpy_db No never checked tables
PostgreSQL ANALYZE MAIN/joplin_db Table: changes, Not analyzed for: 21 days 9 hours, 14 tables were never analyzed: shares / share_users / storages (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/matrix_db Table: applied_schema_deltas, Not analyzed for: 21 days 9 hours, 135 tables were never analyzed: dehydrated_devices / deleted_pushers / device_federation_inbox (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/netbox_db Table: auth_permission, Not analyzed for: 21 days 9 hours, 127 tables were never analyzed: circuits_provider / circuits_circuit / circuits_circuittermination (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/opentogethertube_db No never checked tables
PostgreSQL ANALYZE MAIN/paperless_db Table: auth_permission, Not analyzed for: 21 days 9 hours, 17 tables were never analyzed: auth_user_groups / auth_user_user_permissions / auth_user (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/postgres No never checked tables
PostgreSQL ANALYZE MAIN/rallly_db No never checked tables
PostgreSQL ANALYZE MAIN/recipes_db Table: auth_permission, Not analyzed for: 21 days 9 hours, 73 tables were never analyzed: auth_user_groups / auth_group / auth_user_user_permissions (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL ANALYZE MAIN/taskcafe_db Table: task, Not analyzed for: 21 days 9 hours, 25 tables were never analyzed: task_activity_type / system_options / project_member_invited (first 3 shown), Never analyzed tables for: 2 hours 39 minutes
PostgreSQL Bloat MAIN/atuin_db Maximum table bloat at pg_class: 0.15%, Maximum wasted tablespace at pg_class: 16.00 kB, Maximum index bloat at users: 1.0%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 96.00 kB, Summary of top 10 wasted indexspace: 152.00 kB
PostgreSQL Bloat MAIN/authentik_db Maximum table bloat at authentik_events_event: 0.05%, Maximum wasted tablespace at authentik_events_event: 48.00 kB, Maximum index bloat at authentik_sources_ldap_ldapsource: 1.0%, Maximum wasted indexspace at pg_depend: 88.00 kB, Summary of top 10 wasted tablespace: 264.00 kB, Summary of top 10 wasted indexspace: 152.00 kB
PostgreSQL Bloat MAIN/headscale_db Maximum table bloat at machines: 0.95%, Maximum wasted tablespace at machines: 160.00 kB, Maximum index bloat at pre_auth_keys: 1.0%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 256.00 kB, Summary of top 10 wasted indexspace: 136.00 kB
PostgreSQL Bloat MAIN/helpy_db Maximum table bloat at pg_class_oid_index: 1.0%, Maximum wasted tablespace at pg_class: 16.00 kB, Maximum index bloat at pg_depend: 0.24%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 72.00 kB, Summary of top 10 wasted indexspace: 104.00 kB
PostgreSQL Bloat MAIN/joplin_db Maximum table bloat at files: 0.05%, Maximum wasted tablespace at items: 192.00 kB, Maximum index bloat at items: 0%, Maximum wasted indexspace at items: 0.00 B, Summary of top 10 wasted tablespace: 1.86 MB, Summary of top 10 wasted indexspace: 0.00 B
PostgreSQL Bloat MAIN/matrix_db Maximum table bloat at event_json: 0.07%, Maximum wasted tablespace at event_json: 136.00 kB, Maximum index bloat at pushers: 1.0%, Maximum wasted indexspace at pushers: 8.00 kB, Summary of top 10 wasted tablespace: 296.00 kB, Summary of top 10 wasted indexspace: 72.00 kB
PostgreSQL Bloat MAIN/netbox_db Maximum table bloat at pg_depend: 0%, Maximum wasted tablespace at dcim_powerfeed: 40.00 kB, Maximum index bloat at dcim_powerfeed: 1.0%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 344.00 kB, Summary of top 10 wasted indexspace: 176.00 kB
PostgreSQL Bloat MAIN/opentogethertube_db Maximum table bloat at pg_class_oid_index: 1.0%, Maximum wasted tablespace at pg_class: 16.00 kB, Maximum index bloat at pg_depend: 0.24%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 72.00 kB, Summary of top 10 wasted indexspace: 104.00 kB
PostgreSQL Bloat MAIN/paperless_db Maximum table bloat at documents_document: 0.05%, Maximum wasted tablespace at documents_document: 32.00 kB, Maximum index bloat at pg_depend: 0.24%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 288.00 kB, Summary of top 10 wasted indexspace: 104.00 kB
PostgreSQL Bloat MAIN/postgres Maximum table bloat at pg_class_oid_index: 1.0%, Maximum wasted tablespace at pg_class: 16.00 kB, Maximum index bloat at pg_depend: 0.24%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 72.00 kB, Summary of top 10 wasted indexspace: 104.00 kB
PostgreSQL Bloat MAIN/rallly_db Maximum table bloat at pg_class_oid_index: 1.0%, Maximum wasted tablespace at pg_class: 16.00 kB, Maximum index bloat at pg_depend: 0.24%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 72.00 kB, Summary of top 10 wasted indexspace: 104.00 kB
PostgreSQL Bloat MAIN/recipes_db Maximum table bloat at cookbook_shoppinglistentry: 0%, Maximum wasted tablespace at cookbook_shoppinglistentry: 24.00 kB, Maximum index bloat at cookbook_shoppinglistentry: 1.0%, Maximum wasted indexspace at cookbook_shoppinglistentry: 8.00 kB, Summary of top 10 wasted tablespace: 240.00 kB, Summary of top 10 wasted indexspace: 80.00 kB
PostgreSQL Bloat MAIN/taskcafe_db Maximum table bloat at pg_depend: 0%, Maximum wasted tablespace at notification_object: 8.00 kB, Maximum index bloat at notification_object: 1.0%, Maximum wasted indexspace at pg_depend: 104.00 kB, Summary of top 10 wasted tablespace: 72.00 kB, Summary of top 10 wasted indexspace: 176.00 kB
PostgreSQL Connection Time MAIN 0.036 seconds
PostgreSQL Connections MAIN/atuin_db No active connections, No idle connections
PostgreSQL Connections MAIN/authentik_db Used active connections: 0, Used active percentage: 0%, Used idle connections: 2, Used idle percentage: 2.0%
PostgreSQL Connections MAIN/headscale_db Used active connections: 0, Used active percentage: 0%, Used idle connections: 2, Used idle percentage: 2.0%
PostgreSQL Connections MAIN/helpy_db No active connections, No idle connections
PostgreSQL Connections MAIN/joplin_db Used active connections: 0, Used active percentage: 0%, Used idle connections: 1, Used idle percentage: 1.0%
PostgreSQL Connections MAIN/matrix_db No active connections, No idle connections
PostgreSQL Connections MAIN/netbox_db No active connections, No idle connections
PostgreSQL Connections MAIN/opentogethertube_db No active connections, No idle connections
PostgreSQL Connections MAIN/paperless_db Used active connections: 0, Used active percentage: 0%, Used idle connections: 3, Used idle percentage: 3.0%
PostgreSQL Connections MAIN/postgres Used active connections: 1, Used active percentage: 1.0%, Used idle connections: 0, Used idle percentage: 0%
PostgreSQL Connections MAIN/rallly_db No active connections, No idle connections
PostgreSQL Connections MAIN/recipes_db Used active connections: 0, Used active percentage: 0%, Used idle connections: 1, Used idle percentage: 1.0%
PostgreSQL Connections MAIN/taskcafe_db No active connections, No idle connections
PostgreSQL DB MAIN/atuin_db Size Size is 8.66 MB
PostgreSQL DB MAIN/atuin_db Statistics Blocks Read: 0.00/s, Fetches: 25.27/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/authentik_db Size Size is 16.24 MB
PostgreSQL DB MAIN/authentik_db Statistics Blocks Read: 0.00/s, Fetches: 246.75/s, Commits: 2.89/s, Deletes: 0.00/s, Updates: 0.03/s, Inserts: 0.00/s
PostgreSQL DB MAIN/headscale_db Size Size is 8.92 MB
PostgreSQL DB MAIN/headscale_db Statistics Blocks Read: 0.00/s, Fetches: 56.77/s, Commits: 4.73/s, Deletes: 0.00/s, Updates: 0.57/s, Inserts: 0.00/s
PostgreSQL DB MAIN/helpy_db Size Size is 8.37 MB
PostgreSQL DB MAIN/helpy_db Statistics Blocks Read: 0.00/s, Fetches: 25.13/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/joplin_db Size Size is 468.77 MB
PostgreSQL DB MAIN/joplin_db Statistics Blocks Read: 0.00/s, Fetches: 29.06/s, Commits: 0.28/s, Deletes: 0.00/s, Updates: 0.02/s, Inserts: 0.00/s
PostgreSQL DB MAIN/matrix_db Size Size is 22.93 MB
PostgreSQL DB MAIN/matrix_db Statistics Blocks Read: 0.00/s, Fetches: 89.45/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/netbox_db Size Size is 21.38 MB
PostgreSQL DB MAIN/netbox_db Statistics Blocks Read: 0.00/s, Fetches: 91.22/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/opentogethertube_db Size Size is 8.37 MB
PostgreSQL DB MAIN/opentogethertube_db Statistics Blocks Read: 0.00/s, Fetches: 25.13/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/paperless_db Size Size is 12.69 MB
PostgreSQL DB MAIN/paperless_db Statistics Blocks Read: 0.00/s, Fetches: 38.17/s, Commits: 0.19/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/postgres Size Size is 8.35 MB
PostgreSQL DB MAIN/postgres Statistics Blocks Read: 0.00/s, Fetches: 33.70/s, Commits: 0.21/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/rallly_db Size Size is 8.35 MB
PostgreSQL DB MAIN/rallly_db Statistics Blocks Read: 0.00/s, Fetches: 25.13/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/recipes_db Size Size is 14.36 MB
PostgreSQL DB MAIN/recipes_db Statistics Blocks Read: 0.00/s, Fetches: 31.50/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/taskcafe_db Size Size is 9.47 MB
PostgreSQL DB MAIN/taskcafe_db Statistics Blocks Read: 0.00/s, Fetches: 28.09/s, Commits: 0.06/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL DB MAIN/template1 Size Size is 8.35 MB
PostgreSQL DB MAIN/template1 Statistics Blocks Read: 0.00/s, Fetches: 0.23/s, Commits: 0.03/s, Deletes: 0.00/s, Updates: 0.00/s, Inserts: 0.00/s
PostgreSQL Daemon Sessions MAIN Total: 1, Running: 1
PostgreSQL Instance MAIN Status: running with PID 15696
PostgreSQL Locks MAIN/atuin_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/authentik_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/headscale_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/helpy_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/joplin_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/matrix_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/netbox_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/opentogethertube_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/paperless_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/postgres Access Share Locks 1, Exclusive Locks 0
PostgreSQL Locks MAIN/rallly_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/recipes_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL Locks MAIN/taskcafe_db Access Share Locks 0, Exclusive Locks 0
PostgreSQL VACUUM MAIN/atuin_db 5 tables were never vacuumed: _sqlx_migrations / sessions / total_history_count_user (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/authentik_db Table: authentik_core_source, Not vacuumed for: 13 days 15 hours, 91 tables were never vacuumed: authentik_core_user_groups / authentik_core_provider_property_mappings / authentik_core_user (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/headscale_db Table: machines, Not vacuumed for: 9 hours 58 minutes, 4 tables were never vacuumed: namespaces / pre_auth_keys / api_keys (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/helpy_db No never checked tables
PostgreSQL VACUUM MAIN/joplin_db Table: changes, Not vacuumed for: 21 days 9 hours, 14 tables were never vacuumed: shares / share_users / storages (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/matrix_db Table: cache_invalidation_stream_by_instance, Not vacuumed for: 21 days 9 hours, 143 tables were never vacuumed: dehydrated_devices / deleted_pushers / destination_rooms (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/netbox_db Table: extras_objectchange, Not vacuumed for: 21 days 9 hours, 134 tables were never vacuumed: circuits_provider / circuits_circuit / circuits_circuittermination (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/opentogethertube_db No never checked tables
PostgreSQL VACUUM MAIN/paperless_db Table: django_q_task, Not vacuumed for: 4 hours 32 minutes, 24 tables were never vacuumed: auth_user_groups / auth_user_user_permissions / auth_user (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/postgres No never checked tables
PostgreSQL VACUUM MAIN/rallly_db No never checked tables
PostgreSQL VACUUM MAIN/recipes_db 79 tables were never vacuumed: auth_user_groups / auth_group / auth_user_user_permissions (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL VACUUM MAIN/taskcafe_db 27 tables were never vacuumed: task_activity_type / system_options / project_member_invited (first 3 shown), Never vacuumed tables for: 2 hours 39 minutes
PostgreSQL Version main PostgreSQL 14.4 (Ubuntu 14.4-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit
Proxmox VE Disk Usage 18.03% used (1.89 GB of 10.5 GB)
Proxmox VE Memory Usage Usage: 8.19% - 168 MiB of 2.00 GiB
Proxmox VE VM Backup Status Age: 1 day 17 hours, Server local start time: 2022-07-19 03:07:20+02:00, Duration: 39 seconds, Dedup rate: 4.58, Bandwidth: 11.0 MB/s
Proxmox VE VM Info VM ID: 105, Status: running, Type: lxc, Host: Proxmox03
Proxmox VE VM Snapshot age No snapshot found
SSH daemon configuration Protocol: 2, PermitRootLogin: key-based, PasswordAuthentication: no, PermitEmptyPasswords: no, UsePAM: no, X11Forwarding: no
Systemd Service Summary Total: 99, Disabled: 4, Failed: 1
TCP Connections Established: 10
Uptime Up since Jun 29 2022 10:59:07, Uptime: 21 days 9 hours
Piggyback file '/omd/sites/checkmk/tmp/check_mk/piggyback/PostgreSQL01/Proxmox03': Successfully processed from source 'Proxmox03'
No piggyback files for 'PostgreSQL01.drag0n141.ext'. Skip processing.
[cpu_tracking] Stop [7fa706d771f0 - Snapshot(process=posix.times_result(user=0.040000000000000036, system=0.0, children_user=0.0, children_system=0.0, elapsed=0.03999999910593033))]
[agent] Success, [piggyback] Successfully processed from source 'Proxmox03', execution time 1.8 sec | execution_time=1.790 user_time=0.040 system_time=0.010 children_user_time=0.000 children_system_time=0.000 cmk_time_agent=1.740** (If it is a problem with checks or plugins)
