Author Topic: Connected Route Question  (Read 188 times)

0 Members and 1 Guest are viewing this topic.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1014
  • Last Login:Yesterday at 08:42:50 pm
Connected Route Question
« on: September 21, 2020, 06:35:01 pm »
This is something that has confused me since we made it doable to see entire Connected Routes.

The Connected Route page for DE/PA/NJ I-295  currently has 139 drivers with 129 having clinched it.

However, when you look at the specific state pages, you get this:

DE: 110 drivers, 109 clinched (noting that this is one of if not the most traveled sections of route in TM overall)
NJ:  110 drivers, 57 clinched
PA:  65 drivers, 55 clinched

So theoretically, there should be at most 55 people (including myself) that have clinched the entire route.  I wonder what is in the program causing these odd discrepancies.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1914
  • Last Login:Today at 08:02:23 am
Re: Connected Route Question
« Reply #1 on: September 21, 2020, 07:56:44 pm »
Doesn't sound right for sure.

I don't have time to check it out immediately, so I've created a GitHub Issue to make sure it does get investigated.

https://github.com/TravelMapping/Web/issues/542

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2930
  • Last Login:Today at 12:13:46 am
Re: Connected Route Question
« Reply #2 on: September 24, 2020, 09:42:49 pm »
Quote from: siteupdate.log
HighwayData @ 4001f70ba7d298b2a019114696a0fce72455f76b
UserData @ bafd52681fb7ac64062a1aa7e563d351f543261a
DataProcessing @ 11be967a819fcd28f05582cb1050a721494c3596
Start: 2020-09-23 21:49:20.690292

The Connected Route page for DE/PA/NJ I-295  currently has 139 drivers with 129 having clinched it.
However, when you look at the specific state pages, you get this:
DE: 110 drivers, 109 clinched
NJ:  110 drivers, 57 clinched
PA:  65 drivers, 55 clinched
The HB still reports this as of this writing, on both noreaster & lab2.

user logs:
ConnectedRoute has 160 drivers; 42 clinched
Code: [Select]
[yakra@noreaster /home/www/tm/logs/users]$ grep 'Delaware - New Jersey - Pennsylvania' *.log | wc -l
     160
[yakra@noreaster /home/www/tm/logs/users]$ grep 'Delaware - New Jersey - Pennsylvania.*(100\.00%)$' *.log | wc -l
      42

Choped routes:
Code: [Select]
[yakra@noreaster /home/www/tm/logs/users]$ grep 'DE I-295:' *.log | wc -l
     144
[yakra@noreaster /home/www/tm/logs/users]$ grep 'DE I-295:.*(100\.00%)$' *.log | wc -l
     138
[yakra@noreaster /home/www/tm/logs/users]$ grep 'NJ I-295:' *.log | wc -l
     152
[yakra@noreaster /home/www/tm/logs/users]$ grep 'NJ I-295:.*(100\.00%)$' *.log | wc -l
      57
[yakra@noreaster /home/www/tm/logs/users]$ grep 'PA I-295:' *.log | wc -l
      65
[yakra@noreaster /home/www/tm/logs/users]$ grep 'PA I-295:.*(100\.00%)$' *.log | wc -l
      55
Same results on lab2.

db queries on lab2:
Code: [Select]
mysql> select * from clinchedConnectedRoutes where route = 'de.i295';
160 rows in set (0.01 sec)
mysql> select * from clinchedConnectedRoutes where route = 'de.i295' and clinched = '1';
42 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'de.i295';
144 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'de.i295' and clinched = '1';
138 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'nj.i295';
152 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'nj.i295' and clinched = '1';
57 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'pa.i295';
65 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'pa.i295' and clinched = '1';
55 rows in set (0.00 sec)
...whether a C++ or Python-flavored siteupdate.

It appears something goes wrong on the Web (PHP?) side while/after getting results from the DB.
« Last Edit: September 24, 2020, 10:52:00 pm by yakra »

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2930
  • Last Login:Today at 12:13:46 am
Re: Connected Route Question
« Reply #3 on: September 24, 2020, 11:11:24 pm »
If I had some way to conveniently copy the tooltip text for Total Drivers & Total Clinched, maybe that could provide an avenue to explore...

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1914
  • Last Login:Today at 08:02:23 am
Re: Connected Route Question
« Reply #4 on: September 25, 2020, 08:24:57 am »

Offline yakra

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2930
  • Last Login:Today at 12:13:46 am
Re: Connected Route Question
« Reply #5 on: September 25, 2020, 10:51:52 am »
I just ran that query on lab2 for de.i295, nj.i295 and pa.i295.
Results were 144, 138; 152, 57; 65, 55.
Are you getting different results on noreaster?

How about moving this topic to the public side of the forum, to get more sets of eyes on it? There was that time mikandkristie figured out some SQL issues...