DB error 10 ($11) · Snippets · GitLab

DB error 10

DB error 10

Edited Oct 27, 2020

16.9 KB

Bảo An @anbao.nguyen · Oct 27, 2020

TRANSACTION 421242460993112, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 28, OS thread handle 139767699060480, query id 15071 13.228.30.65 sip Storing result in query cache SELECT SUM(p.last_used_energy) as totalEnergy, p.gateway_id as gatewayId FROM DeviceLog p LEFT JOIN Area a ON a.id = p.area_id WHERE 1 AND (p.created_log_at BETWEEN '2020-09-28T09:29:02Z' AND '2020-10-27T09:29:02Z') GROUP BY p.device_id

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

Edited Oct 27, 2020 by Bảo An
> TRANSACTION 421242460993112, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 28, OS thread handle 139767699060480, query id 15071 13.228.30.65 sip Storing result in query cache SELECT SUM(p.`last_used_energy`) as totalEnergy, p.gateway_id as gatewayId FROM `DeviceLog` p LEFT JOIN `Area` a ON a.id = p.area_id WHERE 1 AND (p.`created_log_at` BETWEEN '2020-09-28T09:29:02Z' AND '2020-10-27T09:29:02Z') GROUP BY p.`device_id` InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

Please register or to comment