Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Jean-François L. <ler...@gm...>]

Hi Uwe,
Thanks for the answer.
I've found it in the meantime: my vserver was defined with a 16 Mb /tmp
directory. Increasing it to 100 made the job.
Anyway, I'll keep your advice about tcp_keepalive ready if it happens again.

Cheers.
Jean-François

2012/6/14 Uwe Schuerkamp <uwe...@ni...>

> On Wed, Jun 13, 2012 at 10:37:45PM +0200, Jean-François Leroux wrote:
> >
> > wait_timeout=691200
> > interactive_timeout=691200
> >
> > To my.cnf.
> >
> > I also added HearbeatInterval = 1 min
> >
> > to bacula-sd.conf and bacula-fd.conf (on the vserver that had problems).
> >
> > But still no go. Backup runs for about 15 minutes and then hangs with
> this
> > error.
>
> Hi,
>
> does the backup *always* crash after 15 minutes? What's the value of
> tcp_keepalive_timeout on the systems involved?
>
> I'm asking because recently we had a weird effect where a backup of a
> windows client would start off just fine, but simply die after the
> amount of seconds for tcp_keepalive_time + 2 secs or so.
>
> Any firewalls involved in the communication among the vservers?
>
> Can you ssh into the other servers from the director without the idle
> ssh sessions timing out on you?
>
> All the best, Uwe
>