[firebird-support] FB 2.1 transaction question

2019-05-17 Thread Rustam rusta...@ukr.net [firebird-support]
Sometimes our application works from remote place via VPN over wireless Internet connection. Often connections brakes and we have active DB connections in MON$ATTACHMENTS for a long time and their TA's blocks further work. Is this same case as in your reply? At least we receive an errors in

Re: [firebird-support] FB 2.1 transaction question

2019-05-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, May 13, 2019 at 5:08 AM Rustam rusta...@ukr.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Important notice: modified rows in that 'dead' transaction remains locked > along this TA existence. So, your another connections will get 'lock > conflict' errors ('no

[firebird-support] FB 2.1 transaction question

2019-05-13 Thread Rustam rusta...@ukr.net [firebird-support]
Important notice: modified rows in that 'dead' transaction remains locked along this TA existence. So, your another connections will get 'lock conflict' errors ('no wait' TA's), or waiting forever ('wait' TA's) when try to modify same rows. Even if you just want reconnect on unexpected

Re: [firebird-support] FB 2.1 transaction question

2019-05-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 10-5-2019 08:18, Fulvio Senore mail...@fsoft.it [firebird-support] wrote: > > > Il 09/05/2019 18:01, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] ha scritto: >>> I have a program that uses Firebird 2.1. Most installation use the >>> embedded version so I prefer to stick with

Re: [firebird-support] FB 2.1 transaction question

2019-05-10 Thread Fulvio Senore mail...@fsoft.it [firebird-support]
Il 09/05/2019 18:01, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] ha scritto: >> I have a program that uses Firebird 2.1. Most installation use the >> embedded version so I prefer to stick with 2.1 since it does all I need. >> >> I have a question about transactions: if I start

Re: [firebird-support] FB 2.1 transaction question

2019-05-09 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> I have a program that uses Firebird 2.1. Most installation use the > embedded version so I prefer to stick with 2.1 since it does all I need. > > I have a question about transactions: if I start a transaction, I add or > modify some data, then the program gets an exception and it crashes, >

[firebird-support] FB 2.1 transaction question

2019-05-09 Thread Fulvio Senore mail...@fsoft.it [firebird-support]
I have a program that uses Firebird 2.1. Most installation use the embedded version so I prefer to stick with 2.1 since it does all I need. I have a question about transactions: if I start a transaction, I add or modify some data, then the program gets an exception and it crashes, what happens