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

MariaDB crashes querying CONNECT/ODBC tables

Details

    Description

      I am trying to use MariaDB to expose data from a legacy system (Guru) in order to eventually migrate to something built with MariaDB. DELETE queries seem to always cause a crash, and some UPDATE queries do as well. A query that causes a crash seems to reliably cause crashes.

      I have attached the relevant section of the error log, my configuration file, and the schema of the table involved in this query. I had a quick look at OpenDB() in tabodbc.cpp, but didn't get much past comments.

      Attachments

        1. describe.txt
          1 kB
          Lex Collige
        2. dropprimarykey.txt
          3 kB
          Lex Collige
        3. mariadb-crash.txt
          5 kB
          Lex Collige
        4. my.ini
          0.3 kB
          Lex Collige
        5. mysql_session.txt
          1 kB
          Lex Collige
        6. showcreate.txt
          1 kB
          Lex Collige

        Activity

          Ascending order - Click to sort in descending order
          bertrandop Olivier Bertrand added a comment -

          The problem is that the source files on my machine have been updated for new versions. Therefore, the line numbers in your crash file do not match (in the current version line 877 of tabodbc.cpp is not even in the OpenDB function)
          For me to check where the crash occured, could you attach the three source files ha_connect.cc, connect.cc and tabodbc.cpp.
          Thanks.

          bertrandop Olivier Bertrand added a comment - The problem is that the source files on my machine have been updated for new versions. Therefore, the line numbers in your crash file do not match (in the current version line 877 of tabodbc.cpp is not even in the OpenDB function) For me to check where the crash occured, could you attach the three source files ha_connect.cc, connect.cc and tabodbc.cpp. Thanks.
          bertrandop Olivier Bertrand added a comment -

          Also please show the detailed session that crashes. Create table and delete statements.

          bertrandop Olivier Bertrand added a comment - Also please show the detailed session that crashes. Create table and delete statements.
          LCollige Lex Collige added a comment -

          This was set up using the binary installer (mariadb-10.1.21-win32.msi) from https://downloads.mariadb.org/mariadb/10.1.21/ so I don't think I have the source files. I have attached the text of a session where this crash occurs.

          mysql_session.txt

          LCollige Lex Collige added a comment - This was set up using the binary installer (mariadb-10.1.21-win32.msi) from https://downloads.mariadb.org/mariadb/10.1.21/ so I don't think I have the source files. I have attached the text of a session where this crash occurs. mysql_session.txt
          LCollige Lex Collige added a comment -

          Removing the primary key from this table seems to have resolved the server crash.

          dropprimarykey.txt

          LCollige Lex Collige added a comment - Removing the primary key from this table seems to have resolved the server crash. dropprimarykey.txt
          bertrandop Olivier Bertrand added a comment -

          There is a bug indeed causing crashes when doing UPDATE or DELETE with a where clause on an indexed column. Almost fixed, will be pushed on next releases.

          bertrandop Olivier Bertrand added a comment - There is a bug indeed causing crashes when doing UPDATE or DELETE with a where clause on an indexed column. Almost fixed, will be pushed on next releases.
          bertrandop Olivier Bertrand added a comment - - edited

          FIX: Indexing must be ignored by CONNECT when doing UPDATE or DELETE.

          bertrandop Olivier Bertrand added a comment - - edited FIX: Indexing must be ignored by CONNECT when doing UPDATE or DELETE.

          People

            bertrandop Olivier Bertrand
            LCollige Lex Collige
            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.