Unable to open (Local DynamoDB) database file after power outage

Question

History: I was able to get read/write to my local DynamoDB environment. I followed the AWS Documents for Downloading and Running DynamoDB: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.html

Issue: I had an accidental power outage to my computer. Now, I get the following error after I launch the DynamoDB process

java -Djava.library.path=./DynamoDBLocal_lib -jar DynamoDBLocal.jar -sharedDb

Error Message:

Aug 23, 2017 3:52:42 PM com.almworks.sqlite4java.Internal log
WARNING: [sqlite] SQLiteQueue[shared-local-instance.db]: stopped abnormally, reincarnating in 3000ms
Aug 23, 2017 3:52:45 PM com.almworks.sqlite4java.Internal log
WARNING: [sqlite] cannot open DB[2]: com.almworks.sqlite4java.SQLiteException: [14] unable to open database file
Aug 23, 2017 3:52:45 PM com.almworks.sqlite4java.Internal log
SEVERE: [sqlite] SQLiteQueue[shared-local-instance.db]: error running job queue
com.almworks.sqlite4java.SQLiteException: [14] unable to open database file
    at com.almworks.sqlite4java.SQLiteConnection.open0(SQLiteConnection.java:1480)
    at com.almworks.sqlite4java.SQLiteConnection.open(SQLiteConnection.java:282)
    at com.almworks.sqlite4java.SQLiteConnection.open(SQLiteConnection.java:293)
    at com.almworks.sqlite4java.SQLiteQueue.openConnection(SQLiteQueue.java:464)
    at com.almworks.sqlite4java.SQLiteQueue.queueFunction(SQLiteQueue.java:641)
    at com.almworks.sqlite4java.SQLiteQueue.runQueue(SQLiteQueue.java:623)
    at com.almworks.sqlite4java.SQLiteQueue.access$000(SQLiteQueue.java:77)
    at com.almworks.sqlite4java.SQLiteQueue$1.run(SQLiteQueue.java:205)
    at java.lang.Thread.run(Thread.java:748)

Attempts: This post is the closest to my error but it involves not DynamoDB but some Cloud logs, etc: https://forums.aws.amazon.com/thread.jspa?threadID=165134

Any thoughts on how to rectify the database file?

You might try opening it with the `sqlite3` command line utility, to see if there are more useful errors. — Michael - sqlbot, Aug 24 '17 at 02:27
This error can also append on M1 Mac. If you're concerned, you can find a solution here: https://stackoverflow.com/questions/66635424/dynamodb-local-setup-on-m1-apple-silicon-mac — TimothePearce, Jun 10 '21 at 09:17

score 23 · Answer 1 · edited Dec 09 '22 at 04:27

23

It could be a permission issue. try updating permissions.

sudo chown $USER docker -R
chmod 775 -R docker

edited Dec 09 '22 at 04:27

Matt Gaunt

9,434
3
36
57

answered Nov 03 '18 at 14:42

Zudhin

266
2
5

For windows I have to run the process as local admin – Michael Mar 08 '21 at 15:06
What is the significance of the `dynamodb` string? What is your answer exactly doing? – koral Jul 28 '21 at 16:39
`dynamodb` was the directory - I've updated it to `docker` to match amazons guide. – Matt Gaunt Dec 09 '22 at 04:28

score 12 · Answer 2 · answered Aug 22 '21 at 17:19

12

It is indeed a permission issue as suggested by Zudhin https://stackoverflow.com/a/53132375/239613

In my case, I'm running Ubuntu and the quick and dirty solution I found is just changing the permissions of the local folder for the volume:

sudo chmod 777 ./docker/dynamodb (provided that's your local folder after following https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html)

answered Aug 22 '21 at 17:19

Gastón Fournier

956
1
9
25

Has anyone been able to get this working with podman / podman-compose? I'm getting the same error and this worked for docker, but it's not working for podman. – Matt Gaunt Dec 09 '22 at 03:43

score 4 · Answer 3 · edited Oct 03 '22 at 20:10

Best way for me using the docker dynamodb-local image was to change the user to root, here is my partial docker-compose.yml file:

version: '3.8'

services:
  dynamodb-local:
    image: amazon/dynamodb-local:latest
    container_name: dynamodb-local
    restart: unless-stopped
    ports:
      - "8000:8000"
    user: root
    volumes:
      - ../tmp/dynamodb:/home/dynamodblocal/data
    working_dir: /home/dynamodblocal
    command: "-jar DynamoDBLocal.jar -sharedDb -dbPath ./data"

score 2 · Answer 4 · answered Nov 04 '19 at 10:51

2

I had faced a similar error with Docker on Windows and the solution was to give 'System' all the permissions for the Docker Volume which persisted the DB Data

answered Nov 04 '19 at 10:51

Rohan Sawant

938
1
11
18

score 1 · Answer 5 · answered Aug 24 '17 at 17:35

Quick solution was to reinstall everything.

rm -rf <unzipped DynamoDB Local folder>

Then, go back through the installation instructions. http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.html

I'm unfamiliar with jar files. Replacing them with new jar files is like reinstalling?

score 1 · Answer 6 · answered Apr 09 '21 at 17:57

1

If you are on Windows, start the command prompt in administrator mode and then run your command again.

java -Djava.library.path=./DynamoDBLocal_lib -jar DynamoDBLocal.jar -sharedDb

It worked for me.

answered Apr 09 '21 at 17:57

Amede Angel Aulerien

361
4
8

score 1 · Answer 7 · answered Apr 20 '22 at 14:02

1

In docker like environment . Same permission issue. sudo chmod 777 ./docker/dynamodb .This still works in 2022

answered Apr 20 '22 at 14:02

Safayet Jamil

509
3
5

score 0 · Answer 8 · answered Feb 27 '21 at 12:35

I got this error when I upgraded my MacOS to Catalina.

I installed DynamoDBLocal again via these instructions - https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html

and it then worked.

If you need to have your old data replicated, just copy the existing "shared-local-instance.db" file into your new installation and it will work as before.

This is caused most likely to some permission changes to file access after Catalina was put in.

score 0 · Answer 9 · answered Nov 06 '21 at 20:31

0

If you are on Windows, give writing rights to the DynamoDB folder in your Desktop.

answered Nov 06 '21 at 20:31

Gabriel

67
9

Unable to open (Local DynamoDB) database file after power outage

9 Answers9

Linked