Skip to main content
edited tags
Link
jesseconnr
  • 488
  • 2
  • 12
Source Link
jesseconnr
  • 488
  • 2
  • 12

Database log_* tables are all empty in production, but not when I export the database for testing in an identical setup

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.