Crash on big MS SqlServer commands

General discussion forum about all databases other than SqlBase.
Nils Jänicke
Germany
Posts: 423
Joined: 20 Sep 2017, 11:56
Location: Villingen-Schwenningen, Germany

Crash on big MS SqlServer commands

Post by Nils Jänicke » 07 Dec 2012, 12:34

Hi,

we have analyzed a increasing no. of application crashes reported from our users with MS SQL-Server databases and have a strong suspicion that we have found a serious memory problem with the ODBC routers.

It seems that TD has a problem fireing multiple big SQL commands. If one of the SQL command has a larger length as the previous commands of other open SQL handles, the SalPrepare command crashes. I've made a test case, I will send it by PM to Jeff and Ana to analyze (it is big because I needed a SQL server database and the crashing application is not very small).
Unfortunately the crash is not fully reproduceable, sometimes it runs well, sometimes it crashes after about 6 Sql Insert command, sometimes only 4, one attempt causes into a "Out of Memory" message on sqlODBC.dll, another attempt I've got an error 1915 at the SqlConnect command (01915 SYS OOM Out of memory when encrypting/decrypting data, Reason: The OS has refused a necessary memory allocation., Remedy: A secure encryption/decryption operation could not proceed.) but in most cases it crashes after the 6th loop over the Prepare of the INSERT command.

We suggest regarding this as critical because of the impact on apps running on MS SQL-Server databases - the routers are not as stable as they should be.
Not beeing able to make a workaround for this we have to rely on a bugfix as a help for our customers.

Best regards
Nils

Georg Diczig
Germany
Posts: 175
Joined: 15 Mar 2017, 15:15
Location: Cologne Germany

Re: Crash on big MS SqlServer commands

Post by Georg Diczig » 10 Dec 2012, 10:18

Hi Nils,

we have also a lot of crashes in environments using the ODBC drivers for MS SQL Server.
Dr. Watson reports often crashes in ntdll!RtlCreateUnicodeStringFromAsciiz but we never call this ntdll function from our TD sources.

Nils, could you contact me by a privat mail?

Thanks
Georg
Best Regards
Georg Diczig

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2385
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: Crash on big MS SqlServer commands

Post by Jeff Luther » 11 Dec 2012, 00:40

Georg - NTDLL.DLL is a separate issue and is a Windows' DLL: http://pcsupport.about.com/od/fixthepro ... dlldll.htm

Do a search for this DLL name here on the forum, because a number of users have reported problems with this in the past. As I recall, most often the problem was due to the DLL not being the latest one.
Jeff Luther @ PC Design
Palm Springs, California

Georg Diczig
Germany
Posts: 175
Joined: 15 Mar 2017, 15:15
Location: Cologne Germany

Re: Crash on big MS SqlServer commands

Post by Georg Diczig » 11 Dec 2012, 10:29

Hi Jeff,

the problem is that we do not reference ntdll.dll as an external library. But of course it is referenced by kernel32 that is referenced by many of the TD dll's. Just run the dependency walker for a exe builded with TD.
The fault in RtlCreateUnicodeStringFromAsciiz makes me feel that it is a unicode issue. On the other hand we do not deal with any unicode - ascii transformations...
Georg - NTDLL.DLL is a separate issue
Yes, I will investigate that and open a new thread.
Best Regards
Georg Diczig

Nils Jänicke
Germany
Posts: 423
Joined: 20 Sep 2017, 11:56
Location: Villingen-Schwenningen, Germany

Re: Crash on big MS SqlServer commands

Post by Nils Jänicke » 17 Dec 2012, 07:18

Hi Jeff,

did you try the testcase I've sent you? Can you reproduce the crash with this example?

Nils

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2385
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: Crash on big MS SqlServer commands

Post by Jeff Luther » 17 Dec 2012, 20:01

Nils -- I replied to you directly -- but thanks for the reminder as I see I didn't include you in the emails to: list :( I've just forwarded the msg. to you.
Jeff Luther @ PC Design
Palm Springs, California

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot], huemerjo and 0 guests