balena devices that were connecting to the VPN were unable to report their VPN connectivity status to balenaCloud. This was because the auto-incrementing ID of a database table related to device connectivity had reached its limit, which prevented the balenaCloud backend from recording new connectivity events. Devices that were already connected to balenaCloud were not affected.
To address this issue, we performed emergency database maintenance to change the data type of the column and allow for a larger limit on the auto-incrementing ID. We also checked other database tables to determine which columns need modification and will schedule a separate maintenance activity to preemptively modify these tables.