Hello Kostis,
These additional tables were created during restore with using Bvfs.
They could be done by older Baculum version (>7.4). From version 7.4.0
Baculum removes current table when restore starts.
If these tables come from Baculum, you can remove them, of course.
Best regards.
Marcin Haba (gani)
On 16 January 2017 at 11:32, Kostis Fardelas wrote:
> Hi,
> I noticed today on a bacula installation (Debian Jessie,
> 5.2.6+dfsg-9.3) the following rogue tables (bXXX):
>
> mysql> show tables;
> +--+
> | Tables_in_bacula |
> +--+
> | BaseFiles|
> | CDImages |
> | Client |
> | Counters |
> | Device |
> | File |
> | FileSet |
> | Filename |
> | Job |
> | JobHisto |
> | JobMedia |
> | Location |
> | LocationLog |
> | Log |
> | Media|
> | MediaType|
> | Path |
> | PathHierarchy|
> | PathVisibility |
> | Pool |
> | RestoreObject|
> | Status |
> | Storage |
> | UnsavedFiles |
> | Version |
> | b211148170289098 |
> | b211148170561795 |
> | b211148170579554 |
> | b211148171743133 |
> | b212148164496524 |
> | b215148166176658 |
> | b215148170072262 |
> | b215148174912048 |
> | b215148174978191 |
> | b220148242047281 |
> | b221148301532508 |
> | b221148301557708 |
> | b22148171559521 |
> | b22148171562093 |
> | b22148171619489 |
> | b22148171624714 |
> | b22148171631582 |
> | b22148171677827 |
> | b22148171679880 |
> | b22148171745054 |
> | b22148171826728 |
> +--+
> 46 rows in set (0.00 sec)
>
> For one of them:
> mysql> select * from b22148171826728;
> +---+---+++
> | JobId | FileIndex | FileId | JobTDate |
> +---+---+++
> | 1032 | 3 | 358730 | 1481708096 |
> +---+---+++
>
> The job was successful:
> mysql> select * from Job where Job.JobId = 1032;
> +---++-+--+---+--+---+-+-+-+-++--++--+--+---+---+-++---++-+-+--+--+-+
> | JobId | Job|
> Name| Type | Level | ClientId | JobStatus
> | SchedTime | StartTime | EndTime |
> RealEndTime | JobTDate | VolSessionId | VolSessionTime |
> JobFiles | JobBytes | ReadBytes | JobErrors | JobMissingFiles | PoolId
> | FileSetId | PriorJobId | PurgedFiles | HasBase | HasCache | Reviewed
> | Comment |
> +---++-+--+---+--+---+-+-+-+-++--++--+--+---+---+-++---++-+-+--+--+-+
> | 1032 | centos7.fardelas.test_varlogjob.2016-12-14_11.32.02_50 |
> centos7.fardelas.test varlogjob | B| F |2 | T
> | 2016-12-14 11:32:02 | 2016-12-14 11:34:12 | 2016-12-14 11:34:56 |
> 2016-12-14 11:34:56 | 1481708096 | 145 | 1478892522 |
> 48 | 3053906 | 126864722 | 0 | 0 | 6 |
> 2 | 0 | 0 | 0 |0 |0 |
> |
> +---++-+--+---+--+---+-+-+-+-++--++--+--+---+---+-++---++-+-+--+--+-+
> 1 row in set (0.00 sec)
>
>
> Any idea what are these tables and if I can remove them safely?
>
>
> Kind regards,
> Kostis
>
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
"Greater love hath no man than this, that a man lay down his life for
his friends." Jesus Christ
"Większej miłości nikt nie ma nad tę, jak gdy k
