

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 | 14852059 |
+----------------------+----------+
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:51043 | Commit                          |   44 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18177 | acquiring total order isolation |   88 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:5225  |                                 |   15 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:17843 | Commit                          |  155 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:25037 |                                 |   45 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:34939 | Commit                          |  169 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:26717 | Commit                          |  188 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:33325 | Commit                          |  192 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:42785 | Commit                          |  219 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18249 | Commit                          |  222 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41625 | acquiring total order isolation |  250 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:48447 | Commit                          |  253 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:33351 | Commit                          |  227 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:1595  |                                 |  280 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41817 | Commit                          |  317 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24821 | Commit                          |  339 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:34719 | Commit                          |  397 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18251 | Commit                          |  464 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24649 | Commit                          |  495 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:3349  |                                 |   45 | Sleep   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:30869 | Commit                          |  534 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:1669  | Commit                          |  580 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40105 | Commit                          |  591 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:20141 | Commit                          |  608 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27069 | Commit                          |  614 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:10659 | Commit                          |  705 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:62587 | acquiring total order isolation |  735 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24479 | Commit                          |  806 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27833 | Commit                          |  959 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:14463 | Commit                          |  970 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18375 | Commit                          |  921 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:59563 | Commit                          | 1007 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:50801 | Commit                          | 1017 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27765 | Commit                          | 1037 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:26397 | Commit                          | 1047 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27831 | Commit                          | 1050 | Query   |
| titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:43377 |                                 |   45 | Sleep   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:36637 | Updating                        |   19 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19995 | acquiring total order isolation |   25 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:2873  | acquiring total order isolation |   33 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:14347 | acquiring total order isolation |  152 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:54479 | acquiring total order isolation |  175 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:32679 | acquiring total order isolation |  268 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:7159  | acquiring total order isolation |  345 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31035 | acquiring total order isolation |  420 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:3063  | acquiring total order isolation |  456 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:22979 | acquiring total order isolation |  501 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:62851 | acquiring total order isolation |  512 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:15675 | Commit                          |  683 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17077 | acquiring total order isolation |  688 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17515 | acquiring total order isolation |  795 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:53877 | acquiring total order isolation |  816 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24441 | acquiring total order isolation |  865 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41255 | acquiring total order isolation |  888 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17753 | acquiring total order isolation |  936 | Query   |
| sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4891  | Commit                          | 1028 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:41783 | Commit                          |  354 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:45033 | Commit                          | 1001 | Query   |
| roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:31279 |                                 | 1279 | Sleep   |
| ndc          | NDCUSER    | blp21152024.iuser.iroot.adidom.com:11537 | acquiring total order isolation | 1004 | Query   |
+--------------+------------+------------------------------------------+---------------------------------+------+---------+
60 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 |
 
| 2859 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:37787 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483134410' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'LS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'DEP' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAQYP' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',15)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |   11 |    0.000 |
| 2858 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:15633 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483959461' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'SW' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'WJK' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCKXD' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',377)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |   27 |    0.000 |
| 2857 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40637 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   61 |    0.000 |
| 2851 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:38265 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |  124 |    0.000 |
| 2847 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:22227 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:3e47ca4d60db4b66aecf71deea13b5a1' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  152 |    0.000 |
| 2846 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:4533  | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483134410' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'LS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'DEP' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAQYP' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',15)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |  170 |    0.000 |
| 2843 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:21233 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483959461' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'SW' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'WJK' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCKXD' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',377)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  205 |    0.000 |
| 2840 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:31367 | acquiring total order isolation | Query   | truncate table TBL_TASKFORCE_DATA_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |  244 |    0.000 |
| 2837 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:30971 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:d061117c9f804158aadd40953df0daa9' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  276 |    0.000 |
| 2835 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:44039 | acquiring total order isolation | Query   | KILL QUERY 2826                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  281 |    0.000 |
| 2833 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:52399 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483141826' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'NS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'DEN' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NNAVKB' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',28)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |  315 |    0.000 |
| 2826 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:51043 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:827a94d8dbfb4ee5a866632c430d2795' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  401 |    0.000 |
| 2823 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18177 | acquiring total order isolation | Query   | KILL QUERY 2557                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  445 |    0.000 |
| 2820 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:17843 | 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-JLF119/07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'EM' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'JLF119' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIDDY1R' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    )                                                                                                                                                                                                                                                                                                                                                                                                              |  511 |    0.000 |
| 2819 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:25037 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   40 |    0.000 |
| 2818 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:34939 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:4d602720435a4599a34003588cae5b11' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  526 |    0.000 |
| 2816 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:26717 | 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-JKY608/07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'EM' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'JKY608' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'07' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIDDY1R' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    )                                                                                                                                                                                                                                                                                                                                                                                                              |  544 |    0.000 |
| 2815 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:33325 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07484061341' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WR' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'NELMS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAJTO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',226)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |  549 |    0.000 |
| 2813 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:42785 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:0bdc2e5b22474319b66e32cf229d5e2d' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  576 |    0.000 |
| 2812 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18249 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07484061341' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WR' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'NELMS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAJTO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',226)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |  579 |    0.000 |
| 2810 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41625 | acquiring total order isolation | Query   | truncate table TBL_LINKED_ORDERS_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |  606 |    0.000 |
| 2809 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:48447 | 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-NYB125/10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ORDER_IN',_latin1'NYB125' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'10' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('QUEUE_IN',_latin1'CIATF6B' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('REQ_DATE_IN',TIMESTAMP'2023-08-17 00:00:00'),
      SYSDATE()
    )                                                                                                                                                                                                                                                                                                                                                                                                              |  610 |    0.000 |
| 2807 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:33351 | Commit                          | Query   | INSERT
  INTO TBL_QUEUECLEAN_LOG
    (
      DATE_ENTERED,
      CSSDB,
      CSSJOBNUMBER,
      ACTIVITY,
      OUTCOME
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('DB_IN',_latin1'CL' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('JOB_IN',_latin1'RSG329' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('ACTIVITY_IN',_latin1'02' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('OUTCOME_IN',_latin1'Old Appt Left in Delay Amendment Accepted' COLLATE 'latin1_swedish_ci')
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |  583 |    0.000 |
| 2804 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:41817 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483152650' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WW' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'PINH' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCMZC' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',76)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  674 |    0.000 |
| 2803 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24821 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483923171' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'SD' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'NWPRT' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NNAAAR' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',193)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |  696 |    0.000 |
| 2798 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:34719 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483324932' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'SW' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'CNE' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCHBE' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',190)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  753 |    0.000 |
| 2791 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18251 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483336205' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'TH' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'AD' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAMAI' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',181)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |  820 |    0.000 |
| 2789 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24649 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07710309263' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'CL' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'SHO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAYOS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',219)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  851 |    0.000 |
| 2786 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:3349  |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   40 |    0.000 |
| 2784 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:30869 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483959060' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'LV' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'ALL' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCQPN' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',175)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  891 |    0.000 |
| 2782 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:1669  | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:581ad8d128cc474a8d75c7ce45796704' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  937 |    0.000 |
| 2780 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:40105 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |  948 |    0.000 |
| 2779 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:20141 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07710309263' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'CL' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'SHO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMAYOS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',219)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |  964 |    0.000 |
| 2777 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27069 | Commit                          | Query   | INSERT
INTO TBL_HPD_LOG
  (
    DATE_ENTERED,
    TASKID,
    CSS_QUEUE,
    NEW_STATUS,
    JOB_QUEUE,
    JOB_TYPE,
    ORDER_STATUS,
    ACTIVITY_TYPE,
    ACTIVITY_STATUS,
    ACTIVITY_DESC,
    APPT_DATE,
    OUTCOME,
    CSS_TASK
  )
  VALUES
  (
    SYSDATE(),
     NAME_CONST('TASKID_IN',_latin1'R5-WMM46015' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('CSSQUEUE_IN',_latin1'CIDBM1R' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('NEWSTATUS_IN',_latin1'ACT' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('JOBQUEUE_IN',_latin1'BJVOR' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('JOBTYPE_IN',_latin1'PWPNAYELTN' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('ORDERSTATUS_IN',_latin1'ENGS' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('ACTTYPE_IN',_latin1'I1PR04CSS' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('ACTSTATUS_IN',_latin1'WMA' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('ACTDESC_IN',_latin1'CSNO INSTALLATION        Installation Revisit' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('APPTDATE_IN',TIMESTAMP'2023-07-26 00:00:00'),
     NAME_CONST('OUTCOME_IN',_latin1'Revisit activity Dates Aligned' COLLATE 'latin1_swedish_ci'),
     NAME_CONST('CSSTASK_IN',_latin1'CM-WMM46015' COLLATE 'latin1_swedish_ci')
  ) |  971 |    0.000 |
| 2771 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:10659 | Commit                          | Query   | LOAD DATA LOCAL INFILE ':SOURCE:a54837d00cdb458aaa76a1aac7fad668' 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`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1061 |    0.000 |
| 2770 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:62587 | acquiring total order isolation | Query   | truncate table TBL_LINKED_ORDERS_INPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 1092 |    0.000 |
| 2765 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:24479 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483141853' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'CL' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'CAN' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NAABPS' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',32)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 1163 |    0.000 |
| 2750 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27833 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 1316 |    0.000 |
| 2749 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:14463 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 1327 |    0.000 |
| 2746 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:18375 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07483152650' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'WW' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'PINH' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMCMZC' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',80)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1277 |    0.000 |
| 2745 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:59563 | 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'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 1364 |    0.000 |
| 2744 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:50801 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07436278706' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'MY' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'YO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMDZNE' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',7)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 1374 |    0.000 |
| 2741 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27765 | 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')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 1394 |    0.000 |
| 2740 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:26397 | Commit                          | Query   | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
      NODEID,
      TERM_START
    )
    VALUES
    (
      SYSDATE(),
       NAME_CONST('MOBILE_IN',_latin1'07436278706' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('DB_IN',_latin1'MY' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('EXCH_IN',_latin1'YO' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('NODEID_IN',_latin1'NMDZNE' COLLATE 'latin1_swedish_ci'),
       NAME_CONST('TERMSTART_IN',7)
    )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 1404 |    0.000 |
| 2739 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:27831 | 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'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 1407 |    0.000 |
| 2709 | titan        | titanuser  | blp21152024.iuser.iroot.adidom.com:43377 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   40 |    0.000 |
| 2850 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24091 | acquiring total order isolation | Query   | KILL QUERY 2610                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  134 |    0.000 |
| 2839 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:45419 | acquiring total order isolation | Query   | KILL QUERY 7855                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  249 |    0.000 |
| 2838 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:36129 | acquiring total order isolation | Query   | KILL QUERY 7851                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  276 |    0.000 |
| 2828 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:19995 | acquiring total order isolation | Query   | KILL QUERY 7835                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  382 |    0.000 |
| 2827 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:2873  | acquiring total order isolation | Query   | KILL QUERY 2574                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  390 |    0.000 |
| 2821 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:14347 | acquiring total order isolation | Query   | KILL QUERY 2559                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  509 |    0.000 |
| 2817 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:54479 | acquiring total order isolation | Query   | KILL QUERY 2814                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  531 |    0.000 |
| 2808 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:32679 | acquiring total order isolation | Query   | KILL QUERY 7799                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  625 |    0.000 |
| 2801 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:7159  | acquiring total order isolation | Query   | KILL QUERY 2799                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  702 |    0.000 |
| 2794 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:31035 | acquiring total order isolation | Query   | KILL QUERY 2534                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  777 |    0.000 |
| 2792 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:3063  | acquiring total order isolation | Query   | KILL QUERY 7776                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  813 |    0.000 |
| 2788 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:22979 | acquiring total order isolation | Query   | KILL QUERY 2785                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  857 |    0.000 |
| 2787 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:62851 | acquiring total order isolation | Query   | KILL QUERY 7769                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |  869 |    0.000 |
| 2774 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:15675 | Commit                          | Query   | Update flowqueue_sogea_fttc  set status ='Processed', remarks ='Acknowledged exception' where seid ='363929495'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1040 |    0.000 |
| 2773 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17077 | acquiring total order isolation | Query   | KILL QUERY 2505                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1045 |    0.000 |
| 2766 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17515 | acquiring total order isolation | Query   | KILL QUERY 2497                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1151 |    0.000 |
| 2764 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:53877 | acquiring total order isolation | Query   | KILL QUERY 2496                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1173 |    0.000 |
| 2759 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:24441 | acquiring total order isolation | Query   | KILL QUERY 2494                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1222 |    0.000 |
| 2755 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:41255 | acquiring total order isolation | Query   | KILL QUERY 2753                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1245 |    0.000 |
| 2752 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:17753 | acquiring total order isolation | Query   | KILL QUERY 7732                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1293 |    0.000 |
| 2743 | sdautomation | SDUSER     | blp21152024.iuser.iroot.adidom.com:4891  | Commit                          | Query   | update CSS_RoutingInfo set remarks = 'Already sent to sales query ' where PROCESSEDDATE  is null  and CSS_Orderno = 'MYW145/07'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | 1385 |    0.000 |
| 2800 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:41783 | 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:32:48', DateTime),'GZK951/18','SM','PAA','3','10/08/2023 17:00:00','01582691490','SERVICE PROVIDER CORE TELECOMMUNICATIONS LTD','DB','WLR3 PROVIDE DIGITAL SYSTEM DDI','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |  711 |    0.000 |
| 2747 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:45033 | 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:22:02', DateTime),'BNM695/16','MY','PAA','3','08/08/2023 15:30:00','01274541737','SERVICE PROVIDER VODAFONE (WLR04) LIMITED','MAN','WLR3 PROVIDE DIGITAL SYS/STD - W','Invalid DAJ Effective activity I1PR06IDV found.','BWP21152074','WISDN')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 1358 |    0.000 |
| 2715 | roland       | rolanduser | blp21152024.iuser.iroot.adidom.com:31279 |                                 | Sleep   | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1636 |    0.000 |
| 2718 | ndc          | NDCUSER    | blp21152024.iuser.iroot.adidom.com:11537 | acquiring total order isolation | Query   | TRUNCATE TABLE NDC_HADES_CSS_TEST                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 1361 |    0.000 |
 
71 rows in set (0.001 sec)


[root@blp21152017 ~]#
[root@blp21152017 ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.6.11 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since Sat 2023-08-12 18:16:35 BST; 4 days ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 6318 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5947 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? >
  Process: 5945 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 6063 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 102 (limit: 203841)
   Memory: 17.5G
   CGroup: /system.slice/mariadb.service
           └─6063 /usr/sbin/mariadbd --wsrep_start_position=c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:14571877,5-1-14571417

Aug 12 18:16:32 blp21152017 sh[5949]: WSREP: Recovered position c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:14571877,5-1-14571417
Aug 12 18:16:32 blp21152017 mariadbd[6063]: 2023-08-12 18:16:32 0 [Note] /usr/sbin/mariadbd (server 10.6.11-MariaDB-log) starting as process>
Aug 12 18:16:32 blp21152017 mariadbd[6063]: 2023-08-12 18:16:32 0 [Warning] Could not increase number of max_open_files to more than 32768 (>
Aug 12 18:16:33 blp21152017 rsyncd[6194]: rsyncd version 3.1.3 starting, listening on port 4444
Aug 12 18:16:34 blp21152017 rsyncd[6206]: connect from blp21152016.iuser.iroot.adidom.com (10.13.237.28)
Aug 12 18:16:34 blp21152017 rsyncd[6206]: rsync to rsync_sst/ from blp21152016.iuser.iroot.adidom.com (10.13.237.28)
Aug 12 18:16:34 blp21152017 rsyncd[6206]: receiving file list
Aug 12 18:16:34 blp21152017 rsyncd[6206]: sent 48 bytes  received 201 bytes  total size 55
Aug 12 18:16:35 blp21152017 rsyncd[6194]: sent 0 bytes  received 0 bytes  total size 0
Aug 12 18:16:35 blp21152017 systemd[1]: Started MariaDB 10.6.11 database server.

[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]# systemctl stop mariadb
^C
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]# ps -ef|grep maria
mysql       6063       1  4 Aug12 ?        04:48:24 /usr/sbin/mariadbd --wsrep_start_position=c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:14571877,5-1-14571417
root     1921864 1919671  0 09:00 pts/2    00:00:00 grep --color=auto maria
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]# kill -9 6063
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.6.11 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: signal) since Thu 2023-08-17 09:00:20 BST; 23s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 6318 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 6063 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=KILL)
  Process: 5947 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? >
  Process: 5945 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 6063 (code=killed, signal=KILL)
   Status: "Shutdown in progress"

Aug 12 18:16:34 blp21152017 rsyncd[6206]: connect from blp21152016.iuser.iroot.adidom.com (10.13.237.28)
Aug 12 18:16:34 blp21152017 rsyncd[6206]: rsync to rsync_sst/ from blp21152016.iuser.iroot.adidom.com (10.13.237.28)
Aug 12 18:16:34 blp21152017 rsyncd[6206]: receiving file list
Aug 12 18:16:34 blp21152017 rsyncd[6206]: sent 48 bytes  received 201 bytes  total size 55
Aug 12 18:16:35 blp21152017 rsyncd[6194]: sent 0 bytes  received 0 bytes  total size 0
Aug 12 18:16:35 blp21152017 systemd[1]: Started MariaDB 10.6.11 database server.
Aug 17 08:53:47 blp21152017 systemd[1]: Stopping MariaDB 10.6.11 database server...
Aug 17 09:00:20 blp21152017 systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Aug 17 09:00:20 blp21152017 systemd[1]: mariadb.service: Failed with result 'signal'.
Aug 17 09:00:20 blp21152017 systemd[1]: Stopped MariaDB 10.6.11 database server.

[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]#
[root@blp21152017 ~]# systemctl start mariadb
[root@blp21152017 ~]# mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 10.6.11-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                                                                | Info                                                                                                 | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |    0 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |   40 | wsrep aborter idle                                                   | NULL                                                                                                 |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |    0 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |    0 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  9 | system user |                                          | sdautomation | Sleep   |    0 | Update_rows_log_event::find_row(14852500) on table `css_routinginfo` | update CSS_RoutingInfo set remarks = 'Not a Residential Line' where PROCESSEDDATE is null   and CSS_ |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |   33 |                                                                      | NULL                                                                                                 |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |   30 |                                                                      | NULL                                                                                                 |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Sleep   |   25 |                                                                      | NULL                                                                                                 |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                                                             | show processlist                                                                                     |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
9 rows in set (0.000 sec)

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

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

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

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
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 | 14852784 |
+----------------------+----------+
1 row in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
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 | 14852784 |
+----------------------+----------+
1 row in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                                                                | Info                                                                                                 | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |   74 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |  157 | wsrep aborter idle                                                   | NULL                                                                                                 |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |   76 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |   25 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  9 | system user |                                          | sdautomation | Sleep   |    4 | Update_rows_log_event::find_row(14852786) on table `css_routinginfo` | update CSS_RoutingInfo set BATCH ='2' WHERE processeddate is null and Remarks not IN ('DELAYED_TO_SQ |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |   31 |                                                                      | NULL                                                                                                 |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |  147 |                                                                      | NULL                                                                                                 |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Sleep   |  142 |                                                                      | NULL                                                                                                 |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                                                             | show processlist                                                                                     |    0.000 |
| 17 | titanuser   | blp21152024.iuser.iroot.adidom.com:32029 | titan        | Sleep   |   76 |                                                                      | NULL                                                                                                 |    0.000 |
| 19 | SDUSER      | blp21152024.iuser.iroot.adidom.com:24663 | sdautomation | Query   |   36 | acquiring total order isolation                                      | KILL QUERY 7950                                                                                      |    0.000 |
| 21 | titanuser   | blp21152024.iuser.iroot.adidom.com:45325 | titan        | Query   |   12 | Commit                                                               | UPDATE SMS_PORT_REQUESTS SET RETURN_MESSAGE =  NAME_CONST('MESSAGE_IN',_latin1'Port 263 : LLEM0 5602 |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
12 rows in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>

MariaDB [(none)]>
MariaDB [(none)]>  show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                                                                | Info                                                                                                 | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |  113 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |  195 | wsrep aborter idle                                                   | NULL                                                                                                 |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |  114 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |   63 | wsrep applier committed                                              | NULL                                                                                                 |    0.000 |
|  9 | system user |                                          | sdautomation | Sleep   |    5 | Update_rows_log_event::find_row(14852786) on table `css_routinginfo` | update CSS_RoutingInfo set BATCH ='2' WHERE processeddate is null and Remarks not IN ('DELAYED_TO_SQ |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |    9 |                                                                      | NULL                                                                                                 |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |  185 |                                                                      | NULL                                                                                                 |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Query   |   23 | Commit                                                               | UPDATE TBL_TIREPORTS_WEBACCESS SET LAST_ACCESSED = SYSDATE(), EXPIRE_EMAIL = 'False', EXPIRE_FINAL = |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                                                             | show processlist                                                                                     |    0.000 |
| 17 | titanuser   | blp21152024.iuser.iroot.adidom.com:32029 | titan        | Sleep   |  115 |                                                                      | NULL                                                                                                 |    0.000 |
| 19 | SDUSER      | blp21152024.iuser.iroot.adidom.com:24663 | sdautomation | Query   |   74 | acquiring total order isolation                                      | KILL QUERY 7950                                                                                      |    0.000 |
| 21 | titanuser   | blp21152024.iuser.iroot.adidom.com:45325 | titan        | Query   |   50 | Commit                                                               | UPDATE SMS_PORT_REQUESTS SET RETURN_MESSAGE =  NAME_CONST('MESSAGE_IN',_latin1'Port 263 : LLEM0 5602 |    0.000 |
| 22 | titanuser   | blp21152024.iuser.iroot.adidom.com:41639 | titan        | Query   |   35 | NULL                                                                 | INSERT
  INTO SMS_PORT_REQUESTS
    (
      DATE_ENTERED,
      MOBILE,
      CSS_DB,
      EXCH,
   |    0.000 |
| 23 | SDUSER      | blp21152024.iuser.iroot.adidom.com:45603 | sdautomation | Query   |   32 | Commit                                                               | Update flowqueue_sogea_fttc  set status ='Review', remarks =' acknowledge btn not found-might be alr |    0.000 |
| 24 | titanuser   | blp21152024.iuser.iroot.adidom.com:13643 | titan        | Query   |   10 | Updating                                                             | UPDATE SMS_PORT_REQUESTS SET RETURN_MESSAGE =  NAME_CONST('MESSAGE_IN',_latin1'Port 263 : LLEM0 5602 |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
15 rows in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>  show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                   | Info             | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |    3 | wsrep applier committed | NULL             |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |  229 | wsrep aborter idle      | NULL             |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |   19 | wsrep applier committed | NULL             |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |   21 | wsrep applier committed | NULL             |    0.000 |
|  9 | system user |                                          | NULL         | Sleep   |   12 | wsrep applier committed | NULL             |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |   42 |                         | NULL             |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |  218 |                         | NULL             |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Sleep   |   30 |                         | NULL             |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                | show processlist |    0.000 |
| 17 | titanuser   | blp21152024.iuser.iroot.adidom.com:32029 | titan        | Sleep   |  148 |                         | NULL             |    0.000 |
| 24 | titanuser   | blp21152024.iuser.iroot.adidom.com:13643 | titan        | Sleep   |   30 |                         | NULL             |    0.000 |
| 25 | titanuser   | blp21152024.iuser.iroot.adidom.com:30679 | titan        | Sleep   |    1 |                         | NULL             |    0.000 |
| 26 | SDUSER      | blp21152024.iuser.iroot.adidom.com:63913 | sdautomation | Sleep   |    5 |                         | NULL             |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
13 rows in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>  show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                   | Info             | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |   17 | wsrep applier committed | NULL             |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |  243 | wsrep aborter idle      | NULL             |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |    7 | wsrep applier committed | NULL             |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |   13 | wsrep applier committed | NULL             |    0.000 |
|  9 | system user |                                          | NULL         | Sleep   |   26 | wsrep applier committed | NULL             |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |   56 |                         | NULL             |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |  232 |                         | NULL             |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Sleep   |   44 |                         | NULL             |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                | show processlist |    0.000 |
| 17 | titanuser   | blp21152024.iuser.iroot.adidom.com:32029 | titan        | Sleep   |  162 |                         | NULL             |    0.000 |
| 24 | titanuser   | blp21152024.iuser.iroot.adidom.com:13643 | titan        | Sleep   |   44 |                         | NULL             |    0.000 |
| 25 | titanuser   | blp21152024.iuser.iroot.adidom.com:30679 | titan        | Sleep   |    1 |                         | NULL             |    0.000 |
| 26 | SDUSER      | blp21152024.iuser.iroot.adidom.com:63913 | sdautomation | Sleep   |   19 |                         | NULL             |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
13 rows in set (0.000 sec)

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>  show processlist;
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
| Id | User        | Host                                     | db           | Command | Time | State                   | Info             | Progress |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
|  2 | system user |                                          | NULL         | Sleep   |   13 | wsrep applier committed | NULL             |    0.000 |
|  1 | system user |                                          | NULL         | Sleep   |  286 | wsrep aborter idle      | NULL             |    0.000 |
|  7 | system user |                                          | NULL         | Sleep   |   11 | wsrep applier committed | NULL             |    0.000 |
|  6 | system user |                                          | NULL         | Sleep   |   11 | wsrep applier committed | NULL             |    0.000 |
|  9 | system user |                                          | NULL         | Sleep   |    4 | wsrep applier committed | NULL             |    0.000 |
| 12 | dbmonitor   | blp21096007.iuser.iroot.adidom.com:36332 | NULL         | Sleep   |   40 |                         | NULL             |    0.000 |
| 13 | titanuser   | blp21152024.iuser.iroot.adidom.com:32249 | titan        | Sleep   |  276 |                         | NULL             |    0.000 |
| 14 | titanuser   | blp21152024.iuser.iroot.adidom.com:30537 | titan        | Sleep   |    2 |                         | NULL             |    0.000 |
| 15 | root        | localhost                                | NULL         | Query   |    0 | starting                | show processlist |    0.000 |
| 17 | titanuser   | blp21152024.iuser.iroot.adidom.com:32029 | titan        | Sleep   |   15 |                         | NULL             |    0.000 |
| 24 | titanuser   | blp21152024.iuser.iroot.adidom.com:13643 | titan        | Sleep   |   88 |                         | NULL             |    0.000 |
| 26 | SDUSER      | blp21152024.iuser.iroot.adidom.com:63913 | sdautomation | Sleep   |   10 |                         | NULL             |    0.000 |
| 27 | titanuser   | blp21152024.iuser.iroot.adidom.com:65337 | titan        | Sleep   |   33 |                         | NULL             |    0.000 |
+----+-------------+------------------------------------------+--------------+---------+------+-------------------------+------------------+----------+
13 rows in set (0.000 sec)

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 | 14852841 |
+----------------------+----------+
1 row in set (0.000 sec)

MariaDB [(none)]> exit
Bye
[root@blp21152017 ~]#
[root@blp21152017 ~]#