observer.zip (2.7 MB)
SQL: SELECT id,transfer_auth_type,source_user_id,book_id,work_flow_id,work_flow_code,target_user_id,status,start_time,end_time,is_deleted,create_time,create_by,update_time,update_by FROM t_sys_authorize_cfg WHERE (transfer_auth_type IN (?,?) AND end_time < ?)
Cause: java.sql.SQLTransientConnectionException: (conn=1572944) Parameter at position 3 is not set
; (conn=1572944) Parameter at position 3 is not set; nested exception is java.sql.SQLTransientConnectionException: (conn=1572944) Parameter at position 3 is not set
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:70) ~[spring-jdbc-5.2.9.RELEASE.jar:5.2.9.RELEASE]
还有这个错：
SQL: select id from t_sys_book t where t.is_deleted = false and book_tree_id in ( WITH RECURSIVE sub_book AS ( SELECT id FROM t_sys_book_gro WHERE id in (select book_tree_id from t_sys_book_gro_user_cfg where is_deleted =false and user_id in ( ? ) AND is_trade_available = ? )AND is_deleted = false UNION SELECT d.id FROM t_sys_book_gro d INNER JOIN sub_book s ON s.id = d.parent_id) SELECT * FROM sub_book b)
Cause: java.sql.SQLTransientConnectionException: (conn=1572944) recursive WITH clause must use a UNION ALL operation
; (conn=1572944) recursive WITH clause must use a UNION ALL operation; nested exception is java.sql.SQLTransientConnectionException: (conn=1572944) recursive WITH clause must use a UNION ALL operation
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:70) ~[spring-jdbc-5.2.9.RELEASE.jar:5.2.9.RELEASE]
