update statement is getting stuck on firebird 5.0

[Shay Ophir]

Hello,
I am using firebird 5.0  on windows SuperClassic mode.
After upgrading from version 2.5 to 5.0 I have cases when prepare   update statement is getting stuck and not response.
I have attached call stack from dump files.
I will appreciate  your help.

Thanks 

[Jiří Činčura]

Provide a repro.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

> --
> You received this message because you are subscribed to the Google
> Groups "firebird-net-provider" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to firebird-net-pro...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/firebird-net-provider/bafebf73-bbc1-437a-ac5c-f8cd929724ban%40googlegroups.com
> <https://groups.google.com/d/msgid/firebird-net-provider/bafebf73-bbc1-437a-ac5c-f8cd929724ban%40googlegroups.com?utm_medium=email&utm_source=footer>.
> Attachments:
> * Screenshot 2024-12-25 2045161.png

[Shay Ophir]

Thanks to your reply.

what do you mean by repro?

The problem happens randomly not every time on class  FesStatement 

line 231_db.FbClient.isc_dsql_prepare(_statusVector, ref trHandle, ref _handle, (short)bytes.Length, bytes, _db.Dialect, pNativeData);

Thanks

[Jiří Činčura]

> what do you mean by repro?

Piece of code that shows the undesired behavior.

> The problem happens randomly not every time on class FesStatement

That means I need repro even more.

[Shay Ophir]

Hello and many thanks for your help.

I have attached the code as a text file.

The code is getting stuck on line 122 "adapter.Update(_table);"

I really appreciate your help. We don't understand the problem here and we haven't even succeeded in raising the DB logs level in order to investigate it.

Thanks

--
You received this message because you are subscribed to the Google Groups "firebird-net-provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-net-pro...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/firebird-net-provider/fa64d8ab-33f5-4128-9b13-66ad2ad959c4%40app.fastmail.com.

[Jiří Činčura]

This is not a repro, because I can't execute the code.

[Shay Ophir]

I is very difficult to reproduce it.

Can give me hints how can I investigate it?

How can I debug it?

How can I enable FB logs on windows and SuperClassic mode?

Thanks