Urchin: Unable to open database for writing since it has been archived

Urchin sometimes takes it upon itself to do some weird things, and this is one of those times. If Urchin has archived a month of data, and then you ask Urchin to parse a log that contains accesses from that archived month, you'll receive this ugly error:

Unable to open database for writing since it has been archived

To fix it, cd into /usr/local/urchin/data/reports/[profile name]/ and unzip the YYYYMM-archive.zip files, then move the zip files out of the way. Make sure that the unzipped files are owned by the Urchin user and group. You should then be able to re-run your stats without a problem.

Credit for this fix goes to Google

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Printed from: http://rackerhacker.com/2007/08/09/urchin-unable-to-open-database-for-writing-since-it-has-been-archived/ .
© Major Hayden 2010.

3 Comments   »

RSS feed for comments on this post , TrackBack URI

Leave a Reply