bad query create panic esp32

[Red-Owl]

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

[ChuckBell]

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: ***@***.***>

[Red-Owl]

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
;

[ChuckBell]

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.

[Red-Owl]

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