Hi,

I am new to Solr dataimport and am trying to do a full-import from
Postgres.  Both Solr 8.11.2 and Postgres 12 are installed in Win10.

Postgres is connecting using id solrpull and login is fine via Pgadmin.
Solr web and core are running.

I don't see any document imported and I don't find any error.  How to fix
this?

Raw Status-Output

{
  "responseHeader": {
    "status": 0,
    "QTime": 0
  },
  "initArgs": [
    "defaults",
    [
      "config",
      "db_configs.xml"
    ]
  ],
  "command": "status",
  "status": "idle",
  "importResponse": "",
  "statusMessages": {
    "Time Elapsed": "0:3:21.15",
    "Total Requests made to DataSource": "1",
    "Total Rows Fetched": "0",
    "Total Documents Processed": "0",
    "Total Documents Skipped": "0",
    "Full Dump Started": "2023-11-27 06:38:15",
    "Full Import failed": "2023-11-27 06:38:35"
  }
}

Configuration

<dataConfig>
  <dataSource type="JdbcDataSource"
              driver="org.postgresql.Driver"
              url="jdbc:postgresql://localhost/world"
              user="solrpull"
              password="NotTelling"/>
  <document>
    <entity name="city"
            query="select id,name from city">
     <field column="id" name="id"/>
     <field column="name" name="name_str"/>
    </entity>
  </document></dataConfig>

log4j2
11/27/2023, 2:13:00 AM WARN false CoreContainer Not all security plugins
configured! authentication=disabled authorization=disabled. Solr is only as
secure as you make it. Consider configuring authentication/authorization
before exposing Solr to users internal or external. See
https://s.apache.org/solrsecurity for more info
11/27/2023, 2:13:00 AM WARN false x:cookbookCSV SolrConfig solrconfig.xml:
<jmx> is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:00 AM WARN false x:cookbookCSV WordDelimiterFilterFactory Solr
loaded a deprecated plugin/analysis class
[solr.WordDelimiterFilterFactory]. Please consult documentation how to
replace it accordingly.
11/27/2023, 2:13:00 AM WARN false x:d
11/27/2023, 2:13:00 AM WARN false x:mail SolrConfig solrconfig.xml: <jmx>
is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:00 AM WARN false x:db LatLonType Solr loaded a deprecated
plugin/analysis class [solr.LatLonType]. Please consult documentation how
to replace it accordingly.
11/27/2023, 2:13:01 AM WARN false x:atom DataImportHandler Data Import
Handler is deprecated as of Solr 8.6. See SOLR-14066 for more details.
11/27/2023, 2:13:01 AM WARN false x:mail DataImportHandler Data Import
Handler is deprecated as of Solr 8.6. See SOLR-14066 for more details.
11/27/2023, 2:13:01 AM WARN false x:db DataImportHandler Data Import
Handler is deprecated as of Solr 8.6. See SOLR-14066 for more details.
11/27/2023, 2:13:01 AM WARN false x:solr SolrConfig solrconfig.xml: <jmx>
is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:01 AM WARN false x:p SolrConfig solrconfig.xml: <jmx> is
no longer supported,&#8203; use solr.xml:/metrics/reporter section instead
11/27/2023, 2:13:01 AM WARN false x:solr DataImportHandler Data Import
Handler is deprecated as of Solr 8.6. See SOLR-14066 for more details.
11/27/2023, 2:13:02 AM WARN false x:tika DataImportHandler Data Import
Handler is deprecated as of Solr 8.6. See SOLR-14066 for more details.
11/27/2023, 2:13:02 AM WARN false x:sample_core SolrConfig solrconfig.xml:
<jmx> is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:02 AM WARN false x:f18maf SolrConfig solrconfig.xml: <jmx>
is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:02 AM WARN false x:demo SolrConfig solrconfig.xml: <jmx>
is no longer supported,&#8203; use solr.xml:/metrics/reporter section
instead
11/27/2023, 2:13:02 AM WARN false x:p DataImportHandler Data Imp My
database has data


select id,name from city
"id" "name"
1 "Seattle"
2 "Japan"
Successfully run. Total query runtime: 37 msec.
2 rows affected.

Reply via email to