账号密码登录
微信安全登录
微信扫描二维码登录

登录后绑定QQ、微信即可实现信息互通

手机验证码登录
找回密码返回
邮箱找回 手机找回
注册账号返回
其他登录方式
分享
  • 收藏
    X
    docker 安装solr 导入mysql时报错
    35
    0

    出于对分词兴趣,研究下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

     <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
        <lst name="defaults">
          <str name="config">db-data-config.xml</str>
        </lst>
      </requestHandler>

    managed-schema

      <field name="_version_" type="plong" indexed="false" stored="false"/>
      <field name="_root_" type="string" indexed="true" stored="false" docValues="false" />
      <field name="_text_" type="text_general" indexed="true" stored="false" multiValued="true"/>
     <field name="id"  type="string" indexed="true" stored="true" required="true" multiValued="false" />
      <field name="str"  type="string" indexed="true" stored="false" />
      <field name="str1"  type="string" indexed="true" stored="false" />

    db-data-config.xml

    <?xml version="1.0" encoding="UTF-8"?>
    <dataConfig>
        <dataSource 
         type="JdbcDataSource"
         name="source1"
         driver="com.mysql.jdbc.Driver"
         url="jdbc:mysql://127.0.0.1:3306/test" 
         user="root"
         password="mi" 
         batchSize="-1" />
        <document>
            <entity 
            name="test" 
            dataSource="source1" 
            query="select * from test"
            >
              <field column="id" name="id" />
              <field column="str" name="str" />
              <field column="str1" name="str1" />
            </entity>
        </document>
    </dataConfig>

    数据库在宿主机上
    看错误是没连接上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.<init>(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
    0
    打赏
    收藏
    点击回答
    您的回答被采纳后将获得:提问者悬赏的 11 元积分
        全部回答
    • 共 0 条
    • 异类辉煌 普通会员 1楼
      502 Bad Gateway

      502 Bad Gateway


      nginx
    更多回答
    扫一扫访问手机版
    • 回到顶部
    • 回到顶部