search

siara-cc / esp32_arduino_sqlite3_lib

Sqlite3 Arduino library for ESP32
Apache License 2.0
350 stars 66 forks source link

Problem with bluetooth.serial #29

Open illosan opened 4 years ago

illosan commented 4 years ago

Hello, when the program reaches this cicle (with bluetooth activated)

while (sqlite3_step(res) == SQLITE_ROW) {....}

the esp32 resets itself returning the following error:

Guru Meditation Error: Core 1 panic'ed (LoadProhibited). Exception was unhandled. Core 1 register dump: PC : 0x400f0a0c PS : 0x00060430 A0 : 0x800d3710 A1 : 0x3ffd0af0
A2 : 0x00000000 A3 : 0x00000000 A4 : 0x00000000 A5 : 0x00000001
A6 : 0x3ffc6f48 A7 : 0x00000008 A8 : 0x80120a88 A9 : 0x3ffd09a0
A10 : 0x00000015 A11 : 0x3f401aec A12 : 0x00000002 A13 : 0x00000080
A14 : 0x00000000 A15 : 0x3ffd0b1c SAR : 0x00000018 EXCCAUSE: 0x0000001c
EXCVADDR: 0x00000010 LBEG : 0x4000c349 LEND : 0x4000c36b LCOUNT : 0xffffffff

Backtrace: 0x400f0a0c:0x3ffd0af0 0x400d370d:0x3ffd0b10 0x400d64ae:0x3ffd0b40 0x4012e001:0x3ffd0b90 0x4008f47d:0x3ffd0bb0

C: 0x400f0a0c: sqlite3_clear_bindings at C:\Users\illo\Documents\Arduino\libraries\Sqlite3Esp32\src\sqlite3.c line 82679 EXCVADDR: 0x00000010

Decoding stack results 0x400f0a0c: sqlite3_clear_bindings at C:\Users\illo\Documents\Arduino\libraries\Sqlite3Esp32\src\sqlite3.c line 82679 0x400d370d: trovaRigaDaInviare() at C:\Users\illo\AppData\Local\Temp\arduino_modified_sketch_171022/iSQLite.ino line 222 0x400d64ae: loop() at C:\Users\illo\AppData\Local\Temp\arduino_modified_sketch_171022/MK03_0.52.ino line 459 0x4012e001: loopTask(void*) at C:\Users\illo\AppData\Local\Arduino15\packages\esp32\hardware\esp32\1.0.4\cores\esp32\main.cpp line 19 0x4008f47d: vPortTaskWrapper at /home/runner/work/esp32-arduino-lib-builder/esp32-arduino-lib-builder/esp-idf/components/freertos/port.c line 143

this is one of the errors i found, but in general with bluetooth attached there are problems when i try to access the database.