-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Closed
Labels
Postgres WireIssues or changes relating to Postgres wire protocolIssues or changes relating to Postgres wire protocol
Description
The error message is:
Exception in thread "pool-3-thread-1" org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: table busy [reason=insert]
### The error may involve com.secusoft.mapper.quest.CameraAccessDetailsMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into camera_access_details_1_20211016 values (72, to_timestamp('2021-10-16 22:06:00','yyyy-MM-dd HH:mm:ss'),to_timestamp('2021-10-16 22:07:00','yyyy-MM-dd HH:mm:ss'), 0, 0)
### Cause: org.postgresql.util.PSQLException: ERROR: table busy [reason=insert]
; uncategorized SQLException for SQL []; SQL state [00000]; error code [0]; ERROR: table busy [reason=insert]; nested exception is org.postgresql.util.PSQLException: ERROR: table busy [reason=insert]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
at com.sun.proxy.$Proxy89.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:279)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:56)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy101.insert(Unknown Source)
at com.secusoft.service.impl.quest.CameraAccessDetailsServiceImpl.insert(CameraAccessDetailsServiceImpl.java:341)
at com.secusoft.service.impl.quest.CameraAccessDetailsServiceImpl$$FastClassBySpringCGLIB$$2703e86a.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Postgres WireIssues or changes relating to Postgres wire protocolIssues or changes relating to Postgres wire protocol