Created
February 21, 2012 22:38
-
-
Save daharon/1879525 to your computer and use it in GitHub Desktop.
MySQL-Cluster SQL node will not come back up in upgrade from 7.1.18 to 7.2.4
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root 7735 5419 0 15:58 pts/0 00:00:00 sudo service mysql start | |
| root 7736 7735 0 15:58 pts/0 00:00:00 /bin/sh /sbin/service mysql start | |
| root 7741 7736 0 15:58 pts/0 00:00:00 /bin/sh /etc/init.d/mysql start | |
| root 7747 7741 0 15:58 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/sql2.office.sazze.com.pid | |
| mysql 8031 7747 12 15:58 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/sql2.office.sazze.com.err --pid-file=/var/lib/mysql/sql2.office.sazze.com.pid --port=3306 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2012-02-21 15:51:52 [MgmtSrvr] INFO -- Nodeid 4 allocated for API at 10.1.1.27 | |
| 2012-02-21 15:51:52 [MgmtSrvr] INFO -- Node 4: mysqld --server-id=0 | |
| 2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 2: Node 4 Connected | |
| 2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 3: Node 4 Connected | |
| 2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 2: Node 4: API mysql-5.5.19 ndb-7.2.4 | |
| 2012-02-21 15:51:53 [MgmtSrvr] INFO -- Node 3: Node 4: API mysql-5.5.19 ndb-7.2.4 | |
| 2012-02-21 15:51:54 [MgmtSrvr] ALERT -- Node 2: Node 4 Disconnected | |
| 2012-02-21 15:51:54 [MgmtSrvr] INFO -- Node 3: Communication to Node 4 closed | |
| 2012-02-21 15:51:54 [MgmtSrvr] INFO -- Node 2: Communication to Node 4 closed | |
| 2012-02-21 15:51:54 [MgmtSrvr] ALERT -- Node 3: Node 4 Disconnected | |
| 2012-02-21 15:51:57 [MgmtSrvr] INFO -- Node 3: Communication to Node 4 opened | |
| 2012-02-21 15:51:57 [MgmtSrvr] INFO -- Node 2: Communication to Node 4 opened |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Shutting down 7.1.18 | |
| # | |
| 120221 14:25:36 [Note] /usr/sbin/mysqld: Normal shutdown | |
| 120221 14:25:36 [Note] Event Scheduler: Purging the queue. 0 events | |
| 120221 14:25:36 [Note] Stopping Cluster Utility thread | |
| 120221 14:25:36 [Note] Stopping Cluster Index Stats thread | |
| 120221 14:25:36 [Note] Stopping Cluster Binlog | |
| 120221 14:25:36 [Note] Stopping Cluster Index Statistics thread | |
| 120221 14:25:37 InnoDB: Starting shutdown... | |
| 120221 14:25:38 InnoDB: Shutdown completed; log sequence number 0 44243 | |
| 120221 14:25:38 [Note] /usr/sbin/mysqld: Shutdown complete | |
| 120221 14:25:38 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended | |
| # | |
| # Starting up 7.2.4 | |
| # | |
| 120221 14:28:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql | |
| 120221 14:28:40 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. | |
| 120221 14:28:40 [Note] Plugin 'FEDERATED' is disabled. | |
| 120221 14:28:40 InnoDB: The InnoDB memory heap is disabled | |
| 120221 14:28:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 120221 14:28:40 InnoDB: Compressed tables use zlib 1.2.3 | |
| 120221 14:28:40 InnoDB: Using Linux native AIO | |
| 120221 14:28:40 InnoDB: Initializing buffer pool, size = 128.0M | |
| 120221 14:28:40 InnoDB: Completed initialization of buffer pool | |
| 120221 14:28:40 InnoDB: highest supported file format is Barracuda. | |
| InnoDB: 127 rollback segment(s) active. | |
| 120221 14:28:41 InnoDB: Waiting for the background threads to start | |
| 120221 14:28:42 InnoDB: 1.1.8 started; log sequence number 44243 | |
| 120221 14:28:42 [Note] NDB: NodeID is 4, management server '10.1.1.26:1186' | |
| 120221 14:28:43 [Note] NDB[0]: NodeID: 4, all storage nodes connected | |
| 120221 14:28:43 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds | |
| 120221 14:28:43 [Note] Starting Cluster Binlog Thread | |
| 120221 14:28:46 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended | |
| # | |
| # Startup failed. | |
| # | |
| # | |
| # Trying again. | |
| # | |
| 120221 14:30:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql | |
| 120221 14:30:54 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. | |
| 120221 14:30:54 [Note] Plugin 'FEDERATED' is disabled. | |
| 120221 14:30:54 InnoDB: The InnoDB memory heap is disabled | |
| 120221 14:30:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 120221 14:30:54 InnoDB: Compressed tables use zlib 1.2.3 | |
| 120221 14:30:54 InnoDB: Using Linux native AIO | |
| 120221 14:30:54 InnoDB: Initializing buffer pool, size = 128.0M | |
| 120221 14:30:54 InnoDB: Completed initialization of buffer pool | |
| 120221 14:30:54 InnoDB: highest supported file format is Barracuda. | |
| InnoDB: The log sequence number in ibdata files does not match | |
| InnoDB: the log sequence number in the ib_logfiles! | |
| 120221 14:30:54 InnoDB: Database was not shut down normally! | |
| InnoDB: Starting crash recovery. | |
| InnoDB: Reading tablespace information from the .ibd files... | |
| InnoDB: Restoring possible half-written data pages from the doublewrite | |
| InnoDB: buffer... | |
| 120221 14:30:55 InnoDB: Waiting for the background threads to start | |
| 120221 14:30:56 InnoDB: 1.1.8 started; log sequence number 1589349 | |
| 120221 14:30:56 [Note] NDB: NodeID is 4, management server '10.1.1.26:1186' | |
| 120221 14:30:56 [Note] NDB[0]: NodeID: 4, all storage nodes connected | |
| 120221 14:30:56 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds | |
| 120221 14:30:56 [Note] Starting Cluster Binlog Thread | |
| 120221 14:30:58 mysqld_safe mysqld from pid file /var/lib/mysql/sql2.office.example.com.pid ended |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The management and data nodes have already been successfully upgraded.
The SQL node is giving me trouble, though...