murilo's avatar
Level 10

quewe errror, cant insert into jobs table - Connection: pgsql, SQL: insert into "jobs"

hello, I am using laravel quewe , and sundly it gave error , when I try to run any quewe ; I am using laravel 11 . my .env is like this -

BROADCAST_CONNECTION=log
FILESYSTEM_DISK=local
QUEUE_CONNECTION=database

CACHE_STORE=database
CACHE_PREFIX=

it is giving this error -

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: insert into "jobs" ("queue", "attempts", "reserved_at", "available_at", "created_at", "payload") values (default, 0, ?, 1744315433, 1744315433, {"uuid":"2a3bb817-a6f3-4c0c-b0c2-a1c3eda49a1c","displayName":"App\\Jobs\\ProcessPropNewOpportunityJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\Jobs\\ProcessPropJob","command":"O:37:\"App\\Jobs\\ProcessPropJob\":0:{}"}}) returning "id")


I tryed to run -

php artisan queue:table
php artisan migrate

I created again the table job . but is not registering any more those jobs and it is failling, becouse it cant register those jobs in the database

0 likes
0 replies

Please or to participate in this conversation.