Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

On 18-9-2014 10:14, doyc...@dsoft-bg.com [firebird-support] wrote: here is a stack trace from Java app server. After that you will find back trace from some of fb_inet processes and a list of all live processes. The mssing back traces are the same like for PID Attaching to process 16275.

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

On 5-9-2014 19:48, doyc...@dsoft-bg.com [firebird-support] wrote: I'm not sure it is locked table. What I'm looking for is idea or advice how to find what the real problem is. I'd start with obtaining a thread dump of the application when it is hanging. The stacktraces might hint at the

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

I'm using Firebird 2.1.6. Also I tried to upgrade to latest jaybird before but it does not work properly with JBoss 4.2.3. I remember something has changed and as soon as I try to start apps server and run client, exceptions were starting to popup in the log. This code path uses long running

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

On 04 Sep 2014 13:31:14 -0700, doyc...@dsoft-bg.com [firebird-support] firebird-support@yahoogroups.com wrote: Yes background process is running to on same application server and uses same data source. I use EJB 2 and CPM for doing database operations. App server is 4.2.3 and jaybird is

RE: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

This is the definition of the table that locks on insert: CREATE TABLE CASH_CASHBOX_DAY_AMMOUNT ( CASHBOXID INTEGER NOT NULL, DATE_TIME NUMERIC( 18, 0) NOT NULL, AMMOUNTNUMERIC( 18, 0), CONSTRAINT PK_CASH_CASHBOX_DAY_AMMOUNT PRIMARY KEY

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

I'm not sure it is locked table. What I'm looking for is idea or advice how to find what the real problem is. My data source definition is this: connection-factories tx-connection-factory jndi-namePowerProDS/jndi-name xa-transaction/ track-connection-by-tx/

[firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

Hi guys, I'm looking for some ideas how to find what is causing this lock. I have 2 production databases that process multiple insert/update statements. There is one background process that does all these modifications 24h/day. The problem is that with one of these databases almost every

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

Hi, Hi guys, I'm looking for some ideas how to find what is causing this lock. I have 2 production databases that process multiple insert/update statements. There is one background process that does all these modifications 24h/day. The problem is that with one of these databases almost

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

They all use READ COMMITTED isolation. It is an application that runs in JBoss App server so I have single datasource defined that uses READ COMMITTED. Blocked statements are insert and update. Selects are not blocked.

RE: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

They all use READ COMMITTED isolation. It is an application that runs in JBoss App server so I have single datasource defined that uses READ COMMITTED. Blocked statements are insert and update. Selects are not blocked. Why are inserts blocked? That should not happen unless you a) don’t

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

On 4-9-2014 13:53, doyc...@dsoft-bg.com [firebird-support] wrote: They all use READ COMMITTED isolation. Are you using the default read committed config of Jaybird, or have you overridden it? Default is isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_write,isc_tpb_wait It is an

RE: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

This is the definition of the table that locks on insert: CREATE TABLE CASH_CASHBOX_DAY_AMMOUNT ( CASHBOXID INTEGER NOT NULL, DATE_TIME NUMERIC( 18, 0) NOT NULL, AMMOUNTNUMERIC( 18, 0), CONSTRAINT PK_CASH_CASHBOX_DAY_AMMOUNT PRIMARY KEY

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

Yes background process is running to on same application server and uses same data source. I use EJB 2 and CPM for doing database operations. App server is 4.2.3 and jaybird is 2.1.6