[fpc-pascal] Stuck in TMSSQLConnection.Execute

[Luca Olivetti]

El 6/5/26 a les 12:02, michael via fpc-pascal ha escrit:

Thank you, no, that's not the problem (each thread uses its own 
connection), see my other reply.

Bye

> 
> Are you using 1 connection per thread ? If not, then that may be your 
> problem.
> 
> Michael.
> 
> On 2026-05-06 10:55, Luca Olivetti via fpc-pascal wrote:
>> Hello,
>>
>> I encountered a strange problem in an application, that's been running 
>> for over a year now.
>> The application is quite convoluted with hundred of threads, one 
>> (actually more than one) of those threads connects to an ms sql server 
>> and now it blocks inside TMSSQLConnection.Execute, but not always
>>
>>
>> procedure TMSSQLConnection.Execute(const cmd: string);
>> begin
>>   DBErrorStr:='';
>>   DBMsgStr  :='';
>>   CheckError( dbcmd(FDBProc, PAnsiChar(cmd)) );
>>   CheckError( dbsqlexec(FDBProc) );  <--- this doesn't return
>>   CheckError( dbresults(FDBProc) );
>> end;
>>
>>
>> However when I terminate the application and before the destroy method 
>> of the thread is called, dbsqlexec returns and the rest of the thread 
>> goes on as nothing happened.
>>
>> As an experiment I wrapped the method in synchronize but that only 
>> freezes the gui when it happens.
>>
>> I don't know it if is relevant but I have a note in my program that I 
>> have to initialize the sql server libraries in the main thread, 
>> otherwise doing it in another thread eventually causes a sigsev.
>>
>> I got the dlls (almost 2 years ago) following the instructions here
>>
>> https://forum.lazarus.freepascal.org/index.php/ 
>> topic,55037.msg409167.html#msg409167
>>
>> using Environment: PLAT=Win32, WIDTH=32, VS_VERSION=2017, TDSVER=7.3
>> (though older artifacts are deleted after a month)
>>
>> This is on windows 32 bits, fpc 3.2.2, any hint on how to debug it 
>> further?
>>
>> Bye
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal