daily pastebin goal
68%
SHARE
TWEET

Untitled

a guest Jan 24th, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL | JS > dba.createCluster('mycluster')
  2.  
  3. A new InnoDB cluster will be created on instance 'root@server1:3306'.
  4.  
  5. Validating instance at server1:3306...
  6.  
  7. This instance reports its own address as server1
  8.  
  9. Instance configuration is suitable.
  10. Creating InnoDB cluster 'mycluster' on 'root@server1:3306'...
  11.  
  12. Dba.createCluster: ERROR: Error starting cluster: 'server1:3306'
  13. Query failed. MySQL Error (3092): ClassicSession.query: The server is not
  14. configured properly to be an active member of the group.
  15. Please see more details on error log..
  16. Query: START group_replication: MySQL Error (3092): ClassicSession.query:
  17. The server is not configured properly to be an active member of the group.
  18. Please see more details on error log. (RuntimeError)
  19.    
  20. [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
  21. [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
  22. [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the whitelist. It is mandatory that it is added.'
  23. [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
  24. [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Unable to announce tcp port 33061. Port already in use?'
  25. [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error joining the group while waiting for the network layer to become ready.'
  26. [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
  27. [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
  28. [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
  29.    
  30. # netstat -ltupn
  31. Active Internet connections (only servers)
  32. Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
  33. tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      612/systemd-resolve
  34. tcp        0      0 0.0.0.0:22007           0.0.0.0:*               LISTEN      816/sshd            
  35. tcp        0      0 10.131.16.221:33060     0.0.0.0:*               LISTEN      870/mysqld          
  36. tcp        0      0 10.131.16.221:33062     0.0.0.0:*               LISTEN      870/mysqld          
  37. tcp        0      0 10.131.16.221:3306      0.0.0.0:*               LISTEN      870/mysqld          
  38. udp        0      0 127.0.0.53:53           0.0.0.0:*                           612/systemd-resolve
  39.    
  40. [mysqld]
  41. pid-file        = /var/run/mysqld/mysqld.pid
  42. socket          = /var/run/mysqld/mysqld.sock
  43. datadir         = /var/lib/mysql
  44. log-error       = /var/log/mysql/error.log
  45.  
  46. admin-address = server1
  47. bind-address = server1
  48. mysqlx_bind_address = server1
  49. session_track_gtids = OWN_GTID
  50. log_timestamps = SYSTEM
  51. default-authentication-plugin = mysql_native_password
  52.    
  53. MySQL | SQL > show variables like '%replication%'
  54.  
  55. +-----------------------------------------------------+--------------------------------------+
  56. | Variable_name                                       | Value                                |
  57. +-----------------------------------------------------+--------------------------------------+
  58. | group_replication_allow_local_lower_version_join    | OFF                                  |
  59. | group_replication_auto_increment_increment          | 7                                    |
  60. | group_replication_bootstrap_group                   | ON                                   |
  61. | group_replication_communication_debug_options       | GCS_DEBUG_NONE                       |
  62. | group_replication_components_stop_timeout           | 31536000                             |
  63. | group_replication_compression_threshold             | 1000000                              |
  64. | group_replication_consistency                       | EVENTUAL                             |
  65. | group_replication_enforce_update_everywhere_checks  | OFF                                  |
  66. | group_replication_exit_state_action                 | READ_ONLY                            |
  67. | group_replication_flow_control_applier_threshold    | 25000                                |
  68. | group_replication_flow_control_certifier_threshold  | 25000                                |
  69. | group_replication_flow_control_hold_percent         | 10                                   |
  70. | group_replication_flow_control_max_quota            | 0                                    |
  71. | group_replication_flow_control_member_quota_percent | 0                                    |
  72. | group_replication_flow_control_min_quota            | 0                                    |
  73. | group_replication_flow_control_min_recovery_quota   | 0                                    |
  74. | group_replication_flow_control_mode                 | QUOTA                                |
  75. | group_replication_flow_control_period               | 1                                    |
  76. | group_replication_flow_control_release_percent      | 50                                   |
  77. | group_replication_force_members                     |                                      |
  78. | group_replication_group_name                        | de380568-1fc9-11e9-9a08-cad7c4f1e463 |
  79. | group_replication_group_seeds                       |                                      |
  80. | group_replication_gtid_assignment_block_size        | 1000000                              |
  81. | group_replication_ip_whitelist                      | AUTOMATIC                            |
  82. | group_replication_local_address                     | server1:33061                      |
  83. | group_replication_member_expel_timeout              | 0                                    |
  84. | group_replication_member_weight                     | 50                                   |
  85. | group_replication_poll_spin_loops                   | 0                                    |
  86. | group_replication_recovery_complete_at              | TRANSACTIONS_APPLIED                 |
  87. | group_replication_recovery_get_public_key           | OFF                                  |
  88. | group_replication_recovery_public_key_path          |                                      |
  89. | group_replication_recovery_reconnect_interval       | 60                                   |
  90. | group_replication_recovery_retry_count              | 10                                   |
  91. | group_replication_recovery_ssl_ca                   |                                      |
  92. | group_replication_recovery_ssl_capath               |                                      |
  93. | group_replication_recovery_ssl_cert                 |                                      |
  94. | group_replication_recovery_ssl_cipher               |                                      |
  95. | group_replication_recovery_ssl_crl                  |                                      |
  96. | group_replication_recovery_ssl_crlpath              |                                      |
  97. | group_replication_recovery_ssl_key                  |                                      |
  98. | group_replication_recovery_ssl_verify_server_cert   | OFF                                  |
  99. | group_replication_recovery_use_ssl                  | ON                                   |
  100. | group_replication_single_primary_mode               | ON                                   |
  101. | group_replication_ssl_mode                          | REQUIRED                             |
  102. | group_replication_start_on_boot                     | ON                                   |
  103. | group_replication_transaction_size_limit            | 150000000                            |
  104. | group_replication_unreachable_majority_timeout      | 0                                    |
  105. | innodb_replication_delay                            | 0                                    |
  106. +-----------------------------------------------------+--------------------------------------+
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top