Bug 148964

Summary: Connections to existing MariaDB databases no longer show tables
Product: LibreOffice Reporter: libreoffice
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: buzea.bogdan, libreoffice
Priority: medium    
Version: 7.3.1.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

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!!