Hello Vince.
I think these numbers speak for themselves:
"Total Requests made to DataSource": "1",
> "Total Rows Fetched": "0",
> "Total Documents Processed": "0",
> "Total Documents Skipped": "0",
Does it point to the right schema? Have you committed SQL INSERT
transaction?
I remember there's a debug parameter in DIH, you may use it.
On Mon, Nov 27, 2023 at 10:33 AM Vince McMahon <
[email protected]> wrote:
> 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,​ 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,​ 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,​ 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,​ 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,​ 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,​ 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,​ 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.
>
--
Sincerely yours
Mikhail Khludnev
