# # # Cause: org. Postgresql. Util. PSQLException: ERROR: out of Shared memory
ヒ ン ト : You took the need to happens max_locks_per_transaction.
; [SQL]; ERROR: out of Shared memory
ヒ ン ト : You took the need to happens max_locks_per_transaction.; Nested exception is org. Postgresql. Util. PSQLException: ERROR: out of Shared memory
ヒ ン ト : You took the need to happens max_locks_per_transaction.
The at org. Springframework. JDBC. Support. SQLErrorCodeSQLExceptionTranslator. DoTranslate (SQLErrorCodeSQLExceptionTranslator. Java: 253)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 72)
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 74)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 399)
Project to do recently, in order to improve the performance of the use of the create temp table TABLE_NAME on commit drop statement,
But the recent discovery in the process of project operation frequent errors in the LOG, at first thought it was caused by lock is much, but in subsequent modules in the survey is very simple, a person also can appear the wrong operation, and the error appears only when create temporary tables,
Have a great god know what's going on, haven't a clue, change the value of max_locks_per_transaction still cannot solve the problem,
CodePudding user response:
Try to raise this parameter shard_memory