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

Jeff Fisher guppy at techmonkeys.org
Tue Jan 16 21:25:19 UTC 2007

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
'INSERT IGNORE  INTO file_on (fid, devid) VALUES ', 'undef') called at
/usr/lib/perl5/site_perl/5.8.5/MogileFS/Store.pm line 1036
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/Worker/Delete.pm line
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/Worker/Delete.pm line
called at /usr/lib/perl5/site_perl/5.8.5/MogileFS/ProcManager.pm line
238   MogileFS::ProcManager::make_new_child('delete') called at

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.


More information about the mogilefs mailing list