· 8 years ago · Nov 24, 2017, 08:22 AM
1I, [2017-11-24T06:45:46.195261 #9205] INFO -- : == Checking mysql cluster galera-galera
2I, [2017-11-24T06:45:46.195283 #9205] INFO -- : Connecting to mysql server (host: xxx, user: root)
3I, [2017-11-24T06:45:46.209780 #9205] INFO -- : Creating db if not exists MYSQLMON_DB
4I, [2017-11-24T06:45:46.219488 #9205] INFO -- : Selecting db MYSQLMON_DB
5I, [2017-11-24T06:45:46.223361 #9205] INFO -- : Creating table if not exists TABLE1 in MYSQLMON_DB
6I, [2017-11-24T06:45:46.233695 #9205] INFO -- : Inserting record 7e4f4be4-4378-475d-b0ba-3aae40378edd
7I, [2017-11-24T06:45:46.240429 #9205] INFO -- : INSERT INTO TABLE1 VALUES ('7e4f4be4-4378-475d-b0ba-3aae40378edd')
8I, [2017-11-24T06:45:46.240468 #9205] INFO -- : Reading record 7e4f4be4-4378-475d-b0ba-3aae40378edd
9I, [2017-11-24T06:45:46.244716 #9205] INFO -- : Success
10I, [2017-11-24T06:45:46.244748 #9205] INFO -- : Cleaning up record 7e4f4be4-4378-475d-b0ba-3aae40378edd
11I, [2017-11-24T06:45:46.251406 #9205] INFO -- : sending metric cluster_state 0 for cluster galera-galera to telegraf ...
12
13I, [2017-11-23T14:42:54.538746 #9205] INFO -- : == Checking mysql cluster galera-galera
14I, [2017-11-23T14:42:54.538766 #9205] INFO -- : Connecting to mysql server (host: xxx, user: root)
15I, [2017-11-23T14:42:54.543844 #9205] INFO -- : Creating db if not exists MYSQLMON_DB
16I, [2017-11-23T14:43:24.564137 #9205] INFO -- : Cleaning up record 30884581-6838-4b8a-a679-cc32d66e49e3
17E, [2017-11-23T14:43:24.564249 #9205] ERROR -- : Error occurred for cluster galera-galera: Timeout waiting for a response from the last query. (waited 30 seconds)
18I, [2017-11-23T14:43:24.564271 #9205] INFO -- : sending metric cluster_state 1 for cluster galera-galera to telegraf ...
19
20> SHOW GLOBAL VARIABLES LIKE '%version%';
21+-------------------------+---------------------------+
22| Variable_name | Value |
23+-------------------------+---------------------------+
24| innodb_version | 5.6.35-80.0 |
25| protocol_version | 10 |
26| slave_type_conversions | |
27| version | 10.1.22-MariaDB |
28| version_comment | Source distribution |
29| version_compile_machine | x86_64 |
30| version_compile_os | Linux |
31| version_malloc_library | system |
32| version_ssl_library | OpenSSL 1.0.1f 6 Jan 2014 |
33| wsrep_patch_version | wsrep_25.16 |
34+-------------------------+---------------------------+
3510 rows in set (0.00 sec)
36
372017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : Start
382017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
392017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
402017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : Start applying row log
412017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : End of applying row log
422017-11-23 15:48:09 140107652926208 [Note] InnoDB: Online DDL : Completed
432017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : Start
442017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
452017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
462017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : Start applying row log
472017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : End of applying row log
482017-11-23 15:48:11 140107652926208 [Note] InnoDB: Online DDL : Completed