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

Brad Fitzpatrick brad at danga.com
Tue Jan 16 21:28:32 UTC 2007


That was fixed this morning.... I hit it too.

The fix is in the 2.00_05 release I emailed about earlier today.

- Brad

On Tue, 16 Jan 2007, Jeff Fisher wrote:

> 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