View Ticket
Not logged in
Ticket UUID: 1aaadb4f0dbb57842bd892e62c3256d0d3057259
Title: fossil: SQL error: out of memory
Status: Open Type: Incident
Severity: Important Priority:
Subsystem: Resolution: Open
Last Modified: 2010-01-26 22:54:40
Version Found In: [71ad9b62a7
Description & Comments:
Is this a bug or fossil reach its limit on size of source tree ? the machine has only 512M of RAM. The iso directory is 22G in size.
root@600m:/pub# fossil commit -m "add iso" -nosign
fossil: SQL error: out of memory

If you have recently updated your fossil executable, you might need to run "fossil all rebuild" to bring the repository schemas up to date. root@600m:/pub# du -ks iso 22293214 iso root@600m:/pub# ^C root@600m:/pub# fossil version This is fossil version [71ad9b62a7] 2009-12-31 14:59:03 UTC root@600m:/pub# cat /etc/release OpenSolaris Development snv_130 X86 Copyright 2009 Sun Microsystems, Inc. All Rights Reserved. Use is subject to license terms. Assembled 18 December 2009 root@600m:/pub#


anonymous claiming to be ge added on 2010-01-07 19:11:27:
Fossil (and Git and Mercurial) don't do too well as a repository for huge binary blobs. You probably either ran out of address space or out of swap space. SQLite also has a limit on the blob size it will store.


bharder added on 2010-01-07 22:29:04:
SQLite itself should not be limiting factor in this case: SQLite limits.


bharder added on 2010-01-07 22:34:06:
Oops... I take that back... the total # bytes for this commit is 22828251136 (22 billion, 8 hundred million...). More than 1 billion default sqlite3 limit.


anonymous added on 2010-01-26 22:54:40:
still getting "out of memory" and less verbosed (no more "SQL error:" ).

root@600m:/pub# ls -l *.fsl
-rw-r--r-- 1 root root 43008 2010-01-26 08:56 iso.fsl
root@600m:/pub#fossil add iso
<snip>
ADDED  iso/mi-vt.py.bz2
ADDED  iso/pdf-letter-2.5.zip
ADDED  iso/qemu-0.9.0-windows.zip
ADDED  iso/qemu-20070827-windows.zip
ADDED  iso/sol-10-u5-doc-ga-dvd-iso.zip
ADDED  iso/ubuntu-server-6.06.2-i386.zip.torrent
ADDED  iso/zenoss-2.1.2-x86.vmware.zip
root@600m:/pub# fossil commit -m "add iso" -nosign
out of memory
root@600m:/pub# fossil version;date
This is fossil version [b8d812efb9] 2010-01-26 14:38:12 UTC
Tuesday, January 26, 2010  4:50:04 PM CST
root@600m:/pub#