From: Eric Wong <email@example.com> To: firstname.lastname@example.org Subject: Re: anybody hit SQLite "database is locked" errors? Date: Tue, 25 Aug 2020 16:29:05 +0000 [thread overview] Message-ID: <20200825162905.GA4005@dcvr> (raw) In-Reply-To: <20200825001204.GA840@dcvr> Eric Wong <email@example.com> wrote: > In particular, the expensive (for LKML) `SELECT COUNT(*) FROM msgmap' > statement in our current examples/grok-pull.post_update_hook.sh > seems to be a culprit. That's even opened with the sqlite3 > `-readonly' flag, it still needs to acquire a SHARED lock in SQLite. Even without the proposed patch to the post_update_hook; I haven't been able to reproduce the problem on a different (faster) machine...
prev parent reply other threads:[~2020-08-25 16:29 UTC|newest] Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top 2020-08-25 0:12 Eric Wong 2020-08-25 10:23 ` [PATCH] grok-pull.post_update_hook: flock(2) before SQLite check Eric Wong 2020-08-25 16:29 ` Eric Wong [this message]
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style List information: https://public-inbox.org/README * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=20200825162905.GA4005@dcvr \ --firstname.lastname@example.org \ --email@example.com \ --subject='Re: anybody hit SQLite "database is locked" errors?' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
Code repositories for project(s) associated with this inbox: https://80x24.org/public-inbox.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).