[MXS-3585] query classifier crashes after upgrade from 2.5.11 to 2.5.12 Created: 2021-06-01  Updated: 2021-11-15  Resolved: 2021-06-02

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.4.18, 2.5.12
Fix Version/s: 2.4.19, 2.5.13

Type: Bug Priority: Critical
Reporter: Maikel Punie Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None
Environment:

centos7


Issue Links:
Duplicate
is duplicated by MXS-3873 Crash in qc_sqlite Closed

 Description   

when uprgading from 2.5.11 to 2.5.12 we get a crash in the read-write splitter

2021-06-01 14:20:44   alert  : (82) (ReadWriteSVC) MaxScale 2.5.12 received fatal signal 11. Commit ID: 7cff3faf7b1237d037ee1b6526add9a56cbc580e System name: Linux Release string: CentOS Linux release 7.9.2009 (Core)
2021-06-01 14:20:44   alert  : (82) (ReadWriteSVC) Statement currently being classified: update mailbox_queue as mb inner join ( select * from mailbox_queue where parsingDone=0 and scheduler=0 and testbed like "%an%" order by mailbox_queue.id limit 20) as mb2 on mb.id=mb2.id set mb.scheduler="2"
2021-06-01 14:20:45   alert  : (82) (ReadWriteSVC)
  /usr/lib64/maxscale/libqc_sqlite.so(+0x79f87): _build/sqlite-bld-3110100/sqlite3.c:132773
  /usr/lib64/maxscale/libqc_sqlite.so(+0x7d0bb): _build/sqlite-bld-3110100/sqlite3.c:135991
  /usr/lib64/maxscale/libqc_sqlite.so(+0x7d70d): _build/sqlite-bld-3110100/sqlite3.c:110385
  /usr/lib64/maxscale/libqc_sqlite.so(+0x7da99): _build/sqlite-bld-3110100/sqlite3.c:110484
  /usr/lib64/maxscale/libqc_sqlite.so(+0x7db27): _build/sqlite-bld-3110100/sqlite3.c:110550
  /usr/lib64/maxscale/libqc_sqlite.so(+0xb92b): query_classifier/qc_sqlite/qc_sqlite.cc:3647
  /usr/lib64/maxscale/libqc_sqlite.so(+0xef4d): query_classifier/qc_sqlite/qc_sqlite.cc:3819
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_Z16qc_get_type_maskP5GWBUF+0x5f): /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/basic_string.h:3295
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale15QueryClassifier17update_route_infoENS0_16current_target_tEP5GWBUF+0x1af): server/core/queryclassifier.cc:1003
  /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession10routeQueryEP5GWBUF+0x2cd): server/modules/routing/readwritesplit/rwsplitsession.cc:135
  /usr/lib64/maxscale/libreadwritesplit.so(_ZN8maxscale6RouterI7RWSplit14RWSplitSessionE10routeQueryEP10mxs_routerP18mxs_router_sessionP5GWBUF+0x21): include/maxscale/router.hh:436
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN15ServiceEndpoint10routeQueryEP5GWBUF+0x81): server/core/service.cc:1882
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7Session10routeQueryEP5GWBUF+0x19): server/core/session.cc:1340
  /usr/lib64/maxscale/libmariadbclient.so(_ZN23MariaDBClientConnection15route_statementEON8maxscale6BufferE+0x92): server/modules/protocol/MariaDB/mariadb_client.cc:1264
  /usr/lib64/maxscale/libmariadbclient.so(_ZN23MariaDBClientConnection21process_normal_packetEON8maxscale6BufferE+0x37): server/modules/protocol/MariaDB/mariadb_client.cc:2450
  /usr/lib64/maxscale/libmariadbclient.so(_ZN23MariaDBClientConnection19process_normal_readEv+0x2a1): server/modules/protocol/MariaDB/mariadb_client.cc:1321
  /usr/lib64/maxscale/libmariadbclient.so(_ZN23MariaDBClientConnection17ready_for_readingEP3DCB+0x68): server/modules/protocol/MariaDB/mariadb_client.cc:1441
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN3DCB14process_eventsEj+0x69): server/core/dcb.cc:1292
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN3DCB13event_handlerEPS_j+0x21): server/core/dcb.cc:1351
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0x1be): maxutils/maxbase/src/worker.cc:879
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x53): maxutils/maxbase/src/worker.cc:574
  /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x22ce5f): thread48.o:?
  /lib64/libpthread.so.0(+0x7ea5): pthread_create.c:?
  /lib64/libc.so.6(clone+0x6d): ??:?


Generated at Thu Feb 08 04:22:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.