finsh调用flashdb按时间迭代的 API时串口报错stack overflow

发布于 2023-08-30 13:16:06 浏览：594 订阅该版

使用stm32f103开发板，RT-Thread-Studio开发，在片外flash上部署flashdb，想通过finsh调用TSDB提供的按时间迭代的 API : fdb_tsl_iter_by_time，实现按照串口输入的时间段，读取并打印数据库中相应时间段的内容的功能。
```c
static void QUERY(uint8_t argc, char **argv)
{

if (argc >= 14)
    {
        // set time and date
        struct tm tm_from = { .tm_year = atoi(argv[1]) - 1900, .tm_mon = atoi(argv[2])-1, .tm_mday = atoi(argv[3]), .tm_hour = atoi(argv[4]), .tm_min = atoi(argv[5]), .tm_sec = atoi(argv[6]) };
        struct tm tm_to =   { .tm_year = atoi(argv[8]) - 1900, .tm_mon = atoi(argv[9])-1, .tm_mday = atoi(argv[10]), .tm_hour = atoi(argv[11]), .tm_min = atoi(argv[12]), .tm_sec = atoi(argv[13]) };

if (tm_from.tm_year > 199 || tm_from.tm_year < 100||tm_to.tm_year > 199 || tm_to.tm_year < 100)
        {
            rt_kprintf("year is out of range [2000-2099]\n");
            return;
        }
        if (tm_from.tm_mon < 0 || tm_from.tm_mon > 11||tm_to.tm_mon < 0 || tm_to.tm_mon > 11)
        {
            rt_kprintf("month is out of range [1-12]\n");
            return;
        }
        if (tm_from.tm_mday == 0 || tm_from.tm_mday > 31||tm_to.tm_mday == 0 || tm_to.tm_mday > 31)
        {
            rt_kprintf("day is out of range [1-31]\n");
            return;
        }
        if (tm_from.tm_hour > 23||tm_to.tm_hour > 23)
        {
            rt_kprintf("hour is out of range [0-23]\n");
            return;
        }
        if (tm_from.tm_min > 59||tm_to.tm_min > 59)
        {
            rt_kprintf("minute is out of range [0-59]\n");
            return;
        }
        if (tm_from.tm_sec > 59||tm_to.tm_sec > 59)
        {
            rt_kprintf("second is out of range [0-59]\n");
            return;
        }
        time_t from_time = mktime(&tm_from), to_time = mktime(&tm_to);

fdb_tsl_iter_by_time(&tsdb, from_time, to_time, query_by_time_cb, &tsdb);
    }
    else
    {
        rt_kprintf("please input: date [year month day hour min sec]\n");
        rt_kprintf("e.g: QUERY 2018 01 01 23 59 59 to 2023 08 27 23 59 59\n");
    }
}
MSH_CMD_EXPORT(QUERY, QUERY the TSDB by time);
```
在测试时发现只要调用fdb_tsl_iter_by_time，串口就报thread：W25Q128 stack overflow，但在普通函数或者线程中调用fdb_tsl_iter_by_time时可以正常实现功能，注释掉
```c
fdb_tsl_iter_by_time(&tsdb, from_time, to_time, query_by_time_cb, &tsdb);
```时不会报错，增大finsh线程栈的大小不能解决问题