|
nbackup -b: не вижу сведений по нему в mon$attachments. Why ?
#38558680
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
hi all.
Вот трейс при работе nbackup -b 0 некоторой большой базы: 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.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
Trace session ID 7 started
2014-02-12T16:03:58.6230 (9319:0x7ff627708f28) TRACE_INIT
SESSION_7
2014-02-12T16:03:58.6230 (9319:0x7ff627708f28) ATTACH_DATABASE
/var/db/fb30/gfixtest30.fdb (ATT_44, SYSDBA:NONE, NONE, <internal>)
2014-02-12T16:03:58.6250 (9319:0x7ff627708f28) START_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_44, SYSDBA:NONE, NONE, <internal>)
(TRA_114, CONCURRENCY | WAIT | READ_WRITE)
2014-02-12T16:03:58.6260 (9319:0x7ff627708f28) EXECUTE_STATEMENT_FINISH
/var/db/fb30/gfixtest30.fdb (ATT_44, SYSDBA:NONE, NONE, <internal>)
(TRA_114, CONCURRENCY | WAIT | READ_WRITE)
-------------------------------------------------------------------------------
ALTER DATABASE BEGIN BACKUP
0 records fetched
0 ms
2014-02-12T16:03:58.6260 (9319:0x7ff627708f28) COMMIT_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_44, SYSDBA:NONE, NONE, <internal>)
(TRA_114, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 8 write(s), 3 fetch(es), 3 mark(s)
2014-02-12T16:03:58.6260 (9319:0x7ff627708f28) DETACH_DATABASE
/var/db/fb30/gfixtest30.fdb (ATT_44, SYSDBA:NONE, NONE, <internal>)
2014-02-12T16:03:58.6260 (9319:0x7ff627708f28) TRACE_FINI
SESSION_7
2014-02-12T16:04:03.9040 (32351:0x7f6c357be2e8) TRACE_INIT
SESSION_7
2014-02-12T16:04:03.9040 (32351:0x7f6c357be2e8) DETACH_DATABASE
/opt/fb30trnk/security3.fdb (ATT_6750, SYSDBA:NONE, NONE, <internal>)
2014-02-12T16:04:03.9050 (32351:0x7f6c357be2e8) TRACE_FINI
SESSION_7
2014-02-12T16:04:43.7120 (9319:0x7ff627b86f28) TRACE_INIT
SESSION_7
2014-02-12T16:04:43.7130 (9319:0x7ff627b86f28) ATTACH_DATABASE
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
2014-02-12T16:04:43.7140 (9319:0x7ff627b86f28) START_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_115, CONCURRENCY | WAIT | READ_WRITE)
2014-02-12T16:04:43.7150 (9319:0x7ff627b86f28) EXECUTE_STATEMENT_FINISH
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_115, CONCURRENCY | WAIT | READ_WRITE)
Statement 19:
-------------------------------------------------------------------------------
insert into rdb$backup_history(rdb$backup_id, rdb$timestamp, rdb$backup_level, rdb$guid, rdb$scn, rdb$file_name) values(gen_id(rdb$backup_history, 1), 'now', ?, ?, ?, ?)
param0 = integer, "0"
param1 = varchar(38), "{B594EB48-12DB-4BCE-E481-69C1395FC5F0}"
param2 = integer, "9"
param3 = varchar(255), "gfixtest30.fdb.nbk0"
0 records fetched
0 ms, 6 read(s), 10 fetch(es), 6 mark(s)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$BACKUP_HISTORY 1
2014-02-12T16:04:43.7150 (9319:0x7ff627b86f28) COMMIT_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_115, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 5 write(s), 1 fetch(es), 1 mark(s)
2014-02-12T16:04:43.7150 (9319:0x7ff627b86f28) START_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_116, CONCURRENCY | WAIT | READ_WRITE)
2014-02-12T16:04:43.7160 (9319:0x7ff627b86f28) EXECUTE_STATEMENT_FINISH
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_116, CONCURRENCY | WAIT | READ_WRITE)
-------------------------------------------------------------------------------
ALTER DATABASE END BACKUP
0 records fetched
0 ms
2014-02-12T16:04:43.7160 (9319:0x7ff627b86f28) COMMIT_TRANSACTION
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
(TRA_116, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 14 write(s), 18 fetch(es), 17 mark(s)
2014-02-12T16:04:43.7160 (9319:0x7ff627b86f28) DETACH_DATABASE
/var/db/fb30/gfixtest30.fdb (ATT_47, SYSDBA:NONE, NONE, <internal>)
2014-02-12T16:04:43.7160 (9319:0x7ff627b86f28) TRACE_FINI
SESSION_7
И вот то, что было в это время видно в mon$att: 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.
SQL> set list on; commit; select * from mon$attachments where mon$attachment_id<>current_connection;
MON$ATTACHMENT_ID 38
MON$SERVER_PID 32351
MON$STATE 0
MON$ATTACHMENT_NAME /var/db/fb30/gfixtest30.fdb
MON$USER Garbage Collector
MON$ROLE <null>
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_ADDRESS <null>
MON$REMOTE_PID <null>
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2014-02-12 16:02:05.9950
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS <null>
MON$STAT_ID 6
MON$CLIENT_VERSION <null>
MON$REMOTE_VERSION <null>
MON$REMOTE_HOST <null>
MON$REMOTE_OS_USER <null>
MON$AUTH_METHOD <null>
MON$SYSTEM_FLAG 1
MON$ATTACHMENT_ID 36
MON$SERVER_PID 32351
MON$STATE 0
MON$ATTACHMENT_NAME /var/db/fb30/gfixtest30.fdb
MON$USER Cache Writer
MON$ROLE <null>
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_ADDRESS <null>
MON$REMOTE_PID <null>
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2014-02-12 16:02:05.9950
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS <null>
MON$STAT_ID 8
MON$CLIENT_VERSION <null>
MON$REMOTE_VERSION <null>
MON$REMOTE_HOST <null>
MON$REMOTE_OS_USER <null>
MON$AUTH_METHOD <null>
MON$SYSTEM_FLAG 1
Д, я знаю, что nbackup как-то там глубоко вкрячен в сам движок.
Но почему бы не отражать наличие его коннекта (вполне себе реального, судя по трейсу) в mon$att ? |
|
|
