## Conf hod04 90457.cnf [mysqld] core-file basedir = /export/home/ushastry/mysql-8.0.4 datadir = /export/home/ushastry/mysql-8.0.4/data/ plugin-load = group_replication.so port = 3333 log_bin socket = /tmp/mysql_hod04.sock disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571707 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod04.no.oracle.com:6607 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE # enabled for https://bugs.mysql.com/bug.php?id=86979 group_replication_start_on_boot=FALSE hod06 90457.cnf [mysqld] core-file basedir = /export/home/ushastry/mysql-8.0.4 datadir = /export/home/ushastry/mysql-8.0.4/data/ plugin-load = group_replication.so port = 3333 log_bin socket = /tmp/mysql_hod06.sock disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571708 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod06.no.oracle.com:6608 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE # enabled for https://bugs.mysql.com/bug.php?id=86979 group_replication_start_on_boot=FALSE -- hod03 90457.cnf [mysqld] core-file basedir = /export/umesh/server/binaries/Trunk/mysql-8.0.4 datadir = /export/umesh/server/binaries/Trunk/mysql-8.0.4/data/ plugin-load = group_replication.so port = 3333 socket = /tmp/mysql_hod03.sock log_bin disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571706 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod03.no.oracle.com:6606 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE group_replication_start_on_boot=FALSE hod03 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./90457.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./90457.cnf --log-error=hod03.err --core-file 2>&1 & hod04 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./90457.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./90457.cnf --log-error=hod04.err --core-file 2>&1 & hod06 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./90457.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./90457.cnf --log-error=hod06.err --core-file 2>&1 & - hod03(node 1) CREATE USER 'rpl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'rpl_pass'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SHOW GLOBAL VARIABLES LIKE 'group_replication%'; SET GLOBAL group_replication_bootstrap_group=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery'; START GROUP_REPLICATION; SET GLOBAL group_replication_bootstrap_group=0; SELECT * FROM performance_schema.replication_connection_status\G SELECT * FROM performance_schema.replication_group_member_stats\G SELECT * FROM performance_schema.replication_group_members; - hod04/hod06(node 2 and 3) SHOW GLOBAL VARIABLES LIKE 'group_replication%'; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery'; START GROUP_REPLICATION; SELECT * FROM performance_schema.replication_connection_status\G SELECT * FROM performance_schema.replication_group_member_stats\G SELECT * FROM performance_schema.replication_group_members; [umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod03.sock --prompt='hod03>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod03> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 263a43af-4218-11e8-83be-0010e05f3e06 | hod03 | 3333 | ONLINE | PRIMARY | 8.0.4 | | group_replication_applier | 361ee9cf-4218-11e8-bdb4-0010e0734b98 | hod06 | 3333 | ONLINE | SECONDARY | 8.0.4 | | group_replication_applier | a8be2043-4218-11e8-a3dc-0010e05f4178 | hod04 | 3333 | ONLINE | SECONDARY | 8.0.4 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 3 rows in set (0.00 sec) [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod04.sock --prompt='hod04>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 62 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod04> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 263a43af-4218-11e8-83be-0010e05f3e06 | hod03 | 3333 | ONLINE | PRIMARY | 8.0.4 | | group_replication_applier | 361ee9cf-4218-11e8-bdb4-0010e0734b98 | hod06 | 3333 | ONLINE | SECONDARY | 8.0.4 | | group_replication_applier | a8be2043-4218-11e8-a3dc-0010e05f4178 | hod04 | 3333 | ONLINE | SECONDARY | 8.0.4 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 3 rows in set (0.00 sec) hod04> [umshastr@hod06]/export/home/ushastry/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod06.sock --prompt='hod06>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod06>SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 263a43af-4218-11e8-83be-0010e05f3e06 | hod03 | 3333 | ONLINE | PRIMARY | 8.0.4 | | group_replication_applier | 361ee9cf-4218-11e8-bdb4-0010e0734b98 | hod06 | 3333 | ONLINE | SECONDARY | 8.0.4 | | group_replication_applier | a8be2043-4218-11e8-a3dc-0010e05f4178 | hod04 | 3333 | ONLINE | SECONDARY | 8.0.4 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 3 rows in set (0.00 sec) hod06> -- session 1 [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod04.sock --prompt='hod04>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod04>stop group_replication; Query OK, 0 rows affected (20.90 sec) hod04>stop group_replication; Query OK, 0 rows affected (18.81 sec) hod04> -- session 2 [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod04.sock --prompt='hod04>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod04>start group_replication; Query OK, 0 rows affected (23.13 sec) hod04>start group_replication; ^C^C -- query aborted ^C^C -- query aborted ^C^C -- query aborted ^C^C -- query aborted ERROR 2013 (HY000): Lost connection to MySQL server during query hod04>\q Bye -- session 1 [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: bin/mysql -uroot -S /tmp/mysql_hod04.sock --prompt='hod04>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. hod04>stop group_replication; Query OK, 0 rows affected (20.90 sec) hod04>stop group_replication; Query OK, 0 rows affected (18.81 sec) hod04> hod04>\q Bye [4] Segmentation fault (core dumped) bin/mysqld --defaults-file=./90457.cnf --log-error=hod04.err --core-file 2>&1 [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: [umshastr@hod04]/export/home/ushastry/mysql-8.0.4: gdb bin/mysqld data/core.32131 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-64.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: ... Reading symbols from /export/home/ushastry/mysql-8.0.4/bin/mysqld...done. [New LWP 32166] [New LWP 32378] [New LWP 32381] [New LWP 32138] [New LWP 32382] [New LWP 32139] [New LWP 32141] [New LWP 32383] [New LWP 32149] [New LWP 32146] [New LWP 32133] [New LWP 32143] [New LWP 32136] [New LWP 32134] [New LWP 32137] [New LWP 32135] [New LWP 32131] [New LWP 32157] [New LWP 32147] [New LWP 32142] [New LWP 32145] [New LWP 32151] [New LWP 32148] [New LWP 32140] [New LWP 32156] [New LWP 32158] [New LWP 32150] [New LWP 32155] [New LWP 32384] [New LWP 32160] [New LWP 32163] [New LWP 32159] [New LWP 32154] [New LWP 32144] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld --defaults-file=./90457.cnf --log-error=hod04.err --core-file'. Program terminated with signal 11, Segmentation fault. #0 0x00007f58350d9771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-78.0.1.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.3-9.el7.x86_64 libstdc++-4.8.3-9.el7.x86_64 nss-softokn-freebl-3.16.2.3-13.el7_1.x86_64 numactl-libs-2.0.9-5.el7_1.x86_64 (gdb) bt #0 0x00007f58350d9771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000001886697 in my_write_core (sig=) at ../../mysql-8.0.4-rc/mysys/stacktrace.cc:303 #2 0x0000000000e2f95d in handle_fatal_signal (sig=11) at ../../mysql-8.0.4-rc/sql/signal_handler.cc:241 #3 #4 thd_get_ha_data (thd=thd@entry=0x7f57d80131c0, hton=hton@entry=0x73a9750) at ../../mysql-8.0.4-rc/sql/sql_thd_api.cc:460 #5 0x0000000000f036d3 in kill_handlerton (thd=0x7f57d80131c0, plugin=) at ../../mysql-8.0.4-rc/sql/handler.cc:1039 #6 0x0000000000b99fc6 in plugin_foreach_with_mask (thd=thd@entry=0x7f57d80131c0, funcs=funcs@entry=0x7f5824814330, type=type@entry=1, state_mask=4294967287, state_mask@entry=8, arg=arg@entry=0x0) at ../../mysql-8.0.4-rc/sql/sql_plugin.cc:2708 #7 0x0000000000b9a15d in plugin_foreach_with_mask (thd=thd@entry=0x7f57d80131c0, func=func@entry=0xf036b0 , type=type@entry=1, state_mask=state_mask@entry=8, arg=arg@entry=0x0) at ../../mysql-8.0.4-rc/sql/sql_plugin.cc:2723 #8 0x0000000000f0975e in ha_kill_connection (thd=thd@entry=0x7f57d80131c0) at ../../mysql-8.0.4-rc/sql/handler.cc:1048 #9 0x0000000000b35738 in THD::awake (this=0x7f57d80131c0, state_to_set=state_to_set@entry=THD::KILL_CONNECTION) at ../../mysql-8.0.4-rc/sql/sql_class.cc:1268 #10 0x00007f5802850c1b in Applier_module::terminate_applier_thread (this=0x7f57d80131d0) at ../../../../mysql-8.0.4-rc/rapid/plugin/group_replication/src/applier.cc:626 #11 0x00007f5802872fac in configure_and_start_applier_module () at ../../../../mysql-8.0.4-rc/rapid/plugin/group_replication/src/plugin.cc:1384 #12 0x00007f580287a572 in initialize_plugin_and_join (sql_api_isolation=sql_api_isolation@entry=PSESSION_DEDICATED_THREAD, delayed_init_thd=delayed_init_thd@entry=0x0) at ../../../../mysql-8.0.4-rc/rapid/plugin/group_replication/src/plugin.cc:636 #13 0x00007f580287acd2 in plugin_group_replication_start () at ../../../../mysql-8.0.4-rc/rapid/plugin/group_replication/src/plugin.cc:510 #14 0x00000000010477dd in group_replication_start (error_message=error_message@entry=0x7f5824814d00) at ../../mysql-8.0.4-rc/sql/rpl_group_replication.cc:117 #15 0x0000000000b7e318 in mysql_execute_command (thd=thd@entry=0x7f57d8000ba0, first_level=first_level@entry=true) at ../../mysql-8.0.4-rc/sql/sql_parse.cc:3239 #16 0x0000000000b80f40 in mysql_parse (thd=thd@entry=0x7f57d8000ba0, parser_state=parser_state@entry=0x7f5824815600) at ../../mysql-8.0.4-rc/sql/sql_parse.cc:5440 #17 0x0000000000b82ec1 in dispatch_command (thd=thd@entry=0x7f57d8000ba0, com_data=com_data@entry=0x7f5824815d00, command=COM_QUERY) at ../../mysql-8.0.4-rc/sql/sql_parse.cc:1730 #18 0x0000000000b83990 in do_command (thd=thd@entry=0x7f57d8000ba0) at ../../mysql-8.0.4-rc/sql/sql_parse.cc:1310 #19 0x0000000000e230d8 in handle_connection (arg=arg@entry=0x75c8d90) at ../../mysql-8.0.4-rc/sql/conn_handler/connection_handler_per_thread.cc:335 #20 0x000000000198d1df in pfs_spawn_thread (arg=0x76560e0) at ../../../mysql-8.0.4-rc/storage/perfschema/pfs.cc:2994 #21 0x00007f58350d4df5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f583353d60d in clone () from /lib64/libc.so.6 (gdb) -- hod04 extract from error log 2018-04-17T09:12:21.685781Z 8 [Warning] [MY-011254] Plugin group_replication reported: 'Unblocking the group replication thread waiting for applier to start, as the start group replication was killed.' 2018-04-17T09:12:21.685796Z 8 [ERROR] [MY-011254] Plugin group_replication reported: 'Unable to initialize the Group Replication applier module.' 09:12:21 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=4 max_threads=151 thread_count=4 connection_count=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68136 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f57d8000ba0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f5824815d80 thread_stack 0x46000 /export/home/ushastry/mysql-8.0.4/bin/mysqld(my_print_stacktrace+0x2e) [0x1886f9e] /export/home/ushastry/mysql-8.0.4/bin/mysqld(handle_fatal_signal+0x4c1) [0xe2fa01] /lib64/libpthread.so.0(+0xf130) [0x7f58350dc130] /export/home/ushastry/mysql-8.0.4/bin/mysqld(thd_get_ha_data+0xa) [0xbfa61a] /export/home/ushastry/mysql-8.0.4/bin/mysqld() [0xf036d3] /export/home/ushastry/mysql-8.0.4/bin/mysqld(plugin_foreach_with_mask(THD*, bool (**)(THD*, st_plugin_int*, void*), int, unsigned int, void*)+0x176) [0xb99fc6] /export/home/ushastry/mysql-8.0.4/bin/mysqld(plugin_foreach_with_mask(THD*, bool (*)(THD*, st_plugin_int*, void*), int, unsigned int, void*)+0x1d) [0xb9a15d] /export/home/ushastry/mysql-8.0.4/bin/mysqld(THD::awake(THD::killed_state)+0x208) [0xb35738] /export/home/ushastry/mysql-8.0.4/lib/plugin/group_replication.so(Applier_module::terminate_applier_thread()+0x12b) [0x7f5802850c1b] /export/home/ushastry/mysql-8.0.4/lib/plugin/group_replication.so(configure_and_start_applier_module()+0x10c) [0x7f5802872fac] /export/home/ushastry/mysql-8.0.4/lib/plugin/group_replication.so(initialize_plugin_and_join(enum_plugin_con_isolation, Delayed_initialization_thread*)+0x4d2) [0x7f580287a572] /export/home/ushastry/mysql-8.0.4/lib/plugin/group_replication.so(plugin_group_replication_start(char**)+0x692) [0x7f580287acd2] /export/home/ushastry/mysql-8.0.4/bin/mysqld(group_replication_start(char**)+0x8d) [0x10477dd] /export/home/ushastry/mysql-8.0.4/bin/mysqld(mysql_execute_command(THD*, bool)+0x1868) [0xb7e318] /export/home/ushastry/mysql-8.0.4/bin/mysqld(mysql_parse(THD*, Parser_state*)+0x350) [0xb80f40] /export/home/ushastry/mysql-8.0.4/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1d81) [0xb82ec1] /export/home/ushastry/mysql-8.0.4/bin/mysqld(do_command(THD*)+0x180) [0xb83990] /export/home/ushastry/mysql-8.0.4/bin/mysqld() [0xe230d8] /export/home/ushastry/mysql-8.0.4/bin/mysqld() [0x198d1df] /lib64/libpthread.so.0(+0x7df5) [0x7f58350d4df5] /lib64/libc.so.6(clone+0x6d) [0x7f583353d60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f57d8009140): start group_replication Connection ID (thread ID): 8 Status: KILL_QUERY The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ## Rest two nodes were up hod03> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 263a43af-4218-11e8-83be-0010e05f3e06 | hod03 | 3333 | ONLINE | PRIMARY | 8.0.4 | | group_replication_applier | 361ee9cf-4218-11e8-bdb4-0010e0734b98 | hod06 | 3333 | ONLINE | SECONDARY | 8.0.4 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 2 rows in set (0.00 sec)