数据库跨境问题
场景:欧洲的服务器想要链接亚东服务器的mysql或者redis,这种情况就会出现网络跨境问题,造成的现象是,公网链接速度延迟较大,造成mysql或redis许多链接超时的问题.
Illuminate\Database\Eloquent\ModelNotFoundException: No query results for model [App\Models\User]. in /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:479
Stack trace:
#0 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\Database\Eloquent\Builder->firstOrFail()
#1 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\Jobs\SendMailJob->restoreModel(Object(Illuminate\Contracts\Database\ModelIdentifier))
#2 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(45): App\Jobs\SendMailJob->getRestoredPropertyValue(Object(Illuminate\Contracts\Database\ModelIdentifier))
#3 [internal function]: App\Jobs\SendMailJob->__wakeup()
#4 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(53): unserialize(‘O:20:”App\\Jobs\\…’)
#5 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(88): Illuminate\Queue\CallQueuedHandler->call(Object(Illuminate\Queue\Jobs\RedisJob), Array)
#6 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(368): Illuminate\Queue\Jobs\Job->fire()
#7 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(314): Illuminate\Queue\Worker->process(‘redis’, Object(Illuminate\Queue\Jobs\RedisJob), Object(Illuminate\Queue\WorkerOptions))
#8 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(134): Illuminate\Queue\Worker->runJob(Object(Illuminate\Queue\Jobs\RedisJob), ‘redis’, Object(Illuminate\Queue\WorkerOptions))
#9 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(112): Illuminate\Queue\Worker->daemon(‘redis’, ‘default’, Object(Illuminate\Queue\WorkerOptions))
#10 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(96): Illuminate\Queue\Console\WorkCommand->runWorker(‘redis’, ‘default’)
#11 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#12 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#13 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#14 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#15 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#16 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#17 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#18 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#19 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/symfony/console/Application.php(1021): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/symfony/console/Application.php(275): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Queue\Console\WorkCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#21 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#22 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#24 /var/www/html/staging/cpulse-be-staging.ivideocloud.cn/releases/20230706082228/artisan(37): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#25 {main}
解决:一般服务商会提供全球加速的服务,只是费用可能较高,但效果会明显
: