Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error in siri-update-rides-gtfs: time data '2023-03-20' does not match format '%y-%m-%d' #14

Open
OriHoch opened this issue Mar 21, 2023 · 0 comments
Assignees

Comments

@OriHoch
Copy link
Contributor

OriHoch commented Mar 21, 2023

I reverted the PR, so after it's fixed a new PR needs to be opened from here

[2023-03-21 14:00:22,787] {bash.py:173} INFO - min_date=2023-03-20
[2023-03-21 14:00:22,787] {bash.py:173} INFO - max_date=2023-03-21
[2023-03-21 14:00:22,787] {bash.py:173} INFO - Getting siri_route_ids / dates...
[2023-03-21 14:00:22,787] {bash.py:173} INFO - 
[2023-03-21 14:00:22,788] {bash.py:173} INFO - select date_trunc('day', siri_ride.scheduled_start_time) scheduled_start_date, siri_ride.siri_route_id
[2023-03-21 14:00:22,788] {bash.py:173} INFO - from siri_ride
[2023-03-21 14:00:22,788] {bash.py:173} INFO - where
[2023-03-21 14:00:22,788] {bash.py:173} INFO - siri_ride.gtfs_ride_id is null
[2023-03-21 14:00:22,788] {bash.py:173} INFO - and siri_ride.scheduled_start_time >= '2023-03-20'
[2023-03-21 14:00:22,788] {bash.py:173} INFO - and siri_ride.scheduled_start_time <= '2023-03-21'
[2023-03-21 14:00:22,788] {bash.py:173} INFO - -- if we have updated_duration_minutes it means we updated the duration of the ride
[2023-03-21 14:00:22,788] {bash.py:173} INFO - -- so we have all the ride stops data which we must ensure before making these updates
[2023-03-21 14:00:22,788] {bash.py:173} INFO - and siri_ride.updated_duration_minutes is not null
[2023-03-21 14:00:22,788] {bash.py:173} INFO - 
[2023-03-21 14:00:22,788] {bash.py:173} INFO - group by date_trunc('day', siri_ride.scheduled_start_time), siri_ride.siri_route_id
[2023-03-21 14:00:22,788] {bash.py:173} INFO - order by date_trunc('day', siri_ride.scheduled_start_time), siri_ride.siri_route_id
[2023-03-21 14:00:22,788] {bash.py:173} INFO - 
[2023-03-21 14:00:23,084] {bash.py:173} INFO - Done. Resident memory: 39.33984375mb
[2023-03-21 14:00:23,084] {bash.py:173} INFO - Date: num siri route ids
[2023-03-21 14:00:23,084] {bash.py:173} INFO - 2023-03-20: 259
[2023-03-21 14:00:23,084] {bash.py:173} INFO - 2023-03-21: 8
[2023-03-21 14:00:23,084] {bash.py:173} INFO - Iterating over date / siri route ids
[2023-03-21 14:00:23,084] {bash.py:173} INFO - Processing date 2023-03-20 (259 route ids)
[2023-03-21 14:01:40,369] {bash.py:173} INFO - Traceback (most recent call last):
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/srv/open_bus_pipelines/operators/_api_bash_operator_script.py", line 27, in <module>
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     main(*sys.argv[1:])
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/srv/open_bus_pipelines/operators/_api_bash_operator_script.py", line 18, in main
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     function.callback(**kwargs)
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/usr/local/lib/stride/lib/python3.8/site-packages/open_bus_stride_etl/siri/cli.py", line 44, in update_rides_gtfs
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     main(**kwargs)
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/usr/local/lib/stride/lib/python3.8/site-packages/open_bus_stride_etl/siri/update_rides_gtfs.py", line 82, in main
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     start_date=date, end_date=get_tommorow_date(date),
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/usr/local/lib/stride/lib/python3.8/site-packages/open_bus_stride_etl/siri/update_rides_gtfs.py", line 136, in get_tommorow_date
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     date = datetime.datetime.strptime(date, GTFS_ROTE_DATE_FORMAT)
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/usr/local/lib/python3.8/_strptime.py", line 568, in _strptime_datetime
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     tt, fraction, gmtoff_fraction = _strptime(data_string, format)
[2023-03-21 14:01:40,370] {bash.py:173} INFO -   File "/usr/local/lib/python3.8/_strptime.py", line 349, in _strptime
[2023-03-21 14:01:40,370] {bash.py:173} INFO -     raise ValueError("time data %r does not match format %r" %
[2023-03-21 14:01:40,370] {bash.py:173} INFO - ValueError: time data '2023-03-20' does not match format '%y-%m-%d'
[2023-03-21 14:01:40,411] {bash.py:177} INFO - Command exited with return code 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants