Steve - I used Google and found this:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00269.php
When I run the 'locale' command here, I get this:
LC_CTYPE="en_US.UTF-8"
The same thing when I check from psql:
gkrtrain=> show lc_ctype
gkrtrain-> ;
lc_ctype
-------------
en_US.UTF-8
(1 row)
I'm not sure if this is related to your problem, but it might be worth
verifying that you get similar answers.
On Oct 27, 2010, at 5:46 PM, Steve Swinsburg wrote:
> Hi all,
>
> We've completed another restore but are still having the same issue. This
> time we created a new database with the UNICODE encoding as per the
> installation manual:
> createdb -U dspace -E UNICODE dspace
> We then took an export of the current production database:
> pg_dump dspace > dspace-prod.dump
> and imported it into the new database:
> psql -d dspace -f dspace-prod.dump
>
> We then upgraded the database to 1.6:
>
> psql -U dspace -f
> /dspace-1.6-2-src-release/dspace/etc/postgres/database_schema_15_16.sql dspace
>
>
> And ran the index-init script:
> [dspace]/bin/dspace index-init
> But still the same issue as before.
>
>>> dspace index-init -v
>>> Exception: org.postgresql.util.PSQLException: ERROR: invalid multibyte
>>> character for locale
>>> org.dspace.browse.BrowseException: org.postgresql.util.PSQLException:
>>> ERROR: invalid multibyte character for locale
>>> at
>>> org.dspace.browse.BrowseCreateDAOPostgres.insertDistinctRecord(BrowseCreateDAOPostgres.java:691)
>>> at
>>> org.dspace.browse.BrowseCreateDAOPostgres.getDistinctID(BrowseCreateDAOPostgres.java:566)
>>> at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:485)
>>> at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1148)
>>> at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1098)
>>> at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:749)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at
>>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212)
>
>
>
> Is there anything wrong with the above process? The next step we are going to
> attempt is checking the actual SQL dump for the bad characters but it is
> massive (1.5 Gb)
>
>
> thanks,
> Steve
>
>
>
>
>
>
>
>
> On 26/10/2010, at 10:10 AM, Steve Swinsburg wrote:
>
>> Hi Kim,
>>
>> We took a *copy* of the database and refreshed it back to dev, so it is
>> identical to the production one, then upgraded it in dev. So I'll need to
>> find out if the original database from production was created that way.
>>
>> Perhaps we should take a dump of the production database instead, and then
>> import that into a fresh UTF8 created database? I think the issue is that
>> the original database was never created as UTF8.
>>
>> Thanks,
>> Steve
>>
>>
>>
>>
>> On 26/10/2010, at 9:17 AM, Kim Shepherd wrote:
>>
>>> Hi Steve,
>>>
>>> Just to check, has your new/dev database been created with UTF8 character
>>> encoding? (pass -E UNICODE or -E UTF8 to createdb)
>>>
>>> Cheers,
>>>
>>> Kim
>>>
>>> On 25 October 2010 14:57, Steve Swinsburg <steve.swinsb...@gmail.com> wrote:
>>> Hi all,
>>>
>>> We are having a problem upgrading an instance of dspace from 1.5.x-1.6.2.
>>> We built the new 1.6.2 code and took a snapshot of our old production
>>> database and migrated in back to our dev environment (along with the
>>> assets). We then ran the db upgrade script.
>>>
>>> Now, when running the index-init script we get this:
>>>
>>> ./dspace index-init -v
>>> Exception: org.postgresql.util.PSQLException: ERROR: invalid multibyte
>>> character for locale
>>> org.dspace.browse.BrowseException: org.postgresql.util.PSQLException:
>>> ERROR: invalid multibyte character for locale
>>> at
>>> org.dspace.browse.BrowseCreateDAOPostgres.insertDistinctRecord(BrowseCreateDAOPostgres.java:691)
>>> at
>>> org.dspace.browse.BrowseCreateDAOPostgres.getDistinctID(BrowseCreateDAOPostgres.java:566)
>>> at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:485)
>>> at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1148)
>>> at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1098)
>>> at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:749)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at
>>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212)
>>>
>>> We are on Postgres:
>>> PostgreSQL 8.1.21 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
>>> 4.1.2 20080704 (Red Hat 4.1.2-48)
>>>
>>> Any tips?
>>>
>>> thanks,
>>> Steve
>>> ------------------------------------------------------------------------------
>>> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
>>> Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
>>> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
>>> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
>>> http://p.sf.net/sfu/nokia-dev2dev
>>> _______________________________________________
>>> DSpace-tech mailing list
>>> DSpace-tech@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>>
>>
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
> Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev_______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech