Doc bug: wal.html should mention proper way to remove wal and shm files

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Doc bug: wal.html should mention proper way to remove wal and shm files

積丹尼 Dan Jacobson
file:///usr/share/doc/sqlite3-doc/wal.html should mention the common case where
the user (let's say someone from a different project) has encountered
  cookies.db cookies.db-shm cookies.db-wal
left behind by some program. User wishs to clean this up, leaving only cookies.db.
Of course he could just
$ rm cookies.db-shm cookies.db-wal
But that might lose data, so the page should mention that users can do
$ sqlite3 cookies.db .dump > /dev/null
instead. (Or perhaps even a better way.)
(Thus achieving the
file:///usr/share/doc/sqlite3-doc/onefile.html
state advertised!)
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Doc bug: wal.html should mention proper way to remove wal and shm files

Clemens Ladisch
積丹尼 Dan Jacobson wrote:
> file:///usr/share/doc/sqlite3-doc/wal.html should mention the common case where
> the user (let's say someone from a different project) has encountered
>   cookies.db cookies.db-shm cookies.db-wal
> left behind by some program. User wishs to clean this up, leaving only cookies.db.

That page says:
| When the last connection to a database closes, that connection does
| one last checkpoint and then deletes the WAL and its associated
| shared-memory file, to clean up the disk.

From this, you can deduce how to clean up: close without crashing.

> $ sqlite3 cookies.db .dump > /dev/null

You could instead use any command that accesses the database:

  $ sqlite3 cookies.db 'begin immediate; rollback;'


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Doc bug: wal.html should mention proper way to remove wal and shm files

積丹尼 Dan Jacobson
In reply to this post by 積丹尼 Dan Jacobson
>>>>> "CL" == Clemens Ladisch <clemens> writes:
CL>> From this, you can deduce how to clean up: close without crashing.[...]
CL> You could instead use any command that accesses the database:

wal.html should provide specific instructions. Not everybody us an expert.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Doc bug: wal.html should mention proper way to remove wal and shm files

積丹尼 Dan Jacobson
In reply to this post by 積丹尼 Dan Jacobson
Not everybody is an expert.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...