Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3393

LP:1007622 - Server crashes in handler::increment_statistics on inserting into a view

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      #4 <signal handler called>
      #5 0x081ed089 in handler::increment_statistics (this=0x946eca0,
      offset=&system_status_var::ha_write_count) at sql_class.h:3645
      #6 0x0843b610 in handler::ha_write_row (this=0x946eca0, buf=0x946c1f8 "\377")
      at handler.cc:4939
      #7 0x0838d8ee in write_record (thd=0x93ef128, table=0x946e108, info=0xae978628)
      at sql_insert.cc:1692
      #8 0x0838b958 in mysql_insert (thd=0x93ef128, table_list=0x9487578, fields=...,
      values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR,
      ignore=false) at sql_insert.cc:887
      #9 0x082e66b6 in mysql_execute_command (thd=0x93ef128) at sql_parse.cc:3233
      #10 0x082eef92 in mysql_parse (thd=0x93ef128,
      rawbuf=0x94874c8 "INSERT INTO v2 (a) VALUES (1)", length=29,
      found_semicolon=0xae979234) at sql_parse.cc:6153
      #11 0x082e1955 in dispatch_command (command=COM_QUERY, thd=0x93ef128,
      packet=0x9446341 "INSERT INTO v2 (a) VALUES (1) ", packet_length=30)
      at sql_parse.cc:1228
      #12 0x082e0dff in do_command (thd=0x93ef128) at sql_parse.cc:923
      #13 0x082ddcf5 in handle_one_connection (arg=0x93ef128) at sql_connect.cc:1218
      #14 0xb778eb25 in start_thread () from /lib/libpthread.so.0

      bzr version-info
      revision-id: <email address hidden>
      date: 2012-06-01 14:56:47 +0200
      build-date: 2012-06-02 01:57:21 +0400
      revno: 3536

      Also reproducible on maria-5.5 revno 3425.
      Could not reproduce on maria-5.2, mysql-5.1, mysql-5.5, mysql-trunk.
      Reproducible with MyISAM, Aria, InnoDB.
      Reproducible with default optimizer_switch as well as with all OFF values.

      1. Test case:

      CREATE TABLE t1 (a INT);
      CREATE ALGORITHM=MERGE VIEW v1 AS SELECT a1.* FROM t1 AS a1, t1 AS a2;
      CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM v1;
      INSERT INTO v2 (a) VALUES (1) ;

      1. End of test case

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.