Unit test failed (` SQLite Error 8: 'attempt to write a readonly database'.`)

[tynguyen]

Describe the bug

Issue occurs when attempting to create a collection or upsert records to the database. For example, /semantic-kernel/dotnet/src/Connectors/Connectors.UnitTests/Memory/Sqlite/SqliteMemoryStoreTests.cs:line 587

This could have something to do with the read/write permission on my pc too. I'm not sure.

[awharrison-28]

Hi @tynguyen I am unable to repro this issue locally, so it might have to do with the your read/write permissions. I did find some cleanup errors in the unit tests though while trying.

I am currently refactoring the SqliteMemoryStore to avoid manually managing the connection. This should make the unit tests cleaner in general.

[tynguyen]

Thanks @awharrison-28 . Closed as it irreproducible.

[awharrison-28]

@tynguyen just wanted to follow up here, #425 should address the unit test issues I discovered that were caused by unclosed connections. I don't think will solve what you described in this issue unfortunately.