Should broadcast event is giving error. It's trying to data in queue instead of payload of jobs table.

[alimranahmed]

Laravel Version: 5.8.38

Facing a weird problem in queue. May be I am doing something wrong with event and queue.

Background

I have a an Event, that event is being broadcasted through pusher, so, then event is implementing ShouldBroadcast and overriding broadcastWith() that just return an array. Just to keep informed, this broadcastWith() method sometimes may be a very big array. But it's not as big as the limit of broadcasting through pusher.

So, when the event is being dispatched, it's trying to save the event's data in jobs table, which is expected. But we are getting this error when that event triggered:

Illuminate\Database\QueryException
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'queue' at row 1 (SQL: insert into `jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values ([{"id":246,"visit_id":337,"doctor_id":109,"patient_id":1,"enqueued_at":"2020-06-16 14:16:39","dequeued_at":null,"created_at":"2020-06-16 14:16:39","updated_at":"2020-06-16 14:16:39","patient":{"id":1,"user_id":8,"person_id":7,"created_at":"2020-05-18 15:56:31","
.......<a very big chunk of json>

It's trying to save the data in queue columns instead of payload column of jobs.
jobs is a table generated by Laravel itself and the type of the queue column is varchar(255). Why Laravel itself is trying to that big json data in queue table when its capacity is only 255? It should save this big json in payload columns instead of queue. I am sure changing the data type and increasing the queue column's capacity is not the solution here.

So, What am I doing wrong?