Hello Mike.
If it hangs you may see it in Thread Dump in Solr Admin or via jstack etc.
Probably it may give a clue what's going on there.
On Wed, Feb 5, 2025 at 3:02 AM Mike Phillips <m.phill...@prosperodigital.com>
wrote:
> I have solr 9.8.0 running the data import handler in standalone mode.
> All the documented steps fail in zoo keeper mode (bummer).
>
> I can import data from MySQL and Postgres but when I try oracle it
> fails. The output in the solr log looks like it is going to connect and
> then it just does nothing.
>
> Here is the log output when doing a Full Import in 8.4.1
>
> 2025-02-04 13:39:13.301 INFO (qtp599782425-69) [ x:rat_11]
> o.a.s.h.d.DataImporter Loading DIH Configuration: data-config.xml
> 2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
> o.a.s.h.d.c.DIHConfiguration The field :clientName present in DataConfig
> does not have a counterpart in Solr Schema
> 2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
> o.a.s.h.d.DataImporter Data Configuration loaded successfully
> 2025-02-04 13:39:13.360 INFO (Thread-24) [ ] o.a.s.h.d.DataImporter
> Starting Full Import
> 2025-02-04 13:39:13.360 INFO (qtp599782425-69) [ x:rat_11]
> o.a.s.c.S.Request [rat_11] webapp=/solr path=/DmeImport
> params={commit=true&clean=true&wt=xml&command=full-import} status=0
> QTime=65
> 2025-02-04 13:39:13.389 WARN (Thread-24) [ ]
> o.a.s.h.d.SimplePropertiesWriter Unable to read: DmeImport.properties
> 2025-02-04 13:39:13.637 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
> Creating a connection for entity asset_core with URL:
> jdbc:oracle:thin:@rat:52689:dme1
> 2025-02-04 13:39:14.183 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
> Time taken for getConnection(): 545
> 2025-02-04 13:39:14.331 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
> Creating a connection for entity asset_dmeaccount with URL:
> jdbc:oracle:thin:@rat:52689:dme1
> ...
> After here the rest of my tables connect and import
>
>
> Here is the log output for solr 9.8.0
>
> 2025-02-04 15:04:57.366 INFO (qtp142099757-26-null-12) [c: s: r:
> x:rat_11 t:null-12] o.a.s.h.d.DataImporter Loading DIH Configuration:
> data-config.xml
> 2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
> x:rat_11 t:null-12] o.a.s.h.d.c.DIHConfiguration The field :clientName
> present in DataConfig does not have a counterpart in Solr Schema
> 2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
> x:rat_11 t:null-12] o.a.s.h.d.DataImporter Data Configuration loaded
> successfully
> 2025-02-04 15:04:57.451 INFO (qtp142099757-26-null-12) [c: s: r:
> x:rat_11 t:null-12] o.a.s.c.S.Request webapp=/solr path=/DmeImport
> params={commit=true&clean=true&wt=xml&command=full-import} status=0
> QTime=86
> 2025-02-04 15:04:57.451 INFO (Thread-23) [c: s: r: x: t:]
> o.a.s.h.d.DataImporter Starting Full Import
> 2025-02-04 15:04:57.475 INFO (Thread-23) [c: s: r: x: t:]
> o.a.s.h.d.SimplePropertiesWriter Read DmeImport.properties
> 2025-02-04 15:04:57.623 INFO (Thread-23) [c: s: r: x: t:]
> o.a.s.h.d.JdbcDataSource Creating a connection for entity asset_core
> with URL: jdbc:oracle:thin:@rat:52689:dme1
> 2025-02-04 15:04:57.838 INFO (Thread-23) [c: s: r: x: t:]
> o.a.s.u.p.LogUpdateProcessorFactory webapp=/solr path=/DmeImport
> params={commit=true&clean=true&wt=xml&command=full-import} status=0
> QTime=86{deleteByQuery=*:* (-1823169888949108736)} 0 474
>
> It just stops here.
>
> I used a lib directory parallel with the conf directory and I put:
>
> data-import-handler-9.7.0.jar
> ojdbc6.jar
>
> Anybody got any suggestions?
>
--
Sincerely yours
Mikhail Khludnev
