Function stmt_cache_requeue_old_entry

db/sql_stmt_cache.c:104–132

Requeue a stmt that was previously removed from the queues by calling * stmt_cache_remove_entry(). Called by put_prepared_stmt_int() after we are * done running stmt and by add_stmt_table() after it allocates the new entry. */

 * done running stmt and by add_stmt_table() after it allocates the new entry.
 */
int stmt_cache_requeue_old_entry(stmt_cache_t *stmt_cache, stmt_cache_entry_t *entry)
{
    int rc = sqlite3_reset(entry->stmt); // reset vdbe when adding to hash tbl
    if (rc != SQLITE_OK) {
        /* sqlite_step -> sql_tick -> EPIPE -> sqlite_reset returns SQLITE_ABORT */
        return -1;
    }

    if (hash_find(stmt_cache->hash, entry->sql) != NULL) {
        return -1; // already there, don't add again
    }

    if (hash_add(stmt_cache->hash, entry) != 0) {
        return -1;
    }

    rc = sqlite3_clear_bindings(entry->stmt);
    assert(rc == SQLITE_OK);
    if (rc != SQLITE_OK) {
        logmsg(LOGMSG_ERROR,
               "%s:%d sqlite3_clear_bindings(%p) error, rc = %d\n", __func__,
               __LINE__, entry->stmt, rc);
    }

    void *list = GET_STMT_LIST(stmt_cache, entry->stmt);
    listc_atl(list, entry);

    return 0;
}

static void stmt_cache_free_entry(stmt_cache_entry_t *entry)
{