Unable to browse to "http://localhost/admin" after completion of dotcms installation. I find the error "ERROR reindex.ReindexThread: No ContentIndex" in the dotcms log

184 views
Skip to first unread message

George Taku

unread,
Nov 18, 2013, 5:20:25 PM11/18/13
to dot...@googlegroups.com

I completed installation of dotCMS and can browse "htpp://localhost".
Problem is, I am not able to browse to "http://localhost/admin" to login. I instead get a page with content like so:

--

500-title

500-body1

500-body2

© 2013, 500-copywright
--

I searched the dotCMS log for erros and find the error  "ERROR reindex.ReindexThread: No ContentIndex" in the log file.

Solution ideas are greatly appreciated.

George Taku

unread,
Nov 18, 2013, 5:35:02 PM11/18/13
to dot...@googlegroups.com
Here is more of the rest of log from the first appearance of error:

[18/11/13 16:25:29:710 CST] ERROR reindex.ReindexThread: No ContentIndexationThread available
[18/11/13 16:25:29:712 CST]  INFO startup.StartupTasksExecutor: Running: Task00765AddUserForeignKeys
[18/11/13 16:25:29:719 CST]  INFO db.DotConnect: Executing SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
[18/11/13 16:25:29:720 CST]  INFO db.DotConnect: Finished Executing SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
[18/11/13 16:25:29:720 CST]  INFO db.DotConnect: Executing update contentlet set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:747 CST]  INFO db.DotConnect: Finished Executing update contentlet set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:747 CST]  INFO db.DotConnect: Executing update htmlpage set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:749 CST]  INFO db.DotConnect: Finished Executing update htmlpage set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:749 CST]  INFO db.DotConnect: Executing update file_asset set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:749 CST]  INFO db.DotConnect: Finished Executing update file_asset set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:749 CST]  INFO db.DotConnect: Executing update containers set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:750 CST]  INFO db.DotConnect: Finished Executing update containers set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:750 CST]  INFO db.DotConnect: Executing update template set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:751 CST]  INFO db.DotConnect: Finished Executing update template set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:751 CST]  INFO db.DotConnect: Executing update links set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:752 CST]  INFO db.DotConnect: Finished Executing update links set mod_user = 'system' where not exists(select userid from user_ where userid = mod_user)
[18/11/13 16:25:29:752 CST]  INFO db.DotConnect: Executing drop index file_asset.idx_file_1
[18/11/13 16:25:29:753 CST] FATAL runonce.Task00765AddUserForeignKeys: Unable to execute SQL upgrade
java.sql.SQLException: Cannot drop the index 'file_asset.idx_file_1', because it does not exist or you do not have permission.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at com.dotmarketing.common.db.DotConnect.executeStatement(DotConnect.java:222)
    at com.dotmarketing.startup.AbstractJDBCStartupTask.executeUpgrade(AbstractJDBCStartupTask.java:192)
    at com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:273)
    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
    at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:857)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:722)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
    at com.dotmarketing.servlets.LoginEditModeServlet.service(LoginEditModeServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:404)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:121)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:61)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.TimeMachineFilter.doFilter(TimeMachineFilter.java:162)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotcms.enterprise.salesforce.SalesForceFilter.doFilter(SourceFile:227)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:146)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
[18/11/13 16:25:29:754 CST] FATAL startup.StartupTasksExecutor: Unable to execute the upgrade task : Task00765AddUserForeignKeys
com.dotmarketing.exception.DotDataException: Cannot drop the index 'file_asset.idx_file_1', because it does not exist or you do not have permission.
    at com.dotmarketing.startup.AbstractJDBCStartupTask.executeUpgrade(AbstractJDBCStartupTask.java:195)
    at com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:273)
    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
    at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:857)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:722)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
    at com.dotmarketing.servlets.LoginEditModeServlet.service(LoginEditModeServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:404)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:121)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:61)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.TimeMachineFilter.doFilter(TimeMachineFilter.java:162)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotcms.enterprise.salesforce.SalesForceFilter.doFilter(SourceFile:227)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:146)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: java.sql.SQLException: Cannot drop the index 'file_asset.idx_file_1', because it does not exist or you do not have permission.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at com.dotmarketing.common.db.DotConnect.executeStatement(DotConnect.java:222)
    at com.dotmarketing.startup.AbstractJDBCStartupTask.executeUpgrade(AbstractJDBCStartupTask.java:192)
    ... 48 more
[18/11/13 16:25:29:755 CST]  INFO startup.StartupTasksExecutor: Finishing upgrade tasks.

Jason Tesser

unread,
Nov 18, 2013, 5:51:59 PM11/18/13
to dot...@googlegroups.com
This looks like an upgrade or a failed install that you started over. When u start over u should start with a blank db 
--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/groups/opt_out.
Message has been deleted

Jorge Urdaneta

unread,
Nov 19, 2013, 8:36:57 AM11/19/13
to dot...@googlegroups.com
The upgrade is trying to execute

drop index file_asset.idx_file_1

But your db is missing that index. You can fake it creating an index over mod_user on file_asset. Then this sql shuld run without problems.

Make sure you follow our instructions at http://dotcms.com/docs/latest/UpgradingTo20

On Nov 18, 2013, at 5:14 PM, George Taku <takug...@gmail.com> wrote:

I believe that I have started over the installation at least three times with a new databases. I was not sure if deleting the database and creating a brown new one, giving the dotcms user ownership would have made a difference, so, I tried that as well.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+unsubscribe@googlegroups.com.

To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/groups/opt_out.

George Taku

unread,
Nov 19, 2013, 11:07:59 AM11/19/13
to dot...@googlegroups.com
Thank you, Jorge. I will try your recommendation and get back here once it's done to let you know how it went. I am now waiting on my windows update to proceed with reinstallation of SQQ Server.
Thank you.
Reply all
Reply to author
Forward
0 new messages