Solution to housekeeper's connection to active time is too long to be disconnected from MySQL

[Warn] housekeeper 11:52:17, 781 Org. logicalcobwebs. proxool. mysql-#0005 was active for 3634735 milliseconds and has been removed automaticaly. the thread responsible was named 'HTTP-7085-processor22 ', and the last SQL it stored med is 'insert into workitem (actor_id, actor_name, comments, created_time, end_time, signed_time, state, taskinstance_id, type_name) values (76, 'zhang san', null, '13-January 1, May-2010.11: 51: 30', null, null, 0,295, 'review ');'.
[Info] http-7085-Processor22 11:52:54, 687 com. fsti. infopriv. Service. impl. workflowserviceimpl-SMS sending failed 1
[Info] http-7085-Processor22 11:52:54, 687 com. fsti. infopriv. Service. impl. workflowserviceimpl-Dispatch ticket --> 76: Michael Zhang succeeded
[Error] http-7085-Processor22 11:52:55, 296 org. springframework. transaction. Interceptor. transactioninterceptor-application exception overridden by rollback exception
Org. springframework. Orm. hibernate3.hibernatejdbcexception: JDBC exception on Hibernate Data Access: sqlexception for SQL [update taskinstance set activity_id = ?, Assignment_strategy = ?, Biz_type = ?, Created_time = ?, Display_name = ?, End_time = ?, Expired_time = ?, From_task_id = ?, Name = ?, Process_id = ?, Processinstance_id = ?, Sn = ?, Sn_name = ?, Started_time = ?, State = ?, Target_task_id = ?, Task_id = ?, Task_type =? Where id =?]; SQL State [null]; error code [0]; cocould not update: [COM. fsti. infopriv. model. taskinstance #294]; Nested exception is Org. hibernate. exception. genericjdbcexception: cocould not update: [COM. fsti. infopriv. model. taskinstance #294]
At org. springframework. Orm. hibernate3.sessionfactoryutils. converthibernateaccessexception (sessionfactoryutils. Java: 642)
At org. springframework. Orm. JPA. Vendor. hibernatejpadialect. translateexceptionifpossible (hibernatejpadialect. Java: 95)
At org. springframework. Dao. Support. dataaccessutils. translateifnecessary (dataaccessutils. Java: 212)
At org. springframework. Orm. JPA. jpaaccessor. translateifnecessary (jpaaccessor. Java: 152)
At org.springframework.orm.jpa.jpatemplate.exe cute (jpatemplate. Java: 189)
At org.springframework.orm.jpa.jpatemplate.exe cutefind (jpatemplate. Java: 151)
At org. springframework. Orm. JPA. jpatemplate. Find (jpatemplate. Java: 311)
At com. fsti. commons. Dao. template. jpaspringdaotemplate. findbyhql (jpaspringdaotemplate. Java: 156)

 

 

 

 

Mysql> show variables like '% timeout ';

The output is as follows:

+ ---------------------------- + ------- +
| Variable_name | value |

+ ---------------------------- + ------- +
| Connect_timeout | 5 |
|
Delayed_insert_timeout | 300 |
| Interactive_timeout | 28800 |
|
Net_read_timeout | 30 |
| Net_write_timeout | 60 |
| Slave_net_timeout |
3600 |
| Wait_timeout | 28800 |
+ ---------------------------- + ------- +

Interactive_timeout
It takes effect after the client_interactive option is set in mysql_connect () and is assigned as wait_timeout;

Mysql> set
Wait_timeout = 10; valid for the current interactive link;
Mysql> set interactive_timeout = 10;
Valid for subsequent interaction links;

The timeout time is measured in seconds and starts from the time after the last SQL statement is executed. If the current idle time exceeds this time, the variable is forcibly disconnected.

Interactive_timeout (commonly used)

The number of seconds the server waits for activity on an interactive
Connection before closing it. An interactive client is defined as a client that
Uses the client_interactive option to mysql_real_connect (). See also
Wait_timeout.

Translation: idle timeout time for client-server interaction. This system variable takes effect only when the "mysql_client_interactive" flag is set when the client connects to the server. For example:

// Enable mysql_client_interactive mode to connect to the Database Server

$ Link = mysql_connect ($ host, $ user, $ PWD, false,
Mysql_client_interactive );