Sun Jul 8 23:21:14 PDT 2012
- Previous message: [Slony1-general] slonik_execute_script not working
- Next message: [Slony1-general] Initial replication failing due to collation error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Anyone seen something like this before?
2012-07-09 04:48:59 UTC[4137] ERROR remoteWorkerThread_1: "select
"_sl".finishTableAfterCopy(20); analyze "public"."reviewsapp_review";
" PGRES_FATAL_ERROR ERROR: could not determine which collation to use
for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.
CONTEXT: SQL statement "reindex table "public"."reviewsapp_review""
PL/pgSQL function "finishtableaftercopy" line 27 at EXECUTE statement
I'm replicating an 8.4 master to a 9.1 slave as part of an upgrade.
The only thing unusual about this table I can see is the column using
the debversion type, but we have successfully done the 8.4 -> 9.1
replication with other databases using that type before.
Table
"public.reviewsapp_review"
Column | Type |
Modifiers
--------------------------+--------------------------+----------------------------------------------------------------------------
id | integer | not null
default nextval('reviewsapp_review_id_seq'::regclass)
softwareitem_id | integer | not null
version | debversion | not null
architecture_id | integer | not null
repository_id | integer | not null
reviewer_id | integer | not null
date_created | timestamp with time zone | not null
default '2010-12-09 20:47:18.910573+00'::timestamp with time zone
rating | integer | not null
summary | character varying(80) | not null
review_text | character varying(5000) | not null
language | character varying(10) | not null
hide | boolean | not null default false
usefulness_total | integer | not null default 0
usefulness_favorable | integer | not null default 0
usefulness_percentage | integer | not null default 0
app_name | character varying(100) | not null
default ''::character varying
date_deleted | timestamp with time zone |
usefulness_wilson_rating | double precision | not null default 0.0
Indexes:
"reviewsapp_review_pkey" PRIMARY KEY, btree (id)
"reviewsapp_review_architecture_id" btree (architecture_id)
"reviewsapp_review_hide" btree (hide)
"reviewsapp_review_language" btree (language)
"reviewsapp_review_repository_id" btree (repository_id)
"reviewsapp_review_reviewer_id" btree (reviewer_id)
"reviewsapp_review_softwareitem_id" btree (softwareitem_id)
"reviewsapp_review_version" btree (version)
Foreign-key constraints:
"architecture_id_refs_id_3635e112ecae648a" FOREIGN KEY
(architecture_id) REFERENCES reviewsapp_architecture(id) DEFERRABLE
INITIALLY DEFERRED
"repository_id_refs_id_2f7062e6db353aa7" FOREIGN KEY
(repository_id) REFERENCES reviewsapp_repository(id) DEFERRABLE
INITIALLY DEFERRED
"reviewer_id_refs_id_28b87f276a073e1e" FOREIGN KEY (reviewer_id)
REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED
"softwareitem_id_refs_id_677a12388e4ffc27" FOREIGN KEY
(softwareitem_id) REFERENCES reviewsapp_softwareitem(id) DEFERRABLE
INITIALLY DEFERRED
Referenced by:
TABLE "reviewsapp_usefulness" CONSTRAINT
"review_id_refs_id_286d40f88d5acdc" FOREIGN KEY (review_id) REFERENCES
reviewsapp_review(id) DEFERRABLE INITIALLY DEFERRED
TABLE "reviewsapp_reviewmoderation" CONSTRAINT
"review_id_refs_id_6bfc7f3d50ef538b" FOREIGN KEY (review_id)
REFERENCES reviewsapp_review(id) DEFERRABLE INITIALLY DEFERRED
--
Stuart Bishop <stuart at stuartbishop.net>
http://www.stuartbishop.net/
- Previous message: [Slony1-general] slonik_execute_script not working
- Next message: [Slony1-general] Initial replication failing due to collation error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list