Job batch exits because of SQL error #38241
Unanswered
iahmedsuhail
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
When running jobs inside a batch, if too many jobs fail, I get the exception
String data, right truncated: 1406 Data too long for column 'failed_job_ids'
This is caused because the default migration that the command
php artisan queue:batches-table
generates lists thefailed_jobs_id
as aTEXT
type, which has some limitations. Can I change the mysql column type toLONGTEXT
?According to MySQL documentation, "These differ only in the maximum length of the values they can hold"
Beta Was this translation helpful? Give feedback.
All reactions