#850: errors in upgrade sql script in trunk
-------------------------+--------------------------------------------------
Reporter: jeanpommier | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
-------------------------+--------------------------------------------------
Some lang codes ('sp', 'po') are erroneous in the migrate-default.sql
script. Another one is missing/removed.
No data is inserted for the new ones (vie, nor, fin)
I've fixed the erroneous and missing codes issues but not inserting data,
in the attached file.
'''However''', the upgraded database does not work :
{{{
ERROR [geonetwork.datamanager] - The metadata document index with id=134
is corrupt/invalid - ignoring it. Error: ERROR: current transaction is
aborted, commands ignored until end of transaction block
org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
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 jeeves.resources.dbms.Dbms.selectFull(Dbms.java:210)
at jeeves.resources.dbms.Dbms.select(Dbms.java:181)
at
org.fao.geonet.kernel.XmlSerializer.internalSelect(XmlSerializer.java:92)
at
org.fao.geonet.kernel.XmlSerializerSvn.internalSelect(XmlSerializerSvn.java:72)
at
org.fao.geonet.kernel.XmlSerializerSvn.selectNoXLinkResolver(XmlSerializerSvn.java:107)
at
org.fao.geonet.kernel.DataManager.indexMetadata(DataManager.java:436)
at
org.fao.geonet.kernel.DataManager.indexMetadataGroup(DataManager.java:419)
at
org.fao.geonet.kernel.DataManager$IndexMetadataTask.run(DataManager.java:367)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
}}}
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/850>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.