重跑这3天的数据执行过程和遇到的问题:
①执行 sh siteKeyDataNew.sh 3 20140801 ;sh siteKeyData_AllSite.sh 3 20140801 ;
错误提示:
awk: cmd. line:39: fatal: cannot open file `../data_today/row_data_20140801*' for reading (No such file or directory)
awk: cmd. line:35: fatal: cannot open file `../data_today/row_data_20140801*' for reading (No such file or directory)Warning: fopen(../data_today/NEWSITE_PV_3_20140801): failed to open stream: No such file or directory in /data/clickflow/shell/siteKeyDataStoreNew.php on line 368
②从错误看出是缺原始数据的,查看/data/clickflow/data_today/ 目录 发现原始数据没了
③解决办法:从10.191.152.111 上拉取备份文件,重跑脚本;
④传送文件方法: 登陆111 , scp /data1/clickflow/row_data_20140801.tar.gz kamilzhou@10.206.8.75:/data/clickflow/data_today/
⑤解压备份文件: tar xvfz row_data_20140801.tar.gz
⑥执行①步骤
⑦流量来源报表查询0801,0810,0820,发现数据恢复正常,问题解决