metalshanked commented on issue #6380:
URL: https://github.com/apache/gravitino/issues/6380#issuecomment-2635066782
I see below error
```
### The error may exist in
org/apache/gravitino/storage/relational/mapper/ModelVersionMetaMapper.java
(best guess)
### The error may involve
org.apache.gravitino.storage.relational.mapper.ModelVersionMetaMapper.deleteModelVersionMetasByLegacyTimeline-Inline
### The error occurred while setting parameters
### SQL: DELETE FROM model_version_info WHERE deleted_at > 0 AND deleted_at
< ? LIMIT ?
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"LIMIT"
Position: 73
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:212)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:72)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
~[mybatis-3.5.6.jar:3.5.6]
at
jdk.proxy2/jdk.proxy2.$Proxy81.deleteModelVersionMetasByLegacyTimeline(Unknown
Source) ~[?:?]
at
org.apache.gravitino.storage.relational.service.ModelVersionMetaService.lambda$deleteModelVersionMetasByLegacyTimeline$16(ModelVersionMetaService.java:240)
~[gravitino-core-0.8.0-incubating.jar:?]
at
org.apache.gravitino.storage.relational.utils.SessionUtils.doWithoutCommitAndFetchResult(SessionUtils.java:92)
~[gravitino-core-0.8.0-incubating.jar:?]
at
org.apache.gravitino.storage.relational.service.ModelVersionMetaService.lambda$deleteModelVersionMetasByLegacyTimeline$17(ModelVersionMetaService.java:237)
~[gravitino-core-0.8.0-incubating.jar:?]
at
java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992)
~[?:?]
at
java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762)
~[?:?]
at
org.apache.gravitino.storage.relational.utils.SessionUtils.doMultipleWithCommit(SessionUtils.java:140)
~[gravitino-core-0.8.0-incubating.jar:?]
at
org.apache.gravitino.storage.relational.service.ModelVersionMetaService.deleteModelVersionMetasByLegacyTimeline(ModelVersionMetaService.java:234)
~[gravitino-core-0.8.0-incubating.jar:?]
at
org.apache.gravitino.storage.relational.JDBCBackend.hardDeleteLegacyData(JDBCBackend.java:334)
~[gravitino-core-0.8.0-incubating.jar:?]
at
org.apache.gravitino.storage.relational.RelationalGarbageCollector.collectAndClean(RelationalGarbageCollector.java:86)
~[gravitino-core-0.8.0-incubating.jar:?]
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
[?:?]
at
java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) [?:?]
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
[?:?]
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
[?:?]
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[?:?]
at java.base/java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"LIMIT"
Position: 73
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
~[postgresql-42.7.5.jar:42.7.5]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
~[postgresql-42.7.5.jar:42.7.5]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
~[postgresql-42.7.5.jar:42.7.5]
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
~[postgresql-42.7.5.jar:42.7.5]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
~[postgresql-42.7.5.jar:42.7.5]
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
~[postgresql-42.7.5.jar:42.7.5]
at
org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
~[postgresql-42.7.5.jar:42.7.5]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)
~[commons-dbcp2-2.11.0.jar:2.11.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)
~[commons-dbcp2-2.11.0.jar:2.11.0]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
~[mybatis-3.5.6.jar:3.5.6]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
~[mybatis-3.5.6.jar:3.5.6]
... 20 more
```
--
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: commits-unsubscr...@gravitino.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
