Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3425

Crash with LOAD DATA LOCAL INFILE and retain_last_statements

    XMLWordPrintable

Details

    Description

      Executing a LOAD DATA LOCAL INFILE when retain_last_statements is enabled causes the following crash:

      2021-03-02 09:08:39   alert  : (2) Fatal: MaxScale 2.4.17 received fatal signal 6. Commit ID: 0408bd9531e1844a8edff6b4ccf77ce75cc18738 System name: Linux Release string: Fedora release 32 (Thirty Two)
      2021-03-02 09:08:39   alert  : (2) Statement currently being classified: none/unknown
      2021-03-02 09:08:39   notice : (2) Stmt 5(2021-03-02 09:06:02): show databases
      2021-03-02 09:08:39   notice : (2) Stmt 4(2021-03-02 09:06:02): show tables
      2021-03-02 09:08:39   notice : (2) Stmt 3(2021-03-02 09:06:04): show tables
      2021-03-02 09:08:39   notice : (2) Stmt 2(2021-03-02 09:08:30): create table test.t1(id int)
      2021-03-02 09:08:39   notice : (2) Stmt 1(2021-03-02 09:08:39): load data local infile 'data.csv' into table t1
      2021-03-02 09:08:40   alert  : (2) 
        /lib64/libpthread.so.0(+0x14a90): sigaction.c:?
        /lib64/libpthread.so.0(raise+0x145): :?
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale7Session20book_server_responseEP6SERVERb+0x23a): server/core/session.cc:1492
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_Z28session_book_server_responseP11MXS_SESSIONP6SERVERb+0x2c): server/core/session.cc:977
        /home/markusjm/build-2.4/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession11clientReplyEP5GWBUFP3DCB+0xac2): server/modules/routing/readwritesplit/rwsplitsession.cc:742
        /home/markusjm/build-2.4/lib64/maxscale/libreadwritesplit.so(_ZN8maxscale6RouterI7RWSplit14RWSplitSessionE11clientReplyEP10mxs_routerP18mxs_router_sessionP5GWBUFP3DCB+0x4a): include/maxscale/router.hh:477
        /home/markusjm/build-2.4/lib64/maxscale/libmariadbbackend.so(+0xd9ea): server/modules/protocol/MySQL/mariadbbackend/mysql_backend.cc:1074
        /home/markusjm/build-2.4/lib64/maxscale/libmariadbbackend.so(+0xa7ee): server/modules/protocol/MySQL/mariadbbackend/mysql_backend.cc:523
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x2f50fb): server/core/dcb.cc:2710
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x2f538e): server/core/dcb.cc:2750
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x2f555e): server/core/dcb.cc:2788
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0xa13): maxutils/maxbase/src/worker.cc:856
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x20d): maxutils/maxbase/src/worker.cc:557
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker11thread_mainEPS0_PNS_9SemaphoreE+0x23): maxutils/maxbase/src/worker.cc:682
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZSt13__invoke_implIvPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EET_St14__invoke_otherOT0_DpOT1_+0xad): /usr/include/c++/10/bits/invoke.h:60
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZSt8__invokeIPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EENSt15__invoke_resultIT_JDpT0_EE4typeEOS8_DpOS9_+0x4f): /usr/include/c++/10/bits/invoke.h:96
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEE9_M_invokeIJLm0ELm1ELm2EEEEvSt12_Index_tupleIJXspT_EEE+0x5f): /usr/include/c++/10/thread:264
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEEclEv+0x18): /usr/include/c++/10/thread:271
        /home/markusjm/build-2.4/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS3_9SemaphoreEES5_S7_EEEEE6_M_runEv+0x1c): /usr/include/c++/10/thread:215
        /lib64/libstdc++.so.6(+0xd8ad4): ??:?
        /lib64/libpthread.so.0(+0x9432): pthread_create.c:?
        /lib64/libc.so.6(clone+0x43): :?
      

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.