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
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
More information about the mogilefs
mailing list