[bug] 5.0.1版本存在异常

[li-zheng-hao]

2022-09-01 15:06:30,237 INFO  - 程序启动
2022-09-01 15:06:30,540 INFO  - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2022-09-01 15:06:30,549 INFO  - CREATE TABLE "ProgramDB"(
"Id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"Data" varchar(255) NOT NULL  ,
"CreateTime" datetime NOT NULL    )
2022-09-01 15:06:30,552 INFO  - SELECT count(*) FROM sqlite_master WHERE name = 'index_programdb_createtime'
2022-09-01 15:06:30,559 INFO  - CREATE  INDEX index_programdb_createtime ON ProgramDB(CreateTime Asc)
2022-09-01 15:06:30,579 INFO  - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2022-09-01 15:06:30,590 INFO  - CREATE TABLE "WindowsDataDB"(
"Id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"Data" blob NOT NULL  ,
"ProgramDataId" integer NOT NULL  ,
"WindowId" varchar(255) NOT NULL    )
2022-09-01 15:06:30,595 INFO  - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2022-09-01 15:06:30,596 INFO  - CREATE TABLE "Versions"(
"Id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"MajorVersion" integer NOT NULL  ,
"MinorVersion" integer NOT NULL  ,
"BuildVersion" integer NOT NULL  ,
"Version" varchar(255) NOT NULL  ,
"PublishTime" datetime NOT NULL    )
2022-09-01 15:06:30,659 INFO  - SELECT `Id`,`Data`,`CreateTime` FROM `ProgramDB`    ORDER BY `CreateTime` DESC LIMIT 0,1
2022-09-01 15:06:30,667 ERROR - 未将对象引用设置到对象的实例。
2022-09-01 15:06:36,405 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:06:36,422 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:06:36,425 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:06:41,323 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:06:41,329 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:06:46,323 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:06:46,332 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:06:46,334 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:06:51,331 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:06:51,337 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:06:51,337 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:06:56,337 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:06:56,343 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:06:56,344 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:07:01,337 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:07:01,340 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:07:04,415 ERROR -    在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   在 GalaSoft.MvvmLight.Helpers.WeakAction`1.Execute(T parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight (PCL)\Helpers\WeakActionGeneric.cs:行号 226
   在 GalaSoft.MvvmLight.Command.RelayCommand`1.Execute(Object parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight (PCL)\Command\RelayCommandGeneric.cs:行号 249
   在 GalaSoft.MvvmLight.Command.EventToCommand.Invoke(Object parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight.Platform (NET45)\Command\EventToCommand.cs:行号 370
   在 System.Windows.Interactivity.TriggerBase.InvokeActions(Object parameter)
   在 System.Windows.Interactivity.EventTriggerBase.OnEvent(EventArgs eventArgs)
   在 System.Windows.Interactivity.EventTriggerBase.OnEventImpl(Object sender, EventArgs eventArgs)
   在 System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   在 System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   在 System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   在 System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   在 System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   在 System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   在 System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   在 System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   在 System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   在 System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   在 System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   在 System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   在 System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   在 System.Windows.Input.InputManager.ProcessStagingArea()
   在 System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   在 System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   在 System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   在 System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   在 System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   在 System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
2022-09-01 15:07:04,415 ERROR - 调用的目标发生了异常。
2022-09-01 15:07:06,338 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:07:06,346 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:07:06,347 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:07:11,344 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:07:11,349 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:07:11,350 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data
2022-09-01 15:07:13,851 ERROR -    在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   在 GalaSoft.MvvmLight.Helpers.WeakAction`1.Execute(T parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight (PCL)\Helpers\WeakActionGeneric.cs:行号 226
   在 GalaSoft.MvvmLight.Command.RelayCommand`1.Execute(Object parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight (PCL)\Command\RelayCommandGeneric.cs:行号 249
   在 GalaSoft.MvvmLight.Command.EventToCommand.Invoke(Object parameter) 位置 C:\Users\lbugn\Documents\MVVMLight\GalaSoft.MvvmLight\GalaSoft.MvvmLight.Platform (NET45)\Command\EventToCommand.cs:行号 370
   在 System.Windows.Interactivity.TriggerBase.InvokeActions(Object parameter)
   在 System.Windows.Interactivity.EventTriggerBase.OnEvent(EventArgs eventArgs)
   在 System.Windows.Interactivity.EventTriggerBase.OnEventImpl(Object sender, EventArgs eventArgs)
   在 System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   在 System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   在 System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   在 System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   在 System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   在 System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   在 System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   在 System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   在 System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   在 System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   在 System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   在 System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   在 System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   在 System.Windows.Input.InputManager.ProcessStagingArea()
   在 System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   在 System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   在 System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   在 System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   在 MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   在 System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   在 System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   在 System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   在 MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   在 MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   在 System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   在 System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
   在 System.Windows.Application.RunDispatcher(Object ignore)
   在 System.Windows.Application.RunInternal(Window window)
   在 System.Windows.Application.Run(Window window)
   在 StickyNotes.App.Main()
2022-09-01 15:07:13,851 ERROR - 调用的目标发生了异常。
2022-09-01 15:07:17,670 INFO  - INSERT INTO `ProgramDB`  
           (`Data`,`CreateTime`)
     VALUES
           (@Data,@CreateTime) ;SELECT LAST_INSERT_ROWID();
2022-09-01 15:07:17,674 INFO  - INSERT INTO `WindowsDataDB`  
           (`Data`,`ProgramDataId`,`WindowId`)
     VALUES
           (@Data,@ProgramDataId,@WindowId) ;
2022-09-01 15:07:17,675 ERROR - 定时存储数据时发生异常,异常内容为:constraint failed
NOT NULL constraint failed: WindowsDataDB.Data