Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
OS:CentOS Linux release 7.7.1908 (Core)
Maxscale: Linux maxscale_189 3.10.0-1062.1.1.el7.x86_64 #1 SMP Fri Sep 13 22:55:44 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
MaxScale 2.4.2
ram 8G
cpu 16 core
-
MXS-SPRINT-93, MXS-SPRINT-94
Description
error in maxscale.log
Maybe this is because I enable maxscale cache for my Percona XtrDB Cluster 5.7
So I closed maxscale cache now.
==========================
|
2019-10-01 21:38:52 alert : (79707) Fatal: MaxScale 2.4.2 received fatal signal 11. Attempting backtrace.
|
2019-10-01 21:38:52 alert : (79707) Commit ID: aad4148d77bf2dfbaa0042bc45abda30c101cad2 System name: Linux Release string: NAME="CentOS Linux"
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libcache.so(_ZN10LRUStorage12do_put_valueERK9cache_keyPK5GWBUF+0xc8): server/modules/filter/cache/lrustorage.hh:201
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libcache.so(_ZN12LRUStorageMT9put_valueERK9cache_keyPK5GWBUF+0x47): /opt/rh/devtoolset-7/root/usr/include/c++/7/x86_64-redhat-linux/bits/gthr-default.h:777
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libcache.so(_ZN18CacheFilterSession12store_resultEv+0x39): server/modules/filter/cache/cachefiltersession.cc:774
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libcache.so(_ZN18CacheFilterSession21handle_expecting_rowsEv+0x14e): server/modules/filter/cache/cachefiltersession.cc:634
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libcache.so(_ZN8maxscale6FilterI11CacheFilter18CacheFilterSessionE11clientReplyEP10mxs_filterP18mxs_filter_sessionP5GWBUF+0x14): include/maxscale/filter.hh:550
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_Z19session_route_replyP11MXS_SESSIONP5GWBUF+0x15): server/core/session.cc:573
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession11clientReplyEP5GWBUFP3DCB+0x4a1): server/modules/routing/readwritesplit/rwsplitsession.cc:836
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libreadwritesplit.so(_ZN8maxscale6RouterI7RWSplit14RWSplitSessionE11clientReplyEP10mxs_routerP18mxs_router_sessionP5GWBUFP3DCB+0x27): include/maxscale/router.hh:477
|
2019-10-01 21:38:52 alert : (79707) /usr/lib64/maxscale/libmariadbbackend.so(+0x4683): server/modules/protocol/MySQL/mariadbbackend/mysql_backend.cc:1044
|
2019-10-01 21:38:53 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x9d487): server/core/dcb.cc:2701
|
2019-10-01 21:38:53 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x9d511): server/core/dcb.cc:2793
|
2019-10-01 21:38:53 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0x196): maxutils/maxbase/src/worker.cc:858
|
2019-10-01 21:38:53 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x53): maxutils/maxbase/src/worker.cc:559
|
2019-10-01 21:38:53 alert : (79707) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x1ad83f): thread48.o:?
|
2019-10-01 21:38:53 alert : (79707) /lib64/libpthread.so.0(+0x7e65): pthread_create.c:?
|
2019-10-01 21:38:53 alert : (79707) /lib64/libc.so.6(clone+0x6d): ??:?
|
============================
|
/etc/maxscale.cnf
|
[maxscale]
|
threads=auto
|
|
|
[node1]
|
type=server
|
address=10.1.0.176
|
port=3306
|
protocol=mariadbbackend
|
|
|
[node2]
|
type=server
|
address=10.1.0.177
|
port=3306
|
protocol=mariadbbackend
|
|
|
[node3]
|
type=server
|
address=10.1.0.178
|
port=3306
|
protocol=mariadbbackend
|
|
|
[node4]
|
type=server
|
address=10.1.0.179
|
port=3306
|
protocol=mariadbbackend
|
|
|
[node5]
|
type=server
|
address=10.1.0.180
|
port=3306
|
protocol=mariadbbackend
|
|
|
[backup_server]
|
type=server
|
address=10.1.0.121
|
port=3306
|
protocol=mariadbbackend
|
|
|
[PXC_Monitor]
|
type=monitor
|
module=galeramon
|
servers=node1,node2,node3,node4,node5,backup_server
|
user=maxscale_monitor
|
password=xxxxxxxxxxxxxxxxxxxxxx
|
monitor_interval=2000ms
|
|
|
|
|
[MaxScaleCache]
|
type=filter
|
module=cache
|
storage=storage_inmemory
|
soft_ttl=60s
|
hard_ttl=90s
|
cached_data=shared
|
max_size=256Mi
|
max_resultset_rows=1000
|
selects=verify_cacheable
|
enabled=true
|
|
|
[PXC_Service]
|
type=service
|
router=readwritesplit
|
slave_selection_criteria=LEAST_GLOBAL_CONNECTIONS
|
servers=node1,node2,node3,node4,node5
|
user=maxscale_monitor
|
password=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|
enable_root_user=1
|
connection_timeout=7200s
|
max_connections=2000
|
max_slave_connections=1
|
filters=MaxScaleCache
|
log_auth_warnings=true
|
master_accept_reads=true
|
disable_sescmd_history=true
|
|
|
[BackUp_Mysql_Service]
|
type=service
|
router=readconnroute
|
router_options=running
|
servers=backup_server
|
user=maxscale_monitor
|
password=xxxxxxxxxxxxxxxxxxx
|
enable_root_user=1
|
|
|
[PXC_Listener]
|
type=listener
|
service=PXC_Service
|
protocol=mariadbclient
|
address=0.0.0.0
|
port=3306
|
|
|
[BackUp_Listener]
|
type=listener
|
service=BackUp_Mysql_Service
|
protocol=mariadbclient
|
address=0.0.0.0
|
port=3307
|