Apparently I've messed up my catalog. It began when I ran the system
disk (with the database on it) out of disk, big time. Rats.
Symptoms:
Jobs fail like this:
17-Jul 00:43 packrat-dir: Start Backup JobId 7780,
Job=nymph.2007-07-16_23.05.26
17-Jul 00:43 nymph-fd: DIR and FD clocks differ by -2 seconds, FD
automatically adjusting.
17-Jul 00:43 packrat-sd: Recycled volume "nymph-diff-0002" on device
"nymph-filedev" (/bacula/nymph), all previous data lost.
17-Jul 00:43 packrat-dir: Volume used once. Marking Volume "nymph-diff-0002"
as Used.
17-Jul 00:43 packrat-dir: nymph.2007-07-16_23.05.26 Fatal error:
sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM Filename WHERE
Name='printers.conf' failed:
Can't open file: 'Filename.MYI' (errno: 145)
17-Jul 00:43 packrat-dir: nymph.2007-07-16_23.05.26 Fatal error:
sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) VALUES
('printers.conf') failed:
Can't open file: 'Filename.MYI' (errno: 145)
.
.
.
There's more but it all includes the Filename.MYI bit.
Also, I can list jobs but not files:
*list jobid=7666
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
| JobId | Name | StartTime | Type | Level | JobFiles |
JobBytes | JobStatus |
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
| 7,666 | nymph | 2007-07-12 01:07:30 | B | D | 27 |
1,133,312 | T |
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
*list files jobid=7666
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
| JobId | Name | StartTime | Type | Level | JobFiles |
JobBytes | JobStatus |
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
| 7,666 | nymph | 2007-07-12 01:07:30 | B | D | 27 |
1,133,312 | T |
+-------+-------+---------------------+------+-------+----------+-----------+-----------+
You have messages.
*m
17-Jul 11:08 packrat-dir: *Console*.2007-07-17_11.08.01 Fatal error:
sql_list.c:372 sql_list.c:372 query SELECT
CONCAT(Path.Path,Filename.Name) AS Filename FROM File,Filename,Path
WHERE File.JobId=7666 AND Filename.FilenameId=File.FilenameId AND
Path.PathId=File.PathId failed:
Can't open file: 'Filename.MYI' (errno: 145)
*
Platform: Centos 4, MySQL 4.1.20, Bacula 2.0.3 (06 March 2007)
I have 40 days of catalog backups in disk volumes plus more on tapes,
but the latest on disk appears to be good. The disk volume contains only
one job.
Unfortunately I wrote over the bootstrap file for this backup with the
one from a tape backup of the catalog (I'll have to fix that later)
I do have the listing of the job, so I have the Volume name, Session ID
and Session Time. I've begun manually constructing a bootstrap file
following the "when things go wrong" section. Do I also need to specify
MediaType so it can find the disk volume?
Furthermore, does it look like a broken catalog is the right problem to
fix ?
I'm trying to proceed calmly here.. Thank in advance for your advice.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
