I’m trying to upgrade a service to use Hibernate search 6.2.1.Final, for some reason when my spring boot app starts up (against an empty database) it is encountering the error :
Schema-validation: wrong column type encountered in column [id] in table [hsearch_agent]; found [int8 (Types#BIGINT)], but expecting [char(36) (Types#CHAR)]
I’ve no doubt this is something stupid I have somehow done, but I cannot figure out what it is, presumably hibernate search is creating the hsearch_agent table, Postgres version is 12.16
If you are starting an app on an entirely clean database you shouldn’t be getting such errors… What I can suggest is make sure that the database really empty and does not contain those two tables hsearch_outbox_eventhsearch_agent also check your dependencies, make sure you do not have a mix of different versions of Hibernate Search at the same time.
If that does not help, you’d probably need to provide some reproducer so that we could take a look.
Thanks for your input. It turns out that we had a flyway script (unbeknown to me) which created the hsearch… tables manually and so we need to do the migration.
One minor thing is that with the hibernate - ddl-auto: validate it complains that the column should be char(36) and not varchar(36) as per the migration script.
and thanks for the note on column type, we’ll update that.