SAPфорум.RU :: Просмотр темы

00:0007:00000:00067:2016/02/17 17:19:39.03 kernel pc: 0x000000013F2D478C tdsrecv_dynamic+ 0x26c (0x000000000875F6C0, 0x000000005C1181D0, 0x000000005C12E870, 0x0000000000000021)
..
00:0007:00000:00067:2016/02/17 17:19:39.05 kernel pc: 0x000000013F29A501 conn_hdlr+ 0x1f91 (0x0000000028F27860, 0x0000000028F27860, 0x0000000000000000, 0x0000000000000000)
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel pc: 0x00000001400FBBC1 kpntwrapper+ 0x51 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel pc: 0x000000007720865D CreateFiberEx+ 0x27d (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel end of stack trace, spid 67, kpid 5177384, suid 6
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel DUMP OF LOADED MODULES:-
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel sqlsrvr.exe loaded at 000000013F270000 [C:\sybase\CRD\ASE-15_0\bin\sqlsrvr.exe]
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel ntdll.dll loaded at 0000000077420000 [C:\Windows\SYSTEM32\ntdll.dll]
00:0007:00000:00067:2016/02/17 17:19:39.06 kernel kernel32.dll loaded at 0000000077200000 [C:\Windows\system32\kernel32.dll]
..
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel ************************************
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel SQL causing error : CREATE PROC N6 AS SELECT * FROM "CRM_ACE_CUSTOM" WHERE "MANDT" = ? ORDER BY "MANDT" ,"F_NAME"
/* R3:CL_CRM_ACE_CUSTOMIZING========CP:80 T:CRM_ACE_CUS
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel ************************************
00:0007:00000:00067:2016/02/17 17:19:39.09 server SQL Text: CREATE PROC N6 AS SELECT * FROM "CRM_ACE_CUSTOM" WHERE "MANDT" = ? ORDER BY "MANDT" ,"F_NAME"
/* R3:CL_CRM_ACE_CUSTOMIZING========CP:80 T:CRM_ACE_CUSTOM M:200 */
/*3*/
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel curdb = 4 tempdb = 6 pstat = 0x40010000 p2stat = 0x101001
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x1 p7stat = 0x10000
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel lasterror = 0 preverror = 0 transtate = 0
00:0007:00000:00067:2016/02/17 17:19:39.09 kernel curcmd = 0 program = R3D006 50 comm rd ODBC

Автор:	Friday [ Ср, фев 17 2016, 14:46 ]
Заголовок сообщения:	Ошибки в sybase
Добрый день. Имеется система на sybase на windows С некоторых пор SAP начал зависать Посмотрел - в логе sybase появляются ошибки Цитата: 00:0007:00000:00067:2016/02/17 17:19:39.03 kernel pc: 0x000000013F2D478C tdsrecv_dynamic+ 0x26c (0x000000000875F6C0, 0x000000005C1181D0, 0x000000005C12E870, 0x0000000000000021) .. 00:0007:00000:00067:2016/02/17 17:19:39.05 kernel pc: 0x000000013F29A501 conn_hdlr+ 0x1f91 (0x0000000028F27860, 0x0000000028F27860, 0x0000000000000000, 0x0000000000000000) 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel pc: 0x00000001400FBBC1 kpntwrapper+ 0x51 (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000) 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel pc: 0x000000007720865D CreateFiberEx+ 0x27d (0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000) 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel end of stack trace, spid 67, kpid 5177384, suid 6 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel DUMP OF LOADED MODULES:- 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel sqlsrvr.exe loaded at 000000013F270000 [C:\sybase\CRD\ASE-15_0\bin\sqlsrvr.exe] 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel ntdll.dll loaded at 0000000077420000 [C:\Windows\SYSTEM32\ntdll.dll] 00:0007:00000:00067:2016/02/17 17:19:39.06 kernel kernel32.dll loaded at 0000000077200000 [C:\Windows\system32\kernel32.dll] .. 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel ************************************ 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel SQL causing error : CREATE PROC N6 AS SELECT * FROM "CRM_ACE_CUSTOM" WHERE "MANDT" = ? ORDER BY "MANDT" ,"F_NAME" /* R3:CL_CRM_ACE_CUSTOMIZING========CP:80 T:CRM_ACE_CUS 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel ************************************ 00:0007:00000:00067:2016/02/17 17:19:39.09 server SQL Text: CREATE PROC N6 AS SELECT * FROM "CRM_ACE_CUSTOM" WHERE "MANDT" = ? ORDER BY "MANDT" ,"F_NAME" /* R3:CL_CRM_ACE_CUSTOMIZING========CP:80 T:CRM_ACE_CUSTOM M:200 / /3*/ 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel curdb = 4 tempdb = 6 pstat = 0x40010000 p2stat = 0x101001 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x1 p7stat = 0x10000 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel lasterror = 0 preverror = 0 transtate = 0 00:0007:00000:00067:2016/02/17 17:19:39.09 kernel curcmd = 0 program = R3D006 50 comm rd ODBC и еще пара сообщений похожих с другими таблицами Я выключаю сап, перевожу sybase в 'single user' прогоняю dbcc tablealloc вроде все нормально. запускаю систему заново - через некоторое время появляются ошибки на другие таблицы пробовал dbcc checkdb Иногда проходит нормально, иногда зависает Как можно восстановить базу?

SAPфорум.RU https://sapboard.ru/forum/

Ошибки в sybase https://sapboard.ru/forum/viewtopic.php?f=14&t=92430	Страница 1 из 1

Страница 1 из 1	Часовой пояс: UTC + 3 часа
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/