Sqllite error when trying to spin up flow emulator

Question

Sqllite error when trying to spin up flow emulator

Closed this issue 2 years ago · 10 comments

Problem

Getting the following error when trying to spin up the flow-emulator:

10:35PM ERR :exclamation:  Failed to configure storage               error="unable to open database file: out of memory (14)"

seems like the issue was caused by this PR: #301

more info on the the "unable to open database file:" error :https://stackoverflow.com/questions/7670289/sqlite3-operationalerror-unable-to-open-database-file

Acceptance Criteria

flow-emulator should be able to spin up without the error occurring

Context

Cannot upgrade to flow v0.44.0 because of this

Answer 1 · 2023-02-16T10:27:59.000Z

@bluesign do you have some context?

Answer 2 · 2023-02-16T10:29:51.000Z

I will have a look now ( which environment @supertejAnchor ? )

Answer 3 · 2023-02-16T13:44:43.000Z

I tried osx and linux couldn't reproduce, trying to find a windows machine.

Answer 4 · 2023-02-16T15:37:37.000Z

Try using https://www.parallels.com/eu/

Answer 5 · 2023-02-16T15:42:41.000Z

I can help but not today as I'm quite busy.

Answer 6 · 2023-02-16T15:43:35.000Z

I found one unused at home, today I will debug

Answer 7 · 2023-02-17T13:45:11.000Z

PS C:\Users\bluesign> flow version
Version: v0.45.4
Commit: b19fe3345881e7489c74449b47586e457b22becb
PS C:\Users\bluesign> flow emulator
5:44AM INF ⚙️   Using service account 0xf8d6e0586b0a20c7 serviceAddress=f8d6e0586b0a20c7 serviceHashAlgo=SHA3_256 servicePrivKey=e87566e6629212562312c18e22b82247f834e231e3aa6efe228011fd12e7cc57 servicePubKey=a6a403a9b41014913897d07277e7164494fc865ae9e7759a489aae43d4b5cd88150478a126eecb696109edff5dc40fb5f817b733dcb4f962702184d6d68862a2 serviceSigAlgo=ECDSA_P256
5:44AM INF 📜  Flow contract                             FlowFees=0xe5a8b7f23e8b548f
5:44AM INF 📜  Flow contract                             FlowStorageFees=0xf8d6e0586b0a20c7
5:44AM INF 📜  Flow contract                             FlowServiceAccount=0xf8d6e0586b0a20c7
5:44AM INF 📜  Flow contract                             FlowToken=0x0ae53cb6e3f42a79
5:44AM INF 📜  Flow contract                             FungibleToken=0xee82856bf20e2aa6
5:44AM INF 🌱  Starting gRPC server on port 3569         port=3569
5:44AM INF 🌱  Starting REST API on port 8888            port=8888
5:44AM INF 🌱  Starting admin server on port 8080        port=8080
5:44AM INF 🌱  Starting debugger on port 2345            port=2345
5:44AM INF ✅  Started REST API server on port 8888      port=8888
5:44AM INF ✅  Started gRPC server on port 3569          port=3569
5:44AM INF ✅  Started admin server on port 8080         port=8080

Answer 8 · 2023-02-17T13:45:33.000Z

I will need some more information to dig about environment.

Answer 9 · 2023-02-21T20:26:47.000Z

Turns out this error is because the emulator is trying to create the DB in the current directory (which is readonly in this case) instead of in $FLOW_DBPATH as the previous versions.

Answer 10 · 2023-02-21T20:28:00.000Z

@supertejAnchor I wil have a look at $FLOW_DBPATH problem, thanks for the details