#23 [17] Fix database issues

Suljettu
1 vuosi sitten avasi RSchenk · 0 kommenttia

After implementation of the container handler / pipeline scheduler some concurrency issues regarding locked databse errors started to occur. To fix those issues a connection pool needs to be implemented. See: https://stackoverflow.com/questions/57123453/how-to-use-diesel-with-sqlite-connections-and-avoid-database-is-locked-type-of

Another possible part of the solution (manual retries on DB errors) can be found here, but needs further investigation if indeed necessary: https://github.com/christian-oudard/sqlite-locking/blob/main/diesel/src/main.rs

After implementation of the container handler / pipeline scheduler some concurrency issues regarding locked databse errors started to occur. To fix those issues a connection pool needs to be implemented. See: https://stackoverflow.com/questions/57123453/how-to-use-diesel-with-sqlite-connections-and-avoid-database-is-locked-type-of Another possible part of the solution (manual retries on DB errors) can be found here, but needs further investigation if indeed necessary: https://github.com/christian-oudard/sqlite-locking/blob/main/diesel/src/main.rs
Kirjaudu sisään osallistuaksesi tähän keskusteluun.
Ei tunnistetta
bug
Ei osoitettua
1 osallistujaa
Ladataan...
Peruuta
Tallenna
Sisältöä ei vielä ole.