MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Dec 9 13:18:18 2020 ---------------------------------------------------------------------------- 2020-12-09 13:18:18 notice : syslog logging is enabled. 2020-12-09 13:18:18 notice : maxlog logging is enabled. 2020-12-09 13:18:18 notice : The collection of SQLite memory allocation statistics turned off. 2020-12-09 13:18:18 notice : Threading mode of SQLite set to Multi-thread. 2020-12-09 13:18:18 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-12-09 13:18:18 notice : Worker message queue size: 1MiB 2020-12-09 13:18:18 notice : The logging of informational messages has been enabled. 2020-12-09 13:18:18 notice : Using up to 4.71GiB of memory for query classifier cache 2020-12-09 13:18:18 notice : Running OS: Linux@5.0.0-1026-gcp, #27~18.04.1-Ubuntu SMP Fri Nov 15 07:40:39 UTC 2019, x86_64 with 8 processor cores. 2020-12-09 13:18:18 notice : Total usable main memory: 31.41GiB. 2020-12-09 13:18:18 notice : MariaDB MaxScale 2.5.5 started (Commit: 91c3b76195d0057ddbe572bbb8d17f6ac6b09d5e) 2020-12-09 13:18:18 notice : MaxScale is running in process 102686 2020-12-09 13:18:18 notice : Configuration file: /etc/maxscale.cnf 2020-12-09 13:18:18 notice : Log directory: /var/log/maxscale 2020-12-09 13:18:18 notice : Data directory: /var/lib/maxscale 2020-12-09 13:18:18 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2020-12-09 13:18:18 notice : Service cache: /var/cache/maxscale 2020-12-09 13:18:18 notice : Working directory: /var/log/maxscale 2020-12-09 13:18:18 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so 2020-12-09 13:18:18 info : qc_sqlite loaded. 2020-12-09 13:18:18 notice : Query classification results are cached and reused. Memory used per thread: 603.1MiB 2020-12-09 13:18:18 notice : Using encrypted passwords. Encryption key read from '/var/lib/maxscale/.secrets'. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140629133256448. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140629124863744. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140629116471040. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140628906211072. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140628897818368. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140628889425664. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140628881032960. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140628872640256. 2020-12-09 13:18:18 notice : MaxScale started with 8 worker threads, each with a stack size of 8388608 bytes. 2020-12-09 13:18:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140629314502464. 2020-12-09 13:18:18 notice : Loading /etc/maxscale.cnf. 2020-12-09 13:18:18 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-12-09 13:18:18 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so 2020-12-09 13:18:18 notice : Loaded module readconnroute: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadconnroute.so 2020-12-09 13:18:18 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so 2020-12-09 13:18:18 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: monitor_interval=10000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2020-12-09 13:18:18 notice : (LocalListener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so 2020-12-09 13:18:18 warning: The MaxScale GUI is enabled but encryption for the REST API is not enabled, the GUI will not be enabled. Configure `admin_ssl_key` and `admin_ssl_cert` to enable HTTPS or add `admin_secure_gui=false` to allow use of the GUI without encryption. 2020-12-09 13:18:18 notice : Started REST API on [127.0.0.1]:8989 2020-12-09 13:18:18 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-12-09 13:18:18 notice : Server 'skysql' version: 10.5.4-2-MariaDB-enterprise-log 2020-12-09 13:18:18 notice : Starting a total of 1 services... 2020-12-09 13:18:18 notice : (LocalListener) Listening for connections at [127.0.0.1]:3306 2020-12-09 13:18:18 notice : Service 'SkyService' started (1/1) 2020-12-09 13:18:19 notice : Read 184 user@host entries from 'skysql' for service 'SkyService'. 2020-12-09 13:18:28 info : Server variables loaded from 'skysql', next update in 600 seconds. 2020-12-09 13:18:32 info : (1) Found matching user 'eng-reports2020'@'127.0.0.1' for client 'eng-reports2020'@'127.0.0.1' with sufficient privileges. 2020-12-09 13:18:32 info : (1) [readconnroute] (SkyService) New session for server skysql. Connections : 1 2020-12-09 13:18:32 info : (1) Started SkyService client session [1] for 'eng-reports2020' from 127.0.0.1 2020-12-09 13:18:32 info : (1) [readconnroute] (SkyService) Routed [COM_QUERY] to 'skysql' select @@version_comment limit 1 2020-12-09 13:18:32 info : (1) Connected to 'skysql' with thread id 216166 2020-12-09 13:18:32 info : (1) Authentication to 'skysql' succeeded. 2020-12-09 13:18:35 info : (1) [readconnroute] (SkyService) Routed [COM_QUERY] to 'skysql' SELECT DATABASE() 2020-12-09 13:18:35 info : (1) [readconnroute] (SkyService) Routed [COM_INIT_DB] to 'skysql' 2020-12-09 13:18:35 alert : (1) MaxScale 2.5.5 received fatal signal 11. Commit ID: 91c3b76195d0057ddbe572bbb8d17f6ac6b09d5e System name: Linux Release string: Ubuntu 18.04.4 LTS 2020-12-09 13:18:35 alert : (1) Statement currently being classified: none/unknown nm: /lib/x86_64-linux-gnu/libc.so.6: no symbols 2020-12-09 13:18:35 alert : (1) /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(+0x26dba): server/modules/protocol/MariaDB/mariadb_backend.cc:71 /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(_ZN24MariaDBBackendConnection17process_ok_packetEN8maxscale6Buffer8iteratorES2_+0x139): server/modules/protocol/MariaDB/mariadb_backend.cc:114 /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(_ZN24MariaDBBackendConnection20process_result_startEN8maxscale6Buffer8iteratorES2_+0xd2): server/modules/protocol/MariaDB/mariadb_backend.cc:2076 /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(_ZN24MariaDBBackendConnection15process_packetsEPP5GWBUF+0x152): server/modules/protocol/MariaDB/mariadb_backend.cc:1811 /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(_ZN24MariaDBBackendConnection14track_responseEPP5GWBUF+0xf): server/modules/protocol/MariaDB/mariadb_backend.cc:1450 /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so(_ZN24MariaDBBackendConnection11normal_readEv+0x628): server/modules/protocol/MariaDB/mariadb_backend.cc:574 /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN3DCB14process_eventsEj+0x6c): server/core/dcb.cc:1291 /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN3DCB13event_handlerEPS_j+0x21): server/core/dcb.cc:1350 /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0x1ce): maxutils/maxbase/src/worker.cc:879 /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x53): maxutils/maxbase/src/worker.cc:574 /usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xbd6df): ??:? /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db): /build/glibc-S7xCS9/glibc-2.27/nptl/pthread_create.c:463 /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f): ??:0 MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Dec 9 13:18:36 2020 ---------------------------------------------------------------------------- 2020-12-09 13:18:36 notice : syslog logging is enabled. 2020-12-09 13:18:36 notice : maxlog logging is enabled. 2020-12-09 13:18:36 notice : The collection of SQLite memory allocation statistics turned off. 2020-12-09 13:18:36 notice : Threading mode of SQLite set to Multi-thread. 2020-12-09 13:18:36 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-12-09 13:18:36 notice : Worker message queue size: 1MiB 2020-12-09 13:18:36 notice : The logging of informational messages has been enabled. 2020-12-09 13:18:36 notice : Using up to 4.71GiB of memory for query classifier cache 2020-12-09 13:18:36 notice : Running OS: Linux@5.0.0-1026-gcp, #27~18.04.1-Ubuntu SMP Fri Nov 15 07:40:39 UTC 2019, x86_64 with 8 processor cores. 2020-12-09 13:18:36 notice : Total usable main memory: 31.41GiB. 2020-12-09 13:18:36 notice : MariaDB MaxScale 2.5.5 started (Commit: 91c3b76195d0057ddbe572bbb8d17f6ac6b09d5e) 2020-12-09 13:18:36 notice : MaxScale is running in process 102857 2020-12-09 13:18:36 notice : Configuration file: /etc/maxscale.cnf 2020-12-09 13:18:36 notice : Log directory: /var/log/maxscale 2020-12-09 13:18:36 notice : Data directory: /var/lib/maxscale 2020-12-09 13:18:36 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2020-12-09 13:18:36 notice : Service cache: /var/cache/maxscale 2020-12-09 13:18:36 notice : Working directory: /var/log/maxscale 2020-12-09 13:18:36 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so 2020-12-09 13:18:36 info : qc_sqlite loaded. 2020-12-09 13:18:36 notice : Query classification results are cached and reused. Memory used per thread: 603.1MiB 2020-12-09 13:18:36 notice : Using encrypted passwords. Encryption key read from '/var/lib/maxscale/.secrets'. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082473322240. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082464929536. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082456536832. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082448144128. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082237404928. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082229012224. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082220619520. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082212226816. 2020-12-09 13:18:36 notice : MaxScale started with 8 worker threads, each with a stack size of 8388608 bytes. 2020-12-09 13:18:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140082654568256. 2020-12-09 13:18:36 notice : Loading /etc/maxscale.cnf. 2020-12-09 13:18:36 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-12-09 13:18:36 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so 2020-12-09 13:18:36 notice : Loaded module readconnroute: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadconnroute.so 2020-12-09 13:18:36 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so 2020-12-09 13:18:36 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: monitor_interval=10000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2020-12-09 13:18:36 notice : (LocalListener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so 2020-12-09 13:18:36 warning: The MaxScale GUI is enabled but encryption for the REST API is not enabled, the GUI will not be enabled. Configure `admin_ssl_key` and `admin_ssl_cert` to enable HTTPS or add `admin_secure_gui=false` to allow use of the GUI without encryption. 2020-12-09 13:18:36 notice : Started REST API on [127.0.0.1]:8989 2020-12-09 13:18:36 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-12-09 13:18:36 notice : Server 'skysql' version: 10.5.4-2-MariaDB-enterprise-log 2020-12-09 13:18:36 notice : Starting a total of 1 services... 2020-12-09 13:18:36 notice : (LocalListener) Listening for connections at [127.0.0.1]:3306 2020-12-09 13:18:36 notice : Service 'SkyService' started (1/1) 2020-12-09 13:18:37 notice : Read 184 user@host entries from 'skysql' for service 'SkyService'. 2020-12-09 13:18:46 info : Server variables loaded from 'skysql', next update in 600 seconds.