Page 2 of 3 | << | < | 1 | 2 | 3 | > | >> | All |
Posted By: tidus on May 6, 2014, 7:49 am | Post: 15 |
Hi,
Close MySQL Server before shutting down your machine. ----------------------- Follow AMPPS on, Twitter : https://twitter.com/AMPPS_Stack Facebook : http://www.facebook.com/softaculousampps Google+ : https://plus.google.com/+AmppsStack |
Posted By: bluesky_c3 on May 6, 2014, 7:50 am | Post: 16 |
Allright, guys! I got it!
Thanks! |
Posted By: sdowns on May 13, 2014, 12:41 pm | Post: 17 |
I'm getting the same error after upgrading to 2.4 on Mavericks 10.9.2.
2014-05-13 13:36:11 8225 [Note] Plugin 'FEDERATED' is disabled. 2014-05-13 13:36:11 8225 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-05-13 13:36:11 8225 [Note] InnoDB: The InnoDB memory heap is disabled 2014-05-13 13:36:11 8225 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-05-13 13:36:11 8225 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-05-13 13:36:11 8225 [Note] InnoDB: Not using CPU crc32 instructions 2014-05-13 13:36:11 8225 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-05-13 13:36:11 8225 [Note] InnoDB: Completed initialization of buffer pool 2014-05-13 13:36:11 8225 [Note] InnoDB: Highest supported file format is Barracuda. 2014-05-13 13:36:11 8225 [Note] InnoDB: 128 rollback segment(s) are active. 2014-05-13 13:36:11 8225 [Note] InnoDB: Waiting for purge to start 2014-05-13 13:36:11 8225 [Note] InnoDB: 5.6.17 started; log sequence number 1600627 2014-05-13 13:36:12 8225 [Note] Server hostname (bind-address): '*'; port: 3306 2014-05-13 13:36:12 8225 [Note] IPv6 is available. 2014-05-13 13:36:12 8225 [Note] - '::' resolves to '::'; 2014-05-13 13:36:12 8225 [Note] Server socket created on IP: '::'. 2014-05-13 13:36:12 8225 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2014-05-13 13:36:12 8225 [Note] Event Scheduler: Loaded 0 events 2014-05-13 13:36:12 8225 [Note] /Applications/AMPPS/mysql/bin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/Applications/AMPPS/mysql/tmp/mysql.sock' port: 3306 Source distribution I have tried the following from this post and the other post mentioned: 1. adding innodb_force_recovery = 1 to config file 2. backup and move log files and mysql-bin files from /ampss/var 3. backup and move innodb files from /ampps/var/mysql |
Posted By: tidus on May 13, 2014, 1:30 pm | Post: 18 |
Quote From : sdowns May 13, 2014, 12:41 pm I'm getting the same error after upgrading to 2.4 on Mavericks 10.9.2.
2014-05-13 13:36:11 8225 [Note] Plugin 'FEDERATED' is disabled. 2014-05-13 13:36:11 8225 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-05-13 13:36:11 8225 [Note] InnoDB: The InnoDB memory heap is disabled 2014-05-13 13:36:11 8225 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-05-13 13:36:11 8225 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-05-13 13:36:11 8225 [Note] InnoDB: Not using CPU crc32 instructions 2014-05-13 13:36:11 8225 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-05-13 13:36:11 8225 [Note] InnoDB: Completed initialization of buffer pool 2014-05-13 13:36:11 8225 [Note] InnoDB: Highest supported file format is Barracuda. 2014-05-13 13:36:11 8225 [Note] InnoDB: 128 rollback segment(s) are active. 2014-05-13 13:36:11 8225 [Note] InnoDB: Waiting for purge to start 2014-05-13 13:36:11 8225 [Note] InnoDB: 5.6.17 started; log sequence number 1600627 2014-05-13 13:36:12 8225 [Note] Server hostname (bind-address): '*'; port: 3306 2014-05-13 13:36:12 8225 [Note] IPv6 is available. 2014-05-13 13:36:12 8225 [Note] - '::' resolves to '::'; 2014-05-13 13:36:12 8225 [Note] Server socket created on IP: '::'. 2014-05-13 13:36:12 8225 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2014-05-13 13:36:12 8225 [Note] Event Scheduler: Loaded 0 events 2014-05-13 13:36:12 8225 [Note] /Applications/AMPPS/mysql/bin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/Applications/AMPPS/mysql/tmp/mysql.sock' port: 3306 Source distribution I have tried the following from this post and the other post mentioned: 1. adding innodb_force_recovery = 1 to config file 2. backup and move log files and mysql-bin files from /ampss/var 3. backup and move innodb files from /ampps/var/mysql Hi, Is you MySQL server not working ? Because I cannot find the error in the logs. Please open a ticket, we will look into it. ----------------------- Follow AMPPS on, Twitter : https://twitter.com/AMPPS_Stack Facebook : http://www.facebook.com/softaculousampps Google+ : https://plus.google.com/+AmppsStack |
Posted By: sdowns on May 14, 2014, 7:45 am | Post: 20 |
Right, I've restored my AMPPS installation back to 2.3, prior to the 2.4 upgrade. I can now run my local website again.
However when I look at the mysql error log I'm still seeing these errors. 2014-05-14 08:23:30 3098 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2014-05-14 08:23:30 3098 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2014-05-14 08:23:30 3098 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2014-05-14 08:23:30 3098 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 2014-05-14 08:23:30 3098 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. In fact these errors have been occurring since I first installed AMPPS 2.2 back in January. Checking the database named 'mysql', the following tables appear in the list of tables but if I try to view them, my SQL client (Sequel Pro) says they do not exist. innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info and slave_worker_info. How do I recreate these tables and does it matter? |
Posted By: z0quete on August 17, 2014, 2:17 pm | Post: 21 |
hi everybody!
i have the same problem, mysql doesent start. the first time i used it it worked well, but on the next day it just didnt start anymore. i've tried reinstalling it and also deleting the files in path/to/Ampps/mysql/data but none of those solutions did work. this is what the error log file sais: http://pastebin.com/pypure0G (sorry for my crappy english, it's not my first language) |
Posted By: z0quete on August 17, 2014, 5:07 pm | Post: 22 |
Quote From : z0quete August 17, 2014, 2:17 pm hi everybody!
i have the same problem, mysql doesent start. the first time i used it it worked well, but on the next day it just didnt start anymore. i've tried reinstalling it and also deleting the files in path/to/Ampps/mysql/data but none of those solutions did work. this is what the error log file sais: http://pastebin.com/pypure0G (sorry for my crappy english, it's not my first language) ok guys i found the solution to my problem. the problem was that i had also WAMP on my computer and somehow i didnt let AMPPS work properly. i never unistalled WAMP because every time i tried i got a an "error 5: acces denied" message. if someone has the se same problem, the solution that i found was deleteng WAMP from an other partion. |
Posted By: imike on August 20, 2014, 5:03 pm | Post: 23 |
Hey guys. So I had the issue of MySQL not starting up today. So I followed the instructions here and deleted the files that weren't folders from the AMPPS/var folder on OSX.
After this I started MySQL and it worked. But then I noticed that 1 of my databases tables were not there any longer. So, I just restored the deleted files immediately. Now I am back to MySQL not starting. My log shows "Innodb: Cannot open table swmandrill/participants from the internal data dictionary of InnoDB though the .frm file for the table exists." It shows this for error for every table inside that database. My logfile: http://pastebin.com/yYFCBbSM How can I get these tables back and get MySQL running. Thanks for your time. |
Posted By: imike on August 20, 2014, 8:13 pm | Post: 24 |
I should add that MySQL is now running but my tables are missing. I have the .frm and .ibd files. I have no idea what to do with them.
|