Skip to content

Instantly share code, notes, and snippets.

@zined
Created December 20, 2012 18:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zined/4347406 to your computer and use it in GitHub Desktop.
Save zined/4347406 to your computer and use it in GitHub Desktop.
percona-server-server-5.5 installation error on a fresh squeeze installation
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: To do so, start the server, then issue the following commands:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: /usr/bin/mysqladmin -u root password 'new-password'
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: /usr/bin/mysqladmin -u root -h ip-10-246-121-195 password 'new-password'
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: Alternatively you can run:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: /usr/bin/mysql_secure_installation
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: which will also give you the option of removing the test
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: databases and anonymous user created by default. This is
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: strongly recommended for production servers.
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: See the manual for more instructions.
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: Please report any problems with the /usr/bin/mysqlbug script!
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: Percona recommends that all production deployments be protected with a support
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime,
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8839]: be eligible for hot fixes, and boost your team's productivity.
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 [Note] Plugin 'FEDERATED' is disabled.
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: The InnoDB memory heap is disabled
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Compressed tables use zlib 1.2.3
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Using Linux native AIO
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Initializing buffer pool, size = 128.0M
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Completed initialization of buffer pool
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: The first specified data file ./ibdata1 did not exist:
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: a new database to be created!
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Setting file ./ibdata1 size to 10 MB
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Database physically writes the file full: wait...
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Database physically writes the file full: wait...
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:32 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Dec 20 17:59:32 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Database physically writes the file full: wait...
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Doublewrite buffer not found: creating new
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Doublewrite buffer created
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: 127 rollback segment(s) active.
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Creating foreign key constraint system tables
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: InnoDB: Foreign key constraint system tables created
Dec 20 17:59:33 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:33 InnoDB: Waiting for the background threads to start
Dec 20 17:59:34 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:34 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.2 started; log sequence number 0
Dec 20 17:59:34 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:34 InnoDB: Starting shutdown...
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8877]: 121220 17:59:38 InnoDB: Shutdown completed; log sequence number 1597945
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 [Note] Plugin 'FEDERATED' is disabled.
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: The InnoDB memory heap is disabled
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Compressed tables use zlib 1.2.3
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Using Linux native AIO
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Initializing buffer pool, size = 128.0M
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Completed initialization of buffer pool
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: highest supported file format is Barracuda.
Dec 20 17:59:38 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:38 InnoDB: Waiting for the background threads to start
Dec 20 17:59:39 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:39 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.2 started; log sequence number 1597945
Dec 20 17:59:39 ip-10-246-121-195 mysqld_safe[8903]: 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
Dec 20 17:59:39 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:39 [ERROR] Aborting
Dec 20 17:59:39 ip-10-246-121-195 mysqld_safe[8903]:
Dec 20 17:59:39 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:39 InnoDB: Starting shutdown...
Dec 20 17:59:43 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:43 InnoDB: Shutdown completed; log sequence number 1597945
Dec 20 17:59:43 ip-10-246-121-195 mysqld_safe[8903]: 121220 17:59:43 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 20 17:59:43 ip-10-246-121-195 mysqld_safe[8903]:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment