Recently released LibreOffice 18.104.22.168 crashes on opening some or navigating in some other forms that I have in a ODB file, which is connected to a MySQL database using MySQL Connector/ODBC 5.3.9 on Windows 7 x64. I'm using this ODB file almost on a daily basis and had no problems with LibreOffice 5.4.2 and the same connector. LibreOffice itself already generated several bug reports the last one of which could be found at http://crashreport.libreoffice.org/stats/crash_details/9c7873bf-7db7-4c1a-bb94-db8222f4eaf9 (from 8 minutes ago). Please, let me know what other information I need to provide and I hope this is fixed soon.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Should I also provide the related MySQL schema?
Strange enough I'm not able to reproduce the issue with a newly defined Data Source used in a new document connecting also with MyODBC 5.3.9, but to a different (example) schema. I noticed that when trying to reconfigure the previously defined Data Source (used by the document that fails) in ODBC Data Source Administrator I get the message "Failure to lookup driver entry at path 'C:\Program Files\MySQL\Connector ODBC 5.3\myodbc5w.dll'". It seems that for some unknown reason the installation path for MySQL ODBC has changed. I'll try to create new data source and use it and would report back whether this solves my problem or not.
Unfortunately, defining a new data source and using it in the database document does not solve my problem. I still get the same error in the error report (see newly generated crash report at crashreport.libreoffice.org/stats/crash_details/b149a991-e7df-4184-a79c-f623f1e96aff ). Should I provide the original form that fails, because apparently creating a new one as example is working fine as I reported previously?
Yes, please, provide everything needed in order to reproduce the crash.
Created attachment 138039 [details]
Example SQL script
Created attachment 138040 [details]
Example DB file
I have just attached example SQL script for creation of the schema with a single table and a DB file with the original form that fails on navigating through the records of this table (which in reality has about 1200 records). Unfortunately, the problem doesn't reproduce like this and there is no crash on navigating the records, so I'm really not sure how to provide an example that demonstrates the crash. It only seem to happen with my existing DB file. Any clues from the crash report about the nature of the problem, so I could try providing reproducible example?
Whatever the reason for the problem I reported in this bug it does not exist in LibreOffice 22.214.171.124 (x64). I just downgraded to this version and everything is fine with the same DB file and same MySQL ODBC Connector without even restarting Windows. How could I contributed further for the identification of the issue given I'm not able to provide reproducible document and not able to share the document I used internally in my organization?
Any help anyone?
I guess it's a duplicate of bug 114495 and it should be fixed in LibreOffice 6.0 or 5.4
*** This bug has been marked as a duplicate of bug 114495 ***