Hi everybody, Everything was working fine until I stopped tomcat service to activate snapshooter in solrconfig.xml. Yesterday before this modification cronjob was firing delta-import every 5mn, imports was during between 5-10mn, everything was ok. But now I've updated to create snapshooter, I tried last evening before leaving and this morning time elapsed was very important like you can notice above and no snapshot, no error in the logs.
<lst name="statusMessages"> <str name="Time Elapsed">16:34:43.247</str> <str name="Total Requests made to DataSource">421</str> <str name="Total Rows Fetched">77829</str> <str name="Total Documents Processed">59</str> <str name="Total Documents Skipped">0</str> <str name="Delta Dump started">2008-10-14 16:20:01</str> <str name="Identifying Delta">2008-10-14 16:20:01</str> <str name="Deltas Obtained">2008-10-14 16:21:01</str> <str name="Building documents">2008-10-14 16:21:01</str> <str name="Total Changed Documents">77555</str> </lst> This morning I tried to stop services and start them again, and still the same problem, it's like it start the autoCommit but nothing running properly afterwards. My conf: Java version : 1.6.0 My servlet container is : tomcat5.5 Solr version :1.3 (apache-solr-1.4-dev.war) My database : MySql I'm taking sor by PHP, but for the moment I don't use it. My files: http://www.nabble.com/file/p19988268/data-config.xml data-config.xml http://www.nabble.com/file/p19988268/schema.xml schema.xml http://www.nabble.com/file/p19988268/solrconfig.xml solrconfig.xml My logs: Oct 15 09:05:08 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:08 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:05:09 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:09 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:05:21 solr-test jsvc.exec[22694]: 70.260: [GC Oct 15 09:05:22 solr-test jsvc.exec[22694]: [PSYoungGen: 384000K->63984K(448000K)] 384180K->142306K(3008000K) Oct 15 09:05:22 solr-test jsvc.exec[22694]: , 0.2392820 secs] [Times: user=0.71 sys=0.16, real=0.24 secs] Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.DocBuilder collectDelta INFO: Completed ModifiedRowKey for Entity: video rows obtained : 373334 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.DocBuilder collectDelta INFO: Running DeletedRowKey() for Entity: video Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.DocBuilder collectDelta INFO: Completed DeletedRowKey for Entity: video rows obtained : 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.DocBuilder collectDelta INFO: Completed parentDeltaQuery for Entity: video Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity video with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_group_ids with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_playlist_ids with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 50 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_fan_ids with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_featured_home_country with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_featured_user_ids with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Creating a connection for entity rel_featured_group_ids with URL: jdbc:mysql://master-spare.vip.videos.com/videos Oct 15 09:05:59 solr-test jsvc.exec[22694]: Oct 15, 2008 9:05:59 AM org.apache.solr.handler.dataimport.JdbcDataSource$1 call INFO: Time taken for getConnection(): 0 Oct 15 09:06:00 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:00 AM org.apache.solr.update.DirectUpdateHandler2 commit INFO: start commit(optimize=false,waitFlush=true,waitSearcher=true) Oct 15 09:06:12 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:12 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:15 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:15 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:15 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:15 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:53 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:53 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:54 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:54 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:55 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:55 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:06:55 solr-test jsvc.exec[22694]: Oct 15, 2008 9:06:55 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:08:53 solr-test jsvc.exec[22694]: Oct 15, 2008 9:08:53 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:08:54 solr-test jsvc.exec[22694]: Oct 15, 2008 9:08:54 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:10:01 solr-test /USR/SBIN/CRON[22788]: (root) CMD (/root/memmon.sh >> /root/memmon.txt) Oct 15 09:10:01 solr-test /USR/SBIN/CRON[22792]: (root) CMD (/usr/bin/wget -q --output-document=/home/tot.txt http://solr-test.adm.videos.com:8180/solr/video/dataimport?command=delta-import&entity=b) Oct 15 09:10:01 solr-test jsvc.exec[22694]: Oct 15, 2008 9:10:01 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={command=delta-import} status=0 QTime=0 Oct 15 09:10:08 solr-test jsvc.exec[22694]: Oct 15, 2008 9:10:08 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:10:08 solr-test jsvc.exec[22694]: Oct 15, 2008 9:10:08 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:15:01 solr-test /USR/SBIN/CRON[22813]: (root) CMD ([ -x /usr/lib/sysstat/sa1 ] && { [ -r "$DEFAULT" ] && . "$DEFAULT" ; [ "$ENABLED" = "true" ] && exec /usr/lib/sysstat/sa1 $SA1_OPTIONS 1 1 ; }) Oct 15 09:15:01 solr-test /USR/SBIN/CRON[22815]: (root) CMD (/usr/bin/wget -q --output-document=/home/tot.txt http://solr-test.adm.videos.com:8180/solr/video/dataimport?command=delta-import&entity=b) Oct 15 09:15:01 solr-test jsvc.exec[22694]: Oct 15, 2008 9:15:01 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={command=delta-import} status=0 QTime=0 Oct 15 09:17:01 solr-test /USR/SBIN/CRON[22818]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Oct 15 09:17:02 solr-test ntpdate[22823]: adjust time server 195.8.215.137 offset -0.034049 sec Oct 15 09:17:05 solr-test jsvc.exec[22694]: Oct 15, 2008 9:17:05 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:17:05 solr-test jsvc.exec[22694]: Oct 15, 2008 9:17:05 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:17:06 solr-test jsvc.exec[22694]: Oct 15, 2008 9:17:06 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:17:07 solr-test jsvc.exec[22694]: Oct 15, 2008 9:17:06 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Oct 15 09:17:07 solr-test jsvc.exec[22694]: Oct 15, 2008 9:17:07 AM org.apache.solr.core.SolrCore execute INFO: [video] webapp=/solr path=/dataimport params={} status=0 QTime=0 Thanks for your time, -- View this message in context: http://www.nabble.com/solr-1.3-snapshooter-doesn%27t-work%2C-commit-never-ending-tp19988268p19988268.html Sent from the Solr - User mailing list archive at Nabble.com.
