Illuminate\Database\QueryException: SQLSTATE[40001]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La transazione (ID di processo 325) è stata interrotta a causa di un deadlock delle risorse blocco con un altro processo. Ripetere la transazione. (SQL: select top 4 * from [buildings] where building_hidden_state_id = 0 AND nightprice > 0 AND max_person > 0 AND isola = 1 AND id IN (SELECT building_id FROM building_photos GROUP BY building_id) order by NEWID()) in file C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 703 #0 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Connection.php(663): Illuminate\Database\Connection->runQueryCallback() #1 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Connection.php(367): Illuminate\Database\Connection->run() #2 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2350): Illuminate\Database\Connection->select() #3 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2338): Illuminate\Database\Query\Builder->runSelect() #4 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2872): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2339): Illuminate\Database\Query\Builder->onceWithColumns() #6 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(615): Illuminate\Database\Query\Builder->get() #7 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(599): Illuminate\Database\Eloquent\Builder->getModels() #8 C:\inetpub\wwwroot\immobilelba.com\app\Http\Controllers\HomeController.php(33): Illuminate\Database\Eloquent\Builder->get() #9 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): App\Http\Controllers\HomeController->index() #10 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #11 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch() #12 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Route.php(205): Illuminate\Routing\Route->runController() #13 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Router.php(695): Illuminate\Routing\Route->run() #14 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #15 C:\inetpub\wwwroot\immobilelba.com\app\Http\Middleware\Locale.php(54): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): App\Http\Middleware\Locale->handle() #17 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #19 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #21 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #23 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #25 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle() #26 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #28 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #29 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle() #30 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Router.php(697): Illuminate\Pipeline\Pipeline->then() #32 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Router.php(672): Illuminate\Routing\Router->runRouteWithinStack() #33 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Router.php(636): Illuminate\Routing\Router->runRoute() #34 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Routing\Router.php(625): Illuminate\Routing\Router->dispatchToRoute() #35 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(166): Illuminate\Routing\Router->dispatch() #36 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #37 C:\inetpub\wwwroot\immobilelba.com\vendor\sentry\sentry-laravel\src\Sentry\Laravel\Http\SetRequestIpMiddleware.php(55): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Sentry\Laravel\Http\SetRequestIpMiddleware->handle() #39 C:\inetpub\wwwroot\immobilelba.com\vendor\sentry\sentry-laravel\src\Sentry\Laravel\Http\SetRequestMiddleware.php(52): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Sentry\Laravel\Http\SetRequestMiddleware->handle() #41 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #43 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #44 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #46 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #47 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #49 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #51 C:\inetpub\wwwroot\immobilelba.com\vendor\fruitcake\laravel-cors\src\HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #52 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #53 C:\inetpub\wwwroot\immobilelba.com\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #54 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle() #55 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #56 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(141): Illuminate\Pipeline\Pipeline->then() #57 C:\inetpub\wwwroot\immobilelba.com\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #58 C:\inetpub\wwwroot\immobilelba.com\public\index.php(52): Illuminate\Foundation\Http\Kernel->handle() #59 {main}