Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-152240

Deadlock during sending workflow notifications

Details

    • Bug
    • Status: Verified
    • Resolution: Unresolved
    • 7.1.10 DXP FP14
    • None
    • None
    • 3

    Description

      Description:
      Sometimes (once a month, twice a month, once in every two months) the customer sees the following exception in the log and the workflow notification wasn't sent out:

      2022-02-11 09:01:38.656 ERROR Deadlock found when trying to get lock; try restarting transaction        [JDBCExceptionReporter:234][liferay/kaleo_graph_walker-113]
      2022-02-11 09:01:38.660 ERROR Unable to process message {destinationName=liferay/kaleo_graph_walker, response=null, responseDestinationName=null, responseId=null, payl[email protected]49ce4306, values={defaultLocale=sv_SE, companyId=60188, groupId=0, principalName=215187, [email protected]2a121072, siteDefaultLocale=sv_SE, themeDisplayLocale=sv_SE}}   [ParallelDestination:55][liferay/kaleo_gr
      aph_walker-113]
      com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.workflow.kaleo.runtime.notification.NotificationMessageSenderException: Unable to send notification message
              at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:32)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
              at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
              at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:752)
              at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:664)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: com.liferay.portal.workflow.kaleo.runtime.notification.NotificationMessageSenderException: Unable to send notification message
              at com.liferay.portal.workflow.kaleo.runtime.notification.BaseNotificationSender.sendNotification(BaseNotificationSender.java:58)
              at com.liferay.portal.workflow.kaleo.runtime.internal.util.NotificationHelperImpl.sendKaleoNotification(NotificationHelperImpl.java:101)
              at com.liferay.portal.workflow.kaleo.runtime.internal.util.NotificationHelperImpl.sendKaleoNotifications(NotificationHelperImpl.java:55)
              at com.liferay.portal.workflow.kaleo.runtime.internal.node.TaskNodeExecutor.doEnter(TaskNodeExecutor.java:152)
              at com.liferay.portal.workflow.kaleo.runtime.node.BaseNodeExecutor.enter(BaseNodeExecutor.java:51)
              at com.liferay.portal.workflow.kaleo.runtime.internal.graph.DefaultGraphWalker.follow(DefaultGraphWalker.java:65)
              at sun.reflect.GeneratedMethodAccessor2421.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:203)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:94)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:125)
              at com.sun.proxy.$Proxy522.follow(Unknown Source)
              at com.liferay.portal.workflow.kaleo.runtime.internal.graph.messaging.PathElementMessageListener.doReceive(PathElementMessageListener.java:47)
              at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
              ... 5 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
              at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:269)
              at com.liferay.portal.service.persistence.impl.UserNotificationDeliveryPersistenceImpl.fetchByU_P_C_N_D(UserNotificationDeliveryPersistenceImpl.java:799)
              at com.liferay.portal.service.persistence.impl.UserNotificationDeliveryPersistenceImpl.fetchByU_P_C_N_D(UserNotificationDeliveryPersistenceImpl.java:675)
              at com.liferay.portal.service.impl.UserNotificationDeliveryLocalServiceImpl.getUserNotificationDelivery(UserNotificationDeliveryLocalServiceImpl.java:97)
              at sun.reflect.GeneratedMethodAccessor2766.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:203)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:94)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:125)
              at com.sun.proxy.$Proxy220.getUserNotificationDelivery(Unknown Source)
              at com.liferay.portal.kernel.service.UserNotificationDeliveryLocalServiceUtil.getUserNotificationDelivery(UserNotificationDeliveryLocalServiceUtil.java:314)
              at com.liferay.portal.kernel.notifications.BaseUserNotificationHandler.isDeliver(BaseUserNotificationHandler.java:122)
              at com.liferay.portal.kernel.notifications.UserNotificationManagerUtil._isDeliver(UserNotificationManagerUtil.java:316)
              at com.liferay.portal.kernel.notifications.UserNotificationManagerUtil.isDeliver(UserNotificationManagerUtil.java:113)
              at com.liferay.portal.workflow.kaleo.runtime.internal.notification.EmailNotificationSender.doSendNotification(EmailNotificationSender.java:136)
              at com.liferay.portal.workflow.kaleo.runtime.notification.BaseNotificationSender.sendNotification(BaseNotificationSender.java:53)
              ... 26 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
              at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)
              at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:124)
              at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:99)
              at com.liferay.portal.service.persistence.impl.UserNotificationDeliveryPersistenceImpl.fetchByU_P_C_N_D(UserNotificationDeliveryPersistenceImpl.java:776)
              ... 46 more
      Caused by: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
              at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
              at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
              at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2412)
              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
              at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
              at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
              at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
              at com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
              at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
              at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
              at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
              at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:112)
              ... 48 more
      Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2043)
              at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
              at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
              at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
              ... 63 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1065)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
              ... 68 more
      

      If you check the mysql's log, you can see that the problem is with two UserNotificationDelivery entries, they have the same userid.
      The difference is the deliveryType:
      TYPE_EMAIL = 10000;
      TYPE_WEBSITE = 10002;

      SHOW ENGINE INNODB STATUS
      
      =====================================
      
      2022-03-22 19:03:04 0x7fc9839cf700 INNODB MONITOR OUTPUT
      
      =====================================
      
      Per second averages calculated from the last 47 seconds
      
      -----------------
      
      BACKGROUND THREAD
      
      -----------------
      
      srv_master_thread loops: 467144 srv_active, 0 srv_shutdown, 28007043 srv_idle
      
      srv_master_thread log flush and writes: 28474187
      
      ----------
      
      SEMAPHORES
      
      ----------
      
      OS WAIT ARRAY INFO: reservation count 390323
      
      OS WAIT ARRAY INFO: signal count 392924
      
      RW-shared spins 0, rounds 745795, OS waits 363032
      
      RW-excl spins 0, rounds 1137758, OS waits 6355
      
      RW-sx spins 8195, rounds 182737, OS waits 2616
      
      Spin rounds per wait: 745795.00 RW-shared, 1137758.00 RW-excl, 22.30 RW-sx
      
      ------------------------
      
      LATEST DETECTED DEADLOCK
      
      ------------------------
      
      2022-02-11 10:01:38 0x7fc9838c7700
      
      *** (1) TRANSACTION:
      
      TRANSACTION 3556429, ACTIVE 0 sec inserting
      
      mysql tables in use 1, locked 1
      
      LOCK WAIT 9 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 8
      
      MySQL thread id 867301, OS thread handle 140504286078720, query id 73938049 164.9.5.197 lray update
      
      insert into UserNotificationDelivery (mvccVersion, companyId, userId, portletId, classNameId, notificationType, deliveryType, deliver, userNotificationDeliveryId) values (0, 60188, 1508623, 'com_liferay_portal_workflow_task_web_portlet_MyWorkflowTaskPortlet', 0, 0, 10002, 1, 1539263)
      
      *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
      
      RECORD LOCKS space id 123 page no 22 n bits 184 index IX_8B6E3ACE of table `LRAY`.`UserNotificationDelivery` trx id 3556429 lock mode S waiting
      
      Record lock, heap no 117 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
      
      0: len 8; hex 800000000017050f; asc         ;;
      
      1: len 30; hex 636f6d5f6c6966657261795f706f7274616c5f776f726b666c6f775f7461; asc com_liferay_portal_workflow_ta; (total 66 bytes);
      
      2: len 8; hex 8000000000000000; asc         ;;
      
      3: len 4; hex 80000000; asc     ;;
      
      4: len 4; hex 80002712; asc   ' ;;
      
      5: len 8; hex 8000000000177cba; asc       | ;;
      
       
      
      *** (2) TRANSACTION:
      
      TRANSACTION 3556424, ACTIVE 0 sec inserting
      
      mysql tables in use 1, locked 1
      
      11 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 11
      
      MySQL thread id 885083, OS thread handle 140503472174848, query id 73938051 164.9.5.197 lray update
      
      insert into UserNotificationDelivery (mvccVersion, companyId, userId, portletId, classNameId, notificationType, deliveryType, deliver, userNotificationDeliveryId) values (0, 60188, 1508623, 'com_liferay_portal_workflow_task_web_portlet_MyWorkflowTaskPortlet', 0, 0, 10000, 1, 1539261)
      
      *** (2) HOLDS THE LOCK(S):
      
      RECORD LOCKS space id 123 page no 22 n bits 184 index IX_8B6E3ACE of table `LRAY`.`UserNotificationDelivery` trx id 3556424 lock_mode X locks rec but not gap
      
      Record lock, heap no 117 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
      
      0: len 8; hex 800000000017050f; asc         ;;
      
      1: len 30; hex 636f6d5f6c6966657261795f706f7274616c5f776f726b666c6f775f7461; asc com_liferay_portal_workflow_ta; (total 66 bytes);
      
      2: len 8; hex 8000000000000000; asc         ;;
      
      3: len 4; hex 80000000; asc     ;;
      
      4: len 4; hex 80002712; asc   ' ;;
      
      5: len 8; hex 8000000000177cba; asc       | ;;
      
       
      
      *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
      
      RECORD LOCKS space id 123 page no 22 n bits 184 index IX_8B6E3ACE of table `LRAY`.`UserNotificationDelivery` trx id 3556424 lock_mode X locks gap before rec insert intention waiting
      
      Record lock, heap no 117 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
      
      0: len 8; hex 800000000017050f; asc         ;;
      
      1: len 30; hex 636f6d5f6c6966657261795f706f7274616c5f776f726b666c6f775f7461; asc com_liferay_portal_workflow_ta; (total 66 bytes);
      
      2: len 8; hex 8000000000000000; asc         ;;
      
      3: len 4; hex 80000000; asc     ;;
      
      4: len 4; hex 80002712; asc   ' ;;
      
      5: len 8; hex 8000000000177cba; asc       | ;;
      
       
      
      *** WE ROLL BACK TRANSACTION (1)
      
      ------------
      
      TRANSACTIONS
      
      ------------
      
      Trx id counter 4210149
      
      Purge done for trx's n:o < 4210147 undo n:o < 0 state: running but idle
      
      History list length 0
      
      LIST OF TRANSACTIONS FOR EACH SESSION:
      
      ---TRANSACTION 421988321710592, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      ---TRANSACTION 421988321707856, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      ---TRANSACTION 421988321713328, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      ---TRANSACTION 421988321709680, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      ---TRANSACTION 421988321708768, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      ---TRANSACTION 421988321711504, not started
      
      0 lock struct(s), heap size 1136, 0 row lock(s)
      
      --------
      
      FILE I/O
      
      --------
      
      I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
      
      I/O thread 1 state: waiting for completed aio requests (log thread)
      
      I/O thread 2 state: waiting for completed aio requests (read thread)
      
      I/O thread 3 state: waiting for completed aio requests (read thread)
      
      I/O thread 4 state: waiting for completed aio requests (read thread)
      
      I/O thread 5 state: waiting for completed aio requests (read thread)
      
      I/O thread 6 state: waiting for completed aio requests (write thread)
      
      I/O thread 7 state: waiting for completed aio requests (write thread)
      
      I/O thread 8 state: waiting for completed aio requests (write thread)
      
      I/O thread 9 state: waiting for completed aio requests (write thread)
      
      Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
      
      ibuf aio reads:, log i/o's:, sync i/o's:
      
      Pending flushes (fsync) log: 0; buffer pool: 0
      
      22693 OS file reads, 12487534 OS file writes, 6688678 OS fsyncs
      
      0.00 reads/s, 0 avg bytes/read, 0.06 writes/s, 0.00 fsyncs/s
      
      -------------------------------------
      
      INSERT BUFFER AND ADAPTIVE HASH INDEX
      
      -------------------------------------
      
      Ibuf: size 1, free list len 12, seg size 14, 536 merges
      
      merged operations:
      
      insert 512, delete mark 1000, delete 165
      
      discarded operations:
      
      insert 0, delete mark 0, delete 0
      
      Hash table size 2365241, node heap has 85 buffer(s)
      
      Hash table size 2365241, node heap has 16 buffer(s)
      
      Hash table size 2365241, node heap has 56 buffer(s)
      
      Hash table size 2365241, node heap has 509 buffer(s)
      
      Hash table size 2365241, node heap has 52 buffer(s)
      
      Hash table size 2365241, node heap has 1115 buffer(s)
      
      Hash table size 2365241, node heap has 267 buffer(s)
      
      Hash table size 2365241, node heap has 100 buffer(s)
      
      0.00 hash searches/s, 1.19 non-hash searches/s
      
      ---
      
      LOG
      
      ---
      
      Log sequence number 4791348992
      
      Log flushed up to   4791348992
      
      Pages flushed up to 4791348992
      
      Last checkpoint at  4791348983
      
      0 pending log flushes, 0 pending chkp writes
      
      2786596 log i/o's done, 0.00 log i/o's/second
      
      ----------------------
      
      BUFFER POOL AND MEMORY
      
      ----------------------
      
      Total large memory allocated 8795455488
      
      Dictionary memory allocated 3391416
      
      Buffer pool size   524224
      
      Free buffers       418326
      
      Database pages     103698
      
      Old database pages 37951
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 607, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 22402, created 81296, written 8175961
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 103698, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ----------------------
      
      INDIVIDUAL BUFFER POOL INFO
      
      ----------------------
      
      ---BUFFER POOL 0
      
      Buffer pool size   32764
      
      Free buffers       25741
      
      Database pages     6881
      
      Old database pages 2520
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 24, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1442, created 5439, written 740972
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6881, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 1
      
      Buffer pool size   32764
      
      Free buffers       26031
      
      Database pages     6600
      
      Old database pages 2416
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 15, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1436, created 5164, written 2013386
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6600, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 2
      
      Buffer pool size   32764
      
      Free buffers       26210
      
      Database pages     6402
      
      Old database pages 2343
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 21, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1367, created 5035, written 119539
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6402, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 3
      
      Buffer pool size   32764
      
      Free buffers       26428
      
      Database pages     6192
      
      Old database pages 2265
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 52, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1261, created 4931, written 1015366
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6192, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 4
      
      Buffer pool size   32764
      
      Free buffers       26235
      
      Database pages     6387
      
      Old database pages 2337
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 16, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1476, created 4911, written 496945
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6387, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 5
      
      Buffer pool size   32764
      
      Free buffers       26195
      
      Database pages     6438
      
      Old database pages 2356
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 57, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1552, created 4886, written 509832
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6438, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 6
      
      Buffer pool size   32764
      
      Free buffers       26527
      
      Database pages     6105
      
      Old database pages 2233
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 37, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1491, created 4614, written 310321
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6105, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 7
      
      Buffer pool size   32764
      
      Free buffers       26423
      
      Database pages     6201
      
      Old database pages 2269
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 51, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1357, created 4844, written 296762
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6201, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 8
      
      Buffer pool size   32764
      
      Free buffers       26198
      
      Database pages     6432
      
      Old database pages 2354
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 37, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1383, created 5049, written 523972
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6432, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 9
      
      Buffer pool size   32764
      
      Free buffers       26039
      
      Database pages     6598
      
      Old database pages 2415
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 67, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1301, created 5297, written 717563
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6598, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 10
      
      Buffer pool size   32764
      
      Free buffers       26142
      
      Database pages     6488
      
      Old database pages 2374
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 44, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1330, created 5158, written 378860
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6488, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 11
      
      Buffer pool size   32764
      
      Free buffers       26220
      
      Database pages     6414
      
      Old database pages 2347
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 17, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1280, created 5134, written 216697
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6414, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 12
      
      Buffer pool size   32764
      
      Free buffers       25990
      
      Database pages     6634
      
      Old database pages 2428
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 47, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1206, created 5428, written 190342
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6634, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 13
      
      Buffer pool size   32764
      
      Free buffers       25879
      
      Database pages     6736
      
      Old database pages 2466
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 56, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1431, created 5305, written 267131
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6736, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 14
      
      Buffer pool size   32764
      
      Free buffers       25934
      
      Database pages     6697
      
      Old database pages 2452
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 30, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1574, created 5123, written 213653
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6697, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      ---BUFFER POOL 15
      
      Buffer pool size   32764
      
      Free buffers       26134
      
      Database pages     6493
      
      Old database pages 2376
      
      Modified db pages  0
      
      Pending reads      0
      
      Pending writes: LRU 0, flush list 0, single page 0
      
      Pages made young 36, not young 0
      
      0.00 youngs/s, 0.00 non-youngs/s
      
      Pages read 1515, created 4978, written 164620
      
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      
      No buffer pool page gets since the last printout
      
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      
      LRU len: 6493, unzip_LRU len: 0
      
      I/O sum[0]:cur[0], unzip sum[0]:cur[0]
      
      --------------
      
      ROW OPERATIONS
      
      --------------
      
      0 queries inside InnoDB, 0 queries in queue
      
      0 read views open inside InnoDB
      
      Process ID=3076, Main thread ID=140504217941760, state: sleeping
      
      Number of rows inserted 9410805, updated 1969915, deleted 107454, read 555391914
      
      2.36 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2.40 reads/s
      
      ----------------------------
      
      END OF INNODB MONITOR OUTPUT
      
      ============================
      

      Patch level: dxp-14-7110, hotfix-5851-7110
      Database: MySQL 5.7.33.
      Connector: MySQL Connector/J 5.1.23

       

      Attachments

        Activity

          People

            feliphe.marinho Feliphe Marinho
            tibor.jandi Tibor Jandi
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              21 weeks, 6 days ago

              Packages

                Version Package