List,

just upgraded from 3.0.3 to 5.0.0. no serious issues so far. thanks a
lot, guys.

i noticed one thing at the end of the job report:

04-Feb 23:15 pyramid-dir JobId 1368: Begin pruning Jobs older than 39
years 7 months 19 days 22 hours 15 mins 10 sec.

39 years? these are the configured retention periods:

File Retention = 30 days
Job Retention = 6 months
Volume Retention = 70 days


i had a little issue with bat. i had to change two sql statements
because sqlite has some problems executing them (unknown column
LocationId), see bacula-media.patch.

and i have a question: why is bat restricted to root and a normal user
is not allowed to execute it?


regards,
-ap


diff -Pur bacula-5.0.0.org/src/qt-console/mediainfo/mediainfo.cpp bacula-5.0.0/src/qt-console/mediainfo/mediainfo.cpp
--- bacula-5.0.0.org/src/qt-console/mediainfo/mediainfo.cpp     2010-02-05 01:10:56.691033000 +0100
+++ bacula-5.0.0/src/qt-console/mediainfo/mediainfo.cpp 2010-01-25 08:56:28.000000000 +0100
@@ -142,7 +142,7 @@
       "Media.MaxVolFiles, Media.MaxVolBytes, Media.VolRetention,InChanger,Slot "
       "FROM Media JOIN Pool USING (PoolId) LEFT JOIN Pool AS RecyclePool "
       "ON (Media.RecyclePoolId = RecyclePool.PoolId) "
-      "LEFT JOIN Location USING (LocationId) "
+      "LEFT JOIN Location ON (Media.LocationId = Location.LocationId) "
       "WHERE Media.VolumeName = '" + m_mediaName + "'";
 
    QStringList results;
diff -Pur bacula-5.0.0.org/src/qt-console/medialist/mediaview.cpp bacula-5.0.0/src/qt-console/medialist/mediaview.cpp
--- bacula-5.0.0.org/src/qt-console/medialist/mediaview.cpp     2010-02-05 21:54:27.008833675 +0100
+++ bacula-5.0.0/src/qt-console/medialist/mediaview.cpp 2010-01-25 08:56:28.000000000 +0100
@@ -304,7 +304,7 @@
       "Slot, MediaType, VolStatus, VolBytes, Pool.Name,  "
       "LastWritten, Media.VolRetention "
       "FROM Media JOIN Pool USING (PoolId) "
-      "LEFT JOIN Location USING (LocationId) "
+      "LEFT JOIN Location ON (Media.LocationId = Location.LocationId) "
       + cmd + 
       " ORDER BY VolumeName LIMIT " + m_sbLimit->cleanText();
 

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to