
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 3     |
+--------------------+-------+
1 row in set (0.000 sec)

MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_local_state_comment';
+---------------------------+--------+
| Variable_name             | Value  |
+---------------------------+--------+
| wsrep_local_state_comment | Synced |
+---------------------------+--------+
1 row in set (0.000 sec)

MariaDB [(none)]>  show status like "wsrep_last_committed";
+----------------------+----------+
| Variable_name        | Value    |
+----------------------+----------+
| wsrep_last_committed | 14852102 |
+----------------------+----------+
1 row in set (0.000 sec)

MariaDB [(none)]> SELECT DB,USER,HOST,STATE,TIME,COMMAND FROM INFORMATION_SCHEMA.PROCESSLIST  where DB != 'NULL' ORDER BY DB DESC;
+--------------+------------+------------------------------------------+---------------------------------+-------+---------+
| DB           | USER       | HOST                                     | STATE                           | TIME  | COMMAND |
+--------------+------------+------------------------------------------+---------------------------------+-------+---------+
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2553  |                                 |     0 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:60993 | Updating                        |    10 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:53569 | Update                          |    19 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:25177 |                                 |    28 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5065  | NULL                            |    44 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:7719  | acquiring total order isolation |    51 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:54115 | Update                          |    44 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46059 | Commit                          |    99 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:11713 | acquiring total order isolation |   103 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:42781 | Commit                          |    98 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:64951 | Commit                          |   166 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:50173 | acquiring total order isolation |   177 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2189  | Commit                          |   212 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:9907  | Commit                          |   224 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:60241 | Commit                          |   297 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:7719  | acquiring total order isolation |   327 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:29905 | Commit                          |   336 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41759 | acquiring total order isolation |   340 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:63645 | Commit                          |   356 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5685  | Commit                          |   374 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:54145 | Commit                          |   388 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40131 | Commit                          |   460 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46529 | acquiring total order isolation |   464 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:44333 | Commit                          |   534 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:58979 | Commit                          |   546 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:13197 | Commit                          |   923 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:16811 |                                 |     4 | Sleep   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:54167 | acquiring total order isolation |    39 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:33323 | acquiring total order isolation |   171 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:55565 | acquiring total order isolation |   279 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:32467 | acquiring total order isolation |   319 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:56833 | acquiring total order isolation |   383 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:10253 | acquiring total order isolation |   390 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18887 | acquiring total order isolation |   532 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4675  | acquiring total order isolation |   569 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4347  | acquiring total order isolation |   606 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41717 | acquiring total order isolation |   621 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:63299 | acquiring total order isolation |   642 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9445  | acquiring total order isolation |   657 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31197 | acquiring total order isolation |   711 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:22705 | acquiring total order isolation |   762 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:15569 | Commit                          |   850 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:1731  | Commit                          |   899 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:8529  | acquiring total order isolation |   903 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19965 | acquiring total order isolation |   939 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19605 |                                 | 11188 | Sleep   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:10347 | Commit                          |    99 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:15807 | Commit                          |   489 | Query   |
+--------------+------------+------------------------------------------+---------------------------------+-------+---------+
48 rows in set (0.001 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> SELECT ID,DB,USER,HOST,STATE,COMMAND,INFO,TIME,progress FROM INFORMATION_SCHEMA.PROCESSLIST where DB != 'NULL' ORDER BY DB DESC;
 
| ID   | DB           | USER       | HOST                                     | STATE                           | COMMAND | INFO                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | TIME  | progress |
 
| 2625 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24019 | acquiring total order isolation | Query   | KILL QUERY 7868                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    92 |    0.000 |
| 2624 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40009 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |    98 |    0.000 |
| 2612 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:42427 | acquiring total order isolation | Query   | KILL QUERY 2837                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   165 |    0.000 |
| 2607 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:33243 | Commit                          | Query   | UPDATE TBL_TIREPORTS_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = 'False', USERDISABLED = 'False' WHERE EIN =  NAME_CONST('EIN_IN',_latin1'801708990' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                                                               |   164 |    0.000 |
| 2594 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55623 | acquiring total order isolation | Query   | truncate table TBL_TASKFORCE_DATA_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   283 |    0.000 |
| 2588 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:47671 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:a533328de25d44f8a4890801b4df0fec' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   336 |    0.000 |
| 2586 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55569 | acquiring total order isolation | Query   | KILL QUERY 2571                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   340 |    0.000 |
| 2582 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2553  |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |   310 |    0.000 |
| 2575 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:7719  | acquiring total order isolation | Query   | KILL QUERY 2818                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   413 |    0.000 |
| 2571 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46059 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:19520ba15d734378a5e7192f67b94f6e' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   460 |    0.000 |
| 2569 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:11713 | acquiring total order isolation | Query   | KILL QUERY 2813                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   464 |    0.000 |
| 2568 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:42781 | Commit                          | Query   | UPDATE TBL_CJL_STATUS_CHECK SET NEW_STATUS =  NAME_CONST('STATUS_IN',_latin1'AAD' COLLATE 'latin1_swedish_ci') WHERE DB =  NAME_CONST('DB_IN',_latin1'NE' COLLATE 'latin1_swedish_ci') AND CSSJOB =  NAME_CONST('JOB_IN',_latin1'DVB247/10' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                            |   460 |    0.000 |
| 2564 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:64951 | Commit                          | Query   | UPDATE TBL_NAMEDENG_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = 'False' WHERE EIN =  NAME_CONST('EIN_IN',_latin1'614391587' COLLATE 'latin1_swedish_ci') and USERDISABLED = 'False'                                                                                                                                                                                                                                                                                                                                                                                                                             |   527 |    0.000 |
| 2560 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:50173 | acquiring total order isolation | Query   | KILL QUERY 2551                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   538 |    0.000 |
| 2557 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2189  | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:b5998602836f479491c6ccc4a21d5e09' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   573 |    0.000 |
| 2556 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:9907  | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'LN-RGZ409/11' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'LN' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'RGZ409' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'11' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIADK1B' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |   586 |    0.000 |
| 2551 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:60241 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:32da815c99ce447e8cb1b47116ace6b5' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   658 |    0.000 |
| 2545 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:7719  | acquiring total order isolation | Query   | truncate table TBL_LINKED_ORDERS_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |   689 |    0.000 |
| 2544 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:29905 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:213ced6054424dbbae4907cf45e2b511' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   697 |    0.000 |
| 2543 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41759 | acquiring total order isolation | Query   | KILL QUERY 2533                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   702 |    0.000 |
| 2541 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:63645 | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'EA-RCR736/10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'EA' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'RCR736' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIACB1B' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |   718 |    0.000 |
| 2539 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5685  | Commit                          | Query   | UPDATE TBL_NAMEDENG_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = 'False' WHERE EIN =  NAME_CONST('EIN_IN',_latin1'803282146' COLLATE 'latin1_swedish_ci') and USERDISABLED = 'False'                                                                                                                                                                                                                                                                                                                                                                                                                             |   736 |    0.000 |
| 2536 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:54145 | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'EM-JLC597/10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'EM' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'JLC597' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIADY1B' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |   750 |    0.000 |
| 2533 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40131 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:c04965e09dab4ee4bc69ff3aa6e79655' INTO TABLE TBL_LINKED_ORDERS_INPUT CHARACTER SET utf8mb4 FIELDS TERMINATED BY '        ' ESCAPED BY '\\' LINES TERMINATED BY '
' IGNORE 0 LINES (`LEAD_JIN`,`LEAD_TYPE`,`LEAD_DATE`,`LEAD_STATUS`,`CHILD_JIN`,`CHILD_TYPE`,`CHILD_DATE`,`CHILD_STATUS`,`WMQUEUE`)                                                                                                                                                                                                                                                                                                                        |   821 |    0.000 |
| 2532 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46529 | acquiring total order isolation | Query   | KILL QUERY 2782                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   826 |    0.000 |
| 2523 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:44333 | Commit                          | Query   | UPDATE TBL_NAMEDENG_WEBACCESS
  SET ALLOW_EDIT = 0,
    LAST_ACCESSED = SYSDATE(),
    USERDISABLED = 'False' ,
    EXPIRE_EMAIL = 'False',
    EXPIRE_FINAL = 'False'
  WHERE EIN      =  NAME_CONST('EIN_IN',_latin1'614358993' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                      |   895 |    0.000 |
| 2522 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:58979 | Commit                          | Query   | UPDATE TBL_TIREPORTS_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = 'False', USERDISABLED = 'False' WHERE EIN =  NAME_CONST('EIN_IN',_latin1'803282146' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                                                               |   908 |    0.000 |
| 2485 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:13197 | Commit                          | Query   | UPDATE SMS_PORT_REQUESTS SET RETURN_MESSAGE =  NAME_CONST('MESSAGE_IN',_latin1'Port 156 : FBLS0 065066  \r\nPort 157 : LLLS2 258022  \r\nPort 158 : LLLS2 300803' COLLATE 'latin1_swedish_ci'), ROBO_STATUS = 'COMPLETE', EIN =  NAME_CONST('EIN_IN',_latin1'612077841' COLLATE 'latin1_swedish_ci') WHERE RECID =  NAME_CONST('RECID_IN',782196)                                                                                                                                                                                                                                                                                                   |  1285 |    0.000 |
| 2422 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:16811 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |     4 |    0.000 |
| 2632 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:27839 | Updating                        | Query   | Update flowqueue_sogea_fttc  set status ='Processed', remarks ='Acknowledged exception' where seid ='363929465'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |     5 |    0.000 |
| 2631 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:33403 | Updating                        | Query   | update CSS_RoutingInfo set remarks = 'No Working Lines Found' ,WORKING_LINES = '0'  where  PROCESSEDDATE is null  and CSS_Orderno = 'DWS300/05'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    27 |    0.000 |
| 2629 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:43779 | acquiring total order isolation | Query   | KILL QUERY 2623                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    70 |    0.000 |
| 2628 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:26905 | acquiring total order isolation | Query   | KILL QUERY 7878                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    72 |    0.000 |
| 2619 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:44179 | acquiring total order isolation | Query   | KILL QUERY 2614                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   104 |    0.000 |
| 2618 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:3001  | acquiring total order isolation | Query   | KILL QUERY 2849                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   116 |    0.000 |
| 2608 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:40893 | acquiring total order isolation | Query   | KILL QUERY 2603                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   177 |    0.000 |
| 2606 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:33019 | acquiring total order isolation | Query   | KILL QUERY 2600                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   187 |    0.000 |
| 2602 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:30185 | acquiring total order isolation | Query   | KILL QUERY 7862                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   212 |    0.000 |
| 2601 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:30455 | acquiring total order isolation | Query   | KILL QUERY 7863                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   214 |    0.000 |
| 2590 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:64249 | acquiring total order isolation | Query   | KILL QUERY 2830                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   328 |    0.000 |
| 2583 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:26973 | acquiring total order isolation | Query   | KILL QUERY 2829                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   354 |    0.000 |
| 2577 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:54167 | acquiring total order isolation | Query   | KILL QUERY 2825                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   400 |    0.000 |
| 2561 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:33323 | acquiring total order isolation | Query   | KILL QUERY 2558                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   532 |    0.000 |
| 2552 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:55565 | acquiring total order isolation | Query   | KILL QUERY 2806                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   640 |    0.000 |
| 2549 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:32467 | acquiring total order isolation | Query   | KILL QUERY 7793                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   681 |    0.000 |
| 2538 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:56833 | acquiring total order isolation | Query   | KILL QUERY 2795                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   745 |    0.000 |
| 2537 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:10253 | acquiring total order isolation | Query   | KILL QUERY 7783                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   751 |    0.000 |
| 2524 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18887 | acquiring total order isolation | Query   | KILL QUERY 2520                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   894 |    0.000 |
| 2518 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4675  | acquiring total order isolation | Query   | KILL QUERY 2516                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   930 |    0.000 |
| 2515 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4347  | acquiring total order isolation | Query   | KILL QUERY 2512                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   967 |    0.000 |
| 2513 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41717 | acquiring total order isolation | Query   | KILL QUERY 2776                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   983 |    0.000 |
| 2511 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:63299 | acquiring total order isolation | Query   | KILL QUERY 7755                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1004 |    0.000 |
| 2510 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9445  | acquiring total order isolation | Query   | KILL QUERY 2774                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1018 |    0.000 |
| 2506 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31197 | acquiring total order isolation | Query   | KILL QUERY 7748                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1073 |    0.000 |
| 2501 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:22705 | acquiring total order isolation | Query   | KILL QUERY 2500                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1124 |    0.000 |
| 2496 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:15569 | Commit                          | Query   | update CSS_RoutingInfo set remarks = 'No Working Lines Found' ,WORKING_LINES = '0'  where  PROCESSEDDATE is null  and CSS_Orderno = 'DTV225/07'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1211 |    0.000 |
| 2494 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:1731  | Commit                          | Query   | Update flowqueue_sogea_fttc  set status ='Processed', remarks ='Acknowledged exception' where seid ='363929501'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1260 |    0.000 |
| 2493 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:8529  | acquiring total order isolation | Query   | KILL QUERY 7723                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1265 |    0.000 |
| 2492 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19965 | acquiring total order isolation | Query   | KILL QUERY 7724                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  1301 |    0.000 |
| 2380 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19605 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 11549 |    0.000 |
| 2626 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:20823 | Commit                          | Query   | INSERT INTO Total_Jobs_Log  (Queue,ProcessDate,JobNumber,CSSDB,ActStatus,Priority,ARD,Telephone,CustomerName,Exch,Description,Notes,InstanceID,Domain_Desc) VALUES ('RITWISDN',Convert( '2023-08-17 08:43:34', DateTime),'GPB274/19','SS','PAA','3','03/07/2023 17:00:00','01225466404','SERVICE PROVIDER BT RETAIL','KMD','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |    73 |    0.000 |
| 2589 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:25753 | Commit                          | Query   | INSERT INTO Total_Jobs_Log  (Queue,ProcessDate,JobNumber,CSSDB,ActStatus,Priority,ARD,Telephone,CustomerName,Exch,Description,Notes,InstanceID,Domain_Desc) VALUES ('RITWISDN',Convert( '2023-08-17 08:39:16', DateTime),'GPB190/20','SS','PAA','3','03/07/2023 17:00:00','01225460987','SERVICE PROVIDER BT RETAIL','KMD','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |   332 |    0.000 |
| 2570 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:10347 | Commit                          | Query   | INSERT INTO Total_Jobs_Log  (Queue,ProcessDate,JobNumber,CSSDB,ActStatus,Priority,ARD,Telephone,CustomerName,Exch,Description,Notes,InstanceID,Domain_Desc) VALUES ('RITWISDN',Convert( '2023-08-17 08:37:07', DateTime),'GPB177/19','SS','PAA','3','03/07/2023 17:00:00','01225469396','SERVICE PROVIDER BT RETAIL','KMD','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |   461 |    0.000 |
| 2529 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:15807 | Commit                          | Query   | INSERT INTO Total_Jobs_Log  (Queue,ProcessDate,JobNumber,CSSDB,ActStatus,Priority,ARD,Telephone,CustomerName,Exch,Description,Notes,InstanceID,Domain_Desc) VALUES ('RITWISDN',Convert( '2023-08-17 08:30:38', DateTime),'TNH452/19','SL','PAA','3','11/08/2023 17:00:00','01724278983','SERVICE PROVIDER BT RETAIL','SEK','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |   850 |    0.000 |
 
64 rows in set (0.002 sec)

MariaDB [(none)]> exit
Bye
[mysql@blp21152018 log]$
