bug#42001: “SQLite database is busy”: contention on the store database

2021-03-30 Thread Ludovic Courtès
Hi, Ludovic Courtès skribis: > On berlin.guix.gnu.org, we’ve seen a lot of contention on the store > database for a month or so, with messages like: > > warning: SQLite database is busy > > More often than not, everything slows down to a halt, and builds don’t > proceed. I think we can now cl

bug#42001: “SQLite database is busy”: contention on the store database

2020-06-23 Thread Ludovic Courtès
Ludovic Courtès skribis: > The are several possible causes of contention: (1) database opened too > many times, (2) database kept opened for too long, and (3) sqlite > mishandling contention somehow. Commit fe5de925aa0f2854a679cebdea02b03cac561c8f should make deduplication more efficient (it was

bug#42001: “SQLite database is busy”: contention on the store database

2020-06-23 Thread Ludovic Courtès
Hi, Mathieu Othacehe skribis: >> utimensat(AT_FDCWD, >> "/gnu/store/whhc80cx1zpi9cj3bil3sp8wwzcf8p9p-image-root/gnu/store/n6l40ygclxfysnc2nxwrslnn5ab6wv3v-profile/lib/modules/5.4.47-gnu/kernel/net/netfilter", >> [{tv_sec=1592814617, tv_nsec=396083395} /* >> 2020-06-22T10:30:17.396083395+0200

bug#42001: “SQLite database is busy”: contention on the store database

2020-06-22 Thread Mathieu Othacehe
Hey Ludo, > utimensat(AT_FDCWD, > "/gnu/store/whhc80cx1zpi9cj3bil3sp8wwzcf8p9p-image-root/gnu/store/n6l40ygclxfysnc2nxwrslnn5ab6wv3v-profile/lib/modules/5.4.47-gnu/kernel/net/netfilter", > [{tv_sec=1592814617, tv_nsec=396083395} /* > 2020-06-22T10:30:17.396083395+0200 */, {tv_sec=1, tv_nsec=0

bug#42001: “SQLite database is busy”: contention on the store database

2020-06-22 Thread Ludovic Courtès
Hi, On berlin.guix.gnu.org, we’ve seen a lot of contention on the store database for a month or so, with messages like: warning: SQLite database is busy More often than not, everything slows down to a halt, and builds don’t proceed. We initially discussed it here: https://issues.guix.gnu.o