second cluster node does not start

Bug #1069801 reported by Mahesh
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
New
Undecided
Unassigned

Bug Description

I have first cluster running on ip 192.168.1.14 hence given command to connect a mysql cluster node from 192.168.1.92 to 192.168.1.14 (first node) as:

 ./mysql-galera -g gcomm://192.168.1.14 start

Starting mysqld instance with data dir /home/workplace/mysql-5.5.23-galera-23.2.1-x86_64/mysql/var and listening at port 3306 and socket /home/Ashwin/workplace/mysql-5.5.23-galera-23.2.1-x86_64/mysql/var/mysqld.sock..... Done (PID:21430)
Waiting for wsrep_ready.ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104
 Done

getting an error for wsrep_ready.

Here is error log entry which can be helpful:

121022 18:38:28 [Warning] Changed limits: max_open_files: 1024 max_connections: 214 table_cache: 400
121022 18:38:28 InnoDB: The InnoDB memory heap is disabled
121022 18:38:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121022 18:38:28 InnoDB: Compressed tables use zlib 1.2.3
121022 18:38:28 InnoDB: Using Linux native AIO
121022 18:38:28 InnoDB: Initializing buffer pool, size = 420.0M
121022 18:38:28 InnoDB: Completed initialization of buffer pool
121022 18:38:28 InnoDB: highest supported file format is Barracuda.
121022 18:38:28 InnoDB: Waiting for the background threads to start
121022 18:38:29 InnoDB: 1.1.8 started; log sequence number 1595843
121022 18:38:29 [Note] Event Scheduler: Loaded 0 events
121022 18:38:29 [Note] WSREP: Read nil XID from storage engines, skipping position init
121022 18:38:29 [Note] WSREP: wsrep_load(): loading provider library '/home/Ashwin/mysql-5.5.23-galera-23.2.1-x86_64/galera/lib/libgalera_smm.so'
121022 18:38:29 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.6: cannot open shared object file: No such file or directory
121022 18:38:29 [ERROR] WSREP: wsrep_load(/home/Ashwin/workplace/mysql-5.5.23-galera-23.2.1-x86_64/galera/lib/libgalera_smm.so) failed: Invalid argument (22). Reverting to no provider.
121022 18:38:29 [Note] WSREP: Read nil XID from storage engines, skipping position init
121022 18:38:29 [Note] WSREP: wsrep_load(): loading provider library 'none'
121022 18:38:29 [ERROR] Aborting

121022 18:38:29 [Note] WSREP: Service disconnected.
121022 18:38:30 [Note] WSREP: Some threads may fail to exit.
121022 18:38:30 InnoDB: Starting shutdown...
121022 18:38:31 InnoDB: Shutdown completed; log sequence number 1595843
121022 18:38:31 [Note] /home/Ashwin/workplace/mysql-5.5.23-galera-23.2.1-x86_64/mysql/sbin/mysqld: Shutdown complete

Please help ASAP.

Revision history for this message
Mahesh (mahesh-patil) wrote :

Related to Galera Cluster

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.