Re: [Bacula-users] Database insert error in bacula-5.2.5.

On Thu, 2012-02-02 at 11:11 -0500, John Drescher wrote:
> I have just upgraded to bacula 5.2.5 from 5.2.1 and I have not seen
> this one before. Although this is the first Full backup on a windows
> box in a while.
> 
> 02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
> "Task Scheduler Writer", State: 0x1 (VSS_WS_STABLE)
<snip />
> 02-Feb 05:43 fileserver-dir JobId 28103: Fatal error:
> sql_create.c:1219 Create db Object record INSERT INTO RestoreObject
> (ObjectName,PluginName,RestoreObject,ObjectLength,ObjectFullLength,ObjectIndex,ObjectType,ObjectCompression,FileIndex,JobId)
> VALUES 
> ('job_metadata.xml','job','\x3c004200410043004b00550050005f0043004f004d0050004f004e0045004e0054005300200078006d006c006e0073003d00220078002d0073006300680065006d0061003a00230056007300730043006f006d0070006f006e0065006e0074004d00650074006100640061007400610022002000760065007200730069006f006e003d00220031002e0032002200200062006f006f007400610062006c006500530079007300740065006d00530074006100740065004200610063006b00750070003d00220079006500730022002000730065006c0065006300740043006f006d0070006f006e0065006e00740073003d002200790065007300220020006200610063006b007500700054007900700065003d002200660075006c006c00220020007000610072007400690061006c00460069006c00650053007500700070006f00720074003d0022006e006f002200200073006e0061007000730068006f007400530065007400490064003d002200610038006500320036003800310062002d0032003100350066002d0034006600390066002d0039003400320038002d0036003900340037006500660039006300330062006500310022002f003e000000',448,448,1328179370,25,0,3581464,28103)
> failed. ERR=ERROR:  permission denied for relation restoreobject
> 02-Feb 05:43 fileserver-dir JobId 28103: Fatal error: catreq.c:538
> Restore object create error. sql_create.c:1219 Create db Object record
> INSERT INTO RestoreObject
> (ObjectName,PluginName,RestoreObject,ObjectLength,ObjectFullLength,ObjectIndex,ObjectType,ObjectCompression,FileIndex,JobId)
> VALUES 
> ('job_metadata.xml','job','\x3c004200410043004b00550050005f0043004f004d0050004f004e0045004e0054005300200078006d006c006e0073003d00220078002d0073006300680065006d0061003a00230056007300730043006f006d0070006f006e0065006e0074004d00650074006100640061007400610022002000760065007200730069006f006e003d00220031002e0032002200200062006f006f007400610062006c006500530079007300740065006d00530074006100740065004200610063006b00750070003d00220079006500730022002000730065006c0065006300740043006f006d0070006f006e0065006e00740073003d002200790065007300220020006200610063006b007500700054007900700065003d002200660075006c006c00220020007000610072007400690061006c00460069006c00650053007500700070006f00720074003d0022006e006f002200200073006e0061007000730068006f007400530065007400490064003d002200610038006500320036003800310062002d0032003100350066002d0034006600390066002d0039003400320038002d0036003900340037006500660039006300330062006500310022002f003e000000',448,448,1328179370,25,0,3581464,28103)
> failed. ERR=ERROR:  permission denied for relation restoreobject
<snip />
> 
> 
> Did I miss a db update / grant somewhere?
> 

hi, 

Long time lurker here, first attempt to help.

Seems like that should be the same issue a previous poster had when
attempting a catalog backup (I had that issue after upgrade to 5.2.2).

When I upgraded from 5.0.3 (db v12) to 5.2.2 (db v14) using source code,
restoreobject was created.  I don't know which db version 5.2.1 used but
I don't see a db v13 so presumably there was a db structure upgrade from
any version < 5.2.2.  (I'm too lazy to look at the moment).

You, or the upgrade script, probably did miss a GRANT on table
restoreobject.  It's not in the db upgrade script I used
(bacula/bacula/updatedb/update_postgresql_tables_12_to_14).

I GRANTed rights to user bacula for that table and in addition usage
must be granted for the related sequence (postgresql).

This is what I have now:
bacula=# \dp restoreobject*
                                            Access privileges
 Schema |               Name                |   Type   |   Access
privileges   | Column access privileges 
--------+-----------------------------------+----------+-----------------------+--------------------------
 public | restoreobject                     | table    |
bacula=arwdDxt/bacula
 public | restoreobject_restoreobjectid_seq | sequence |
bacula=rwU/bacula     |

Regards,
Marty Frasier



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users