Hello everybody,
I'm setting up a DSpace 1.7.2 installation with a fairly large amount of
external data getting imported, and upon running index-init I end up
with the following error:
Exception: org.postgresql.util.PSQLException: ERROR: index row size 4216
exceeds maximum 2712 for index "bi_item_s1_idx"
org.dspace.browse.BrowseException: org.postgresql.util.PSQLException:
ERROR: index row size 4216 exceeds maximum 2712 for index "bi_item_s1_idx"
at
org.dspace.browse.BrowseCreateDAOPostgres.insertIndex(BrowseCreateDAOPostgres.java:700)
at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:354)
at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1073)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:715)
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:183)
Caused by: org.postgresql.util.PSQLException: ERROR: index row size 4216
exceeds maximum 2712 for index "bi_item_s1_idx"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
at
org.dspace.browse.BrowseCreateDAOPostgres.insertIndex(BrowseCreateDAOPostgres.java:695)
... 9 more
According to another thread on the subject, this seems to be related to
a too big dc.title string or a similar string that's used to construct
the search indexes in postgresql (4216 > 2712, but from what I can tell
I don't have any fields that long.. unicode issue maybe?). I haven't
changed any index settings from the original dspace.cfg. Now my question
is, is there any way to find out exactly where the problem lies so I
know where to start looking? The fields that are indexed as described in
the search.index.<x> entries in dspace.cfg? Are they all treated the
same way or differently? Any insight into this would be greatly
appreciated...
On a sidenote, this data will get updated overnight from other
repositories, is running index-init every time needed? Or is
index-update enough?
Thanks in advance,
Mikael Mölsä
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
