Bug 132916 - MariaDB/MySQL - ODBC: Trying to create a query leads immediately to crash from LO
Summary: MariaDB/MySQL - ODBC: Trying to create a query leads immediately to crash fro...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: wantBacktrace
Depends on:
Blocks:
 
Reported: 2020-05-10 13:14 UTC by Robert Großkopf
Modified: 2020-05-10 17:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-05-10 13:14:55 UTC
Have a connection to MariaDB with ODBC.
Start "Create Query in Design View ..." or "Create Query in SQL View ..." or "Use Wizard to Create a Query ..."
Whole LO crashes immediately.

Got this first with LO 6.4.3.2 on OpenSUSE 15.1 64bit rpm Linux. Then tested it with LO 6.1.5.2 on the same system - same behavior. LO 6.4.4.1 - same behavior. Reset the user-folder of LO by renaming "4" to "4_alt" - same behavior.

It is impossible to create a query in LO for MariaDB connected by ODBC.
Comment 1 Julien Nabet 2020-05-10 15:51:14 UTC
On pc Debian testing x86-64 with master sources updated today, I don't reproduce this.
I use:
Package: odbc-mariadb
Source: mariadb-connector-odbc
Version: 3.1.4-1
Installed-Size: 347
Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>
Architecture: amd64

[MariaDB]
Description=MariaDB
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so

[bug_132916]
Description=MariaDB_desc
Driver=MariaDB
SERVER=localhost
USER=julien
PASSWORD=XXXXX
DATABASE=test
PORT=3306

No crash too with LO Debian package 6.4.3.2

What odbc driver do you use and which version is it?
Would it be possible to retrieve a backtrace?
Anything on console? errors, warnings, traces
Comment 2 Robert Großkopf 2020-05-10 16:31:04 UTC
(In reply to Julien Nabet from comment #1)
Hi Julien,

> Package: odbc-mariadb
> Source: mariadb-connector-odbc
> Version: 3.1.4-1

I had installed the normal version for OpenSUSE 15.1 - 3.0.2
As I got your respond I updated to the experimental Server-version 3.1.7 .
No I could open the editor for queries.

Seems to be not our bug, but I'm interested what Base talks to the driver while only opening such a editor ...

I will set this bug to "NOTOURBUG"
Comment 3 Julien Nabet 2020-05-10 17:38:23 UTC
(In reply to Robert Großkopf from comment #2)
> (In reply to Julien Nabet from comment #1)
> Hi Julien,
> 
> > Package: odbc-mariadb
> > Source: mariadb-connector-odbc
> > Version: 3.1.4-1
> 
> I had installed the normal version for OpenSUSE 15.1 - 3.0.2
> As I got your respond I updated to the experimental Server-version 3.1.7 .
> No I could open the editor for queries.
> 
> Seems to be not our bug, but I'm interested what Base talks to the driver
> while only opening such a editor ...
> 
> I will set this bug to "NOTOURBUG"

The backtrace may help to find the relation.
If you got time/feel like, you can reinstall previous version to get a backtrace.