【BOS基础系统_权限】SHR提交入职单报错

SHR提交入职单报错，web前端提示的报错堆栈大致：Caused exception message is: Transaction[XID:48ED3162C2AE4FEA9C712FAD8355D3B1/48ED3162C2AE4FEA9C712FAD8355D3B1] has been marked ROLLBACK ONLY somewhere!

下载并查看apusic.log发现原因

1、更新t_bas_comfuncmenucache表发送死锁

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected

  Detail: Process 10019251 waits for ShareLock on transaction 16642521; blocked by process 10022369.

Process 10022369 waits for ShareLock on transaction 16642550; blocked by process 10019251.

  Hint: See server log for query details.

  Where: while updating tuple (5037,88) in relation "t_bas_comfuncmenucache"

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:480)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at com.kingdee.eas.base.uiframe.utils.MenuDbUtil.execute(MenuDbUtil.java:57)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at com.kingdee.eas.base.uiframe.utils.CustMenuAutoUpdateForDB.updateAllUserComMenuCach(CustMenuAutoUpdateForDB.java:449)

2021-10-19 09:50:30 閿欒 [con.err-Thread 339] at com.kingdee.eas.base.uiframe.app.MainFunctionMenuControllerBean._updateAllUserComMenuCach(MainFunctionMenuControllerBean.java:2419)

...........

2、于是抛异常，内