error when using SchedulerApp.db_url on mariadb server

[xntstack]

Hi, Using the configuration SchedulerApp.db_url = mariadb+mariadbconnector://... . If I create a new job I get the following error in the log: (mariadb.DataError) Out of range value for column 'update_time' at row 1. As a workaround I changed the column type to BIGINT instead of INT(11). Not only update_time, but I changed the *_time column type to make it work properly.

[welcome[bot]]

Thank you for opening your first issue in this project! Engagement like this is essential for open source projects! :hugs:
If you haven't done so already, check out Jupyter's Code of Conduct. Also, please try to follow the issue template as it helps other other community members to contribute more effectively. You can meet the other Jovyans by joining our Discourse forum. There is also an intro thread there where you can stop by and say Hi! :wave:
Welcome to the Jupyter community! :tada:

[3coins]

@xntstack Thanks for opening this issue. Do you want to submit this change in a PR? I can check afterwards that this doesn't break for existing users with the SQLite database.

[xntstack]

Hi @3coins For now, I've only applied sql code manually, changing the types of the columns that threw the error. I haven't changed the orm part yet except for a small fix that concerned the connection to the database: https://github.com/jupyter-server/jupyter-scheduler/compare/main...anto-progetica:jupyter-scheduler:main Without this modification, the connection with the database is often interrupted generating an error.