javeme commented on PR #1897:
URL:
https://github.com/apache/incubator-hugegraph/pull/1897#issuecomment-1147109313
postgresql java11 ci:
```java
Error: -06 05:47:41 [main] [ERROR] c.b.h.b.Transaction - Failed to commit
changes:
com.baidu.hugegraph.backend.BackendException: Failed to commit
at
com.baidu.hugegraph.backend.store.mysql.MysqlSessions$Session.commit(MysqlSessions.java:438)
~[classes/:?]
at
com.baidu.hugegraph.backend.store.mysql.MysqlStore.commitTx(MysqlStore.java:308)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.AbstractTransaction.commitMutation2Backend(AbstractTransaction.java:322)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.IndexableTransaction.commit2Backend(IndexableTransaction.java:57)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.AbstractTransaction.commit(AbstractTransaction.java:238)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.AbstractTransaction.commitOrRollback(AbstractTransaction.java:377)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.AbstractTransaction.afterWrite(AbstractTransaction.java:344)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.SchemaTransaction.saveSchema(SchemaTransaction.java:448)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.SchemaTransaction.updateSchema(SchemaTransaction.java:406)
~[classes/:?]
at
com.baidu.hugegraph.backend.cache.CachedSchemaTransaction.updateSchema(CachedSchemaTransaction.java:216)
~[classes/:?]
at
com.baidu.hugegraph.backend.tx.SchemaTransaction.updatePropertyKey(SchemaTransaction.java:136)
~[classes/:?]
at
com.baidu.hugegraph.StandardHugeGraph.updatePropertyKey(StandardHugeGraph.java:720)
~[classes/:?]
at
com.baidu.hugegraph.schema.builder.PropertyKeyBuilder.append(PropertyKeyBuilder.java:197)
~[classes/:?]
at
com.baidu.hugegraph.schema.builder.PropertyKeyBuilder.append(PropertyKeyBuilder.java:46)
~[classes/:?]
at
com.baidu.hugegraph.core.PropertyKeyCoreTest.testAppendPropertyKeyWithUserdata(PropertyKeyCoreTest.java:611)
~[classes/:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:?]
at
jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
~[junit-4.12.jar:4.12]
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
~[junit-4.12.jar:4.12]
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
~[junit-4.12.jar:4.12]
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
~[junit-4.12.jar:4.12]
at org.junit.runners.Suite.runChild(Suite.java:128)
~[junit-4.12.jar:4.12]
at org.junit.runners.Suite.runChild(Suite.java:27)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
~[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
~[junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
~[junit-4.12.jar:4.12]
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
~[surefire-junit4-2.20.jar:2.20]
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:272)
~[surefire-junit4-2.20.jar:2.20]
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:236)
~[surefire-junit4-2.20.jar:2.20]
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
~[surefire-junit4-2.20.jar:2.20]
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:386)
~[surefire-booter-2.20.jar:2.20]
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:323)
~[surefire-booter-2.20.jar:2.20]
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:143)
~[surefire-booter-2.20.jar:2.20]
Caused by: java.sql.BatchUpdateException: Batch entry 0 UPDATE pk SET
NAME='age', STATUS=1, CARDINALITY=1, DATA_TYPE=8, AGGREGATE_TYPE=0,
PROPERTIES='[]', USER_DATA='{"max":100,"~create_time":"2022-06-06
05:47:41.879","min":1}', WRITE_TYPE=1, WHERE ID=15 was aborted: ERROR: syntax
error at or near "WHERE"
Position: 129 Call getNextException to see other errors in the batch.
at
org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:50)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2191)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:472)
~[postgresql-42.1.4.jar:42.1.4]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1563)
~[postgresql-42.1.4.jar:42.1.4]
at
com.baidu.hugegraph.backend.store.mysql.MysqlSessions$Session.commit(MysqlSessions.java:433)
~[classes/:?]
... 50 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"WHERE"
Position: 129
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:472)
~[postgresql-42.1.4.jar:42.1.4]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1563)
~[postgresql-42.1.4.jar:42.1.4]
at
com.baidu.hugegraph.backend.store.mysql.MysqlSessions$Session.commit(MysqlSessions.java:433)
~[classes/:?]
... 50 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
