Serilog MSSQL Sink doesn’t write logs to database

by

Below are some ideas that could help you troubleshoot:

Are you testing with Verbose or Debug events only? That could be the reason. You didn’t specify a global minimum level for Serilog (you only specified for the minimum level for the sink, which acts as a filter), and the default minimum is Information, which means Verbose and Debug are being ignored… Specify the global MinimumLevel for Serilog:

ILogger logger = new LoggerConfiguration()
      .MinimumLevel.Verbose()
      .WriteTo.MSSqlServer(connectionString,
                           tableName,
                           autoCreateSqlTable: autoCreateSqlTable,
                           restrictedToMinimumLevel: LogEventLevel.Verbose,
                           columnOptions: GetSQLSinkColumnOptions(),
                           batchPostingLimit: batchPostingLimit)          
      .CreateLogger();

Are you disposing your logger? Serilog.Sinks.MSSqlServer is a “periodic batching sink”, so you’ll need to make sure you dispose the logger at the end to force it to flush the logs to the database. See Lifecycle of Loggers.

((IDisposable) logger).Dispose();

Even though you’re using 1 for batchPostingLimit, it waits 5 seconds by default before sending the logs to the database. If your app closes before that period and you didn’t dispose the logger, the messages are lost.

For the sake of troubleshooting, use AuditTo instead of WriteTo (and remove the batchPostingLimit which is not applicable for auditing). WriteTo is safe and will eat any exceptions, whilst AuditTo will let exceptions bubble up.

ILogger logger = new LoggerConfiguration()
    .AuditTo.MSSqlServer(
        connectionString,
        tableName,
        restrictedToMinimumLevel: LogEventLevel.Verbose,
        autoCreateSqlTable: true)
    .CreateLogger();

Of course, once you figure out what’s wrong, go back to WriteTo.

More Related Contents:

  1. Serilog – multiple log files
  2. Serilog DI in ASP.NET Core, which ILogger interface to inject?
  3. Filter Serilog logs to different sinks depending on context source?
  4. Capture the Screen into a Bitmap
  5. Create instance of generic type whose constructor requires a parameter?
  6. What is the async/await equivalent of a ThreadPool server?
  7. Why do BCL Collections use struct enumerators, not classes?
  8. How to export a JQgrid data to Excel using c#?
  9. Absolute path back to web-relative path
  10. LINQ to SQL multiple tables left outer join
  11. Set up dot instead of comma in numeric values
  12. How to check if a list is ordered?
  13. Create XML Nodes based on XPath?
  14. Cannot access non-static field
  15. Conditional compilation depending on the framework version in C#
  16. Is there some way to handle async/await behind an ASMX service?
  17. Error 80040154 (Class not registered exception) when initializing VCProjectEngineObject (Microsoft.VisualStudio.VCProjectEngine.dll)
  18. Using Moq to mock an asynchronous method for a unit test
  19. When using a Settings.settings file in .NET, where is the config actually stored?
  20. HttpWebRequest & Native GZip Compression
  21. Can’t see localhost from UWP app
  22. Is there anyway to #define CONSTANT on a solution basis?
  23. Local variable and expression trees
  24. How to convert DateTime in Specific timezone?
  25. What is the difference between Contains and Any in LINQ?
  26. C#: Difference between List and Collection (CA1002, Do not expose generic lists) [duplicate]
  27. Why events can’t be used in the same way in derived classes as in the base class in C#?
  28. Selenium Webdriver PhantomJS C# always opens a cmd window
  29. How to upload large files using MVC 4?
  30. An error occurred attempting to determine the process id of the DNX process hosting your application

Leave a Comment