CrateDB 5.5 not working out of the box with Npgsql 8: A PostgreSQL type with the name 'unknown' was not found in the current database info

Integrations Client Libraries
1

Hello,

It is the same issue as the one raised on the Npgsql Github. When trying to connect an error will be raised claiming a type with the name unknown was not found.

The solution of disabling type loading works however, but this might have unwanted consequences?

Worth investigating and adding here: cratedb-examples/by-language/csharp-npgsql at main · crate/cratedb-examples · GitHub

1 Like
2

Dear Jonas,

thank you for writing in and for reporting this problem. We already recognized it on behalf of our QA suite at Update to npgsql 8.0.0 by amotl · Pull Request #289 · crate/crate-qa · GitHub, but we didn’t manage to take care about it, yet.

Do you know about any more details whether “A PostgreSQL type with the name ‘unknown’” refers to a certain type, or whether it is a general error?

With kind regards,
Andreas.

3

Hi Andreas,

It is a certain type, happens upon opening the connection. Apparently, since .NET 8 they introducted a dependency on the “unkown” type, as seen here:

They assume it’s standard for pg-like databases, cratedb doesn’t have one?

Thanks!
Jonas

1 Like
4

Hi Jonas,

excellent, thank you so much for referring us to this conversation. That will certainly help to provide better guidance for the database engineers. I will forward it into a corresponding issue at crate/crate.

With kind regards,
Andreas.

1 Like
5

Hi again,

Here we go.

With kind regards,
Andreas.

1 Like
6

Dear Jonas,

the issue was resolved on behalf of a fix to CrateDB.

Thank you again for pointing us to the relevant conversation on GitHub. :blue_heart:

Cheers,
Andreas.

1 Like
7

Thanks a lot Andreas, that was fast :slight_smile:

1 Like
8

Thank you. Forwarding the kudos to @mfussenegger for fixing this so quickly.