TLJH开发环境搭建失败：jupyterhub.service启动失败

问题现象 #

• 近期搭建TLJH开发环境时，运行bootstrap.py后服务器无法启动，访问localhost:12000显示“404 page not found”
• 1月23日前用相同方法构建的镜像可正常启动，1月27日重新构建镜像后出现异常，期间TLJH仓库无新提交记录
• 部署环境：Docker 20.10.21的Ubuntu 22.04主机容器内

错误日志详情 #

执行journalctl -u jupyterhub -f得到以下输出：

-- Logs begin at Mon 2023-01-30 12:44:34 UTC. --
Jan 30 12:44:41 87f857896c91 python3[64]:         raise exc.ArgumentError(msg, code=code) from err
Jan 30 12:44:41 87f857896c91 python3[64]:     sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [1]. Did you mean to say select(1)?
Jan 30 12:44:41 87f857896c91 python3[64]:     
Jan 30 12:44:41 87f857896c91 systemd[1]: jupyterhub.service: Main process exited, code=exited, status=1/FAILURE
Jan 30 12:44:41 87f857896c91 systemd[1]: jupyterhub.service: Failed with result 'exit-code'.
Jan 30 12:44:41 87f857896c91 systemd[1]: jupyterhub.service: Scheduled restart job, restart counter is at 5.
Jan 30 12:44:41 87f857896c91 systemd[1]: Stopped jupyterhub.service.
Jan 30 12:44:41 87f857896c91 systemd[1]: jupyterhub.service: Start request repeated too quickly.
Jan 30 12:44:41 87f857896c91 systemd[1]: jupyterhub.service: Failed with result 'exit-code'.
Jan 30 12:44:41 87f857896c91 systemd[1]: Failed to start jupyterhub.service.

无效尝试 #

根据日志中的SQLAlchemy报错，曾将SQLAlchemy从2.0.0降级至1.4.46并重新加载hub，但问题未得到解决。

有效解决方法 #

执行以下命令完成修复：

pip3 install --upgrade 'SQLAlchemy<2.0.0'
tljh-config reload hub

内容的提问来源于stack exchange，提问作者lonfo