[MXS-1787] Crash with mysql client test `test_bug49972` Created: 2018-04-12  Updated: 2018-04-13  Resolved: 2018-04-13

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.2
Fix Version/s: 2.2.5

Type: Bug Priority: Major
Reporter: dapeng huang Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None


 Description   

crash at execute following code

 stmt= mysql_simple_prepare(mysql, "CALL p1((SELECT f1()), ?)");

stack:

bin/maxscale[0x407991]
/lib64/libpthread.so.0(+0xf100)[0x7f6f68801100]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x1846b)[0x7f6f621fb46b]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x13640)[0x7f6f621f6640]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x70449)[0x7f6f62253449]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x74f4b)[0x7f6f62257f4b]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x753ac)[0x7f6f622583ac]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x7588c)[0x7f6f6225888c]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0x75915)[0x7f6f62258915]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0xb2a4)[0x7f6f621ee2a4]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libqc_sqlite.so(+0xc685)[0x7f6f621ef685]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmaxscale-common.so.1.0.0(qc_get_type_mask+0x1b)[0x7f6f68cecfeb]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libreadwritesplit.so(_Z20determine_query_typeP5gwbufi+0x49)[0x7f6f630db149]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libreadwritesplit.so(_Z15get_target_typeP14RWSplitSessionP5gwbufPhPjS4_+0x1b6)[0x7f6f630dc1e6]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libreadwritesplit.so(_ZN9RouteInfoC1EP14RWSplitSessionP5gwbuf+0x33)[0x7f6f630dab23]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libreadwritesplit.so(+0x7d20)[0x7f6f630d6d20]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmariadbclient.so(+0x3f6a)[0x7f6f6248df6a]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x586aa)[0x7f6f68cd36aa]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x58848)[0x7f6f68cd3848]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker15poll_waiteventsEv+0x1c1)[0x7f6f68d0fa41]
/home/wuzang.hdp/run/mxs2/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker3runEv+0x72)[0x7f6f68d0fcb2]



 Comments   
Comment by markus makela [ 2018-04-12 ]

Looks like it crashed while parsing the prepared statement.

Comment by markus makela [ 2018-04-12 ]

Reproduced it.

2018-04-12 17:35:41   alert  : (9) Fatal: MaxScale 2.2.4 received fatal signal 11. Attempting backtrace.
2018-04-12 17:35:41   alert  : (9) Commit ID: 1a293c0093bf1da68e1274ccd7dc717f8ca58264 System name: Linux Release string: NAME="CentOS Linux"
2018-04-12 17:35:41   alert  : (9)   /usr/bin/maxscale() [0x4051d7]: ??:0
2018-04-12 17:35:41   alert  : (9)   /lib64/libpthread.so.0(+0xf5e0) [0x7f41280ef5e0]: sigaction.c:?
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x20ea2) [0x7f41215cfea2]: /usr/include/c++/4.8.2/bits/stl_tree.h:482
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x1f897) [0x7f41215ce897]: /usr/include/c++/4.8.2/bits/stl_tree.h:657
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x1e817) [0x7f41215cd817]: /usr/include/c++/4.8.2/bits/stl_map.h:181
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x16bb0) [0x7f41215c5bb0]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:1317
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x163f7) [0x7f41215c53f7]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:1080
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x16808) [0x7f41215c5808]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:1198 (discriminator 2)
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x19f78) [0x7f41215c8f78]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:2070
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0xdd24) [0x7f41215bcd24]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:4079
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0xb2571) [0x7f4121661571]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:133288
2018-04-12 17:35:41   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0xb379f) [0x7f412166279f]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:134168
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0xb4b12) [0x7f4121663b12]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:135418
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x8c380) [0x7f412163b380]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:110297
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x8c70b) [0x7f412163b70b]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:110395
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x8c85a) [0x7f412163b85a]: /home/vagrant/build/sqlite-bld-3110100/sqlite3.c:110459
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x962d) [0x7f41215b862d]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:3358
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x9e73) [0x7f41215b8e73]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:3523
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x950c) [0x7f41215b850c]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:3346
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x143df) [0x7f41215c33df]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:256
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libqc_sqlite.so(+0x126cf) [0x7f41215c16cf]: /home/vagrant/MaxScale/query_classifier/qc_sqlite/qc_sqlite.cc:4609
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(qc_get_type_mask+0xe1) [0x7f412863b7dc]: /home/vagrant/MaxScale/server/core/query_classifier.cc:202
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libreadwritesplit.so(_Z20determine_query_typeP5gwbufi+0x6f) [0x7f4122940d06]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/rwsplit_mysql.cc:91
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libreadwritesplit.so(_Z15get_target_typeP14RWSplitSessionP5gwbufPhPjS4_+0xbd) [0x7f4122941d56]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:116
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libreadwritesplit.so(_ZN9RouteInfoC2EP14RWSplitSessionP5gwbuf+0x67) [0x7f412293f4bd]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/rwsplitsession.cc:141
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libreadwritesplit.so(+0x3044f) [0x7f412293944f]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/readwritesplit.cc:964
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmariadbclient.so(+0x76f7) [0x7f412189d6f7]: /home/vagrant/MaxScale/server/modules/protocol/MySQL/mariadbclient/mysql_client.cc:1563 (discriminator 1)
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmariadbclient.so(+0x5efe) [0x7f412189befe]: /home/vagrant/MaxScale/server/modules/protocol/MySQL/mariadbclient/mysql_client.cc:1063
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmariadbclient.so(+0x5ca0) [0x7f412189bca0]: /home/vagrant/MaxScale/server/modules/protocol/MySQL/mariadbclient/mysql_client.cc:1005
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmariadbclient.so(+0x43b5) [0x7f412189a3b5]: /home/vagrant/MaxScale/server/modules/protocol/MySQL/mariadbclient/mysql_client.cc:516
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x9dc92) [0x7f412860bc92]: /home/vagrant/MaxScale/server/core/dcb.cc:3113
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x9e050) [0x7f412860c050]: /home/vagrant/MaxScale/server/core/dcb.cc:3193
2018-04-12 17:35:42   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x9e0fd) [0x7f412860c0fd]: /home/vagrant/MaxScale/server/core/dcb.cc:3229
2018-04-12 17:35:43   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker15poll_waiteventsEv+0x455) [0x7f412866bf8f]: /home/vagrant/MaxScale/server/core/worker.cc:1205 (discriminator 3)
2018-04-12 17:35:43   alert  : (9)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker3runEv+0x54) [0x7f412866b0d8]: /home/vagrant/MaxScale/server/core/worker.cc:887
2018-04-12 17:35:43   alert  : (9)   /usr/bin/maxscale(main+0x204c) [0x409076]: /home/vagrant/MaxScale/server/core/gateway.cc:2254
2018-04-12 17:35:43   alert  : (9)   /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f4125ff4c05]: ??:?
2018-04-12 17:35:43   alert  : (9)   /usr/bin/maxscale() [0x4046b9]: ??:0

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