postman发送请求后数据库表数据被清空
异常名称:无(发送查询请求数据库数据被清空)
异常分析:没有执行任何删除语句,没有调用任何删除接口,对数据库进行查询时出现清空数据库
异常原因:因同事对数据库字段进行增加后 未及时更新数据库DDL语句 导致数据库字段与请求字段不一致 ,因而导致此异常
异常详情:要执行的接口
@GetMapping("/xxxxx/xxxxx/sum")
public ResponseData getAuxiliaryPlanSum(@RequestParam(value = "saleOrderCode", required = false) String saleOrderCode,
@RequestParam(value = "orderNumber", required = false) String orderNumber,
@RequestParam(value = "materialTypeId", required = false) String materialTypeId,
@RequestParam(value = "plannedDeliveryStartTime", required = false) String plannedDeliveryStartTime,
@RequestParam(value = "plannedDeliveryEndTime", required = false) String plannedDeliveryEndTime,
@RequestParam(value = "materialCode", required = false) String materialCode,
@RequestParam(value = "materialIsComplete", required = false) Boolean materialIsComplete,
@RequestParam(value = "key", required = false) String key,
@RequestParam(value = "sort", required = false) String sort,
@RequestParam(value = "isLastSort", required = false) Boolean isLastSort,
@RequestParam(value = "current", defaultValue = "1") Integer current,
@RequestParam(value = "size", defaultValue = "1500") Integer size,
@RequestParam(value = "isConditionQuery", defaultValue = "true") Boolean isConditionQuery,
@RequestParam(value = "state", required = false) Integer state,
@RequestParam(value = "customerNames", required = false) String customerNames,
@RequestParam(value = "synchronizationTimeStartTime", required = false) String synchronizationTimeStartTime,
@RequestParam(value = "synchronizationTimeEndTime", required = false) String synchronizationTimeEndTime) {
TmpOrderAuxiliaryPlanSumVO vo = tmpOrderAuxiliaryPlanService.getAuxiliaryPlanSum(saleOrderCode, orderNumber, plannedDeliveryStartTime,
plannedDeliveryEndTime, materialCode, materialIsComplete, isLastSort, current, size, key, sort,
materialTypeId, isConditionQuery, state, customerNames, synchronizationTimeStartTime, synchronizationTimeEndTime);
return success(vo);
}
执行后导致数据库
解决方案:数据库及时更新DDL语句,新增字段
解决结果:成功
注意事项:切勿在生产环境出现此错误!!!!否则请及时跑路