ql -l check报错，导致rmlog进程退出，无法正常删除日志

[cjh19831115]

root@qinglong:/ql $ ql -l check

开始执行... 2023-03-14 12:07:05

=====> 开始检测

changed 1 package in 8s

1 package is looking for funding
run npm fund for details
Writing to /root/.config/pip/pip.conf
 WARN  deprecated [email protected]: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details.
Already up to date
Progress: resolved 209, reused 123, downloaded 0, added 0, done
 WARN  tslib has no binaries
 WARN  Issues with peer dependencies found
.
└─┬ ts-node 10.9.1
└── ✕ missing peer @types/node@""
Peer dependencies that should be installed:
@types/node@""

Done in 23.2s
=====> 启动公开服务

---> 1. 复制通知文件

---> 复制一份 /ql/sample/notify.py 为 /ql/data/scripts/notify.py

'/ql/sample/notify.py' -> '/ql/data/scripts/notify.py'

---> 复制一份 /ql/sample/notify.js 为 /ql/data/scripts/sendNotify.js

'/ql/sample/notify.js' -> '/ql/data/scripts/sendNotify.js'
---> 通知文件复制完成

---> 2. 复制nginx配置文件

'/ql/docker/nginx.conf' -> '/etc/nginx/nginx.conf'
'/ql/docker/front.conf' -> '/etc/nginx/conf.d/front.conf'
---> 配置文件复制完成

=====> 检测面板

<script src="https://gw.alipayobjects.com/os/lib/react/18.2.0/umd/react.production.min.js"></script> <script src="https://gw.alipayobjects.com/os/lib/react-dom/18.2.0/umd/react-dom.production.min.js"></script>

<script src="./umi.fbc80036.js"></script>

=====> 面板服务启动正常

=====> 检测nginx服务
94 root 0:00 nginx: master process nginx -c /etc/nginx/nginx.conf
18983 root 0:00 nginx: worker process
18984 root 0:00 nginx: worker process
18985 root 0:00 nginx: worker process
18986 root 0:00 nginx: worker process

=====> nginx服务正常

---> pm2日志
2023-03-14T12:03:15: parent: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:15: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:15: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:15: errno: 1,
2023-03-14T12:03:15: code: 'SQLITE_ERROR',
2023-03-14T12:03:15: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jd_redrain_half_983/2023-03-13-22-30-02-505.log' AND Crontab.t = '1678766595' LIMIT 1;"
2023-03-14T12:03:15: },
2023-03-14T12:03:15: original: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:15: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:15: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:15: errno: 1,
2023-03-14T12:03:15: code: 'SQLITE_ERROR',
2023-03-14T12:03:15: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jd_redrain_half_983/2023-03-13-22-30-02-505.log' AND Crontab.t = '1678766595' LIMIT 1;"
2023-03-14T12:03:15: },
2023-03-14T12:03:15: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jd_redrain_half_983/2023-03-13-22-30-02-505.log' AND Crontab.t = '1678766595' LIMIT 1;",
2023-03-14T12:03:15: parameters: {}
2023-03-14T12:03:15: }
2023-03-14T12:03:16: error: 🔥 error: Error:
2023-03-14T12:03:16: at Database. (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:236:27)
2023-03-14T12:03:16: at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:50
2023-03-14T12:03:16: at new Promise ()
2023-03-14T12:03:16: at Query.run (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:12)
2023-03-14T12:03:16: at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/sequelize.js:649:28
2023-03-14T12:03:16: at SQLiteQueryInterface.select (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:12)
2023-03-14T12:03:16: at Function.findAll (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1816:21)
2023-03-14T12:03:16: at Function.findOne (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1982:12)
2023-03-14T12:03:16: at CronService.find (/ql/back/services/cron.ts:269:22)
2023-03-14T12:03:16: at /ql/back/api/cron.ts:161:22 {
2023-03-14T12:03:16: [stack]: 'Error: \n' +
2023-03-14T12:03:16: ' at Database. (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:236:27)\n' +
2023-03-14T12:03:16: ' at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:50\n' +
2023-03-14T12:03:16: ' at new Promise ()\n' +
2023-03-14T12:03:16: ' at Query.run (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:12)\n' +
2023-03-14T12:03:16: ' at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/sequelize.js:649:28\n' +
2023-03-14T12:03:16: ' at SQLiteQueryInterface.select (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:12)\n' +
2023-03-14T12:03:16: ' at Function.findAll (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1816:21)\n' +
2023-03-14T12:03:16: ' at Function.findOne (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1982:12)\n' +
2023-03-14T12:03:16: ' at CronService.find (/ql/back/services/cron.ts:269:22)\n' +
2023-03-14T12:03:16: ' at /ql/back/api/cron.ts:161:22',
2023-03-14T12:03:16: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:16: name: 'SequelizeDatabaseError',
2023-03-14T12:03:16: parent: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:16: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:16: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:16: errno: 1,
2023-03-14T12:03:16: code: 'SQLITE_ERROR',
2023-03-14T12:03:16: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-02-30-01-961.log' AND Crontab.t = '1678766596' LIMIT 1;"
2023-03-14T12:03:16: },
2023-03-14T12:03:16: original: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:16: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:16: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:16: errno: 1,
2023-03-14T12:03:16: code: 'SQLITE_ERROR',
2023-03-14T12:03:16: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-02-30-01-961.log' AND Crontab.t = '1678766596' LIMIT 1;"
2023-03-14T12:03:16: },
2023-03-14T12:03:16: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-02-30-01-961.log' AND Crontab.t = '1678766596' LIMIT 1;",
2023-03-14T12:03:16: parameters: {}
2023-03-14T12:03:16: }
2023-03-14T12:03:17: error: 🔥 error: Error:
2023-03-14T12:03:17: at Database. (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:236:27)
2023-03-14T12:03:17: at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:50
2023-03-14T12:03:17: at new Promise ()
2023-03-14T12:03:17: at Query.run (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:12)
2023-03-14T12:03:17: at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/sequelize.js:649:28
2023-03-14T12:03:17: at SQLiteQueryInterface.select (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:12)
2023-03-14T12:03:17: at Function.findAll (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1816:21)
2023-03-14T12:03:17: at Function.findOne (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1982:12)
2023-03-14T12:03:17: at CronService.find (/ql/back/services/cron.ts:269:22)
2023-03-14T12:03:17: at /ql/back/api/cron.ts:161:22 {
2023-03-14T12:03:17: [stack]: 'Error: \n' +
2023-03-14T12:03:17: ' at Database. (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:236:27)\n' +
2023-03-14T12:03:17: ' at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:50\n' +
2023-03-14T12:03:17: ' at new Promise ()\n' +
2023-03-14T12:03:17: ' at Query.run (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/sqlite/query.js:234:12)\n' +
2023-03-14T12:03:17: ' at /ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/sequelize.js:649:28\n' +
2023-03-14T12:03:17: ' at SQLiteQueryInterface.select (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:12)\n' +
2023-03-14T12:03:17: ' at Function.findAll (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1816:21)\n' +
2023-03-14T12:03:17: ' at Function.findOne (/ql/node_modules/.pnpm/sequelize@6.28.0_@whyour[email protected]/node_modules/sequelize/src/model.js:1982:12)\n' +
2023-03-14T12:03:17: ' at CronService.find (/ql/back/services/cron.ts:269:22)\n' +
2023-03-14T12:03:17: ' at /ql/back/api/cron.ts:161:22',
2023-03-14T12:03:17: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:17: name: 'SequelizeDatabaseError',
2023-03-14T12:03:17: parent: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:17: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:17: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:17: errno: 1,
2023-03-14T12:03:17: code: 'SQLITE_ERROR',
2023-03-14T12:03:17: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-09-30-02-612.log' AND Crontab.t = '1678766597' LIMIT 1;"
2023-03-14T12:03:17: },
2023-03-14T12:03:17: original: [Error: SQLITE_ERROR: no such column: Crontab.t] {
2023-03-14T12:03:17: [stack]: 'Error: SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:17: [message]: 'SQLITE_ERROR: no such column: Crontab.t',
2023-03-14T12:03:17: errno: 1,
2023-03-14T12:03:17: code: 'SQLITE_ERROR',
2023-03-14T12:03:17: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-09-30-02-612.log' AND Crontab.t = '1678766597' LIMIT 1;"
2023-03-14T12:03:17: },
2023-03-14T12:03:17: sql: "SELECT id, name, command, schedule, timestamp, saved, status, isSystem, pid, isDisabled, isPinned, log_path, labels, last_running_time, last_execution_time, sub_id, createdAt, updatedAt FROM Crontabs AS Crontab WHERE Crontab.log_path = '/hyzaw_AllJDScripts_master_jx_sign_xd_545/2023-03-13-09-30-02-612.log' AND Crontab.t = '1678766597' LIMIT 1;",
2023-03-14T12:03:17: parameters: {}
2023-03-14T12:03:17: }
2023-03-14T12:03:51: info: [任务退出] ql rmlog 1 进程id: 20285，退出码 0

=====> 检测后台

{"code":401,"message":"jwt malformed"}

=====> 后台服务启动正常

启动面板服务

启动定时任务服务