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