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语句,新增字段

解决结果:成功

注意事项:切勿在生产环境出现此错误!!!!否则请及时跑路