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, [EMAIL PROTECTED],
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#3998797
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3998797
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
