Dan Langille wrote:
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,

thanks for the pointer. I actually solved it by droping the tables
and recreating them as dbuser bacula. Not much of an effort.
What really worries me is the kernel crash I observed. Well the
second time i restarted bacula everything went smoothly. I'll keep
track of this. I will have a look at the vmcore and may report this
to the FreeBSD ppl.


Attila



-------------------------------------------------------
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

Reply via email to