You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-user@lucene.apache.org by "manish@mailinator.com" <ma...@mailinator.com> on 2009/10/09 10:21:41 UTC
Unable to use jdbc store
I am using lucene 2.9.0 ,Compass2.2.0. I have configured for jdbc store.In my
oracle db, there are 22000 users in User_ table . I am unable to index 22000
users.It stops at 13000 users. Problem is that table LUCENE_10109(my jdbc
index table) is getting populated with no of records. now I have 277215
records in LUCENE_10109. These records are not getting merged as they do
when store type is file. What i mean is that when store type is file,
merging is properly done & so final size of index on file system is 10 to 15
MB for 22000 users.This is not true with store type jdbc . Records are being
populated in LUCENE_10109 but no merging is done. So at some stage ( in my
case when 13000 users are indexed) there is no space in tablespace USERS
stopping indexing process giving following errors
Exception in thread "Thread-8"
org.apache.lucene.index.MergePolicy$MergeException:
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql
[insert into LUCENE_0 (name_, value_, size_, lf_, deleted_) values ( ?, ?,
?, current_timestamp, ? )]; nested exception is java.sql.SQLException:
ORA-01691: unable to extend lob segment SCOTT.SYS_LOB0000052243C00002$$ by
1024 in tablespace USERS
at
org.apache.lucene.index.ConcurrentMergeScheduler$MergeThread.run(ConcurrentMergeScheduler.java:271)
Caused by: org.apache.lucene.store.jdbc.JdbcStoreException: Failed to
execute sql [insert into LUCENE_0 (name_, value_, size_, lf_, deleted_)
values ( ?, ?, ?, current_timestamp, ? )]; nested exception is
java.sql.SQLException: ORA-01691: unable to extend lob segment
SCOTT.SYS_LOB0000052243C00002$$ by 1024 in tablespace USERS
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.store.jdbc.index.RAMAndFileJdbcIndexOutput.close(RAMAndFileJdbcIndexOutput.java:81)
at org.apache.lucene.index.FieldsWriter.close(FieldsWriter.java:76)
at
org.apache.lucene.index.SegmentMerger.mergeFields(SegmentMerger.java:330)
at org.apache.lucene.index.SegmentMerger.merge(SegmentMerger.java:133)
at org.apache.lucene.index.IndexWriter.mergeMiddle(IndexWriter.java:3273)
at org.apache.lucene.index.IndexWriter.merge(IndexWriter.java:2968)
at
org.apache.lucene.index.ConcurrentMergeScheduler$MergeThread.run(ConcurrentMergeScheduler.java:240)
Caused by: java.sql.SQLException: ORA-01691: unable to extend lob segment
SCOTT.SYS_LOB0000052243C00002$$ by 1024 in tablespace USERS
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:159)
... 8 more
09:32:27,600 INFO [[/tunnel-web]:649] Initializing Spring FrameworkServlet
'Spring Servlet'
Exception in thread "Thread-9"
org.apache.lucene.index.MergePolicy$MergeException:
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql
[insert into LUCENE_0 (name_, value_, size_, lf_, deleted_) values ( ?, ?,
?, current_timestamp, ? )]; nested exception is java.sql.SQLException:
ORA-01691: unable to extend lob segment SCOTT.SYS_LOB0000052243C00002$$ by
1024 in tablespace USERS
at
org.apache.lucene.index.ConcurrentMergeScheduler$MergeThread.run(ConcurrentMergeScheduler.java:271)
Caused by: org.apache.lucene.store.jdbc.JdbcStoreException: Failed to
execute sql [insert into LUCENE_0 (name_, value_, size_, lf_, deleted_)
values ( ?, ?, ?, current_timestamp, ? )]; nested exception is
java.sql.SQLException: ORA-01691: unable to extend lob segment
SCOTT.SYS_LOB0000052243C00002$$ by 1024 in tablespace USERS
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.store.jdbc.index.RAMAndFileJdbcIndexOutput.close(RAMAndFileJdbcIndexOutput.java:81)
at org.apache.lucene.index.FieldsWriter.close(FieldsWriter.java:76)
at
org.apache.lucene.index.SegmentMerger.mergeFields(SegmentMerger.java:330)
at org.apache.lucene.index.SegmentMerger.merge(SegmentMerger.java:133)
at org.apache.lucene.index.IndexWriter.mergeMiddle(IndexWriter.java:3273)
at org.apache.lucene.index.IndexWriter.merge(IndexWriter.java:2968)
at
org.apache.lucene.index.ConcurrentMergeScheduler$MergeThread.run(ConcurrentMergeScheduler.java:240)
Caused by: java.sql.SQLException: ORA-01691: unable to extend lob segment
SCOTT.SYS_LOB0000052243C00002$$ by 1024 in tablespace USERS
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:159)
... 8 more
I have set MergeFactor=10;
Thanks ..
Any help is highly appreciated
--
View this message in context: http://www.nabble.com/Unable-to-use-jdbc-store-tp25817293p25817293.html
Sent from the Lucene - Java Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org