It seems compass is using a caching mechanism for blobs and that cache is not always consistent with data in database. Select queries are done inside a transaction and when transactions are commited some blobs remain invalid.
Can someone point me where to find compass configuration files? Thank you On Friday 22 May 2009 16:28:32 Mihai Durbaca wrote: > Hello, > > After doing the same NXQL search several times in search form I get the > following error in Jboss console: > > ERROR [SearchPageProvider] Catched a SearchException > org.nuxeo.ecm.core.search.api.client.SearchException: > org.nuxeo.ecm.core.api.WrappedException: Exception: > org.nuxeo.ecm.core.search.api.client.SearchException. message: Failed to > search with query [...]; nested exception is > org.apache.lucene.store.jdbc.JdbcStoreException: Failed to read > transactional blob [_12yi.cfs]; nested exception is > org.postgresql.util.PSQLException: ERROR: invalid large-object descriptor: > 3306 > > I tried re-indexing the entire repository but that didn't fixed the problem > so I'm thinking this has to be a configuration problem. As far as I now > Nuxeo sets autocommit false on database transactions and blobs are stored > as bytea. > > The project is based on Nuxeo 5.1.6 with jcr and compass stored in > PostgresSQL 8.2. Compass is using JTA transactions. > > Any help would be appreciated. -- Mihai-Alexandru DURBACA _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
