texttest -a tsc -d /home/delphi/tt_home -reconnect /home/delphi/.texttest/tmp/linux.27Jan032850.2145127 -g
texttest -a tsc -d /home/delphi/tt_home
---------- Differences in errors ---------- 127,128c127 < Warning: Ambiguous tram edges '30710062#3' and '30710062#4' for lane '4685730#0_1'. < Warning: Ambiguous tram edges '24864947#21' and '24864947#22' for lane '33685647#0_1'. --- > Warning: Ambiguous tram edges '4791641#10' and '4791641#11' for lane '-112441857#0_1'. 131a131 > Warning: Ambiguous tram edges '118423895' and '316975485#0' for lane '291670881#5_3'. 227c227 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 238c238 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 249,250c249,250 < Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. < Warning: 48 total messages of type: Non-static traffic light '%' does not define variable phase length. --- > Warning: 5 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. > Warning: 49 total messages of type: Non-static traffic light '%' does not define variable phase length. 388c388 < Warning: 9096 total messages of type: No connection between edge '%' and edge '%' found. --- > Warning: 9100 total messages of type: No connection between edge '%' and edge '%' found. ---------- Differences in output ---------- 73c73 < Joined 160 junction cluster(s). --- > Joined 161 junction cluster(s). 75c75 < 15296 nodes removed. --- > 15294 nodes removed. 113c113 < Dead-end junctions : 83 --- > Dead-end junctions : 84 135c135 < 1690 nodes loaded. --- > 1691 nodes loaded. 137c137 < 3902 edges loaded. --- > 3903 edges loaded. 165c165 < Dead-end junctions : 83 --- > Dead-end junctions : 84 187,188c187,188 < importing shapes from /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... < polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO --- > importing shapes from /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... > polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO <truncated after showing first 30 lines>
---------- Differences in errors ----------
92a93,121
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 124, in insertmany
> psycopg2.extras.execute_values(cursor, command, parameters)
> File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1270, in execute_values
> cur.execute(b''.join(parts))
> psycopg2.errors.SyntaxError: INSERT has more expressions than target columns
> LINE 1: ...terval_end, entry_id) VALUES ('(','1','1','0','1','0','0','1...
> ^
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 469, in simulation_request
> conn.rollback()
> psycopg2.InterfaceError: connection already closed
<truncated after showing first 30 lines>
---------- Differences in output ----------
91,94c91,92
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
96c94,96
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
98,102c98,99
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
108d104
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
110c106,107
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in catalogue ----------
7,10c7,10
< ----------------Berlin_1223.taz.xml
< ----------------RBS_OD_ORT_1412.taz.xml
< ----------------bidi.taz.xml
< ----------------districts.taz.xml
---
> ----------------Berlin_1223.taz.xml.gz
> ----------------RBS_OD_ORT_1412.taz.xml.gz
> ----------------bidi.taz.xml.gz
> ----------------districts.taz.xml.gz
13c13,14
< ----------------net.net.xml
---
> ----------------landmarks.csv.gz
> ----------------net.net.xml.gz
16,40d16
< --------------------emission_routes.xml
< --------------------emissions.sumo.log
< --------------------emissions.sumocfg
< --------------------person_tripinfo.xml
< --------------------persons.sumo.log
< --------------------persons.sumocfg
< --------------------persons.xml
< --------------------allpairs
< ------------------------aggregated_oneshot_meso.xml
< ------------------------all_pairs_passenger24.csv
< ------------------------all_pairs_public.csv
< ------------------------mapped_all_pairs_passenger24.csv
< ------------------------mapped_all_pairs_public.csv
< ------------------------miv_all_pairs_passenger24.trips.duarcfg
<truncated after showing first 30 lines>
---------- Differences in errors ----------
2,18c2,36
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 2 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 3 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 10 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 11 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 17 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 18 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 12 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 13 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 5 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 6 has no controlling detector.
< Warning: Traffic light type 'actuated' cannot be used in mesoscopic simulation. Using 'static' as fallback.
---
> Error: The lane 740848375_1 to use within the busStop 'busStop_0' is not known.
> Error: Could not end a stopping place that is not opened.
> Quitting (on error).
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 434, in simulation_request
> final_routes, final_weights = t2s.main(options)
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/t2s.py", line 627, in main
> return options.script_module.assign_trips(options, first_depart, last_depart, options.trips_for_dua, options.weights)
<truncated after showing first 30 lines>
---------- Differences in output ----------
5c5
< [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '0'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
---
> [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '6'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
9,10c9,10
< db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly_walking.csv
< Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly_walking.csv".
---
> db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly.csv
> Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly.csv".
12c12
< Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.
---
> Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.gz.
14c14
< Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#2, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 28.28, Q1 27.13, median 34.00, Q3 42.56
---
> Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#1, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 27.86, Q1 26.08, median 33.39, Q3 42.56
19c19
< Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml' ...
---
> Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml.gz' ...
23,1131c23,26
< Loading additional-files from '<texttest sandbox>/data/scenario_workdir/mitte_net/bidi.taz.xml' ... done ((TIME)).
< Loading done.
< Simulation started with time: 135131.00.
< Simulation ended at time: 148151.00
< Reason: The final simulation step has been reached.
< Performance:
< Vehicles:
<truncated after showing first 30 lines>
---------- Differences in sumoTrips ----------
3,4c3,4
< <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#2" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
< <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#2" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---
> <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#1" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
> <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#1" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---------- Differences in output ----------
102,105c102,103
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
107c105,107
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
109,113c109,110
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
119d115
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
121c117,118
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in output ----------
84,87c84,85
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
89c87,89
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
91,95c91,92
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
101d97
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
103c99,100
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
template tscDaemonDatabaseTripsFromFile (
Last six runs
Jan2023
)---------- Differences in errors ----------
81a82,110
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 124, in insertmany
> psycopg2.extras.execute_values(cursor, command, parameters)
> File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1270, in execute_values
> cur.execute(b''.join(parts))
> psycopg2.errors.SyntaxError: INSERT has more expressions than target columns
> LINE 1: ...terval_end, entry_id) VALUES ('(','1','1','0','1','0','0','1...
> ^
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 469, in simulation_request
> conn.rollback()
> psycopg2.InterfaceError: connection already closed
<truncated after showing first 30 lines>
---------- Differences in output ----------
87,90c87,88
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
92c90,92
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
94,98c94,95
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
104d100
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
106c102,103
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
Test exceeded wallclock time limit of 3600.0 seconds
---------- Differences in catalogue ----------
5d4
< ------------scripts.py
7,24c6,13
< ----------------Berlin_1223.poly.xml
< ----------------Berlin_1223.taz.xml
< ----------------__init__.py
< ----------------bidi.taz.xml
< ----------------landmarks.csv
< ----------------net.net.xml
< ----------------suburb.taz.xml
< ----------------vtypes.xml
< ------------mitte_net
< ----------------__init__.py
< ----------------bidi.taz.xml
< ----------------landmarks.csv
< ----------------mitte.net.xml
< ----------------mitte.txt
< ----------------mitte_bidi.taz.xml
< ----------------mitte_vtypes.xml
< ----------------net.net.xml
< ----------------suburb.taz.xml
---
> ----------------bidi.taz.xml.gz
> ----------------fleet.add.xml
> ----------------fleet_stops.add.xml
> ----------------location_priorities.xml
> ----------------net.net.xml.gz
> ----------------ptVtypes.xml
> ----------------ptlines.xml.gz
> ----------------stops.add.xml.gz
<truncated after showing first 30 lines>
---------- Differences in errors ----------
1,16c1,64
< Warning: Ignoring track count 2 for edge '104765087'.
< Warning: Discarding unknown compound 'cycleway.track' in type 'cycleway.track|highway.primary' (first occurence for edge '4045243').
< Warning: Discarding unknown compound 'cycleway.lane' in type 'cycleway.lane|highway.primary' (first occurence for edge '4068078').
< Warning: Discarding unknown compound 'cycleway.lane' in type 'cycleway.lane|highway.secondary' (first occurence for edge '4383235').
< Warning: Discarding unknown compound 'cycleway.track' in type 'cycleway.track|highway.secondary' (first occurence for edge '4396503').
< Warning: Discarding unknown compound 'cycleway.lane' in type 'cycleway.lane|highway.tertiary' (first occurence for edge '4412886').
< Warning: Discarding unusable type 'railway.abandoned' (first occurence for edge '4741460').
< Warning: Ambiguous railway kilometrage direction for way '4741937' (assuming forward)
< Warning: Discarding unusable type 'railway.construction' (first occurence for edge '23439780').
< Warning: Discarding unusable type 'railway.proposed' (first occurence for edge '23707860').
< Warning: Ambiguous railway kilometrage direction for way '25005728' (assuming forward)
< Warning: Ambiguous railway kilometrage direction for way '25386365' (assuming forward)
< Warning: Ambiguous railway kilometrage direction for way '25946680' (assuming forward)
< Warning: Discarding unusable type 'highway.construction' (first occurence for edge '25959781').
< Warning: Discarding unusable type 'waterway.stream' (first occurence for edge '31112384').
< Warning: Ambiguous railway kilometrage direction for way '32572620' (assuming forward)
---
> Warning: Value of key 'maxspeed:type' is not numeric ('trunk') in edge '4777588'.
> Warning: Ignoring track count 2 for edge '4787491'.
> Warning: Ignoring track count 2 for edge '23042324'.
> Warning: Ignoring track count 2 for edge '25307513'.
> Warning: Ignoring track count 2 for edge '86260987'.
> Warning: Ignoring track count 2 for edge '101687021'.
> Warning: Value of key 'layer' is not numeric ('1roof:shape=flat') in edge '790520607'.
> Warning: Discarding unusable type 'waterway.canal' (first occurrence for edge '4041237').
> Warning: Discarding unknown compound 'usage.main' in type 'railway.light_rail|usage.main' (first occurrence for edge '4315430').
> Warning: Ambiguous railway kilometrage direction for way '4359673' (assuming forward)
> Warning: Discarding unknown compound 'usage.main' in type 'railway.rail|usage.main' (first occurrence for edge '4364674').
> Warning: Ambiguous railway kilometrage direction for way '4364674' (assuming forward)
<truncated after showing first 30 lines>
---------- Differences in output ----------
1c1,9
< Loading configuration ... done.
---
> ----- generating template berlin_net
> creating template dir for berlin_net
> copying location_priorities.xml
> copying ptVtypes.xml
> copying ptlines.xml.gz
> copying stops.add.xml.gz
> copying vtypes.xml
> starting to import osm ...
> netconvert -c /home/delphi/tsc/data/berlin_net/template_gen0pt.netccfg --output-file <texttest sandbox>/data/scenario_templates/berlin_net/tmp_output/0_net.net.xml.gz --log <texttest sandbox>/data/scenario_templates/berlin_net/log/template_gen0pt.log
3c11
< Parsing nodes from osm-file 'C:/Users/arme_ma/Documents/Giuliana/Projekte/UrMo/GitHub/tsc/tests/../data/berlin_net/osm/berlin_net.osm.xml.gz' ...
---
> Parsing nodes from osm-file '/home/delphi/tsc/data/berlin_net/osm/berlin_net.osm.xml.gz' ...
5,7c13,15
< done.
< Parsing edges from osm-file 'C:/Users/arme_ma/Documents/Giuliana/Projekte/UrMo/GitHub/tsc/tests/../data/berlin_net/osm/berlin_net.osm.xml.gz' ...
< done.
---
> done ((TIME)).
> Parsing edges from osm-file '/home/delphi/tsc/data/berlin_net/osm/berlin_net.osm.xml.gz' ...
> done ((TIME)).
11,71c19,75
< Adding new type 'cycleway.track|highway.primary' (first occurence for edge '4045243').
< Adding new type 'cycleway.track|highway.secondary' (first occurence for edge '4045656').
< Adding new type 'cycleway.track|highway.residential' (first occurence for edge '4054007').
< Adding new type 'cycleway.lane|highway.secondary' (first occurence for edge '4067949').
< Adding new type 'cycleway.lane|highway.residential' (first occurence for edge '4068019').
<truncated after showing first 30 lines>
---------- Differences in errors ---------- 127,128c127 < Warning: Ambiguous tram edges '30710062#3' and '30710062#4' for lane '4685730#0_1'. < Warning: Ambiguous tram edges '24864947#21' and '24864947#22' for lane '33685647#0_1'. --- > Warning: Ambiguous tram edges '4791641#10' and '4791641#11' for lane '-112441857#0_1'. 131a131 > Warning: Ambiguous tram edges '118423895' and '316975485#0' for lane '291670881#5_3'. 227c227 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 238c238 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 249,250c249,250 < Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. < Warning: 48 total messages of type: Non-static traffic light '%' does not define variable phase length. --- > Warning: 5 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. > Warning: 49 total messages of type: Non-static traffic light '%' does not define variable phase length. 388c388 < Warning: 9096 total messages of type: No connection between edge '%' and edge '%' found. --- > Warning: 9100 total messages of type: No connection between edge '%' and edge '%' found. ---------- Differences in output ---------- 73c73 < Joined 160 junction cluster(s). --- > Joined 161 junction cluster(s). 75c75 < 15296 nodes removed. --- > 15294 nodes removed. 113c113 < Dead-end junctions : 83 --- > Dead-end junctions : 84 135c135 < 1690 nodes loaded. --- > 1691 nodes loaded. 137c137 < 3902 edges loaded. --- > 3903 edges loaded. 165c165 < Dead-end junctions : 83 --- > Dead-end junctions : 84 187,188c187,188 < importing shapes from /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... < polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO --- > importing shapes from /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... > polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO <truncated after showing first 30 lines>
---------- Differences in errors ----------
92a93,109
> Process Process-1:
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 121, in insertmany
> cursor.executemany(command, parameters)
> sqlite3.OperationalError: 39 values for 5 columns
---------- Differences in output ----------
91,94c91,92
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
96c94,96
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
98,102c98,99
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
108d104
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
110c106,107
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in catalogue ----------
7,10c7,10
< ----------------Berlin_1223.taz.xml
< ----------------RBS_OD_ORT_1412.taz.xml
< ----------------bidi.taz.xml
< ----------------districts.taz.xml
---
> ----------------Berlin_1223.taz.xml.gz
> ----------------RBS_OD_ORT_1412.taz.xml.gz
> ----------------bidi.taz.xml.gz
> ----------------districts.taz.xml.gz
13c13,14
< ----------------net.net.xml
---
> ----------------landmarks.csv.gz
> ----------------net.net.xml.gz
16,40d16
< --------------------emission_routes.xml
< --------------------emissions.sumo.log
< --------------------emissions.sumocfg
< --------------------person_tripinfo.xml
< --------------------persons.sumo.log
< --------------------persons.sumocfg
< --------------------persons.xml
< --------------------allpairs
< ------------------------aggregated_oneshot_meso.xml
< ------------------------all_pairs_passenger24.csv
< ------------------------all_pairs_public.csv
< ------------------------mapped_all_pairs_passenger24.csv
< ------------------------mapped_all_pairs_public.csv
< ------------------------miv_all_pairs_passenger24.trips.duarcfg
<truncated after showing first 30 lines>
---------- Differences in errors ----------
2,18c2,36
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 2 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 3 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 10 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 11 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 17 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 18 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 12 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 13 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 5 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 6 has no controlling detector.
< Warning: Traffic light type 'actuated' cannot be used in mesoscopic simulation. Using 'static' as fallback.
---
> Error: The lane 740848375_1 to use within the busStop 'busStop_0' is not known.
> Error: Could not end a stopping place that is not opened.
> Quitting (on error).
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 434, in simulation_request
> final_routes, final_weights = t2s.main(options)
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/t2s.py", line 627, in main
> return options.script_module.assign_trips(options, first_depart, last_depart, options.trips_for_dua, options.weights)
<truncated after showing first 30 lines>
---------- Differences in output ----------
5c5
< [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '0'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
---
> [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '6'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
9,10c9,10
< db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly_walking.csv
< Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly_walking.csv".
---
> db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly.csv
> Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly.csv".
12c12
< Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.
---
> Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.gz.
14c14
< Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#2, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 28.28, Q1 27.13, median 34.00, Q3 42.56
---
> Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#1, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 27.86, Q1 26.08, median 33.39, Q3 42.56
19c19
< Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml' ...
---
> Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml.gz' ...
23,1131c23,26
< Loading additional-files from '<texttest sandbox>/data/scenario_workdir/mitte_net/bidi.taz.xml' ... done ((TIME)).
< Loading done.
< Simulation started with time: 135131.00.
< Simulation ended at time: 148151.00
< Reason: The final simulation step has been reached.
< Performance:
< Vehicles:
<truncated after showing first 30 lines>
---------- Differences in sumoTrips ----------
3,4c3,4
< <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#2" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
< <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#2" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---
> <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#1" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
> <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#1" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---------- Differences in output ----------
102,105c102,103
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
107c105,107
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
109,113c109,110
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
119d115
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
121c117,118
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in output ----------
84,87c84,85
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
89c87,89
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
91,95c91,92
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
101d97
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
103c99,100
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
template tscDaemonDatabaseTripsFromFile (
Last six runs
Jan2023
)---------- Differences in errors ----------
81a82,98
> Process Process-1:
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 121, in insertmany
> cursor.executemany(command, parameters)
> sqlite3.OperationalError: 39 values for 5 columns
---------- Differences in output ----------
87,90c87,88
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
92c90,92
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
94,98c94,95
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
104d100
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
106c102,103
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in errors ---------- 127,128c127 < Warning: Ambiguous tram edges '30710062#3' and '30710062#4' for lane '4685730#0_1'. < Warning: Ambiguous tram edges '24864947#21' and '24864947#22' for lane '33685647#0_1'. --- > Warning: Ambiguous tram edges '4791641#10' and '4791641#11' for lane '-112441857#0_1'. 131a131 > Warning: Ambiguous tram edges '118423895' and '316975485#0' for lane '291670881#5_3'. 227c227 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 238c238 < Warning: 8 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. --- > Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. 249,250c249,250 < Warning: 7 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. < Warning: 48 total messages of type: Non-static traffic light '%' does not define variable phase length. --- > Warning: 5 total messages of type: Lane '%' is not connected from any incoming edge at junction '%'. > Warning: 49 total messages of type: Non-static traffic light '%' does not define variable phase length. 388c388 < Warning: 9096 total messages of type: No connection between edge '%' and edge '%' found. --- > Warning: 9100 total messages of type: No connection between edge '%' and edge '%' found. ---------- Differences in output ---------- 73c73 < Joined 160 junction cluster(s). --- > Joined 161 junction cluster(s). 75c75 < 15296 nodes removed. --- > 15294 nodes removed. 113c113 < Dead-end junctions : 83 --- > Dead-end junctions : 84 135c135 < 1690 nodes loaded. --- > 1691 nodes loaded. 137c137 < 3902 edges loaded. --- > 3903 edges loaded. 165c165 < Dead-end junctions : 83 --- > Dead-end junctions : 84 187,188c187,188 < importing shapes from /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... < polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/behr_mi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO --- > importing shapes from /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.dbf ... > polyconvert -n <texttest sandbox>/scenario_templates/mitte_test/net.net.xml.gz -o <texttest sandbox>/scenario_templates/mitte_test/Berlin Verkehrsbezirke (1193 VBz) GK4_zone.poly.xml.gz --shapefile-prefixes /home/delphi/tsc/data/berlin_net/shapes/Berlin Verkehrsbezirke (1193 VBz) GK4_zone --shapefile.add-param --shapefile.traditional-axis-mapping --shapefile.id-column NO <truncated after showing first 30 lines>
---------- Differences in errors ----------
92a93,121
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 124, in insertmany
> psycopg2.extras.execute_values(cursor, command, parameters)
> File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1270, in execute_values
> cur.execute(b''.join(parts))
> psycopg2.errors.SyntaxError: INSERT has more expressions than target columns
> LINE 1: ...terval_end, entry_id) VALUES ('(','1','1','0','1','0','0','1...
> ^
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 469, in simulation_request
> conn.rollback()
> psycopg2.InterfaceError: connection already closed
<truncated after showing first 30 lines>
---------- Differences in output ----------
91,94c91,92
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
96c94,96
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
98,102c98,99
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
108d104
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
110c106,107
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in catalogue ----------
7,10c7,10
< ----------------Berlin_1223.taz.xml
< ----------------RBS_OD_ORT_1412.taz.xml
< ----------------bidi.taz.xml
< ----------------districts.taz.xml
---
> ----------------Berlin_1223.taz.xml.gz
> ----------------RBS_OD_ORT_1412.taz.xml.gz
> ----------------bidi.taz.xml.gz
> ----------------districts.taz.xml.gz
13c13,14
< ----------------net.net.xml
---
> ----------------landmarks.csv.gz
> ----------------net.net.xml.gz
16,40d16
< --------------------emission_routes.xml
< --------------------emissions.sumo.log
< --------------------emissions.sumocfg
< --------------------person_tripinfo.xml
< --------------------persons.sumo.log
< --------------------persons.sumocfg
< --------------------persons.xml
< --------------------allpairs
< ------------------------aggregated_oneshot_meso.xml
< ------------------------all_pairs_passenger24.csv
< ------------------------all_pairs_public.csv
< ------------------------mapped_all_pairs_passenger24.csv
< ------------------------mapped_all_pairs_public.csv
< ------------------------miv_all_pairs_passenger24.trips.duarcfg
<truncated after showing first 30 lines>
---------- Differences in errors ----------
2,18c2,36
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 2 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663498', linkIndex 3 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 10 has no controlling detector.
< Warning: At actuated tlLogic 'GS_25663747', linkIndex 11 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_1679221141_1679221142_29271704_29271705', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 17 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_196725581_21487224_29219437_29219438', linkIndex 18 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 12 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_262476527_311718989_588159289', linkIndex 13 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'GS_cluster_964750391_971891590', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 6 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_1857304353_29784556_29784557_343372788', linkIndex 7 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 5 has no controlling detector.
< Warning: At actuated tlLogic 'cluster_262471375_343590422_3730313106', linkIndex 6 has no controlling detector.
< Warning: Traffic light type 'actuated' cannot be used in mesoscopic simulation. Using 'static' as fallback.
---
> Error: The lane 740848375_1 to use within the busStop 'busStop_0' is not known.
> Error: Could not end a stopping place that is not opened.
> Quitting (on error).
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 434, in simulation_request
> final_routes, final_weights = t2s.main(options)
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/t2s.py", line 627, in main
> return options.script_module.assign_trips(options, first_depart, last_depart, options.trips_for_dua, options.weights)
<truncated after showing first 30 lines>
---------- Differences in output ----------
5c5
< [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '0'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
---
> [('DB_CAR_FLEET_KEY', 'MID2008_Y2010_BERLIN'), ('DB_HH_SAMPLE_SIZE', '1.0'), ('DB_TABLE_ADDITIONAL_TRAFFIC', ''), ('DB_TABLE_CARS', 'berlin_cars'), ('DB_TABLE_REPRESENTATIVES', 'berlin_location_representatives'), ('DB_TABLE_SUMO_OD_ENTRY', 'sumo_od_entry'), ('DB_TABLE_SUMO_OD_OUTPUT', 'sumo_od'), ('DB_TABLE_SUMO_STATUS', 'global_sumo_status'), ('DB_TABLE_SUMO_TRIP_OUTPUT', 'sumo_trip'), ('DB_TABLE_TAZ', 'berlin_taz'), ('DB_TABLE_TRIPS', 'berlin_trips'), ('DELETE_INTERMEDIATE_RESULTS', 'false')
, ('DELETE_TEMP', 'false'), ('ITERATION', '0'), ('MAX_SUMO_ITERATION', '1'), ('SHARING_FLEET_SIZE', '100'), ('SHARING_VEHICLE_CAPACITY', '5'), ('SLICE', [24]), ('SUMO_DESTINATION_FOLDER', 'mitte_net'), ('SUMO_MODES', '6'), ('SUMO_NET_PARAMETER', '{}'), ('SUMO_TEMPLATE_FOLDER', 'mitte_net'), ('SUMO_TRIP_FILTER', '')]
9,10c9,10
< db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly_walking.csv
< Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly_walking.csv".
---
> db_status_message: berlin_2010 0 >> starting t2s using tripfile twoPersonsOnly.csv
> Read 2 persons with a total of 4 trips from input file "<texttest sandbox>/data/twoPersonsOnly.csv".
12c12
< Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.
---
> Mapping using <texttest sandbox>/data/scenario_workdir/mitte_net/districts.taz.xml.gz.
14c14
< Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#2, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 28.28, Q1 27.13, median 34.00, Q3 42.56
---
> Mapping deviations: count 8, min 9.41 (xycoord=(720.7678498803871, 1303.540090534836), edge=320462164#1, uid=('1000005', '1000001')), max 42.56 (xycoord=(568.7532229983481, 913.0316369170323), edge=-4588215#5, uid=('1000019', '1000003')), mean 27.86, Q1 26.08, median 33.39, Q3 42.56
19c19
< Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml' ...
---
> Loading net-file from '<texttest sandbox>/data/scenario_workdir/mitte_net/net.net.xml.gz' ...
23,1131c23,26
< Loading additional-files from '<texttest sandbox>/data/scenario_workdir/mitte_net/bidi.taz.xml' ... done ((TIME)).
< Loading done.
< Simulation started with time: 135131.00.
< Simulation ended at time: 148151.00
< Reason: The final simulation step has been reached.
< Performance:
< Vehicles:
<truncated after showing first 30 lines>
---------- Differences in sumoTrips ----------
3,4c3,4
< <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#2" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
< <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#2" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---
> <person id="1000005_1000001_817_0" depart="135225"><personTrip fromTaz="320462164#1" toTaz="340716730#1" modes="taxi"/><param key="taz_id_start" value="110110312"/><param key="taz_id_end" value="110311212"/></person>
> <person id="1000005_1000001_850_0" depart="137205"><personTrip fromTaz="340716730#1" toTaz="320462164#1" modes="taxi"/><param key="taz_id_start" value="110311212"/><param key="taz_id_end" value="110110312"/></person>
---------- Differences in output ----------
102,105c102,103
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
107c105,107
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
109,113c109,110
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
119d115
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
121c117,118
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
---------- Differences in output ----------
84,87c84,85
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
89c87,89
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
91,95c91,92
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
101d97
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
103c99,100
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>
template tscDaemonDatabaseTripsFromFile (
Last six runs
Jan2023
)---------- Differences in errors ----------
81a82,110
> Process Process-1:
> Traceback (most recent call last):
> File "/home/delphi/tsc/tsc_main.py", line 459, in simulation_request
> run_all_pairs(options, conn, sim_key, params, final_routes, final_weights)
> File "/home/delphi/tsc/tsc_main.py", line 319, in run_all_pairs
> startIdx = s2t_pt.upload_all_pairs(conn, all_pair_tables, 31 * 3600, 32 * 3600,
> File "/home/delphi/sumo/tools/sumolib/miscutils.py", line 41, in benchmark_wrapper
> result = func(*args, **kwargs)
> File "/home/delphi/tsc/s2t_pt.py", line 151, in upload_all_pairs
> db_manipulator.insertmany(conn, odQuery, odValues)
> File "/home/delphi/tsc/db_manipulator.py", line 124, in insertmany
> psycopg2.extras.execute_values(cursor, command, parameters)
> File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1270, in execute_values
> cur.execute(b''.join(parts))
> psycopg2.errors.SyntaxError: INSERT has more expressions than target columns
> LINE 1: ...terval_end, entry_id) VALUES ('(','1','1','0','1','0','0','1...
> ^
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
> self.run()
> File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run
> self._target(*self._args, **self._kwargs)
> File "/home/delphi/tsc/tsc_main.py", line 469, in simulation_request
> conn.rollback()
> psycopg2.InterfaceError: connection already closed
<truncated after showing first 30 lines>
---------- Differences in output ----------
87,90c87,88
< Warning: could not find an edge for departure of ('1100020098', '1100020097') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020098') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020098', '1100020095') from (52.53589568, 13.32689285), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020096', '1100020099') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020096', '1100020095') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
92c90,92
< Warning: could not find an edge for departure of ('1100020097', '1100152896') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
---
> Warning: could not find an edge for departure of ('1100020099', '1100020099') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100020098') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020095', '1100177160') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
94,98c94,95
< Warning: could not find an edge for departure of ('1100020099', '1100152890') from (52.53363167, 13.32717288), depart_minute=0 (skipping trip)
< Warning: could not find an edge for departure of ('1100020095', '1100152878') from (52.53523868, 13.32864885), depart_minute=0 (skipping trip)
< Mapping (1087.4520966036944, 2279.0150752263144) to 437325051#0 (dist: 8.82) which is not in taz 110109822, best match in taz is -7917219#3 (dist: 120.93)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
< Mapping (1577.1669913597289, 2934.633303419687) to -172078325#4 (dist: 8.67) which is not in taz 110109912, best match in taz is 4597254 (dist: 64.22)
---
> Warning: could not find an edge for departure of ('1100020096', '1100177160') from (52.53548668, 13.32863285), depart_minute=0 (skipping trip)
> Warning: could not find an edge for departure of ('1100020097', '1100152917') from (52.53598968, 13.32686285), depart_minute=0 (skipping trip)
104d100
< Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
106c102,103
< Mapping (1787.6123460037634, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
---
> Mapping (3399.359839078621, 2007.5262750424445) to 932637371 (dist: 56.41) which is not in taz 110110513, best match in taz is 4615497#0 (dist: 140.02)
> Mapping (1787.6123460038216, 4.49782804492861) to -32938436#1 (dist: 184.60) which is not in taz 110201215, best match in taz is 4612404#0 (dist: 418.22)
<truncated after showing first 30 lines>