Paweł Pinkos (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c0e39f...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzE3NjU1Y2E0...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-13954?atlOrigin=eyJpIjoiMzE3Nj...
) HHH-13954 (
https://hibernate.atlassian.net/browse/HHH-13954?atlOrigin=eyJpIjoiMzE3Nj...
) PostgreSQL - partitioned table: Schema-validation: missing table (when table exists) (
https://hibernate.atlassian.net/browse/HHH-13954?atlOrigin=eyJpIjoiMzE3Nj...
)
Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 17/Apr/2020 00:35
AM Priority: Major Reporter: Paweł Pinkos (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c0e39f...
)
Hibernate do not support partitioned tables in PostgreSQL 11
There is issue with supported metadata types. Under validation hibernate looking for
["TABLE","VIEW"] object type from database metadata. But postgresql in
case of partirioned table return type "PARTITIONED TABLE".
If ddl policy for hibernate is "validate" - then application failed under
deploy.
If "update" then hibernate trying create table but get error from database
"Table already exists"
Accepted types are hardcoded in (line number: 84,85):
org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl
https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src...
Stacktrace below:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name
'entityManagerFactory' defined in class path resource
[org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class] :
Invocation of init method failed; nested exception is
javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build
Hibernate SessionFactory; nested exception is
org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table
[xxx.xyz]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108)
~ [spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)
~ [spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
~ [spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
~ [spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
at com.orange.rms.dl.Application.main(Application.java:12) [classes/:na]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to
build Hibernate SessionFactory; nested exception is
org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table
[xxx.xyz]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:403)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792)
~ [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
... 16 common frames omitted
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation:
missing table [xxx.xyz]
at
org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:121)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:42)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:89)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:68)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:192)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314) ~
[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:468)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1237)
~ [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at
org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391)
~ [spring-orm-5.2.5.RELEASE.jar:5.2.5.RELEASE]
... 20 common frames omitted
(
https://hibernate.atlassian.net/browse/HHH-13954#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-13954#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )