E-mail storage and one small issue with my setup.

[Jeff Fisher]

Is anyone currently (or has thought of) using MogileFS for e-mail storage?

I setup a MogileFS test installation last night to get a real feel of it
after lurking on this list for awhile and watching it get developed.
There's one problem that is happening but it doesn't seem to actually be
stopping me from using it:

Jan 16 15:18:51 mogilefs mogilefsd[12833]: crash log: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '' at line 1 at
/usr/lib/perl5/site_perl/5.8.5/MogileFS/Store.pm line 184
MogileFS::Store::dowell('MogileFS::Store::MySQL=HASH(0x88bc5a0)',
'INSERT IGNORE  INTO file_on (fid, devid) VALUES ', 'undef') called at
/usr/lib/perl5/site_perl/5.8.5/MogileFS/Store.pm line 1036
MogileFS::Store::mass_insert_file_on('MogileFS::Store::MySQL=HASH(0x88bc5a0)')
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/Worker/Delete.pm line
107
MogileFS::Worker::Delete::process_tempfiles('MogileFS::Worker::Delete=ARRAY(0x88bc324)')
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/Worker/Delete.pm line
50
MogileFS::Worker::Delete::work('MogileFS::Worker::Delete=ARRAY(0x88bc324)')
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/ProcManager.pm line
238   MogileFS::ProcManager::make_new_child('delete') called at
/usr/lib/perl5/site_perl/5.8.5/MogileFS/ProcManager.p

It looks like it is running this:

070116 15:19:34    6163 Connect     mogile at localhost on mogilefs
                   6163 Query       set autocommit=1
                   6163 Query       SELECT fid, devids FROM tempfile
WHERE createtime < UNIX_TIMESTAMP() - 3600 LIMIT 50
                   6163 Query       INSERT IGNORE  INTO file_on (fid,
devid) VALUES
                   6163 Quit


Any ideas?

Maybe there needs to be a wiki page of all the crazy things people are
using MogileFS for.

Jeff