sidorares/node-mysql2

node-mysql2 hangs for long time without showing anything

開放

#695 建立於 2017年12月6日

 (26 則留言) (2 個反應) (0 位負責人)TypeScript (679 個分叉)github user discovery
help wantedneeds investigationneeds reproduction

倉庫指標

星標
 (4,384 顆星)
PR 合併指標
 (平均合併 18小時 50分鐘) (30 天內合併 29 個 PR)

描述

I have a script, that makes heavy use of node-mysql2. It inserts large number of rows into db, then proceeds to make further modifications to those rows. First part is run as separate promise with lots of async/await.

After the first part, during the early stages of second part script suddenly hangs (at first I attributed that to some kind of terminal IO glitch, but the behaviour is reproducible in different terminals both on Windows and Linux). mysql processlist looks like this

+-----+------+-----------+------+---------+------+-------+-----------------------+----------+
| Id  | User | Host      | db   | Command | Time | State | Info                  | Progress |
+-----+------+-----------+------+---------+------+-------+-----------------------+----------+
| 130 | root | localhost | basa | Sleep   |    1 |       | NULL                  |    0.000 |
| 133 | root | localhost | NULL | Query   |    0 | init  | SHOW FULL PROCESSLIST |    0.000 |
+-----+------+-----------+------+---------+------+-------+-----------------------+----------+

Interestingly, running the first and second part of script separately eliminates the issue.

貢獻者指南