sidorares/node-mysql2

node-mysql2 hangs for long time without showing anything

Ouverte

#695 ouverte le 6 déc. 2017

 (26 commentaires) (2 réactions) (0 personne assignée)TypeScript (679 forks)github user discovery
help wantedneeds investigationneeds reproduction

Métriques du dépôt

Stars
 (4 384 étoiles)
Métriques de merge PR
 (Merge moyen 18h 50m) (29 PRs mergées en 30 j)

Description

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.

Guide contributeur