--- In firebird-support@yahoogroups.com, "Leyne, Sean" <sleyne@a...>
wrote:

> Scott,
>
> > > Looks like you are short of some resources.
> >
> > Ivan,
> >
> > I think you are right. It appears the Firebird installation does not
> > include /opt/interbase/tmp
> >
> > What I gather from this line:
> > #TMP_DIRECTORY 20000 "/opt/interbase/tmp"
> > in the isc_config file, the directory is needed.
>
> Actually, since the line starts with '#', this means that the line is
> commented out -- so it has no effect.

If this was a bash script I would agree with you, but since it is
isc_config file someone once mentioned it means the default settings.
However, this conflicts with the not so clear, incomplete, OpGuide.

I don't know who or what to believe as nobody seems to be able to come
up with anything, clearly, documented on this stuff.

>
> > > Anyway, I created the tmp directory and sweep runs fine now.

(in case anyone else runs into this problem)

>
> To be honest, I find it very difficult to beleive that this solved

the problem,

Me too, but it's working now. Any other theories?

> the sweep and the temporary/sorting directory have nothing to
> do with each other

What would make you think that? It's the only thing I changed before
the sweep started working. Why wouldn't sweep want to use temp space?

> -- there *has* to be another explanation.

I think so too. Care to make a guess?