Есть:
Hardware: Dual Xeon CPU 2.40GHz, RAM 3gb
Soft: FedoraCore3, FirebirdCS-1.5.4.4910-0
База 1.7Gb
Database header page information:
Flags 0
Checksum 12345
Generation 164746
Page size 4096
ODS version 10.1
Oldest transaction 32436
Oldest active 164597
Oldest snapshot 160092
Next transaction 164726
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Mar 25, 2007 1:12:17
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
*END*
Периодически какая-то транзакция базу вгоняет в состояние, когда
невозможно поменять системные таблицы. Как определить какая операция
держит базу. Типа как в mysql делается show processlist
./fb_lock_print | more
LOCK_HEADER BLOCK
Version: 15, Active owner: 0, Length: 655360, Used:
643448
Lock manager pid: 22314
Semmask: 0x2C74, Flags: 0x0001
Enqs: 186338756, Converts: 344623, Rejects: 366111, Blocks:
51600
Deadlock scans: 4, Deadlocks: 0, Scan interval: 10
Acquires: 199032676, Acquire blocks: 442776, Spin count: 0
Mutex wait: 0.2%
Hash slots: 101, Hash lengths (min/avg/max): 0/ 0/ 4
Remove node: 0, Insert queue: 0, Insert prior:
0
Owners (2): forward: 11704, backward: 147780
Free owners (33): forward: 11392, backward: 12188
Free locks (5159): forward: 124060, backward: 375220
Free requests (5958): forward: 215704, backward: 362624
Lock Ordering: Enabled
OWNER BLOCK 11704
Owner id: 22314, type: 1, flags: 0x24, pending: 0,
semid: 1
Process id: 22314, UID: 0x0 Alive
Flags: 0x24 wake
Requests: *empty*
Blocks: *empty*
OWNER BLOCK 147780
Owner id: 12533, type: 3, flags: 0x20, pending: 0,
semid: 2 (available)
Process id: 12533, UID: 0x1F4 Alive
Flags: 0x20 wake
Requests (89): forward: 448968, backward: 152272
Blocks: *empty*
Event log:
DEL_OWNER: owner = 151468, lock = 151468, request = 0
DEL_OWNER: owner = 12188, lock = 12188, request = 0
DEL_OWNER: owner = 11392, lock = 11392, request = 0
DEL_OWNER: owner = 101920, lock = 101920, request = 0
DEL_OWNER: owner = 643372, lock = 643372, request = 0
DEL_OWNER: owner = 179272, lock = 179272, request = 0
DEL_OWNER: owner = 147780, lock = 147780, request = 0
DEL_OWNER: owner = 104148, lock = 104148, request = 0
DEL_OWNER: owner = 175244, lock = 175244, request = 0
DEL_OWNER: owner = 104072, lock = 104072, request = 0
DEL_OWNER: owner = 643296, lock = 643296, request = 0
DEL_OWNER: owner = 196900, lock = 196900, request = 0
DEL_OWNER: owner = 96292, lock = 96292, request = 0
DEL_OWNER: owner = 163876, lock = 163876, request = 0
DEL_OWNER: owner = 215628, lock = 215628, request = 0
DEL_OWNER: owner = 187900, lock = 187900, request = 0
DEL_OWNER: owner = 60884, lock = 60884, request = 0
DEL_OWNER: owner = 195732, lock = 195732, request = 0
DEL_OWNER: owner = 84260, lock = 84260, request = 0
DEL_OWNER: owner = 147856, lock = 147856, request = 0
DEL_OWNER: owner = 89744, lock = 89744, request = 0
DEL_OWNER: owner = 35132, lock = 35132, request = 0
DEL_OWNER: owner = 56332, lock = 56332, request = 0
DEL_OWNER: owner = 51628, lock = 51628, request = 0
DEL_OWNER: owner = 46768, lock = 46768, request = 0
DEL_OWNER: owner = 106616, lock = 106616, request = 0
DEL_OWNER: owner = 184080, lock = 184080, request = 0
DEL_OWNER: owner = 103996, lock = 103996, request = 0
DEL_OWNER: owner = 225292, lock = 225292, request = 0
DEL_OWNER: owner = 103920, lock = 103920, request = 0
DEL_OWNER: owner = 197652, lock = 197652, request = 0
DEL_OWNER: owner = 151468, lock = 151468, request = 0
DEL_OWNER: owner = 12188, lock = 12188, request = 0
DEL_OWNER: owner = 11392, lock = 11392, request = 0
DEL_OWNER: owner = 643372, lock = 643372, request = 0
DEL_OWNER: owner = 101920, lock = 101920, request = 0
DEL_OWNER: owner = 77308, lock = 77308, request = 0
DEL_OWNER: owner = 179272, lock = 179272, request = 0
DEL_OWNER: owner = 104148, lock = 104148, request = 0
DEL_OWNER: owner = 175244, lock = 175244, request = 0
DEL_OWNER: owner = 104072, lock = 104072, request = 0
DEL_OWNER: owner = 643296, lock = 643296, request = 0
Спасибо
