[TIMOB-16831] Android: Analytics: Event sequence numbers are not sequential

GitHub Issue	n/a
Type	Bug
Priority	Medium
Status	Closed
Resolution	Won't Fix
Resolution Date	2014-04-09T18:08:49.000+0000
Affected Version/s	Release 3.2.3
Fix Version/s	n/a
Components	Android
Labels	qe-3.2.3
Reporter	Lokesh Choudhary
Assignee	Allen Yeung
Created	2014-04-08T21:39:56.000+0000
Updated	2017-03-21T18:09:44.000+0000

Description

NOTE : Not a regression. I could repro it in 3.2.2.GA also.

Description:

1. Run the analytics app from repo mobile_test_internal/FeatureTest on an android device. 2. After the app launches you will see the ti.enroll & ti.start events on the ubuntu server. 3. Now end the app & start it again as well as try some other events.

Actual Results:

1. The sequence numbers of the events are not one after another but sometimes 1 or 2 numbers ahead. 2. My analytics logs:

ubuntu@staging-com-net:/local_storage/event_store/p/hourly/2014-04-08$ tail -f mobile_events.json.txt | grep 848eb8a7-7510-4772-84a9-255be2b224b8
{"id":"584e962f-00ed-4414-a16a-567b86c1f7ff:3d7da741d7d61c15","sid":"57138e3c-db37-4ff5-9217-9ab4b37a74fb","ts":"2014-04-08T20:59:38.524+0000","event":"ti.end","data":{"value":""},"seq":5,"mid":"3d7da741d7d61c15","ver":"2","type":"ti.end","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}
{"city":"San Francisco","region_code":"CA","country_code":"US","country_name":"United States","postal_code":"","latitude":37.774898529053,"longitude":-122.41940307617,"area_code":415,"continent_code":"NA","ip_address":"38.110.144.252","region_name":"California","id":"ae6b5936-d1ab-46f2-8a6d-68ab74e99b59:3d7da741d7d61c15","sid":"15cdfc97-4e68-4607-950d-d63577d2df50","ts":"2014-04-08T21:01:11.522+0000","event":"ti.start","data":{"platform":"android","os":"Android","model":"Nexus 5","tz":-480,"nettype":"WIFI","deploytype":"test","app_version":"1.0","osver":"4.4.2","version":"3.2.3"},"seq":6,"mid":"3d7da741d7d61c15","ver":"2","type":"ti.start","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"751f6252-0b9b-483e-9687-38ae251824a0:3d7da741d7d61c15","sid":"15cdfc97-4e68-4607-950d-d63577d2df50","ts":"2014-04-08T21:02:37.827+0000","event":"featureEvent","data":{"value":"featureEvent.testButton"},"seq":8,"mid":"3d7da741d7d61c15","ver":"2","type":"app.feature","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"a9192ff5-12eb-4693-ac69-f6b91fff78c2:3d7da741d7d61c15","sid":"15cdfc97-4e68-4607-950d-d63577d2df50","ts":"2014-04-08T21:03:23.020+0000","event":"ti.end","data":{"value":""},"seq":10,"mid":"3d7da741d7d61c15","ver":"2","type":"ti.end","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"city":"San Francisco","region_code":"CA","country_code":"US","country_name":"United States","postal_code":"","latitude":37.774898529053,"longitude":-122.41940307617,"area_code":415,"continent_code":"NA","ip_address":"38.110.144.252","region_name":"California","id":"43bf7399-9da0-40b9-a2de-fb93c52c660a:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:05:00.620+0000","event":"ti.start","data":{"platform":"android","os":"Android","model":"Nexus 5","tz":-480,"nettype":"WIFI","deploytype":"test","app_version":"1.0","osver":"4.4.2","version":"3.2.3"},"seq":11,"mid":"3d7da741d7d61c15","ver":"2","type":"ti.start","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"791d091b-d678-43b5-a735-f2d3cf5d5a16:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:06:28.970+0000","event":"navEvent.testButton","data":{"to":"navEventTwo","data":null,"event":"navEvent.testButton","from":"navEventOne"},"seq":13,"mid":"3d7da741d7d61c15","ver":"2","type":"app.nav","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"79861dd4-5e63-4f7c-854e-8ddc8c9f9ecc:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:09:06.101+0000","event":"featureEvent","data":{"value":"featureEvent.testButton"},"seq":14,"mid":"3d7da741d7d61c15","ver":"2","type":"app.feature","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"a221419e-624c-4d30-ad41-98324b0864ac:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:10:17.630+0000","event":"settingsEvent","data":{"value":"settingsEvent.testButton"},"seq":15,"mid":"3d7da741d7d61c15","ver":"2","type":"app.settings","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"d1831b85-8fc7-44a5-aceb-b66413ad2a92:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:11:11.789+0000","event":"timedEvent.testButton","data":{"data":null,"stop":1396991100563,"duration":371224,"start":1396991100563,"event":"timedEvent.testButton"},"seq":16,"mid":"3d7da741d7d61c15","ver":"2","type":"app.timed","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

{"id":"bd898af7-6cea-44a9-8592-2105c254b4bc:3d7da741d7d61c15","sid":"65b5c4c0-b991-434f-bdfe-65166a687cdc","ts":"2014-04-08T21:12:01.262+0000","event":"userEvent","data":{"value":"userEvent.testButton"},"seq":17,"mid":"3d7da741d7d61c15","ver":"2","type":"app.user","aguid":"848eb8a7-7510-4772-84a9-255be2b224b8"}

Expected Results:

1. The sequence numbers of the events should be one after another.

Comments

Ingo Muschenetz 2014-04-09

Viewing this, it looks like these are just the row IDs in the database. I guess I would expect them to be sequential, but perhaps not? https://github.com/appcelerator/titanium_mobile/blob/8f8ed4c0fab3aa5e36d10dd92c9a8237bd8d79dd/android/titanium/src/java/org/appcelerator/titanium/analytics/TiAnalyticsModel.java
Lee Morris 2017-03-21

Closing ticket as the issue will not fix.

JSON Source