solr导入mysql时间类型_docker 安装solr 导入mysql时报错

出于对分词兴趣，研究下solr,遇到以下这个问题：

Dockerfile

FROM solr:7.5.0

WORKDIR /opt/solr/server/solr

RUN mkdir test \

&& cp /opt/solr/dist/solr-dataimporthandler-7.5.0.jar /opt/solr/server/solr-webapp/webapp/WEB-INF/lib \

&& cp /opt/solr/dist/solr-dataimporthandler-extras-7.5.0.jar /opt/solr/server/solr-webapp/webapp/WEB-INF/lib

COPY mysql-connector-java-8.0.14.jar /opt/solr/server/solr-webapp/webapp/WEB-INF/lib

WORKDIR /opt/solr/server/solr/test

RUN echo 'name=test' > core.properties

RUN mkdir data

RUN cp -r ../configsets/_default/conf/ .

WORKDIR /opt/solr/server/solr/test/conf

ADD db-data-config.xml .

ADD solrconfig.xml .

ADD managed-schema .

EXPOSE 8983

solrconfig.xml

db-data-config.xml

managed-schema

db-data-config.xml

type="JdbcDataSource"

name="source1"

driver="com.mysql.jdbc.Driver"

url="jdbc:mysql://127.0.0.1:3306/test"

user="root"

password="mi"

batchSize="-1" />

name="test"

dataSource="source1"

query="select * from test"

>

数据库在宿主机上

看错误是没连接上mysql，想问下哪部出错呢。

点击全部导入报错

Exception while processing: test document : SolrInputDocument(fields: []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select * from test Processing Document # 1

at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:69)

at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:327)

at org.apache.solr.handler.dataimport.JdbcDataSource.createResultSetIterator(JdbcDataSource.java:288)

at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:283)

at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:52)

at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)

at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)

at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:267)

at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476)

at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)

at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330)

at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:233)

at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:424)

at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)

at org.apache.solr.handler.dataimport.DataImporter.lambda$runAsync$0(DataImporter.java:466)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure