Welcome to 96MB, please Login or Create an account to get full access to the forums.
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Percona MySQL won't start

Offline zhuanyi Posted 10-01-2013, 11:05 PM -
Post: #1
Senior Member
357 Posts
Reputation: 5
I have installed a fresh copy of Percona MySQL 5.5 and for some reason it won't start, here is the verbose output:

Code:
mysqld --verbose                    131001 20:59:32 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
131001 20:59:32 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
mysqld: Table 'mysql.plugin' doesn't exist
131001 20:59:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
131001 20:59:32 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
131001 20:59:32 InnoDB: The InnoDB memory heap is disabled
131001 20:59:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131001 20:59:32 InnoDB: Compressed tables use zlib 1.2.3
131001 20:59:32 InnoDB: Using Linux native AIO
131001 20:59:32 InnoDB: Initializing buffer pool, size = 128.0M
131001 20:59:32 InnoDB: Completed initialization of buffer pool
131001 20:59:32 InnoDB: highest supported file format is Barracuda.
131001 20:59:32  InnoDB: Waiting for the background threads to start
131001 20:59:33 Percona XtraDB (http://www.percona.com) 5.5.33-29.3 started; log sequence number 1597945
131001 20:59:33 [Note] Recovering after a crash using mysql-bin
131001 20:59:33 [Note] Starting crash recovery...
131001 20:59:33 [Note] Crash recovery finished.
131001 20:59:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

However I have installed various DB tables using the install_table script:
Code:
Installing MySQL system tables...
131001 21:00:07 [Warning] Using unique option prefix key_buffer instead of key_b                                                                             uffer_size is deprecated and will be removed in a future release. Please use the                                                                              full name instead.
131001 21:00:07 [Note] WSREP: Read nil XID from storage engines, skipping positi                                                                             on init
131001 21:00:07 [Note] WSREP: wsrep_load(): loading provider library 'none'
131001 21:00:07 [Note] WSREP: Service disconnected.
131001 21:00:08 [Note] WSREP: Some threads may fail to exit.
OK
Filling help tables...
131001 21:00:08 [Warning] Using unique option prefix key_buffer instead of key_b                                                                             uffer_size is deprecated and will be removed in a future release. Please use the                                                                              full name instead.
131001 21:00:08 [Note] WSREP: Read nil XID from storage engines, skipping positi                                                                             on init
131001 21:00:08 [Note] WSREP: wsrep_load(): loading provider library 'none'
131001 21:00:08 [Note] WSREP: Service disconnected.
131001 21:00:09 [Note] WSREP: Some threads may fail to exit.
OK

Help please?[/code]
Back to top Find Quote


Forum Jump:

User(s) browsing this thread
1 Guest(s)

© 2012 96MB

Community software by MyBB

Premium Theme by ThemeFreak