Stack overflow using with postgresql

[mateusleonardi]

Hello,

I'm trying to use this logging with postgresql but when the application starts I get the Stack Overflow Exception.

My entity framework is working fine with postgresql.

Do you know if is possible to use this tool with it?

Thanks in advance.

[msmolka]

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.

[msmolka]

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.

[mateusleonardi]

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

Thank you for the attention.

[msmolka]

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

[pdesterlich]

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

[msmolka]

@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