MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Dec 18 10:27:54 2019 ---------------------------------------------------------------------------- 2019-12-18 10:27:54 notice : syslog logging is enabled. 2019-12-18 10:27:54 notice : maxlog logging is enabled. 2019-12-18 10:27:54 notice : The logging of informational messages has been enabled. 2019-12-18 10:27:54 notice : Using up to 4.66GiB of memory for query classifier cache 2019-12-18 10:27:54 notice : Working directory: /var/log/maxscale 2019-12-18 10:27:54 notice : The collection of SQLite memory allocation statistics turned off. 2019-12-18 10:27:54 notice : Threading mode of SQLite set to Multi-thread. 2019-12-18 10:27:54 notice : MariaDB MaxScale 2.4.4 started (Commit: 231f68b6dc70804b785df356679601ab3eb8e379) 2019-12-18 10:27:54 notice : MaxScale is running in process 14994 2019-12-18 10:27:54 notice : Configuration file: /etc/maxscale.cnf 2019-12-18 10:27:54 notice : Log directory: /var/log/maxscale 2019-12-18 10:27:54 notice : Data directory: /var/lib/maxscale 2019-12-18 10:27:54 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2019-12-18 10:27:54 notice : Service cache: /var/cache/maxscale 2019-12-18 10:27:54 notice : Worker message queue size: 1.00MiB 2019-12-18 10:27:54 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so 2019-12-18 10:27:54 info : qc_sqlite loaded. 2019-12-18 10:27:54 notice : Query classification results are cached and reused. Memory used per thread: 596.05MiB 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 info : Epoll instance for listening sockets added to worker epoll instance. 2019-12-18 10:27:54 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2019-12-18 10:27:54 notice : Loading /etc/maxscale.cnf. 2019-12-18 10:27:54 warning: /etc/maxscale.cnf.d exists, but it is not a directory. Ignoring. 2019-12-18 10:27:54 info : [maxscaled] Initialise MaxScaled Protocol module. 2019-12-18 10:27:54 notice : Loaded module maxscaled: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so 2019-12-18 10:27:54 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so 2019-12-18 10:27:54 warning: [cli] THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-12-18 10:27:54 notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so 2019-12-18 10:27:54 notice : [readwritesplit] Initializing statement-based read/write split router module. 2019-12-18 10:27:54 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so 2019-12-18 10:27:54 notice : [galeramon] Initialise the MySQL Galera Monitor module. 2019-12-18 10:27:54 notice : Loaded module galeramon: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libgaleramon.so 2019-12-18 10:27:54 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: monitor_interval=2000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2019-12-18 10:27:54 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackend.so 2019-12-18 10:27:54 notice : [cache] Initialized cache module V1.0.0. 2019-12-18 10:27:54 notice : Loaded module cache: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcache.so 2019-12-18 10:27:54 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackendauth.so 2019-12-18 10:27:54 notice : [cache] Creating shared cache. 2019-12-18 10:27:54 notice : [storage_inmemory] Storage module created. 2019-12-18 10:27:54 notice : [cache] Created multi threaded LRU storage. 2019-12-18 10:27:54 notice : [cache] Created multi threaded cache. 2019-12-18 10:27:54 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so 2019-12-18 10:27:54 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxadminauth.so 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056547096320. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056467601152. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056459208448. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056450815744. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056442423040. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056434030336. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056425637632. 2019-12-18 10:27:54 info : In-memory sqlite database successfully opened for thread 140056417244928. 2019-12-18 10:27:54 notice : Started REST API on [127.0.0.1]:8989 2019-12-18 10:27:54 notice : MaxScale started with 8 worker threads, each with a stack size of 8388608 bytes. 2019-12-18 10:27:54 notice : Starting a total of 2 services... 2019-12-18 10:27:54 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-12-18 10:27:54 notice : Server 'db01-b' version: 10.2.18-MariaDB-10.2.18+maria~xenial-log 2019-12-18 10:27:54 notice : Server 'db01-a' version: 10.2.18-MariaDB-10.2.18+maria~xenial 2019-12-18 10:27:54 notice : Server 'db01-c' version: 10.2.18-MariaDB-10.2.18+maria~xenial-log 2019-12-18 10:27:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES (#Information Removed) . 2019-12-18 10:27:54 notice : [MariaDBAuth] [Read-Write-Service] Loaded 52 MySQL users for listener Read-Write-Listener from server db01-b. . 2019-12-18 10:27:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES (#Information Removed) . . 2019-12-18 10:27:54 notice : Listening for connections at [0.0.0.0]:3306 2019-12-18 10:27:54 notice : Service 'Read-Write-Service' started (1/2) 2019-12-18 10:27:54 notice : Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 2019-12-18 10:27:54 notice : Service 'MaxAdmin-Service' started (2/2) 2019-12-18 10:27:54 error : (1) [readwritesplit] Couldn't find suitable Master from 3 candidates. 2019-12-18 10:27:54 error : (1) Failed to create new router session for service 'Read-Write-Service'. See previous errors for more details. 2019-12-18 10:27:54 info : Stopped Read-Write-Service client session [1] 2019-12-18 10:27:54 notice : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2019-12-18 10:27:54 info : (2) [readwritesplit] Servers and router connection counts: 2019-12-18 10:27:54 info : (2) [readwritesplit] current operations : 0 in [10.0.0.22]:3306 Slave, Synced, Running 2019-12-18 10:27:54 info : (2) [readwritesplit] current operations : 0 in [10.0.0.21]:3306 Slave, Synced, Running 2019-12-18 10:27:54 info : (2) [readwritesplit] current operations : 0 in [10.0.0.23]:3306 Master, Synced, Running 2019-12-18 10:27:54 info : (2) [readwritesplit] Connected to 'db01-c' 2019-12-18 10:27:54 info : (2) [readwritesplit] Selected Master: db01-c 2019-12-18 10:27:54 info : (2) [readwritesplit] Connected to 'db01-b' 2019-12-18 10:27:54 info : (2) [readwritesplit] Selected Slave: db01-b 2019-12-18 10:27:54 info : (2) Started Read-Write-Service client session [2] for '#Information Removed' from 10.0.0.32 2019-12-18 10:27:54 info : (2) Connected to 'db01-c' with thread id 41317934 2019-12-18 10:27:54 info : (2) Connected to 'db01-b' with thread id 723855046 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_SESSION_WRITE, stmt: SET NAMES 'utf8' 2019-12-18 10:27:54 info : (2) [readwritesplit] Session write, routing to all servers. 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to master: db01-c [10.0.0.23]:3306 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-c 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 114, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.name AS c__name, c.value AS c__value FROM cms_params c WHERE c.name = 'cache' LIMIT 1 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 494, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.name AS c__name, c.urlname AS c__urlname, c.title AS c__title, c.description AS c__description, c.keywords AS c__keywords, c.type AS c__type, c.image1 AS c__image1, c.image2 AS c__image2, c.image3 AS c__image3, c.image4 AS c__image4, c.image5 AS c__image5, c.hidden AS c__hidden, c.ressort_id AS c__ressort_id, c.seobox_id AS c__seobox_id, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM cms_category c WHERE c.urlname = '#Information Removed' 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 492, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.name AS c__name, c.urlname AS c__urlname, c.title AS c__title, c.description AS c__description, c.keywords AS c__keywords, c.type AS c__type, c.image1 AS c__image1, c.image2 AS c__image2, c.image3 AS c__image3, c.image4 AS c__image4, c.image5 AS c__image5, c.hidden AS c__hidden, c.ressort_id AS c__ressort_id, c.seobox_id AS c__seobox_id, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM cms_category c WHERE c.id = '1' LIMIT 1 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to master: db01-c [10.0.0.23]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-c 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 84, type: QUERY_TYPE_WRITE, stmt: INSERT INTO cms_tracking (element_name, element_id) VALUES ('CmsCategory', '1') 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to master: db01-c [10.0.0.23]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-c 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 11, type: QUERY_TYPE_COMMIT, stmt: commit 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to master: db01-c [10.0.0.23]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-c 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 325, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.name AS c__name, c.tname AS c__tname, c.type AS c__type, c.module AS c__module, c.controller AS c__controller, c.action AS c__action, c.lifetime AS c__lifetime, c.identifier AS c__identifier, c.rendered_objects AS c__rendered_objects FROM cms_placement_box c WHERE c.identifier = 'animatedteaser' 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 249, type: QUERY_TYPE_READ, stmt: SELECT updated FROM cms_cache_manager WHERE type = '#Information Removed' AND id = '10' 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 310, type: QUERY_TYPE_READ, stmt: SELECT c.id AS c__id, c.category_id AS c__category_id, c.list_id AS c__list_id, c.box_id AS c__box_id, c.param AS c__param, c.objectname AS c__objectname, c.placeholder AS c__placeholder, c.sort AS c__sort FROM cms_placement c WHERE (c.category_id = '10' AND c.placeholder = 'left_bottom') ORDER BY c.sort 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1334, 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 2019-12-18 10:27:54 info : (2) [readwritesplit] Route query to slave: db01-b [10.0.0.22]:3306 < 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-b 2019-12-18 10:27:54 info : (2) [readwritesplit] Reply complete, last reply from db01-b 2019-12-18 10:27:54 error : (2) debug assert at /home/vagrant/MaxScale/server/core/buffer.cc:48 failed: buf->tail != reinterpret_cast(0xdeadbeef) 2019-12-18 10:27:54 alert : (2) Fatal: MaxScale 2.4.4 received fatal signal 6. Commit ID: 231f68b6dc70804b785df356679601ab3eb8e379 System name: Linux Release string: Ubuntu 18.04.3 LTS 2019-12-18 10:27:54 info : (3) [readwritesplit] Servers and router connection counts: 2019-12-18 10:27:54 info : (3) [readwritesplit] current operations : 0 in [10.0.0.22]:3306 Slave, Synced, Running 2019-12-18 10:27:54 info : (3) [readwritesplit] current operations : 0 in [10.0.0.21]:3306 Slave, Synced, Running 2019-12-18 10:27:54 info : (3) [readwritesplit] current operations : 0 in [10.0.0.23]:3306 Master, Synced, Running 2019-12-18 10:27:54 info : (3) [readwritesplit] Connected to 'db01-c' 2019-12-18 10:27:54 info : (3) [readwritesplit] Selected Master: db01-c 2019-12-18 10:27:54 info : (3) [readwritesplit] Connected to 'db01-a' 2019-12-18 10:27:54 info : (3) [readwritesplit] Selected Slave: db01-a 2019-12-18 10:27:54 info : (3) Started Read-Write-Service client session [3] for '#Information Removed' from 10.0.0.33 2019-12-18 10:27:54 info : (3) Connected to 'db01-c' with thread id 41317935 2019-12-18 10:27:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_SESSION_WRITE, stmt: SET NAMES 'utf8' 2019-12-18 10:27:54 info : (3) [readwritesplit] Session write, routing to all servers. 2019-12-18 10:27:54 info : (3) [readwritesplit] Route query to slave: db01-a [10.0.0.21]:3306 2019-12-18 10:27:54 info : (3) [readwritesplit] Route query to master: db01-c [10.0.0.23]:3306 2019-12-18 10:27:54 info : (3) Connected to 'db01-a' with thread id 557135269 2019-12-18 10:27:54 info : (3) [readwritesplit] Reply complete, last reply from db01-c 2019-12-18 10:27:54 info : (3) [readwritesplit] Reply complete, last reply from db01-a 2019-12-18 10:27:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 539, 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 = '#Information Removed' AND c2.active = '1' 2019-12-18 10:27:54 info : (3) [readwritesplit] Route query to slave: db01-a [10.0.0.21]:3306 < 2019-12-18 10:27:54 info : (3) [readwritesplit] Reply complete, last reply from db01-a 2019-12-18 10:27:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 1471, 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 2019-12-18 10:27:54 info : (3) [readwritesplit] Route query to slave: db01-a [10.0.0.21]:3306 < 2019-12-18 10:27:54 info : (3) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-a 2019-12-18 10:27:54 info : (3) [readwritesplit] Reply not yet complete. Waiting for 1 replies, got one from db01-a 2019-12-18 10:27:54 error : (3) debug assert at /home/vagrant/MaxScale/server/core/buffer.cc:48 failed: buf->tail != reinterpret_cast(0xdeadbeef) MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Dec 18 10:27:55 2019 ---------------------------------------------------------------------------- 2019-12-18 10:27:55 notice : syslog logging is enabled. 2019-12-18 10:27:55 notice : maxlog logging is enabled. 2019-12-18 10:27:55 notice : The logging of informational messages has been enabled. 2019-12-18 10:27:55 notice : Using up to 4.66GiB of memory for query classifier cache