In response to Martin Simmons <[EMAIL PROTECTED]>: > >>>>> On Mon, 06 Aug 2007 10:24:11 -0400, Roland Roberts said: > > > > I'm a bacula newbie. I've just installed bacula 2.0.3 on two Fedora > > Core 6 systems, my backup server and my laptop. After working through > > the tutorial and getting my test backup and restore to work locally, I > > configured the laptop and left it to do an overnight backup. It looked > > good for a while, but when I awoke this morning, I had the errors (below). > > > > I'm not sure how to avoid the problem in the future. I can't find > > client_encoding in the manual, or anything with "encoding" in its name > > as a parameter to be set. I see the problem is caused by a couple of > > files with names that are not ASCII (an presumably not UTF8 either). I > > can "fix" this problem by just uninstalling the packages to which these > > files belong (they belong to games I don't play).
This is a PostgreSQL issue, which is why you won't find much reference in the Bacula manuals. PostgreSQL is super careful to ensure you don't insert invalid data. This is a different philosophy than MySQL, which seems to be super careful not to over-complicate things for the user. Connect to the PostgreSQL database using the psql command: psql -U bacula bacula Then enter "\l" to list the installed databases and their attributes. You should see the bacula database as UTF8. If not, you're kind of in a jam, because you can't change the encoding on a PG database after it's been created, you'll have to drop the database and recreate it. If you need to save the database, you'll need to pg_dump it, drop and recreate it with the correct encoding, then restore from the dump, which may involve manually correcting data that doesn't match UTF8 rules. You have two encodings that PG uses, the database encoding and the client encoding. This is spiffy because it allows each user to change his encoding and PG will convert data as needed on the fly. Unfortunately, it also makes things a little more complicated. The previous paragraph dealt with the DB encoding. To see what the client encoding is, you can do "show client_encoding;" from the psql program. If this is not set to UTF8, you _can_ change it on the fly. Simply issue "ALTER DATABASE bacula SET client_encoding='UTF8';" Then you'll want to restart Bacula for it to pick up the new setting. There is more information here: http://www.postgresql.org/docs/8.2/static/multibyte.html HTH. > > How can I figure out the actual encoding for these file names? How can > > I fix the problem to back them up in the future? > > From the context, it looks like the encoding of those names is Latin-1 (ISO > 8859-1). I don't think Bacula cares about the encoding much itself on unix, > other than for config files and messages, so you could try using a database > encoding that allows any sequence of bytes. > > __Martin > > > > > > > roland > > > > -- > > PGP Key ID: 66 BC 3B CD > > Roland B. Roberts, PhD RL Enterprises > > [EMAIL PROTECTED] 6818 Madeline Court > > [EMAIL PROTECTED] Brooklyn, NY 11220 > > > > > > > > 06-Aug 02:42 bacula-dir: No prior Full backup Job record found. > > 06-Aug 02:42 bacula-dir: No prior or suitable Full backup found in catalog. > > Doing FULL backup. > > 06-Aug 02:42 bacula-dir: Start Backup JobId 1, > > Job=Aristarchus_Backup.2007-08-06_02.42.10 > > 06-Aug 02:42 bacula-sd: Wrote label to prelabeled Volume "Volume000" on > > device "FileStorage" (/backup) > > Aristarchus: /var/lib/nfs/rpc_pipefs is a different filesystem. Will > > not descend from / into /var/lib/nfs/rpc_pipefs > > Aristarchus: /dev is a different filesystem. Will not descend from / > > into /dev > > Aristarchus: /misc is a different filesystem. Will not descend from / > > into /misc > > Aristarchus: /home is a different filesystem. Will not descend from / > > into /home > > Aristarchus: /net is a different filesystem. Will not descend from / > > into /net > > Aristarchus: /selinux is a different filesystem. Will not descend from > > / into /selinux > > Aristarchus: /sys is a different filesystem. Will not descend from / > > into /sys > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM > > Filename WHERE Name='reconstructîon2.xal' failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) > > VALUES ('reconstructîon2.xal') failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:872 Create db Filename record INSERT INTO Filename > > (Name) VALUES ('reconstructîdon2.xal') failed. ERR=ERROR: invalid byte > > sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: catreq.c:476 Attribute create error. sql_create.c:872 Create db > > Filename record INSERT INTO Filename (Name) VALUES ('reconstructîon2.xal') > > failed. ERR=ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM > > Filename WHERE Name='español.lng' failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) > > VALUES ('español.lng') failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:872 Create db Filename record INSERT INTO Filename > > (Name) VALUES ('español.lng') failed. ERR=ERROR: invalid byte sequence for > > encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: catreq.c:476 Attribute create error. sql_create.c:872 Create db > > Filename record INSERT INTO Filename (Name) VALUES ('español.lng') failed. > > ERR=ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 04:35 bacula-sd: Job write elapsed time = 01:52:58, Transfer rate = > > 7.579 M bytes/second > > 06-Aug 04:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Error: > > Bacula 2.0.3 (06Mar07): 06-Aug-2007 04:35:12 > > JobId: 1 > > Job: Aristarchus_Backup.2007-08-06_02.42.10 > > Backup Level: Full (upgraded from Incremental) > > Client: "aristarchus" 2.0.3 (06Mar07) > > i686-redhat-linux-gnu,redhat,(Zod) > > FileSet: "Aristarchus Set" 2007-08-06 02:42:10 > > Pool: "Default" (From Job resource) > > Storage: "File" (From command line) > > Scheduled time: 06-Aug-2007 02:42:01 > > Start time: 06-Aug-2007 02:42:14 > > End time: 06-Aug-2007 04:35:12 > > Elapsed time: 1 hour 52 mins 58 secs > > Priority: 10 > > FD Files Written: 509,288 > > SD Files Written: 509,288 > > FD Bytes Written: 51,303,198,098 (51.30 GB) > > SD Bytes Written: 51,374,843,510 (51.37 GB) > > Rate: 7569.1 KB/s > > Software Compression: None > > VSS: no > > Encryption: no > > Volume name(s): Volume000 > > Volume Session Id: 1 > > Volume Session Time: 1186382480 > > Last Volume Bytes: 51,429,073,100 (51.42 GB) > > Non-fatal FD errors: 0 > > SD Errors: 0 > > FD termination status: OK > > SD termination status: OK > > Termination: *** Backup Error *** > > > > 06-Aug 02:42 bacula-dir: No prior Full backup Job record found. > > 06-Aug 02:42 bacula-dir: No prior or suitable Full backup found in catalog. > > Doing FULL backup. > > 06-Aug 02:42 bacula-dir: Start Backup JobId 1, > > Job=Aristarchus_Backup.2007-08-06_02.42.10 > > 06-Aug 02:42 bacula-sd: Wrote label to prelabeled Volume "Volume000" on > > device "FileStorage" (/backup) > > Aristarchus: /var/lib/nfs/rpc_pipefs is a different filesystem. Will > > not descend from / into /var/lib/nfs/rpc_pipefs > > Aristarchus: /dev is a different filesystem. Will not descend from / > > into /dev > > Aristarchus: /misc is a different filesystem. Will not descend from / > > into /misc > > Aristarchus: /home is a different filesystem. Will not descend from / > > into /home > > Aristarchus: /net is a different filesystem. Will not descend from / > > into /net > > Aristarchus: /selinux is a different filesystem. Will not descend from > > / into /selinux > > Aristarchus: /sys is a different filesystem. Will not descend from / > > into /sys > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM > > Filename WHERE Name='reconstructîon2.xal' failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) > > VALUES ('reconstructîon2.xal') failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:872 Create db Filename record INSERT INTO Filename > > (Name) VALUES ('reconstructîon2.xal') failed. ERR=ERROR: invalid byte > > sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:21 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: catreq.c:476 Attribute create error. sql_create.c:872 Create db > > Filename record INSERT INTO Filename (Name) VALUES ('reconstructîon2.xal') > > failed. ERR=ERROR: invalid byte sequence for encoding "UTF8": 0xee6f6e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM > > Filename WHERE Name='español.lng' failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) > > VALUES ('español.lng') failed: > > ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: sql_create.c:872 Create db Filename record INSERT INTO Filename > > (Name) VALUES ('español.lng') failed. ERR=ERROR: invalid byte sequence for > > encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 03:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Fatal > > error: catreq.c:476 Attribute create error. sql_create.c:872 Create db > > Filename record INSERT INTO Filename (Name) VALUES ('español.lng') failed. > > ERR=ERROR: invalid byte sequence for encoding "UTF8": 0xf16f6c2e > > HINT: This error can also happen if the byte sequence does not match the > > encoding expected by the server, which is controlled by "client_encoding". > > > > 06-Aug 04:35 bacula-sd: Job write elapsed time = 01:52:58, Transfer rate = > > 7.579 M bytes/second > > 06-Aug 04:35 bacula-dir: Aristarchus_Backup.2007-08-06_02.42.10 Error: > > Bacula 2.0.3 (06Mar07): 06-Aug-2007 04:35:12 > > JobId: 1 > > Job: Aristarchus_Backup.2007-08-06_02.42.10 > > Backup Level: Full (upgraded from Incremental) > > Client: "aristarchus" 2.0.3 (06Mar07) > > i686-redhat-linux-gnu,redhat,(Zod) > > FileSet: "Aristarchus Set" 2007-08-06 02:42:10 > > Pool: "Default" (From Job resource) > > Storage: "File" (From command line) > > Scheduled time: 06-Aug-2007 02:42:01 > > Start time: 06-Aug-2007 02:42:14 > > End time: 06-Aug-2007 04:35:12 > > Elapsed time: 1 hour 52 mins 58 secs > > Priority: 10 > > FD Files Written: 509,288 > > SD Files Written: 509,288 > > FD Bytes Written: 51,303,198,098 (51.30 GB) > > SD Bytes Written: 51,374,843,510 (51.37 GB) > > Rate: 7569.1 KB/s > > Software Compression: None > > VSS: no > > Encryption: no > > Volume name(s): Volume000 > > Volume Session Id: 1 > > Volume Session Time: 1186382480 > > Last Volume Bytes: 51,429,073,100 (51.42 GB) > > Non-fatal FD errors: 0 > > SD Errors: 0 > > FD termination status: OK > > SD termination status: OK > > Termination: *** Backup Error *** > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? Stop. > > Now Search log events and configuration files using AJAX and a browser. > > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Bill Moran http://www.potentialtech.com ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
