If you encounter Slave_IO_Running: No but Slave_SQL_Running: Yes in MySQL replication setup, here may have something that can help.
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
1 row in set (0.00 sec)
This basically means that the slave server is working, but for some reason the master does not send anything to the slave. To troubleshoot this problem, go to the master server instead and check the error log. In my case, this is what I found.
[root@master mysql]# tail master.err
120220 10:11:45 Failed to open log (file './master-bin.000050', errno 13)
In my case, the file master-bin.000050 is actually there, but the owner is root which therefore cannot be opened by the account mysql. Most likely it is because someone started MySQL using the root account after a server down and later on someone restarted the MySQL again under the mysql account. Anyway changed the owner of the file and problem fixed.
First of all, this is the case I encountered and may not be useful on your case.
To reset the data in MySQL database, for the sake of fixing out-sync database replication.
- Stopped MySQL service
- Renamed the original data folder for backup purpose
- Create a new data folder with the same original name
- Execute database installation mysql_install_db
- Import the dumped data
- Set up replication
When executing database installation, the error message below appeared.
Installation of system tables failed!
The following command print nothing to the console.
After checking the log at /var/log/message, it is found that the SELinux prevented the installation.
Fix the security context issue used by SELinux
Sorry I am not going to provide the way here because I having really tried that myself.
Permanent set SELinux to Permissive or Disable (Security Risk)
Obviously this is not a good way to fix the problem but if you still want to do that, here is the way.
Edit the file:
Set to permissive
This is what you can see:
[root@my-server ~]# mysqld -V
mysqld Ver 4.1.22-standard-log for pc-linux-gnu on i686 (MySQL Community Edition - Standard (GPL))
Extra: Temperately disable SELinux
Here is the way:
echo 0 > /selinux/enforce
HOWTO: Turning off or disabling SELinux
Well my friend installed the app and I found that it is not working as expected because he is using a Samsung Android phone with different built-in alarm clock. Because there is no standard API for calling the alarm (not until API 9 seems) and therefore the app need to relies on the package name and class name for calling the alarm. Anyway here fixed the Samsung and probably Sony phone.
Below is a change log in version 1.2:
! Fixed not able to launch alarm setting page on some Samsung, Sony Android phones
! Fixed possible crash when the alarm setting page is not found
! Fixed a bug in displaying incorrect 12/24 hour format when changing system language