{"action":"closed","issue":{"url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem/issues/27","repository_url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem","labels_url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem/issues/27/comments","events_url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem/issues/27/events","html_url":"https://github.com/dwdv/Lagerverwaltungssystem/issues/27","id":334459946,"node_id":"MDU6SXNzdWUzMzQ0NTk5NDY=","number":27,"title":"mysql entry duplication error","user":{"login":"dwdv","id":28686494,"node_id":"MDQ6VXNlcjI4Njg2NDk0","avatar_url":"https://avatars1.githubusercontent.com/u/28686494?v=4","gravatar_id":"","url":"https://api.github.com/users/dwdv","html_url":"https://github.com/dwdv","followers_url":"https://api.github.com/users/dwdv/followers","following_url":"https://api.github.com/users/dwdv/following{/other_user}","gists_url":"https://api.github.com/users/dwdv/gists{/gist_id}","starred_url":"https://api.github.com/users/dwdv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwdv/subscriptions","organizations_url":"https://api.github.com/users/dwdv/orgs","repos_url":"https://api.github.com/users/dwdv/repos","events_url":"https://api.github.com/users/dwdv/events{/privacy}","received_events_url":"https://api.github.com/users/dwdv/received_events","type":"User","site_admin":false},"labels":[{"id":918676636,"node_id":"MDU6TGFiZWw5MTg2NzY2MzY=","url":"https://api.github.com/repos/dwdv/Lagerverwaltungssystem/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"closed","locked":false,"assignee":{"login":"sh501st","id":38885647,"node_id":"MDQ6VXNlcjM4ODg1NjQ3","avatar_url":"https://avatars1.githubusercontent.com/u/38885647?v=4","gravatar_id":"","url":"https://api.github.com/users/sh501st","html_url":"https://github.com/sh501st","followers_url":"https://api.github.com/users/sh501st/followers","following_url":"https://api.github.com/users/sh501st/following{/other_user}","gists_url":"https://api.github.com/users/sh501st/gists{/gist_id}","starred_url":"https://api.github.com/users/sh501st/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sh501st/subscriptions","organizations_url":"https://api.github.com/users/sh501st/orgs","repos_url":"https://api.github.com/users/sh501st/repos","events_url":"https://api.github.com/users/sh501st/events{/privacy}","received_events_url":"https://api.github.com/users/sh501st/received_events","type":"User","site_admin":false},"assignees":[{"login":"sh501st","id":38885647,"node_id":"MDQ6VXNlcjM4ODg1NjQ3","avatar_url":"https://avatars1.githubusercontent.com/u/38885647?v=4","gravatar_id":"","url":"https://api.github.com/users/sh501st","html_url":"https://github.com/sh501st","followers_url":"https://api.github.com/users/sh501st/followers","following_url":"https://api.github.com/users/sh501st/following{/other_user}","gists_url":"https://api.github.com/users/sh501st/gists{/gist_id}","starred_url":"https://api.github.com/users/sh501st/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sh501st/subscriptions","organizations_url":"https://api.github.com/users/sh501st/orgs","repos_url":"https://api.github.com/users/sh501st/repos","events_url":"https://api.github.com/users/sh501st/events{/privacy}","received_events_url":"https://api.github.com/users/sh501st/received_events","type":"User","site_admin":false}],"milestone":null,"comments":7,"created_at":"2018-06-21T11:54:54Z","updated_at":"2018-06-25T13:06:59Z","closed_at":"2018-06-25T13:06:59Z","author_association":"OWNER","body":"How to reproduce:\r\n\r\n- Start server via ./server.sh\r\n- view.js in presentation mode for a couple of seconds to generate a solid amount of logs\r\n- refresh tab (F5)\r\n\r\nServer output:\r\n```\r\nInserting access updates failed: { Error: ER_DUP_ENTRY: Duplicate entry '20-0-1528977130' for \r\nkey 'PRIMARY'                                                                                \r\n    at Query.Sequence._packetToError (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/\r\nlib/protocol/sequences/Sequence.js:52:14)                                                    \r\n    at Query.ErrorPacket (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/protocol\r\n/sequences/Query.js:77:18)                                                                   \r\n    at Protocol._parsePacket (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/prot\r\nocol/Protocol.js:279:23)                                                                     \r\n    at Parser.write (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/protocol/Pars\r\ner.js:76:12)                                                                                 \r\n    at Protocol.write (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/protocol/Pr\r\notocol.js:39:16)                                                                             \r\n    at Socket.<anonymous> (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/Connect\r\nion.js:103:28)                                                                               \r\n    at emitOne (events.js:116:13)\r\n    at Socket.emit (events.js:211:7)\r\n    at addChunk (_stream_readable.js:263:12)\r\n    at readableAddChunk (_stream_readable.js:250:11)\r\n    --------------------\r\n    at Protocol._enqueue (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/protocol\r\n/Protocol.js:145:48)                                                                         \r\n    at Connection.query (/home/dan/git/Lagerverwaltungssystem/node_modules/mysql/lib/Connectio\r\nn.js:208:25)                                                                                 \r\n    at order.articles.forEach (/home/dan/git/Lagerverwaltungssystem/include/db.js:18:10)\r\n    at Array.forEach (<anonymous>)\r\n    at Object.exports.updateLog (/home/dan/git/Lagerverwaltungssystem/include/db.js:14:20)\r\n    at activeStorages.forEach (/home/dan/git/Lagerverwaltungssystem/server.js:291:6)\r\n    at Map.forEach (<anonymous>)\r\n    at Timeout.f [as _onTimeout] (/home/dan/git/Lagerverwaltungssystem/server.js:285:17)\r\n    at ontimeout (timers.js:498:11)\r\n    at tryOnTimeout (timers.js:323:5)\r\n  code: 'ER_DUP_ENTRY',\r\n  errno: 1062,\r\n  sqlMessage: 'Duplicate entry \\'20-0-1528977130\\' for key \\'PRIMARY\\'',\r\n  sqlState: '23000',\r\n  index: 0,\r\n  sql: 'INSERT INTO log (order_id, no_in_order, product, unix, storage_id) VALUES\\n           \r\n             (\\'20\\', \\'0\\', \\'2103\\', \\'1529581477\\', \\'1528977130\\')' }                    \r\n```"}}
{"actor":{"display_login":"dwdv"}}