Re: [Bacula-users] catreq.c:586 attribute create error

[Fred P. <fre...@gm...>]

When I try and do an Update > Volume Parameters > All Volumes from All Pools
I get the following:
Error updating Volume records: ERR=sql_update.c:461 Update failed:
affected_rows=0 for UPDATE Media SET Acti                      onOnPurge=0,
Recycle=1,VolRetention=31536000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,
MaxVolBytes=0,Recyc                      lePoolId=0 WHERE PoolId=1
Error updating Volume records: ERR=sql_update.c:461 Update failed:
affected_rows=0 for UPDATE Media SET Acti                      onOnPurge=0,
Recycle=1,VolRetention=31536000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,
MaxVolBytes=5368709                      1200,RecyclePoolId=0 WHERE PoolId=2
Error updating Volume records: ERR=sql_update.c:461 Update failed:
affected_rows=0 for UPDATE Media SET Acti                      onOnPurge=0,
Recycle=1,VolRetention=31536000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,
MaxVolBytes=0,Recyc                      lePoolId=0 WHERE PoolId=3
Error updating Volume records: ERR=sql_update.c:461 Update failed:
affected_rows=0 for UPDATE Media SET Acti                      onOnPurge=0,
Recycle=1,VolRetention=5184000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,M
axVolBytes=53687091                      20,RecyclePoolId=0 WHERE PoolId=4
All Volume defaults updated from "pbserv1-localdrives" Pool record.
Error updating Volume records: ERR=sql_update.c:461 Update failed:
affected_rows=0 for UPDATE Media SET Acti                      onOnPurge=0,
Recycle=1,VolRetention=5184000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,M
axVolBytes=53687091                      20,RecyclePoolId=0 WHERE PoolId=6



List media produces the following output:

*list media
Pool: Default
No results to list.
Pool: File
No results to list.
Pool: Scratch
No results to list.
Pool: volpool_backup-pb01
No results to list.
Pool: pbserv1-localdrives
+---------+----------------------+-----------+---------+----------+---------
-+--------------+---------+------+-----------+-----------+------------------
---+
| MediaId | VolumeName           | VolStatus | Enabled | VolBytes | VolFiles
| VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten
|
+---------+----------------------+-----------+---------+----------+---------
-+--------------+---------+------+-----------+-----------+------------------
---+
|       1 | volpool_pbserv1-0001 | Append    |       1 |      225 |        0
|    5,184,000 |       1 |    0 |         0 | File      | 0000-00-00
00:00:00 |
+---------+----------------------+-----------+---------+----------+---------
-+--------------+---------+------+-----------+-----------+------------------
---+
Pool: pbserv1-critfiles
No results to list.




-----Original Message-----
From: Uwe Schuerkamp [mailto:uwe...@ni...] 
Sent: Friday, June 08, 2012 5:45 AM
To: Fred Parks
Cc: 'Bryan Harris'; bac...@li...
Subject: Re: [Bacula-users] catreq.c:586 attribute create error

On Wed, Jun 06, 2012 at 09:50:49PM -0400, Fred Parks wrote:
> I don't see anything on quotas being turned on in /etc/fstab and the 
> free inodes on the file systems is way high.
> 

Have you tried the "update" command from within bconsole to create / update
the pool and volume definitions? What's the output of "list media"? 

Cheers, Uwe