aio-libs / aio-libs/aioodbc

calling `executemany` async concurrently leads to "Segamentation fault"

Ouverte
#243 2 commentaires 1 réaction 0 personnes assignées Voir sur GitHub
Langage dominant
Python
Étoiles
326
Forks
62
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

I'm using `aioodbc` to talk to MySQL. `executemany` works for me in inserting many rows into a table. Hoping to increase throughput, I tried to async call `executemany` concurrently like this:

```
async for x in data:
task = asyncio.ensure_future(cursor.executemany(...))
await queue.put(task)
```

The queue has capacity 10. This leads to `Segmentation fault` w/o any additional info. I guess this has to do with the interaction between async and threads, but don't know for sure. Any idea why this is happening? Thanks.

Guide de contribution

Ouvrir le guide de contribution

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.