===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : l_n_a
APPLICATION :
COMPOSE_TASK :
MSACCESS : ava
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 13:59:33.98
Enter the new time:
===========================================================================
2025-02-01 13:59:35,882 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-01 13:59:35,883 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-01 13:59:35,883 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-01 13:59:35,884 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-01 12:59:38.270628+00:00 : ===============================================================================.
Progress update 2025-02-01 12:59:38.272135+00:00 : INFO.00.004 Start Launcher.
2025-02-01 13:59:38,272 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'd_n_a', '-m', 'ava']
2025-02-01 13:59:38,275 [root] [launcher.py ] INFO Start launcher.py
2025-02-01 13:59:38,287 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
File "D:\SoftDevelopment\Projects\IO-Aero\io-avstats\scripts\launcher.py", line 179, in <module>
main(sys.argv)
File "D:\SoftDevelopment\Projects\IO-Aero\io-avstats\scripts\launcher.py", line 90, in main
avstats.get_args()
File "D:\SoftDevelopment\Projects\IO-Aero\io-avstats\ioavstats\avstats.py", line 486, in get_args
check_arg_msaccess(parsed_args)
File "D:\SoftDevelopment\Projects\IO-Aero\io-avstats\ioavstats\avstats.py", line 103, in check_arg_msaccess
terminate_fatal(glob_local.ERROR_00_903.replace("{msaccess}", args.msaccess))
File "D:\SoftDevelopment\Projects\IO-Aero\io-avstats\ioavstats\avstats.py", line 848, in terminate_fatal
io_utils.terminate_fatal(error_msg)
File "C:\ProgramData\miniconda3\envs\ioavstats\Lib\site-packages\iocommon\io_utils.py", line 349, in terminate_fatal
traceback.print_stack()
FATAL ERROR: program abort =====>
FATAL ERROR: program abort =====> ERROR.00.903 'ava' is not a valid NTSB compliant MS Access database name <===== FATAL ERROR
FATAL ERROR: program abort =====>
Processing of the script run_io_avstats_dev was aborted
(ioavstats) D:\SoftDevelopment\Projects\IO-Aero\io-avstats>run_io_avstats_dev l_n_a avall
'export' is not recognized as an internal or external command,
operable program or batch file.
Script run_io_avstats_dev is now running
Please wait ...
===========================================================================
Start run_io_avstats_dev
---------------------------------------------------------------------------
IO-AVSTATS - Aviation Event Statistics.
---------------------------------------------------------------------------
ENV_FOR_DYNACONF : prod
PYTHONPATH : .
---------------------------------------------------------------------------
TASK : l_n_a
APPLICATION :
COMPOSE_TASK :
MSACCESS : avall
MSEXCEL :
---------------------------------------------------------------------------
The current time is: 14:00:01.75
Enter the new time:
===========================================================================
2025-02-01 14:00:03,007 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-01 14:00:03,007 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-01 14:00:03,007 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-01 14:00:03,008 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-01 13:00:04.578434+00:00 : ===============================================================================.
Progress update 2025-02-01 13:00:04.578952+00:00 : INFO.00.004 Start Launcher.
2025-02-01 14:00:04,578 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'd_n_a', '-m', 'avall']
2025-02-01 14:00:04,579 [root] [launcher.py ] INFO Start launcher.py
2025-02-01 14:00:04,590 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-01 13:00:04.591413+00:00 : INFO.00.008 Arguments task='d_n_a' msaccess='avall'.
Progress update 2025-02-01 13:00:04.591413+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-01 13:00:04.592413+00:00 : INFO.00.047 Download NTSB MS Access database file 'avall'.
Progress update 2025-02-01 13:00:04.592413+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:00:05.042219+00:00 : INFO.00.013 The connection to the MS Access database file 'avall.zip' on the NTSB download page was successfully established.
Progress update 2025-02-01 13:00:07.473556+00:00 : INFO.00.014 From the file 'avall.zip' 168 chunks were downloaded.
Progress update 2025-02-01 13:00:08.544182+00:00 : INFO.00.015 The file 'avall.zip' was successfully unpacked.
Progress update 2025-02-01 13:00:09.553801+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\IO-AVSTATS.mdb'.
Progress update 2025-02-01 13:00:09.662456+00:00 : INFO.00.051 msaccess_file='D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\avall.sql'.
Progress update 2025-02-01 13:00:09.662456+00:00 : INFO.00.052 razorsql_jar_file='C:\Program Files\RazorSQL\razorsql.jar'.
Progress update 2025-02-01 13:00:09.663457+00:00 : INFO.00.053 razorsql_java_path='C:\Program Files\RazorSQL\jre11\bin\java'.
1738414810026: launching RazorSQL . . .
1738414810026: args . . .
-backup
IO-AVSTATS
null
null
;
null
D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\avall.sql
NO
tables
YES
null
NO
NO
1738414810065: userName: walte
1738414810065: libraryPath: C:\Program Files\RazorSQL\jre11\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\miniconda3\envs\ioavstats;C:\ProgramData\miniconda3\envs\ioavstats\Library\mingw-w64\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\usr\bin;C:\ProgramData\miniconda3\envs\ioavstats\Library\bin;C:\ProgramData\miniconda3\envs\ioavstats\Scripts;C:\ProgramData\miniconda3\envs\ioavstats\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\Python313\Scripts;C:\Program Files\Python313;C:\Program Files (x86)\infogridpacific\AZARDI;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\dotnet;C:\Program Files\Git LFS;C:\Program Files\Microsoft SQL Server\110\Tools\Binn;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Software\GnuWin32\bin;C:\WINDOWS;C:\WINDOWS\System32;C:\WINDOWS\System32\OpenSSH;C:\WINDOWS\System32\wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;\bin;\bin;\bin;C:\ProgramData\miniconda3\condabin;C:\Program Files\PostgreSQL\16\bin;C:\Software\jdk-20.0.1\bin;C:\Program Files\PuTTY;C:\Software\LAStools\bin;C:\Software\GnuPG\bin;C:\Program Files\nodejs;C:\Program Files\Calibre2;C:\Program Files\Go\bin;C:\Program Files\Git\cmd;C:\Program Files\Zero Install;C:\Program Files\GitHub CLI;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\Docker\Docker\resources\bin;C:\Program Files\TortoiseGit\bin;C:\Program Files\Amazon\AWSCLIV2;C:\Users\walte\.cargo\bin;C:\Users\walte\AppData\Local\Microsoft\WindowsApps;C:\Software\Microsoft VS Code\bin;c:\users\walte\.local\bin;C:\Users\walte\AppData\Local\JetBrains\Toolbox\scripts;C:\Users\walte\AppData\Local\Pandoc;C:\Users\walte\AppData\Local\GitHubDesktop\bin;C:\Users\walte\AppData\Roaming\npm;C:\Users\walte\AppData\Local\Microsoft\WinGet\Links;D:\Batch;C:\Program Files\Redis;C:\ProgramData\miniconda3\condabin;C:\Program Files\JetBrains\JetBrains Gateway 2024.3\bin;.;C:\Users\walte\AppData\Local\Microsoft\WindowsApps;.
1738414810065: javaVersion: 17.0.7
1738414810065:
1738414810065: Verifying RazorSQL resources location.
1738414810065:
1738414810066: testing base url: / = file:/C:/Program%20Files/RazorSQL/
1738414810066:
1738414810066: testString1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1738414810066: testString2: file:/C:/Program%20Files/RazorSQL/data/base.ssql
1738414810066: testFile1: C:\Program Files\RazorSQL\razorsql.jar
1738414810066: testFile2: C:\Program Files\RazorSQL\data\base.ssql
1738414810066: both test file exists. Base URL found.
1738414810066: resource directory: file:/C:/Program%20Files/RazorSQL/
1738414810066: user home: C:\Users\walte
1738414810068: user profile: C:\Users\walte
1738414810068: app data: C:\Users\walte\AppData\Roaming
1738414810068: checking write access to: C:\Users\walte\AppData\Roaming
1738414810068: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1738414810068: can write to C:\Users\walte\AppData\Roaming
1738414810068: user.home: C:\Users\walte\AppData\Roaming
1738414810068: RazorSQL Scratch Directory: C:\Users\walte\AppData\Roaming\RazorSQL
1738414810069: RazorSQL Scratch Directory exists
1738414810069: checking for sub directories
1738414810069: razorsql launch log: C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1738414810069: launch log file = C:\Users\walte\AppData\Roaming\RazorSQL\razorsql_launch_log.txt
1738414810070: Checking for graphics properties
1738414810070: graphics properties file: C:\Users\walte\AppData\Roaming\RazorSQL\data\graphics_properties.txt
1738414810070: gOverride: null
1738414810070: not disabling advanced graphics
1738414810070: path0: file:/C:/Program%20Files/RazorSQL/data/run.ssql
1738414810070: path1: file:/C:/Program%20Files/RazorSQL/razorsql.jar
1738414810070: runArgs: true
1738414810070: showScreen: false
1738414810070: args[0]: -backup
1738414810070: args[1]: IO-AVSTATS
1738414810070: args[2]: null
1738414810070: args[3]: null
1738414810070: args[4]: ;
1738414810070: args[5]: null
1738414810070: args[6]: D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\avall.sql
1738414810070: args[7]: NO
1738414810070: args[8]: tables
1738414810072: args[9]: YES
1738414810072: args[10]: null
1738414810072: args[11]: NO
1738414810072: args[12]: NO
1738414810072: Command: -backup
1738414810072: Running -backup
h: name = C:\Program Files\RazorSQL\data\run.ssql
h: name = C:\Program Files\RazorSQL\razorsql.jar
1738414810079: Attempting to load . . .
command found
uOne: file:/C:/Program%20Files/RazorSQL/
h: name = C:\Program Files\RazorSQL\data\run.ssql
1738414810090reading file . . .C:\Program Files\RazorSQL\data\base.ssql
1738414810115done reading . . .
1738414810134done converting
1738414810134starting lib load.
1738414810144lib load complete.
In command line processor
Max Memory: 30688.0
Current Total Memory: 2048.0
Free Memory: 1916.0260467529297
1738414810218: r init
1738414810218: d init
1738414810218: get default file encoding
1738414810218: end d init
custom home directory: null
Checking for user data from old versions
1738414810220: user home: C:\Users\walte
1738414810221: user profile: C:\Users\walte
1738414810221: app data: C:\Users\walte\AppData\Roaming
1738414810221: checking write access to: C:\Users\walte\AppData\Roaming
1738414810221: write dir: C:\Users\walte\AppData\Roaming\RichardsonSoftware
1738414810221: can write to C:\Users\walte\AppData\Roaming
newHome: C:\Users\walte\AppData\Roaming\RazorSQL
dataHome: C:\Users\walte\AppData\Roaming/RazorSQL/data/
preferences file: C:\Users\walte\AppData\Roaming\RazorSQL\data\preferences.txt
Profiles Exist
1738414810235: loading icons
1738414810693: done r init
Getting connection data from: IO-AVSTATS
1738414810695: r init
1738414810695: d init
1738414810695: get default file encoding
1738414810695: end d init
custom home directory: null
Checking for user data from old versions
newHome: C:\Users\walte\AppData\Roaming\RazorSQL
dataHome: C:\Users\walte\AppData\Roaming/RazorSQL/data/
preferences file: C:\Users\walte\AppData\Roaming\RazorSQL\data\preferences.txt
Profiles Exist
1738414810695: loading icons
1738414810709: done r init
getting connection . . .
Not using SSH Tunnel
driver: sun.jdbc.odbc.JdbcOdbcDriver
classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
loadedCommonJars: false
commonURL: file:/C:/Program%20Files/RazorSQL/drivers/common/
commonDir: C:\Program Files\RazorSQL\drivers\common
commonFiles[0]: file:/C:/Program%20Files/RazorSQL/drivers/common/activation.jar
commonFiles[1]: file:/C:/Program%20Files/RazorSQL/drivers/common/common.jar
commonFiles[2]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-api.jar
commonFiles[3]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-core.jar
commonFiles[4]: file:/C:/Program%20Files/RazorSQL/drivers/common/jaxb-impl.jar
commonFiles[6]: file:/C:/Program%20Files/RazorSQL/drivers/common/odbc.jar
connection type: ODBC
final classLocation: C:\Program Files\RazorSQL\drivers\common\odbc.jar
classLocation file: C:\Program Files\RazorSQL\drivers\common\odbc.jar
building sql manager
Loading driver
Done loading driver
Getting connection with no login info
JdbcOdbcDriver: in initialize
OdbcApi == null
Creating new OdbcApi, nativePrefix:
JdbcOdbc constructor
Attempting to load JdbcOdbc library
Got OdbcApi: sun.jdbc.odbc.JdbcOdbc@77846d2c
Getting charset
JdbcOdbcDriver.OdbcApi.charSet: Cp1252
Connection obtained
obtained connection
database major version = 2
database product name: ACCESS
multiValueInsert: false
includeIdentifyColumns: false
Calling backup . . .
Retrieving Tables . . .
Generating Table DDL . . .
1 of 20
number of columns 93
column map size: 93
foundNull: false
2 of 20
number of columns 2
column map size: 2
foundNull: false
3 of 20
number of columns 11
column map size: 11
foundNull: false
4 of 20
number of columns 2
column map size: 2
foundNull: false
5 of 20
number of columns 6
column map size: 6
foundNull: false
6 of 20
number of columns 5
column map size: 5
foundNull: false
7 of 20
number of columns 7
column map size: 7
foundNull: false
8 of 20
number of columns 13
column map size: 13
foundNull: false
9 of 20
number of columns 17
column map size: 17
foundNull: false
10 of 20
number of columns 73
column map size: 73
foundNull: false
11 of 20
number of columns 10
column map size: 10
foundNull: false
12 of 20
number of columns 14
column map size: 14
foundNull: false
13 of 20
number of columns 33
column map size: 33
foundNull: false
14 of 20
number of columns 8
column map size: 8
foundNull: false
15 of 20
number of columns 7
column map size: 7
foundNull: false
16 of 20
number of columns 8
column map size: 8
foundNull: false
17 of 20
number of columns 5
column map size: 5
foundNull: false
18 of 20
number of columns 8
column map size: 8
foundNull: false
19 of 20
number of columns 11
column map size: 11
foundNull: false
20 of 20
number of columns 3
column map size: 3
foundNull: false
Generating Alter Table DDL . . .
1 of 20
2 of 20
3 of 20
4 of 20
5 of 20
6 of 20
7 of 20
8 of 20
9 of 20
10 of 20
11 of 20
12 of 20
13 of 20
14 of 20
15 of 20
16 of 20
17 of 20
18 of 20
19 of 20
20 of 20
backup finished
closing connection . . .
connection closed.
Shutting down logging streams
Done shutting down logging streams
Exiting . . .
Progress update 2025-02-01 13:00:12.470991+00:00 : INFO.00.011 The DDL script for the MS Access database 'avall.mdb' was created successfully.
Progress update 2025-02-01 13:00:12.548204+00:00 : INFO.00.012 The DDL script for the MS Access database 'avall.mdb' is identical to the reference script.
Progress update 2025-02-01 13:00:12.549205+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-01 13:00:12.549205+00:00 : 7 s - Total time launcher.
Progress update 2025-02-01 13:00:12.549205+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-01 13:00:12.549205+00:00 : ===============================================================================.
2025-02-01 14:00:14,307 [root] [io_logger.py ] INFO You are using io-aero's iocommon version 1.2.63 logger (Copyright (c) 2022-2024 IO-Aero)
2025-02-01 14:00:14,307 [root] [io_settings.py ] INFO Starting the configuration management system.
2025-02-01 14:00:14,308 [root] [io_settings.py ] INFO Running in a source (non-compiled) environment. Configuration loading from: D:\SoftDevelopment\Projects\IO-Aero\io-avstats
2025-02-01 14:00:14,308 [root] [io_settings.py ] INFO Dynaconf settings loaded successfully.
Progress update 2025-02-01 13:00:15.853665+00:00 : ===============================================================================.
Progress update 2025-02-01 13:00:15.853665+00:00 : INFO.00.004 Start Launcher.
2025-02-01 14:00:15,853 [root] [launcher.py ] INFO param argv=['scripts\\launcher.py', '-t', 'l_n_a', '-m', 'avall']
2025-02-01 14:00:15,853 [root] [launcher.py ] INFO Start launcher.py
2025-02-01 14:00:15,865 [root] [launcher.py ] INFO locale=('en_US', 'UTF-8')
Progress update 2025-02-01 13:00:15.867178+00:00 : INFO.00.008 Arguments task='l_n_a' msaccess='avall'.
Progress update 2025-02-01 13:00:15.867178+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-01 13:00:15.867178+00:00 : INFO.00.049 Load NTSB MS Access database data from file 'avall'.
Progress update 2025-02-01 13:00:15.867178+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:00:15.867178+00:00 : INFO.00.054 ODBC driver='DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\SoftDevelopment\Projects\IO-Aero\io-avstats\data\download\avall.mdb;'.
2025-02-01 14:00:16,321 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-01 13:00:16.439097+00:00 : INFO.00.021 The following database table is not processed: 'MSysAccessObjects'.
Progress update 2025-02-01 13:00:16.439097+00:00 : INFO.00.021 The following database table is not processed: 'MSysACEs'.
Progress update 2025-02-01 13:00:16.439097+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXColumns'.
Progress update 2025-02-01 13:00:16.439615+00:00 : INFO.00.021 The following database table is not processed: 'MSysIMEXSpecs'.
Progress update 2025-02-01 13:00:16.439615+00:00 : INFO.00.021 The following database table is not processed: 'MSysModules2'.
Progress update 2025-02-01 13:00:16.439615+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupCategories'.
Progress update 2025-02-01 13:00:16.439615+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroups'.
Progress update 2025-02-01 13:00:16.439615+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneGroupToObjects'.
Progress update 2025-02-01 13:00:16.440139+00:00 : INFO.00.021 The following database table is not processed: 'MSysNavPaneObjectIDs'.
Progress update 2025-02-01 13:00:16.440139+00:00 : INFO.00.021 The following database table is not processed: 'MSysObjects'.
Progress update 2025-02-01 13:00:16.440139+00:00 : INFO.00.021 The following database table is not processed: 'MSysQueries'.
Progress update 2025-02-01 13:00:16.440139+00:00 : INFO.00.021 The following database table is not processed: 'MSysRelationships'.
Progress update 2025-02-01 13:00:16.440139+00:00 : INFO.00.021 The following database table is not processed: 'Country'.
Progress update 2025-02-01 13:00:16.440659+00:00 : INFO.00.021 The following database table is not processed: 'ct_iaids'.
Progress update 2025-02-01 13:00:16.440659+00:00 : INFO.00.021 The following database table is not processed: 'ct_seqevt'.
Progress update 2025-02-01 13:00:16.440659+00:00 : INFO.00.021 The following database table is not processed: 'eADMSPUB_DataDictionary'.
Progress update 2025-02-01 13:00:16.440659+00:00 : INFO.00.021 The following database table is not processed: 'states'.
Progress update 2025-02-01 13:00:16.440659+00:00 :
Progress update 2025-02-01 13:00:16.441177+00:00 : Database table : events <-----------------------------------.
Progress update 2025-02-01 13:00:25.862757+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:00:33.545804+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:00:39.925253+00:00 : Number rows selected : 28332.
Progress update 2025-02-01 13:00:39.925757+00:00 : Number rows inserted : 28332.
Progress update 2025-02-01 13:00:39.956334+00:00 :
Progress update 2025-02-01 13:00:39.956334+00:00 : Database table : aircraft <-----------------------------------.
Progress update 2025-02-01 13:00:50.555687+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:00:59.436590+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:01:07.301490+00:00 : Number rows selected : 28795.
Progress update 2025-02-01 13:01:07.301490+00:00 : Number rows inserted : 28795.
Progress update 2025-02-01 13:01:07.334123+00:00 :
Progress update 2025-02-01 13:01:07.334123+00:00 : Database table : dt_events <-----------------------------------.
Progress update 2025-02-01 13:01:13.549459+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:01:19.289511+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:01:25.124949+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:01:30.719681+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:01:36.335196+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:01:41.974468+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:01:47.673383+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-01 13:01:53.547048+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-01 13:01:59.212552+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-01 13:02:04.915822+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-01 13:02:06.185087+00:00 : Number rows selected : 102093.
Progress update 2025-02-01 13:02:06.186085+00:00 : Number rows inserted : 102093.
Progress update 2025-02-01 13:02:06.196086+00:00 :
Progress update 2025-02-01 13:02:06.196086+00:00 : Database table : ntsb_admin <-----------------------------------.
Progress update 2025-02-01 13:02:12.059302+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:02:17.823430+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:02:19.119069+00:00 : ERROR.00.946 The ev_id '20210527103155' is missing in database table events.
Progress update 2025-02-01 13:02:19.897600+00:00 : ERROR.00.946 The ev_id '20220328104839' is missing in database table events.
Progress update 2025-02-01 13:02:22.523648+00:00 : Number rows selected : 28332.
Progress update 2025-02-01 13:02:22.523648+00:00 : Number rows inserted : 28330.
Progress update 2025-02-01 13:02:22.528648+00:00 :
Progress update 2025-02-01 13:02:22.529647+00:00 : Database table : dt_aircraft <-----------------------------------.
Progress update 2025-02-01 13:02:29.645605+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:02:35.627157+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:02:41.765614+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:02:47.584769+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:02:53.406307+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:02:59.278416+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:03:05.244519+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-01 13:03:11.343102+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-01 13:03:17.285230+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-01 13:03:23.248215+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-01 13:03:29.164471+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-01 13:03:35.018927+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-01 13:03:40.842757+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-01 13:03:46.682869+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-01 13:03:52.526739+00:00 : Number of rows so far read : 150000.
Progress update 2025-02-01 13:03:58.363472+00:00 : Number of rows so far read : 160000.
Progress update 2025-02-01 13:04:04.179182+00:00 : Number of rows so far read : 170000.
Progress update 2025-02-01 13:04:10.048265+00:00 : Number of rows so far read : 180000.
Progress update 2025-02-01 13:04:15.892902+00:00 : Number of rows so far read : 190000.
Progress update 2025-02-01 13:04:21.743791+00:00 : Number of rows so far read : 200000.
Progress update 2025-02-01 13:04:27.514320+00:00 : Number of rows so far read : 210000.
Progress update 2025-02-01 13:04:33.320998+00:00 : Number of rows so far read : 220000.
Progress update 2025-02-01 13:04:39.111655+00:00 : Number of rows so far read : 230000.
Progress update 2025-02-01 13:04:44.908944+00:00 : Number of rows so far read : 240000.
Progress update 2025-02-01 13:04:46.466409+00:00 : Number rows selected : 242688.
Progress update 2025-02-01 13:04:46.466409+00:00 : Number rows inserted : 242688.
Progress update 2025-02-01 13:04:46.491939+00:00 :
Progress update 2025-02-01 13:04:46.491939+00:00 : Database table : engines <-----------------------------------.
Progress update 2025-02-01 13:04:52.839972+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:04:58.580208+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:05:02.104748+00:00 : Number rows selected : 25871.
Progress update 2025-02-01 13:05:02.104748+00:00 : Number rows inserted : 25871.
Progress update 2025-02-01 13:05:02.111280+00:00 :
Progress update 2025-02-01 13:05:02.112285+00:00 : Database table : events_sequence <-----------------------------------.
Progress update 2025-02-01 13:05:08.752791+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:05:14.917936+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:05:20.723739+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:05:26.611452+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:05:32.496169+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:05:38.428115+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:05:39.036072+00:00 : Number rows selected : 60980.
Progress update 2025-02-01 13:05:39.036072+00:00 : Number rows inserted : 60980.
Progress update 2025-02-01 13:05:39.042072+00:00 :
Progress update 2025-02-01 13:05:39.042072+00:00 : Database table : findings <-----------------------------------.
Progress update 2025-02-01 13:05:45.658698+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:05:51.574884+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:05:57.513949+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:06:03.496772+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:06:10.203435+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:06:16.576195+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:06:20.591915+00:00 : Number rows selected : 66532.
Progress update 2025-02-01 13:06:20.591915+00:00 : Number rows inserted : 66532.
Progress update 2025-02-01 13:06:20.602916+00:00 :
Progress update 2025-02-01 13:06:20.602916+00:00 : Database table : flight_crew <-----------------------------------.
Progress update 2025-02-01 13:06:27.590083+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:06:33.612713+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:06:39.228531+00:00 : Number rows selected : 29195.
Progress update 2025-02-01 13:06:39.228531+00:00 : Number rows inserted : 29195.
Progress update 2025-02-01 13:06:39.238045+00:00 :
Progress update 2025-02-01 13:06:39.238045+00:00 : Database table : injury <-----------------------------------.
Progress update 2025-02-01 13:06:45.867992+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:06:51.950380+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:06:57.790344+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:07:03.621622+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:07:09.544380+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:07:15.326675+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:07:21.017376+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-01 13:07:26.790750+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-01 13:07:32.647271+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-01 13:07:38.579395+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-01 13:07:44.885171+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-01 13:07:50.742597+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-01 13:07:56.424025+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-01 13:08:02.272792+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-01 13:08:08.179378+00:00 : Number of rows so far read : 150000.
Progress update 2025-02-01 13:08:12.795063+00:00 : Number rows selected : 157773.
Progress update 2025-02-01 13:08:12.795063+00:00 : Number rows inserted : 157773.
Progress update 2025-02-01 13:08:12.807834+00:00 :
Progress update 2025-02-01 13:08:12.807834+00:00 : Database table : narratives <-----------------------------------.
Progress update 2025-02-01 13:09:47.394510+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:11:19.644054+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:11:55.667108+00:00 : Number rows selected : 26424.
Progress update 2025-02-01 13:11:55.668109+00:00 : Number rows inserted : 26424.
Progress update 2025-02-01 13:11:55.711643+00:00 :
Progress update 2025-02-01 13:11:55.711643+00:00 : Database table : occurrences <-----------------------------------.
Progress update 2025-02-01 13:11:55.711643+00:00 : Number rows selected : 0.
Progress update 2025-02-01 13:11:55.712647+00:00 :
Progress update 2025-02-01 13:11:55.712647+00:00 : Database table : dt_flight_crew <-----------------------------------.
Progress update 2025-02-01 13:12:02.506962+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:12:08.578985+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:12:14.478953+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:12:20.360974+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:12:26.284562+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:12:32.224896+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:12:38.181259+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-01 13:12:44.096538+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-01 13:12:49.969555+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-01 13:12:55.993485+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-01 13:13:02.065739+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-01 13:13:08.098109+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-01 13:13:14.004324+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-01 13:13:19.869478+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-01 13:13:25.751938+00:00 : Number of rows so far read : 150000.
Progress update 2025-02-01 13:13:31.635026+00:00 : Number of rows so far read : 160000.
Progress update 2025-02-01 13:13:32.833061+00:00 : Number rows selected : 161971.
Progress update 2025-02-01 13:13:32.833061+00:00 : Number rows inserted : 161971.
Progress update 2025-02-01 13:13:32.846121+00:00 :
Progress update 2025-02-01 13:13:32.846121+00:00 : Database table : flight_time <-----------------------------------.
Progress update 2025-02-01 13:13:40.822515+00:00 : Number of rows so far read : 10000.
Progress update 2025-02-01 13:13:46.654906+00:00 : Number of rows so far read : 20000.
Progress update 2025-02-01 13:13:52.585508+00:00 : Number of rows so far read : 30000.
Progress update 2025-02-01 13:13:58.500941+00:00 : Number of rows so far read : 40000.
Progress update 2025-02-01 13:14:04.432960+00:00 : Number of rows so far read : 50000.
Progress update 2025-02-01 13:14:10.285533+00:00 : Number of rows so far read : 60000.
Progress update 2025-02-01 13:14:16.195915+00:00 : Number of rows so far read : 70000.
Progress update 2025-02-01 13:14:22.061777+00:00 : Number of rows so far read : 80000.
Progress update 2025-02-01 13:14:27.935052+00:00 : Number of rows so far read : 90000.
Progress update 2025-02-01 13:14:33.732484+00:00 : Number of rows so far read : 100000.
Progress update 2025-02-01 13:14:39.515210+00:00 : Number of rows so far read : 110000.
Progress update 2025-02-01 13:14:45.355189+00:00 : Number of rows so far read : 120000.
Progress update 2025-02-01 13:14:51.264113+00:00 : Number of rows so far read : 130000.
Progress update 2025-02-01 13:14:57.168559+00:00 : Number of rows so far read : 140000.
Progress update 2025-02-01 13:15:03.150808+00:00 : Number of rows so far read : 150000.
Progress update 2025-02-01 13:15:09.159463+00:00 : Number of rows so far read : 160000.
Progress update 2025-02-01 13:15:15.238615+00:00 : Number of rows so far read : 170000.
Progress update 2025-02-01 13:15:21.128461+00:00 : Number of rows so far read : 180000.
Progress update 2025-02-01 13:15:26.952320+00:00 : Number of rows so far read : 190000.
Progress update 2025-02-01 13:15:32.858318+00:00 : Number of rows so far read : 200000.
Progress update 2025-02-01 13:15:38.782658+00:00 : Number of rows so far read : 210000.
Progress update 2025-02-01 13:15:44.672162+00:00 : Number of rows so far read : 220000.
Progress update 2025-02-01 13:15:50.529234+00:00 : Number of rows so far read : 230000.
Progress update 2025-02-01 13:15:56.394175+00:00 : Number of rows so far read : 240000.
Progress update 2025-02-01 13:16:02.285049+00:00 : Number of rows so far read : 250000.
Progress update 2025-02-01 13:16:08.133220+00:00 : Number of rows so far read : 260000.
Progress update 2025-02-01 13:16:13.989744+00:00 : Number of rows so far read : 270000.
Progress update 2025-02-01 13:16:19.837092+00:00 : Number of rows so far read : 280000.
Progress update 2025-02-01 13:16:25.727459+00:00 : Number of rows so far read : 290000.
Progress update 2025-02-01 13:16:31.517913+00:00 : Number of rows so far read : 300000.
Progress update 2025-02-01 13:16:37.391825+00:00 : Number of rows so far read : 310000.
Progress update 2025-02-01 13:16:43.207050+00:00 : Number of rows so far read : 320000.
Progress update 2025-02-01 13:16:49.054776+00:00 : Number of rows so far read : 330000.
Progress update 2025-02-01 13:16:54.902751+00:00 : Number of rows so far read : 340000.
Progress update 2025-02-01 13:17:00.652534+00:00 : Number of rows so far read : 350000.
Progress update 2025-02-01 13:17:06.892296+00:00 : Number of rows so far read : 360000.
Progress update 2025-02-01 13:17:10.549725+00:00 : Number rows selected : 366014.
Progress update 2025-02-01 13:17:10.549725+00:00 : Number rows inserted : 366014.
Progress update 2025-02-01 13:17:10.592944+00:00 :
Progress update 2025-02-01 13:17:10.593944+00:00 : Database table : seq_of_events <-----------------------------------.
Progress update 2025-02-01 13:17:10.593944+00:00 : Number rows selected : 0.
Progress update 2025-02-01 13:17:10.951735+00:00 : INFO.00.065 Cleansing PostgreSQL data.
Progress update 2025-02-01 13:17:10.951735+00:00 : --------------------------------------------------------------------------------
2025-02-01 14:17:10,952 [root] [db_utils.py ] INFO INFO.00.080 Admin connect request host=localhost port=5432 dbname=io_aero_db user=io_aero
Progress update 2025-02-01 13:17:11.025700+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'acft_category'.
Progress update 2025-02-01 13:17:11.895080+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:11.895080+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dest_country'.
Progress update 2025-02-01 13:17:12.493596+00:00 : Number cols trimmed : 1587.
Progress update 2025-02-01 13:17:12.961257+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:12.961257+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'dprt_country'.
Progress update 2025-02-01 13:17:13.515184+00:00 : Number cols trimmed : 1658.
Progress update 2025-02-01 13:17:13.973118+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:13.974119+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'far_part'.
Progress update 2025-02-01 13:17:14.855392+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:14.856392+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'oper_country'.
Progress update 2025-02-01 13:17:15.365116+00:00 : Number cols trimmed : 1611.
Progress update 2025-02-01 13:17:15.807158+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:15.807158+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'owner_country'.
Progress update 2025-02-01 13:17:16.297293+00:00 : Number cols trimmed : 1542.
Progress update 2025-02-01 13:17:16.726453+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:16.727453+00:00 : INFO.00.066 Cleansing table 'aircraft' column 'regis_no'.
Progress update 2025-02-01 13:17:17.188581+00:00 : Number cols trimmed : 38.
Progress update 2025-02-01 13:17:17.604257+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:17.604257+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_city'.
Progress update 2025-02-01 13:17:18.008910+00:00 : Number cols trimmed : 6.
Progress update 2025-02-01 13:17:18.084075+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:18.084075+00:00 : INFO.00.066 Cleansing table 'events' column 'ev_site_zipcode'.
Progress update 2025-02-01 13:17:18.139197+00:00 : Number cols trimmed : 2.
Progress update 2025-02-01 13:17:18.154808+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:18.154808+00:00 : INFO.00.066 Cleansing table 'events' column 'latitude'.
Progress update 2025-02-01 13:17:18.196572+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:18.196572+00:00 : INFO.00.066 Cleansing table 'events' column 'longitude'.
Progress update 2025-02-01 13:17:18.237165+00:00 : --------------------------------------------------------------------------------
Progress update 2025-02-01 13:17:18.237165+00:00 : INFO.00.066 Cleansing table 'events_sequence' column 'occurrence_code'.
Progress update 2025-02-01 13:17:18.656336+00:00 : Number cols trimmed : 1799.
Progress update 2025-02-01 13:17:18.666335+00:00 : -------------------------------------------------------------------------------.
Progress update 2025-02-01 13:17:18.666335+00:00 : 1,022 s - Total time launcher.
Progress update 2025-02-01 13:17:18.666335+00:00 : INFO.00.006 End Launcher.
Progress update 2025-02-01 13:17:18.666335+00:00 : ===============================================================================.
---------------------------------------------------------------------------
The current time is: 14:17:19.24
Enter the new time:
---------------------------------------------------------------------------
End run_io_avstats_dev
===========================================================================