- asyncpg version: 0.24.0
- PostgreSQL version: PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
- Python version: 3.7.11
- Platform: Windows
- Do you use pgbouncer?: No
- Did you install asyncpg with pip?: Yes
I'm trying to execute this code:
result = await conn.executemany(command=query, args=records)
where query is:
INSERT INTO elexeon_time_series (subject, flow, timestamp, value, update_time, environment) VALUES ($1, $2, $3, $4, $5, $6);
and records consists of the following data:
[{'environment': 'test',
'flow': 'test_flow',
'subject': 'test_subject_K4oESG2YRrnUhld',
'timestamp': Timestamp('2021-08-11 10:34:19.458810'),
'update_time': Timestamp('2021-08-11 12:34:19.458810'),
'value': 0.4},
{'environment': 'test',
'flow': 'test_flow',
'subject': 'test_subject_K4oESG2YRrnUhld',
'timestamp': Timestamp('2021-08-11 11:34:19.458810'),
'update_time': Timestamp('2021-08-11 12:34:19.458810'),
'value': 0.5}]When I try to execute this code, I get a rather cryptic traceback. can anybody explain what it means? What am I doing wrong?
test_postgres_aio.py:60:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
..\..\eunrg_utils\database\postgres_async.py:33: in async_insert_postgres_data
result = await conn.executemany(command=query, args=records)
C:\installs\anaconda\envs\eunrg_utils\lib\site-packages\asyncpg\connection.py:355: in executemany
return await self._executemany(command, args, timeout)
C:\installs\anaconda\envs\eunrg_utils\lib\site-packages\asyncpg\connection.py:1677: in _executemany
result, _ = await self._do_execute(query, executor, timeout)
C:\installs\anaconda\envs\eunrg_utils\lib\site-packages\asyncpg\connection.py:1711: in _do_execute
result = await executor(stmt, None)
asyncpg\protocol\protocol.pyx:254: in bind_execute_many
???
asyncpg\protocol\coreproto.pyx:945: in asyncpg.protocol.protocol.CoreProtocol._bind_execute_many_more
???
asyncpg\protocol\protocol.pyx:220: in genexpr
???
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> ???
E KeyError: 0
asyncpg\protocol\prepared_stmt.pyx:149: KeyError
I'm trying to execute this code:
where query is:
and records consists of the following data:
[{'environment': 'test', 'flow': 'test_flow', 'subject': 'test_subject_K4oESG2YRrnUhld', 'timestamp': Timestamp('2021-08-11 10:34:19.458810'), 'update_time': Timestamp('2021-08-11 12:34:19.458810'), 'value': 0.4}, {'environment': 'test', 'flow': 'test_flow', 'subject': 'test_subject_K4oESG2YRrnUhld', 'timestamp': Timestamp('2021-08-11 11:34:19.458810'), 'update_time': Timestamp('2021-08-11 12:34:19.458810'), 'value': 0.5}]When I try to execute this code, I get a rather cryptic traceback. can anybody explain what it means? What am I doing wrong?