10 sqlite软件包内存泄漏

发布于 2022-05-22 11:06:39 浏览：1386 订阅该版

在4.1.0版本下使用sqlite软件包，从https://github.com/RT-Thread-packages/SQLite下载的源码并替换pkgs --update的sqlite文件(不知道为什么直接update的一运行就报`(obj != object) assertion failed at function:rt_object_init, line number:358`， 而从github下载的就能运行)，
运行一段时间后发现使用内存不断增大，用memtrace工具确定是操作数据库的线程导致，请问造成内存泄漏到底是我应用程序的问题还是软件包本身的问题，该怎么排查呢？硬件使用的nuc980dk61yc

![aa.jpg](https://oss-club.rt-thread.org/uploads/20220522/bd2cbbf6495d69f6457ee594db0d716a.jpg)

```c
void app_sqlite3_thread(void *argument)
{
    sqlite3_initialize();

sqlite3 *db;
    char *zErrMsg = 0;
    int res;
    int start = 0;
    int index = 0;
    char cmd[128] = {0};
    time_t now;

rt_thread_mdelay(2000);

res = sqlite3_open("/mnt/sd1/test.db", &db);
    if (res != 0)
    {
        LOG_E("open db fail");
        rt_thread_mdelay(1000);
        return;
    }

res = sqlite3_exec(db, "create table if not exists mydb(time vchar(30),fs1_1 float,fs1_2 float,fs2_1 float,fs2_2 float,fs3_1 float,fs3_2 float,temp1 char,temp2 char,temp3 char,current1 char,current2 char,current3 char,freq1 char,freq2 char,freq3 char)", 0, 0, &zErrMsg);
    if (res != 0)
    {
        LOG_E("create table fail");
        sqlite3_free(zErrMsg);
        rt_thread_mdelay(1000);
        return;
    }

res = sqlite3_exec(db, "PRAGMA synchronous=FULL", 0, 0, &zErrMsg);
    if (res != 0)
    {
        printf("set pragma fail\r\n");
        sqlite3_free(zErrMsg);
    }

while (1)
    {
        // printf("start: %d\r\n", rt_tick_get());
        start = rt_tick_get();
        rt_memset(cmd, 0, sizeof(cmd));
        now = time(RT_NULL);
        rt_sprintf(cmd, "insert into mydb values('%s',1.2,2.6,3.1,4.7,0.9,4.2,10,25,28,12,36,28,30,19,24)", ctime(&now));
        res = sqlite3_exec(db, cmd, 0, 0, &zErrMsg);
        if (res != 0)
        {
            LOG_E("insert data fail");
            sqlite3_free(zErrMsg);
        }

if (rt_tick_get() - start > 100)
        {
            // LOG_W("write time too long: %d",rt_tick_get() - start);
        }

rt_thread_mdelay(20);
    }

sqlite3_close(db);
}

int app_sqlite(void)
{
    rt_thread_t tid = 0;
    tid = rt_thread_create("app_sqlite", app_sqlite3_thread, RT_NULL, 500 * 1024, 10, 300);
    if (tid != RT_NULL)
    {
        rt_thread_startup(tid);
    }
    else
        rt_kprintf("create sqlite app fail\r\n");
}

INIT_APP_EXPORT(app_sqlite);
```