14:58:03,049 DEBUG com.pan.util.socket.SocketServerSession: Client /127.0.0.1:5840 连接成功。 14:58:03,049 DEBUG com.pan.util.socket.SocketServerSession: 已连接,开始InputStream解析...... 14:58:03,054 DEBUG com.pan.util.socket.SocketServerSession: InputStream中数据长度:189 14:58:03,054 DEBUG com.pan.util.socket.SocketServerSession: Socket 接收数据长度:189. >> 内容:<ROOT Version="1"><REQUEST>CHECK_TIME</REQUEST><DATAS><DATA WORKSTART_TIME="07:00:00" WORKEND_TIME="21:00:00" /></DATAS><SESSION>bps102</SESSION><TIMESTAMP>20130718145803</TIMESTAMP></ROOT> 14:58:03,060 DEBUG com.pan.soms.door.socketdoor.protocol.impl.CheckTime2: 数据开始处理 14:58:03,061 DEBUG com.pan.soms.door.socketdoor.protocol.impl.CheckTime2: 开始处理取号机校时数据... 14:58:03,071 DEBUG com.pan.soms.door.socketdoor.SocketUtil: 向客户端回复:<ROOT><RESPONSE>CHECK_TIME</RESPONSE><STATUS>0</STATUS><TIMESTAMP>20130718145803</TIMESTAMP></ROOT> 14:58:03,071 DEBUG com.pan.soms.door.socketdoor.SocketUtil: OutputStream.Close suessed. 14:58:03,071 DEBUG com.pan.util.socket.SocketServerSession: 客户端 /127.0.0.1:5840 信息处理完成。 14:58:03,140 DEBUG com.pan.util.socket.SocketServerSession: Client /127.0.0.1:5841 连接成功。 14:58:03,140 DEBUG com.pan.util.socket.SocketServerSession: 已连接,开始InputStream解析...... 14:58:03,140 DEBUG com.pan.util.socket.SocketServerSession: InputStream中数据长度:4981
14:58:03,141 DEBUG com.pan.util.socket.SocketServerSession: Socket 接收数据长度:4981. >> 内容:<ROOT Version="1"><REQUEST>REGIST2</REQUEST><DATAS><DATA><![CDATA[UEsDBBQAAAgIAEF38kIlRTMt3AAAAFQBAAAOAAAAYnJhbmNocGFyYS54bWyzsa/IzVEoSy0qzszPs1Uy1DNQUiguScxLSczJz0u1VapMLVayt+PlsnEqSsxLzghILEp0zs9Ly0wHiikoIImC+UARx6JUoIqUVDsDAzNDYwsbfbgAVAFEi6eLXVJBsaGBkY0+XABFgV9ibqrdiwlLn+yY9bSvVRdVMVgSqjwwDOJ4O1M9Sz1DYwMzPQtzc6C9cHGYOpfUstSc/AKgqN3TnulPdq15unPz03WdT7tmP53Q8Xz5xGddDU/7Jz7dOPXZnM6XMyc8bV3ztH8H0BwkfWA/66N4GpkLDRkAUEsDBBQAAAgIAEF38kKyWrjMbQIAAP8KAAAQAAAAY291bnRlcmluZm9zLnhtbOVWS27bMBDdF+gdBK5tSZa9MiQHrbMxGrsfp0m3tDSxiUikyk8lnyIXKNArdNcTpeco9bE+kBPbiFcNvBE5bx4fH2aGdi/SKDR+ABeEUQ8NTBsZQmIa4JBR8NAWBLqYvH3jLiC5xBIvQeqVYbipGAt/AxE2SOChOooMTUiFh8qPcaq/N1LGY8tKksRMhibja8ux7YH1bX61zDl22EgEmsVDitOSXfQj4nMm2J3s+ywaa1y/QKFcR6EEQoiASoPiCNpiCux4JsodD0muoNqfY0KzyDVehTpzyhSVwGf0jokK81XAVHGu+a+YjzNYTlEeXwjQ0uIQ0uttDNV+Gdkw4oMREfrR9xXXZmiHI5zuVoqu9KEBBKiRuO9WLW0t7HMS6riA7wqo3w3uO2ymFaXIkJrMQzpKaOZl6w7WUUQ71UGDTEhO6PpFfAu9OC/jDYFkoaIV8DPxXpIs25d7Hdgw/kJD43dBwEGIM6n9guka6prPeyLn/YRp1nzm9PN8ab7HAsxbjuMYuHnL+H2eNmVhCL7UA6RndOA946YcLraZ/3rGVIVScfAoKMlxqJPUKiT+B9hes3ugHlVh2LgWpttMyuF7udbTZZ7HnmqRPFj60Wxfq+rfutn383QYCi35CCvWzfbdJeVdNhm4VvFR7lYFM1nFYmA7eu4B7+t56Vp1qI3N2mFiDx4f/vz99fPx4XeFzANtbF3okwZlY7eEd+o3E9rdLNFF/VQjnxye+X1Cs4fGh/qhCI55KazS346hz1jsHGmxc8hi52SLnVdi8fBIi4eHLB6ebPHwlVg8OtLi0SGLRydbPPp/LHatxl/Zf1BLAwQUAAAICABBd/JCl2nODtICAADiCQAADAAAAHVzZXJpbmZvLnhtbN1W3W7TMBS+R+IdotzSJHbSrWvUdBKdhKb9UGhh3LrJ6RYtsYvt0PYREGjifkLiBbhHg8fZQLwFzk/TlK5bhSokUCvFPufz53O++ByntTuJI+0NcBEy6unYRLomJKEBiRgFT5+C0HfbDx+0Xgjg+3TIOowOw1Nl0bTWRLjCP4OYaGHg6YsIXVPEVHh6MXAnanwm5ci1rPF4bI4dk/FTy0YIW6+ODnsZzwwbi4BI4ukJp8UOwohDnzPBhtLwWewqnJGj9CyWPBqIIAYqNUpiWA4ox7v7Yk89eiA9XfIESvsRCWnq6ZNBpFafhDQlKN1q0kk4V/SHzCcpIltd7J7vryIbRTDpT0dQ2gvPGQt90OKQPvX9hCstlNAxmcxmCR2whAYQ6JWFtyU1C2sBdtfuc7+A1wlQf9m5Urw9XZOKzdPT1ZKHNFVxIQVrbbJjNdoQ3XESD9I3sxGyLhFizHiwIboeTMojk52mjPQJEGqecDIaATe7qtoYVcCaltkPwwEnfFrTXhZlaJvYrDdx08Q7jo1qWieJZMLBo5BITqKa1k0GUegfwLTPzoF6NImiSviETtNd/yz+54SeqppfTqFLaFp9ZufZUc98TASU+Zwwfp4t67AoAl+qFFSIv8Pn6SEz+/3dvDociISgHy6cQpUj5Kb7OFvW6grKfKuqL3MWsVSbglV2hXkLuZ1niSGPJeuL+bxoCjN8XrvtwUhgZBtCDocGVn22ZRWOCiytyvbNt0/XX97m7sxQAPI6a+dri0nhmlVNqVRLnee2oXDpszDlZ6ns/+H9F4AR0vT28WF+awTrXBtlFJXX3LYRdgy0bdhY4oZrb7l1bGLUrGPUeIR2XIRaVhWeK1uVcj1d7ZW6fv94cXN5eZeu9r+ra8PASlfk4m31N22niRzsbFJXZ6WuPy7eXV+9/3n19ebzh7vUdf4Lde26ibbtncbWWuoWos2/1H4BUEsDBBQAAAgIAEF38kKMmMWizgMAABoZAAAOAAAAd2ludHlwZWFsbC54bWztmVtvG0UUx9+R+A6rfbb3Zie+yHalOohajaHg0CBVlZjdPXFGmZ01M7PE7lN5KCBe4AFFiDcQ4ikIIUW0VS+fpg7hWzB78a6N02kCrlQiK5E9M+fMf86c+e3Zkdy6Ng6I9hkwjkPa1m3D0jUuEPURCSm09Qlw/Vrn7bdau5juTEbQDekeHsoBTWuNeZN7+xAgDfttfcFB16Qs5W09azTHsr0vxKhpmoeHh8ZhxQjZ0HQsyzY/7m8PEpmZb8B9JFBbjxjNFuDlAHss5OGeKHth0JR+5dRLT0JJgwECAVChURTAUjype7PHt+TXAERbFyyCfLyPMI0tO8glxeTc/BGHbsSYVN8OPRR7JLOzxdPlZWAjAuN4Xj6eWfZD7IEWYPq+50VMpkJmOUDjWS+ibhhRH3x9bqJiT4tuqtULO4dPI6DesvG8dXq+rgmp1NbjmYJhGmdwIXzzQkLvRYELbFVi8nNFUl1EyA1Aq9rmLRYOGXDek4c4XpHmDvYOQKQJHAjExJxuRDkeUvAH+2E8/l/l36H+asU/RHQoC8fs6UkerET+FqLxQ2x0P+gPjOuIg7HL0GgEzNgN2UEyrRsSAp6Q5aikLbmXtNtZqbKM5K+kdSMiIgZtCpFgiMhJkUuwdxMmO+EB0DaNCJnbHaKT7Mn+F/vq0b0wQHFsKzrkLRAIk/My9S4gahS54MYAGEYE34sLVB+NPnHu3BlMuIDAGCQBlKSGFzKC3SJJ1Ysmya3V0Ia3sWk3KlWw6o27pdcpfrekJdvbxi5DbFJIOoZtVBt2w7DrFec1nm3LfHlFTGwvq6aJMTvC+SJv5lW+eCWcr7OkkMaSvObSflbkZ/5Zt7fVcUfctpyyG42gbNkts7BkrunT3IltWXNRIy6gnenT+399d//0q4e5QDKcec4KYwe1zLyd2ZYqUkcutDx4jrcsMJ1Go7HoHQ9mvmm9yK8K+NV3hTKm8TXFg+KC4V/ghlGcTl5v5o/xOgwx7TiWXSlbtbJtC6vetCz53zJT05xvHP6cp+PMPIt9JX59NL6NSARpAvJegck/I2mZaTpm3aLoZCTnB3cZXhwFL46Kl7Nnx2cnv5z+/uXp8XM1Mu4amcshY7/ZyFQUyFRUyPz57RdnJz+pYfHWsFwKFrv+ZsNSVcBSVcLy9OTs5LEaFn8Ny5WCZUMBy4by8vLr99Nvjl75JoI1L1eKl00FL5tKXn4+mj76XA3L3hqWKwVLTQFLTQnLb4+nD45fPPph+vWPamSGa2SuFDJ1BTJ1JTIP/njx5EgNy701LP8HWPJ29hPH31BLAwQUAAAICABBd/JCpYPBXA4CAABLBgAAFQAAAFdpblR5cGVHcm91cEluZm9zLnhtbK2VbW/aMBDH30/ad7D8GhxY23VFZJVKpQkNum6wdVJVaY5zBat+oH4o5NvPMQHSAVOFUKTI9t39/L+Tz+5eLqRAL2As1yrFbdLCyDqqciq0ghQXYPHl5/fvujcwv6aOjsCFGULdhe1YNgVJEc9TvLFiFIDKprgadBZhPHVu1kmS+XxO5idEm0nyodVqJ7+Hg1FkrHylzQMlxd6oim6bkjOjrX50TaZlJ/g1l1446lgqAQESlEOKSngtZunb6dtqJcXOeFivDylXpWVMMxEir7zlCqwdFzPoUQcTbYpoWgf8tNDzxoTNBprRMibyKi1LNUHnTMCihKzXK8tUcwZIcvWNMW9CZUK5JV2sZl5l2qscclwL3JXifqGvAv+nZ2O38OxBsW3jrp37OUYukFJcRjrD1QT/k1DyJtBN+B8L5WUG5kiwAbyAqLG4coeBbml5TI5Wrx9UTUIzrg5iPLWRe0tV2R6k9304IlfUArkzdDYDQ+60eYphPS0EMBdavIG23BvoV9X+LRK/Bup54byBVIF3hooQ5DPB2VcoxvoJVKq8qJeIqqKUclhe9aPcz3clOCqsA0k2SVjyBRQYzsiAW/enfX9fuYxifRsBwbQRPNukdvrW1LLzc3rGzj62L05OofXp4uHhqLhDqtZN9jdptO1r8Gisql2/iZL1VbS5t3ZztghLLfFqLl+FpPYs/AVQSwECMwAUAAAICABBd/JCJUUzLdwAAABUAQAADgAAAAAAAAAAAAAAAAAAAAAAYnJhbmNocGFyYS54bWxQSwECMwAUAAAICABBd/JCslq4zG0CAAD/CgAAEAAAAAAAAAAAAAAAAAAIAQAAY291bnRlcmluZm9zLnhtbFBLAQIzABQAAAgIAEF38kKXac4O0gIAAOIJAAAMAAAAAAAAAAAAAAAAAKMDAAB1c2VyaW5mby54bWxQSwECMwAUAAAICABBd/JCjJjFos4DAAAaGQAADgAAAAAAAAAAAAAAAACfBgAAd2ludHlwZWFsbC54bWxQSwECMwAUAAAICABBd/JCpYPBXA4CAABLBgAAFQAAAAAAAAAAAAAAAACZCgAAV2luVHlwZUdyb3VwSW5mb3MueG1sUEsFBgAAAAAFAAUAMwEAANoMAAAAAA==]]></DATA></DATAS><SESSION>bps102</SESSION><TIMESTAMP>20130718145803</TIMESTAMP></ROOT> 14:58:03,144 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: 数据开始处理 14:58:03,145 INFO com.pan.soms.door.socketdoor.protocol.impl.Regist2: 开始处理取号机注册数据... 14:58:03,170 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: 通过ZIP文件解压获得文件包中的所有xml文件个数：5 14:58:03,170 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: PRegist2.processing() >>> branchpara.xml >>> E:\work\workspace\Src\branches\shandongyouchu\com.pan.soms\bin\SOMS\store\temp\673394c4-ed30-4f01-93f4-75433bad39d1\branchpara.xml 14:58:03,181 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: PRegist2.processing() >>> counterinfos.xml >>> E:\work\workspace\Src\branches\shandongyouchu\com.pan.soms\bin\SOMS\store\temp\673394c4-ed30-4f01-93f4-75433bad39d1\counterinfos.xml 14:58:03,198 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: PRegist2.processing() >>> userinfo.xml >>> E:\work\workspace\Src\branches\shandongyouchu\com.pan.soms\bin\SOMS\store\temp\673394c4-ed30-4f01-93f4-75433bad39d1\userinfo.xml 14:58:03,214 DEBUG com.pan.permission.dal.impl.PersonDal: Update XPath://person[@id='bps102'] 14:58:03,219 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: PRegist2.processing() >>> wintypeall.xml >>> E:\work\workspace\Src\branches\shandongyouchu\com.pan.soms\bin\SOMS\store\temp\673394c4-ed30-4f01-93f4-75433bad39d1\wintypeall.xml 14:58:03,261 DEBUG com.pan.permission.dal.impl.StationDal: Update XPath://station[@id='bps102'] 14:58:03,265 DEBUG com.pan.soms.door.socketdoor.protocol.impl.Regist2: PRegist2.processing() >>> WinTypeGroupInfos.xml >>> E:\work\workspace\Src\branches\shandongyouchu\com.pan.soms\bin\SOMS\store\temp\673394c4-ed30-4f01-93f4-75433bad39d1\WinTypeGroupInfos.xml 14:58:03,267 DEBUG com.pan.permission.dal.impl.StationDal: Update XPath://station[@id='bps102'] 14:58:03,274 DEBUG com.pan.soms.door.socketdoor.SocketUtil: 向客户端回复:<ROOT><RESPONSE>REGIST2</RESPONSE><STATUS>0</STATUS><DATA><COUNTERS><COUNTER NUMBER="01" ID="bps102-coer-001"/><COUNTER NUMBER="02" ID="bps102-coer-002"/><COUNTER NUMBER="03" ID="bps102-coer-003"/><COUNTER NUMBER="04" ID="bps102-coer-004"/></COUNTERS><PERSONS><PERSON NUMBER="1001" ID="bps102-stff-1001"/><PERSON NUMBER="1002" ID="bps102-stff-1002"/><PERSON NUMBER="1003" ID="bps102-stff-1003"/></PERSONS><OPERATIONS><OPERATION NUMBER="01" ID="d48b166c292035a7e53720afe8376aad"/><OPERATION NUMBER="02" ID="6215a1f393660cfd3ebe7c56d2247864"/><OPERATION NUMBER="03" ID="a5b437b191ce8a5515bf4cec5550abe5"/><OPERATION NUMBER="04" ID="cb0583b151794ce42b91af1d1dd1689e"/><OPERATION NUMBER="05" ID="e71fe863194d77999fbff51eabe36562"/><OPERATION NUMBER="06" ID="9b35244a410074e36aacdd829a95a7d3"/><OPERATION NUMBER="07" ID="750a6399127e506141c38a62c22d3074"/><OPERATION NUMBER="08" ID="0d98c74797e49d00bcc4c17c9d557a2b"/></OPERATIONS><BRANCH NUMBER="bps102" ID="bps102"/><OPERATIONGROUPS/></DATA><TIMESTAMP>20130718145803</TIMESTAMP></ROOT> 14:58:03,275 DEBUG com.pan.soms.door.socketdoor.SocketUtil: OutputStream.Close suessed. 14:58:03,275 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:AvgServiceTime_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,287 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC AvgServiceTime_bps102 14:58:03,458 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM AvgServiceTime_bps102 14:58:03,460 DEBUG com.pan.soms.cache.dal.CacheDal: AvgServiceTime_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,460 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:AvgServiceTime_bps102字段成功. 14:58:03,461 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:AvgWaitTime_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,461 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC AvgWaitTime_bps102 14:58:03,518 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM AvgWaitTime_bps102 14:58:03,520 DEBUG com.pan.soms.cache.dal.CacheDal: AvgWaitTime_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,520 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:AvgWaitTime_bps102字段成功. 14:58:03,520 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEffeService_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,523 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEffeService_bps102 14:58:03,575 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEffeService_bps102 14:58:03,576 DEBUG com.pan.soms.cache.dal.CacheDal: IncEffeService_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,577 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEffeService_bps102字段成功. 14:58:03,577 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEffeWait_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,585 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEffeWait_bps102 14:58:03,625 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEffeWait_bps102 14:58:03,626 DEBUG com.pan.soms.cache.dal.CacheDal: IncEffeWait_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,627 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEffeWait_bps102字段成功. 14:58:03,627 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEval_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,628 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEval_bps102 14:58:03,670 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEval_bps102 14:58:03,672 DEBUG com.pan.soms.cache.dal.CacheDal: IncEval_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,673 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEval_bps102字段成功. 14:58:03,673 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalLevel1_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,674 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalLevel1_bps102 14:58:03,696 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalLevel1_bps102 14:58:03,697 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel1_bps102表中有索引:["id","multiid","day","week","month","season","year","leak","customerlevel"] 14:58:03,698 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalLevel1_bps102字段成功. 14:58:03,698 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalLevel2_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:03,700 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel2_bps102,不存在，创建表IncEvalLevel2_bps102,SQL:CREATE TABLE IncEvalLevel2_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:03,762 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalLevel2_bps102 14:58:03,809 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalLevel2_bps102 14:58:03,832 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel2_bps102表中有索引:["id"] 14:58:03,896 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 multiid 添加索引成功 14:58:03,990 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 day 添加索引成功 14:58:04,062 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 week 添加索引成功 14:58:04,108 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 month 添加索引成功 14:58:04,181 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 season 添加索引成功 14:58:04,235 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 year 添加索引成功 14:58:04,298 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 leak 添加索引成功 14:58:04,352 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel2_bps102 中字段 customerlevel 添加索引成功 14:58:04,353 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalLevel2_bps102字段成功. 14:58:04,353 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalLevel3_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:04,355 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel3_bps102,不存在，创建表IncEvalLevel3_bps102,SQL:CREATE TABLE IncEvalLevel3_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:04,393 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalLevel3_bps102 14:58:04,418 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalLevel3_bps102 14:58:04,419 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel3_bps102表中有索引:["id"] 14:58:04,500 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 multiid 添加索引成功 14:58:04,672 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 day 添加索引成功 14:58:04,737 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 week 添加索引成功 14:58:04,792 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 month 添加索引成功 14:58:04,861 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 season 添加索引成功 14:58:04,908 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 year 添加索引成功 14:58:04,962 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 leak 添加索引成功 14:58:05,016 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel3_bps102 中字段 customerlevel 添加索引成功 14:58:05,017 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalLevel3_bps102字段成功. 14:58:05,017 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalLevel4_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:05,018 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel4_bps102,不存在，创建表IncEvalLevel4_bps102,SQL:CREATE TABLE IncEvalLevel4_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:05,057 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalLevel4_bps102 14:58:05,072 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalLevel4_bps102 14:58:05,074 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel4_bps102表中有索引:["id"] 14:58:05,129 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 multiid 添加索引成功 14:58:05,210 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 day 添加索引成功 14:58:05,255 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 week 添加索引成功 14:58:05,309 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 month 添加索引成功 14:58:05,381 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 season 添加索引成功 14:58:05,435 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 year 添加索引成功 14:58:05,497 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 leak 添加索引成功 14:58:05,552 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel4_bps102 中字段 customerlevel 添加索引成功 14:58:05,553 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalLevel4_bps102字段成功. 14:58:05,553 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalLevel5_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:05,555 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel5_bps102,不存在，创建表IncEvalLevel5_bps102,SQL:CREATE TABLE IncEvalLevel5_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:05,594 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalLevel5_bps102 14:58:05,608 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalLevel5_bps102 14:58:05,611 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalLevel5_bps102表中有索引:["id"] 14:58:05,665 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 multiid 添加索引成功 14:58:05,752 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 day 添加索引成功 14:58:05,808 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 week 添加索引成功 14:58:05,862 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 month 添加索引成功 14:58:05,932 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 season 添加索引成功 14:58:05,987 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 year 添加索引成功 14:58:06,041 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 leak 添加索引成功 14:58:06,095 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalLevel5_bps102 中字段 customerlevel 添加索引成功 14:58:06,095 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalLevel5_bps102字段成功. 14:58:06,095 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalNot_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:06,097 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalNot_bps102,不存在，创建表IncEvalNot_bps102,SQL:CREATE TABLE IncEvalNot_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:06,136 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalNot_bps102 14:58:06,153 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalNot_bps102 14:58:06,154 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalNot_bps102表中有索引:["id"] 14:58:06,218 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 multiid 添加索引成功 14:58:06,329 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 day 添加索引成功 14:58:06,375 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 week 添加索引成功 14:58:06,429 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 month 添加索引成功 14:58:06,501 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 season 添加索引成功 14:58:06,555 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 year 添加索引成功 14:58:06,609 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 leak 添加索引成功 14:58:06,666 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNot_bps102 中字段 customerlevel 添加索引成功 14:58:06,666 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalNot_bps102字段成功. 14:58:06,666 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncEvalNotAsk_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:06,668 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalNotAsk_bps102,不存在，创建表IncEvalNotAsk_bps102,SQL:CREATE TABLE IncEvalNotAsk_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:06,713 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncEvalNotAsk_bps102 14:58:06,727 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncEvalNotAsk_bps102 14:58:06,728 DEBUG com.pan.soms.cache.dal.CacheDal: IncEvalNotAsk_bps102表中有索引:["id"] 14:58:06,785 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 multiid 添加索引成功 14:58:06,886 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 day 添加索引成功 14:58:06,945 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 week 添加索引成功 14:58:06,999 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 month 添加索引成功 14:58:07,080 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 season 添加索引成功 14:58:07,135 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 year 添加索引成功 14:58:07,189 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 leak 添加索引成功 14:58:07,259 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncEvalNotAsk_bps102 中字段 customerlevel 添加索引成功 14:58:07,259 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncEvalNotAsk_bps102字段成功. 14:58:07,259 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncGiveUpTicket_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:07,262 DEBUG com.pan.soms.cache.dal.CacheDal: IncGiveUpTicket_bps102,不存在，创建表IncGiveUpTicket_bps102,SQL:CREATE TABLE IncGiveUpTicket_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:07,325 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncGiveUpTicket_bps102 14:58:07,390 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncGiveUpTicket_bps102 14:58:07,391 DEBUG com.pan.soms.cache.dal.CacheDal: IncGiveUpTicket_bps102表中有索引:["id"] 14:58:07,451 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 multiid 添加索引成功 14:58:07,577 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 day 添加索引成功 14:58:07,631 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 week 添加索引成功 14:58:07,693 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 month 添加索引成功 14:58:07,765 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 season 添加索引成功 14:58:07,819 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 year 添加索引成功 14:58:07,866 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 leak 添加索引成功 14:58:07,920 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncGiveUpTicket_bps102 中字段 customerlevel 添加索引成功 14:58:07,921 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncGiveUpTicket_bps102字段成功. 14:58:07,921 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncTicket_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:07,923 DEBUG com.pan.soms.cache.dal.CacheDal: IncTicket_bps102,不存在，创建表IncTicket_bps102,SQL:CREATE TABLE IncTicket_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:07,961 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncTicket_bps102 14:58:07,997 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncTicket_bps102 14:58:07,998 DEBUG com.pan.soms.cache.dal.CacheDal: IncTicket_bps102表中有索引:["id"] 14:58:08,058 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 multiid 添加索引成功 14:58:08,153 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 day 添加索引成功 14:58:08,209 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 week 添加索引成功 14:58:08,263 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 month 添加索引成功 14:58:08,334 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 season 添加索引成功 14:58:08,389 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 year 添加索引成功 14:58:08,434 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 leak 添加索引成功 14:58:08,488 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncTicket_bps102 中字段 customerlevel 添加索引成功 14:58:08,489 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncTicket_bps102字段成功. 14:58:08,489 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncStationCount_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:08,490 DEBUG com.pan.soms.cache.dal.CacheDal: IncStationCount_bps102,不存在，创建表IncStationCount_bps102,SQL:CREATE TABLE IncStationCount_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:08,530 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncStationCount_bps102 14:58:08,551 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncStationCount_bps102 14:58:08,552 DEBUG com.pan.soms.cache.dal.CacheDal: IncStationCount_bps102表中有索引:["id"] 14:58:08,601 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 multiid 添加索引成功 14:58:08,693 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 day 添加索引成功 14:58:08,743 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 week 添加索引成功 14:58:08,797 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 month 添加索引成功 14:58:08,869 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 season 添加索引成功 14:58:08,923 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 year 添加索引成功 14:58:08,985 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 leak 添加索引成功 14:58:09,041 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationCount_bps102 中字段 customerlevel 添加索引成功 14:58:09,041 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncStationCount_bps102字段成功. 14:58:09,042 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:IncStationPerson_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:09,043 DEBUG com.pan.soms.cache.dal.CacheDal: IncStationPerson_bps102,不存在，创建表IncStationPerson_bps102,SQL:CREATE TABLE IncStationPerson_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:09,082 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC IncStationPerson_bps102 14:58:09,097 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM IncStationPerson_bps102 14:58:09,098 DEBUG com.pan.soms.cache.dal.CacheDal: IncStationPerson_bps102表中有索引:["id"] 14:58:09,153 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 multiid 添加索引成功 14:58:09,241 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 day 添加索引成功 14:58:09,288 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 week 添加索引成功 14:58:09,333 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 month 添加索引成功 14:58:09,404 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 season 添加索引成功 14:58:09,461 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 year 添加索引成功 14:58:09,524 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 leak 添加索引成功 14:58:09,578 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:IncStationPerson_bps102 中字段 customerlevel 添加索引成功 14:58:09,579 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:IncStationPerson_bps102字段成功. 14:58:09,579 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:MaxServiceTime_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:09,581 DEBUG com.pan.soms.cache.dal.CacheDal: MaxServiceTime_bps102,不存在，创建表MaxServiceTime_bps102,SQL:CREATE TABLE MaxServiceTime_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:09,620 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC MaxServiceTime_bps102 14:58:09,633 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM MaxServiceTime_bps102 14:58:09,634 DEBUG com.pan.soms.cache.dal.CacheDal: MaxServiceTime_bps102表中有索引:["id"] 14:58:09,685 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 multiid 添加索引成功 14:58:09,764 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 day 添加索引成功 14:58:09,818 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 week 添加索引成功 14:58:09,875 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 month 添加索引成功 14:58:09,946 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 season 添加索引成功 14:58:10,010 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 year 添加索引成功 14:58:10,064 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 leak 添加索引成功 14:58:10,127 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxServiceTime_bps102 中字段 customerlevel 添加索引成功 14:58:10,127 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:MaxServiceTime_bps102字段成功. 14:58:10,128 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:MaxWaitTime_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:10,129 DEBUG com.pan.soms.cache.dal.CacheDal: MaxWaitTime_bps102,不存在，创建表MaxWaitTime_bps102,SQL:CREATE TABLE MaxWaitTime_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:10,168 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC MaxWaitTime_bps102 14:58:10,184 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM MaxWaitTime_bps102 14:58:10,185 DEBUG com.pan.soms.cache.dal.CacheDal: MaxWaitTime_bps102表中有索引:["id"] 14:58:10,242 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 multiid 添加索引成功 14:58:10,329 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 day 添加索引成功 14:58:10,384 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 week 添加索引成功 14:58:10,439 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 month 添加索引成功 14:58:10,519 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 season 添加索引成功 14:58:10,575 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 year 添加索引成功 14:58:10,629 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 leak 添加索引成功 14:58:10,692 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxWaitTime_bps102 中字段 customerlevel 添加索引成功 14:58:10,692 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:MaxWaitTime_bps102字段成功. 14:58:10,692 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:MaxOpenStationCount_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:10,694 DEBUG com.pan.soms.cache.dal.CacheDal: MaxOpenStationCount_bps102,不存在，创建表MaxOpenStationCount_bps102,SQL:CREATE TABLE MaxOpenStationCount_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:10,733 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC MaxOpenStationCount_bps102 14:58:10,748 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM MaxOpenStationCount_bps102 14:58:10,749 DEBUG com.pan.soms.cache.dal.CacheDal: MaxOpenStationCount_bps102表中有索引:["id"] 14:58:10,806 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 multiid 添加索引成功 14:58:10,886 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 day 添加索引成功 14:58:10,940 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 week 添加索引成功 14:58:10,996 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 month 添加索引成功 14:58:11,067 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 season 添加索引成功 14:58:11,123 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 year 添加索引成功 14:58:11,177 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 leak 添加索引成功 14:58:11,240 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxOpenStationCount_bps102 中字段 customerlevel 添加索引成功 14:58:11,240 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:MaxOpenStationCount_bps102字段成功. 14:58:11,240 DEBUG com.pan.soms.cache.dal.CacheDal: MYSQL, 开始检测数据表:MaxActivePerson_bps102,表中字段:[multiid, day, week, month, season, year, leak, customerlevel, id, creator, modifior, createdtime, modifedtime, isdeleted, memo, h_total, h_0, s_0_total, s_0_0, s_1_total, s_1_0, s_2_total, s_2_0, s_3_total, s_3_0, s_4_total, s_4_0, s_5_total, s_5_0, s_6_total, s_6_0, s_7_total, s_7_0, h_1, s_0_1, s_1_1, s_2_1, s_3_1, s_4_1, s_5_1, s_6_1, s_7_1, h_2, s_0_2, s_1_2, s_2_2, s_3_2, s_4_2, s_5_2, s_6_2, s_7_2, h_3, s_0_3, s_1_3, s_2_3, s_3_3, s_4_3, s_5_3, s_6_3, s_7_3, h_4, s_0_4, s_1_4, s_2_4, s_3_4, s_4_4, s_5_4, s_6_4, s_7_4, h_5, s_0_5, s_1_5, s_2_5, s_3_5, s_4_5, s_5_5, s_6_5, s_7_5, h_6, s_0_6, s_1_6, s_2_6, s_3_6, s_4_6, s_5_6, s_6_6, s_7_6, h_7, s_0_7, s_1_7, s_2_7, s_3_7, s_4_7, s_5_7, s_6_7, s_7_7, h_8, s_0_8, s_1_8, s_2_8, s_3_8, s_4_8, s_5_8, s_6_8, s_7_8, h_9, s_0_9, s_1_9, s_2_9, s_3_9, s_4_9, s_5_9, s_6_9, s_7_9, h_10, s_0_10, s_1_10, s_2_10, s_3_10, s_4_10, s_5_10, s_6_10, s_7_10, h_11, s_0_11, s_1_11, s_2_11, s_3_11, s_4_11, s_5_11, s_6_11, s_7_11, h_12, s_0_12, s_1_12, s_2_12, s_3_12, s_4_12, s_5_12, s_6_12, s_7_12, h_13, s_0_13, s_1_13, s_2_13, s_3_13, s_4_13, s_5_13, s_6_13, s_7_13, h_14, s_0_14, s_1_14, s_2_14, s_3_14, s_4_14, s_5_14, s_6_14, s_7_14, h_15, s_0_15, s_1_15, s_2_15, s_3_15, s_4_15, s_5_15, s_6_15, s_7_15, h_16, s_0_16, s_1_16, s_2_16, s_3_16, s_4_16, s_5_16, s_6_16, s_7_16, h_17, s_0_17, s_1_17, s_2_17, s_3_17, s_4_17, s_5_17, s_6_17, s_7_17, h_18, s_0_18, s_1_18, s_2_18, s_3_18, s_4_18, s_5_18, s_6_18, s_7_18, h_19, s_0_19, s_1_19, s_2_19, s_3_19, s_4_19, s_5_19, s_6_19, s_7_19, h_20, s_0_20, s_1_20, s_2_20, s_3_20, s_4_20, s_5_20, s_6_20, s_7_20, h_21, s_0_21, s_1_21, s_2_21, s_3_21, s_4_21, s_5_21, s_6_21, s_7_21, h_22, s_0_22, s_1_22, s_2_22, s_3_22, s_4_22, s_5_22, s_6_22, s_7_22, h_23, s_0_23, s_1_23, s_2_23, s_3_23, s_4_23, s_5_23, s_6_23, s_7_23] 14:58:11,242 DEBUG com.pan.soms.cache.dal.CacheDal: MaxActivePerson_bps102,不存在，创建表MaxActivePerson_bps102,SQL:CREATE TABLE MaxActivePerson_bps102 ( multiid VARCHAR(150) NOT NULL,day INT(8) NOT NULL,week INT(8) NOT NULL,month INT(8) NOT NULL,season INT(8) NOT NULL,year INT(8) NOT NULL,leak INT NOT NULL DEFAULT 1,customerlevel SMALLINT(8) ,id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,creator VARCHAR(32) NOT NULL,modifior VARCHAR(32) NOT NULL,createdTime TIMESTAMP NOT NULL,modifedTime TIMESTAMP NOT NULL,isDeleted TINYINT(1) ,memo TEXT(10) ,h_total INT(4) ,h_0 INT(4) ,s_0_total INT(4) ,s_0_0 INT(4) ,s_1_total INT(4) ,s_1_0 INT(4) ,s_2_total INT(4) ,s_2_0 INT(4) ,s_3_total INT(4) ,s_3_0 INT(4) ,s_4_total INT(4) ,s_4_0 INT(4) ,s_5_total INT(4) ,s_5_0 INT(4) ,s_6_total INT(4) ,s_6_0 INT(4) ,s_7_total INT(4) ,s_7_0 INT(4) ,h_1 INT(4) ,s_0_1 INT(4) ,s_1_1 INT(4) ,s_2_1 INT(4) ,s_3_1 INT(4) ,s_4_1 INT(4) ,s_5_1 INT(4) ,s_6_1 INT(4) ,s_7_1 INT(4) ,h_2 INT(4) ,s_0_2 INT(4) ,s_1_2 INT(4) ,s_2_2 INT(4) ,s_3_2 INT(4) ,s_4_2 INT(4) ,s_5_2 INT(4) ,s_6_2 INT(4) ,s_7_2 INT(4) ,h_3 INT(4) ,s_0_3 INT(4) ,s_1_3 INT(4) ,s_2_3 INT(4) ,s_3_3 INT(4) ,s_4_3 INT(4) ,s_5_3 INT(4) ,s_6_3 INT(4) ,s_7_3 INT(4) ,h_4 INT(4) ,s_0_4 INT(4) ,s_1_4 INT(4) ,s_2_4 INT(4) ,s_3_4 INT(4) ,s_4_4 INT(4) ,s_5_4 INT(4) ,s_6_4 INT(4) ,s_7_4 INT(4) ,h_5 INT(4) ,s_0_5 INT(4) ,s_1_5 INT(4) ,s_2_5 INT(4) ,s_3_5 INT(4) ,s_4_5 INT(4) ,s_5_5 INT(4) ,s_6_5 INT(4) ,s_7_5 INT(4) ,h_6 INT(4) ,s_0_6 INT(4) ,s_1_6 INT(4) ,s_2_6 INT(4) ,s_3_6 INT(4) ,s_4_6 INT(4) ,s_5_6 INT(4) ,s_6_6 INT(4) ,s_7_6 INT(4) ,h_7 INT(4) ,s_0_7 INT(4) ,s_1_7 INT(4) ,s_2_7 INT(4) ,s_3_7 INT(4) ,s_4_7 INT(4) ,s_5_7 INT(4) ,s_6_7 INT(4) ,s_7_7 INT(4) ,h_8 INT(4) ,s_0_8 INT(4) ,s_1_8 INT(4) ,s_2_8 INT(4) ,s_3_8 INT(4) ,s_4_8 INT(4) ,s_5_8 INT(4) ,s_6_8 INT(4) ,s_7_8 INT(4) ,h_9 INT(4) ,s_0_9 INT(4) ,s_1_9 INT(4) ,s_2_9 INT(4) ,s_3_9 INT(4) ,s_4_9 INT(4) ,s_5_9 INT(4) ,s_6_9 INT(4) ,s_7_9 INT(4) ,h_10 INT(4) ,s_0_10 INT(4) ,s_1_10 INT(4) ,s_2_10 INT(4) ,s_3_10 INT(4) ,s_4_10 INT(4) ,s_5_10 INT(4) ,s_6_10 INT(4) ,s_7_10 INT(4) ,h_11 INT(4) ,s_0_11 INT(4) ,s_1_11 INT(4) ,s_2_11 INT(4) ,s_3_11 INT(4) ,s_4_11 INT(4) ,s_5_11 INT(4) ,s_6_11 INT(4) ,s_7_11 INT(4) ,h_12 INT(4) ,s_0_12 INT(4) ,s_1_12 INT(4) ,s_2_12 INT(4) ,s_3_12 INT(4) ,s_4_12 INT(4) ,s_5_12 INT(4) ,s_6_12 INT(4) ,s_7_12 INT(4) ,h_13 INT(4) ,s_0_13 INT(4) ,s_1_13 INT(4) ,s_2_13 INT(4) ,s_3_13 INT(4) ,s_4_13 INT(4) ,s_5_13 INT(4) ,s_6_13 INT(4) ,s_7_13 INT(4) ,h_14 INT(4) ,s_0_14 INT(4) ,s_1_14 INT(4) ,s_2_14 INT(4) ,s_3_14 INT(4) ,s_4_14 INT(4) ,s_5_14 INT(4) ,s_6_14 INT(4) ,s_7_14 INT(4) ,h_15 INT(4) ,s_0_15 INT(4) ,s_1_15 INT(4) ,s_2_15 INT(4) ,s_3_15 INT(4) ,s_4_15 INT(4) ,s_5_15 INT(4) ,s_6_15 INT(4) ,s_7_15 INT(4) ,h_16 INT(4) ,s_0_16 INT(4) ,s_1_16 INT(4) ,s_2_16 INT(4) ,s_3_16 INT(4) ,s_4_16 INT(4) ,s_5_16 INT(4) ,s_6_16 INT(4) ,s_7_16 INT(4) ,h_17 INT(4) ,s_0_17 INT(4) ,s_1_17 INT(4) ,s_2_17 INT(4) ,s_3_17 INT(4) ,s_4_17 INT(4) ,s_5_17 INT(4) ,s_6_17 INT(4) ,s_7_17 INT(4) ,h_18 INT(4) ,s_0_18 INT(4) ,s_1_18 INT(4) ,s_2_18 INT(4) ,s_3_18 INT(4) ,s_4_18 INT(4) ,s_5_18 INT(4) ,s_6_18 INT(4) ,s_7_18 INT(4) ,h_19 INT(4) ,s_0_19 INT(4) ,s_1_19 INT(4) ,s_2_19 INT(4) ,s_3_19 INT(4) ,s_4_19 INT(4) ,s_5_19 INT(4) ,s_6_19 INT(4) ,s_7_19 INT(4) ,h_20 INT(4) ,s_0_20 INT(4) ,s_1_20 INT(4) ,s_2_20 INT(4) ,s_3_20 INT(4) ,s_4_20 INT(4) ,s_5_20 INT(4) ,s_6_20 INT(4) ,s_7_20 INT(4) ,h_21 INT(4) ,s_0_21 INT(4) ,s_1_21 INT(4) ,s_2_21 INT(4) ,s_3_21 INT(4) ,s_4_21 INT(4) ,s_5_21 INT(4) ,s_6_21 INT(4) ,s_7_21 INT(4) ,h_22 INT(4) ,s_0_22 INT(4) ,s_1_22 INT(4) ,s_2_22 INT(4) ,s_3_22 INT(4) ,s_4_22 INT(4) ,s_5_22 INT(4) ,s_6_22 INT(4) ,s_7_22 INT(4) ,h_23 INT(4) ,s_0_23 INT(4) ,s_1_23 INT(4) ,s_2_23 INT(4) ,s_3_23 INT(4) ,s_4_23 INT(4) ,s_5_23 INT(4) ,s_6_23 INT(4) ,s_7_23 INT(4) )DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 14:58:11,281 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表字段是否存在：DESC MaxActivePerson_bps102 14:58:11,297 DEBUG com.pan.soms.cache.dal.CacheDal: 查看数据表有多少索引：SHOW INDEX FROM MaxActivePerson_bps102 14:58:11,298 DEBUG com.pan.soms.cache.dal.CacheDal: MaxActivePerson_bps102表中有索引:["id"] 14:58:11,363 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 multiid 添加索引成功 14:58:11,459 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 day 添加索引成功 14:58:11,505 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 week 添加索引成功 14:58:11,561 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 month 添加索引成功 14:58:11,632 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 season 添加索引成功 14:58:11,729 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 year 添加索引成功 14:58:11,876 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 leak 添加索引成功 14:58:11,924 DEBUG com.pan.soms.cache.dal.CacheDal: 数据库:MaxActivePerson_bps102 中字段 customerlevel 添加索引成功 14:58:11,925 DEBUG com.pan.soms.cache.dal.CacheDal: checkTabel:检测数据表:MaxActivePerson_bps102字段成功. 14:58:11,925 DEBUG com.pan.util.socket.SocketServerSession: 客户端 /127.0.0.1:5841 信息处理完成。
没有评论 :
发表评论