Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: TSA Pixel Tracking V2
-
Fix Version/s: TSA Pixel Tracking V2
-
Component/s: TSA Tracking
-
Labels:None
-
Environment:
Pixel Server :192.168.30.190
Staginging-xml1 (Build 48)
Description
2 rows are inserting for waypoint with hit limit 1 having 2 hits within span of 3 seconds.
Prerequisite: Host the page pass_Full_Api.html to 79 for siteid=560 and waypoint=2045.
Steps to reproduce:
1) Open http://192.168.70.79/pixel_tracking/test_js/pass_full_api.htm [ pass_Full_Api.html is attached]
2)Click debug of
basic pixel URL for (560, 2045):
[debug]
within span of 3 seconds.
This generates log on Pixel server - 192.168.30.190.
vagrant@test-pixel-2:/usr/local/share/tsa/logs/spike-v2/done$ cat 2011-05-04-1300-560-190.tsv
1304514551 439334 usid3a82cf371a720e3f4415899ab9014dc8 uvid2bfa6a2328df82d276c9ef4db425336f tsatime:1304514547091|u:http%3A%2F%2F192.168.70.79%2Fpixel_tracking%2Ftest_js%2F|s:560|w:2045|debug:1 REMOTE_ADDR:192.168.70.119|HTTP_REFERER:http%3A%2F%2F192.168.70.79%2Fpixel_tracking%2Ftest_js%2Fpass_full_api.htm|HTTP_USER_AGENT:Mozilla%2F5.0%20%28Windows%3B%20U%3B%20Windows%20NT%205.1%3B%20en-US%3B%20rv%3A1.9.1.19%29%20Gecko%2F20110420%20Firefox%2F3.5.19%20%28%20.NET%20CLR%203.5.30729%29%20SearchToolbar|HTTPS:|HTTP_HOST:apitest.thesearchagency.net|SCRIPT_NAME:%2Fv2%2Fa3%2Ftsaimg.php|REQUEST_METHOD:GET 190
1304514551 831541 usid3a82cf371a720e3f4415899ab9014dc8 uvid2bfa6a2328df82d276c9ef4db425336f tsatime:1304514547091|u:http%3A%2F%2F192.168.70.79%2Fpixel_tracking%2Ftest_js%2F|s:560|w:2045|debug:1 REMOTE_ADDR:192.168.70.119|HTTP_REFERER:http%3A%2F%2F192.168.70.79%2Fpixel_tracking%2Ftest_js%2Fpass_full_api.htm|HTTP_USER_AGENT:Mozilla%2F5.0%20%28Windows%3B%20U%3B%20Windows%20NT%205.1%3B%20en-US%3B%20rv%3A1.9.1.19%29%20Gecko%2F20110420%20Firefox%2F3.5.19%20%28%20.NET%20CLR%203.5.30729%29%20SearchToolbar|HTTPS:|HTTP_HOST:apitest.thesearchagency.net|SCRIPT_NAME:%2Fv2%2Fa3%2Ftsaimg.php|REQUEST_METHOD:GET 190
3)Run
tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./v2pixsync.sh -d 3 --siteids 560 --pixel-server-list '192.168.30.190'
4)Run
tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./v2pixel_playback.sh -a 541 -d 4 2>&1| tee /tmp/test.log
5)Now login to stagingdb6 and use spikev2
mysql> select * from waypointLog where waypointID=2045;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| siteID | unixTimestamp | microseconds | rowNum | waypointID | userAgentID | cpc | distributionID | campaignID | keyword | sourceID | searchEngineListingID | isNewSession | sessionKey | visitorKey | visitorKeyHash | sessionKeyHash | refererURL | ultimateRefererURL | remoteAddr | params | sourceKey | creativeKey | baseUltimateRefererURL | internalURLPatternMatch | isOrganic | backRef | destination | tsaTime | recordedOutOfOrder | parentUnixTimestamp | parentMicroseconds | parentRowNum |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 560 | 1304514551 | 439334 | 1 | 2045 | 11 | 0 | 126 | 15 | NULL | 561911581 | 0 | 1 | uvid2bfa6a2328df82d276c9ef4db425336f | usid3a82cf371a720e3f4415899ab9014dc8 | 330134718 | 2623854622 | http://192.168.70.79/pixel_tracking/test_js/pass_full_api.htm | http://192.168.70.79/pixel_tracking/test_js/ | 192.168.70.119 | debug=1 | http://192.168.70.79 | 0 | 0 | NULL | NULL | 1304514547091 | 0 | NULL | NULL | NULL |
| 560 | 1304514551 | 831541 | 2 | 2045 | 11 | 0 | 126 | 15 | NULL | 561911581 | 0 | 1 | uvid2bfa6a2328df82d276c9ef4db425336f | usid3a82cf371a720e3f4415899ab9014dc8 | 330134718 | 2623854622 | http://192.168.70.79/pixel_tracking/test_js/pass_full_api.htm | http://192.168.70.79/pixel_tracking/test_js/ | 192.168.70.119 | debug=1 | http://192.168.70.79 | 0 | 0 | NULL | NULL | 1304514547091 | 0 | NULL | NULL | NULL |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Should it insert 1 records as hit limit is 1?
