Hello,
I saw today i have some problem on Queue, i have configured with supervisorctl
adrian@adinextcloud:~$ sudo supervisorctl status laravel-worker:*
[sudo] password for adrian:
laravel-worker:laravel-worker_00 RUNNING pid 1225902, uptime 0:03:47
laravel-worker:laravel-worker_01 RUNNING pid 1225866, uptime 0:03:48
laravel-worker:laravel-worker_02 RUNNING pid 1225903, uptime 0:03:47
laravel-worker:laravel-worker_03 RUNNING pid 1225867, uptime 0:03:48
laravel-worker:laravel-worker_04 RUNNING pid 1225918, uptime 0:03:45
laravel-worker:laravel-worker_05 RUNNING pid 1225919, uptime 0:03:45
laravel-worker:laravel-worker_06 RUNNING pid 1225868, uptime 0:03:48
laravel-worker:laravel-worker_07 RUNNING pid 1225904, uptime 0:03:47
But in log i find this error:
2022-11-09 12:05:01 App\Jobs\Ninja\QueueSize … 5.61ms DONE
In Connection.php line 760:
SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from inform
ation_schema.tables where table_schema = invoiceninjav5 and table_name = ac
counts and table_type = ‘BASE TABLE’)
In Connector.php line 70:
SQLSTATE[HY000] [2002] No such file or directory
2023-01-31 19:20:03 App\Jobs\Ninja\QueueSize … RUNNING
2023-01-31 19:20:03 App\Jobs\Ninja\QueueSize … 10.55ms DONE
I saw if i put like this on a mysql client is work:
select * from information_schema.tables where table_schema = ‘invoiceninjav5’ and table_name = ‘accounts’ and table_type = ‘BASE TABLE’) ;
Thanks