Skip to Main Content
Forums

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EnvironmentFailureException

- MyX -May 18 2014 — edited May 20 2014

Hello!

I've upgraded my systems to use 6.0.11 instead of 5.0.97. Everything works fine, storage is 20+ percent more compact and so on, BUT.

1) Under load (all the time) on production server, after every 25-40 minutes uptime the

    > (JE 6.0.11) Environment must be closed, caused by: com.sleepycat.je.EnvironmentFailureException: Environment invalid because of previous exception: (JE 6.0.11) /usr/local/ae3/private/data/bdbj-lcl java.lang.AssertionError UNCAUGHT_EXCEPTION: Uncaught Exception in internal thread, unable to continue. Environment is invalid and must be closed.

    > com.sleepycat.je.EnvironmentFailureException

        > Environment invalid because of previous exception: (JE 6.0.11) /usr/local/ae3/private/data/bdbj-lcl java.lang.AssertionError UNCAUGHT_EXCEPTION: Uncaught Exception in internal thread, unable to continue. Environment is invalid and must be closed.

        > com.sleepycat.je.EnvironmentFailureException

            > null

            > java.lang.AssertionError

              : com.sleepycat.je.evictor.LRUEvictor.processTarget(LRUEvictor.java:2014)

              : com.sleepycat.je.evictor.LRUEvictor.findParentAndRetry(LRUEvictor.java:2182)

              : com.sleepycat.je.evictor.LRUEvictor.processTarget(LRUEvictor.java:2019)

              : com.sleepycat.je.evictor.LRUEvictor.evictBatch(LRUEvictor.java:1689)

              : com.sleepycat.je.evictor.LRUEvictor.doEvict(LRUEvictor.java:1538)

              : com.sleepycat.je.evictor.Evictor$BackgroundEvictTask.run(Evictor.java:739)

              : java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

              : java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

              : java.lang.Thread.run(Thread.java:724)

error appears and floods everything, I have to restart the instance and then it works another 30 minutes approx.

Same thing was happening on non heavy loaded (all) servers during log file upgrade to new format, timing was random tough. None of the environments that are bigger than 1G size were upgraded 'in one go' - I had to restart several times because of the same error.

2) I had to reduce the number of cleaner threads to 1 (config.setConfigParam( EnvironmentConfig.CLEANER_THREADS, "1" )) - otherwise it was not starting AT ALL, on every database instance it was failing on with words like "expect BEING_CLEANED but CLEANED"

I am using low-level BDB JE API with cursors and byte arrays. No secondary databases. No DPL. Does anyone experiencing anything like that?

Comments

The biggest change from 3.2 to 4.0 is the jdbc driver got upgrade to 11.2.0.3 from like 11.2.0.1.

Your SQL Dev 3.2.2 on XP with 11.2.x.x Full client - what are the last 2 digits - they can be important.

Also, I don't want your rollout to be delayed, I would advise opening an SR with MOS for better response time/help here.

Ok, because I was curious, and because I hadn't set this up before in 12c Multitenant...

SQL Developer 4.0.1

11.2.0.4 Instant Client

Windows 7

Oracle Enterprise Linux, 12c PDB

ops$jdsmith - connects as an os authenticated account, just fine

So it's working, for me at least.

SamBach

Thanks for the reply Jeff, sorry for not getting back to you earlier, weekend starts a bit earlier for us.

The client version was 11.2.0.3. in at least one of the cases where it was not working (invalid username/password).

I'm concerned there is something in my companies SOE that is causing this issue. I'm also confused as to why this problem seems to only affect my organization...

Is there a way for us to debug/diagnose this? Perhaps some low level tracing?

I'm happy to discuss this here unless you think an SR is required.

thatJeffSmith-Oracle

For the machine where 'it works on some machines' - have you also tried it with SQL*Plus?

That is, can you connect using OS Authentication from SQL*Plus on all of these machines and it's just SQL Developer that is surfacing the issue?

Also, we don't need an Oracle client to do the OS Authenticated connections, try connecting w/o turning on the OCI/Thick setting in the Advanced preferences dialog.

SamBach 
Jeff Smith SQLDev PM wrote:




1.For the machine where 'it works on some machines' - have you also tried it with SQL*Plus?




That is, can you connect using OS Authentication from SQL*Plus on all of these machines and it's just SQL Developer that is surfacing the issue?




2. Also, we don't need an Oracle client to do the OS Authenticated connections, try connecting w/o turning on the OCI/Thick setting in the Advanced preferences dialog.

1. Yes. Always checked with SQL*Plus

2. I did not know that. Here are the results without using the Oracle client (i.e. OCI/Thick not ticked) on my machine (x86, Windows XP):

SQL Developer 3.2.20.09 - Works with OS Auth connections

SQL Developer 4.0.1.14 - Does not work with OS Auth: Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied

I'm very surprised that even 3.2.2 worked without using the Oracle client as this has not been the case for us in the past. Is there a way for us to see what "connect command" is being sent by SQL Developer. I'm thinking we can perhaps compare the non-working versions to the working versions?

Regards

SamBach

I'd be curious to know if anyone else is experiencing this issue. From my search on the web it doesn't seem to be a widespread problem.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 17 2014
Added on May 18 2014
#berkeley-db-java-edition, #exception
12 comments
4,540 views