On 24 Jan 2006 at 23:31, Attila Fülöp wrote:
> Mhhh,
>
> just upgraded to 1.38.5. The first time I tried to
> stop bacula the machine panicked(in pmap_invalidate_page)
> while stopping the director.
>
> Bacula 1.38.5 + FreeBSD 5.4-RELEASE-p8 amd64 (dual opteron)
> gcc 3.4.2 postgresql
>
> Anybody seen this before? Anybody using this setup without
> problems?
>
> This is a production machine, so I'm in troubles right now.
> Certainly I can't afford to panic/reboot it often.
> And no, I don't have a second opteron machine around.
>
> Below is what i did. Btw i know the reason for the errors:
> i ran the update_bacula_tables script with dbuser pgsql, not
> bacula. It's not that good if you type faster than you
> think :-( Well i can simply fix this by droping and
> recreating the tables. But then i have to restart bacula and
> cross my fingers.
>
>
> Attila
>
>
> [EMAIL PROTECTED] ~$ /usr/local/etc/rc.d/z-bacula.sh start
> Starting the Bacula Storage daemon
> Starting the Bacula File daemon
> Starting the Bacula Director daemon
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:331 sql_create.c:331
> query SELECT MediaTypeId,MediaType FROM MediaType WHERE MediaType='File'
> failed:
> ERROR: permission denied for relation mediatype
>
> 24-Jan 21:51 bacula-dir: sql_create.c:331 SELECT MediaTypeId,MediaType FROM
> MediaType WHERE MediaType='File'
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:349 sql_create.c:349
> insert INSERT INTO MediaType (MediaType,ReadOnly) VALUES ('File',0) failed:
> ERROR: permission denied for relation mediatype
>
> 24-Jan 21:51 bacula-dir: sql_create.c:349 INSERT INTO MediaType
> (MediaType,ReadOnly) VALUES ('File',0)
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:273 sql_create.c:273
> query SELECT StorageId,AutoChanger FROM Storage WHERE Name='File' failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_create.c:273 SELECT StorageId,AutoChanger FROM
> Storage WHERE Name='File'
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:301 sql_create.c:301
> insert INSERT INTO Storage (Name,AutoChanger) VALUES ('File',0) failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_create.c:301 INSERT INTO Storage
> (Name,AutoChanger) VALUES ('File',0)
> 24-Jan 21:51 bacula-dir: Error: sql_create.c:303 Create DB Storage record
> INSERT INTO Storage (Name,AutoChanger) VALUES ('File',0) failed. ERR=ERROR:
> permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: Error: sql_update.c:270 sql_update.c:270 update
> UPDATE Storage SET AutoChanger=0 WHERE StorageId=0 failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_update.c:270 UPDATE Storage SET AutoChanger=0
> WHERE StorageId=0
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:331 sql_create.c:331
> query SELECT MediaTypeId,MediaType FROM MediaType WHERE MediaType='LTO2'
> failed:
> ERROR: permission denied for relation mediatype
>
> 24-Jan 21:51 bacula-dir: sql_create.c:331 SELECT MediaTypeId,MediaType FROM
> MediaType WHERE MediaType='LTO2'
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:349 sql_create.c:349
> insert INSERT INTO MediaType (MediaType,ReadOnly) VALUES ('LTO2',0) failed:
> ERROR: permission denied for relation mediatype
>
> 24-Jan 21:51 bacula-dir: sql_create.c:349 INSERT INTO MediaType
> (MediaType,ReadOnly) VALUES ('LTO2',0)
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:273 sql_create.c:273
> query SELECT StorageId,AutoChanger FROM Storage WHERE Name='CertanceDrive'
> failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_create.c:273 SELECT StorageId,AutoChanger FROM
> Storage WHERE Name='CertanceDrive'
> 24-Jan 21:51 bacula-dir: Fatal error: sql_create.c:301 sql_create.c:301
> insert INSERT INTO Storage (Name,AutoChanger) VALUES ('CertanceDrive',0)
> failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_create.c:301 INSERT INTO Storage
> (Name,AutoChanger) VALUES ('CertanceDrive',0)
> 24-Jan 21:51 bacula-dir: Error: sql_create.c:303 Create DB Storage record
> INSERT INTO Storage (Name,AutoChanger) VALUES ('CertanceDrive',0) failed.
> ERR=ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: Error: sql_update.c:270 sql_update.c:270 update
> UPDATE Storage SET AutoChanger=0 WHERE StorageId=0 failed:
> ERROR: permission denied for relation storage
>
> 24-Jan 21:51 bacula-dir: sql_update.c:270 UPDATE Storage SET AutoChanger=0
> WHERE StorageId=0
> [EMAIL PROTECTED] ~$ /usr/local/etc/rc.d/z-bacula.sh stop
> Stopping the Bacula File daemon
> Stopping the Bacula Storage daemon
> Stopping the Bacula Director daemon
> --- Here the machine panicked -----
OK, I have a solution for those permission denied issues. I just
happened to document that a couple of days ago:
http://dan.langille.org/2006/01/21/bacula-notes-on-upgrading-to-1385/
The scripts there will give you a start on getting the permissions
right. Then try again.
--
Dan Langille : http://www.langille.org/
BSDCan - The Technical BSD Conference - http://www.bsdcan.org/
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
