Cpu consume 100% when \copy

yandex / odyssey

Scalable PostgreSQL connection pooler

BSD 3-Clause "New" or "Revised" License

3.2k stars 160 forks source link

Cpu consume 100% when \copy #316

Open peresun opened 3 years ago

peresun commented 3 years ago

When I run '\copy ... from ...', odyssey consume 100% CPU. Writev will always retry forever even if no buffer left when NON_BLOCK is set. But I think close NON_BLOCK is not a good idea.

peresun commented 3 years ago

Another question: Does Odyssey correctly handle the problem of successful writing of partial data of writev?

I think mm_iov_advance handle the problem, thanks

x4m commented 3 years ago

Thanks for reaching out. Sorry, i did not have time yet to reproduce the problem. Did you find out that COPY works OK?

peresun commented 3 years ago

Copy works OK, but cpu consume 100%.

At 2021-05-13 17:18:31, "Andrey Borodin" @.***> wrote:

Thanks for reaching out. Sorry, i did not have time yet to reproduce the problem. Did you find out that COPY works OK?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or unsubscribe.

x4m commented 3 years ago

This seems like a bug which we would have to address. Though I still did not reproduce it :(