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
Crash on big MS SqlServer commands
Re: Crash on big MS SqlServer commands
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
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
Georg Diczig
Re: Crash on big MS SqlServer commands
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.
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
Palm Springs, California
Re: Crash on big MS SqlServer commands
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...
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...
Yes, I will investigate that and open a new thread.Georg - NTDLL.DLL is a separate issue
Best Regards
Georg Diczig
Georg Diczig
Re: Crash on big MS SqlServer commands
Hi Jeff,
did you try the testcase I've sent you? Can you reproduce the crash with this example?
Nils
did you try the testcase I've sent you? Can you reproduce the crash with this example?
Nils
Re: Crash on big MS SqlServer commands
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
Palm Springs, California
Who is online
Users browsing this forum: [Ccbot], huemerjo and 0 guests