Hi,
I have a bib problem since I update my Percona 5.5.24 to 5.5.27:
Error message in second and third node node is :
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: error processing percona-xtradb-cluster-server-5.5 (–configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
Errors were encountered while processing:
percona-xtradb-cluster-server-5.5
E: Sub-process /usr/bin/dpkg returned an error code (1)
the error log in mysql :
120911 13:57:14 [ERROR] WSREP: gcs/src/gcs_backend.c:gcs_backend_init():87: Invalid backend URI: 0
120911 13:57:14 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():202: Failed to initialize backend using ‘0’: -22 (Invalid argument)
120911 13:57:14 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1290: Failed to open channel ‘my_wsrep_cluster’ at ‘0’: -22 (Invalid argument)
120911 13:57:14 [ERROR] WSREP: gcs connect failed: Invalid argument
120911 13:57:14 [ERROR] WSREP: wsrep::connect() failed: 6
120911 13:57:14 [ERROR] Aborting
And syslog :
Sep 11 13:56:44 t2-mysql02 mysqld_safe[10491]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum(‘N’,‘Y’) CHARACTER SET utf8 NOT ’ at line 1
Sep 11 13:56:44 t2-mysql02 mysqld_safe[10491]: 120911 13:56:44 [ERROR] Aborting
Sep 11 13:56:44 t2-mysql02 mysqld_safe[10491]:
Sep 11 13:56:44 t2-mysql02 mysqld_safe[10491]: 120911 13:56:44 [Note] WSREP: Service disconnected.
Sep 11 13:56:45 t2-mysql02 mysqld_safe[10491]: 120911 13:56:45 [Note] WSREP: Some threads may fail to exit.
Sep 11 13:56:45 t2-mysql02 mysqld_safe[10491]: 120911 13:56:45 InnoDB: Starting shutdown…
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10491]: 120911 13:56:48 InnoDB: Shutdown completed; log sequence number 2549519372
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10491]: 120911 13:56:48 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10491]:
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Warning] option ‘wsrep_max_ws_rows’: unsigned value 67108864 adjusted to 1048576
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Note] Flashcache bypass: disabled
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Note] Flashcache setup error is : ioctl failed
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]:
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Note] WSREP: Read nil XID from storage engines, skipping position init
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Note] WSREP: wsrep_load(): loading provider library ‘none’
Sep 11 13:56:48 t2-mysql02 kernel: [11361.879267] mysqld: sending ioctl 4004fecd to a partition!
Sep 11 13:56:48 t2-mysql02 kernel: [11361.879272] mysqld: sending ioctl 4004fecd to a partition!
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 [Note] Plugin ‘FEDERATED’ is disabled.
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: The InnoDB memory heap is disabled
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: Compressed tables use zlib 1.2.3
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: Using Linux native AIO
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: Initializing buffer pool, size = 1.0G
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: Completed initialization of buffer pool
Sep 11 13:56:48 t2-mysql02 mysqld_safe[10544]: 120911 13:56:48 InnoDB: highest supported file format is Barracuda.
Sep 11 13:56:53 t2-mysql02 mysqld_safe[10544]: 120911 13:56:53 InnoDB: Waiting for the background threads to start
Sep 11 13:56:54 t2-mysql02 mysqld_safe[10544]: 120911 13:56:54 Percona XtraDB (http://www.percona.com) 1.1.8-rel28.1 started; log sequence number 2549519372
Sep 11 13:56:54 t2-mysql02 mysqld_safe[10544]: 120911 13:56:54 [Note] WSREP: Service disconnected.
Sep 11 13:56:55 t2-mysql02 mysqld_safe[10544]: 120911 13:56:55 [Note] WSREP: Some threads may fail to exit.
Sep 11 13:56:55 t2-mysql02 mysqld_safe[10544]: 120911 13:56:55 InnoDB: Starting shutdown…
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10544]: 120911 13:56:58 InnoDB: Shutdown completed; log sequence number 2549519372
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Warning] option ‘wsrep_max_ws_rows’: unsigned value 67108864 adjusted to 1048576
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Note] Flashcache bypass: disabled
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Note] Flashcache setup error is : ioctl failed
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]:
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Note] WSREP: Read nil XID from storage engines, skipping position init
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Note] WSREP: wsrep_load(): loading provider library ‘none’
Sep 11 13:56:58 t2-mysql02 kernel: [11371.684835] mysqld: sending ioctl 4004fecd to a partition!
Sep 11 13:56:58 t2-mysql02 kernel: [11371.684839] mysqld: sending ioctl 4004fecd to a partition!
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 [Note] Plugin ‘FEDERATED’ is disabled.
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: The InnoDB memory heap is disabled
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: Compressed tables use zlib 1.2.3
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: Using Linux native AIO
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: Initializing buffer pool, size = 1.0G
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: Completed initialization of buffer pool
Sep 11 13:56:58 t2-mysql02 mysqld_safe[10597]: 120911 13:56:58 InnoDB: highest supported file format is Barracuda.
Sep 11 13:57:02 t2-mysql02 mysqld_safe[10597]: 120911 13:57:02 InnoDB: Waiting for the background threads to start
Sep 11 13:57:03 t2-mysql02 mysqld_safe[10597]: 120911 13:57:03 Percona XtraDB (http://www.percona.com) 1.1.8-rel28.1 started; log sequence number 2549519372
Sep 11 13:57:03 t2-mysql02 mysqld_safe[10597]: ERROR: 1050 Table ‘plugin’ already exists
Sep 11 13:57:03 t2-mysql02 mysqld_safe[10597]: 120911 13:57:03 [ERROR] Aborting
Sep 11 13:57:03 t2-mysql02 mysqld_safe[10597]:
Sep 11 13:57:03 t2-mysql02 mysqld_safe[10597]: 120911 13:57:03 [Note] WSREP: Service disconnected.
Sep 11 13:57:04 t2-mysql02 mysqld_safe[10597]: 120911 13:57:04 [Note] WSREP: Some threads may fail to exit.
Sep 11 13:57:04 t2-mysql02 mysqld_safe[10597]: 120911 13:57:04 InnoDB: Starting shutdown…
Sep 11 13:57:07 t2-mysql02 mysqld_safe[10597]: 120911 13:57:07 InnoDB: Shutdown completed; log sequence number 2549519372
Sep 11 13:57:07 t2-mysql02 mysqld_safe[10597]: 120911 13:57:07 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 11 14:14:37 t2-mysql02 /etc/init.d/mysql[3676]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
Sep 11 14:14:37 t2-mysql02 /etc/init.d/mysql[3676]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Sep 11 14:14:37 t2-mysql02 /etc/init.d/mysql[3676]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Sep 11 14:14:37 t2-mysql02 /etc/init.d/mysql[3676]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
Thx for your help