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

crash in readwritesplit with temporary table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.2.1
    • N/A
    • readwritesplit
    • None

    Description

      Just happened to a customer:

      2018-04-05 23:18:42   warning: (3725012) [readwritesplit] [rwsplit-service] Write query received from ecash_jobs@172.24.100.1. Master server changed from 'db01' to 'db02'. Closing client connection.
      2018-04-05 23:18:42   error  : (3725012) [readwritesplit] Routing query "DROP TEMPORARY TABLE IF EXISTS wyfcdqdovg_17;
      					CREATE TEMPORARY TABLE wyfcdqdovg_17(
      						hdr_id INT(10) NOT NULL DEFAULT 0,max_ti_id INT(10) NOT NULL DEFAULT 0,hdr_new_status_id int(10) not null default 0,hdr_new_sub_status_id int(10) not null default 0,
      						index idx_maxti_id(max_ti_id),index idx_hdr_id(hdr_id)
      						) ENGINE=MEMORY;
      					LOAD DATA INFILE '/tmp/wyfcdqdovg_17.csv' INTO TABLE wyfcdqdovg_17 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'" failed.
      2018-04-05 23:18:42   alert  : (3725012) Fatal: MaxScale 2.2.1 received fatal signal 11. Attempting backtrace.
      2018-04-05 23:18:42   alert  : (3725012) Commit ID: eda82881619388a3512d6cfcbcf9ad83ea930339 System name: Linux Release string: CentOS release 6.9 (Final)
      2018-04-05 23:18:43   alert  : (3725012)   /usr/bin/maxscale() [0x406c29]: ??:0
      2018-04-05 23:18:44   alert  : (3725012)   /lib64/libpthread.so.0() [0x398340f7e0]: ??:0
      2018-04-05 23:18:44   alert  : (3725012)   /lib64/libc.so.6(cfree+0x1c) [0x398307b8cc]: ??:0
      2018-04-05 23:18:45   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x42c41) [0x7f84426c9c41]: ??:0
      2018-04-05 23:18:46   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(gwbuf_free+0x19) [0x7f84426c9f49]: ??:0
      2018-04-05 23:18:46   alert  : (3725012)   /usr/lib64/maxscale/libreadwritesplit.so(+0xa214) [0x7f84411c0214]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/readwritesplit.cc:502
      2018-04-05 23:18:47   alert  : (3725012)   /usr/lib64/maxscale/libreadwritesplit.so(+0xa722) [0x7f84411c0722]: /home/vagrant/MaxScale/server/modules/routing/readwritesplit/readwritesplit.cc:1226
      2018-04-05 23:18:47   alert  : (3725012)   /usr/lib64/maxscale/libmariadbbackend.so(+0x3bcb) [0x7f843c253bcb]: /home/vagrant/MaxScale/server/modules/protocol/MySQL/mariadbbackend/mysql_backend.c:980
      2018-04-05 23:18:47   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x5398e) [0x7f84426da98e]: ??:0
      2018-04-05 23:18:48   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x53b58) [0x7f84426dab58]: ??:0
      2018-04-05 23:18:49   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker15poll_waiteventsEv+0x21b) [0x7f844271363b]: ??:0
      2018-04-05 23:18:50   alert  : (3725012)   /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN8maxscale6Worker3runEv+0x121) [0x7f8442713911]: ??:0
      2018-04-05 23:18:50   alert  : (3725012)   /lib64/libpthread.so.0() [0x3983407aa1]: ??:0
      2018-04-05 23:18:51   alert  : (3725012)   /lib64/libc.so.6(clone+0x6d) [0x39830e8bcd]: ??:0
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            rpizzi Rick Pizzi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.