On 04/10/2012 10:51 AM, Joe Nyland wrote:
> I'm a bit ashamed to admit I'm still battling this! I've removed
> '--delete-master-logs' from my mysqldump line, but it hasn't helped.
>
> For some reason, it seems as if the dump does not contain any mention
> of the temporary tables being created, neither do the binary logs,
> however there are statements which refer to bacula.batch, as if it
> should be there.
>
> Could it be that these statements refer to a bacula.batch table which
> was created by another thread prior to the mysql dump being created?
> ...and that's why the "CREATE TEMPORARY TABLE bacula.batch" statement
> is not in the binary logs after the full backup. Surely, if this were
> the case, the bacula.batch table sowuld be included in the dump would
> they not?
No, because a dump will not contain temporary tables. So if you restore
a dump and a set of binlogs that contain transactions referring to
temporary tables extant when you created the dump, yes, those
transactions are irretrievably orphaned.
> My fear is that because I am restoring binary logs, the binary log
> restores will be running under their own threads (after the main dump
> file had been restored) and thus will be unable to access temporary
> tables created by any other previous threads - making what I am
> trying to achieve impossible.
Ah, yes. It sounds in any case as though what you're trying to do is to
be able to restore a dump with a state corresponding to an interrupted
Bacula job and then complete the job, and that's simply not possible.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
