So I guessed maybe your dbs contain different sequence names. There is a known bug that in such cases your error comes up. See https://hibernate.atlassian.net/browse/HHH-13373 .

During my testing of your demo, I started from empty dbs and found both sequence names are the same, i.e. ‘hibernate_sequence’. So I can launch it successfully.

Could you run the following SQL command to ensure whether the sequence names are different or not?

select table_schema,table_name from information_schema.TABLES where table_type='SEQUENCE';