Sometimes there can be so many frozen mails in the Exim mail queue. To know the number of frozen mails in the mail queue, you can use the following command exim -bpr | grep frozen | wc -l In order to remove all frozen mails from the Exim mail queue, use the following command exim -bpr | grep frozen | awk {‘print $3’} | xargs exim -Mrm You can also use the command given below to delete all frozen mails exiqgrep -z -i | xargs exim -Mrm If you want to only delete frozen messages older than a day, you can try the following exiqgrepRead More →

If you run a replicated MySQL setup and have a master failure, you may see the following error in your error log. [ERROR] Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236) At this point your slave will not be replicating and you will need to recover from the situation. But why did it occur in the first place and what does it mean to your data integrity? Why it occurs This error will occur if the master stops unexpectedly. This could be as a result of a hardware failure (like a disk error) or a power loss.Read More →

How to fix MySql Replication Error 1236 We have some websites that use two database servers in master-master replication. Recently one of the servers died and had to be resurrected. (They are cloud based and SoftLayer doesn’t seem to have their cloud-based offering thing nailed down, yet. Every week one of them will go down and be unresponsive until tech support does some magic.) After one of the servers was brought back up the other server would not connect. It “Slave_IO_Running: No” and “Seconds_Behind_Master: null” which means it was not playing nicely. First, I went to the MySql log files, which for this server isRead More →

When you connect your IPAD/IPHONE to the computer, you used to be able to see photos under DCIM folder , now it’s blank. It’s because your iphone is locked , this is to prevent someone copying your data when they don’t know your ipad/iphone password. How to fix? – If your ipad/iphone is connected to the PC already , disconnect it. – Unlock the phone – connect to the PC again – make sure that your iphone/ipad is in unlock status.Read More →