I’m trying out Hangfire Core with postgresql on .net Core 3.1. I use the latest versions of Hangfire and Hangfire.PostgreSql. I didn’t create a new database for this; instead, I connect Hangfire to an existing postgres db which is in version 13.8.
I followed the instruction steps listed in the Getting Started > Asp.net Core App section. The Hangfire related tables were created successfully under new “Hangfire” schema and I was able to get the Dashboard to display fine. However, as soon as I added the line to queue a background job (Console.WriteLine command), I got this error:
Hangfire.BackgroundJobClientException: Background job creation failed. See inner exception for details. ---> Npgsql.PostgresException (0x80004005): 42804: column "invocationdata" is of type jsonb but expression is of type text.
I also noticed other similar error in my VS output panel but on a different column.
Npgsql.PostgresException (0x80004005): 42804: column "data" is of type jsonb but expression is of type text
I also tried using older versions Hangfire 1.7.31 & Hangfire.PostgreSql 1.8.6, but I ran into the same exception as well.
Had anyone run into the same issue and how to solve it?
Thank you in advance!