[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Bacula-devel] MySQL table 'batch' goes missing


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

I just had a job bail out with this message:

06-Jan 13:09 server-dir JobId 84: Fatal error: sql_create.c:732
sql_create.c:732 insert INSERT INTO batch VALUES
(578407,84,'/path/','filename','P4A ORB4 IGk B h h A Byp BAA Q BHf8G2
BHQexl BHfb1A A A E','oJKoU70RjrXaw
UdZeOLFQ') failed:
Table 'bacula.batch' doesn't exist

A short investigation shows that this happens due to the MySQL
connection timing out and the table subsequently getting dropped.

My question is: Wouldn't it be better to create a permanent table and
just drop it when done? If multiple of these are needed concurrently,
they could be created with a unique name, like bacula.batch-$jobid and
then maybe add some cleanup code that purges any bacula.batch* tables
upon director startup.

This would make Bacula resilient to MySQL timeouts and avoid forcing
users to change their global MySQL config. (e.g. I don't mind granting
the Bacula user rights to create tables, I DO mind changing the MySQL
timeout for everybody.)

Greetings,
       Michel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFHgMof2Vs+MkscAyURAkgjAJ4rbVz9m4Op58rBfDO8eoY4/FSEfACgi/4l
4dOTxhZv6Wz4SD1002sejZE=
=eQDl
-----END PGP SIGNATURE-----


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.