{"action":"created","issue":{"url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/7","repository_url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib","labels_url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/7/comments","events_url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/7/events","html_url":"https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/7","id":422068701,"node_id":"MDU6SXNzdWU0MjIwNjg3MDE=","number":7,"title":"\"SQL error: out of memory\" when insert data to table.","user":{"login":"pornpol","id":14724205,"node_id":"MDQ6VXNlcjE0NzI0MjA1","avatar_url":"https://avatars1.githubusercontent.com/u/14724205?v=4","gravatar_id":"","url":"https://api.github.com/users/pornpol","html_url":"https://github.com/pornpol","followers_url":"https://api.github.com/users/pornpol/followers","following_url":"https://api.github.com/users/pornpol/following{/other_user}","gists_url":"https://api.github.com/users/pornpol/gists{/gist_id}","starred_url":"https://api.github.com/users/pornpol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pornpol/subscriptions","organizations_url":"https://api.github.com/users/pornpol/orgs","repos_url":"https://api.github.com/users/pornpol/repos","events_url":"https://api.github.com/users/pornpol/events{/privacy}","received_events_url":"https://api.github.com/users/pornpol/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":29,"created_at":"2019-03-18T07:15:13Z","updated_at":"2019-04-17T16:06:23Z","closed_at":null,"author_association":"NONE","body":"System return \"SQL error: out of memory\" when inserts data into a table that has more than (~ 250 rows) \r\n\r\nInsert into pqmeter_data (meter_id, exid, w, wh, pf, varh, i0, i1, i2, v0, v1, v2,thdvr, thdvs, thdvt, thdir, thdis, thdit, vunbr, vunbs, vunbt, chr3, chs3, cht3, chr5, chs5, cht5, chr7, chs7, cht7, chr9, chs9, cht9, chr11, chs11, cht11, chr13, chs13, cht13, chr15, chs15, cht15, freq, mdt) values ('1', '125', '0.0000', '0.0000', '0.0000', '0.0000', '0.00', '0.00', '0.00', '224.71', '112.61', '112.38', '1.41', '1.71', '1.68', '0.00', '0.00', '0.00', '49.91', '24.88', '25.03', '0.50', '0.84', '0.85', '1.02', '1.25', '1.23', '0.37', '0.23', '0.24', '0.60', '0.48', '0.46', '0.27', '0.27', '0.26', '0.23', '0.32', '0.31', '0.00', '0.00', '0.00', '49.96', '1552917357')\r\nSQL error: out of memory\r\n\r\nSystem return \"SQL error: out of memory\" when inserts data into a table that has more than (~ 5000 rows) \r\nInsert into sensor_data (sensor_id, exid, a0, a1, a2, a3, a4, a5, a6, a7, sdt) values ('1', '1021', '-12.492', '0', '0', '0', '0', '0', '0', '0', '1552918218')\r\nSQL error: out of memory\r\n\r\n\"SELECT\" statement still works fine in those tables.\r\nAnd \"INSERT\" into other tables still work too.\r\n\r\nPlease suggest what I can do.\r\n\r\nThank you."},"comment":{"url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/comments/484154978","html_url":"https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/7#issuecomment-484154978","issue_url":"https://api.github.com/repos/siara-cc/esp32_arduino_sqlite3_lib/issues/7","id":484154978,"node_id":"MDEyOklzc3VlQ29tbWVudDQ4NDE1NDk3OA==","user":{"login":"tobozo","id":1893754,"node_id":"MDQ6VXNlcjE4OTM3NTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/1893754?v=4","gravatar_id":"","url":"https://api.github.com/users/tobozo","html_url":"https://github.com/tobozo","followers_url":"https://api.github.com/users/tobozo/followers","following_url":"https://api.github.com/users/tobozo/following{/other_user}","gists_url":"https://api.github.com/users/tobozo/gists{/gist_id}","starred_url":"https://api.github.com/users/tobozo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tobozo/subscriptions","organizations_url":"https://api.github.com/users/tobozo/orgs","repos_url":"https://api.github.com/users/tobozo/repos","events_url":"https://api.github.com/users/tobozo/events{/privacy}","received_events_url":"https://api.github.com/users/tobozo/received_events","type":"User","site_admin":false},"created_at":"2019-04-17T16:06:23Z","updated_at":"2019-04-17T16:06:23Z","author_association":"NONE","body":"so after more than 3 days of uptime, the 2 bytes per hour 'leak' stopped; the heap is now at 132412 and stable, no crash watsoever \\o/\r\n\r\n\r\n"}}
{"actor":{"display_login":"tobozo"}}