Re: [Firebird-devel] Acquire lock for relation (XXX) failed

2022-02-01 Thread Dmitry Yemanov 

01.02.2022 17:11, Jiří Činčura wrote:

session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;


Can same be achieved by selects/insert/updates and some TPB settings (like i.e. 
isc_tpb_concurrency)?


Sure, but with isc_tpb_consistency (not isc_tpb_concurrency).


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Acquire lock for relation (XXX) failed

2022-02-01 Thread Jiří Činčura 
> session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;

Can same be achieved by selects/insert/updates and some TPB settings (like i.e. 
isc_tpb_concurrency)?

> session 2: INSERT INTO VERY_BIG_TABLE VALUES (..) -- in NO WAIT transaction

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Acquire lock for relation (XXX) failed

2022-02-01 Thread Dmitry Yemanov 

01.02.2022 16:45, Jiří Činčura wrote:

Hi *,

What do I have to do to get an error "Acquire lock for relation (XXX) failed"?


session 1: CREATE INDEX ... ON VERY_BIG_TABLE (...); COMMIT;
session 2: INSERT INTO VERY_BIG_TABLE VALUES (..) -- in NO WAIT transaction


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel