Mikhail Tchervonenkoпоправьте если где ошибся1) DELETE FROM MON$STATEMENTS WHERE MON$STATEMENT_ID = ... - придушит стейтмент, но не саму транзакцию; таблица mon$transactions для этого;
2) DELETE FROM MON$
CONNECTIONS - нет такой таблицы, есть mon$
attachments
3) "можно исключить через CURRENT_CONNECTION себя, дабы самому остаться" - вы и так останетесь :-)
Запустите два ISQL'я и выполните в одном из них:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
C:\MIX\firebird\QA\fbt-repo>isql /3255:e25
Database: /3255:e25, User: SYSDBA
SQL> show version;
ISQL Version: WI-V3.0.0.32320 Firebird 3.0 Release Candidate 2
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V2.5.6.26969 Firebird 2.5"
Firebird/Windows/Intel/i386 (remote server), version "WI-V2.5.6.26969 Firebird 2.5/tcp (csprog)/P12"
Firebird/Windows/Intel/i386 (remote interface), version "WI-V3.0.0.32320 Firebird 3.0 Release Candidate 2/tcp (csprog)/P12"
on disk structure version 11.2
SQL> set list on;
SQL> select current_connection from rdb$database;
CURRENT_CONNECTION 3
SQL> select * from mon$attachments;
MON$ATTACHMENT_ID 3
MON$SERVER_PID 952
MON$STATE 1
MON$ATTACHMENT_NAME e25
MON$USER SYSDBA
MON$ROLE NONE
MON$REMOTE_PROTOCOL TCPv4
MON$REMOTE_ADDRESS 192.168.43.154
MON$REMOTE_PID 1684
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2016-02-04 19:21:22.0790
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS C:\MIX\Firebird\fb30\isql.exe
MON$STAT_ID 2
MON$ATTACHMENT_ID 4
MON$SERVER_PID 952
MON$STATE 0
MON$ATTACHMENT_NAME e25
MON$USER SYSDBA
MON$ROLE NONE
MON$REMOTE_PROTOCOL TCPv4
MON$REMOTE_ADDRESS 192.168.43.154
MON$REMOTE_PID 5360
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2016-02-04 19:21:33.7980
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS C:\MIX\Firebird\fb30\isql.exe
MON$STAT_ID 6
SQL> commit; set count on; delete from mon$attachments; commit;
Records affected: 2
SQL> select * from mon$attachments;
MON$ATTACHMENT_ID 3
MON$SERVER_PID 952
MON$STATE 1
MON$ATTACHMENT_NAME e25
MON$USER SYSDBA
MON$ROLE NONE
MON$REMOTE_PROTOCOL TCPv4
MON$REMOTE_ADDRESS 192.168.43.154
MON$REMOTE_PID 1684
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2016-02-04 19:21:22.0790
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS C:\MIX\Firebird\fb30\isql.exe
MON$STAT_ID 2
Records affected: 1
SQL> select current_connection from rdb$database;
CURRENT_CONNECTION 3
Records affected: 1
SQL>
PS. Хотя на основании вот этого:
1.
SQL> commit; set count on; delete from mon$attachments; commit;
Records affected: 2
-- можно ведь подумать, что отвалились :-)
