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
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users