[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

[firebird-support] Re: Where is changeMultiConnectMode.sh on FreeBSD?

SuperClassic is better if you have multiple cpus and ram http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg25-appx-architectures.html http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg25-appx-architectures.html

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.

[firebird-support] Re: Where is changeMultiConnectMode.sh on FreeBSD?

Its a single processor server. Also I like the 'shared cache' of SuperSever.

[firebird-support] Re: Where is changeMultiConnectMode.sh on FreeBSD?

If you look in the firebird port source it can be changed from /etc/rc.conf firebird_mode =superserver https://github.com/freebsd/freebsd-ports/blob/master/databases/firebird25-server/files/firebird.in

[firebird-support] Re: Where is changeMultiConnectMode.sh on FreeBSD?

Here is the doc https://raw.githubusercontent.com/freebsd/freebsd-ports/master/databases/firebird25-server/files/pkg-message.in https://raw.githubusercontent.com/freebsd/freebsd-ports/master/databases/firebird25-server/files/pkg-message.in

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