滨海园区平台上报程序启动报错问题处理

问题描述:园区sql有人给改了导致上报服务无法启动

解决办法:
1.进入目录,尝试启动查看日志

  1. #进入上报程序目录
  2. cd /home/seekcy/data-upload-mid
  3. #执行启动命令
  4. ./service-server.sh
  5. #查看日志
  6. tail -f logs/info.log

2.如果日志报错如下图,则说明是这个问题

3.执行sql

  1. #连接mysql
  2. mysql -uroot -pPassword2017
  3. #执行sql
  4. delete from data_upload_mid.common_flyway_schema_history where script = 'V20260513_1600__xinjiangxinlianxin_init.sql';
  5. delete from data_upload_mid.common_platform where id >= (
  6. select t.min_id from (
  7. select min(id) as min_id from data_upload_mid.common_platform where identity = 'xinjiang_xinlianxin'
  8. ) t
  9. );

4.再次尝试重启服务

  1. ./service-server.sh

转载请注明作者和出处,并添加本页链接。
原文链接: //svn.seekcy.com/919