Thomas Kempf wrote:
> 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
>
>
>
Hi Thomas, I remember discussion on the ML about trouble with postgresql &
bacula.
Bacula mens insist to have SQL_ASCII for postgres & bacula.
Your bacula's db is SQL_ASCII, but I suppose as template0 and template1 are
UTF-8 the batch temporary table
are created based on one of the two which conduct to the errors you encounter.
I think you have to give this information if you are reporting this bug.
(Perharps give a try to the wiki, searching about postgresql & the docs )
before you transmit a bug.
Anyway if bacula need a sql_ascii table, it should be "smart" enough to create
it with this requirement.
--
Bruno Friedmann
Ioda-Net Sàrl
2830 Vellerat - Switzerland
Tél : ++41 32 435 7171
Fax : ++41 32 435 7172
gsm : ++41 78 802 6760
www.ioda-net.ch
Centre de Formation et de Coaching En Ligne
www.cfcel.com
------------------------------------------------------------------------------
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
