Bacula database rogue tables

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bacula database rogue tables

Kostis Fardelas
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Bacula database rogue tables

Marcin Haba
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 <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-users
Loading...