Nick Mills-Barrett

Hm, finally testing this but it seems to be working correctly, firstly created a container with a read only dir: ``` docker run -it -v `pwd`:/opt/pyinfra:ro ubuntu ``` Then tried...

~Was just looking at the indices on the `e2e_room_keys` table and spotted there's one missing in the above list `e2e_room_keys_with_version_idx` which was added in [this delta](https://github.com/matrix-org/synapse/blob/develop/synapse/storage/schema/main/delta/56/fix_room_keys_index.sql).~ ignore me misread the...

> I see this both on `matrix.org` and my personal server. Do you see something different? 😅please ignore me - I thought the list above was every index not a...

Yes!: Since bringing in https://github.com/matrix-org/synapse/commit/a466164647b969efd2e85168144cd75693443c05 this is now reduced to a single index lookup since the join is gone, but still makes sense to use `batch_iter` I think. ``` Gather...

Thank you for the detailed write up @phlummox! Indeed this is a regression with the recent changes to make SSH host keys behave like OpenSSH. Would you mind PR-ing that...

@jaysoffian I have just merged in https://github.com/Fizzadar/pyinfra/commit/591ea61e3b29210ccb5ac71665920f1374a51e18 which I believe solves this issue (and any other host state needs within operation execution context).

Unfortunately this is an upstream problem with the SSH library used by pyinfra, Paramiko: https://github.com/paramiko/paramiko/issues/771

Leaving this open as it’s unresolved but relabelled as a dependency issue.

I'm keen on this too once Python 2 support is removed in v2 (https://github.com/Fizzadar/pyinfra/issues/329). The connectors will also need support: + SSH: replacement for `paramiko` (https://github.com/ronf/asyncssh looks like a good...

@oz123 I was literally just thinking this! Was doing some digging into unrelated things (parallelisation of operation calls) which uses gevent local objects and it turns out asyncio only has...