SQLite Forum

"database or disk is full" with in-memory database. Suggested next steps?
Login
These sessions use the default (1 GB) and a modified (4 GB) SQLITE_CONFIG_MEMDB_MAXSIZE

```
SQLite version 3.37.0 2021-08-18 18:05:52
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open "file:///x?vfs=memdb"
sqlite> create table x(x);
sqlite> insert into x select value from wholenumber where value between 1 and 100000000;
Error: database or disk is full
sqlite> ^Z


SQLite version 3.37.0 2021-08-19 19:52:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open "file:///x?vfs=memdb"
sqlite> create table x(x);
sqlite> insert into x select value from wholenumber where value between 1 and 100000000;
sqlite>
```

Note that table x will take about 2 GB of space ...