Bug 148964 - Connections to existing MariaDB databases no longer show tables
Summary: Connections to existing MariaDB databases no longer show tables
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-06 11:31 UTC by libreoffice
Modified: 2022-05-07 06:47 UTC (History)
2 users (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 libreoffice 2022-05-06 11:31:41 UTC
Description:
In Calc I have spreadsheets with pivot tables accessing a data connection to a MariaDB database. In the base database no tables are shown. 

Opening the existing Calc file shows an information field: /build/libreoffice-fresh/src/libreoffice-7.3.3.2/connectivity/source/drivers/odbc/OTools.cxx:325 about 15 times before the file opens. 

The pivot is not upgradable because of lost tables. 

In the Base file the tables are no longer present.

With a new base file it is the same result with no tables of external database. 

Steps to Reproduce:
Steps to Reproduce for opening file: 
No tables shown

Steps to Reproduce for new database:
1. File / New / Database
2. Connect to an existing Database / ODBC or MySQL
3.1 Select ODBC Source or MySQL with ODBC(UnixODCB Connection with isql has success)
3.2 Direct Connection database, server, port
4. Type in the user name, check "Password required", press "Test Connection" and type the password
5. Wizzard reports success
6. No tables shown


Actual Results:
In existing and in new created base databases the tables of connected MariaDB database are no longer shown.
My postgresql connection shows tables as expected. 

Expected Results:
show the tables of the existing MariaDB Database like in isql of unixODBC


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.3.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
7.3.3-1
Calc: threaded
Comment 1 libreoffice 2022-05-06 12:36:23 UTC
As restart of MariaDB does not resolve the problem. 
As a last try I restarted the complete server. Now it is possible to see the tables. 

Sorry!!