[Bacula-bugs] [bacula 0000836]: SQL errors

[<bac...@li...>]

The following issue has been CLOSED 
====================================================================== 
http://bugs.bacula.org/view.php?id=836 
====================================================================== 
Reported By:                litauer
Assigned To:                ebollengier
====================================================================== 
Project:                    bacula
Issue ID:                   836
Category:                   brestore
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     closed
Resolution:                 reopened
Fixed in Version:           2.2.0
====================================================================== 
Date Submitted:             04-25-2007 09:34 EDT
Last Modified:              04-30-2007 05:28 EDT
====================================================================== 
Summary:                    SQL errors
Description: 
When selecting a client from the client list, following errors are
reported:

DBD::mysql::st execute failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'AND brestore_pathvisibility1.jobid IN
(126,106,86,66,46,4)) AS listpath1
    JOI' at line 13 at ./brestore.pl line 2519.
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at
./brestore.pl line 2520.
DBD::mysql::db selectall_arrayref failed: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ')
           AND File.JobId IN (126,106,86,66,46,4)
         GROUP BY Filename.Name
         ORDER BY' at line 7 at ./brestore.pl line 292.
Use of uninitialized value in subroutine entry at ./brestore.pl line 1491.
====================================================================== 

---------------------------------------------------------------------- 
 ebollengier - 04-28-07 06:44  
---------------------------------------------------------------------- 
Can you run brestore with debug option and past the full sql statement ? 

---------------------------------------------------------------------- 
 ebollengier - 04-28-07 07:53  
---------------------------------------------------------------------- 
Witch version of mysql are you using ? 

---------------------------------------------------------------------- 
 litauer - 04-30-07 02:37  
---------------------------------------------------------------------- 
I am running mysql 5.0

Here ist the debug output (parts of it):

Bvfs::ls_dirs:2518
SELECT PathId, Path, JobId, Lstat FROM (
    
    SELECT Path1.PathId, Path1.Path, lower(Path1.Path),
           listfile1.JobId, listfile1.Lstat
    FROM (
        SELECT DISTINCT brestore_pathhierarchy1.PathId
        FROM brestore_pathhierarchy AS brestore_pathhierarchy1
        JOIN Path AS Path2
            ON (brestore_pathhierarchy1.PathId = Path2.PathId)
        JOIN brestore_pathvisibility AS brestore_pathvisibility1
            ON (brestore_pathhierarchy1.PathId =
brestore_pathvisibility1.PathId)
        WHERE brestore_pathhierarchy1.PPathId = 
        AND brestore_pathvisibility1.jobid IN (231,210,189,4)) AS
listpath1
    JOIN Path AS Path1 ON (listpath1.PathId = Path1.PathId)
    LEFT JOIN (
        SELECT File1.PathId, File1.JobId, File1.Lstat FROM File AS File1
        WHERE File1.FilenameId = 21
        AND File1.JobId IN (231,210,189,4)) AS listfile1
        ON (listpath1.PathId = listfile1.PathId)
     ) AS A ORDER BY 2,3 DESC

DBD::mysql::st execute failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'AND brestore_pathvisibility1.jobid IN (231,210,189,4))
AS listpath1
    JOIN Pat' at line 13 at ./brestore.pl line 2519.
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at
./brestore.pl line 2520. 

---------------------------------------------------------------------- 
 ebollengier - 04-30-07 04:02  
---------------------------------------------------------------------- 
Can you try the last svn version ?

You have to remove old tables
drop table brestore_knownjobid;
drop table brestore_pathhierarchy;
drop table brestore_pathvisibility;
drop table brestore_missing_path; 

---------------------------------------------------------------------- 
 litauer - 04-30-07 04:20  
---------------------------------------------------------------------- 
Works great, thanks a lot! 

---------------------------------------------------------------------- 
 ebollengier - 04-30-07 04:41  
---------------------------------------------------------------------- 
Thanks for your feedback 

---------------------------------------------------------------------- 
 litauer - 04-30-07 04:45  
---------------------------------------------------------------------- 
Sorry, my jubilations were too early ;-)

I can select a client from the client list now. I changed the location to
/etc and tried to restore fstab. I added fstab to restore items an clicked
Restore. After about 2-3 minutes a popup "Ready to submit .." appears, but
all menus are empty (Storage, FileSet, Job, Client list). Clicking on OK
gives "Can't use this job". 

---------------------------------------------------------------------- 
 ebollengier - 04-30-07 05:27  
---------------------------------------------------------------------- 
It's not the same problem, the communication between brestore and your 
bconsole doesn't work.

Be sure to use bconsole binary /usr/sbin/bconsole with -n  switch 
(not /etc/bacula/bconsole) and that you can execute it in a xterm. (check
permission). 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
04-25-07 09:34  litauer        New Issue                                    
04-25-07 09:34  litauer        Status                   new => assigned     
04-25-07 09:34  litauer        Assigned To               => ebollengier     
04-28-07 06:44  ebollengier    Note Added: 0002405                          
04-28-07 07:53  ebollengier    Note Added: 0002406                          
04-30-07 02:37  litauer        Note Added: 0002416                          
04-30-07 04:02  ebollengier    Note Added: 0002417                          
04-30-07 04:20  litauer        Note Added: 0002418                          
04-30-07 04:41  ebollengier    Note Added: 0002419                          
04-30-07 04:42  ebollengier    Status                   assigned => closed  
04-30-07 04:42  ebollengier    Resolution               open => fixed       
04-30-07 04:42  ebollengier    Fixed in Version          => 2.2.0           
04-30-07 04:45  litauer        Status                   closed => feedback  
04-30-07 04:45  litauer        Resolution               fixed => reopened   
04-30-07 04:45  litauer        Note Added: 0002420                          
04-30-07 05:27  ebollengier    Note Added: 0002421                          
04-30-07 05:28  ebollengier    Status                   feedback => closed  
======================================================================