[MDEV-12220] MariaDB crashes querying CONNECT/ODBC tables Created: 2017-03-09  Updated: 2017-03-18  Resolved: 2017-03-18

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows, Storage Engine - Connect
Affects Version/s: 10.1.21
Fix Version/s: 10.1.23, 10.2.5, 10.3.0, 10.0.31

Type: Bug Priority: Critical
Reporter: Lex Collige Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 2008R2, Guru ODBC

Attachments: Text File describe.txt     Text File dropprimarykey.txt     Text File mariadb-crash.txt     File my.ini     Text File mysql_session.txt     Text File showcreate.txt    

 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.

 Comments   
Comment by Olivier Bertrand [ 2017-03-12 ]

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.

Comment by Olivier Bertrand [ 2017-03-13 ]

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

Comment by Lex Collige [ 2017-03-13 ]

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

Comment by Lex Collige [ 2017-03-16 ]

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

dropprimarykey.txt

Comment by Olivier Bertrand [ 2017-03-17 ]

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.

Comment by Olivier Bertrand [ 2017-03-18 ]

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

Generated at Thu Feb 08 07:56:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.