SHARE
TWEET

Untitled

a guest Oct 10th, 2018 120 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Initializing database
  2.  
  3.  
  4. PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
  5. To do so, start the server, then issue the following commands:
  6.  
  7. '/usr/bin/mysqladmin' -u root password 'new-password'
  8. '/usr/bin/mysqladmin' -u root -h  password 'new-password'
  9.  
  10. Alternatively you can run:
  11. '/usr/bin/mysql_secure_installation'
  12.  
  13. which will also give you the option of removing the test
  14. databases and anonymous user created by default.  This is
  15. strongly recommended for production servers.
  16.  
  17. See the MariaDB Knowledgebase at http://mariadb.com/kb or the
  18. MySQL manual for more instructions.
  19.  
  20. Please report any problems at http://mariadb.org/jira
  21.  
  22. The latest information about MariaDB is available at http://mariadb.org/.
  23. You can find additional information about the MySQL part at:
  24. http://dev.mysql.com
  25. Consider joining MariaDB's strong and vibrant community:
  26. https://mariadb.org/get-involved/
  27.  
  28. Database initialized
  29. MySQL init process in progress...
  30. 2018-10-10 18:16:32 0 [Note] mysqld (mysqld 10.3.10-MariaDB-1:10.3.10+maria~bionic) starting as process 101 ...
  31. 2018-10-10 18:16:32 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
  32. 2018-10-10 18:16:32 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
  33. 2018-10-10 18:16:32 0 [Note] WSREP: wsrep_load(): Galera 25.3.24(r3825) by Codership Oy <info@codership.com> loaded successfully.
  34. 2018-10-10 18:16:32 0 [Note] WSREP: CRC-32C: using hardware acceleration.
  35. 2018-10-10 18:16:32 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
  36. 2018-10-10 18:16:32 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
  37. 2018-10-10 18:16:32 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.192.3; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.
  38. 2018-10-10 18:16:32 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1
  39. 2018-10-10 18:16:32 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
  40. 2018-10-10 18:16:32 0 [Note] WSREP: wsrep_sst_grab()
  41. 2018-10-10 18:16:32 0 [Note] WSREP: Start replication
  42. 2018-10-10 18:16:32 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
  43. 2018-10-10 18:16:32 0 [Note] WSREP: protonet asio version 0
  44. 2018-10-10 18:16:32 0 [Note] WSREP: Using CRC-32C for message checksums.
  45. 2018-10-10 18:16:32 0 [Note] WSREP: backend: asio
  46. 2018-10-10 18:16:32 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
  47. 2018-10-10 18:16:32 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
  48. 2018-10-10 18:16:32 0 [Note] WSREP: restore pc from disk failed
  49. 2018-10-10 18:16:32 0 [Note] WSREP: GMCast version 0
  50. 2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  51. 2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  52. 2018-10-10 18:16:32 0 [Note] WSREP: EVS version 0
  53. 2018-10-10 18:16:32 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer 'maria-0:,maria-1:'
  54. 2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection established to 9d923d46 tcp://192.168.192.3:4567
  55. 2018-10-10 18:16:32 0 [Warning] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') address 'tcp://192.168.192.3:4567' points to own listening address, blacklisting
  56. 2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection established to 7e4bd57b tcp://192.168.192.2:4567
  57. 2018-10-10 18:16:32 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
  58. 2018-10-10 18:16:32 0 [Note] WSREP: declaring 7e4bd57b at tcp://192.168.192.2:4567 stable
  59. 2018-10-10 18:16:32 0 [Note] WSREP: Node 7e4bd57b state prim
  60. 2018-10-10 18:16:32 0 [Note] WSREP: view(view_id(PRIM,7e4bd57b,2) memb {
  61.         7e4bd57b,0
  62.         9d923d46,0
  63. } joined {
  64. } left {
  65. } partitioned {
  66. })
  67. 2018-10-10 18:16:32 0 [Note] WSREP: save pc into disk
  68. MySQL init process in progress...
  69. 2018-10-10 18:16:33 0 [Note] WSREP: gcomm: connected
  70. 2018-10-10 18:16:33 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  71. 2018-10-10 18:16:33 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  72. 2018-10-10 18:16:33 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
  73. 2018-10-10 18:16:33 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
  74. 2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
  75. 2018-10-10 18:16:33 0 [Note] WSREP: Waiting for SST to complete.
  76. 2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47
  77. 2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47 from 0 (4d68cc172901)
  78. 2018-10-10 18:16:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9de40a1c-ccb8-11e8-b4b2-67e86775fd47 from 1 (eee67952e2ab)
  79. 2018-10-10 18:16:33 0 [Note] WSREP: Quorum results:
  80.         version    = 4,
  81.         component  = PRIMARY,
  82.         conf_id    = 1,
  83.         members    = 1/2 (joined/total),
  84.         act_id     = 6,
  85.         last_appl. = -1,
  86.         protocols  = 0/9/3 (gcs/repl/appl),
  87.         group UUID = 7bb894eb-ccb8-11e8-a775-ff8d1a593fee
  88. 2018-10-10 18:16:33 0 [Note] WSREP: Flow-control interval: [23, 23]
  89. 2018-10-10 18:16:33 0 [Note] WSREP: Trying to continue unpaused monitor
  90. 2018-10-10 18:16:33 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6)
  91. 2018-10-10 18:16:33 2 [Note] WSREP: State transfer required:
  92.         Group state: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
  93.         Local state: 00000000-0000-0000-0000-000000000000:-1
  94. 2018-10-10 18:16:33 2 [Note] WSREP: New cluster view: global state: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3
  95. 2018-10-10 18:16:33 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
  96. 2018-10-10 18:16:33 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.192.3' --datadir '/var/lib/mysql/'   --parent '101'  ''  '''
  97. 2018-10-10 18:16:34 2 [Note] WSREP: Prepared SST request: rsync|192.168.192.3:4444/rsync_sst
  98. 2018-10-10 18:16:34 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  99. 2018-10-10 18:16:34 2 [Note] WSREP: REPL Protocols: 9 (4, 2)
  100. 2018-10-10 18:16:34 2 [Note] WSREP: Assign initial position for certification: 6, protocol version: 4
  101. 2018-10-10 18:16:34 0 [Note] WSREP: Service thread queue flushed.
  102. 2018-10-10 18:16:34 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (7bb894eb-ccb8-11e8-a775-ff8d1a593fee): 1 (Operation not permitted)
  103.          at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
  104. 2018-10-10 18:16:34 0 [Note] WSREP: Member 1.0 (eee67952e2ab) requested state transfer from '*any*'. Selected 0.0 (4d68cc172901)(SYNCED) as donor.
  105. 2018-10-10 18:16:34 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 6)
  106. 2018-10-10 18:16:34 2 [Note] WSREP: Requesting state transfer: success, donor: 0
  107. 2018-10-10 18:16:34 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
  108. MySQL init process in progress...
  109. MySQL init process in progress...
  110. 2018-10-10 18:16:35 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') connection to peer 9d923d46 with addr tcp://192.168.192.3:4567 timed out, no messages seen in PT3S
  111. 2018-10-10 18:16:35 0 [Note] WSREP: (9d923d46, 'tcp://0.0.0.0:4567') turning message relay requesting off
  112. 2018-10-10 18:16:35 0 [Note] WSREP: 0.0 (4d68cc172901): State transfer to 1.0 (eee67952e2ab) complete.
  113. 2018-10-10 18:16:35 0 [Note] WSREP: Member 0.0 (4d68cc172901) synced with group.
  114. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 163 (20181010 18:16:36.177)
  115. MySQL init process in progress...
  116. WSREP_SST: [INFO] Joiner cleanup done. (20181010 18:16:36.702)
  117. 2018-10-10 18:16:36 0 [Note] WSREP: SST complete, seqno: 6
  118. 2018-10-10 18:16:36 0 [Note] InnoDB: Using Linux native AIO
  119. 2018-10-10 18:16:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  120. 2018-10-10 18:16:36 0 [Note] InnoDB: Uses event mutexes
  121. 2018-10-10 18:16:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  122. 2018-10-10 18:16:36 0 [Note] InnoDB: Number of pools: 1
  123. 2018-10-10 18:16:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
  124. 2018-10-10 18:16:36 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
  125. 2018-10-10 18:16:36 0 [Note] InnoDB: Completed initialization of buffer pool
  126. 2018-10-10 18:16:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  127. 2018-10-10 18:16:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1673121
  128. MySQL init process in progress...
  129. 2018-10-10 18:16:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
  130. 2018-10-10 18:16:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  131. 2018-10-10 18:16:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  132. 2018-10-10 18:16:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  133. 2018-10-10 18:16:37 0 [Note] InnoDB: Waiting for purge to start
  134. 2018-10-10 18:16:37 0 [Note] InnoDB: 10.3.10 started; log sequence number 1673130; transaction id 21
  135. 2018-10-10 18:16:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  136. 2018-10-10 18:16:37 0 [Note] Plugin 'FEEDBACK' is disabled.
  137. 2018-10-10 18:16:37 0 [Warning] 'proxies_priv' entry '@% root@4d68cc172901' ignored in --skip-name-resolve mode.
  138. 2018-10-10 18:16:37 0 [Note] WSREP: Signalling provider to continue.
  139. 2018-10-10 18:16:37 0 [Note] WSREP: SST received: 7bb894eb-ccb8-11e8-a775-ff8d1a593fee:6
  140. 2018-10-10 18:16:37 0 [Note] InnoDB: Buffer pool(s) load completed at 181010 18:16:37
  141. 2018-10-10 18:16:37 0 [Note] WSREP: 1.0 (eee67952e2ab): State transfer from 0.0 (4d68cc172901) complete.
  142. 2018-10-10 18:16:37 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 6)
  143. 2018-10-10 18:16:37 0 [Note] WSREP: Member 1.0 (eee67952e2ab) synced with group.
  144. 2018-10-10 18:16:37 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 6)
  145. 2018-10-10 18:16:37 2 [Note] WSREP: Synchronized with group, ready for connections
  146. 2018-10-10 18:16:37 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  147. 2018-10-10 18:16:37 0 [Note] Reading of all Master_info entries succeded
  148. 2018-10-10 18:16:37 0 [Note] Added new Master_info '' to hash table
  149. 2018-10-10 18:16:37 0 [Note] mysqld: ready for connections.
  150. Version: '10.3.10-MariaDB-1:10.3.10+maria~bionic'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
  151. ERROR 1396 (HY000) at line 8: Operation CREATE USER failed for 'root'@'%'
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