MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 3     |
+--------------------+-------+
1 row in set (0.001 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:49833 | Update                          |    2 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:57643 | NULL                            |   11 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:51271 | Update                          |   33 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:1029  | Updating                        |   43 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27615 | acquiring total order isolation |    7 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:6919  | Commit                          |  115 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37497 |                                 |    4 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5643  | acquiring total order isolation |  205 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:59931 |                                 |  258 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2561  | Commit                          |  278 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:63963 | Commit                          |  312 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:49397 | Commit                          |  394 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:21729 | Commit                          |  487 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37961 | Commit                          |  564 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:25603 | acquiring total order isolation |  577 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:43493 | Commit                          |  645 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:45973 | Commit                          |  676 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46155 | Commit                          |  687 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:62981 | Commit                          |  781 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:61695 | Commit                          |  907 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:8199  | Commit                          |  878 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55909 |                                 |   13 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55127 |                                 |    8 | Sleep   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:32259 | Updating                        |   48 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:56985 | acquiring total order isolation |   52 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:5575  | acquiring total order isolation |   90 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:11307 | acquiring total order isolation |   97 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24935 | acquiring total order isolation |  124 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:58913 | acquiring total order isolation |  197 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9197  | acquiring total order isolation |  232 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:47481 | acquiring total order isolation |  238 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41313 | acquiring total order isolation |  303 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:60795 | acquiring total order isolation |  377 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:42333 | acquiring total order isolation |  450 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31981 | acquiring total order isolation |  485 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9545  | acquiring total order isolation |  575 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:16501 | acquiring total order isolation |  666 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18179 | acquiring total order isolation |  716 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:52001 | acquiring total order isolation |  736 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31583 | acquiring total order isolation |  771 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:53507 | acquiring total order isolation |  822 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18145 | acquiring total order isolation |  847 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31355 | Commit                          |  959 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:51555 | Commit                          |  959 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:12989 | Commit                          |  218 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:63335 | Commit                          |  607 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:63655 | Commit                          |  737 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:58705 | Commit                          |  864 | Query   |
+--------------+------------+------------------------------------------+---------------------------------+------+---------+
48 rows in set (0.001 sec)


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 |
 
| 7884 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:35539 | Sending data                    | Query   | UPDATE TBL_LINKED_ORDERS T
 INNER JOIN TBL_LINKED_ORDERS_INPUT I
 ON T.LEAD_JIN = I.LEAD_JIN AND T.CHILD_JIN = I.CHILD_JIN
 SET T.LEAD_DATE = I.LEAD_DATE,
        T.LEAD_STATUS = I.LEAD_STATUS,
        T.CHILD_DATE = I.CHILD_DATE,
        T.CHILD_STATUS = I.CHILD_STATUS,
        T.WMQUEUE = I.WMQUEUE
        wHERE
     CASE T.LEAD_DATE WHEN I.LEAD_DATE THEN 1 ELSE 0 END = 0
    OR CASE T.CHILD_DATE WHEN I.CHILD_DATE THEN 1 ELSE 0 END = 0
    OR CASE T.LEAD_STATUS WHEN I.LEAD_STATUS THEN 1 ELSE 0 END = 0
    OR CASE T.CHILD_STATUS WHEN I.CHILD_STATUS THEN 1 ELSE 0 END = 0
    OR CASE T.WMQUEUE WHEN I.WMQUEUE THEN 1 ELSE 0 END = 0                        |   11 |    0.000 |
| 7883 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:35215 | acquiring total order isolation | Query   | KILL QUERY 2847                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   15 |    0.000 |
| 7879 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:52453 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:3e32cf3beef647298c4a35924dcd1203' 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`)                                                                                                                                                                                                                                                                                                                        |   62 |    0.000 |
| 7871 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:3105  | Commit                          | Query   | INSERT
  INTO TBL_QUEUECLEAN_LOG
    (
      DATE_ENTERED,
      CSSDB,
      CSSJOBNUMBER,
      ACTIVITY,
      OUTCOME
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('DB_IN',_latin1'NI' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('JOB_IN',_latin1'CZK487' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('OUTCOME_IN',_latin1'Old Appt Left in Delay Amendment Accepted' COLLATE 'latin1_swedish_ci')
    )                                                                                                                                       |   18 |    0.000 |
| 7868 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:29099 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:b6a7f7b5466f4b1499611c068047a2d3' 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`)                                                                                                                                                                                                                                                                                                                        |  186 |    0.000 |
| 7867 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37533 | acquiring total order isolation | Query   | KILL QUERY 2588                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  190 |    0.000 |
| 7865 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:60365 | Commit                          | Query   | INSERT
  INTO TBL_QUEUECLEAN_LOG
    (
      DATE_ENTERED,
      CSSDB,
      CSSJOBNUMBER,
      ACTIVITY,
      OUTCOME
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('DB_IN',_latin1'SM' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('JOB_IN',_latin1'HDC312' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'05' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('OUTCOME_IN',_latin1'Old Appt Left in Delay Amendment Accepted' COLLATE 'latin1_swedish_ci')
    )                                                                                                                                       |  210 |    0.000 |
| 7852 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41973 | acquiring total order isolation | Query   | truncate table TBL_TASKFORCE_DATA_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |  289 |    0.000 |
| 7846 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:62589 | acquiring total order isolation | Query   | truncate table TBL_TASKFORCE_DATA_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |  320 |    0.000 |
| 7836 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27615 | acquiring total order isolation | Query   | truncate table TBL_TASKFORCE_DATA_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |  353 |    0.000 |
| 7825 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:6919  | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'ES-NHN266/08' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'ES' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'NHN266' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'08' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIDTF1R' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |  461 |    0.000 |
| 7818 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37497 | Commit                          | Query   | INSERT
  INTO TBL_QUEUECLEAN_LOG
    (
      DATE_ENTERED,
      CSSDB,
      CSSJOBNUMBER,
      ACTIVITY,
      OUTCOME
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('DB_IN',_latin1'SM' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('JOB_IN',_latin1'HBQ725' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('OUTCOME_IN',_latin1'Old Appt Left in Delay Amendment Accepted' COLLATE 'latin1_swedish_ci')
    )                                                                                                                                       |  245 |    0.000 |
| 7813 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5643  | acquiring total order isolation | Query   | KILL QUERY 2544                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  551 |    0.000 |
| 7801 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:2561  | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'WS-NZY862/07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'NZY862' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIDGW1B' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |  624 |    0.000 |
| 7795 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:63963 | Commit                          | Query   | INSERT
  INTO TBL_NOTES_LOG
    (
      PK_ORDER,
      DB,
      ORDER_NUMBER,
      ACTIVITY,
      CSSQUEUE,
      REQ_DATE,
      DATE_ENTERED
    )
    VALUES
    (
       NAME_CONST('PK_IN',_latin1'SS-GTX150/08' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'SS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'GTX150' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'08' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIDSI1R' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    ) |  658 |    0.000 |
| 7785 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:49397 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                               |  740 |    0.000 |
| 7774 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:21729 | Commit                          | Query   | UPDATE TBL_NAMEDENG_UPDATE_LOG SET DATEUPDATED = SYSDATE() WHERE TYPEOFUPDATE = 'TaskForce'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |  833 |    0.000 |
| 7767 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37961 | 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'                                                                                                                                                                                                                                                                                                                                                                                                                             |  910 |    0.000 |
| 7765 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:25603 | acquiring total order isolation | Query   | KILL QUERY 2771                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  923 |    0.000 |
| 7757 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:43493 | Commit                          | Query   | UPDATE TBL_NAMEDENG_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = 'False' WHERE EIN =  NAME_CONST('EIN_IN',_latin1'614358993' COLLATE 'latin1_swedish_ci') and USERDISABLED = 'False'                                                                                                                                                                                                                                                                                                                                                                                                                             |  991 |    0.000 |
| 7753 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:45973 | 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'614358993' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                                                               | 1022 |    0.000 |
| 7752 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:46155 | 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'614391587' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                                                               | 1033 |    0.000 |
| 7742 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:62981 | Commit                          | Query   | UPDATE SMS_PORT_REQUESTS SET RETURN_MESSAGE =  NAME_CONST('MESSAGE_IN',_latin1'Port 44 : 01475 707042  \r\nPort 45 : 01475 795163  \r\nPort 46 : 01475 700700' COLLATE 'latin1_swedish_ci'), ROBO_STATUS = 'COMPLETE', EIN =  NAME_CONST('EIN_IN',_latin1'612812251' COLLATE 'latin1_swedish_ci') WHERE RECID =  NAME_CONST('RECID_IN',782209)                                                                                                                                                                                                                                                                                                      | 1127 |    0.000 |
| 7735 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:61695 | 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'615352990' COLLATE 'latin1_swedish_ci')                                                                                                                                                                                                                                                                                                                                                                                                                               | 1253 |    0.000 |
| 7730 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:8199  | Commit                          | Query   | INSERT
  INTO TBL_NAMEDENG_RECORDLOCKING
    (
      CSS_ORDER,
      EIN,
      USERNAME,
      DATELOCKED
    )
    VALUES
    (
       NAME_CONST('CSSORDER_IN',_latin1'BSB762MY' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EIN_IN',_latin1'614391587' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('USERNAME_IN',_latin1'Ankita Mishra' COLLATE 'latin1_swedish_ci'),
      SYSDATE()
    )                                                                                                                                                                                                                                           | 1224 |    0.000 |
| 7616 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55909 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |   27 |    0.000 |
| 7475 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:55127 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |   23 |    0.000 |
| 7886 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:30481 | Updating                        | Query   | Update flowqueue_sogea_fttc  set status ='Processed', remarks ='Acknowledged exception' where seid ='363928835'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    5 |    0.000 |
| 7885 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:20875 | acquiring total order isolation | Query   | KILL QUERY 2630                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |    7 |    0.000 |
| 7882 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:56681 | acquiring total order isolation | Query   | KILL QUERY 7881                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   20 |    0.000 |
| 7876 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:28979 | acquiring total order isolation | Query   | KILL QUERY 2609                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  114 |    0.000 |
| 7861 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:47745 | acquiring total order isolation | Query   | KILL QUERY 7858                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  222 |    0.000 |
| 7856 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:39995 | acquiring total order isolation | Query   | KILL QUERY 2592                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  258 |    0.000 |
| 7850 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24375 | acquiring total order isolation | Query   | KILL QUERY 2584                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  293 |    0.000 |
| 7834 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:56985 | acquiring total order isolation | Query   | KILL QUERY 7830                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  398 |    0.000 |
| 7829 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:5575  | acquiring total order isolation | Query   | KILL QUERY 7824                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  436 |    0.000 |
| 7828 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:11307 | acquiring total order isolation | Query   | KILL QUERY 2565                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  443 |    0.000 |
| 7823 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24935 | acquiring total order isolation | Query   | KILL QUERY 2563                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  470 |    0.000 |
| 7814 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:58913 | acquiring total order isolation | Query   | KILL QUERY 2555                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  544 |    0.000 |
| 7809 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9197  | acquiring total order isolation | Query   | KILL QUERY 2553                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  578 |    0.000 |
| 7808 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:47481 | acquiring total order isolation | Query   | KILL QUERY 7803                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  584 |    0.000 |
| 7797 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41313 | acquiring total order isolation | Query   | KILL QUERY 2802                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  649 |    0.000 |
| 7787 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:60795 | acquiring total order isolation | Query   | KILL QUERY 2535                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  723 |    0.000 |
| 7780 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:42333 | acquiring total order isolation | Query   | KILL QUERY 2530                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  796 |    0.000 |
| 7775 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31981 | acquiring total order isolation | Query   | KILL QUERY 2525                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  831 |    0.000 |
| 7766 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:9545  | acquiring total order isolation | Query   | KILL QUERY 2778                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  921 |    0.000 |
| 7754 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:16501 | acquiring total order isolation | Query   | KILL QUERY 2507                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1012 |    0.000 |
| 7750 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18179 | acquiring total order isolation | Query   | KILL QUERY 2502                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1063 |    0.000 |
| 7747 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:52001 | acquiring total order isolation | Query   | KILL QUERY 2769                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1082 |    0.000 |
| 7744 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31583 | acquiring total order isolation | Query   | KILL QUERY 2498                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1117 |    0.000 |
| 7739 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:53507 | acquiring total order isolation | Query   | KILL QUERY 2495                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1168 |    0.000 |
| 7738 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:18145 | acquiring total order isolation | Query   | KILL QUERY 2756                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1193 |    0.000 |
| 7732 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31355 | Commit                          | Query   | update CSS_RoutingInfo set remarks = 'No Working Lines Found' ,WORKING_LINES = '0'  where  PROCESSEDDATE is null  and CSS_Orderno = 'DXT506/08'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1305 |    0.000 |
| 7724 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:51555 | Commit                          | Query   | Update flowqueue_sogea_fttc  set status ='Processed', remarks ='Acknowledged exception' where seid ='363929503'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1305 |    0.000 |
| 7870 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:23177 | 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:41:25', DateTime),'GPB222/19','SS','PAA','3','03/07/2023 17:00:00','01225469188','SERVICE PROVIDER BT RETAIL','KMD','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |  176 |    0.000 |
| 7811 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:12989 | 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:34:58', DateTime),'GPB146/19','SS','PAA','3','30/06/2023 17:00:00','01225462557','SERVICE PROVIDER BT RETAIL','KMD','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                  |  564 |    0.000 |
| 7761 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:63335 | 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:28:28', DateTime),'STX506/19','SD','PAA','3','28/06/2023 17:00:00','01329668293','SERVICE PROVIDER BT RETAIL','STBBN','WLR3 PROVIDE DIGITAL SYS/STD','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                |  954 |    0.000 |
| 7746 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:63655 | 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:26:19', DateTime),'DTZ737/04','NE','PAA','3','14/08/2023 17:00:00','01914560493','SERVICE PROVIDER   VERASTAR LIMITED','SS','WLR3 MODIFY DIGITAL SYS/STD','Invalid DAJ Effective activity I1CH04IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                           | 1083 |    0.000 |
| 7737 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:58705 | 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:24:11', DateTime),'MYH312/18','ND','PAA','3','11/08/2023 17:00:00','01634893340','SERVICE PROVIDER BT RETAIL','CDO','WLR3 PROVIDE DIGITAL STANDARD MS','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                              | 1210 |    0.000 |
 
59 rows in set (0.001 sec)



