Skip to content

PendingJob of -1 errors as Out of Range for Unsigned Big Int #19

@gpickin

Description

@gpickin

https://github.com/coldbox-modules/cbq/blob/main/models/Jobs/DBBatchRepository.cfc#L109

This seems to get to a state of -1

Addional: {
DatabaseName: MySQL, 
DatabaseVersion: 5.7.26-0ubuntu0.18.04.1, 
Datasource: cstc_www_cstcclienttracker_com, 
DriverName: MySQL Connector/J, 
DriverVersion: mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf), 
SQL: UPDATE `cbq_batches` SET `failedJobIds` = '[]', `failedJobs` = 0, `pendingJobs` = -1 WHERE `id` = '10196D57-64FD-444C-A34FB5EE5566B35B'
},

Not sure the best way to solve this... maybe throw a min of 0 in there?
Or should we try to resolve the issue that gets us to this point?

Metadata

Metadata

Assignees

Labels

bugSomething isn't workinghelp wantedExtra attention is needed

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions