Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Начинающий...
Guest
Есть таблица логов, в которой ключ генерится с использованием sequence:
+

CREATE DATABASE Logs
GO

USE Logs
GO


/****** Object:  Sequence [dbo].[ZampaLogId_Sequence]    Script Date: 28.08.2014 11:38:22 ******/
CREATE SEQUENCE [dbo].[LogId_Sequence] 
 AS [int]
 START WITH 1
 INCREMENT BY 1
 MINVALUE -2147483648
 MAXVALUE 2147483647
 CYCLE 
 CACHE 


GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblLog](
	[Id] [int] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[ClientCreateDate] [datetime] NOT NULL,
	[WorkplaceId] [int] NULL,
	[UserId] [int] NULL,
	[ThreadId] [int] NOT NULL,
	[LogSeverityLevelId] [int] NOT NULL,
	[Description] [varchar](max) NOT NULL,
	[ComponentId] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tblLog] ADD  CONSTRAINT [DF_tblLog_Id]  DEFAULT (NEXT VALUE FOR [LogId_Sequence]) FOR [Id]
GO

ALTER TABLE [dbo].[tblLog] ADD  CONSTRAINT [DF_tblLog_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]
GO

Далее есть ХП в другой БД, которая пишет в эту таблицу:
+
CREATE DATABASE OtherDB
GO

USE OtherDB
GO

CREATE PROCEDURE [dbo].[sp_Service_AddProgramLog]
	-- Add the parameters for the stored procedure here
	@LogDescription varchar(max), @ComponentId int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

insert into Logs.dbo.tblLog (ClientCreateDate, ThreadId, LogSeverityLevelId, Description, ComponentId)
values (GETDATE(), 0, 1, @LogDescription, @ComponentId)

END

GO


Вызываем ХП:
+
EXECUTE [dbo].[sp_Service_AddProgramLog] 
   @LogDescription = 'тест'
  ,@ComponentId = 11


Получаем:

Msg 0, Level 11, State 0, Line 0
При выполнении текущей команды возникла серьезная ошибка.. При наличии результатов они должны быть аннулированы.
Msg 0, Level 20, State 0, Line 0
При выполнении текущей команды возникла серьезная ошибка.. При наличии результатов они должны быть аннулированы.


WTF?! Как побороть? Если заменить sequence на identity - отрабатывает без ошибок.

PS. Microsoft SQL Server 2012 (SP1) - 11.0.3349.0 (X64)
Mar 8 2013 17:33:56
Copyright (c) Microsoft Corporation
Business Intelligence Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

Microsoft SQL Server Management Studio 11.0.2100.60
28 авг 14, 11:59    [16506009]     Ответить | Цитировать Сообщить модератору
 Re: Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Glory
Member

Откуда:
Сообщений: 104751
Начинающий...
WTF?!

А при выполнении в той же базе ?
28 авг 14, 12:16    [16506137]     Ответить | Цитировать Сообщить модератору
 Re: Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Начинающий...
Guest
Glory,
В той же базе - выполняется без ошибок.
28 авг 14, 12:19    [16506162]     Ответить | Цитировать Сообщить модератору
 Re: Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Начинающий...
Guest
Начинающий...,

плюс в логах сервера вот что:

+
Current time is 12:11:41 08/28/14.
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 11.0.3349.0
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.


Computer type is Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz.
Bios Version is VRTUAL - 1
Hyper-V UEFI Release v1.0
2 X64 level 8664, 10 Mhz processor (s).
Windows NT 6.2 Build 9200 CSD .

Memory
MemoryLoad = 83%
Total Physical = 8189 MB
Available Physical = 1321 MB
Total Page File = 9469 MB
Available Page File = 2267 MB
Total Virtual = 134217727 MB
Available Virtual = 134202776 MB
***Stack Dump being sent to D:\mssql_data\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0003.txt
SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/28/14 12:11:41 spid 54
*
*
* Exception Address = 00007FFF9E428866 Module(sqllang+0000000000DE8866)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000000000000
* Input Buffer 462 bytes -
* DECLARE @RC int DECLARE @LogDescription varchar(max) DECL
* ARE @ComponentId int -- TODO: Set parameter values here. EXECUTE @
* RC = [dbo].[sp_Service_AddProgramLog] @LogDescription = 'sss' ,@
* ComponentId = 1
*
*
* MODULE BASE END SIZE
* sqlservr 00007FF78FF40000 00007FF78FF7DFFF 0003e000
* ntdll 00007FFFC3730000 00007FFFC38D9FFF 001aa000
* KERNEL32 00007FFFC28E0000 00007FFFC2A19FFF 0013a000
* KERNELBASE 00007FFFC0EA0000 00007FFFC0FAEFFF 0010f000
* ADVAPI32 00007FFFC2B50000 00007FFFC2BF4FFF 000a5000
* MSVCR100 00000000610D0000 00000000611A1FFF 000d2000
* MSVCP100 0000000061000000 0000000061097FFF 00098000
* sqlos 0000000060C00000 0000000060C06FFF 00007000
* NETAPI32 00007FFFBEBA0000 00007FFFBEBB4FFF 00015000
* pdh 00007FFFB78C0000 00007FFFB790CFFF 0004d000
* opends60 0000000060BF0000 0000000060BF7FFF 00008000
* sqlmin 00007FFFB5970000 00007FFFB78B7FFF 01f48000
* sqllang 00007FFF9D640000 00007FFF9F6CEFFF 0208f000
* sqlTsEs 00007FFFB50E0000 00007FFFB5966FFF 00887000
* sqldk 00007FFFB4C60000 00007FFFB50D8FFF 00479000
* msvcrt 00007FFFC27F0000 00007FFFC2896FFF 000a7000
* sechost 00007FFFC2790000 00007FFFC27E6FFF 00057000
* RPCRT4 00007FFFC2FD0000 00007FFFC3106FFF 00137000
* netutils 00007FFFBF500000 00007FFFBF50BFFF 0000c000
* srvcli 00007FFFC06B0000 00007FFFC06D4FFF 00025000
* wkscli 00007FFFBF510000 00007FFFBF525FFF 00016000
* USER32 00007FFFC2C00000 00007FFFC2D70FFF 00171000
* ole32 00007FFFC3240000 00007FFFC33B7FFF 00178000
* OLEAUT32 00007FFFC3120000 00007FFFC31D6FFF 000b7000
* CRYPT32 00007FFFC0CC0000 00007FFFC0E96FFF 001d7000
* Secur32 00007FFFB7A40000 00007FFFB7A4AFFF 0000b000
* PSAPI 00007FFFC3110000 00007FFFC3116FFF 00007000
* WS2_32 00007FFFC2A80000 00007FFFC2AD7FFF 00058000
* USERENV 00007FFFC0320000 00007FFFC033DFFF 0001e000
* AUTHZ 00007FFFBFD90000 00007FFFBFDD7FFF 00048000
* WINTRUST 00007FFFC0C70000 00007FFFC0CBBFFF 0004c000
* WINMM 00007FFFB7A20000 00007FFFB7A3EFFF 0001f000
* GDI32 00007FFFC3400000 00007FFFC3543FFF 00144000
* combase 00007FFFC10F0000 00007FFFC12C5FFF 001d6000
* MSASN1 00007FFFC0B50000 00007FFFC0B61FFF 00012000
* NSI 00007FFFC33C0000 00007FFFC33C8FFF 00009000
* profapi 00007FFFC0AA0000 00007FFFC0AB3FFF 00014000
* WINMMBASE 00007FFFB79F0000 00007FFFB7A19FFF 0002a000
* SSPICLI 00007FFFC0880000 00007FFFC08AAFFF 0002b000
* cfgmgr32 00007FFFC0C20000 00007FFFC0C69FFF 0004a000
* DEVOBJ 00007FFFBF990000 00007FFFBF9B5FFF 00026000
* LOGONCLI 00007FFFC0410000 00007FFFC044CFFF 0003d000
* SAMCLI 00007FFFBBD00000 00007FFFBBD16FFF 00017000
* CRYPTBASE 00007FFFC0910000 00007FFFC0919FFF 0000a000
* bcryptPrimitives 00007FFFC08B0000 00007FFFC090FFFF 00060000
* instapi110 00007FFFB7940000 00007FFFB794DFFF 0000e000
* cscapi 00007FFFB79D0000 00007FFFB79DFFFF 00010000
* sqlevn70 0000000060970000 0000000060BE9FFF 0027a000
* CRYPTSP 00007FFFC0450000 00007FFFC046DFFF 0001e000
* rsaenh 00007FFFC0050000 00007FFFC0084FFF 00035000
* bcrypt 00007FFFC0590000 00007FFFC05B5FFF 00026000
* imagehlp 00007FFFC33E0000 00007FFFC33F4FFF 00015000
* ncrypt 00007FFFC0560000 00007FFFC0583FFF 00024000
* NTASN1 00007FFFC0520000 00007FFFC0559FFF 0003a000
* gpapi 00007FFFBFD00000 00007FFFBFD21FFF 00022000
* VERSION 00007FFFB7950000 00007FFFB7959FFF 0000a000
* msv1_0 00007FFFC0340000 00007FFFC03A7FFF 00068000
* cryptdll 00007FFFC0300000 00007FFFC0317FFF 00018000
* kerberos 00007FFFC0210000 00007FFFC02FAFFF 000eb000
* schannel 00007FFFBFDE0000 00007FFFBFE4AFFF 0006b000
* MSCOREE 00007FFFBBFE0000 00007FFFBC043FFF 00064000
* mscoreei 00007FFFBBF20000 00007FFFBBFBCFFF 0009d000
* CLUSAPI 00007FFFB1F80000 00007FFFB1FEBFFF 0006c000
* RESUTILS 00007FFFB1530000 00007FFFB1578FFF 00049000
* security 00007FFFB79C0000 00007FFFB79C2FFF 00003000
* ualapi 00007FFFBC590000 00007FFFBC5A8FFF 00019000
* ESENT 00007FFFBC2D0000 00007FFFBC580FFF 002b1000
* ntmarta 00007FFFBCC40000 00007FFFBCC6FFFF 00030000
* SHELL32 00007FFFC1370000 00007FFFC278EFFF 0141f000
* SHLWAPI 00007FFFC2A20000 00007FFFC2A70FFF 00051000
* kernel.appcore 00007FFFBF800000 00007FFFBF809FFF 0000a000
* clbcatq 00007FFFC2F20000 00007FFFC2FC3FFF 000a4000
* sqlncli11 000000005F7D0000 000000005FB22FFF 00353000
* COMCTL32 00007FFFC0B70000 00007FFFC0C10FFF 000a1000
* COMDLG32 00007FFFC12D0000 00007FFFC136DFFF 0009e000
* SHCORE 00007FFFBF460000 00007FFFBF4FEFFF 0009f000
* SQLNCLIR11 000000005F790000 000000005F7C7FFF 00038000
* DPAPI 00007FFFBF7E0000 00007FFFBF7E8FFF 00009000
* netbios 00007FFFB08C0000 00007FFFB08C9FFF 0000a000
* clr 00007FFFBB320000 00007FFFBBC9BFFF 0097c000
* MSVCR120_CLR0400 00007FFFBB240000 00007FFFBB315FFF 000d6000
* mscorlib.ni 00007FFFB9CB0000 00007FFFBB23CFFF 0158d000
* SqlAccess 0000000013870000 00000000138DCFFF 0006d000
* clrjit 00007FFFB8EC0000 00007FFFB8FEEFFF 0012f000
* BatchParser 000000005F760000 000000005F78AFFF 0002b000
* ftimport 0000000060000000 0000000060024FFF 00025000
* MSFTE 0000000049980000 0000000049D2DFFF 003ae000
* dbghelp 000000005EB20000 000000005ECB5FFF 00196000
* mswsock 00007FFFC03B0000 00007FFFC0407FFF 00058000
* ntdsapi 00007FFFBEB30000 00007FFFBEB57FFF 00028000
* DSPARSE 00007FFFBC0E0000 00007FFFBC0EAFFF 0000b000
* DNSAPI 00007FFFBFF90000 00007FFFC0032FFF 000a3000
* rasadhlp 00007FFFBC5B0000 00007FFFBC5B8FFF 00009000
* IPHLPAPI 00007FFFBE290000 00007FFFBE2B8FFF 00029000
* WINNSI 00007FFFBE220000 00007FFFBE229FFF 0000a000
* fwpuclnt 00007FFFBDE70000 00007FFFBDED7FFF 00068000
* ncryptsslp 00007FFFB1350000 00007FFFB136AFFF 0001b000
* xpsqlbot 000000005F680000 000000005F687FFF 00008000
* xpstar 000000005F610000 000000005F67FFFF 00070000
* ATL100 00000000610A0000 00000000610CAFFF 0002b000
* SQLSCM 000000005F600000 000000005F60EFFF 0000f000
* ODBC32 00007FFFB4BA0000 00007FFFB4C5BFFF 000bc000
* xpstar 000000005F280000 000000005F2A4FFF 00025000
* SAMLIB 00007FFFBBCE0000 00007FFFBBCFDFFF 0001e000
* Sort00060101 00007FFFB4B80000 00007FFFB4B92FFF 00013000
* System.Data 00007FFFACE70000 00007FFFAD18CFFF 0031d000
* apphelp 00007FFFBF3D0000 00007FFFBF457FFF 00088000
* xplog70 000000005EA50000 000000005EA63FFF 00014000
* BROWCLI 00007FFFAC3D0000 00007FFFAC3E1FFF 00012000
* xplog70 000000005EA40000 000000005EA42FFF 00003000
* DSROLE 00007FFFBEBC0000 00007FFFBEBC8FFF 00009000
* Sort00001000 00007FFF9B300000 00007FFF9B3D4FFF 000d5000
* ssdebugps 000000005EB00000 000000005EB12FFF 00013000
* peverify 00007FFFA9350000 00007FFFA9385FFF 00036000
* rasapi32 00007FFFBD220000 00007FFFBD2C7FFF 000a8000
* rasman 00007FFFBD1C0000 00007FFFBD1EDFFF 0002e000
* rtutils 00007FFFBD1F0000 00007FFFBD201FFF 00012000
* winhttp 00007FFFB29F0000 00007FFFB2AB4FFF 000c5000
* dhcpcsvc6 00007FFFBD770000 00007FFFBD783FFF 00014000
* dhcpcsvc 00007FFFBD740000 00007FFFBD758FFF 00019000
* System.ni 00007FFFB9040000 00007FFFB9CADFFF 00c6e000
* System 000000000E830000 000000000EB7DFFF 0034e000
* System.Transactions 00007FFFA7640000 00007FFFA7688FFF 00049000
* System.Security.ni 00007FFFB4A90000 00007FFFB4B76FFF 000e7000
* System.Security 000000000B720000 000000000B765FFF 00046000
* System.Xml.ni 00007FFFB7A80000 00007FFFB842FFFF 009b0000
* System.Xml 000000000FA70000 000000000FD05FFF 00296000
* System.Configuration.ni 00007FFFB8430000 00007FFFB855EFFF 0012f000
* System.Configuration 000000000B7C0000 000000000B821FFF 00062000
* System.Core.ni 00007FFFB8560000 00007FFFB8EBCFFF 0095d000
* System.Core 0000000010630000 0000000010765FFF 00136000
* instapi 0000000048060000 000000004806CFFF 0000d000
* MSVCR80 000000005FB30000 000000005FBF8FFF 000c9000
* System.Web.Services 000000000E700000 000000000E7D1FFF 000d2000
* dbghelp 000000005E730000 000000005E8C5FFF 00196000
*
* P1Home: 00000001EE3ECBD0: 00007FFFB4C9C3A0 00000001EE3EC088 00000001EE3ED3E8 0000000100000028 00000002
7F080520 000000027F080048
* P2Home: 00007FFFB4C78C8F: 41000002E0C48148 5B5E5F5C415E415F 909090909090C35D 9090909090909090 C1834838
EC834890 000000282444C7C0
* P3Home: 0000000000000000:
* P4Home: 000000000E42CC50: 0000000000000000 0000FFFF00001FA0 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* P5Home: 0000000000000000:
* P6Home: 00000001A0FC3650: 00007FFFB5982320 0000000100000001 00000001A0FC36D8 00000001C0160FF0 40461E77
00001000 0000000000000000
* ContextFlags: 000000000010005F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 000000
0000000000 0000000000000000
* MxCsr: 0000000000001FA0:
* SegCs: 0000000000000033:
* SegDs: 000000000000002B:
* SegEs: 000000000000002B:
* SegFs: 0000000000000053:
* SegGs: 000000000000002B:
* SegSs: 000000000000002B:
* EFlags: 0000000000010246:
* Rax: 0000000000000000:
* Rcx: 0000000000000000:
* Rdx: 0000000002020E91:
* Rbx: 0000000000000000:
* Rsp: 000000000E42D260: 0000000000000000 000000000E42D348 00000001F6180760 0000000000000000 00000000
0E42D2F8 000000000E42D2F0
* Rbp: 000000000E42D348: 0000A39500C268AC 0EA330E90000000B FFFFFFFFFFFFFFFF 0000000100000001 00007FFF
9D66E4AC 0000000000000002
* Rsi: 00000001F6180760: 00007FFFB598D750 0000000168C7E040 00000001A41D09D0 FFFFFFFF00000001 00000001
F6180780 00000001F6180780
* Rdi: 0000000000000000:
* R8: 0000000000000007:
* R9: 000000000000000E:
* R10: 000000000000000E:
* R11: 000000000E42D250: 0000000000000000 00007FFF9E428860 0000000000000000 000000000E42D348 00000001
F6180760 0000000000000000
* R12: 0000000000000001:
* R13: 000000000EA330E9: 05876700000003B1 8500000003B8A000 000003B1D9000586 03B6300001E7F400 A60003AE
3F000000 021C7500000003B8
* R14: 0000000000000000:
* R15: 00000001F61807D0: 00007FFF9D64D7E8 0000000000000000 0000000000000000 403CFE1200000000 00000000
00000000 0000000000000000
* Rip: 00007FFF9E428866: 453B0852FF108B48 8B48138B481E750C 117508453B12FFCB 52FFCB8B48138B48 7401B000
453B4848 5C8D4CC6B60F4104
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
00007FFF9E428866 Module(sqllang+0000000000DE8866)
00007FFF9DB8B4CF Module(sqllang+000000000054B4CF)
00007FFF9D673034 Module(sqllang+0000000000033034)
00007FFF9D673598 Module(sqllang+0000000000033598)
00007FFF9D69CAEE Module(sqllang+000000000005CAEE)
00007FFF9D69C9A9 Module(sqllang+000000000005C9A9)
00007FFF9D6503B1 Module(sqllang+00000000000103B1)
00007FFF9D66A58B Module(sqllang+000000000002A58B)
00007FFF9D669CC4 Module(sqllang+0000000000029CC4)
00007FFF9E4FCA51 Module(sqllang+0000000000EBCA51)
00007FFF9E4FC4C5 Module(sqllang+0000000000EBC4C5)
00007FFF9E4F9DC8 Module(sqllang+0000000000EB9DC8)
00007FFF9D6503B1 Module(sqllang+00000000000103B1)
00007FFF9D66A58B Module(sqllang+000000000002A58B)
00007FFF9D669CC4 Module(sqllang+0000000000029CC4)
00007FFF9D68EE4C Module(sqllang+000000000004EE4C)
00007FFF9D684827 Module(sqllang+0000000000044827)
00007FFFB4C73740 Module(sqldk+0000000000013740)
00007FFFB4C73BE4 Module(sqldk+0000000000013BE4)
00007FFFB4C739E7 Module(sqldk+00000000000139E7)
00007FFFB4CA1D3F Module(sqldk+0000000000041D3F)
00007FFFB4CA24A0 Module(sqldk+00000000000424A0)
00007FFFB4CA32EB Module(sqldk+00000000000432EB)
00007FFFB4CA1B68 Module(sqldk+0000000000041B68)
00007FFFC28E16AD Module(KERNEL32+00000000000016AD)
00007FFFC37A34A5 Module(ntdll+00000000000734A5)

CSession @0x00000001E7D42450
----------------------------
m_sessionId = 54 m_cRef = 14 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x00000001E7D42040
m_pstackBhfPool = 0x00000001E7D63910 m_dwLoginFlags = 0x83e0 m_fBackground = 0
m_eConnResetOption = 0 m_fUserProc = 1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 10307205 m_eclClient = 7 m_protType = 5
m_hHttpToken = FFFFFFFFFFFFFFFF

m_pV7LoginRec
---------------------
0000000000000000: fe070000 04000074 00100000 00000006 f4190000 þ......t........ô...

0000000000000014: 00000000 e0830000 00000000 00000000 5e000b00 ....àƒ..........^...

0000000000000028: 00000000 00000000 74002e00 d0000600 dc000000 ........t...Ð...Ü...

000000000000003C: dc001c00 14010000 14010400 b4a228f6 2dfe1c01 Ü...........´¢(ö-þ..

0000000000000050: e206fe07 0000fe07 00000000 0000 â.þ...þ.......




CPhysicalConnection @0x00000001E7D42230
---------------------------------------
m_pPhyConn->m_pmo = 0x00000001E7D42040
m_pPhyConn->m_pNetConn = 0x00000001E7D42BF0
m_pPhyConn->m_pConnList = 0x00000001E7D42420
m_pPhyConn->m_pSess = 0x00000001E7D424A8 m_pPhyConn->m_fTracked = -1
m_pPhyConn->m_cbPacketsize = 4096 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0


CBatch @0x00000001E7D43140
--------------------------
m_pSess = 0x00000001E7D42450 m_pConn = 0x00000001E7D43020 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x00000002547D1C38


EXCEPT (null) @0x000000000E429E50
---------------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x00007FFFB4D2F260



Task @0x00000002547D1C38
------------------------
CPU Ticks used (ms) = 0 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x0000000000000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000 SchedulerId = 0x1
ThreadId = 0x53fc m_state = 0 m_eAbortSev = 0



EC @0x00000001E7D62DD0
----------------------
spid = 0 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 ecType = 0
__pSETLS = 0x00000001E7D43090 __pSEParams = 0x00000001E7D43520

SEInternalTLS @0x00000001E7D43090
---------------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x00000002547D1C38
m_activeHeapDatasetList = 0x00000001E7D43090
m_activeIndexDatasetList = 0x00000001E7D430A0 m_pDbccContext = 0x0000000000000000
m_pAllocFileLimit = 0x0000000000000000 m_dekInstanceIndex = 0x-1
m_pImbiContext = 0x0000000000000000

SEParams @0x00000001E7D43520
----------------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x00000002711251E0
m_execStats = 0x00000002753148C8
28 авг 14, 12:24    [16506207]     Ответить | Цитировать Сообщить модератору
 Re: Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Crimean
Member

Откуда:
Сообщений: 13147
ловил такое на 12 сервере. при определенных раскладах - дампится на сиквенсах. подтверждаю.
28 авг 14, 12:46    [16506361]     Ответить | Цитировать Сообщить модератору
Между сообщениями интервал более 1 года.
 Re: Непонятная проблема с SEQUENCE в DEFAULT CONSTRAINT  [new]
Dmitry Andreev
Member

Откуда:
Сообщений: 1
Добрый день.
Лечится установкой последнего CU.
https://support.microsoft.com/en-us/kb/3068703
14 окт 15, 13:10    [18277327]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить