Magento Version: EE 1.12.02
I'm having an issue with all of my log_* tables being empty on my production site. Mage_Log is turned on, there are no errors in any of the Magento logs or system logs that would point to anything being wrong.
However the really odd part is when I follow these steps for bringing up my test environment so that I can troubleshoot the issue, the problem disappears. I'll list the instructions in case there's anything anyone can gleam from them.
1) I export my production database so that I can import it into development for troubleshooting.
mysqldump --add-drop-database -u prod -p prod_db > prod_db.sql
2) I sed the database with my development URL and turn off https.
sed s^prod.url^dev.url^g < prod_db.sql > dev_db_1.sql
sed s^https://dev.url^http://dev.url < dev_db.sql > dev_db_final.sql
3) I import this database over my development database for testing.
mysql -u dev -p dev_db < dev_db_final.sql
4) I log into my development setup, flush the cache, re-index and browse the site and all of my log_* tables start working.
There are no other changes during that process. The server is the same, the permissions are the exact same, the code is the exact same code as production.
dev_db
— which means if you've ever loaded up that database with log entries they'll stick around.DROP TABLE IF EXISTS
for each table? So I imagine that can't be the issue. EDIT: Just realised they're using --add-drop-database.