New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Docker image - Notifications bell - General error: 10 disk I/O error #4131

Closed
mentat-fr opened this Issue Jan 23, 2019 · 2 comments

Comments

2 participants
@mentat-fr
Copy link

mentat-fr commented Jan 23, 2019

Actual behaviour

When click on notification bell have the error message, same when try to optimise the VACUUM optimisation.

Internal Error: SQL Error: SQLSTATE[HY000]: General error: 10 disk I/O error

Otherwise all other actions seems to be fine, I can create and update tasks.

Expected behaviour

No error and notification list.

Steps to reproduce

Screenshots

capture d ecran de 2019-01-23 10-27-26

Configuration

Working with the last official docker image kanboard/kanboard on openmediavault NAS

  • Kanboard version: latest docker image 1.2.7
  • Database type and version: sqlite 3.24.0
  • PHP version: 7.2.13
  • OS: Linux 4.18.0-0.bpo.3-amd64
  • Browser: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36
@mentat-fr

This comment has been minimized.

Copy link
Author

mentat-fr commented Jan 24, 2019

Here the debug log with the 2 lines

[debug] SQL: SELECT * FROM "user_has_unread_notifications" WHERE "user_id" = ? ORDER BY "date_creation" ASC [2019-01-24 20:34:02] [debug] SQL: SQLSTATE[HY000]: General error: 10 disk I/O error

Full debug when I hit the notification bell

[2019-01-24 20:33:32] [debug] ############################################### [2019-01-24 19:34:02] [debug] Kanboard\Core\Controller\Runner::executeMiddleware [2019-01-24 19:34:02] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute [2019-01-24 20:34:02] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware [2019-01-24 20:34:02] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware [2019-01-24 20:34:02] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware [2019-01-24 20:34:02] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware [2019-01-24 20:34:02] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\WebNotificationController::show [2019-01-24 20:34:02] [debug] SQL: SELECT "version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1 [2019-01-24 20:34:02] [debug] SQL: query_duration=0.0047440528869629 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0047440528869629 [2019-01-24 20:34:02] [debug] SQL: SELECT "data" FROM "sessions" WHERE "id" = ? LIMIT 1 [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00036096572875977 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0051050186157227 [2019-01-24 20:34:02] [debug] SQL: SELECT "option", "value" FROM "settings" [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00018405914306641 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0052890777587891 [2019-01-24 20:34:02] [debug] SQL: SELECT projects.id, projects.name FROM "projects" LEFT JOIN "project_has_users" ON "project_has_users"."project_id"="projects"."id" WHERE project_has_users.user_id = ? AND projects.is_active IN (?) [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00029683113098145 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0055859088897705 [2019-01-24 20:34:02] [debug] SQL: SELECT projects.id, projects.name FROM "projects" LEFT JOIN "project_has_groups" ON "project_has_groups"."project_id"="projects"."id" LEFT JOIN "group_has_users" ON "group_has_users"."group_id"="project_has_groups"."group_id" WHERE group_has_users.user_id = ? AND projects.is_active IN (?) [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00036716461181641 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0059530735015869 [2019-01-24 20:34:02] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" IN (?, ?) [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00022006034851074 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0061731338500977 [2019-01-24 20:34:02] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00041985511779785 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0065929889678955 [2019-01-24 20:34:02] [debug] SQL: SELECT 1 FROM "users" WHERE "id" = ? AND "is_active" = ? [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00029182434082031 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0068848133087158 [2019-01-24 20:34:02] [debug] SQL: SELECT * FROM "users" WHERE "id" = ? LIMIT 1 [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00038909912109375 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0072739124298096 [2019-01-24 20:34:02] [debug] SQL: SELECT * FROM "user_has_unread_notifications" WHERE "user_id" = ? ORDER BY "date_creation" ASC [2019-01-24 20:34:02] [debug] SQL: SQLSTATE[HY000]: General error: 10 disk I/O error [2019-01-24 20:34:02] [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ? [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00017309188842773 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0074470043182373 [2019-01-24 20:34:02] [debug] SQL: UPDATE "sessions" SET "expire_at"=?, "data"=? WHERE "id" = ? [2019-01-24 20:34:02] [debug] SQL: query_duration=0.00034785270690918 [2019-01-24 20:34:02] [debug] SQL: total_execution_time=0.0077948570251465 [2019-01-24 20:34:02] [debug] APP: nb_queries=11 [2019-01-24 20:34:02] [debug] APP: rendering_time=0.27068305015564 [2019-01-24 20:34:02] [debug] APP: memory_usage=1.82M [2019-01-24 20:34:02] [debug] APP: uri=/?controller=WebNotificationController&action=show&user_id=3 [2019-01-24 20:34:02] [debug] ###############################################

@fguillot

This comment has been minimized.

Copy link
Collaborator

fguillot commented Feb 2, 2019

Your issue doesn't seems to be related to Kanboard itself but the poor disk I/O of your device. I would recommend to use Postgresql instead of SQLite.

In the future, if you have any installation issues, please use the forum: https://kanboard.discourse.group/

@fguillot fguillot closed this Feb 2, 2019

@kanboard kanboard locked and limited conversation to collaborators Feb 2, 2019

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.