search

ap0405140 / MSSQLLogAnalyzer

Microsoft SQL Server Log Analyzer. DBLOG.DatabaseLogAnalyzer can read the SQL Server transaction logs online, and return RedoSQL and UndoSQL for every transaction. It base on SQL Server fn_dblog() function and develop some extension.
MIT License
142 stars 39 forks source link

好像最新的版本有问题 #8

Open sunxq86 opened 2 years ago

sunxq86 commented 2 years ago

DBLOG_DML.cs 1212行 BitConverter.ToInt16(rowdata, index); 1242行 if (rowdata.Length > VarColumnEndIndex) { throw new Exception(); }

4月12号我发你邮件了。

ap0405140 commented 2 years ago

你好, 这个需有实际环境才能分析, 如果方便的话, 可以把测试的数据库备份发给我分析看看, 谢谢.

sunxq86 commented 2 years ago

邮件已回

ap0405140 commented 2 years ago

没收到喔?

sunxq86 commented 2 years ago

@. ----- 原始邮件 ----- 发件人：唐诗三百首 @.> 收件人：ap0405140/MSSQLLogAnalyzer @.> 抄送人：sunxq86 @.>, Author @.***> 主题：Re:_[ap0405140/MSSQLLogAnalyzer]好像最新的版本有问题(Issue_#8) 日期：2022年05月24日 09点05分

没收到喔?

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

sunxq86 commented 2 years ago

您好！我随便写了测试数据就不行了create table xxxx(id uniqueidentifier,name nvarchar(200),createtime datetime) insert into xxxx values (newid(),'dds',getdate())insert into xxxx values (newid(),'dds',getdate())insert into xxxx values (newid(),'dds',getdate())

数据库版本：Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64) Mar 22 2021 18:10:24 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor) 程序详见附件：

----- 原始邮件 ----- 发件人：唐诗三百首 @.> 收件人：ap0405140/MSSQLLogAnalyzer @.> 抄送人：sunxq86 @.>, Author @.> 主题：Re:_[ap0405140/MSSQLLogAnalyzer]好像最新的版本有问题(Issue_#8) 日期：2022年05月21日 09点47分

你好, 这个需有实际环境才能分析, 如果方便的话, 可以把测试的数据库备份发给我分析看看, 谢谢.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

ap0405140 commented 1 year ago

以上SQL, 我试了能正常解析.