Always a bummer when ZCS upgrades die. Thanks for the posts. I had the same error, but also had to wipe out the old ZCS logger mysql database. I tried your fixes and got no quick results, just kept hanging. I went and looked and found my MySQL->logger.mta table was over 11 gig. No wonder I was having trouble.
NOT understanding Zimbra fully, I just figured "what the heck" and did the following:
mv /opt/zimbra/logger /opt/zimbra/logger-corrupt
rpm -e [installed zimbra logger rpm here]
killed off all zimbra stuff (after /etc/rc.d/init.d/zimbra stop)
Then restarted the install script. It FLEW through it -- apparently the portion of the install that deals with the logger is what really slows things down the most.
After nearly turning blue from holding my breath, I was relieved to see that after the install, all my accounts and email history were intact. Even better was that the admin GUI was all happy, and I don't have the error about the logger not working like I have for quite some time now.
Now....to get some sleep.
