Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    Hi everybody,

    I fix the problem by reinstalling the Percona in the second and third node.

    Comment

    Working...
    X