Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting EnvironmentFailureException after deleting/recreating the env folder.

Neelkamal-OracleSep 19 2017

Hello,

I am running into below exception :

This environment's log file has no root. Since the root is the first entry written into a log at environment creation, this should only happen if the initial creation of the environment was never checkpointed or synced. Please move aside the existing log files to allow the creation of a new environment LOG_INTEGRITY: Log information is incorrect, problem is likely persistent. Environment is invalid and must be closed.

Below is my use case.

During initialization of my application  I am trying to validate bk db by creating an env folder and inserting a test entry in berkeley db.

In case if that fails I am closing the store and the env , deleting the env folder , recreating the folder and try inserting the test entry again.

Basically I am trying to validate twice before turning berkeley db off. I am running into this exception when trying to insert into bk db the second time.

I went through the thread : Environment is invalid and must be closed (after upgrading to 4.1.7)  but couldn't relate to my use case.

Thanks,

Neel

Comments

Arpad Kiss

I think you wanted DESC, not DEPT.
DESC tablename;

Pictures are worth many words, show us

image.png

user527460

Hi, @thatjeffsmith-oracle ,
Here is the picture from SQL Developer version 21.4.3.x,
Picklist is not showing with table alias 'a' as shown here.

image.png

That query to get the column list might take a half-second, be patient
Windows 10/21.4.3
image.png

user527460

hi @thatjeffsmith-oracle ,
No luck, i waited for a min but pick list not showing. I tried to change theme to dark as showing in your image, still no pick list pops up.

ask for it multiple times, if the query takes too long, we give up

Robert Kilmer

Try Ctrl-Space.

670554

Ctrl-Space is not working in Version 22.2.1.234

it brings up a different menu.

thatJeffSmith-Oracle

23.1.1 is latest and this is your example in 23.1.1

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

Post Details

Locked on Oct 17 2017
Added on Sep 19 2017
0 comments
247 views