I've been doing exactly that. It is, creating a new DB file for each
test, and I was having the same problem as you.

I suggested a change to the driver to cover that situation:
https://github.com/pharo-rdbms/Pharo-SQLite3/pull/22/files

Try applying that change and see if that works.

I still prefer to recreate the database, it will give you a full fresh
start, and if you want you can halt before the deletion of the db, to
analyze its internal state.

Best regards!


Esteban A. Maringolo

On Sat, Aug 7, 2021 at 11:13 PM <vinref@gmail.com> wrote:
>
> Hi
>
> Actually I will just do a bunch of
>
> DROP TABLE IF EXISTS
>
> instead of dropping the db altogether.
>
> Thanks, Vince