MariaDB MaxScale  /var/log/maxscale/maxscale.log  Thu Feb 13 01:22:17 2020
----------------------------------------------------------------------------
2020-02-13 01:22:17   notice : syslog logging is enabled.
2020-02-13 01:22:17   notice : maxlog logging is enabled.
2020-02-13 01:22:17   notice : The logging of informational messages has been enabled.
2020-02-13 01:22:17   notice : Using up to 4.66GiB of memory for query classifier cache
2020-02-13 01:22:17   notice : Working directory: /var/log/maxscale
2020-02-13 01:22:17   notice : The collection of SQLite memory allocation statistics turned off.
2020-02-13 01:22:17   notice : Threading mode of SQLite set to Multi-thread.
2020-02-13 01:22:17   notice : MariaDB MaxScale 2.4.6 started (Commit: 714dece7ddb025d2ed2cca945a607a02b80bc7a2)
2020-02-13 01:22:17   notice : MaxScale is running in process 5885
2020-02-13 01:22:17   notice : Configuration file: /etc/maxscale.cnf
2020-02-13 01:22:17   notice : Log directory: /var/log/maxscale
2020-02-13 01:22:17   notice : Data directory: /var/lib/maxscale
2020-02-13 01:22:17   notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale
2020-02-13 01:22:17   notice : Service cache: /var/cache/maxscale
2020-02-13 01:22:17   notice : Worker message queue size: 1.00MiB
2020-02-13 01:22:17   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so
2020-02-13 01:22:17   info   : qc_sqlite loaded.
2020-02-13 01:22:17   notice : Query classification results are cached and reused. Memory used per thread: 596.05MiB
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-02-13 01:22:17   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-02-13 01:22:17   notice : Loading /etc/maxscale.cnf.
2020-02-13 01:22:17   warning: /etc/maxscale.cnf.d exists, but it is not a directory. Ignoring.
2020-02-13 01:22:17   info   : [maxscaled] Initialise MaxScaled Protocol module.
2020-02-13 01:22:17   notice : Loaded module maxscaled: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so
2020-02-13 01:22:17   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so
2020-02-13 01:22:17   warning: [cli] THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead
2020-02-13 01:22:17   notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so
2020-02-13 01:22:17   notice : [readwritesplit] Initializing statement-based read/write split router module.
2020-02-13 01:22:17   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so
2020-02-13 01:22:17   notice : [galeramon] Initialise the MySQL Galera Monitor module.
2020-02-13 01:22:17   notice : Loaded module galeramon: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libgaleramon.so
2020-02-13 01:22:17   notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackend.so
2020-02-13 01:22:17   notice : [cache] Initialized cache module V1.0.0.
2020-02-13 01:22:17   notice : Loaded module cache: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcache.so
2020-02-13 01:22:17   notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackendauth.so
2020-02-13 01:22:17   notice : [cache] Creating shared cache.
2020-02-13 01:22:17   notice : [storage_inmemory] Storage module created.
2020-02-13 01:22:17   notice : [cache] Created multi threaded LRU storage.
2020-02-13 01:22:17   notice : [cache] Created multi threaded cache.
2020-02-13 01:22:17   notice : Loaded module mariadbauth: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so
2020-02-13 01:22:17   notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxadminauth.so
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231690532608.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231682139904.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231673747200.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231665354496.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231656961792.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231648569088.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231640176384.
2020-02-13 01:22:17   info   : In-memory sqlite database successfully opened for thread 140231631783680.
2020-02-13 01:22:17   notice : Started REST API on [127.0.0.1]:8989
2020-02-13 01:22:17   notice : MaxScale started with 8 worker threads, each with a stack size of 8388608 bytes.
2020-02-13 01:22:17   notice : Starting a total of 2 services...
2020-02-13 01:22:17   notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used.
2020-02-13 01:22:17   notice : Server 'db01-b' version: 10.2.18-MariaDB-10.2.18+maria~xenial-log
2020-02-13 01:22:17   notice : Server 'db01-a' version: 10.2.18-MariaDB-10.2.18+maria~xenial
2020-02-13 01:22:17   notice : Server 'db01-c' version: 10.2.18-MariaDB-10.2.18+maria~xenial-log
2020-02-13 01:22:17   notice : [MariaDBAuth] [Read-Write-Service] Loaded 16 MySQL users for listener 'Read-Write-Listener' from server 'db01-b' with checksum 0x34ed7ad9.
<---shortened MariaDBAuth added users --->
2020-02-13 01:22:17   info   : [MariaDBAuth] Added user:
<---shortened MariaDBAuth added users --->
2020-02-13 01:22:18   info   : (4) [readwritesplit] Route query to master: db01-c 	[10.0.0.23]:3306 <
2020-02-13 01:22:18   info   : (4) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-c
2020-02-13 01:22:18   info   : (4) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-c
2020-02-13 01:22:18   error  : (4) debug assert at /home/vagrant/MaxScale/server/core/buffer.cc:48 failed: buf->tail != reinterpret_cast<GWBUF*>(0xdeadbeef)
2020-02-13 01:22:18   alert  : (4) Fatal: MaxScale 2.4.6 received fatal signal 6. Commit ID: 714dece7ddb025d2ed2cca945a607a02b80bc7a2 System name: Linux Release string: Ubuntu 18.04.4 LTS
2020-02-13 01:22:19   info   : (5) [readwritesplit] Servers and router connection counts:
2020-02-13 01:22:19   info   : (5) [readwritesplit] current operations : 0 in 	[10.0.0.22]:3306 Slave, Synced, Running
2020-02-13 01:22:19   info   : (5) [readwritesplit] current operations : 1 in 	[10.0.0.21]:3306 Slave, Synced, Running
2020-02-13 01:22:19   info   : (5) [readwritesplit] current operations : 1 in 	[10.0.0.23]:3306 Master, Synced, Running
2020-02-13 01:22:19   info   : (5) [readwritesplit] Connected to 'db01-c'
2020-02-13 01:22:19   info   : (5) [readwritesplit] Selected Master: db01-c
2020-02-13 01:22:19   info   : (5) [readwritesplit] Connected to 'db01-b'
2020-02-13 01:22:19   info   : (5) [readwritesplit] Selected Slave: db01-b
2020-02-13 01:22:19   info   : (5) Started Read-Write-Service client session [5] for 'USER' from 10.0.0.31
2020-02-13 01:22:19   info   : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_SESSION_WRITE, stmt: SET NAMES 'utf8' 
2020-02-13 01:22:19   info   : (5) [readwritesplit] Session write, routing to all servers.
2020-02-13 01:22:19   info   : (5) [readwritesplit] Route query to slave: db01-b 	[10.0.0.22]:3306
2020-02-13 01:22:19   info   : (5) [readwritesplit] Route query to master: db01-c 	[10.0.0.23]:3306
2020-02-13 01:22:19   info   : (5) Connected to 'db01-c' with thread id 223218588
2020-02-13 01:22:19   info   : (5) Connected to 'db01-b' with thread id 816189271
2020-02-13 01:22:19   info   : (5) [readwritesplit] Reply complete, last reply from db01-c
2020-02-13 01:22:19   info   : (5) [readwritesplit] Reply complete, last reply from db01-b
2020-02-13 01:22:19   info   : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 629, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.redirect_id AS c__redirect_id, c.url AS c__url, c.destination_id AS c__destination_id, c.user_id AS c__user_id, c.created AS c__created, c.updated AS c__updated, c2.id AS c2__id, c2.title AS c2__title, c2.objectid AS c2__objectid, c2.objectname AS c2__objectname, c2.active AS c2__active, c2.user_id AS c2__user_id, c2.created AS c2__created, c2.updated AS c2__updated FROM cms_redirect_source c INNER JOIN cms_redirect c2 ON c.redirect_id = c2.id WHERE c.url = 'cencored-url/' AND c2.active = '1' 
2020-02-13 01:22:19   info   : (5) [readwritesplit] Route query to slave: db01-b 	[10.0.0.22]:3306 <
2020-02-13 01:22:19   info   : (5) [readwritesplit] Reply complete, last reply from db01-b
2020-02-13 01:22:19   info   : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 4467, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.title AS c__title, c.seotitle AS c__seotitle, c.urlname AS c__urlname, c.header AS c__header, c.seoheader AS c__seoheader, c.teaser AS c__teaser, c.shortteaser AS c__shortteaser, c.teasertitle AS c__teasertitle, c.text AS c__text, c.debatetext AS c__debatetext, c.keywords AS c__keywords, c.filename AS c__filename, c.sourcetext AS c__sourcetext, c.authortext AS c__authortext, c.type AS c__type, c.subtype AS c__subtype, c.urgency AS c__urgency, c.user_id AS c__user_id, c.owner_id AS c__owner_id, c.category_id AS c__category_id, c.resource_id AS c__resource_id, c.approved AS c__approved, c.archive AS c__archive, c.approved_date AS c__approved_date, c.description AS c__description, c.published_date AS c__published_date, c.public_vgwort_id AS c__public_vgwort_id, c.private_vgwort_id AS c__private_vgwort_id, c.vgwort_domain AS c__vgwort_domain, c.vgwort_reported AS c__vgwort_reported, c.hide AS c__hide, c.redirect_article_id AS c__redirect_article_id, c.ticker_inverte 
2020-02-13 01:22:19   info   : (5) [readwritesplit] Route query to slave: db01-b 	[10.0.0.22]:3306 <
2020-02-13 01:22:19   info   : (5) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-b
2020-02-13 01:22:19   info   : (5) [readwritesplit] Reply complete, last reply from db01-b
2020-02-13 01:22:19   error  : (5) debug assert at /home/vagrant/MaxScale/server/core/buffer.cc:48 failed: buf->tail != reinterpret_cast<GWBUF*>(0xdeadbeef)
2020-02-13 01:22:19   alert  : (5) Fatal: MaxScale 2.4.6 received fatal signal 6. Commit ID: 714dece7ddb025d2ed2cca945a607a02b80bc7a2 System name: Linux Release string: Ubuntu 18.04.4 LTS
nm: /lib/x86_64-linux-gnu/libc.so.6: no symbols
nm: /lib/x86_64-linux-gnu/libc.so.6: no symbols
2020-02-13 01:22:19   alert  : (2) 
  /lib/x86_64-linux-gnu/libpthread.so.0(raise+0xc7): ??:?
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_Z14ensure_at_headPK5GWBUF+0xc2): server/core/buffer.cc:49
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_Z15validate_bufferPK5GWBUF+0xc3): server/core/buffer.cc:60
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_Z12gwbuf_lengthPK5GWBUF+0x18): server/core/buffer.cc:550
  /usr/lib/x86_64-linux-gnu/maxscale/libcache.so(_ZN18CacheFilterSession11clientReplyEP5GWBUF+0x5d): server/modules/filter/cache/cachefiltersession.cc:364
  /usr/lib/x86_64-linux-gnu/maxscale/libcache.so(_ZN8maxscale6FilterI11CacheFilter18CacheFilterSessionE11clientReplyEP10mxs_filterP18mxs_filter_sessionP5GWBUF+0x37): include/maxscale/filter.hh:547
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_Z19session_route_replyP11MXS_SESSIONP5GWBUF+0x2fb): server/core/session.cc:542
  /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so(_ZN14RWSplitSession11clientReplyEP5GWBUFP3DCB+0x1043): server/modules/routing/readwritesplit/rwsplitsession.cc:866
  /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so(_ZN8maxscale6RouterI7RWSplit14RWSplitSessionE11clientReplyEP10mxs_routerP18mxs_router_sessionP5GWBUFP3DCB+0x4a): include/maxscale/router.hh:477
  /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackend.so(+0x5db6): server/modules/protocol/MySQL/mariadbbackend/mysql_backend.cc:1069
  /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackend.so(+0x45dc): server/modules/protocol/MySQL/mariadbbackend/mysql_backend.cc:515
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(+0x2068a1): server/core/dcb.cc:2713
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(+0x206c3c): server/core/dcb.cc:2794
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(+0x206cf8): server/core/dcb.cc:2832
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0x43a): maxutils/maxbase/src/worker.cc:856
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x135): maxutils/maxbase/src/worker.cc:557
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker11thread_mainEPS0_PNS_9SemaphoreE+0x23): maxutils/maxbase/src/worker.cc:682
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZSt13__invoke_implIvPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EET_St14__invoke_otherOT0_DpOT1_+0x4c): /usr/include/c++/7/bits/invoke.h:60
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZSt8__invokeIPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EENSt15__invoke_resultIT_JDpT0_EE4typeEOS8_DpOS9_+0x57): /usr/include/c++/7/bits/invoke.h:95
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEE9_M_invokeIJLm0ELm1ELm2EEEEDTcl8__invokespcl10_S_declvalIXT_EEEEESt12_Index_tupleIJXspT_EEE+0x5f): /usr/include/c++/7/thread:234
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEEclEv+0x1d): /usr/include/c++/7/thread:243
  /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS3_9SemaphoreEES5_S7_EEEEE6_M_runEv+0x1c): /usr/include/c++/7/thread:186
  /usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xbd66f): ??:?
  /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db): ??:?
  /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f): ??:0


