bad query create panic esp32 #234

Activity

1. ChuckBell commented on Aug 13, 2024

   

   ChuckBell

   on Aug 13, 2024 via email

   Owner

   More actions

   Can you please share the query and code segment?

   …

   On Mon, Aug 5, 2024 at 11:47 Gufo Rosso ***@***.***> wrote: Connected to server version 8.0.38 (compatible login) Error: 60 = Out of range value for column 'mc_cpm_min' at row 2. (insert decimal into int field) Disconnected. Guru Meditation Error: Core 0 panic'ed (LoadProhibited). Exception was unhandled. the problem is not my bad query is a panic this exception or truncate data or not insert a data — Reply to this email directly, view it on GitHub <#234>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6SHYCF4DRRTD67W37VV7DZP6NBFAVCNFSM6AAAAABMASGKOGVHI2DSMVQWIX3LMV43ASLTON2WKOZSGQ2DQOBZGE2DCMA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>
2. Red-Owl commented on Aug 14, 2024

   

   Red-Owl

   on Aug 14, 2024

   Author

   More actions

   String mysql_insert_query(void){
     String subq = "( SELECT SUBSTRING_INDEX(host,':',1) as 'ip' from performance_schema.processlist WHERE ID=connection_id() )";
     long ep = esprtc.getEpoch();
     String query = "INSERT INTO esp32.geiger SET ";
     query += "mc_ippy=" + subq + ",";
     query += "mc_epoq='" + String(ep, 10) + "',";
     query += "mc_date=now(), ";
     query += "mc_session='" + String(ENABLE_STRING) + "',";
     query += "mc_cpm_min='" + String(CPM_PREV[2]) + "',";
     query += "mc_usv_min='" + String(GEIGER_PREV2) + "',";
     query += "mc_model='" + String(FIRMWARE_MODEL) + "',";
     query += "mc_serial='" + String(FIRMWARE_SERIAL) + "',";
     query += "mc_version='" + String(FIRMWARE_VERSION) + "'; ";
     return query;
   }
   

   CREATE TABLE geiger (
   MC BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
   mc_ippy CHAR(16) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   mc_date DATETIME(6) NULL DEFAULT NULL,
   mc_session VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   mc_cpm_min MEDIUMINT UNSIGNED NULL DEFAULT NULL,
   mc_usv_min DECIMAL(20,6) UNSIGNED NULL DEFAULT NULL,
   mc_model VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   mc_serial VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   mc_version VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   mc_epoq BIGINT NULL DEFAULT NULL,
   PRIMARY KEY (MC) USING BTREE
   )
   COLLATE='utf8mb4_unicode_ci'
   ENGINE=InnoDB
   AUTO_INCREMENT=2954
   ;
3. ChuckBell commented on Sep 6, 2024

   

   ChuckBell

   on Sep 6, 2024 via email

   Owner

   More actions

   Hi. I missed it the first time. The error says you are inserting a decimal into an int field. That won’t work and will throw the error if the range of the whole number exceeds the max value. I suggest either changing the field type and adding error handling to avoid rounding/truncation errors. Hope this helps.

   …

   On Aug 14, 2024, at 10:12 AM, Gufo Rosso ***@***.***> wrote: String mysql_insert_query(void){ String subq = "( SELECT SUBSTRING_INDEX(host,':',1) as 'ip' from performance_schema.processlist WHERE ID=connection_id() )"; long ep = esprtc.getEpoch(); String query = "INSERT INTO esp32.geiger SET "; query += "mc_ippy=" + subq + ","; query += "mc_epoq='" + String(ep, 10) + "',"; query += "mc_date=now(), "; query += "mc_session='" + String(ENABLE_STRING) + "',"; query += "mc_cpm_min='" + String(CPM_PREV[2]) + "',"; query += "mc_usv_min='" + String(GEIGER_PREV2) + "',"; query += "mc_model='" + String(FIRMWARE_MODEL) + "',"; query += "mc_serial='" + String(FIRMWARE_SERIAL) + "',"; query += "mc_version='" + String(FIRMWARE_VERSION) + "'; "; return query; } CREATE TABLE geiger ( MC BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, mc_ippy CHAR(16) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci', mc_date DATETIME(6) NULL DEFAULT NULL, mc_session VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci', mc_cpm_min MEDIUMINT UNSIGNED NULL DEFAULT NULL, mc_usv_min DECIMAL(20,6) UNSIGNED NULL DEFAULT NULL, mc_model VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci', mc_serial VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci', mc_version VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci', mc_epoq BIGINT NULL DEFAULT NULL, PRIMARY KEY (MC) USING BTREE ) COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB AUTO_INCREMENT=2954 ; — Reply to this email directly, view it on GitHub <#234 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6SHYHGDQ4P3YLE27QUEXDZRNQVPAVCNFSM6AAAAABMASGKOGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBYHA4TGOBSHA>. You are receiving this because you commented.
4. Red-Owl commented on Sep 8, 2024

   

   Red-Owl

   on Sep 8, 2024

   Author

   More actions

   .... Panic bad query create a guru meditation. Bad query return error id or message. Not crash.