Sqlstate[hy000]


#1

Hi ,

The error is random, when creating a task or BoardViewController :triumph:

Fatal error: Uncaught PicoDb\SQLException: SQL Error: SQLSTATE[HY000]: General error: 5 database is locked in C:\xampp\htdocs\kanban\libs\picodb\lib\PicoDb\StatementHandler.php:351 Stack trace: #0 C:\xampp\htdocs\kanban\libs\picodb\lib\PicoDb\StatementHandler.php(245): PicoDb\StatementHandler->handleSqlError(Object(PDOException)) #1 C:\xampp\htdocs\kanban\libs\picodb\lib\PicoDb\Table.php(237): PicoDb\StatementHandler->execute() #2 C:\xampp\htdocs\kanban\app\Core\Session\SessionHandler.php(68): PicoDb\Table->insert(Array) #3 [internal function]: Kanboard\Core\Session\SessionHandler->write(‘M-Jm4aAhw9TttT3…’, ‘csrf|a:1:{s:60:…’) #4 [internal function]: session_write_close() #5 {main} thrown in C:\xampp\htdocs\kanban\libs\picodb\lib\PicoDb\StatementHandler.php on line 351


#2

Typical for sqlite, slow drive probably.


#3

probably very poor disk I/O. You should try Nginx with PHP-FPM, and if possible use Postgresql instead of Sqlite.


#4

ok , testing disk and services online localhost , Thanks