Open Prophidys opened 9 years ago
From crov...@gmail.com on February 11, 2010 07:02:36
What steps will reproduce the problem? 1. mysql> select * from ifOutOctets_1 where dtime>=FROM_UNIXTIME(1265820000) and dtime<=FROM_UNIXTIME(1265887000) and id=9; +----+---------------------+----------+---------------+ | id | dtime | counter | rate | +----+---------------------+----------+---------------+ | 9 | 2010-02-10 16:35:40 | 307930 | 1026.367331 | | 9 | 2010-02-10 16:40:40 | 263690 | 879.057192 | | 9 | 2010-02-10 16:45:40 | 253515 | 845.048178 | | 9 | 2010-02-10 16:50:40 | 218256 | 727.537461 | | 9 | 2010-02-10 16:55:40 | 352355 | 1174.459686 | | 9 | 2010-02-10 17:00:40 | 272720 | 909.082412 | | 9 | 2010-02-10 17:05:40 | 1629387 | 5431.477839 | | 9 | 2010-02-10 17:10:40 | 1532179 | 5107.150431 | | 9 | 2010-02-10 17:15:40 | 329265 | 1097.560332 | | 9 | 2010-02-10 17:20:40 | 762859 | 2542.830777 | | 9 | 2010-02-10 17:25:40 | 238373 | 794.547594 | | 9 | 2010-02-10 17:30:40 | 258901 | 863.029615 | | 9 | 2010-02-10 17:35:40 | 239723 | 799.03301 | | 9 | 2010-02-10 17:40:40 | 251800 | 839.399207 | | 9 | 2010-02-10 17:45:40 | 2686208 | 8953.663387 | | 9 | 2010-02-10 17:50:40 | 129861 | 432.880316 | | 9 | 2010-02-11 08:15:40 | 484125 | 1613.767423 | | 9 | 2010-02-11 08:20:40 | 70529068 | 235099.639297 | | 9 | 2010-02-11 08:25:40 | 29418196 | 98055.434496 | | 9 | 2010-02-11 08:30:40 | 264818 | 882.760203 | | 9 | 2010-02-11 08:35:40 | 21052718 | 70175.869358 | | 9 | 2010-02-11 08:40:40 | 4536670 | 15121.059183 | | 9 | 2010-02-11 08:45:40 | 302948 | 1009.899248 | | 9 | 2010-02-11 08:50:40 | 483990 | 1613.294762 | | 9 | 2010-02-11 08:55:40 | 948944 | 3163.107423 | | 9 | 2010-02-11 09:00:40 | 249215 | 830.733622 | | 9 | 2010-02-11 09:05:40 | 942839 | 3142.691491 | | 9 | 2010-02-11 09:10:40 | 449982 | 1499.905682 | | 9 | 2010-02-11 09:15:40 | 392801 | 1309.367131 | +----+---------------------+----------+---------------+ 29 rows in set (0.01 sec)
mysql> select * from ifInOctets_1 where dtime>=FROM_UNIXTIME(1265820000) and dtime<=FROM_UNIXTIME(1265887000) and id=9; +----+---------------------+----------+--------------+ | id | dtime | counter | rate | +----+---------------------+----------+--------------+ | 9 | 2010-02-10 16:35:40 | 25393 | 84.634677 | | 9 | 2010-02-10 16:40:40 | 8812 | 29.377352 | | 9 | 2010-02-10 16:45:40 | 5826 | 19.419525 | | 9 | 2010-02-10 16:50:40 | 11957 | 39.857622 | | 9 | 2010-02-10 16:55:40 | 17673 | 58.907082 | | 9 | 2010-02-10 17:00:40 | 19901 | 66.339216 | | 9 | 2010-02-10 17:05:40 | 253280 | 844.279336 | | 9 | 2010-02-10 17:10:40 | 164125 | 547.071785 | | 9 | 2010-02-10 17:15:40 | 28650 | 95.500813 | | 9 | 2010-02-10 17:20:40 | 117809 | 392.699074 | | 9 | 2010-02-10 17:25:40 | 7095 | 23.648667 | | 9 | 2010-02-10 17:30:40 | 17724 | 59.081673 | | 9 | 2010-02-10 17:35:40 | 5840 | 19.465608 | | 9 | 2010-02-10 17:40:40 | 6002 | 20.008186 | | 9 | 2010-02-10 17:45:40 | 1007262 | 3357.414131 | | 9 | 2010-02-10 17:50:40 | 6120 | 20.400501 | | 9 | 2010-02-11 08:15:40 | 260130 | 867.10344 | | 9 | 2010-02-11 08:20:40 | 5810516 | 19368.132944 | | 9 | 2010-02-11 08:25:40 | 1744037 | 5813.331002 | | 9 | 2010-02-11 08:30:40 | 39252 | 130.844543 | | 9 | 2010-02-11 08:35:40 | 1273352 | 4244.384924 | | 9 | 2010-02-11 08:40:40 | 348757 | 1162.440595 | | 9 | 2010-02-11 08:45:40 | 10881 | 36.272288 | | 9 | 2010-02-11 08:50:40 | 331488 | 1104.983805 | | 9 | 2010-02-11 08:55:40 | 11236801 | 37454.856341 | | 9 | 2010-02-11 09:00:40 | 5632 | 18.773765 | | 9 | 2010-02-11 09:05:40 | 30911 | 103.032635 | | 9 | 2010-02-11 09:10:40 | 113323 | 377.746017 | | 9 | 2010-02-11 09:15:40 | 33900 | 113.003779 | +----+---------------------+----------+--------------+ 29 rows in set (0.01 sec) 2. http://localhost/rtg/rtgplot.cgi?PO=Traffic+In/Out:500:150::1265831439:1265885958&DO=0:ifInOctets_1:9&LO=0:0::In&DO=1:ifOutOctets_1:9&LO=1:1::Out
http://localhost/rtg/rtgplot.cgi?PO=Traffic+In/Out:500:150::1265831440:1265885958&DO=0:ifInOctets_1:9&LO=0:0::In&DO=1:ifOutOctets_1:9&LO=1:1::Out 3. What is the expected output? What do you see instead? Some graph. What version of the product are you using? On what operating system? CVS in 10/02/10 -> Debian Lenny.
Attachment: 1.png 2.png
Original issue: http://code.google.com/p/rtg2/issues/detail?id=12
From crov...@gmail.com on February 11, 2010 07:02:36
What steps will reproduce the problem? 1. mysql> select * from ifOutOctets_1 where dtime>=FROM_UNIXTIME(1265820000) and dtime<=FROM_UNIXTIME(1265887000) and id=9; +----+---------------------+----------+---------------+ | id | dtime | counter | rate | +----+---------------------+----------+---------------+ | 9 | 2010-02-10 16:35:40 | 307930 | 1026.367331 | | 9 | 2010-02-10 16:40:40 | 263690 | 879.057192 | | 9 | 2010-02-10 16:45:40 | 253515 | 845.048178 | | 9 | 2010-02-10 16:50:40 | 218256 | 727.537461 | | 9 | 2010-02-10 16:55:40 | 352355 | 1174.459686 | | 9 | 2010-02-10 17:00:40 | 272720 | 909.082412 | | 9 | 2010-02-10 17:05:40 | 1629387 | 5431.477839 | | 9 | 2010-02-10 17:10:40 | 1532179 | 5107.150431 | | 9 | 2010-02-10 17:15:40 | 329265 | 1097.560332 | | 9 | 2010-02-10 17:20:40 | 762859 | 2542.830777 | | 9 | 2010-02-10 17:25:40 | 238373 | 794.547594 | | 9 | 2010-02-10 17:30:40 | 258901 | 863.029615 | | 9 | 2010-02-10 17:35:40 | 239723 | 799.03301 | | 9 | 2010-02-10 17:40:40 | 251800 | 839.399207 | | 9 | 2010-02-10 17:45:40 | 2686208 | 8953.663387 | | 9 | 2010-02-10 17:50:40 | 129861 | 432.880316 | | 9 | 2010-02-11 08:15:40 | 484125 | 1613.767423 | | 9 | 2010-02-11 08:20:40 | 70529068 | 235099.639297 | | 9 | 2010-02-11 08:25:40 | 29418196 | 98055.434496 | | 9 | 2010-02-11 08:30:40 | 264818 | 882.760203 | | 9 | 2010-02-11 08:35:40 | 21052718 | 70175.869358 | | 9 | 2010-02-11 08:40:40 | 4536670 | 15121.059183 | | 9 | 2010-02-11 08:45:40 | 302948 | 1009.899248 | | 9 | 2010-02-11 08:50:40 | 483990 | 1613.294762 | | 9 | 2010-02-11 08:55:40 | 948944 | 3163.107423 | | 9 | 2010-02-11 09:00:40 | 249215 | 830.733622 | | 9 | 2010-02-11 09:05:40 | 942839 | 3142.691491 | | 9 | 2010-02-11 09:10:40 | 449982 | 1499.905682 | | 9 | 2010-02-11 09:15:40 | 392801 | 1309.367131 | +----+---------------------+----------+---------------+ 29 rows in set (0.01 sec)
mysql> select * from ifInOctets_1 where dtime>=FROM_UNIXTIME(1265820000) and dtime<=FROM_UNIXTIME(1265887000) and id=9; +----+---------------------+----------+--------------+ | id | dtime | counter | rate | +----+---------------------+----------+--------------+ | 9 | 2010-02-10 16:35:40 | 25393 | 84.634677 | | 9 | 2010-02-10 16:40:40 | 8812 | 29.377352 | | 9 | 2010-02-10 16:45:40 | 5826 | 19.419525 | | 9 | 2010-02-10 16:50:40 | 11957 | 39.857622 | | 9 | 2010-02-10 16:55:40 | 17673 | 58.907082 | | 9 | 2010-02-10 17:00:40 | 19901 | 66.339216 | | 9 | 2010-02-10 17:05:40 | 253280 | 844.279336 | | 9 | 2010-02-10 17:10:40 | 164125 | 547.071785 | | 9 | 2010-02-10 17:15:40 | 28650 | 95.500813 | | 9 | 2010-02-10 17:20:40 | 117809 | 392.699074 | | 9 | 2010-02-10 17:25:40 | 7095 | 23.648667 | | 9 | 2010-02-10 17:30:40 | 17724 | 59.081673 | | 9 | 2010-02-10 17:35:40 | 5840 | 19.465608 | | 9 | 2010-02-10 17:40:40 | 6002 | 20.008186 | | 9 | 2010-02-10 17:45:40 | 1007262 | 3357.414131 | | 9 | 2010-02-10 17:50:40 | 6120 | 20.400501 | | 9 | 2010-02-11 08:15:40 | 260130 | 867.10344 | | 9 | 2010-02-11 08:20:40 | 5810516 | 19368.132944 | | 9 | 2010-02-11 08:25:40 | 1744037 | 5813.331002 | | 9 | 2010-02-11 08:30:40 | 39252 | 130.844543 | | 9 | 2010-02-11 08:35:40 | 1273352 | 4244.384924 | | 9 | 2010-02-11 08:40:40 | 348757 | 1162.440595 | | 9 | 2010-02-11 08:45:40 | 10881 | 36.272288 | | 9 | 2010-02-11 08:50:40 | 331488 | 1104.983805 | | 9 | 2010-02-11 08:55:40 | 11236801 | 37454.856341 | | 9 | 2010-02-11 09:00:40 | 5632 | 18.773765 | | 9 | 2010-02-11 09:05:40 | 30911 | 103.032635 | | 9 | 2010-02-11 09:10:40 | 113323 | 377.746017 | | 9 | 2010-02-11 09:15:40 | 33900 | 113.003779 | +----+---------------------+----------+--------------+ 29 rows in set (0.01 sec) 2. http://localhost/rtg/rtgplot.cgi?PO=Traffic+In/Out:500:150::1265831439:1265885958&DO=0:ifInOctets_1:9&LO=0:0::In&DO=1:ifOutOctets_1:9&LO=1:1::Out
http://localhost/rtg/rtgplot.cgi?PO=Traffic+In/Out:500:150::1265831440:1265885958&DO=0:ifInOctets_1:9&LO=0:0::In&DO=1:ifOutOctets_1:9&LO=1:1::Out 3. What is the expected output? What do you see instead? Some graph. What version of the product are you using? On what operating system? CVS in 10/02/10 -> Debian Lenny.
Attachment: 1.png 2.png
Original issue: http://code.google.com/p/rtg2/issues/detail?id=12