topic Activiti Processes disappearing, requiring a server restart in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/activiti-processes-disappearing-requiring-a-server-restart/m-p/7010#M3372 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 8pt;">Hello,</P><P style="margin: 0cm 0cm 8pt;">We are using Activiti (5.21.0) connected to MySql (15.1). Activiti (web application ) is deployed on Tomcat (8.0.43). Within a gap of 5-7 days we get an issue. All the processes, except for the default Demo Process &amp; Demo Reports &nbsp;, get un-deployed. &nbsp;That is we cannot see the processes in Deployments tab or under ‘Deployed process definitions’ tab.&nbsp; However if we check the ACT_RE_DEPLOYMENT <SPAN style="color: red;">table </SPAN>records are present for each of our BPMN processes. &nbsp;On restarting tomcat things return to normal.</P><P style="margin: 0cm 0cm 8pt;">This is generally happening at the time of Auto-restart of Tomcat for rolling over the logs. But seems that this restart causes memory issues. Please see the log below.</P><P style="margin: 0cm 0cm 8pt;">&nbsp;</P><P style="margin: 0cm 0cm 8pt;"><SPAN style="background: yellow; font-size: 12px;">29-Jul-2017 14:42:59.065 INFO [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance.</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">29-Jul-2017 14:42:59.066 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">29-Jul-2017 14:42:59.117 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service Catalina</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">02:42:59,121 [localhost-startStop-2] INFO&nbsp; org.springframework.web.context.support.AnnotationConfigWebApplicationContext&nbsp; - Closing WebApplicationContext for namespace 'dispatcher-servlet': startup date [Fri Jul 28 17:56:51 BST 2017]; parent: Root WebApplicationContext</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">02:42:59,141 [localhost-startStop-2] INFO&nbsp; org.activiti.rest.servlet.WebConfigurer&nbsp; - Destroying Web application</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">02:42:59,142 [localhost-startStop-2] INFO&nbsp; org.springframework.web.context.support.AnnotationConfigWebApplicationContext&nbsp; - Closing Root WebApplicationContext: startup date [Fri Jul 28 17:56:47 BST 2017]; root of context hierarchy</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">02:42:59,143 [localhost-startStop-2] INFO&nbsp; org.activiti.engine.impl.asyncexecutor.AbstractAsyncJobExecutor&nbsp; - Shutting down the default async job executor [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor].</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">02:42:59,145 [Thread-5] INFO&nbsp; org.activiti.engine.impl.asyncexecutor.AcquireAsyncJobsDueRunnable&nbsp; - stopped async job due acquisition</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="background: yellow; font-size: 12px;">29-Jul-2017 14:42:59.160 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [activiti-rest] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">java.lang.Object.wait(Native Method)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 12px;">com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:43)</SPAN></P><P style="margin: 0cm 0cm 8pt;">&nbsp;</P><P style="margin: 0cm 0cm 8pt;"><STRONG>Below is the observation from MySql DB, not sure if this is also causing the issue.</STRONG></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">LATEST DETECTED DEADLOCK</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;------------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;2017-07-28 16:57:11 2b5721f44700</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** (1) TRANSACTION:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;TRANSACTION 3186592, ACTIVE 0 sec starting index read</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;mysql tables in use 1, locked 1</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LOCK WAIT 11 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 6</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;MySQL thread id 351405, OS thread handle 0x2b5721ec2700, query id 10900155 10.95.104.93 opsbank updating</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;update ACT_HI_TASKINST set</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_ = 'escalationExample:1:32515',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXECUTION_ID_ = '38254',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME_ = 'First line support',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PARENT_TASK_ID_ = null,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DESCRIPTION_ = 'Fix issue raised by customer',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OWNER_ = null,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASSIGNEE_ = 'kermit',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CLAIM_TIME_ = null,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_ = '2017-07-28 17:57:11.185',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_ = 583211182,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE_REASON_ = 'deleted',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TASK_DEF_KEY_ = 'firstLineSupport',</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FORM_KEY_ = null,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRIORITY_ = 50,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DUE_DATE_ = null,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CATEGORY_ = null</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;&nbsp;&nbsp;&nbsp; where ID_ = '38257'</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** (1) WAITING FOR THIS LOCK TO BE GRANTED:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;RECORD LOCKS space id 300 page no 10 n bits 184 index `PRIMARY` of table `activitiopen`.`ACT_HI_TASKINST` trx id 3186592 lock_mode X locks rec but not gap waiting</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Record lock, heap no 112 PHYSICAL RECORD: n_fields 22; compact format; info bits 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 0: len 5; hex 3338323537; asc 38257;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 1: len 6; hex 000000309f9f; asc&nbsp;&nbsp;&nbsp; 0&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 2: len 7; hex 600000024a1c02; asc `&nbsp;&nbsp; J&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 3: len 25; hex 657363616c6174696f6e4578616d706c653a313a3332353135; asc escalationExample:1:32515;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 4: len 16; hex 66697273744c696e65537570706f7274; asc firstLineSupport;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 5: len 5; hex 3338323531; asc 38251;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 6: len 5; hex 3338323534; asc 38254;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">7: len 18; hex 4669727374206c696e6520737570706f7274; asc First line support;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 8: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 9: len 28; hex 4669782069737375652072616973656420627920637573746f6d6572; asc Fix issue raised by customer;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 10: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 11: len 6; hex 6b65726d6974; asc kermit;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 12: len 7; hex 999d2b7e40001e; asc&nbsp;&nbsp; +~@&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 13: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 14: len 7; hex 999d2c0c621784; asc&nbsp;&nbsp; , b&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 15: len 8; hex 80000000003022a7; asc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0" ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 16: len 9; hex 636f6d706c65746564; asc completed;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 17: len 4; hex 80000032; asc&nbsp;&nbsp;&nbsp; 2;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 18: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 19: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 20: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 21: len 0; hex ; asc ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** (2) TRANSACTION:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;TRANSACTION 3186591, ACTIVE 0 sec starting index read</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;mysql tables in use 1, locked 1</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;30 lock struct(s), heap size 6544, 20 row lock(s), undo log entries 8</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;MySQL thread id 351404, OS thread handle 0x2b5721f44700, query id 10900172 10.95.104.93 opsbank updating</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;delete from ACT_RU_EXECUTION where ID_ = '38251' and REV_ = 1</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** (2) HOLDS THE LOCK(S):</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;RECORD LOCKS space id 300 page no 10 n bits 184 index `PRIMARY` of table `activitiopen`.`ACT_HI_TASKINST` trx id 3186591 lock_mode X locks rec but not gap</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Record lock, heap no 112 PHYSICAL RECORD: n_fields 22; compact format; info bits 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 0: len 5; hex 3338323537; asc 38257;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 1: len 6; hex 000000309f9f; asc&nbsp;&nbsp;&nbsp; 0&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 2: len 7; hex 600000024a1c02; asc `&nbsp;&nbsp; J&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 3: len 25; hex 657363616c6174696f6e4578616d706c653a313a3332353135; asc escalationExample:1:32515;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 4: len 16; hex 66697273744c696e65537570706f7274; asc firstLineSupport;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 5: len 5; hex 3338323531; asc 38251;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 6: len 5; hex 3338323534; asc 38254;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 7: len 18; hex 4669727374206c696e6520737570706f7274; asc First line support;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 8: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 9: len 28; hex 4669782069737375652072616973656420627920637573746f6d6572; asc Fix issue raised by customer;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 10: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 11: len 6; hex 6b65726d6974; asc kermit;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 12: len 7; hex 999d2b7e40001e; asc&nbsp;&nbsp; +~@&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 13: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 14: len 7; hex 999d2c0c621784; asc&nbsp;&nbsp; , b&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 15: len 8; hex 80000000003022a7; asc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0" ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 16: len 9; hex 636f6d706c65746564; asc completed;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 17: len 4; hex 80000032; asc&nbsp;&nbsp;&nbsp; 2;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 18: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 19: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 20: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 21: len 0; hex ; asc ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** (2) WAITING FOR THIS LOCK TO BE GRANTED:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;RECORD LOCKS space id 281 page no 3 n bits 248 index `PRIMARY` of table `activitiopen`.`ACT_RU_EXECUTION` trx id 3186591 lock_mode X locks rec but not gap waiting</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Record lock, heap no 175 PHYSICAL RECORD: n_fields 19; compact format; info bits 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 0: len 5; hex 3338323531; asc 38251;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 1: len 6; hex 000000309f98; asc&nbsp;&nbsp;&nbsp; 0&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 2: len 7; hex 5c000001d82b76; asc \&nbsp;&nbsp;&nbsp; +v;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 3: len 4; hex 80000001; asc&nbsp;&nbsp;&nbsp;&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 4: len 5; hex 3338323531; asc 38251;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 5: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 6: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 7: len 25; hex 657363616c6174696f6e4578616d706c653a313a3332353135; asc escalationExample:1:32515;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 8: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 9: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 10: len 1; hex 80; asc&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 11: len 1; hex 80; asc&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 12: len 1; hex 81; asc&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 13: len 1; hex 80; asc&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 14: len 4; hex 80000001; asc&nbsp;&nbsp;&nbsp;&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 15: len 4; hex 80000002; asc&nbsp;&nbsp;&nbsp;&nbsp; ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 16: len 0; hex ; asc ;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 17: SQL NULL;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; 18: len 6; hex 597b7c230528; asc Y{|# (;;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;*** WE ROLL BACK TRANSACTION (1)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;TRANSACTIONS</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Trx id counter 3228847</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Purge done for trx's n<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /> &lt; 3228832 undo n<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /> &lt; 0 state: running but idle</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;History list length 2288</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LIST OF TRANSACTIONS FOR EACH SESSION:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---TRANSACTION 0, not started</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;MySQL thread id 367358, OS thread handle 0x2b57076be700, query id 11230443 10.48.66.88 opsbank init</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;SHOW ENGINE INNODB STATUS</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---TRANSACTION 3228846, not started</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;MySQL thread id 30464, OS thread handle 0x2b57076ff700, query id 11230437 localhost 127.0.0.1 rdsadmin cleaning up</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;--------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;FILE I/O</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;--------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 0 state: waiting for completed aio requests (insert buffer thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 1 state: waiting for completed aio requests (log thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 2 state: waiting for completed aio requests (read thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 3 state: waiting for completed aio requests (read thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 4 state: waiting for completed aio requests (read thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 5 state: waiting for completed aio requests (read thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 6 state: waiting for completed aio requests (write thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 7 state: waiting for completed aio requests (write thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 8 state: waiting for completed aio requests (write thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O thread 9 state: waiting for completed aio requests (write thread)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending flushes (fsync) log: 0; buffer pool: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;1092 OS file reads, 395704 OS file writes, 372957 OS fsyncs</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;-------------------------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;INSERT BUFFER AND ADAPTIVE HASH INDEX</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;-------------------------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Ibuf: size 1, free list len 0, seg size 2, 0 merges</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;merged operations:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; insert 0, delete mark 0, delete 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;discarded operations:</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp; insert 0, delete mark 0, delete 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Hash table size 5843809, node heap has 15 buffer(s)</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 hash searches/s, 0.00 non-hash searches/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LOG</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Log sequence number 58534483</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Log flushed up to&nbsp;&nbsp; 58534483</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages flushed up to 58534483</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Last checkpoint at&nbsp; 58534483</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0 pending log writes, 0 pending chkp writes</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;118354 log i/o's done, 0.00 log i/o's/second</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;----------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;BUFFER POOL AND MEMORY</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;----------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Total memory allocated 3021996032; in additional pool allocated 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Dictionary memory allocated 268428</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 180224</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 178654</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 1555</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 951, created 604, written 152095</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 1555, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;----------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;INDIVIDUAL BUFFER POOL INFO</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;----------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22326</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 201</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 164, created 37, written 55513</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 201, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 1</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22324</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 203</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 75, created 128, written 2027</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 203, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 2</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22397</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 128</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 62, created 66, written 515</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 128, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 3</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22284</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 241</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 151, created 90, written 18624</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 241, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 4</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22307</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 220</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 136, created 84, written 15435</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 220, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 5</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22332</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 194</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 112, created 82, written 9345</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 194, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 6</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22330</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 197</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 128, created 69, written 38249</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 197, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;---BUFFER POOL 7</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Buffer pool size&nbsp;&nbsp; 22528</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Free buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22354</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Database pages&nbsp;&nbsp;&nbsp;&nbsp; 171</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Old database pages 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Modified db pages&nbsp; 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending reads 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pending writes: LRU 0, flush list 0, single page 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages made young 0, not young 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 youngs/s, 0.00 non-youngs/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read 123, created 48, written 12387</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 reads/s, 0.00 creates/s, 0.00 writes/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;No buffer pool page gets since the last printout</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;LRU len: 171, unzip_LRU len: 0</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;I/O sum[0]:cur[0], unzip sum[0]:cur[0]</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;--------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;ROW OPERATIONS</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;--------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0 queries inside InnoDB, 0 queries in queue</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0 read views open inside InnoDB</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Main thread process no. 12056, id 47656132937472, state: sleeping</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;Number of rows inserted 20459, updated 41529, deleted 16824, read 4309439</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.07 reads/s</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;----------------------------</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;END OF INNODB MONITOR OUTPUT</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;============================</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;</SPAN></P><P style="margin: 0cm 0cm 8pt;"><SPAN style="font-size: 11px;">&nbsp;</SPAN></P></BODY></HTML> Wed, 02 Aug 2017 12:37:50 GMT ob2wr 2017-08-02T12:37:50Z Activiti Processes disappearing, requiring a server restart https://connect.hyland.com/t5/alfresco-forum/activiti-processes-disappearing-requiring-a-server-restart/m-p/7010#M3372 Hello,We are using Activiti (5.21.0) connected to MySql (15.1). Activiti (web application ) is deployed on Tomcat (8.0.43). Within a gap of 5-7 days we get an issue. All the processes, except for the default Demo Process &amp; Demo Reports &nbsp;, get un-deployed. &nbsp;That is we cannot see the processes in Wed, 02 Aug 2017 12:37:50 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-processes-disappearing-requiring-a-server-restart/m-p/7010#M3372 ob2wr 2017-08-02T12:37:50Z Re: Activiti Processes disappearing, requiring a server restart https://connect.hyland.com/t5/alfresco-forum/activiti-processes-disappearing-requiring-a-server-restart/m-p/7011#M3373 <HTML><HEAD></HEAD><BODY><P>Sorry&nbsp; typo, MySQL version is 5.5</P></BODY></HTML> Wed, 02 Aug 2017 15:25:15 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-processes-disappearing-requiring-a-server-restart/m-p/7011#M3373 ob2wr 2017-08-02T15:25:15Z