Multi process/ mysql

[Miha Zoubek]

Hi,

i am trying to use multi process for one thing. I fallowed this tutorial: https://codeforgeek.com/2014/12/cluster-node-js-performance/

After i stard nodejs app, after 4 min i get:

/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/Parser.js:77
        throw err; // Rethrow non-MySQL errors
              ^
Error: ER_DUP_ENTRY: Duplicate entry '381611335152' for key 'PRIMARY'
    at Query.Sequence._packetToError (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/sequences/Sequence.js:48:14)
    at Query.ErrorPacket (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/sequences/Query.js:83:18)
    at Protocol._parsePacket (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/Protocol.js:280:23)
    at Parser.write (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/Parser.js:73:12)
    at Protocol.write (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/Protocol.js:39:16)
    at Socket.<anonymous> (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/Connection.js:96:28)
    at Socket.emit (events.js:95:17)
    at Socket.<anonymous> (_stream_readable.js:765:14)
    at Socket.emit (events.js:92:17)
    at emitReadable_ (_stream_readable.js:427:10)
    --------------------
    at Protocol._enqueue (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/protocol/Protocol.js:141:48)
    at Connection.query (/var/www/html/LDB-
rs/nodejs/node_modules/mysql/lib/Connection.js:201:25)
    at /var/www/html/LDB-rs/nodejs/app.js:41:16
    at Function._.each._.forEach (/var/www/html/LDB-
rs/nodejs/node_modules/underscore/underscore.js:153:9)
    at /var/www/html/LDB-rs/nodejs/app.js:39:6
    at Parser.<anonymous> (/var/www/html/LDB-
rs/nodejs/node_modules/xml2js/lib/xml2js.js:484:18)
    at Parser.emit (events.js:95:17)
    at Object.onclosetag (/var/www/html/LDB-
rs/nodejs/node_modules/xml2js/lib/xml2js.js:445:26)
    at emit (/var/www/html/LDB-
rs/nodejs/node_modules/xml2js/node_modules/sax/lib/sax.js:639:35)
    at emitNode (/var/www/html/LDB-
rs/nodejs/node_modules/xml2js/node_modules/sax/lib/sax.js:644:5)
    at closeTag (/var/www/html/LDB-
rs/nodejs/node_modules/xml2js/node_modules/sax/lib/sax.js:903:7)
worker 8423 died

I guess this is due to multi core thing, if i use only one core it works ok.

Progrem read one xml file, put it in json and then insert in the mysql table.

tnx for help

Miha

[Ryan Schmidt]

Looks like you're trying to insert the same primary key into the database more than once. Don't do that.