|
Error during sweep: page type 7 lock conv denied <==> "Deadlock scans:26, Deadlocks: 1"
#38850505
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
Нарылось тут еще кое-что. Оказывается, существует мистическая связь между "page type 7 lock conversion denied", заваливающимся свипом и "внезапно положительными" значениями Deadlock scans и Deadlocks :-)
Вот что вижу в накопительном логе заголовка лок-таблицы (OLTP-EMUL тест, 100 аттачей, SC, FW = ON):
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.
150108_ 215843 :
---------------
LOCK_HEADER BLOCK
Version: 146, Creation timestamp: 2015-01-08 21:27:37
Active owner: 0, Length: 79691776, Used: 79655696
Enqs: 71912520, Converts: 2799125, Rejects: 6057795, Blocks: 38274612
Deadlock scans: 0, Deadlocks: 0 , Scan interval: 10
Acquires: 211755763, Acquire blocks: 90977473, Spin count: 0
Mutex wait: 43.0%
Hash slots: 45007, Hash lengths (min/avg/max): 0/ 2/ 8
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (101): forward: 372904, backward: 78715672
Free owners: *empty*
Free locks (1188): forward: 50794472, backward: 55385552
Free requests (355876): forward: 29604736, backward: 5952304
150108_ 215849 :
---------------
LOCK_HEADER BLOCK
Version: 146, Creation timestamp: 2015-01-08 21:27:37
Active owner: 0, Length: 79691776, Used: 79655696
Enqs: 72030497, Converts: 2803033, Rejects: 6064329, Blocks: 38338574
Deadlock scans: 26, Deadlocks: 1 , Scan interval: 10
Acquires: 212129600, Acquire blocks: 91149618, Spin count: 0
Mutex wait: 43.0%
Hash slots: 45007, Hash lengths (min/avg/max): 0/ 1/ 7
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (101): forward: 372904, backward: 78715672
Free owners: *empty*
Free locks (25169): forward: 15606216, backward: 29088192
Free requests (370617): forward: 45818120, backward: 62996896
И вот что при этом было в firebirsd.log'e:
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.
32 oel64 Thu Jan 8 21:27:37 2015
33 /opt/fb30trnk/bin/fbguard: guardian starting /opt/fb30trnk/bin/firebird
34
35
36
37 oel64 Thu Jan 8 21:29:01 2015
38 Database: oltp30
39 page 55146, page type 5 lock denied (216)
40
41
42 oel64 Thu Jan 8 21:43:16 2015
43 Database: oltp30
44 page 56946, page type 5 lock denied (216)
45
46
47 oel64 Thu Jan 8 21:47:36 2015
48 Sweep is started by SWEEPER ---------------------------- СТАРТ #1 -------------------
49 Database "oltp30"
50 OIT 153354, OAT 187284, OST 179639, Next 190406
51
52
53 oel64 Thu Jan 8 21:48:24 2015
54 Database: oltp30
55 page 137452, page type 5 lock denied (216)
56
57
58 oel64 Thu Jan 8 21:57:25 2015
59 Database: oltp30
60 page 46075, page type 5 lock denied (216)
61
62
63 oel64 Thu Jan 8 21:58:44 2015
64 Database: oltp30
65 page 65104, page type 7 lock conversion denied (215)
66
67
68 oel64 Thu Jan 8 21:58:44 2015
69 Error during sweep:
70 page 65104, page type 7 lock conversion denied
71
72
73 oel64 Thu Jan 8 21:58:47 2015
74 Sweep is started by SWEEPER ---------------------------- СТАРТ #2 -------------------
75 Database "oltp30"
76 OIT 153354, OAT 200219, OST 188322, Next 205394
77
78
79 oel64 Thu Jan 8 22:03:12 2015
80 Sweep is finished
81 Database "oltp30"
82 OIT 188321, OAT 204203, OST 200219, Next 210455
83
84
85 oel64 Thu Jan 8 22:04:25 2015
86 Database: oltp30
87 page 28888, page type 5 lock denied (216)
|
|
|
