Mysql Connectivity issue

cancel
Showing results for 
Search instead for 
Did you mean: 
yuva
Active Member

Mysql Connectivity issue

Jump to solution

Hi

I have created a new alfresco all-in-one project with sdk 2.2, I tried to connect with mysql as a database. So, I changed the following things in alfresco-global.properties.

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
# db.driver=org.postgresql.Driver
db.username=root
db.password=root
db.name=alfresco
db.url=jdbc:mysql://localhost:5432/${db.name}  
#?useUnicode=yes&characterEncoding=UTF-8
# db.url=jdbcSmiley Tongueostgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=100
db.pool.validate.query=SELECT 1
db.port=3306

when I start my server, I got this below issues. Can anyone help me to connect my projecct with mysql.

Log :

INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug
logging for this logger for a complete list of JARs that were scanned but no TLD
s were found in them. Skipping unneeded JARs during scanning can improve startup
 time and JSP compilation time.
Nov 20, 2017 4:07:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\alfresco-community\tomcat\webap
ps\manager has finished in 155 ms
2017-11-20 16:07:45,912  INFO  [solr.component.AsyncBuildSuggestComponent] [Sugg
estor-alfresco-1] Loaded suggester shingleBasedSuggestions, took 852 ms
 Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8443"]
Nov 20, 2017 4:07:45 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 23040 ms
2017-11-20 16:08:01,276  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-1] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200000 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJ
ob.java:145)
        at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:
82)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:08:01,356  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-2] Tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:
78)
        at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106
)
        at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.
java:1116)
        at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:174)

        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:12,416  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-1] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200001 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJ
ob.java:145)
        at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:
82)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,248  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-11] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200003 api/solr/aclchangesets re
turn status:404
        at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient
.java:169)
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(Acl
Tracker.java:354)
        at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:
320)
        at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:111)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,258  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-13] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200004 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModel
sComponent.java:87)
        at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequest
Body(AlfrescoSearchHandler.java:292)
        at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:135)
        at org.alfresco.solr.Cloud.getResponse(Cloud.java:165)
        at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:149)
        at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(Sol
rInformationServer.java:722)
        at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:
81)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,637  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-12] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200002 api/solr/aclchangesets re
turn status:404
        at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient
.java:169)
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(Acl
Tracker.java:354)
        at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:
320)
        at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:111)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,680  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-10] Tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:
78)
        at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106
)
        at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.
java:1116)
        at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:174)

        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,690  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-14] Model tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:
78)
        at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106
)
        at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.
java:1116)
        at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModel
sComponent.java:87)
        at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequest
Body(AlfrescoSearchHandler.java:292)
        at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:135)
        at org.alfresco.solr.Cloud.getResponse(Cloud.java:165)
        at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:149)
        at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(Sol
rInformationServer.java:722)
        at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:
81)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:
190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)

1 Solution

Accepted Solutions
kalpesh_c2
Senior Member

Re: Mysql Connectivity issue

Jump to solution

Hi, Yuvaraj D
Your database name should be same as given in alfresco-global.properties file. 

If you have not created database then create it.

And you need to add mysql connector jar also in your project library.

Change your database port in alfresco-global.properties file i.e. db.port=3306

Thanks,

Kalpesh,

ContCentric

View solution in original post

5 Replies
kranthi
Active Member II

Re: Mysql Connectivity issue

Jump to solution

Change db.port=3306 to as you mentioned port number.5432

as you  mentioned in db.url

yuva
Active Member

Re: Mysql Connectivity issue

Jump to solution

after the changing the port number it shows hibernate dialect error.I will attach the log.

yuva
Active Member

Re: Mysql Connectivity issue

Jump to solution

when i run the project in eclipse i got this error, I try to run my tomcat server directly it is very slow and not able run for a while, so i run it in eclipse itself.

Nov 20, 2017 5:44:35 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
2017-11-20 17:44:35,752 INFO [solr.component.AsyncBuildSuggestComponent] [Suggestor-alfresco-1] Loaded suggester shingleBasedSuggestions, took 41 ms
2017-11-20 17:44:41,107 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-1] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200000 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJob.java:131)
at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:74)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:41,158 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-1] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200001 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJob.java:131)
at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:74)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:45,088 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-5] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200005 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModelsComponent.java:80)
at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:283)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
at org.alfresco.solr.Cloud.getResponse(Cloud.java:159)
at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:143)
at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(SolrInformationServer.java:715)
at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:74)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:45,108 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-4] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200004 api/solr/aclchangesets return status:404
at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:162)
at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:335)
at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:313)
at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:104)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:45,108 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-6] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200006 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModelsComponent.java:80)
at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:283)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
at org.alfresco.solr.Cloud.getResponse(Cloud.java:159)
at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:143)
at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(SolrInformationServer.java:715)
at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:74)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:45,440 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200002 api/solr/aclchangesets return status:404
at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:162)
at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:335)
at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:313)
at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:104)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:44:45,452 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-2] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200003 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:167)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:45:00,038 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-9] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200007 api/solr/aclchangesets return status:404
at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:162)
at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:335)
at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:313)
at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:104)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:45:00,063 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-12] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200009 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModelsComponent.java:80)
at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:283)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
at org.alfresco.solr.Cloud.getResponse(Cloud.java:159)
at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:143)
at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(SolrInformationServer.java:715)
at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:74)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:45:00,081 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-10] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200008 api/solr/aclchangesets return status:404
at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:162)
at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:335)
at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:313)
at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:104)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:45:00,091 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-16] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200010 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:167)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2017-11-20 17:45:00,111 ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-11] Model tracking failed
org.alfresco.error.AlfrescoRuntimeException: 10200011 GetModelsDiff return status is 404
at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1157)
at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:249)
at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:207)
at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:229)
at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModelsComponent.java:80)
at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:283)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
at org.alfresco.solr.Cloud.getResponse(Cloud.java:159)
at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:143)
at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(SolrInformationServer.java:715)
at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:74)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:185)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

kalpesh_c2
Senior Member

Re: Mysql Connectivity issue

Jump to solution

Hi, Yuvaraj D
Your database name should be same as given in alfresco-global.properties file. 

If you have not created database then create it.

And you need to add mysql connector jar also in your project library.

Change your database port in alfresco-global.properties file i.e. db.port=3306

Thanks,

Kalpesh,

ContCentric

yuva
Active Member

Re: Mysql Connectivity issue

Jump to solution

Thank you Kalpesh Patel 

Its working now. Problem with port no,I used a same port number which i used previously to connect with postgres.