View Ticket
Not logged in
Ticket UUID: 8f8083f23038c3b5c67146b8ee1e9e0fd2e947a1
Title: commit not possible
Status: Open Type: Code_Defect
Severity: Important Priority:
Subsystem: Resolution: Open
Last Modified: 2010-11-11 12:09:26
Version Found In: [4e1241f323] 2010-10-31 21:51:11 UTC
Description & Comments:
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://fatman@dreamtrack.dnsalias.com/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.
  1. Type "PRAGMA journal_mode=WAL;"