Search • FAQ • Memberlist • Log in

Backup Central Forums Forum Index » Bacula » Database insert error in bacula-5.2.5.

The time now is Thu May 24, 2012 10:06 pm
View previous topic | View next topic
Reply to topic Page 1 of 1
Database insert error in bacula-5.2.5.
Author Message
drescherjm
Joined: 17 Apr 2009
Posts: 1545
Post Database insert error in bacula-5.2.5. 
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)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"VSS Metadata Store Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"Performance Counters Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"System Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"ASR Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"Registry Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"BITS Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"WMI Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"Shadow Copy Optimization Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 radimgws68-fd JobId 28103: VSS Writer (BackupComplete):
"COM+ REGDB Writer", State: 0x1 (VSS_WS_STABLE)
02-Feb 05:42 dev6-sd JobId 28103: Job write elapsed time = 19:42:17,
Transfer rate = 13.30 M Bytes/second
02-Feb 05:42 dev6-sd JobId 28103: Committing spooled data to Volume
"A00055". Despooling 46,437,086 bytes ...
02-Feb 05:42 dev6-sd JobId 28103: Despooling elapsed time = 00:00:01,
Transfer rate = 46.43 M Bytes/second
02-Feb 05:43 dev6-sd JobId 28103: Sending spooled attrs to the
Director. Despooling 1,379,307,904 bytes ...
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
02-Feb 05:43 fileserver-dir JobId 28103: Error: Bacula fileserver-dir
5.2.5 (26Jan12):
Build OS: x86_64-pc-linux-gnu gentoo
JobId: 28103
Job: radimgws68-full.2012-02-01_09.53.44_25
Backup Level: Full
Client: "radimgws68-fd" 5.2.5 (26Jan12) Microsoft
Windows 7 Enterprise Edition Service Pack 1 (build 7601),
64-bit,Cross-compile,Win64
FileSet: "ws68-full" 2010-07-28 20:30:00
Pool: "UserBackup-LTO2" (From Job resource)
Catalog: "HBCatalog" (From Client resource)
Storage: "DEV6-Changer" (From command line)
Scheduled time: 01-Feb-2012 09:52:10
Start time: 01-Feb-2012 09:53:46
End time: 02-Feb-2012 05:43:58
Elapsed time: 19 hours 50 mins 12 secs
Priority: 10
FD Files Written: 3,581,464
SD Files Written: 0
FD Bytes Written: 943,155,949,928 (943.1 GB)
SD Bytes Written: 0 (0 B)
Rate: 13207.2 KB/s
Software Compression: None
VSS: yes
Encryption: no
Accurate: no
Volume name(s): A00056|A00038|A00055
Volume Session Id: 749
Volume Session Time: 1319130239
Last Volume Bytes: 208,379,824,128 (208.3 GB)
Non-fatal FD errors: 1
SD Errors: 0
FD termination status: OK
SD termination status: SD despooling Attributes
Termination: *** Backup Error ***


Did I miss a db update / grant somewhere?

--
John M. Drescher

------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Thu Feb 02, 2012 8:13 am View user's profile Send private message
Marty Frasier
Guest



Post 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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Thu Feb 02, 2012 9:03 am
drescherjm
Joined: 17 Apr 2009
Posts: 1545
Post Database insert error in bacula-5.2.5. 
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     |


Sounds good to me. I will check this out later.

Thanks,
John

------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Thu Feb 02, 2012 9:14 am View user's profile Send private message
Geert Stappers
Guest



Post Database insert error in bacula-5.2.5. 
Op 20120202 om 18:12 schreef John Drescher:
Op 20120202 om 17:40 schreef Marty Frasier:
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     |


Sounds good to me. I will check this out later.

Is no news, good news?


Geert Stappers
in an attempt to release a possible self-reply-lock
------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Wed Feb 08, 2012 12:09 am
drescherjm
Joined: 17 Apr 2009
Posts: 1545
Post Database insert error in bacula-5.2.5. 
On Wed, Feb 8, 2012 at 3:07 AM, Geert Stappers
<Geert.Stappers < at > vanadgroup.com> wrote:
Op 20120202 om 18:12 schreef John Drescher:
Op 20120202 om 17:40 schreef Marty Frasier:
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     |


Sounds good to me. I will check this out later.

Is no news, good news?


No news is oh no.. I completely forgot about the issue. To many
projects going on at once. Thanks for reminding me. I will check on
this later in the week.

John

------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Wed Feb 08, 2012 5:20 am View user's profile Send private message
drescherjm
Joined: 17 Apr 2009
Posts: 1545
Post Database insert error in bacula-5.2.5. 
On Wed, Feb 8, 2012 at 8:19 AM, John Drescher <drescherjm < at > gmail.com> wrote:
On Wed, Feb 8, 2012 at 3:07 AM, Geert Stappers
<Geert.Stappers < at > vanadgroup.com> wrote:
Op 20120202 om 18:12 schreef John Drescher:
Op 20120202 om 17:40 schreef Marty Frasier:
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     |


Sounds good to me. I will check this out later.

Is no news, good news?


Working on now. The permissions were definitely wrong:
bacula=# \dp restoreobject*
Access privileges
Schema | Name | Type | Access
privileges | Column access privileges
--------+-----------------------------------+----------+-------------------+--------------------------
public | restoreobject | table | |
public | restoreobject_restoreobjectid_seq | sequence | |
(2 rows)




--
John M. Drescher

------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Wed Feb 08, 2012 9:44 am View user's profile Send private message
drescherjm
Joined: 17 Apr 2009
Posts: 1545
Post Database insert error in bacula-5.2.5. 
On Wed, Feb 8, 2012 at 12:43 PM, John Drescher <drescherjm < at > gmail.com> wrote:
On Wed, Feb 8, 2012 at 8:19 AM, John Drescher <drescherjm < at > gmail.com> wrote:
On Wed, Feb 8, 2012 at 3:07 AM, Geert Stappers
<Geert.Stappers < at > vanadgroup.com> wrote:
Op 20120202 om 18:12 schreef John Drescher:
Op 20120202 om 17:40 schreef Marty Frasier:
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     |


Sounds good to me. I will check this out later.

Is no news, good news?


Working on now. The permissions were definitely wrong:
bacula=# \dp restoreobject*
                                         Access privileges
 Schema |               Name                |   Type   | Access
privileges | Column access privileges
--------+-----------------------------------+----------+-------------------+--------------------------
 public | restoreobject                     | table    |                   |
 public | restoreobject_restoreobjectid_seq | sequence |                   |
(2 rows)



It seems I needed to re run the grant_postgresql_privileges script:

fileserver1 bacula # sh grant_postgresql_privileges -h 192.168.1.33 -U hbroker
Password for user hbroker:
psql:-:2: ERROR: role "bacula" already exists
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
Privileges for user bacula granted on database bacula.
fileserver1 bacula # psql -U hbroker -d bacula -h 192.168.1.33
Password for user hbroker:
psql (9.1.2)
Type "help" for help.

bacula=# \dp restoreobject*
Access privileges
Schema | Name | Type | Access
privileges | Column access privileges
--------+-----------------------------------+----------+-------------------------+--------------------------
public | restoreobject | table |
hbroker=arwdDxt/hbroker+|
| | |
bacula=arwdDxt/hbroker |
public | restoreobject_restoreobjectid_seq | sequence |
hbroker=rwU/hbroker +|
| | |
bacula=rw/hbroker |
(2 rows)

bacula=#

John

------------------------------------------------------------------------------
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.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Wed Feb 08, 2012 9:49 am View user's profile Send private message
Display posts from previous:

Backup Central Forums Forum Index » Bacula » Database insert error in bacula-5.2.5.

The time now is Thu May 24, 2012 10:06 pm | All times are GMT - 8 Hours
 
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB