Not the answer you need?
Register and ask your own question!

Why Nodes 2 and 3 doesn't start with new version 5.5.27

aziguiazigui ContributorCurrent User Role Beginner
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

Comments

  • aziguiazigui Contributor Current User Role Beginner
    Hi everybody,

    I fix the problem by reinstalling the Percona in the second and third node.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.