runtime error
Exit code: 1. Reason: rt_module return _bootstrap._gcd_import(name[level:], package, level) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1204, in _gcd_import File "<frozen importlib._bootstrap>", line 1176, in _find_and_load File "<frozen importlib._bootstrap>", line 1147, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 690, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 940, in exec_module File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed File "/home/user/app/src/app.py", line 22, in <module> db = init_db() ^^^^^^^^^ File "/home/user/app/src/db_manager.py", line 63, in init_db con.execute(f"CREATE OR REPLACE TABLE {table_name} AS SELECT * FROM read_csv_auto('{abs_file_path}')") _duckdb.ConversionException: Conversion Error: CSV Error on Line: 105446 Original Line: t_fb1_sb_1,829,8001,To Dufferin Gate Express,,0,,shape_829_sb,1,1 Error when converting column "trip_id". Could not convert string "t_fb1_sb_1" to 'BIGINT' Column trip_id is being converted as type BIGINT This type was auto-detected from the CSV file. Possible solutions: * Override the type for this column manually by setting the type explicitly, e.g., types={'trip_id': 'VARCHAR'} * Set the sample size to a larger value to enable the auto-detection to scan more values, e.g., sample_size=-1 * Use a COPY statement to automatically derive types from an existing table. * Check whether the null string value is set correctly (e.g., nullstr = 'N/A') file = /home/user/app/static/trips.txt delimiter = , (Auto-Detected) quote = (empty) (Auto-Detected) escape = (empty) (Auto-Detected) new_line = \r\n (Auto-Detected) header = true (Auto-Detected) skip_rows = 0 (Auto-Detected) comment = (empty) (Auto-Detected) strict_mode = true (Auto-Detected) date_format = (Auto-Detected) timestamp_format = (Auto-Detected) null_padding = 0 sample_size = 20480 ignore_errors = false all_varchar = 0
Container logs:
Fetching error logs...