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