131 lines
4.4 KiB
Markdown
131 lines
4.4 KiB
Markdown
# 500 错误排查指南
|
||
|
||
## 问题描述
|
||
导入省份数据时出现 500 Internal Server Error
|
||
|
||
## 可能的原因和解决方案
|
||
|
||
### 1. 数据库表未创建
|
||
|
||
**检查步骤：**
|
||
```sql
|
||
-- 连接到数据库
|
||
USE cattleTends;
|
||
|
||
-- 检查表是否存在
|
||
SHOW TABLES LIKE 'cattleprovince';
|
||
SHOW TABLES LIKE 'cattlenational';
|
||
```
|
||
|
||
**如果表不存在，执行以下 SQL：**
|
||
|
||
#### 创建 cattleprovince 表
|
||
```sql
|
||
CREATE TABLE IF NOT EXISTS cattleprovince (
|
||
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
|
||
province VARCHAR(255) NOT NULL UNIQUE COMMENT '省份名称',
|
||
province_price DECIMAL(10, 2) COMMENT '省份均价',
|
||
inventory_23th INT COMMENT '23年存栏（万头）',
|
||
slaughter_23th INT COMMENT '23年出栏（万头）',
|
||
inventory_24th INT COMMENT '24年存栏（万头）',
|
||
slaughter_24th INT COMMENT '24年出栏（万头）',
|
||
inventory_25th INT COMMENT '25年存栏（万头）',
|
||
slaughter_25th INT COMMENT '25年出栏（万头）',
|
||
create_time DATETIME COMMENT '创建时间',
|
||
up_time DATETIME NOT NULL COMMENT '更新时间'
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='省份数据表';
|
||
|
||
-- 添加索引
|
||
CREATE INDEX idx_province_name ON cattleprovince(province);
|
||
CREATE INDEX idx_province_price ON cattleprovince(province_price);
|
||
CREATE INDEX idx_inv_23 ON cattleprovince(inventory_23th);
|
||
CREATE INDEX idx_sla_23 ON cattleprovince(slaughter_23th);
|
||
CREATE INDEX idx_inv_24 ON cattleprovince(inventory_24th);
|
||
CREATE INDEX idx_sla_24 ON cattleprovince(slaughter_24th);
|
||
CREATE INDEX idx_inv_25 ON cattleprovince(inventory_25th);
|
||
CREATE INDEX idx_sla_25 ON cattleprovince(slaughter_25th);
|
||
```
|
||
|
||
#### 创建 cattlenational 表
|
||
```sql
|
||
CREATE TABLE IF NOT EXISTS cattlenational (
|
||
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
|
||
national_inventory_23th INT COMMENT '23年全国存栏量（15个省份存栏量的总和）',
|
||
national_slaughter_23th INT COMMENT '23年全国出栏量（15个省份出栏量的总和）',
|
||
national_inventory_24th INT COMMENT '24年全国存栏量（15个省份存栏量的总和）',
|
||
national_slaughter_24th INT COMMENT '24年全国出栏量（15个省份出栏量的总和）',
|
||
national_inventory_25th INT COMMENT '25年全国存栏量（15个省份存栏量的总和）',
|
||
national_slaughter_25th INT COMMENT '25年全国出栏量（15个省份出栏量的总和）',
|
||
create_time DATETIME COMMENT '创建时间',
|
||
up_time DATETIME NOT NULL COMMENT '更新时间'
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='全国总量数据表';
|
||
|
||
-- 添加索引
|
||
CREATE INDEX idx_national_inv_23 ON cattlenational(national_inventory_23th);
|
||
CREATE INDEX idx_national_sla_23 ON cattlenational(national_slaughter_23th);
|
||
CREATE INDEX idx_national_inv_24 ON cattlenational(national_inventory_24th);
|
||
CREATE INDEX idx_national_sla_24 ON cattlenational(national_slaughter_24th);
|
||
CREATE INDEX idx_national_inv_25 ON cattlenational(national_inventory_25th);
|
||
CREATE INDEX idx_national_sla_25 ON cattlenational(national_slaughter_25th);
|
||
```
|
||
|
||
### 2. 查看后端日志
|
||
|
||
**检查后端日志文件：**
|
||
```bash
|
||
# 如果使用 start.sh 启动
|
||
tail -f log.out
|
||
|
||
# 或者查看 Spring Boot 控制台输出
|
||
```
|
||
|
||
**常见错误信息：**
|
||
- `Table 'cattleTends.cattleprovince' doesn't exist` - 表不存在
|
||
- `Table 'cattleTends.cattlenational' doesn't exist` - 表不存在
|
||
- `Could not resolve placeholder` - 配置问题
|
||
- `No bean found` - 依赖注入问题
|
||
|
||
### 3. 检查后端服务是否正常运行
|
||
|
||
```bash
|
||
# 检查服务是否运行
|
||
ps aux | grep java | grep cattletends
|
||
|
||
# 检查端口是否监听
|
||
netstat -tlnp | grep 12240
|
||
```
|
||
|
||
### 4. 重新编译和重启
|
||
|
||
```bash
|
||
cd backend
|
||
mvn clean package
|
||
./start.sh restart
|
||
```
|
||
|
||
### 5. 测试接口
|
||
|
||
```bash
|
||
# 测试获取省份数据接口
|
||
curl http://localhost:12240/api/cattle-data/provinces
|
||
|
||
# 测试获取全国总量接口
|
||
curl http://localhost:12240/api/cattle-data/national
|
||
```
|
||
|
||
## 快速修复步骤
|
||
|
||
1. **确保数据库表已创建**（执行上面的 SQL）
|
||
2. **重新编译后端**：`cd backend && mvn clean package`
|
||
3. **重启服务**：`./start.sh restart`
|
||
4. **查看日志**：`tail -f log.out`
|
||
5. **重新尝试导入**
|
||
|
||
## 如果问题仍然存在
|
||
|
||
请提供以下信息：
|
||
1. 后端日志的完整错误信息
|
||
2. 数据库表是否已创建（执行 `SHOW TABLES;`）
|
||
3. Excel 文件的格式（列数、数据类型）
|
||
|