corteks-team/mysql_data_generator

Fill a database with random data.

mysql_data_generator's Issues

Error -4077 // ECONNRESET

• PS E:\src\project\orbicall2\dist> mysqldatagen --db mysql://orbmaster:[email protected]:3306/orbicall2
• * [n] => Skip the current table. Only works during data generation phase.
• [2022-02-05T21:54:57.864] [WARN] default - For performance foreign_key_checks, autocommit and unique_checks are disabled during insert.
• [2022-02-05T21:54:57.866] [WARN] default - They are disabled per connections and should not alter your configuration.
• [2022-02-05T21:54:57.867] [INFO] default - To improve performances further you can update innodb_autoinc_lock_mode = 0 in your my.ini.
• [2022-02-05T21:54:57.939] [INFO] default - No scripts provided.
• [2022-02-05T21:54:58.033] [INFO] default - fill: events
• [2022-02-05T21:54:58.037] [INFO] default - 50 / 1000
• [2022-02-05T21:55:09.181] [ERROR] default - ECONNRESET Error
• [2022-02-05T21:55:09.183] [ERROR] default - Error: read ECONNRESET
• at TCP.onStreamRead (node:internal/stream_base_commons:211:20)
• --------------------
• at Protocol._enqueue (C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\mysql\lib\protocol\Protocol.js:144:48)
• at Connection.query (C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\mysql\lib\Connection.js:198:25)
• at C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\dialects\mysql\index.js:134:18
• at new Promise ()
• at Client_MySQL._query (C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\dialects\mysql\index.js:128:12)
• at Client_MySQL.query (C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\client.js:167:17)
• at Runner.query (C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\runner.js:134:36)
• at C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\runner.js:40:23
• at C:\Users\AXA\AppData\Roaming\npm\node_modules@corteks\mysql-data-generator\node_modules\knex\lib\runner.js:260:24
• at processTicksAndRejections (node:internal/process/task_queues:96:5) {
• errno: -4077,
• code: 'ECONNRESET',
• syscall: 'read',
• fatal: true
• }
• [2022-02-05T21:55:09.185] [INFO] default - Close database connection
• [ ]

How to run it in windows machine

Let me know how to run the second step in windows machine
mysqldatagen --db mysql://user:[email protected]:3306/database