>>> aisdb.decode_msgs(filepaths_2, dbconn=dbconn, psql_conn_string=psql_conn_string, dbpath=None, source='exactEarth', verbose=True)
found matching checksum, skipping /meridian/AIS_archive/meopar/2021/202101/012021_NM4_1.zip
found matching checksum, skipping /meridian/AIS_archive/meopar/2021/202101/012021_NM4_2.zip
Connected to postgres server
exactEarth_historical_data_2021-01-15.nm4 count:19546429 elapsed: 3854.58s rate: 5071 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-16.nm4 count:20367246 elapsed: 2529.55s rate: 8052 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-17.nm4 count:20219131 elapsed: 2549.61s rate: 7930 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-18.nm4 count:20205040 elapsed: 2556.71s rate: 7903 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-19.nm4 count:19903918 elapsed: 2657.11s rate: 7491 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-20.nm4 count:19197514 elapsed: 2453.87s rate: 7823 msgs/s
Connected to postgres server
exactEarth_historical_data_2021-01-21.nm4 count:18074815 elapsed: 2106.02s rate: 8582 msgs/s
['c65b39e7c114e7d7b0fc4468065b7376', b'\x80\x04N.'] INSERT INTO hashmap VALUES (?,?)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/home/smith6/ais/src/aisdb/database/decoder.py", line 250, in decode_msgs
dbindex.insert_checksum(signature)
File "/home/smith6/ais/src/aisdb/database/decoder.py", line 74, in insert_checksum
dbconn.execute('INSERT INTO hashmap VALUES (?,?)',
File "/home/smith6/ais/src/aisdb/database/dbconn.py", line 198, in execute
raise err
File "/home/smith6/ais/src/aisdb/database/dbconn.py", line 195, in execute
cur.execute(sql, args)
File "/home/smith6/ais/env_aisdb/lib/python3.10/site-packages/psycopg/cursor.py", line 723, in execute
raise ex.with_traceback(None)
psycopg.ProgrammingError: the query has 0 placeholders but 2 parameters were passed