Имеется:
Сервер БД - Sybase ASE 11.9.2
Рабочая БД - A (на этом сервере)
Действия:
- создаю БД B со своими db-device-асми на том же сервере что и A.
- dump database A to "C:\A0.dat.bak"
- load database B from "C:\A0.dat.bak"
- ... пользую БД B на уровне выборок и изменений записей ...
- dump database A to "C:\A1.dat.bak"
- сегодня > load database B from "C:\A1.dat.bak" и тут в логе sybase появляется следующее:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
00:00000:00001:2006/01/12 15:11:35.98 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00001:2006/01/12 15:11:38.51 kernel pc: 0x673e0d ri_crt_constr+ 0x2ed (0x20b59cd4, 0x20b59c24, 0x20b59c64, 0x20c22070)
00:00000:00001:2006/01/12 15:11:38.51 kernel pc: 0x673e0d ri_crt_constr+ 0x2ed (0x20b59cd4, 0x20b59ce4, 0x20b59ba4, 0xc5)
00:00000:00001:2006/01/12 15:11:38.51 kernel pc: 0x67390f s_crt_constr+ 0x31f (0x20b59ce4, 0x2029b9f0, 0x2029b9f0, 0x2029b9f0)
00:00000:00001:2006/01/12 15:11:38.52 kernel pc: 0x67d390 s_preprocess+ 0x1c0 (0x0, 0x2029b9f0, 0x2029b9f0, 0x2029b9f0)
00:00000:00001:2006/01/12 15:11:38.52 kernel pc: 0x6765af s_compile+ 0x1af (0x20b59800, 0x2029b9f0, 0x21, 0x2029b9f0)
00:00000:00001:2006/01/12 15:11:38.52 kernel [Handler pc: 0x646400 s_handle installed by the following function:-]
00:00000:00001:2006/01/12 15:11:38.52 kernel pc: 0x643374 sequencer+ 0x264 (0x0, 0x200153ec, 0x5cad0006, 0x3f0)
00:00000:00001:2006/01/12 15:11:38.52 kernel pc: 0x430e81 tdsrecv_language+ 0xc1 (0x2, 0x4000, 0x200153ec, 0x5cad0006)
00:00000:00001:2006/01/12 15:11:38.52 kernel [Handler pc: 0x453f60 hdl_backout installed by the following function:-]
00:00000:00001:2006/01/12 15:11:38.52 kernel [Handler pc: 0x5cb220 ut_handle installed by the following function:-]
00:00000:00001:2006/01/12 15:11:38.52 kernel [Handler pc: 0x5cb220 ut_handle installed by the following function:-]
00:00000:00001:2006/01/12 15:11:38.52 kernel pc: 0x40c33c conn_hdlr+ 0xbac (0x200153ec, 0x3f0, 0x5cad0006, 0x200153ec)
00:00000:00001:2006/01/12 15:11:38.57 kernel pc: 0x874406 kpntwrapper+ 0x96 (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.57 kernel pc: 0x7c57438b KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.62 kernel pc: 0x7c571608 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.62 kernel end of stack trace, spid 1, kpid 1555628061, suid 1
далее все update-ы БД A затыкаются ошибкой вида:
1.
00:00000:00001:2006/01/12 15:11:38.63 server SQL Text: update ...
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.
00:00000:00001:2006/01/12 15:11:38.63 kernel curdb = 5 pstat = 0x10000 lasterror = 937
00:00000:00001:2006/01/12 15:11:38.63 kernel preverror = 0 transtate = 1
00:00000:00001:2006/01/12 15:11:38.63 kernel curcmd = 0 program =
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x8bd1e7 os_get_cur_stk_desc+ 0x57 (0x390ef14, 0x5cb9001d, 0x390ef14, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x8bd1e7 os_get_cur_stk_desc+ 0x57 (0x390ef14, 0x390f468, 0x270f, 0x2)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x89ccb4 pcstkwalk+ 0x224 (0x5cb9001d, 0x2, 0x270f, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x89c84e ucstkgentrace+ 0x1ce (0x5cb9001d, 0x1, 0xc0000005, 0x2029b9f0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x87b414 ucbacktrace+ 0x84 (0x5cb9001d, 0xffffffff, 0x1308, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x405f65 terminate_process+ 0x525 (0xc0000005, 0x7800bdb5, 0x390f85c, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x87381e kiexception+ 0x1ee (0x200153ec, 0x3f0, 0x5cad0006, 0x200153ec)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x87447d kpntwrapper+ 0x10d (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x7c57438b KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel pc: 0x7c571608 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2006/01/12 15:11:38.63 kernel end of stack trace, spid 1, kpid 1555628061, suid 1
00:00000:00020:2006/01/12 15:11:38.63 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x673e0d ri_crt_constr+ 0x2ed (0x20a8f4d4, 0x20a8f424, 0x20a8f464, 0x20b25070)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x673e0d ri_crt_constr+ 0x2ed (0x20a8f4d4, 0x20a8f4e4, 0x20a8f3a4, 0xc5)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x67390f s_crt_constr+ 0x31f (0x20a8f4e4, 0x20324680, 0x20324680, 0x20324680)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x67d390 s_preprocess+ 0x1c0 (0x0, 0x20324680, 0x20324680, 0x20324680)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x6765af s_compile+ 0x1af (0x20a8f000, 0x20324680, 0x21, 0x20324680)
00:00000:00020:2006/01/12 15:11:38.63 kernel [Handler pc: 0x646400 s_handle installed by the following function:-]
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x643374 sequencer+ 0x264 (0x1, 0x20014f54, 0x6a840021, 0x15a8)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x430e81 tdsrecv_language+ 0xc1 (0x3, 0x4000, 0x20014f54, 0x6a840021)
00:00000:00020:2006/01/12 15:11:38.63 kernel [Handler pc: 0x453f60 hdl_backout installed by the following function:-]
00:00000:00020:2006/01/12 15:11:38.63 kernel [Handler pc: 0x5cb220 ut_handle installed by the following function:-]
00:00000:00020:2006/01/12 15:11:38.63 kernel [Handler pc: 0x5cb220 ut_handle installed by the following function:-]
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x40c33c conn_hdlr+ 0xbac (0x20014f54, 0x15a8, 0x6a840021, 0x20014f54)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x874406 kpntwrapper+ 0x96 (0x0, 0x0, 0x0, 0x0)
00:00000:00020:2006/01/12 15:11:38.63 kernel pc: 0x7c57438b KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00020:2006/01/12 15:11:38.63 kernel end of stack trace, spid 20, kpid 1787953174, suid 5
при этом в клиентских приложениях вылетает сообщение о не возможности внести изменения в БД B, т.к. она "for load", хотя нет ни одного ODBC или OLEDB источника ссылающегося на БД B. Помогите разобраться на какие грабли я налетел?.. |
