Stack overflow using with postgresql about znetcs.aspnetcore.logging.entityframeworkcore HOT 6 CLOSED

There should not be any issue with postgress.

However there can be issue with global logging configuration. If you are not using any filters for this logger and adding it in the same way as AddDebug or AddConsole, you can have such problem, because EF Core is using logging internally, so it tries to use logger which depends on it.
Try add and use logging filters and exclude all Entity Framework Core logs from storing them in database.
See https://github.com/msmolka/ZNetCS.AspNetCore.Logging.EntityFrameworkCore/blob/master/test/ZNetCS.AspNetCore.Logging.EntityFrameworkCoreTest/StartupSimple.cs, as example.

In short you should exclude any EFC internal logging from being handled by this logger. Let me know if this filter works.

from znetcs.aspnetcore.logging.entityframeworkcore.

If you still have issue with logger after exclude EF Core logs from logger please provide small example and I will try to analyse and solve.
I personally tested it with MySQL, MariaDB, SQL Server, InMemory databases and it worked.

from znetcs.aspnetcore.logging.entityframeworkcore.

It wasn't working anyway so I created my own logger.

Thank you for the attention.

from znetcs.aspnetcore.logging.entityframeworkcore.

I was wonder what was wrong, in my opinion all should work. But ok, closing.

from znetcs.aspnetcore.logging.entityframeworkcore.

If anyone is interested, suggested solution from @msmolka works.

I had the same problems reported by @mateusleonardi with different databases (mariadb, sql server and sqlite), giving different errors but anyway not working (working fine where i removed database logging).

If i add a filter to ignore microsoft and system logs (and add "Microsoft.Extensions.Logging.Filter" to dependencies) everything works fine (both app and database logs)

edit: you can find a sample working project at https://github.com/pdesterlich/LoggingTest

from znetcs.aspnetcore.logging.entityframeworkcore.

@pdesterlich thank for more testing and confirmation. I'm using this library on daily basis and the only issue is to make sure you are not logging (using this logger) anything related to Microsoft.EntityFrameworkCore.
This is because each log of EFCore will cause to log. So obviously Stack Overflow

from znetcs.aspnetcore.logging.entityframeworkcore.