Hi Sean,
indeed, I am using InnoDB. FYI I removed the dialectClass attribute from
the compass.cfg.xml, that might be the reason ...
Sean Radford wrote:
Hmm... Still not working for me :-(
My prior 'No operations allowed after statement closed' exception has
gone, but been replaces by a host of:
org.jboss.tm.JBossRollbackException: Unable to commit,
tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=tibia/607,
BranchQual=, localId=607] status=STATUS_NO_TRANSACTION; - nested throwabl
e: (org.compass.core.engine.SearchEngineException: Failed in first phase
commit from sub-index [nxdocs]; nested exception is
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execu
te sql [insert into index_nxdocs (name_, value_, size_, lf_, deleted_)
values ( ?, ?, ?, current_timestamp, ? )]; nested exception is
java.sql.SQLException: Duplicate entry '_0.fnm' for key
1)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:372)
at org.jboss.tm.TxManager.commit(TxManager.java:240)
at
org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
at
org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:902)
at
org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)
at org.jboss.mq.SpySession.run(SpySession.java:323)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.compass.core.engine.SearchEngineException: Failed in
first phase commit from sub-index [nxdocs]; nested exception is
org.apache.lucene.store.jdbc.JdbcStoreException: Failed t
o execute sql [insert into index_nxdocs (name_, value_, size_, lf_,
deleted_) values ( ?, ?, ?, current_timestamp, ? )]; nested exception is
java.sql.SQLException: Duplicate entry '_0.fnm'
for key 1
at
org.compass.core.lucene.engine.transaction.ReadCommittedTransaction$TransIndexManager.firstPhase(ReadCommittedTransaction.java:158)
at
org.compass.core.lucene.engine.transaction.ReadCommittedTransaction.doPrepare(ReadCommittedTransaction.java:261)
at
org.compass.core.lucene.engine.transaction.ReadCommittedTransaction.doCommit(ReadCommittedTransaction.java:267)
at
org.compass.core.lucene.engine.transaction.AbstractTransaction.commit(AbstractTransaction.java:85)
at
org.compass.core.lucene.engine.LuceneSearchEngine.commit(LuceneSearchEngine.java:244)
at
org.compass.core.transaction.JTASyncTransaction$JTATransactionSynchronization.beforeCompletion(JTASyncTransaction.java:78)
at
org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1491)
at
org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1110)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:324)
... 8 more
Caused by: org.apache.lucene.store.jdbc.JdbcStoreException: Failed to
execute sql [insert into index_nxdocs (name_, value_, size_, lf_,
deleted_) values ( ?, ?, ?, current_timestamp, ? )];
nested exception is java.sql.SQLException: Duplicate entry '_0.fnm' for
key 1
at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:163)
at
org.apache.lucene.store.jdbc.index.AbstractJdbcIndexOutput.close(AbstractJdbcIndexOutput.java:47)
at org.apache.lucene.index.FieldInfos.write(FieldInfos.java:259)
at
org.apache.lucene.index.SegmentMerger.mergeFields(SegmentMerger.java:176)
at
org.apache.lucene.index.SegmentMerger.merge(SegmentMerger.java:88)
at
org.apache.lucene.index.TransIndex.firstPhase(TransIndex.java:317)
at
org.compass.core.lucene.engine.transaction.ReadCommittedTransaction$TransIndexManager.firstPhase(ReadCommittedTransaction.java:156)
... 16 more
Caused by: java.sql.SQLException: Duplicate entry '_0.fnm' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:159)
... 22 more
Vincent, are you using MySQL InnoDBs ? and consequently the
org.apache.lucene.store.jdbc.dialect.MySQLInnoDBDialect in compass.cfg?
Sean
It works great now, thanks a lot !!!
Florent Guillaume wrote:
The solution is to use in your datasource a connection url like:
<connection-url>
jdbc:mysql://localhost/yourdatabase?emulateLocators=true
</connection-url>
The emulateLocators=true parameter is important. This has been tested
with MySQL driver mysql-connector-java-3.1.13.jar.
For reference, see
http://static.compassframework.org/docs/latest/jdbcdirectory.html
and
http://jira.compassframework.org/browse/CMP-335
We'll add this to the docs (or as commented values in the
configuration for starters).
Florent
On 5 Jun 2007, at 09:53, Vincent Dutat wrote:
Hi,
I am in the exact same situation, with the same exceptions, I even
changed/removed the dialectClass attribute in
nuxeo.ear/platform/nuxeo-platform-search-compass-plugin-5.1-SNAPSHOT.jar/compass.cfg.xml
but it did not solve the problem. (FYI I posted a message yesterday).
Regards.
Sean Radford wrote:
Hi,
Has anyone got Nuxeo to fully use MySQL?
I have got the head to successfully use MySQL for the main
repository, but have problems with the other services. For these I
have:
1. configured my MySQL server for default engine of InnoDB
2. created the database with correct user access.
3. amended the datasources/***.xml files
4. amended config/comment-relations-bundle.xml to databaseType
MySQL (also tried MYSQL
5. amended config/nxrelations-default-jena-bundle.xml to
databaseType MySQL (also tried MYSQL
All seems to go ok on boot-up but when I try to create a document I
get set of stacktrace in the log. Afraid I haven't fully had time
yet to investigate yet, but:
1. I have no tables in: NXRELATIONS_DEFAULT_JENA or NXSEARCH_COMPASS
2. On going to the 'New Workspace' form I get:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No
operations allowed after connection closed.
3. On saving my 'new workspace' I get:
Failed to create dir [index_nxdocs]; nested exception is
org.apache.lucene.store.jdbc.JdbcStoreException:
Failed to execute [create table index_nxdocs (name_ varchar(50) ,
value_ longvarbinary , size_ integer , lf_ timestamp , deleted_
bit, primary key (name_) ) ];
The workspace saves, but I'm guessing is not being indexed.
Any ideas? (sorry if there is an obvious problem, and I'm a little
premature in my posting)
Thanks and regards,
Sean
---
Dr. Sean Radford, MBBS, MSc
http://www.tacola.com
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
