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
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
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
> 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
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,
>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
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
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]
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
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
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
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,
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
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
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
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
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
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
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
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
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
> 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
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
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
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.
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
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
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:
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
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
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
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
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
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
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,
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
-
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
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
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
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
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
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
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,
>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
, 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
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
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
>> 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
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
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
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
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
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>
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
54 matches
Mail list logo