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.
The Director Version is 2.4.4 (the version provided by Debian Stable)
and the clients are different ones from 2.1.26 to 2.4.5. As it is the
same with all client-versions the problem seems to be the director. As i
could not find a repository for Lenny which provides the latest version
i will have to compile it on my own. I'll check this as soon as possible.
>
>> 2. How can i solve that problem. There is nothing in the bacula logs and
>> the db-log just tells me that the batch insert failed at line xyz. But
>> as the attribute spool-file is deleted after the job, i can't look which
>> file produces the error. Is it something which is adressed in bacula v3.
>> If so, i would take the pain and upgrade by self-compiling the new
>> bacula instead of taking the deb-packages.
>
> What is the exact error you see in the db logs? What does psql -l print?
Sorry, the logs are german, the english version would be:
ERROR: invalid byte sequence for encoding "UTF8": 0xf66e6c69
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".
2009-07-06 19:45:12 CEST FEHLER: ungültige Byte-Sequenz für Kodierung
»UTF8«: 0xf66e6c69
2009-07-06 19:45:12 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-06 19:45:12 CEST ZUSAMMENHANG: COPY batch, Zeile 42434
2009-07-06 19:45:12 CEST ANWEISUNG: COPY batch FROM STDIN
2009-07-06 19:46:04 CEST FEHLER: Tabelle »delcandidates« existiert nicht
2009-07-06 19:46:04 CEST ANWEISUNG: DROP TABLE DelCandidates
2009-07-06 19:46:04 CEST FEHLER: Index »delinx1« existiert nicht
2009-07-06 19:46:04 CEST ANWEISUNG: DROP INDEX DelInx1
2009-07-06 19:46:04 CEST FEHLER: Index »delinx1« existiert nicht
2009-07-06 19:46:04 CEST ANWEISUNG: DROP INDEX DelInx1
And here is the output of psql -l:
psql -U bacula
Dies ist psql 8.3.7, das interaktive PostgreSQL-Terminal.
Geben Sie ein: \copyright für Urheberrechtsinformationen
\h für Hilfe über SQL-Anweisungen
\? für Hilfe über interne Anweisungen
\g oder Semikolon, um eine Anfrage auszuführen
\q um zu beenden
bacula=> \l
Liste der Datenbanken
Name | Eigentümer | Kodierung
-----------+------------+-----------
bacula | bacula | SQL_ASCII
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(4 Zeilen)
------------------------------------------------------------------------------
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
