View Ticket
Not logged in
Ticket UUID: 3cacfcb6fae33169db0f86e4a2cf797b46dc94c9
Title: fossil: SQL error: string or blob too big
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Resolution: Not_A_Bug
Last Modified: 2010-01-06 14:17:19
Version Found In: 4f24addea9
Description & Comments:
What is the size limit of a blob ? I got following error when trying to commit a tree with many tar.gz files under the src tree.
[root] fossil commit -m "add basic pkgs" -nosign

fossil: SQL error: string or blob too big

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]


anonymous added on 2010-01-06 13:47:01:
Is there a way to see which file causing the error message ?


anonymous added on 2010-01-06 14:04:22:
a minicpan tar ball was the offending file(1.1G).

bash-2.05$ ls -l pub/8.3/perl-5.10.1/src/minicpan-12152009.tgz
-rw-r--r--   1 webadm   other      1118878373 Dec 15 01:18 pub/8.3/perl-5.10.1/src/minicpan-12152009.tgz
bash-2.05$ 

drh added on 2010-01-06 14:17:19:
BLOBs are limited to 1GiB.