Package: bacula-director-mysql
Version: 1.36.1-1
Severity: normal
Tags: patch
Subject: bacula-director-mysql: Unknown table 'delCandidates'
Package: bacula-director-mysql
Version: 1.36.1-1
Severity: normal
A restore job just printed
18-Feb 11:51 antalya-dir: Begin pruning Jobs.
18-Feb 11:51 antalya-dir: Query failed: SELECT DISTINCT DelCandidates.JobId
FROM Job,DelCandidates WHERE (Job.JobTdate<1098355884 AND
delCandidates.JobStatus!='T') OR (Job.JobTDate>1098355884 AND Job.ClientId=1
AND Job.Type='R'): ERR=Unknown table 'delCandidates' in where clause
18-Feb 11:51 antalya-dir: Pruned 0 Jobs for client antalya-fd from catalog.
18-Feb 11:51 antalya-dir: Begin pruning Files.
18-Feb 11:51 antalya-dir: No Files found to prune.
18-Feb 11:51 antalya-dir: End auto prune.
There is a typo in src/dird/sql_cmds.c (still there in CVS, file version
1.48). Patch attached.
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (990, 'testing'), (100, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.4.27-lpc.7.k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages bacula-director-mysql depends on:
ii bacula-common 1.36.1-1 Network backup, recovery and verif
ii bacula-director-common 1.36.1-1 Network backup, recovery and verif
ii debconf 1.4.30.11 Debian configuration management sy
ii libc6 2.3.2.ds1-20 GNU C Library: Shared libraries an
ii libgcc1 1:3.4.3-6 GCC support library
ii libmysqlclient12 4.0.23-4 mysql database client library
ii libssl0.9.7 0.9.7e-2 SSL shared libraries
ii libstdc++5 1:3.3.5-8 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-6 Wietse Venema's TCP wrappers libra
ii mysql-client 4.0.23-4 mysql database client binaries
ii zlib1g 1:1.2.2-3 compression library - runtime
-- debconf information:
* bacula-director-mysql/remove_catalog_on_purge: false
* bacula-director-mysql/db_host: localhost
* bacula-director-mysql/create_tables: true
* bacula-director-mysql/mysql_root_username: lupe
* bacula-director-mysql/db_user: bacula
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (990, 'testing'), (100, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.4.27-lpc.7.k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages bacula-director-mysql depends on:
ii bacula-common 1.36.1-1 Network backup, recovery and verif
ii bacula-director-common 1.36.1-1 Network backup, recovery and verif
ii debconf 1.4.30.11 Debian configuration management sy
ii libc6 2.3.2.ds1-20 GNU C Library: Shared libraries an
ii libgcc1 1:3.4.3-6 GCC support library
ii libmysqlclient12 4.0.23-4 mysql database client library
ii libssl0.9.7 0.9.7e-2 SSL shared libraries
ii libstdc++5 1:3.3.5-8 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-6 Wietse Venema's TCP wrappers libra
ii mysql-client 4.0.23-4 mysql database client binaries
ii zlib1g 1:1.2.2-3 compression library - runtime
-- debconf information:
* bacula-director-mysql/remove_catalog_on_purge: false
* bacula-director-mysql/db_host: localhost
* bacula-director-mysql/create_tables: true
* bacula-director-mysql/mysql_root_username: lupe
* bacula-director-mysql/db_user: bacula
--- src/dird/sql_cmds.c.orig 2004-11-10 22:18:13.000000000 +0100
+++ src/dird/sql_cmds.c 2005-02-18 12:21:10.000000000 +0100
@@ -147,7 +147,7 @@
const char *select_restore_del =
"SELECT DISTINCT DelCandidates.JobId "
"FROM Job,DelCandidates "
- "WHERE (Job.JobTdate<%s AND delCandidates.JobStatus!='T') OR "
+ "WHERE (Job.JobTdate<%s AND DelCandidates.JobStatus!='T') OR "
"(Job.JobTDate>%s "
"AND Job.ClientId=%u "
"AND Job.Type='R')";
@@ -158,7 +158,7 @@
const char *select_admin_del =
"SELECT DISTINCT DelCandidates.JobId "
"FROM Job,DelCandidates "
- "WHERE (Job.JobTdate<%s AND delCandidates.JobStatus!='T') OR "
+ "WHERE (Job.JobTdate<%s AND DelCandidates.JobStatus!='T') OR "
"(Job.JobTDate>%s "
"AND Job.ClientId=%u "
"AND Job.Type='D')";
