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.swinsburg@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