Description: LO Base hangs on VIEWING data from a specific table in MariaDB. Steps to Reproduce: 1. Logon to database 2. Open small table: OK 3. Open edit of bigger table (35 columns, 400 rows): colum definitions are shown 4. Open this table for data Opening a form to view the data has the same problem. Actual Results: LO Base hangs Expected Results: The tabledata Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Versie: 6.4.6.2 Build ID: 1:6.4.6-0ubuntu0.20.04.1 CPU-threads: 4; Besturingssysteem: Linux 5.4; UI-render: standaard; VCL: gtk3; Locale: nl-NL (nl_NL.UTF-8); UI-taal: nl-NL Calc: threaded Database: MariaDB on Synology
Long ago under win7 I solved a problem with base by deleting the library files. I tried it and it also solved this problem. Maybe you should not register (external) databases.
How do you connect to the database? Database is on a NAS, not on an external Server?
A couple of days after deleting the library the problem is back. MariaDB is hosted on Synology DS218. I had the same problem on one of my Win7 machines and never solved it. On Linux it worked for nearly a year.
Connection is made via MySQL / Direct
Could it be it is something bug 83999 ? I know JDBC isn't as fast as the direct connection with MariaDB. But it will import data like shown in bug 83999 directly …
I doubt, I had the same problem with Win7. As it took too much time searching for a solution I changed to Lazarus as DB-frontend, both on Win7 as Linux. More effort but also more reliable and flexible. I propose to close this bug report.
(In reply to bugzilla@htbes.nl from comment #6) > > I propose to close this bug report. I will close this bug as WORKSFORME.