Statement failed, SQLSTATE = 40001
lock conflict on no wait transaction
After line 0 in file t004-ins-log.sql
Command error: show database

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

oel64   Mon Nov  4 09:52:50 2013
        Error in isc_attach_database() API call when working with legacy security database
        I/O error during "open" operation for file "/opt/fb30/security3.fdb"
        Error while trying to open file
        No such file or directory

2013-11-04  12:18:12 .706 Statement failed, SQLSTATE = 40001
2013-11-04 12:18:12.737 lock conflict on no wait transaction
2013-11-04 12:18:12.737 After line 0 in file t004-ins-log.sql

log_ins_CSMIR_206.err:2013-11-04 12:18:12.737 lock conflict on no wait
log_ins_TLPRG_046.err:2013-11-04 14:20:45.233 lock conflict on no wait
log_ins_CSMIR_239.err:2013-11-04 14:52:39.362 lock conflict on no wait
log_ins_CSMIR_072.err:2013-11-04 14:55:19.737 lock conflict on no wait
log_ins_CSMIR_148.err:2013-11-04 14:55:23.971 lock conflict on no wait
log_ins_TLPRG_059.err:2013-11-04 15:13:16.499 lock conflict on no wait
log_ins_CSMIR_148.err:2013-11-04 15:28:10.050 lock conflict on no wait
log_ins_CSMIR_208.err:2013-11-04 15:55:06.581 lock conflict on no wait
log_ins_TLPRG_001.err:2013-11-04 15:57:43.108 lock conflict on no wait
log_ins_TLPRG_095.err:2013-11-04 16:00:33.796 lock conflict on no wait
log_ins_TLPRG_003.err:2013-11-04 16:13:28.421 lock conflict on no wait
log_ins_TLPRG_073.err:2013-11-04 16:13:28.467 lock conflict on no wait
log_ins_CSMIR_224.err:2013-11-04 16:21:04.565 lock conflict on no wait
log_ins_CSMIR_067.err:2013-11-04 16:23:41.518 lock conflict on no wait
log_ins_CSMIR_042.err:2013-11-04 16:23:41.878 lock conflict on no wait
log_ins_CSMIR_220.err:2013-11-04 16:30:11.940 lock conflict on no wait

$ isql idx_under_load_test.fdb
Database:  idx_under_load_test.fdb
SQL> show trigger;
Trigger name                     Invalid
================================ =======
TRG_LOGON

Table name                       Trigger name                     Invalid
================================ ================================ =======
LOG_ACTIVITY                     LOG_ACTIVITY_GEN_PK
SQL> set blob all;

 SQL> show trigger trg_logon; 
TRG_LOGON, Sequence: 0, Type: ON CONNECT, Active
as
begin
  if ( current_user = 'CALIBRATOR' ) -- ==> молотилки сюда  НЕ  попадут, они все как SYSDBA
  then
    execute procedure SYS_CONNECT_CALIBRATE;
end
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 SQL> show trigger log_activity_gen_pk;  -- соотв-щая таблица сейчас НЕ используется.

Triggers on Table LOG_ACTIVITY:
LOG_ACTIVITY_GEN_PK, Sequence: 0, Type: BEFORE INSERT, Active
as
begin
    if (new.id is null) then
        new.id = gen_id(log_activity_seq, 1);
end
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 SQL> show proc sys_connect_calibrate; 
Procedure text:
=============================================================================
declare variable v_dts_beg timestamp;
declare variable v_dts_end timestamp;
declare variable c_min_duration_to_log int = 1000; --00; --3000; --5000; --0; -- 3000;
begin
    v_dts_end=cast('now' as timestamp);
    if (current_user <> 'CALIBRATOR') then -- => на всякий случай еще раз проверяем...
        EXIT; -- ##################  E X I T  ###############

    select first 1 cast(dts as timestamp) from ext_connect_calibr into v_dts_beg;
    if (
        v_dts_beg is null
        or
        datediff(millisecond from v_dts_beg to v_dts_end)
        < c_min_duration_to_log -- or connect was established enough quickly
       ) then
        EXIT; -- ##################  E X I T  ###############

    -- now we must log event of too long connection:
    insert into log_connect_calibr(dts_before_establish, dts_after_establish)
    values( :v_dts_beg, :v_dts_end);
    -- external file used by shell to run gdb if it`s size greater than zero
    insert into ext_long_connect_log(msg)
    values( 'ms_'||lpad( datediff(millisecond from :v_dts_beg to :v_dts_end),8,'0'));
end
=============================================================================