PG数据插入数据报错

Expect-乐 2021-03-09 05:15:08

报错日志如下：

### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: insufficient data left in message

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: insert into sqltext values (210500003,'2021-03-09 17:05:28.687000','0x020000007cdd473871aa03d39a8a9df0291022e6d8d96c2f','FETCH API_CURSOR000000000115C10C')

### Cause: org.postgresql.util.PSQLException: ERROR: insufficient data left in message

org.apache.ibatis.exceptions.PersistenceException: 

### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: insufficient data left in message

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: insert into sqltext values (210500003,'2021-03-09 17:05:28.687000','0x020000007cdd473871aa03d39a8a9df0291022e6d8d96c2f','FETCH API_CURSOR000000000115C10C')

### Cause: org.postgresql.util.PSQLException: ERROR: insufficient data left in message

        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)

        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)

        at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)

        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)

        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)

        at com.sun.proxy.$Proxy97.insert2table(Unknown Source)

        at com.dfc.util.CommonUtils.insertTable(CommonUtils.java:131)

        at com.dfc.ScriptExecutor.DcV1.parsejson(DcV1.java:51)

        at com.dfc.ScriptExecutor.DcV1.check(DcV1.java:32)

        at com.dfc.ScriptExecutor.DcExecutor.analyse(DcExecutor.java:56)

        at com.dfc.ScriptExecutor.DcExecutor.execute(DcExecutor.java:22)

        at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:483)

        at com.rt.job.executor.service.jobhandler.GeneralRtScriptJobs.GeneralRtScriptHandler.execute(GeneralRtScriptHandler.java:55)

        at com.rt.job.core.thread.JobThread.run(JobThread.java:75)

        at com.rt.job.core.thread.NormalJobThread.run(NormalJobThread.java:23)

Caused by: org.postgresql.util.PSQLException: ERROR: insufficient data left in message

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)

        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)

        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)

        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)

        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)

        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)

        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)

        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)

        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)

        ... 15 more