This bug was filed from the crash reporting server and is br-c16fc501-2ff2-4545-bf6f-00b3c0fbf167. ========================================= Open MSSQL database, using username/password, test good via ODBC. Can view tables, etc. Click Tools, Relationships: Result is crash. Win 10 and Fedora 32/33. Database is 663M with many tables.
Jay, can you create an example of MSSQL database with only some table and with small size and then attach it here?
Created attachment 168558 [details] SQL of Database schema. SQL schema of database from MS SQL Server Studio V 18.6
[Automated Action] NeedInfo-To-Unconfirmed
@Jay : is this a 32bit ODBC driver you are using with 64bit LO ? I would have thought that a 32bit ODBC driver would not provide exactly the same data structure as a 64bit driver ? You also mention that you tested with Fedora 32/33, but the crash report is from a Windows client ?
Yes, the computer I reported from was the windows 10 mentioned in the original message, then followed by the word AND, meaning I did not file a separate bug from the Fedora box, but that I had ALSO tried using a Fedora machine, eliminating the possibility that it was limited to, or only present on one OS, hopefully reducing the troubleshooting steps by doing some experimenting on my side. I also tried two separate Fedora machines I had available, one running 32, the other 33. I suppose I could move the SQL file to one of my home computers and try it on Ubuntu and CentOS... The ODBC is a 64 bit driver, V. 17 for SQL Server, from Microsoft found here: https://www.microsoft.com/en-us/download/details.aspx?id=56567 I attached screenshot of said driver.
Created attachment 171331 [details] Screenshot of ODBC driver
Thanks Jay. What is strange then is that the crash report states that the following calls are being made : odbc32.dll 0x29711 odbc32.dll 0x27903 odbc32.dll 0x5c1f1 so where is this 32bit ODBC driver being called from ? I would have thought that compile time when building LO for release on cygwin used 64bit ODBC dll, but perhaps I'm wrong. Anyway, aside from that, I'm going to link this to a similar one I have encountered with listing relationships on a mysql instance (albeit using the native mysql connecter C driver). Unfortunately, that one is rather longstanding, so if that one is anything to go by, sorting your issue out, even confirming it, might take a while, as not everyone that helps out in QA has access to a mssql server instance.
No worries. I was hoping to look into a backup made from our *wonderful* program that uses a SQL database to store all of our data, so I could export it and import into whatever we get to replace this one with. I wish it wasn't full of sensitive to our business data, or I would attempt to attach the SQL file directly, to help troubleshoot this. I'm not sure where the call is being made, I'm using the 64 bit driver, on 64 bit systems... I haven't tried opening it since Libreoffice has updated to 7.1.2.2 It only happens if I want to look at relationships. *Update* Connected to the database with 7.1.2.2, and did not crash or get the error, using Windows 10. I will try with Fedora. Something has changed.
Jay, do you have the bug now in current LibreOffice version?
Dear Jay Fude, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Just to clarify - this bug is _not_ about right-to-left, and the rtl_ prefix stands for the runtime library, IIANM.
Dear Jay Fude, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp