Thomas Kempf schrieb: > Martin Simmons schrieb: >>>>>>> On Tue, 07 Jul 2009 08:13:43 +0200, Thomas Kempf said: >>> hello, >>> i've got some problems with bacula 2.4.4. on Debian Lenny and postgresql >>> 8.3. Basically I'm facing the problem with postgresql discarding the >>> complete batch insert after a job because there are some invalid utf8 >>> byte-sequences in it. There were already some discussions on this >>> subject with the proposal to dump the db and to reload it with encoding >>> SQL_ASCII which is what i did. This did not solve my problem. The backup >>> of some machines still produces this annoying error. Now i have two >>> questions. >>> >>> 1. Why does bacula send me messages with the backup status of ok for >>> those machines instead of telling me at least, that the batch copy >>> failed. IMO there should be at least a warning that attribute despooling >>> failed. >> If this happens with the latest version of Bacula, then please make a bug >> report.
o.k. I installed bacula 3.0.1 and ran a backup job with one of the clients where the problem exists. Error still occurs. Here are the logs: ************************************************************************** 09-Jul 11:45 baraber-sd: Job write elapsed time = 01:23:56, Transfer rate = 22.43 M bytes/second 09-Jul 11:45 baraber-sd: Sending spooled attrs to the Director. Despooling 4,787,248 bytes ... 09-Jul 11:45 hueper-dir JobId 11420: Bacula hueper-dir 3.0.1 (30Apr09): 09-Jul-2009 11:45:57 Build OS: powerpc-unknown-linux-gnu debian 5.0.1 JobId: 11420 Job: TT-save.2009-07-09_10.19.00_04 Backup Level: Full Client: "baraber-fd" 2.1.26 (12Jul07) i686-pc-linux-gnu,suse,9.3 FileSet: "tt-save" 2009-07-09 10:19:00 Pool: "TT" (From Job resource) Catalog: "MyCatalog" (From Client resource) Storage: "NEC-LTO2" (From command line) Scheduled time: 09-Jul-2009 10:18:52 Start time: 09-Jul-2009 10:19:03 End time: 09-Jul-2009 11:45:57 Elapsed time: 1 hour 26 mins 54 secs Priority: 10 FD Files Written: 12,768 SD Files Written: 0 FD Bytes Written: 112,968,866,299 (112.9 GB) SD Bytes Written: 0 (0 B) Rate: 21666.4 KB/s Software Compression: None VSS: no Encryption: no Accurate: no Volume name(s): TT0002L2 Volume Session Id: 602 Volume Session Time: 1239870780 Last Volume Bytes: 119,144,245,248 (119.1 GB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination: Backup OK 09-Jul 11:45 hueper-dir JobId 11420: Begin pruning Jobs. 09-Jul 11:45 hueper-dir JobId 11420: No Jobs found to prune. 09-Jul 11:45 hueper-dir JobId 11420: Begin pruning Files. 09-Jul 11:45 hueper-dir JobId 11420: Pruned Files from 1 Jobs for client baraber-fd from catalog. 09-Jul 11:45 hueper-dir JobId 11420: End auto prune. ********************************************************************** After the job, there are no entries in the file table instead this is in the log of postgresql: *********************************************************************** 2009-07-09 11:45:53 CEST FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe4727a 2009-07-09 11:45:53 CEST TIPP: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. 2009-07-09 11:45:53 CEST ZUSAMMENHANG: COPY batch, Zeile 6844 2009-07-09 11:45:53 CEST ANWEISUNG: COPY batch FROM STDIN 2009-07-09 11:45:57 CEST FEHLER: Tabelle »delcandidates« existiert nicht 2009-07-09 11:45:57 CEST ANWEISUNG: DROP TABLE DelCandidates so i guess i'll make a bug report, because there should be at least a warning that something went wrong while spooling attributes. Tom ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
