解决SQLite异常：library routine called out of sequence

心已赠人 2022-07-13 08:50 32阅读 0赞

在平常的练习中出现了这样的问题，在网上搜寻了下，发现没有什么确定的答案。

却发现：

Error Code SQLITE\_MISUSE (21) "Library routine called out of sequence"

The SQLITE\_MISUSE error code is returned when you misuse the SQLitelibrary in some way. SQLite does not guarantee that it will detectmisuse, so you should not depend on this behavior in any way. TheSQLITE\_MISUSE error code is intended to help you find the bugs inyour code.

Here are some possible causes of SQLITE\_MISUSE:

1.  Calling any API routine with an sqlite3\* pointer that was not obtained from sqlite3\_open() or sqlite3\_open16() or which has already been closed by sqlite3\_close().
2.  Trying to use the same database connection at the same instant in time from two or more threads.
3.  Calling sqlite3\_step() with a sqlite3\_stmt\* statement pointer that was not obtained from sqlite3\_prepare() or sqlite3\_prepare16() or that has already been destroyed by sqlite3\_finalize().
4.  Trying to bind values to a statement (using sqlite3\_bind\_...()) while that statement is running.

这是SQLite官网上给出的问题解释。

1.  调用API所用到的指针，第一种情况是没有从sqlite3\_open()或者是sqlite3\_open16()获得，第二种情况是sqlite3\_close()函数已经将[数据库][Link 1]关闭了。我是第二种情况。

2.  两个或者更多的线程同时访问该数据库。对于这样的问题，可以通过加上锁进行解决。

3.  sqlite3\_step()所用到的变量statement指针，第一种情况是该指针不是从sqlite3\_prepare()或者是sqlite3\_open16()获得的，第二种情况是该指针已经被销毁或者被释放。这个和１中的情况是一样的，不同的是使用这种指针的函数，两者可以和为一种情况。

**4.  试图将values绑定到一个正在运行的statement上。该解释未遇到。（本人遇到：在statement绑定bind值后未reset就又重新对statement绑定bind值）**

**===================================================================**

IOS，SQLite批量插入错误

在数据库中插入数据的时候，报错：`Prepare-error library routine called out of sequence`

代码如下，麻烦帮我看看错误出在哪儿了。谢谢

NSString *databaseName = @"DB.sqlite";
        NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES);
        NSString *documentsDir = [documentPaths objectAtIndex:0];
        NSString *databasePath = [documentsDir stringByAppendingPathComponent:databaseName];
    
        sqlite3 *concertsDB;
        const char *dbpath = [databasePath UTF8String];
    
        if (sqlite3_open(dbpath, &concertsDB) == SQLITE_OK)
        {
            sqlite3_exec(concertsDB, "BEGIN TRANSACTION", 0, 0, 0);
            const char *sqlStatement = "INSERT INTO concertsData VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            sqlite3_stmt *compiledStatement;
    
            if (sqlite3_prepare_v2(concertsDB, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
                int hasError;
    
                for (int i=0; i<[events count]; i++) {
    
                    sqlite3_bind_text(compiledStatement, 1, [[[events objectAtIndex:i] title] UTF8String], -1, SQLITE_TRANSIENT);
                    sqlite3_bind_int(compiledStatement, 2, [[[events objectAtIndex:i] date] timeIntervalSince1970]);
    
                    sqlite3_bind_text(compiledStatement, 3, [[[events objectAtIndex:i] time] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 4, [[[events objectAtIndex:i] shortDesription] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 5, [[[events objectAtIndex:i] conductor] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 6, [[[events objectAtIndex:i] location] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 7, [[[events objectAtIndex:i] durations] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 8, [[[events objectAtIndex:i] works] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 9, [[[events objectAtIndex:i] solists] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 10, [[[events objectAtIndex:i] fulltext] UTF8String], -1, SQLITE_TRANSIENT);                    
    
                    sqlite3_bind_text(compiledStatement, 11, [[[[events objectAtIndex:i] concertUrl] absoluteString] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 12, [[[[events objectAtIndex:i] buyUrl] absoluteString] UTF8String], -1, SQLITE_TRANSIENT);
    
                    sqlite3_bind_text(compiledStatement, 13, [[[events objectAtIndex:i] imageName] UTF8String], -1, SQLITE_TRANSIENT);
    
                    if (sqlite3_step(compiledStatement) != SQLITE_DONE) {
                        hasError=1;
                        NSLog(@"Prepare-error %s", sqlite3_errmsg(concertsDB));
                    }
    
                    sqlite3_clear_bindings(compiledStatement);
                }
                sqlite3_reset(compiledStatement);
                if( hasError == 0 ) {
                    sqlite3_exec(concertsDB, "COMMIT", 0, 0, 0);
                }
                else {
                    sqlite3_exec(concertsDB, "ROLLBACK", 0, 0, 0);
                }
    
            }
    
            sqlite3_close(concertsDB);
        ｝

[Link 1]: http://lib.csdn.net/base/mysql