Re: [Bacula-users] Bacula database rogue tables

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 <dante1234 AT gmail DOT com> wrote:
> Hi,
> I noticed today on a bacula installation (Debian Jessie,
> 5.2.6+dfsg-9.3) the following rogue tables (bXXXXXXXXXXX):
>
> 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 AT lists.sourceforge DOT 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 kto życie swoje kładzie
za przyjaciół swoich." Jezus Chrystus

------------------------------------------------------------------------------
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users