Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2620

TSA_Pixel_Tracking: 2 rows are inserting for waypoint with hit limit 1 having 2 hits within span of 3 seconds.

    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):

      http://apitest.thesearchagency.net/v2/a3/tsaimg.php?tsatime=1304514547091&u=http%3A//192.168.70.79/pixel_tracking/test_js/&s=560&w=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?

        Attachments

          Activity

            People

            • Assignee:
              mholly Mike Holly
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: