FYI
---------- Forwarded message ---------
From: Mike Phillips <m.phill...@prosperodigital.com>
Date: Thu, Feb 6, 2025 at 9:06 PM
Subject: Re: oracle and DIH
To: <solr-u...@lucene.apache.org>
Hope this helps anybody with old jars and old versions.
Turns out this was due to old ojdbc6.jar.
I modified the DIH and added a catch for throwable. I discovered I was
getting:
Caused by: java.security.AccessControlException: access denied
("java.lang.RuntimePermission" "accessClassInPackage.sun.security.krb5")
at
java.base/java.security.AccessControlContext.checkPermission(AccessControlContext.java:472)
~[?:?]
at
java.base/java.security.AccessController.checkPermission(AccessController.java:897)
~[?:?]
at
java.base/java.lang.SecurityManager.checkPermission(SecurityManager.java:322)
~[?:?]
at
java.base/java.lang.SecurityManager.checkPackageAccess(SecurityManager.java:1238)
~[?:?]
at
java.base/java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:901)
~[?:?]
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
~[?:?]
at java.base/java.lang.Class.forName0(Native Method) ~[?:?]
at java.base/java.lang.Class.forName(Class.java:315) ~[?:?]
at oracle.net.ano.AuthenticationService.k(Unknown Source) ~[?:?]
at oracle.net.ano.AuthenticationService.<clinit>(Unknown Source) ~[?:?]
I upgraded to the highest Oracle jdbc that was compatible with our
database: ojdbc8-19.3.0.0.jar
and the access exception went away and the DIH completed successfully
On 2/6/2025 7:04 AM, Patryk Mazurkiewicz wrote:
> 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
>>
--
Sincerely yours
Mikhail Khludnev
