The postgreSQL import stage of the migration is failing on me.
It bombs out with this error message: ERROR: invalid byte sequence for encoding "UTF8": 0xeda080 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". CONTEXT: COPY rhnpackagechangelogdata, line 136452 I found a posting from July where someone had a similar problem. You had him apply a patch to the spacewalk-dump-schema script. I went to apply the same patch and found it to already be there. Here's a snippit from that old post: On Tue, Jul 12, 2011 at 02:01:19PM +0000, [email protected]<mailto:[email protected]> wrote: > Hi, > > fgrep -B1 rhnpackagerepodata spacewalk-oracle.dmp ... > -- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE > DATE Can you apply the following patch to your spacewalk-dump-schema and dump and import the schema again, to see if it addresses the problem for you? diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index e391111..0068ed4 100755 --- a/utils/spacewalk-dump-schema +++ b/utils/spacewalk-dump-schema @@ -115,7 +115,7 @@ sub process_table { if (ref $row->[$i] and ref $row->[$i] eq 'ARRAY') { # user types no warnings 'uninitialized'; $row->[$i] = "(@{[ join ',', @{$row->[$i]} ]})"; - } elsif ($types[$i] eq 'unknown') { # blobs + } elsif ($types[$i] eq 'unknown' or $types[$i] eq 'BLOB') { # blobs $row->[$i] =~ s!(.)! sprintf "\\\\%03o<file:///\\\%2503o>", ord($1) !seg; } else { $row->[$i] =~ s!([\x00-\x1f\x5c])! sprintf "\\x%02x<file:///\\x%2502x>", ord($1) !seg; The patch apparently worked for the other guy. When I check the oracle dump, I find the same 'Types' line: -- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE DATE copy rhnpackagerepodata(package_id,primary_xml,filelist,other,created,modified) from stdin; Any idea's? Since I have to scheduled downtime in advance, it's taking me a while to try out your suggestions and make any progress. I appreciated the quickness of your previous responses. Cheers, --james
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
