I have also the same issue using JBoss Portal 2.4CR2 with Postgres 8.2
(postgresql-8.2-504.jdbc2.jar). However I noticed that it only happens with images that
are stored as BLOBs. I have increased the heap size as suggested. It looks to me as it
can't read the image file that is uploaded (gif). What's your take.
If anyone could help that would be great.
Let us know if a solution is available.
2007-01-08 09:22:19,859 DEBUG [org.hibernate.pretty.Printer]
org.jboss.portal.cms.hibernate.state.WSPBinVal{key=4901,
data=org.hibernate.lob.SerializableBlob@d5da26,
id=6d3f3f3e-12c0-4207-814f-a56245fec7c0/{http://www.jcp.org/jcr/1.0}data[0]}
| 2007-01-08 09:22:19,859 DEBUG [org.hibernate.engine.ActionQueue] changes must be
flushed to space: jbp_cms_wsp_binval
| 2007-01-08 09:22:19,859 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open
PreparedStatement (open PreparedStatements: 0, globally: 0)
| 2007-01-08 09:22:19,859 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC
connection
| 2007-01-08 09:22:19,875 DEBUG [org.hibernate.SQL] insert into jbp_cms_wsp_binval
(BINVAL_ID, BINVAL_DATA, PK) values (?, ?, ?)
| 2007-01-08 09:22:19,875 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close
PreparedStatement (open PreparedStatements: 1, globally: 1)
| 2007-01-08 09:22:19,875 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping
aggressive-release due to flush cycle
| 2007-01-08 09:22:19,890 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not
insert: [org.jboss.portal.cms.hibernate.state.WSPBinVal] [insert into jbp_cms_wsp_binval
(BINVAL_ID, BINVAL_DATA, PK) values (?, ?, ?)]
| org.postgresql.util.PSQLException: Unexpected error writing large object to database.
| Exception: java.io.IOException: Read error
| Stack Trace:
| java.io.IOException: Read error
| at java.io.FileInputStream.readBytes(Native Method)
| at java.io.FileInputStream.read(FileInputStream.java:194)
| at
org.postgresql.jdbc2.AbstractJdbc2Statement.setBlob(AbstractJdbc2Statement.java:2745)
| at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setBlob(WrappedPreparedStatement.java:517)
| at org.hibernate.type.BlobType.set(BlobType.java:49)
| at org.hibernate.type.BlobType.nullSafeSet(BlobType.java:117)
| at
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1932)
| at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2178)
| at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
| at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
| at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
| at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
| at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at
org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager$DbBLOBStore.get(JBossCachePersistenceManager.java:1363)
| at org.apache.jackrabbit.core.state.util.Serializer.serialize(Serializer.java:219)
| at
org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.store(JBossCachePersistenceManager.java:786)
| at
org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.storeHB(JBossCachePersistenceManager.java:1252)
| at
org.jboss.portal.cms.hibernate.state.JBossCachePersistenceManager.store(JBossCachePersistenceManager.java:1207)
| at
org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:569)
| at
org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:170)
| at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:172)
| at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:315)
| at org.jboss.portal.cms.impl.jcr.JCRCMS.execute(JCRCMS.java:448)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3998797#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...