Solved TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Report SqlBase bugs and possible workarounds.
EWetzel
Germany
Posts: 262
Joined: 07 Mar 2017, 12:08
Location: Germany

TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by EWetzel » 03 Jan 2015, 13:40

Hi,

with 6.2 SP3 comes a new (for me mystery) bug.

In dependency from some rules SqlFetchNext crashes on fetching Binary Data from SQLBase from a Long Varchar Column into a Variable from Datatype Binary.

The rules:
1. before SqlFetchNext is called the function "MImgLoadFromFileInfo" must be called
(this is a function from Michael Stoll (MImage / MTable), maybe he can also help)
2. The Bufferlength of the Binarydata must be > 0
3. The SELECT Statement must contain another Long Varchar Column with Text

I attached a Sample App.

Important: My Sample App works with every other Version of 6.2 (SP1, SP2 UPD2, ...)
binarytestcrash.jpg
best regards
Enrico
You do not have the required permissions to view the files attached to this post.

EWetzel
Germany
Posts: 262
Joined: 07 Mar 2017, 12:08
Location: Germany

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by EWetzel » 13 Jan 2015, 08:43

Hi,

can anyone from Gupta confirm this issue?

It is definitely new with SP3.
It cost me 3 days to analyze this problem.

Enrico

VEspinal

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by VEspinal » 14 Jan 2015, 19:32

Hi:

It is working for me.

Please see attached video and let me know if I am missing anything on your reprocase.

Thanks,
Victor Espinal
You do not have the required permissions to view the files attached to this post.

EWetzel
Germany
Posts: 262
Joined: 07 Mar 2017, 12:08
Location: Germany

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by EWetzel » 14 Jan 2015, 21:08

Hi,

thank you for the test.

Which OS do you use.
I use Windows 7 Ultimate 64 bit.

Can you please make an exe file and test again.

Enrico

VEspinal

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by VEspinal » 14 Jan 2015, 22:06

You are welcome Enrico.

I use Windows 7 Professional 64 bit.

Created the .exe and got same results.

Thanks
Victor

EWetzel
Germany
Posts: 262
Joined: 07 Mar 2017, 12:08
Location: Germany

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by EWetzel » 03 Apr 2015, 18:49

Hi,

Now with TD6.3 the situation is worse.

Please, can someone test my new sample (only Sal Code) with TD 6.3.

Step 2 ("MImgLoadFromFileInfo") is no longer necessary!

I tested on Windows 7 64 Bit and Windows 8.1 64 Bit.

Enrico
You do not have the required permissions to view the files attached to this post.

Igor Ivanovic
Site Admin
Site Admin
Croatia
Posts: 1420
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by Igor Ivanovic » 04 Apr 2015, 08:47

Enrico,

I've got the same crash on win 10 64bit.
Igor Ivanovic
Image

Jean-Marc Gemperle

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by Jean-Marc Gemperle » 08 Apr 2015, 14:08

Hi

I get the crash win8 64bit TD 6.3 OK with 6.2
See video
Thanks for the testcase

Cheers
JM

TD-21984
SQLBASE SqlFetchNext Fetching Binary Data crash
You do not have the required permissions to view the files attached to this post.

EWetzel
Germany
Posts: 262
Joined: 07 Mar 2017, 12:08
Location: Germany

Re: TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

Post by EWetzel » 08 Apr 2015, 14:37

Hi,

Thank you for the Investigation.

After my tests I know:
On TD 6.3 it happens permanent
On TD 6.2 It happens sporadically
(Until TD 6.2 SP2 UPD2 42744 there was no issue)

Maybe, after found out the Problem on TD 6.3 the developer has any idea what could be the Problem on TD 6.2.
(Memory leak?)

Enrico

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests