Bug 139165 - View Relationships: MSSQL via ODBC: Crash in: rtl_uString2String
Summary: View Relationships: MSSQL via ODBC: Crash in: rtl_uString2String
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-22 17:20 UTC by Jay Fude
Modified: 2023-12-04 20:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature: ["rtl_uString2String"]


Attachments
SQL of Database schema. (666.49 KB, application/octet-stream)
2020-12-29 17:29 UTC, Jay Fude
Details
Screenshot of ODBC driver (5.71 KB, image/png)
2021-04-21 12:13 UTC, Jay Fude
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jay Fude 2020-12-22 17:20:12 UTC
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.
Comment 1 Roman Kuznetsov 2020-12-24 19:30:13 UTC
Jay, can you create an example of MSSQL database with only some table and with small size and then attach it here?
Comment 2 Jay Fude 2020-12-29 17:29:57 UTC
Created attachment 168558 [details]
SQL of Database schema.

SQL schema of database from MS SQL Server Studio V 18.6
Comment 3 QA Administrators 2020-12-30 03:39:57 UTC Comment hidden (obsolete)
Comment 4 Alex Thurgood 2021-04-21 10:18:18 UTC
@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 ?
Comment 5 Jay Fude 2021-04-21 12:12:32 UTC
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.
Comment 6 Jay Fude 2021-04-21 12:13:29 UTC
Created attachment 171331 [details]
Screenshot of ODBC driver
Comment 7 Alex Thurgood 2021-04-21 17:06:38 UTC
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.
Comment 8 Jay Fude 2021-04-21 17:15:38 UTC
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.
Comment 9 Roman Kuznetsov 2023-05-09 10:27:24 UTC
Jay, do you have the bug now in current LibreOffice version?
Comment 10 QA Administrators 2023-11-06 03:13:26 UTC
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
Comment 11 Eyal Rozenberg 2023-12-04 20:53:47 UTC
Just to clarify - this bug is _not_ about right-to-left, and the rtl_ prefix stands for the runtime library, IIANM.