Fossil SCM

I was'n able to commit added files in version
fossil version [d8f8932ff2] 2010-08-13 07:07:08 UTC

and succedd with older version
fossil version [fb5f0c2580] 2010-07-03 15:33:59 UTC

fossil commit --comment "úvodní naplnění databáze"
Autosync:  file:///Users/navratil/fossil/bin.fsl
                Bytes      Cards  Artifacts     Deltas
Send:             146          2          0          0
Error: Database error: database is locked
COMMIT



/Applications/fossil commit
Autosync:  file:///Users/navratil/fossil/bin.fsl
                Bytes      Cards  Artifacts     Deltas
Send:             146          2          0          0
Received:         108          3          0          0
Total network traffic: 252 bytes sent, 282 bytes received
/usr/bin/vim "/Users/navratil/bin/ci-comment-0D37EFA17E26.txt"
New_Version: 074b99d7792352ff4363ff80f2cceb833168d342
Autosync:  file:///Users/navratil/fossil/bin.fsl
                Bytes      Cards  Artifacts     Deltas
Send:          500258         72          3          0
Error: Database error: SQL error: database is locked

anonymous claiming to be arichardson added on 2010-11-11 12:01:59: I'm occasionally seeing this error in my Buildbot logs.

fossil pull && fossil update
 in dir /var/lib/buildbot/Reu2/slave/bin/nikko/build (timeout 1200 secs)
 watching logfiles {}
 argv: fossil pull && fossil update
 environment:
  HOME=/var/lib/buildbot
  LANG=en_GB.UTF-8
  LOGNAME=buildbot
  LS_COLORS=<snip very long string>
  MAIL=/var/mail/fatman
  PATH=<snip very long string>
  PWD=/var/lib/buildbot/Reu2/slave/bin/nikko/build
  SHELL=/bin/bash
  SUDO_COMMAND=/usr/bin/buildbot start /var/lib/buildbot/Reu2/slave/
  SUDO_GID=1000
  SUDO_UID=1000
  SUDO_USER=fatman
  TERM=screen-bce
  USER=buildbot
  USERNAME=buildbot
 closing stdin
 using PTY: False
Server:    http://[email protected]/fossils/reu2.cgi
                Bytes      Cards  Artifacts     Deltas

Sent:             146          2          0          0
waiting for server...
processed: 100%         fossil: 
Error: Database error: database is locked
DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)
program finished with exit code 1
elapsedTime=0.172838

The build runs every 8 hours. Usually it's fine, but sometimes this happens and causes the build to fail.

drh added on 2010-11-11 12:09:26: Recommended fix in both cases above:

1. Run the fossil sql command to get an interactive SQLite shell.

2. Type "PRAGMA journal_mode=WAL;"