uploading zip with invalid coordinates file
This should result in errors associated to the project. However the error is not logged in the db - thread crash with the errors in log file:
2018-05-28 13:13:36,918 ERROR [Thread-16] (ProjectService.java:1514) - Unknown column name: "��F^@I^@L^@E".
lcsb.mapviewer.converter.InvalidCoordinatesFile: Unknown column name: "��F^@I^@L^@E".
at lcsb.mapviewer.converter.OverviewParser.processCoordinates(OverviewParser.java:267)
at lcsb.mapviewer.converter.OverviewParser.parseOverviewLinks(OverviewParser.java:191)
at lcsb.mapviewer.converter.ComplexZipConverter.createModel(ComplexZipConverter.java:147)
at lcsb.mapviewer.services.impl.ProjectService.createModel(ProjectService.java:686)
at lcsb.mapviewer.services.impl.ProjectService$7.run(ProjectService.java:953)
at java.lang.Thread.run(Thread.java:748)
2018-05-28 13:13:36,928 WARN [Thread-16] (SqlExceptionHelper.java:143) - SQL Error: 0, SQLState: 22021
2018-05-28 13:13:36,929 ERROR [Thread-16] (SqlExceptionHelper.java:144) - ERROR: invalid byte sequence for encoding "UTF8": 0x00
2018-05-28 13:13:36,932 WARN [Thread-16] (NewPooledConnection.java:486) - [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
2018-05-28 13:13:36,932 WARN [Thread-16] (NewPooledConnection.java:487) - [c3p0] Another error has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block ] which will not be reported to listeners!
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:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy59.executeUpdate(Unknown Source)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3013)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2915)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3244)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:113)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:276)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1127)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:325)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
at lcsb.mapviewer.persist.DbUtils.closeSessionForCurrentThread(DbUtils.java:168)
at lcsb.mapviewer.services.impl.ProjectService$7.run(ProjectService.java:1029)
at java.lang.Thread.run(Thread.java:748)
2018-05-28 13:13:36,932 WARN [Thread-16] (SqlExceptionHelper.java:143) - SQL Error: 0, SQLState: 25P02
2018-05-28 13:13:36,932 ERROR [Thread-16] (SqlExceptionHelper.java:144) - ERROR: current transaction is aborted, commands ignored until end of transaction block
reported by Diana Gabriel(aging map project)
Edited by Piotr Gawron