[firebird-support] Deadlock

The following procedure causes a deadlock when the user on the web page navigates rapidly through a javascript object on the web page. Please give me some advice on how best to deal with this. I've thought about changing it using DATEDIFF so they update only once a minute, but I would apprecia

[firebird-support] deadlock

Hello @ll, at the moment, we have some problems with deadlock-messages, Firebird 3.01.32531. gstat-h C:\Programme\firebird\Firebird_3_0>gstat -h d:\interbase\ifls.gdb Database "D:\INTERBASE\IFLS.GDB" Database header page information: Flags 0 Gen

[firebird-support] Deadlock Troubleshooting.

Hi, I'm running Firebird 2.5.1. Clients are written in Delphi, connect using FIBPlus. All SELECT statements are running under transactions with parameters:READ_COMMITTED | REC_VERSION | NOWAIT | READ_ONLY. All UPDATES/DELETES/INSERTS are running under transactions with parameters:READ_COMMITTED

Re: [firebird-support] Deadlock

> The following procedure causes a deadlock when the user on the web page > navigates rapidly through a javascript object on the web page. Please > give me some advice on how best to deal with this. I've thought about > changing it using DATEDIFF so they update only once a minute, but I > would a

Re: [firebird-support] Deadlock

Session login is is unique between logins, but will be reused by the same user. I've no doubt that there are two attempts to update the same record. That is because session login is used to validate the user has permission to write the record they are attempting to. In the scenario described,

RE: [firebird-support] Deadlock

>The following procedure causes a deadlock when the user on the web page >navigates rapidly through a javascript object on the web page.  Please >give me some advice on how best to deal with this.  I've thought about >changing it using DATEDIFF so they update only once a minute, but I >would appr

RE: [firebird-support] Deadlock

I think you are correct on the 'lock conflict'. After posting the original message, I started reviewing the error log and noticed several 'lock conflict on No Wait transaction'. This would make sense as this is a key part of the security and this procedure is called on every read/write to the

[firebird-support] DeadLock Conflict

Hi All If possible at all, how can I trace which workstation (Firebird Client) is holding a record hostage and thus causing a deadlock conflict? Regards Stef van der Merwe email s...@autotech.co.za [Non-text portions of this message have been removed]

Re: [firebird-support] deadlock

Bieniaszewski From: 'Check_Mail' check_m...@satron.de [firebird-support] Sent: Thursday, April 13, 2017 8:00 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] deadlock Hello @ll, at the moment, we have some problems with deadlock-messages, Firebird 3.01.32531. gs

[firebird-support] Deadlock on Commit

Created a new database using deZign. The resulting script was run using IB_SQL, which reported "Script completed without exceptions". Ran the script using my standard creation checklist, which can be viewed at http://secure.enw-ltd.com/dbCreation.html#ibsqlCreation. On committing there was an I

Re[2]: [firebird-support] Deadlock

Hello, dixonepperson! Monday, March 17, 2014, 6:45:55 PM, you wrote: dyc> That raises three questions: dyc> 1) Should I put a WAIT in the procedure with a LOCK TIMEOUT? depends of how you want to handle update/delete conflicts. dyc> 2) Would it be better to a START TRANSACTION / COMMIT inside

Re[4]: [firebird-support] Deadlock

Hello, Mark! Monday, March 17, 2014, 7:30:16 PM, you wrote: >> you can't do it, at all. MR> No, but you can of course use IN AUTONOMOUS TRANSACTION within the stored MR> procedure. See Mark! :-) By the question it is clear that author have very sketchy knowledge about transactions (if any). So,

Re: [firebird-support] DeadLock Conflict

Hi, Probably you mean Lock conflict, not a true deadlock (full error text will help). If you see transaction number in the message, you can track it using MON$ tables, and then find out which connection has started it. Regards, Alexey Kovyazin IBSurgeon Hi All If possible at all, how can

[firebird-support] Deadlock - expected behaviour

Hi All! I have currently been looking into an issue where one of our clients seem to be experiencing a deadlock. However I am not a Firebird expert so I think I might need some help, hopefully someone could point me in the right direction. In short: I have narrowed it down to being due to one

Re: [firebird-support] Deadlock on Commit

Hej, i've tested your db creation script with flamerobin, executing it blockwise: - creating tables: OK - creating generators, NOT setting the values: OK - creating triggers: OK - creating foreign key: NOK following are failing with : incompatible data type: ALTER TABLE TBSETTINGS ADD CONSTRAINT

Re: Re[2]: [firebird-support] Deadlock

On Mon, 17 Mar 2014 18:54:21 +0400, Dmitry Kuzmenko wrote: > dyc> 2) Would it be better to a START TRANSACTION / COMMIT inside the > dyc> procedure as opposed to putting the transaction control in the > FbClient? > > you can't do it, at all. No, but you can of course use IN AUTONOMOUS TRANSACTIO

Re: Re[2]: [firebird-support] Deadlock

This discussion has migrated to slightly off topic where I should be taking it up in Firebird-tools. But to close the discussion, here is how I resolved it. If the choices I've made are not the best, please criticize. in the C# method that calls FbCommand, I added an optional parameter, Iso

[firebird-support] Deadlock exception occurs but it shouldn't?

Hi, I have a very simple table: CREATE TABLE PARAMS ( ID INTEGER NOT NULL, NAME VARCHAR(32) NOT NULL, CONSTRAINT PK_PARAMS PRIMARY KEY (ID), CONSTRAINT UNQ_PARAMS UNIQUE (NAME) ); I have two threads which constantly and at the same time are writing to this table: UPDATE OR INSERT INTO

[firebird-support] Deadlock error from firebird during midnight

Hi All, During midnight my service performs a calculation on firebird database. But I am receiving errors while fetching data from firebird database 1. "ERR::-2147467259: Deadlock concurrent transaction number is 5744401" 2. ERR::Error reading data from the connection.; FirebirdS

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

On 24-12-2014 09:22, brucedickin...@wp.pl [firebird-support] wrote: > I have a very simple table: > > CREATE TABLE PARAMS > ( >ID INTEGER NOT NULL, >NAME VARCHAR(32) NOT NULL, >CONSTRAINT PK_PARAMS PRIMARY KEY (ID), >CONSTRAINT UNQ_PARAMS UNIQUE (NAME) > ); > > I have two threads wh

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Hi. You should 'lock' the record you are working with. Did you read about 'with lock'? I am not sure this will help you in this case, but Hugo On 24/12/2014 06:22, brucedickin...@wp.pl [firebird-support] wrote: Hi, I have a very simple table: CREATE TABLE PARAMS ( ID INTEGER NOT NUL

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

> On Dec 24, 2014, at 3:22 AM, brucedickin...@wp.pl [firebird-support] > wrote: > > I have two threads which constantly and at the same time are writing to this > table: > > UPDATE OR INSERT INTO PARAMS (NAME) VALUES(:P_NAME) MATCHING (NAME) RETURNING > ID; > > > I've set my transaction p

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Hello Ann Maybe I am not understanding correctly, but: *Case 1:* - Transaction T1 starts with settings: READ WRITE WAIT READ COMMITTED - Transaction T1 updates a record which ID is 23 - Transaction T2 starts with settings: READ WRITE WAIT READ COMMITTED - Transaction T2 updates the s

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Update, internally, consists of following steps (simplified) : 1. read record 2. evaluate new record 3. write new record into data page really, it is a more complex, but for now we interesting only in steps above. At step 1, read-committed (RC) transaction waits for commit or rollback of conc

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Vlad, that helped me a lot, thank you. It is good to know what is going under the hood of Firebird. Now everything is much clearer for me and I know how to proceed with my problem. Best regards.

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Vlad, your explanation is very good, but I still don't understand something: Why before step 1 the engine does not blocks the record avoiding such problem? Greetings. Walter. On Sat, Dec 27, 2014 at 5:19 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > Update, internally, con

Re: [firebird-support] Deadlock error from firebird during midnight

30.11.2017 14:31, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Interesting part is this error occurs only at midnight from 12 to 2 AM. > Thereafter, > everything goes smoothly without any error. I tried replicating this on my > test machine > but no success. > > On analysing

Re: [firebird-support] Deadlock error from firebird during midnight

Do you get all the three errors all the time? In my case long running querry through .NET Provider raised error "error reading data from connection ". The same queries ran fine through flamerobin. Regards, Rajiv On 30 Nov 2017 19:01, "'Joje' j...@codework-solutions.com [firebird-support]" wrote:

Re: [firebird-support] Deadlock error from firebird during midnight

I got this errors only during midnight. Thereafter it's working fine. Get Outlook for Android From: LtColRDSChauhan rdsc1...@gmail.com [firebird-support] Sent: Thursday, 30 November, 8:29 PM Subject: Re: [firebird-support] Deadlock error from firebird during midnight To: fir

Re: [firebird-support] Deadlock error from firebird during midnight

01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote: > I got this errors only during midnight. Thereafter it's working fine. It may pretend to work fine, but using default transaction isolation level in .NET provider is just a disaster waiting to happen. It is the reason of

Re: [firebird-support] Deadlock error from firebird during midnight

Thanks a lot, Dimitry ! This issue of mine, for which I had posted for help on the firebird-net-provider group, is now resolved. On Fri, Dec 1, 2017 at 10:06 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wro

Re: [firebird-support] Deadlock error from firebird during midnight

Please, let us know what the cause ended up being and how you resolved the problem! On Sat, 02 Dec 2017 23:08:49 -0500 LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote Thanks a lot, Dimitry ! This issue of mine, for which I had p

Re: [firebird-support] Deadlock error from firebird during midnight

On Sun, Dec 3, 2017 at 5:04 PM, DougC d...@moosemail.net [firebird-support] wrote: > > > Please, let us know what the cause ended up being and how you resolved the > problem! > > Alright, I will explain the issue in detail. 1. I have a .NET application of mine deployed since about last 7 yrs wit

RE: [firebird-support] Deadlock error from firebird during midnight

procedures work fine during day time without any issues. Thank you. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 03 December 2017 06:08 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Deadlock error from firebird during midnight

Re: [firebird-support] Deadlock error from firebird during midnight

Hello, “Error reading data from the connection” has again surfaced despite of using FbTransaction tx = con.BeginTransaction( new FbTransactionOptions() {TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.NoWait}); Please help ! Regards, Rajiv On Sun, Dec 3,

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced This is a server crash. This instruction may be useful for you to help developers fix it: http://ibphoenix.com/resources/documents/development/doc_35 -

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" wrote: 12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced This is a server crash. This instruction may be useful for you to

Re: [firebird-support] Deadlock error from firebird during midnight

On Tue, Dec 12, 2017 at 4:18 PM, LtColRDSChauhan wrote: > > > On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" wrote: > > 12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > “Error reading data from the connection” has again surfa

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size 62,028 KB and > (b) My .NET Application - size 2,65,968 KB > > 2. Please let me know how do I share these DMP files. If your database does not c

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" wrote: 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size 62,028 KB and > (b) My .NET Application - size 2,65,968 K

Re: [firebird-support] Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 2:22 AM, LtColRDSChauhan wrote: > > > On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" wrote: > > 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > 1. I have generated DMP files for : > > (a) The Fireb

Re: [firebird-support] Deadlock error from firebird during midnight

1. Noticed an intriguing thing. 2. I was believing that the exception "Error reading data from connection" was being raised when the RAM or Processor is highly stressed on executing a query / stored procedure. Hence I modified such executions as under: (a) instead of fetching all records in one b

[firebird-support] Deadlock when 2 session update the same 01 row

Dear all, I am newbie to Firebird, I am working on Oracle and porting a small module to Firebird. We face with very strang problem: When session A and B update a row in a table at the same time. If A goes first, and while A does not commit or rollback yet, B will update the same row. In Oracle,

RE: [firebird-support] Deadlock when 2 session update the same 01 row

>I am newbie to Firebird, I am working on Oracle and porting a small module to >Firebird. We >face with very strang problem: > >When session A and B update a row in a table at the same time. If A goes >first, and while A >does not commit or rollback yet, B will update the same row. In Oracle, B

RE: [firebird-support] Deadlock when 2 session update the same 01 row

, November 27, 2012 4:07 PM To: 'firebird-support@yahoogroups.com' Subject: RE: [firebird-support] Deadlock when 2 session update the same 01 row >I am newbie to Firebird, I am working on Oracle and porting a small module to Firebird. We >face with very strang problem: > &g

Re: [firebird-support] Deadlock when 2 session update the same 01 row

On Tue, Nov 27, 2012 at 8:11 AM, André Knappstein < knappst...@beta-eigenheim.de> wrote: > Somewhere along this: > > FbTransactionBehavior t_behaviour; > FbTransactionOptions t_options; > > t_behaviour = FbTransactionBehavior.NoWait; > t_options.TransactionBehavior = t_behaviour; > > FbC

Re: [firebird-support] Deadlock when 2 session update the same 01 row

g Tysvær > Sent: Tuesday, November 27, 2012 4:07 PM > To: 'firebird-support@yahoogroups.com' > Subject: RE: [firebird-support] Deadlock when 2 session update the same 01 > row > > >>I am newbie to Firebird, I am working on Oracle and porting a smal

Re: [firebird-support] Deadlock when 2 session update the same 01 row

>> FbTransactionBehavior t_behaviour; >> FbTransactionOptions t_options; >> >> t_behaviour = FbTransactionBehavior.NoWait; >> t_options.TransactionBehavior = t_behaviour; >> >> FbConnection conn = new FbConnection(); >> conn.BeginTransaction(t_options); >> > should that be t_behaviour

Re: [firebird-support] Deadlock when 2 session update the same 01 row

FWIW there seems to be a related question in the .net list. Jiri confirmed that the default is "NoWait". This makes my misunderstanding of the term "deadlock" complete, because in NoWait I usually get an exception right off, which is all but a deadlock in the way I used to understand i

Re: [firebird-support] Deadlock when 2 session update the same 01 row

On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein < knappst...@beta-eigenheim.de> wrote: > FWIW there seems to be a related question in the .net list. > Jiri confirmed that the default is "NoWait". This makes my > misunderstanding of the term "deadlock" complete, because in NoWait I

Re: [firebird-support] Deadlock when 2 session update the same 01 row

Ann Harrison schrieb am 28.11.2012 um 16:07 (-0500): > On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein > wrote: > > > … the default is "NoWait". This makes my misunderstanding > > of the term "deadlock" complete, because in NoWait I usually get > > an exception right off, which is all but

RE: [firebird-support] Deadlock when 2 session update the same 01 row

Good explanation -Mensagem Original- De: Ann Harrison Enviada em: 28/11/2012 19:08 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Deadlock when 2 session update the same 01 row On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein < knappst...@beta-eigenheim

Re: [firebird-support] Deadlock when 2 session update the same 01 row

Thank you for the time to explain so well. I always appreciate your detailed explanations on such topics, be they historical or technical. Now it's clear why this exception is filed under "deadlock" at times. > On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein < > knappst...@beta-eigenheim.de>

Re: [firebird-support] Deadlock when 2 session update the same 01 row

Ann, I like very much the way you explain every thing. Now, I want to collect all your e-mails to this group. Greetings. Walter. On Wed, Nov 28, 2012 at 6:07 PM, Ann Harrison wrote: > ** > > > On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein < > knappst...@beta-eigenheim.de> wrote: > > > FWI