[Bug Report]: some lookups fail if mysql & phpfpm are running with systemd PrivateTmp #2527

New Issue

OVERLORD · 2026-02-05T04:25:05+03:00

OVERLORD commented

2026-02-05 04:25:05 +03:00

Originally created by @ymarkus on GitHub (Dec 14, 2021).

Describe the Bug

If the mysql/mariadb & phpfpm systemd service is running with the option PrivateTmp set to true, bookstack throws the following error when trying to access e.g. shelves:

Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-bf-3a.MAI' (Errcode: 2 "No such file or directory") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc)

Steps to Reproduce

Start mariadb & phpfpm services with PrivateTmp=true, e.g. by using the NixOS module
Try to access shelves

Expected Behaviour

Don't throw an error

Screenshots or Additional Context

laravel.log:

[2021-12-14 13:11:48] production.ERROR: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 "No such file or directory") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc) {"userId":3,"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc) at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)
[stacktrace]
#0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback()
#1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run()
#2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select()
#3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get()
#7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()
#10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation()
#11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations()
#12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get()
#13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate()
#14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated()
#15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index()
#16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run()
#20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle()
#23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle()
#25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle()
#27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle()
#33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle()
#39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then()
#41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack()
#42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute()
#43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute()
#44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch()
#45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle()
#48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle()
#49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then()
#57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#59 {main}

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
[stacktrace]
#0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()
#1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(335): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback()
#4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run()
#5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select()
#6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect()
#7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get()
#10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels()
#11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()
#13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation()
#14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations()
#15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get()
#16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate()
#17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated()
#18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index()
#19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run()
#23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle()
#26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle()
#28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle()
#30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle()
#36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle()
#42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then()
#44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack()
#45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute()
#46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute()
#47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch()
#48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle()
#51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle()
#52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then()
#60 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#61 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#62 {main}

[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)
[stacktrace]
#0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute()
#1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(335): Doctrine\\DBAL\\Driver\\PDOStatement->execute()
#2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback()
#4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run()
#5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select()
#6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect()
#7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get()
#10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels()
#11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get()
#12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()
#13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation()
#14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations()
#15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get()
#16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate()
#17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated()
#18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index()
#19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()
#22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run()
#23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle()
#26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle()
#28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle()
#30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle()
#36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle()
#42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then()
#44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack()
#45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute()
#46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute()
#47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch()
#48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle()
#51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle()
#52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then()
#60 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#61 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#62 {main}
"}

Exact BookStack Version

21.10.3

PHP Version

8.0

Hosting Environment

NixOS 21.05.20211203.c383928 (Okapi)

Originally created by @ymarkus on GitHub (Dec 14, 2021). ### Describe the Bug If the mysql/mariadb & phpfpm systemd service is running with the option `PrivateTmp` set to `true`, bookstack throws the following error when trying to access e.g. `shelves`: ``` Illuminate\Database\QueryException SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-bf-3a.MAI' (Errcode: 2 "No such file or directory") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc) ``` ### Steps to Reproduce 1. Start mariadb & phpfpm services with `PrivateTmp=true`, e.g. by using the [NixOS module](https://github.com/NixOS/nixpkgs/blob/nixos-21.11/nixos/modules/services/web-servers/phpfpm/default.nix) 2. Try to access shelves ### Expected Behaviour Don't throw an error ### Screenshots or Additional Context laravel.log: ``` [2021-12-14 13:11:48] production.ERROR: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 "No such file or directory") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc) {"userId":3,"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") (SQL: select `books`.*, `bookshelves_books`.`bookshelf_id` as `pivot_bookshelf_id`, `bookshelves_books`.`book_id` as `pivot_book_id`, `bookshelves_books`.`order` as `pivot_order` from `books` inner join `bookshelves_books` on `books`.`id` = `bookshelves_books`.`book_id` where (exists (select * from `joint_permissions` where `books`.`id` = `joint_permissions`.`entity_id` and `joint_permissions`.`entity_type` = BookStack\\Book and `role_id` in (1) and `action` = view and (`has_permission` = 1 or (`has_permission_own` = 1 and `owned_by` = 3)))) and `bookshelves_books`.`bookshelf_id` in (1, 2) and `books`.`deleted_at` is null order by `order` asc) at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669) [stacktrace] #0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback() #1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run() #2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select() #3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect() #4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get() #7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager() #10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation() #11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations() #12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get() #13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate() #14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated() #15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index() #16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch() #18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run() #20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle() #23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle() #25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle() #27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle() #33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle() #39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then() #41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack() #42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute() #43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute() #44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch() #45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle() #48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle() #49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle() #55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then() #57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #59 {main} [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18) [stacktrace] #0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\\DBAL\\Driver\\PDO\\Exception::new() #1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(335): Doctrine\\DBAL\\Driver\\PDOStatement->execute() #2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback() #4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run() #5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select() #6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect() #7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns() #9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get() #10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels() #11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager() #13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation() #14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations() #15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get() #16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate() #17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated() #18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index() #19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch() #21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run() #23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle() #26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle() #28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle() #30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle() #36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle() #42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then() #44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack() #45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute() #46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute() #47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch() #48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle() #51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle() #52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle() #58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #59 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then() #60 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #61 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #62 {main} [previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 \"No such file or directory\") at /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112) [stacktrace] #0 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute() #1 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(335): Doctrine\\DBAL\\Driver\\PDOStatement->execute() #2 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #3 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback() #4 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run() #5 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Connection->select() #6 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect() #7 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #8 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns() #9 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\\Database\\Query\\Builder->get() #10 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/BelongsToMany.php(650): Illuminate\\Database\\Eloquent\\Builder->getModels() #11 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->get() #12 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(594): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager() #13 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(563): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation() #14 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(531): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations() #15 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\\Database\\Eloquent\\Builder->get() #16 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Entities/Repos/BookshelfRepo.php(35): Illuminate\\Database\\Eloquent\\Builder->paginate() #17 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Controllers/BookshelfController.php(44): BookStack\\Entities\\Repos\\BookshelfRepo->getAllPaginated() #18 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): BookStack\\Http\\Controllers\\BookshelfController->index() #19 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #20 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch() #21 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #22 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run() #23 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #24 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Authenticate.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Authenticate->handle() #26 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/Localization.php(75): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\Localization->handle() #28 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/RunThemeActions.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\RunThemeActions->handle() #30 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #32 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #34 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Session\\Middleware\\StartSession->handle() #36 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #38 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #40 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/ControlIframeSecurity.php(31): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\ControlIframeSecurity->handle() #42 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\\Pipeline\\Pipeline->then() #44 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack() #45 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\\Routing\\Router->runRoute() #46 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute() #47 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\\Routing\\Router->dispatch() #48 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #49 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/app/Http/Middleware/TrustProxies.php(39): Fideloper\\Proxy\\TrustProxies->handle() #51 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): BookStack\\Http\\Middleware\\TrustProxies->handle() #52 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #54 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #55 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #56 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #57 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle() #58 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #59 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then() #60 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #61 /nix/store/innnpbi6jpg7p3j6yp1lbfm624wjkh1w-composer-bookstack/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle() #62 {main} "} ``` ### Exact BookStack Version 21.10.3 ### PHP Version 8.0 ### Hosting Environment NixOS 21.05.20211203.c383928 (Okapi)

OVERLORD added the 🐛 Bug label 2026-02-05 04:25:05 +03:00

OVERLORD closed this issue

2026-02-05 04:25:07 +03:00

OVERLORD commented

2026-02-05 04:25:09 +03:00

@ssddanbrown commented on GitHub (Dec 14, 2021):

Hi @ymarkus,
Are you sure this is a bug for BookStack instead of a system configuration bug?

The message:

SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 "No such file or directory")

Appears to be coming from MySQL/MariaDB in regards to it's access of the /tmp dir.
From what I understand the PrivateTmp option will forbid access to the /tmp directory which is likely causing this, an instead creates a custom tmp dir for the process. I'm not sure how MySQL/MariaDB or PHP interacts with this system, if it should pick up this location automatically or if it needs to be set in the application configuration.

@ssddanbrown commented on GitHub (Dec 14, 2021): Hi @ymarkus, Are you sure this is a bug for BookStack instead of a system configuration bug? The message: > SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-14ff-c0-0.MAI' (Errcode: 2 "No such file or directory") Appears to be coming from MySQL/MariaDB in regards to it's access of the `/tmp` dir. From what I understand the `PrivateTmp` option will forbid access to the `/tmp` directory which is likely causing this, an instead creates a custom tmp dir for the process. I'm not sure how MySQL/MariaDB or PHP interacts with this system, if it should pick up this location automatically or if it needs to be set in the application configuration.

OVERLORD commented

2026-02-05 04:25:17 +03:00

@ymarkus commented on GitHub (Dec 15, 2021):

Thank you, @ssddanbrown ! It seems like it was indeed an issue with my system setup. For some reason, the tmpdir of mysql doesnt exist, as described here at RedHat. Sorry for bothering!

If someone hits this issue: simply restart the mysql/mariadb service and then it recreates the tmpdir.

@ymarkus commented on GitHub (Dec 15, 2021): Thank you, @ssddanbrown ! It seems like it was indeed an issue with my system setup. For some reason, the tmpdir of mysql doesnt exist, as described [here at RedHat](https://access.redhat.com/discussions/3027351). Sorry for bothering! If someone hits this issue: simply restart the mysql/mariadb service and then it recreates the tmpdir.

OVERLORD commented

2026-02-05 04:25:23 +03:00

@ssddanbrown commented on GitHub (Dec 15, 2021):

@ymarkus No worries, glad to hear you found the solution!

@ssddanbrown commented on GitHub (Dec 15, 2021): @ymarkus No worries, glad to hear you found the solution!

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#2527

[Bug Report]: some lookups fail if mysql & phpfpm are running with systemd PrivateTmp #2527

Describe the Bug

Steps to Reproduce

Expected Behaviour

Screenshots or Additional Context

Exact BookStack Version

PHP Version

Hosting Environment

[Bug Report]: some lookups fail if mysql & phpfpm are running with systemd `PrivateTmp` #2527