hibernate_sequence table on MySQL does not define a Primary Key Column on MySQL / MariaDB and Galera cluster (Using GenerationType.AUTO or GenerationType.TABLE) Every InnoDB Table on Galera needs a primary key, therefore setting Galera "innodb_force_primary_key = 1" is strongly recommended for a fully functional cluster. See http://galeracluster.com/documentation-webpages/limitations.html#tables-without-primary-keys If DDL is executed, you will therefore receive error "This table type requires a primary key". Using GenerationType.IDENTITY is not always possible (db agnostic applications, TABLE_PER_CLASS hierarchy), so this should be fixed. |