Hello everyone,
I am getting the error in the subject line when running a job with a changed
fileset.
This is Bareos 16.2.4 running on Debian 9 "Stretch". When Stretch was released,
I upgraded from the existing configuration of Debian 8 "Jessie". Since I am
using the Debian Bareos packages, this upgraded Bareos from 14.2 to 16.2.4. I
did not check the release notes (my mistake, I know) and did not update the
database scheme as I should have. I manually updated the database scheme
version to 2004.
I have not since had a reason to update the FileSet until yesterday. I updated
a FileSet and tried to run a job. The job fails with the error below:
24-Nov 08:49 backup-dir JobId 908: Error: sql_create.c:791 Create DB FileSet
record INSERT INTO FileSet (FileSet,MD5,CreateTime,FileSetText) VALUES
('Clients','j+/9T+NcNR/U67/H5j/v6A','2017-11-24 08:49:30','FileSet {
Name = "Clients"
Include {
Options {
Signature = MD5
IgnoreCase = Yes
Drive Type = "fixed"
}
File = "C:/Users/"
}
}
') failed. ERR=ERROR: column "filesettext" of relation "fileset" does not exist
LINE 1: INSERT INTO FileSet (FileSet,MD5,CreateTime,FileSetText) VAL...
^
24-Nov 08:49 backup-dir JobId 908: Error: Could not create FileSet "Clients"
record. ERR=
The job runs if I change the FileSet back to what it previously was.
I assume this is because 15.2 added the FileSetText column in the database. I
have now updated the database scheme, but the problem continues.
Also, grant_bareos_privileges gives me this error, but appears to work
correctly:
Granting postgresql tables
psql:/tmp/grants.sql.6698:1: ERROR: role "bareos" 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
GRANT
GRANT
GRANT
GRANT
GRANT
Privileges for user bareos granted ON database bareos.
So how can I fix this, recognizing that it probably is my fault?
Thanks for your help,
oldtechaa
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
