danhuawang opened a new issue, #9225:
URL: https://github.com/apache/gravitino/issues/9225
### Version
main branch
### Describe what's wrong
Use the script "upgrade-1.0.0-to-1.1.0-postgresql.sql" to upgrade the
gravitino postgresql backend,
then create the hive table with partition definition failed.
It seams the COLUMN table_version_info.partitions in
"upgrade-1.0.0-to-1.1.0-postgresql.sql" is incorrect.
### Error message and/or stacktrace
2025-11-24 08:01:41.137 INFO [Gravitino-webserver-82]
[org.apache.gravitino.catalog.hive.HiveCatalogOperations.loadSchema(HiveCatalogOperations.java:409)]
- Loaded Hive schema (database) auth_hive_schema1 from Hive Metastore
2025-11-24 08:01:41.496 INFO [Gravitino-webserver-82]
[org.apache.gravitino.catalog.hive.HiveCatalogOperations.createTable(HiveCatalogOperations.java:812)]
- Created Hive table a in Hive Metastore
2025-11-24 08:01:41.498 ERROR [Gravitino-webserver-82]
[org.apache.gravitino.catalog.TableOperationDispatcher.internalCreateTable(TableOperationDispatcher.java:680)]
- Failed to put entity for
auth_statistics_test.auth_stats_catalog1.auth_hive_schema1.a in Gravitino, with
this situation the returned object will not contain the metadata from Gravitino.
java.io.IOException: org.postgresql.util.PSQLException: ERROR: column
"partitioning" of relation "table_version_info" does not exist
Position: 63
at
org.apache.gravitino.storage.relational.converters.PostgreSQLExceptionConverter.toGravitinoException(PostgreSQLExceptionConverter.java:44)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.utils.ExceptionUtils.checkSQLException(ExceptionUtils.java:33)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.service.TableMetaService.insertTable_aroundBody6(TableMetaService.java:160)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.service.TableMetaService.insertTable_aroundBody7$advice(TableMetaService.java:73)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.service.TableMetaService.insertTable(TableMetaService.java:1)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.JDBCBackend.insert(JDBCBackend.java:176)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.storage.relational.RelationalEntityStore.put(RelationalEntityStore.java:118)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.catalog.TableOperationDispatcher.internalCreateTable(TableOperationDispatcher.java:672)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.catalog.TableOperationDispatcher.lambda$createTable$8(TableOperationDispatcher.java:191)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.lock.TreeLockUtils.doWithTreeLock(TreeLockUtils.java:49)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.catalog.TableOperationDispatcher.createTable(TableOperationDispatcher.java:187)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.hook.TableHookDispatcher.createTable(TableHookDispatcher.java:83)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.catalog.TableNormalizeDispatcher.createTable(TableNormalizeDispatcher.java:78)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.listener.TableEventDispatcher.createTable(TableEventDispatcher.java:136)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.server.web.rest.TableOperations.lambda$createTable$1(TableOperations.java:141)
~[gravitino-server-1.1.0-SNAPSHOT.jar:?]
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
~[?:?]
at java.base/javax.security.auth.Subject.doAs(Subject.java:439) ~[?:?]
at
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:44)
~[gravitino-core-1.1.0-SNAPSHOT.jar:?]
at org.apache.gravitino.server.web.Utils.doAs(Utils.java:202)
~[gravitino-server-common-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.server.web.rest.TableOperations.createTable(TableOperations.java:133)
~[gravitino-server-1.1.0-SNAPSHOT.jar:?]
at
org.apache.gravitino.server.web.rest.TableOperations_$$_jvste74_0._d3createTable(TableOperations_$$_jvste74_0.java)
~[gravitino-server-1.1.0-SNAPSHOT.jar:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at
org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1268)
~[hk2-utils-2.6.1.jar:?]
at
org.jvnet.hk2.internal.MethodInterceptorHandler$MethodInvocationImpl.proceed(MethodInterceptorHandler.java:164)
~[hk2-locator-2.6.1.jar:?]
at
org.apache.gravitino.server.web.filter.GravitinoInterceptionService$MetadataAuthorizationMethodInterceptor.invoke(GravitinoInterceptionService.java:159)
~[gravitino-server-1.1.0-SNAPSHOT.jar:?]
at
org.jvnet.hk2.internal.MethodInterceptorHandler.invoke(MethodInterceptorHandler.java:97)
~[hk2-locator-2.6.1.jar:?]
at
org.apache.gravitino.server.web.rest.TableOperations_$$_jvste74_0.createTable(TableOperations_$$_jvste74_0.java)
~[gravitino-server-1.1.0-SNAPSHOT.jar:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
### How to reproduce
Use the script "upgrade-1.0.0-to-1.1.0-postgresql.sql" to upgrade the
gravitino postgresql backend,
then create the hive table with partition definition failed
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
