Hello, Thanks for the bug report. In the future, it would be helpful to send them to [EMAIL PROTECTED] instead of the bacula-users list.
This is actually a bug in MySQL, or at least the version you are using since, unless I am mistaken, the SQL standard requires table names to be case independent. Just the same, I have corrected the Bacula code in both the 1.36.2 stream (to be released shortly) and the 1.37 development stream. Thanks for the patch. On Fri, 2005-02-18 at 12:29 +0100, Lupe Christoph wrote: > 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 -- Best regards, Kern -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
