|
биндю базу в кеш, а используется и ругается на default
#36562085
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: Днепропетровск
Сообщения: 348
|
|
есть Adaptive Server Enterprise/12.5.3/EBF 13339 ESD#7/P/x86_64/Enterprise Linux/ase1253/1951/64-bit/OPT/Fri Mar 24 00:39:11 2006 на RHEL 3.
1.
2.
3.
4.
5.
--создаю девайсы:
disk init name "device_190", size="32G", physname="/dev/raw/raw190"
disk init name "arc_2000_log", size="1G", physname="/sybase/test/arc_2000_log"
--создаю базу.
create database arc_2000_test on device_190="28G" log on arc_2000_log="1G"
создал отдельно-стоящий mixed cache, для работы с этой базой: second_data_cache, забиндил базу на этот кеш.
загружаю дамп в эту базу. по окончанию load, в конце выскакивает.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
02:00000:00158:2010/04/05 20:49:52.54 server Device Information:
Device number = 88
Phyname = /dev/raw/raw190
02:00000:00158:2010/04/05 20:49:52.54 server Buffer Information:
Buf addr = 0x0x2d63a463c0, Mass addr = 0x0x2d63a463c0
Buf pageno = 32, Mass pageno = 32, dbid = 24
02:00000:00158:2010/04/05 20:49:52.54 server
Buf virtpg = 1476395040, Mass virtpg = 1476395040
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
02:00000:00158:2010/04/05 20:49:52.54 server Page Information from first read attempt: Page read from cache ppageno = 16, pobjid = 3, pindid = 0 pnextpg = 18, pprevpg = 0 plevel = 0, pstat = 0x11 pts_hi = 0, pts_lo = 86
02:00000:00158:2010/04/05 20:49:52.55 server Page Information from second read attempt: Page read from disk ppageno = 16, pobjid = 3, pindid = 0 pnextpg = 18, pprevpg = 0 plevel = 0, pstat = 0x11 pts_hi = 0, pts_lo = 86
02:00000:00158:2010/04/05 20:49:52.55 server SDES Information:
dbid = 24, objid = 2, scur.pageid = 32
sstat = 0x2002005, sstat2 = 0x0
suid = 1, cacheid = 0
02:00000:00158:2010/04/05 20:49:52.55 server PSS Information:
pstat = 0x1010000, pcurdb = 24, pspid = 158
p2stat = 0x1000, p3stat = 0x800
plasterror = 0, preverror = 0, pattention = 0
02:00000:00158:2010/04/05 20:49:52.55 server End diagnostics for read failure:
02:00000:00158:2010/04/05 20:49:52.55 server Error: 697, Severity: 21, State: 5
02:00000:00158:2010/04/05 20:49:52.55 server An attempt was made to fetch logical page '32' for object '2' in database '24' from cache 'default data cache'. Wrong logical page '16' was found in cache.
ну согласно troubleshoot guide перегружаю сервер ....
при попытке recovery выскакивает в логе:
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.
00:00000:00001:2010/04/05 20:55:17.62 server Starting diagnostics for read failure:
00:00000:00001:2010/04/05 20:55:17.62 server Device Information:
Device number = 88
Phyname = /dev/raw/raw190
00:00000:00001:2010/04/05 20:55:17.62 server Buffer Information:
Buf addr = 0x0x2d654888c8, Mass addr = 0x0x2d654888c8
Buf pageno = 32, Mass pageno = 32, dbid = 24
00:00000:00001:2010/04/05 20:55:17.62 server
Buf virtpg = 1476395040, Mass virtpg = 1476395040
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2010/04/05 20:55:17.62 server Page Information from first read attempt: Page read from cache ppageno = 16, pobjid = 3, pindid = 0 pnextpg = 18, pprevpg = 0 plevel = 0, pstat = 0x11 pts_hi = 0, pts_lo = 86
00:00000:00001:2010/04/05 20:55:17.62 server Page Information from second read attempt: Page read from disk ppageno = 16, pobjid = 3, pindid = 0 pnextpg = 18, pprevpg = 0 plevel = 0, pstat = 0x11 pts_hi = 0, pts_lo = 86
00:00000:00001:2010/04/05 20:55:17.62 server SDES Information:
dbid = 24, objid = 2, scur.pageid = 32
sstat = 0x2002005, sstat2 = 0x0
suid = 1, cacheid = 0
00:00000:00001:2010/04/05 20:55:17.62 server PSS Information:
pstat = 0x0, pcurdb = 1, pspid = 1
p2stat = 0x1110, p3stat = 0x900
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2010/04/05 20:55:17.62 server End diagnostics for read failure:
00:00000:00001:2010/04/05 20:55:17.63 server Error: 697, Severity: 21, State: 5
00:00000:00001:2010/04/05 20:55:17.63 server An attempt was made to fetch logical page '32' for object '2' in database '24' from cache 'default data cache'. Wrong logical page '16' was found in cache.
00:00000:00001:2010/04/05 20:55:17.90 server Error: 834, Severity: 20, State: 4
00:00000:00001:2010/04/05 20:55:17.90 server Illegal attempt to clean buffer: BUF=0x0x0000002d65488990, MASS=0x0x0000002d65488990, Buf#=0, page=0x0x0000002c06016000, dbid=24, Mass vpage=1476395009, Buf lpage=1, Mass stat=0x44001008, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.
дамп не битый - проверял на другом сервере.
вопрос: почему при recovery для этой базы используется default data cache, если забинден другой это нормально? можно ли сменить его на другой? |
|
|
