[Firebird-devel] Timeout on batch

2022-01-05 Thread Jiří Činčura
Hi *, Is there a way to send timeout value for batch, same way it's now possible for single statements (op_execute/op_execute2)? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Commit (un)certainity

2022-01-05 Thread Dimitry Sibiryakov
Hello All. It is documented that successful return from function send() for TCP doesn't mean successful delivery of data to the target host, mere put them into socket buffer. If op_commit is sent but network error appear during waiting for response there can be two cases: 1) op_commit

[Firebird-devel] Commit (un)certainity

2022-01-05 Thread Dimitry Sibiryakov
Hello All. It is documented that successful return from function send() for TCP doesn't mean successful delivery of data to the target host, mere put them into socket buffer. If op_commit is sent but network error appear during waiting for response there can be two cases: 1) op_commit

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Jiří Činčura
One way to handle this is via manual inserts (and deletes) in a dedicated table. Something like: 1. Insert a row into the table at the beginning of each transaction. 2. If the connection fails during the commit, check for the presence of the corresponding row in the database. - If the row is pre

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Vlad Khorsun
05.01.2022 15:03, Dimitry Sibiryakov wrote:   Hello All.   It is documented that successful return from function send() for TCP doesn't mean successful delivery of data to the target host, mere put them into socket buffer.   If op_commit is sent but network error appear during waiting for r

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Dimitry Sibiryakov
Jiří Činčura wrote 05.01.2022 19:44: You're probably thinking about something in client library? Yes. You probably have the same problem in your provider, no? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Adriano dos Santos Fernandes
Em qua., 5 de jan. de 2022 17:14, Dimitry Sibiryakov escreveu: > Jiří Činčura wrote 05.01.2022 19:44: > > You're probably thinking about something in client library? > >Yes. You probably have the same problem in your provider, no? If no response or network error is returned, application wil

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Jiří Činčura
>Yes. You probably have the same problem in your provider, no? The problem exists there. Same as with fbclient. But I don't explicitly solve it, application developer is responsible for handling such scenario (if ever). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel

[Firebird-devel] ExprNode::FLAG_VALUE

2022-01-05 Thread Adriano dos Santos Fernandes
Hi! There is ExprNode::FLAG_VALUE ("Full value area required in impure space"), inherited from old (2.5) code base nod_value. It's set by sort subsystem and used only for parameters and variables. It makes then allocate impure space for impure_value_ex instead of traditional dsc. Most nodes all