"audit_record": { "name": "Query", "record": "154659583_2022-02-01T14:19:29", "timestamp": "2022-02-03T22:50:44Z", "command_class": "alter_table", "connection_id": "785710", "status": 0, "sqltext": "Alter table `Ref`.`UC_DevType_Acronym` \r\n\tchange `UCA_Acro_Type` `UCA_Acro_Category` varchar(32) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\r\n\tadd column `UCA_Acro_Group` varchar(8) NULL after `UCA_Acro_LongName`,\r\n\tadd column `UCA_Acro_Type` varchar(32) NULL after `UCA_Acro_Group`", "user": "xx", "host": "xx", "os_user": "", "ip": "xx", "db": "Ref" } } { "audit_record": { "name": "Query", "record": "154659949_2022-02-01T14:19:29", "timestamp": "2022-02-03T22:50:55Z", "command_class": "alter_table", "connection_id": "785710", "status": 1138, "sqltext": "Alter table `Ref`.`UC_DevType_Acronym` \r\n\tchange `UCA_Acro_Group` `UCA_Acro_Group` varchar(8) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL first,\r\n\tchange `UCA_Acro_Type` `UCA_Acro_Type` varchar(32) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL after `UCA_Acro_Group`, \r\n drop primary key,\r\n add primary key (`UCA_Acro_Group`, `UCA_Acro_T ype`, `UCA_Acro_Category`, `UCA_Acro_ShortName`)", "user": "xx", "host": "xx", "os_user": "", "ip": "xx", "db": "Ref" } ------------------ Error Log { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655474, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Member 0(server2) initiates vote on 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747,a137104158dda842: Invalid use of NULL value, Error_code: 1138;", "time": "2022-02-03T17:50:55.474021-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655474, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Votes over 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2761303580:\n 0000000000000000: 2/5\n c18fdc8270b5a4e5: 3/5\nWinner: c18fdc8270b5a4e5", "time": "2022-02-03T17:50:55.474674-05:00", "label": "Note" } { "prio": 1, "subsystem": "Galera", "component": "Galera", "source_line": 616, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Got negative vote on successfully applied 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2761303580", "time": "2022-02-03T17:50:55.474768-05:00", "ts": 1643928655474, "thread": 29, "label": "Error" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Closing send monitor...", "time": "2022-02-03T17:50:55.475407-05:00", "ts": 1643928655475, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Closed send monitor.", "time": "2022-02-03T17:50:55.475436-05:00", "ts": 1643928655475, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "gcomm: terminating thread", "time": "2022-02-03T17:50:55.475460-05:00", "ts": 1643928655475, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "gcomm: joining thread", "time": "2022-02-03T17:50:55.475483-05:00", "ts": 1643928655475, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "gcomm: closing backend", "time": "2022-02-03T17:50:55.475752-05:00", "ts": 1643928655475, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655498, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Member 1(server3) initiates vote on 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747,a137104158dda842: Invalid use of NULL value, Error_code: 1138;", "time": "2022-02-03T17:50:55.498533-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655498, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Votes over 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747:\n a137104158dda842: 2/5\nWaiting for more votes.", "time": "2022-02-03T17:50:55.498589-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655498, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Member 3(server3) initiates vote on 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747,a137104158dda842: Invalid use of NULL value, Error_code: 1138;", "time": "2022-02-03T17:50:55.498620-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928655498, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Votes over 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747:\n a137104158dda842: 3/5\nWinner: a137104158dda842", "time": "2022-02-03T17:50:55.498638-05:00", "label": "Note" } { "prio": 2, "subsystem": "Galera", "component": "Galera", "ts": 1643928655499, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Failed to report last committed 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588739, -77 (File descriptor in bad state)", "time": "2022-02-03T17:50:55.499487-05:00", "label": "Warning" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Current view of cluster as seen by this node\nview (view_id(NON_PRIM,0ee0169d-87a8,476)\nmemb {\n\t0ee0169d-87a8,0\n\t}\njoined {\n\t}\nleft {\n\t}\npartitioned {\n\t53cc0556-94ff,0\n\t72327c6c-a29f,0\n\ta3aa2cd1-ab06,0\n\tc63694db-a6b5,0\n\t}\n)", "time": "2022-02-03T17:50:56.504646-05:00", "ts": 1643928656504, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "PC protocol downgrade 1 -> 0", "time": "2022-02-03T17:50:56.505365-05:00", "ts": 1643928656505, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Current view of cluster as seen by this node\nview ((empty))", "time": "2022-02-03T17:50:56.505397-05:00", "ts": 1643928656505, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "gcomm: closed", "time": "2022-02-03T17:50:56.520630-05:00", "ts": 1643928656520, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1", "time": "2022-02-03T17:50:56.524282-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Flow-control interval: [200, 200]", "time": "2022-02-03T17:50:56.524359-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Received NON-PRIMARY.", "time": "2022-02-03T17:50:56.524384-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Shifting SYNCED -> OPEN (TO: 2781588756)", "time": "2022-02-03T17:50:56.524401-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "New SELF-LEAVE.", "time": "2022-02-03T17:50:56.524422-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Flow-control interval: [0, 0]", "time": "2022-02-03T17:50:56.524464-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Received SELF-LEAVE. Closing connection.", "time": "2022-02-03T17:50:56.524479-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Shifting OPEN -> CLOSED (TO: 2781588756)", "time": "2022-02-03T17:50:56.524490-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928656524, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "RECV thread exiting 0: Success", "time": "2022-02-03T17:50:56.524511-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "recv_thread() joined.", "time": "2022-02-03T17:50:56.535246-05:00", "ts": 1643928656535, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Closing replication queue.", "time": "2022-02-03T17:50:56.535294-05:00", "ts": 1643928656535, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 29, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Closing slave action queue.", "time": "2022-02-03T17:50:56.535309-05:00", "ts": 1643928656535, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 51, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Got vote request for seqno 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588747", "time": "2022-02-03T17:50:56.535347-05:00", "ts": 1643928656535, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 28, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "================================================\nView:\n id: 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588756\n status: non-primary\n protocol_version: 4\n capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO\n final: no\n own_index: 0\n members(1):\n\t0: 0ee0169d-8366-11ec-87a8-daf06975324d, server2\n=================================================", "time": "2022-02-03T17:50:56.537598-05:00", "ts": 1643928656537, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 28, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Non-primary view", "time": "2022-02-03T17:50:56.537665-05:00", "ts": 1643928656537, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 28, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "================================================\nView:\n id: 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:2781588756\n status: non-primary\n protocol_version: 4\n capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO\n final: yes\n own_index: -1\n members(0):\n=================================================", "time": "2022-02-03T17:50:57.617729-05:00", "ts": 1643928657617, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 28, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Non-primary view", "time": "2022-02-03T17:50:57.617753-05:00", "ts": 1643928657617, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928658967, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Service thread queue flushed.", "time": "2022-02-03T17:50:58.967759-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "thread": 28, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5", "time": "2022-02-03T17:50:58.968044-05:00", "ts": 1643928658968, "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827831, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "dtor state: CLOSED", "time": "2022-02-03T17:53:47.831592-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827831, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "MemPool(TrxHandleSlave): hit ratio: 0.999135, misses: 16721, in use: 0, in pool: 2049", "time": "2022-02-03T17:53:47.831672-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827834, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "mon: entered 19307373 oooe fraction 0 oool fraction 0", "time": "2022-02-03T17:53:47.834435-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827837, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "mon: entered 19307373 oooe fraction 0.448133 oool fraction 0.00484349", "time": "2022-02-03T17:53:47.837292-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "mon: entered 19870190 oooe fraction 0 oool fraction 5.03266e-08", "time": "2022-02-03T17:53:47.840061-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "cert index usage at exit 0", "time": "2022-02-03T17:53:47.840100-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "cert trx map usage at exit 0", "time": "2022-02-03T17:53:47.840115-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "deps set usage at exit 0", "time": "2022-02-03T17:53:47.840128-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "avg deps dist 8.99831", "time": "2022-02-03T17:53:47.840143-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "avg cert interval 2.35482e+06", "time": "2022-02-03T17:53:47.840158-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "cert index size 1103", "time": "2022-02-03T17:53:47.840171-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827840, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Service thread queue flushed.", "time": "2022-02-03T17:53:47.840218-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827843, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "wsdb trx map usage 0 conn query map usage 0", "time": "2022-02-03T17:53:47.843661-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827843, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "MemPool(LocalTrxHandle): hit ratio: 0.999996, misses: 75, in use: 0, in pool: 75", "time": "2022-02-03T17:53:47.843714-05:00", "label": "Note" } { "prio": 3, "subsystem": "Galera", "component": "Galera", "ts": 1643928827856, "source_file": "wsrep_mysqld.cc", "function": "wsrep_log_cb", "mlv": 3, "msg": "Flushing memory map to disk...", "time": "2022-02-03T17:53:47.856201-05:00", "label": "Note" }