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