Hi Mike,
Also, activating debug-level logs for the DIH component could give you more
details.
Thank you,
Patryk
On Wed, Feb 5, 2025 at 09:09 Mikhail Khludnev <m...@apache.org> wrote:
> 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
>
