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. 根据错误信息采取相应的解决措施
|