109 lines
2.4 KiB
Markdown
109 lines
2.4 KiB
Markdown
# 快速检查任务382
|
||
|
||
## 方法1: 使用MySQL命令行
|
||
|
||
```bash
|
||
mysql -u root -p fastadmin
|
||
```
|
||
|
||
然后执行：
|
||
|
||
```sql
|
||
-- 查看任务详情
|
||
SELECT
|
||
id,
|
||
user_id,
|
||
lover_id,
|
||
status,
|
||
error_msg,
|
||
created_at,
|
||
updated_at
|
||
FROM generation_task
|
||
WHERE id = 382\G
|
||
|
||
-- 查看payload详情
|
||
SELECT JSON_PRETTY(payload) FROM generation_task WHERE id = 382\G
|
||
```
|
||
|
||
## 方法2: 使用Python脚本（在lover目录下）
|
||
|
||
```bash
|
||
cd lover
|
||
python -c "
|
||
import sys
|
||
sys.path.insert(0, '.')
|
||
from sqlalchemy import create_engine, text
|
||
engine = create_engine('mysql+pymysql://root:rootx77@localhost:3306/fastadmin?charset=utf8mb4')
|
||
with engine.connect() as conn:
|
||
result = conn.execute(text('SELECT id, status, error_msg, payload FROM generation_task WHERE id = 382'))
|
||
row = result.fetchone()
|
||
if row:
|
||
print(f'任务ID: {row[0]}')
|
||
print(f'状态: {row[1]}')
|
||
print(f'错误信息: {row[2]}')
|
||
print(f'Payload: {row[3]}')
|
||
else:
|
||
print('任务不存在')
|
||
"
|
||
```
|
||
|
||
## 方法3: 使用HTTP API检查
|
||
|
||
```bash
|
||
# 获取任务状态
|
||
curl http://192.168.1.141:30101/sing/task/382
|
||
|
||
# 或者使用浏览器访问
|
||
http://192.168.1.141:30101/sing/task/382
|
||
```
|
||
|
||
## 方法4: 检查应用日志
|
||
|
||
在Windows PowerShell中：
|
||
|
||
```powershell
|
||
# 查找任务382相关的日志
|
||
Select-String -Path "lover\logs\*.log" -Pattern "任务 382" -Context 5,5
|
||
|
||
# 或者查找最近的错误日志
|
||
Select-String -Path "lover\logs\*.log" -Pattern "failed|error|exception" | Select-Object -Last 20
|
||
```
|
||
|
||
## 常见失败原因及解决方案
|
||
|
||
### 1. 用户视频生成次数不足
|
||
```sql
|
||
-- 检查用户剩余次数
|
||
SELECT id, mobile, video_gen_remaining
|
||
FROM user
|
||
WHERE id = (SELECT user_id FROM generation_task WHERE id = 382);
|
||
|
||
-- 如果需要，可以手动增加次数
|
||
UPDATE user
|
||
SET video_gen_remaining = video_gen_remaining + 10
|
||
WHERE id = (SELECT user_id FROM generation_task WHERE id = 382);
|
||
```
|
||
|
||
### 2. 内容安全审核失败
|
||
- 更换其他歌曲
|
||
- 检查恋人形象是否合规
|
||
- 查看分段视频的错误信息
|
||
|
||
### 3. DashScope API问题
|
||
- 检查API密钥是否有效
|
||
- 验证API配额是否充足
|
||
- 测试网络连接
|
||
|
||
### 4. 重试任务
|
||
```bash
|
||
# 使用API重试
|
||
curl -X POST http://192.168.1.141:30101/sing/retry/382 \
|
||
-H "Authorization: Bearer YOUR_TOKEN"
|
||
```
|
||
|
||
## 下一步
|
||
|
||
1. 先用方法3（HTTP API）快速查看任务状态
|
||
2. 如果需要详细信息，使用方法1（SQL查询）
|
||
3. 根据错误信息采取相应的解决措施
|