iOS开发中SQLite死锁问题(OC版)

最新推荐文章于 2023-05-10 09:40:12 发布
最新推荐文章于 2023-05-10 09:40:12 发布
阅读量367 收藏
点赞数
分类专栏： iOS 数据库 文章标签： SQLite Object-C iOS
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u012138272/article/details/103093161
版权

iOS开发中SQLite死锁问题(OC版)

翻自己的博客发现自己以前写过如何使用SQLite，然后当时好像没提死锁的事情。因为SQLite只支持单线程的，所以如果碰到多个功能需要访问SQLite的，很有可能引起死锁问题。当然了，现在可能都用Swift不用OC了，但是为了方案的完整性，我还是要记录一下这件事情。

那么比较常见的就是@synchronized关键字，这个Java的同学应该很熟悉，过多的解释也没什么好说的，前人都已经栽树成林了，我没必要再多啰嗦了。

以下是两年前的代码了，也是为了补之前那篇博客《iOS SQLite3 “增删改查”（Objective-C）》的坑

代码或者博客写的不好，还请多多指教，感谢！

//
//  SQLite.h
//
//  Created by Zhan on 16/9/8.
//  Copyright © 2016年 Michael Zhan. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>

typedef void (^SelectBlock)(NSMutableArray * mutableArray);
typedef void (^DBFailureBlock)(void);
typedef void (^Success)(void);
typedef void (^Failed)(void);

@interface ContactDB : NSObject

+ (ContactDB *)sharedDataBaseHandle;
-(sqlite3 *)openDB;
-(void)createTable;
-(void)dropTable:(Success)successBlock failed:(Failed)failedBlock;

-(void)insert_name:(NSString *)name phone:(NSString *)phone headimg:(NSString *)path deptId:(NSString *)deptId deptName:(NSString *)deptName uppercase:(NSString *)uppercase userId:(NSString *)userId mail:(NSString *)mail;

-(void)loadContact:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;

-(void)select_name:(NSString *)name success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;
-(void)select_phone:(NSString *)phone success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;
-(void)select_uppercase:(NSString *)uppercase success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;

-(void)select_userId:(NSString *)userId success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;

-(void)select_deptName:(NSString *)deptName success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock;

-(void)closeDB;

+ (void)destroyDealloc;

@end

//
//  SQLite.m
//
//  Created by Zhan on 16/9/8.
//  Copyright © 2016年 Michael Zhan. All rights reserved.
//

#import "ContactDB.h"

@implementation ContactDB

static ContactDB *manager = nil;
static sqlite3 * db = nil;  //设置句柄 通过句柄对数据库进行操作
static bool isOperation;

+(ContactDB *)sharedDataBaseHandle{
    if (manager == nil) {
        manager = [[ContactDB alloc] init];
        isOperation = false;
    }
    return manager;
}

-(sqlite3 *)openDB{
    if (db != nil) {
        return db;
    }
    NSArray *test = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES);
    NSString * fileName = [[test lastObject]stringByAppendingPathComponent:@"Contact"];
    NSLog(@"%@",fileName);  //打印路径
    sqlite3_open(fileName.UTF8String, &db);
    [self dropTable:^{
        [self createTable];
    } failed:^{
        
    }];
    return db;
}

-(void)createTable{
    NSString * sql = [[@"create table if not exists "stringByAppendingString:@"Contact"]stringByAppendingString:@" (id integer primary key autoincrement not null, name text not null, phone text not null, headimg text null, deptId text not null, deptName text not null, uppercase text null, userId text not null, mail text null);"];
    //    NSLog(@"sql : %@",sql);
    if(db == nil){
        return;
    }
    sqlite3_exec(db, sql.UTF8String, NULL, NULL, NULL);
//    NSLog(@"create contact error : %s",err);
}

-(void)loadContact:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    sqlite3_stmt *statement = nil;
    NSString *sql = @"select * from Contact";
    //    NSLog(@"sql == %@",sql);
//    BOOL hasRow = false;
    if(db == nil && isOperation == true){
        return;
    }
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    isOperation = true;
    @synchronized(self){
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
    //            hasRow = true;
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *mail = (char *)sqlite3_column_text(statement, 8);
                NSString *mailStr = [[NSString alloc]initWithUTF8String:mail];
                [mutableDictionary setObject:mailStr forKey:@"mail"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
        sqlite3_finalize(statement);
    }
}

- (void)insert_name:(NSString *)name phone:(NSString *)phone headimg:(NSString *)path deptId:(NSString *)deptId deptName:(NSString *)deptName uppercase:(NSString *)uppercase userId:(NSString *)userId mail:(NSString *)mail{
        BOOL hasInfo = false;
        sqlite3_stmt *statement = nil;
        NSString *select = [[@"select * from Contact where userId = '"stringByAppendingString:userId]stringByAppendingString:@"'"];
        @synchronized (self) {
            if(db == nil && isOperation == true){
                return;
            }
            isOperation = true;
            if (sqlite3_prepare_v2(db, [select UTF8String], -1, &statement, nil) == SQLITE_OK) {
                while (sqlite3_step(statement) == SQLITE_ROW) {
                    hasInfo = true;
                    break;
                }
            }
            uppercase = [uppercase stringByReplacingOccurrencesOfString:@" " withString:@""];
            NSString * sql;
            if(hasInfo){
                sql = [NSString stringWithFormat:@"update Contact set name = '%@', phone = '%@', headimg = '%@', deptId = '%@', deptName = '%@', uppercase = '%@', mail = '%@' where userId = '%@'",name, phone, path, deptId, deptName, uppercase, mail, userId];
            }else{
                sql = [NSString stringWithFormat:@"insert into Contact (name, phone, headimg, deptId, deptName, uppercase, userId, mail) VALUES('%@', '%@', '%@', '%@', '%@', '%@', '%@', '%@')", name, phone, path, deptId, deptName, uppercase, userId, mail];
            }
            sqlite3_exec(db, sql.UTF8String, NULL, NULL, NULL);
            isOperation = false;
            sqlite3_finalize(statement);
        }
  
-(void)select_name:(NSString *)name success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    sqlite3_stmt *statement = nil;
    NSString *sql = [[@"select * from Contact where name LIKE '%"stringByAppendingString:name]stringByAppendingString:@"%'"];
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    if(db == nil && isOperation == true){
        return;
    }
    isOperation = true;
    @synchronized (self) {
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *mail = (char *)sqlite3_column_text(statement, 8);
                NSString *mailStr = [[NSString alloc]initWithUTF8String:mail];
                [mutableDictionary setObject:mailStr forKey:@"mail"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
        sqlite3_finalize(statement);
    }
}

-(void)select_phone:(NSString *)phone success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    sqlite3_stmt *statement = nil;
    NSString *sql = [[@"select * from Contact where phone LIKE '%"stringByAppendingString:phone]stringByAppendingString:@"%'"];
    //    NSLog(@"sql == %@",sql);
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    if(db == nil && isOperation == true){
        return;
    }
    isOperation = true;
    @synchronized (self) {
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *mail = (char *)sqlite3_column_text(statement, 8);
                NSString *mailStr = [[NSString alloc]initWithUTF8String:mail];
                [mutableDictionary setObject:mailStr forKey:@"mail"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
        sqlite3_finalize(statement);
    }
}

-(void)select_uppercase:(NSString *)uppercase success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    uppercase = [uppercase uppercaseString];
    uppercase = [uppercase stringByReplacingOccurrencesOfString:@" " withString:@""];
    sqlite3_stmt *statement = nil;
    NSString *sql = [[@"select * from Contact where uppercase LIKE '%"stringByAppendingString:uppercase]stringByAppendingString:@"%'"];
    //    NSLog(@"sql == %@",sql);
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    if(db == nil && isOperation == true){
        return;
    }
    isOperation = true;
    @synchronized (self) {
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
        sqlite3_finalize(statement);
    }
}

-(void)select_userId:(NSString *)userId success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    sqlite3_stmt *statement = nil;
    NSString *sql = [[@"select * from Contact where userId = '"stringByAppendingString:userId]stringByAppendingString:@"'"];
    if(db == nil && isOperation == true){
        return;
    }
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    @synchronized (self) {
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *mail = (char *)sqlite3_column_text(statement, 8);
                NSString *mailStr = [[NSString alloc]initWithUTF8String:mail];
                [mutableDictionary setObject:mailStr forKey:@"mail"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
        sqlite3_finalize(statement);
    }
}

-(void)select_deptName:(NSString *)deptName success:(SelectBlock)successBlock failure:(DBFailureBlock)failureBlock{
    sqlite3_stmt *statement = nil;
    NSString *sql = [[@"select * from Contact where deptName = '"stringByAppendingString:deptName]stringByAppendingString:@"'"];
//    NSLog(@"sql == %@",sql);
    if(db == nil && isOperation == true){
        return;
    }
    NSMutableArray * mutableArray = [[NSMutableArray alloc]init];
    @synchronized (self) {
        if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statement, nil) == SQLITE_OK) {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                NSMutableDictionary *mutableDictionary = [[NSMutableDictionary alloc]init];
                
                char *name = (char *)sqlite3_column_text(statement, 1);
                NSString *nameStr = [[NSString alloc] initWithUTF8String:name];
                [mutableDictionary setObject:nameStr forKey:@"name"];
                
                char *phone = (char *)sqlite3_column_text(statement, 2);
                NSString *phoneStr = [[NSString alloc]initWithUTF8String:phone];
                [mutableDictionary setObject:phoneStr forKey:@"phone"];
                
                char *headimg = (char *)sqlite3_column_text(statement, 3);
                NSString *headimgStr = [[NSString alloc]initWithUTF8String:headimg];
                [mutableDictionary setObject:headimgStr forKey:@"headimg"];
                
                char *deptId = (char *)sqlite3_column_text(statement, 4);
                NSString *deptIdStr = [[NSString alloc]initWithUTF8String:deptId];
                [mutableDictionary setObject:deptIdStr forKey:@"deptId"];
                
                char *deptName = (char *)sqlite3_column_text(statement, 5);
                NSString *deptNameStr = [[NSString alloc]initWithUTF8String:deptName];
                [mutableDictionary setObject:deptNameStr forKey:@"deptName"];
                
                char *uppercase = (char *)sqlite3_column_text(statement, 6);
                NSString *uppercasetStr = [[NSString alloc]initWithUTF8String:uppercase];
                [mutableDictionary setObject:uppercasetStr forKey:@"uppercase"];
                
                char *userId = (char *)sqlite3_column_text(statement, 7);
                NSString *userIdStr = [[NSString alloc]initWithUTF8String:userId];
                [mutableDictionary setObject:userIdStr forKey:@"userId"];
                
                char *mail = (char *)sqlite3_column_text(statement, 8);
                NSString *mailStr = [[NSString alloc]initWithUTF8String:mail];
                [mutableDictionary setObject:mailStr forKey:@"mail"];
                
                [mutableArray addObject:mutableDictionary];
            }
            isOperation = false;
            successBlock(mutableArray);
        }else{
            failureBlock();
        }
            sqlite3_finalize(statement);
    }
}

-(void)dropTable:(Success)successBlock failed:(Failed)failedBlock{
    NSString * sql = [@"drop table if exists "stringByAppendingString:@"Contact"];
    NSLog(@"sql : %@",sql);
    @synchronized (self) {
        @try {
           sqlite3_exec(db, sql.UTF8String, NULL, NULL, NULL);
           successBlock();
        } @catch (NSException *exception) {
           failedBlock();
        } @finally {
            
        }
    }
//    sqlite3_exec(db, sql.UTF8String, NULL, NULL, NULL);
}

-(void)closeDB{
    if (sqlite3_close(db) == SQLITE_OK){
        db = nil;
    }
}

+ (void)destroyDealloc{
    if (nil == manager){
        return;
    }
    manager = nil;
}

@end
骑码小张
关注
专栏目录
116道iOS面试题+答案，希望对你的面试有帮助
原来是泽镜的博客
01-08 7378
之前看了很多面试题，感觉要不是不够就是过于冗余，于是我将网上的一些面试题进行了删减和重排，现在分享给大家。（题目来源于网络，侵删） 1. Object-c的类可以多重继承么?可以实现多个接口么?Category是什么?重写一个类的方式用继承好还是分类好?为什么? 答： Object-c的类不可以多重继承;可以实现多个接口，通过实现多个接口可以完成C++的多重继承;Category是类别，一般情况用分类好，用Category去重写类的方法，仅对本Category有效，不会影响到其他类与原有类的关系。 2. #
iOS 开发技术栈与进阶
Thinker361的专栏
03-10 447
最近有一些开发朋友问我应该怎样提升自己的能力，回想起来做了这么久 iOS 开发，我也有过那种“让我做一个功能实现个需求我会做，但接下来怎样提高我不知道。”的时期，这里尝试列一下 iOS 开发的相关技术，再说说在学习进阶上我的一些想法。 iOS 技术栈 这里按我的理解给 iOS 相关技术分个类，以工程实现的角度，分成了基础、需求、效率、质量四个类别。基础指程序开发和 iOS 开发的基础知
解决sqlite死锁示例异常database is locked示例
08-20
解决sqlite死锁示例异常database is locked示例
小代码大BUG,记解决Sqlite3死锁问题
weixin_33725722的博客
02-18 213
随时记录学习,工作中遇到的点滴"大问题,小问题" 今天遇到了一个问题,sqlite3提示数据库死锁,无法更新,奇怪的是可以插入,可以查询,可以删除,就是不可以更新, 经过近几个小时的排查,最终找到了问题的根源, 有一点点想法,就是问题大不大,关键看你懂不懂,或者说,问题解决没解决,如果没解决,那么就是个大问题 如果问题解决了,那么就是小问题,而且吧,这个小问题或大问题的定义因人而异,而经验...
SQLite死锁
csenjoy的博客
06-08 4078
一，场景描述    有两个线程，一个线程对SQLite数据库读操作。另外一个线程对数据库写操作，写操作是通过begin transaction, commit transaction操作完成。业务层操作保存数据时，出现卡死现象    通过日志打印，发现commit transaction时，出现数据库死锁二.解决过程    通过https://blog.csdn.net/u012160319/ar...
IOS开发中的死锁问题
xx_irish的专栏
11-07 502
最近开发中遇到的死锁问题比较多， 近段时间总结了下还是基础不够扎实： 在继续的开发过程中， 会不定期更新开发中遇到的并发死锁问题 2016-11-7 今天遇到个数据库中使用互斥锁导致的问题：   一般数据库查询结构如下： @Semaphore_Wait(MUTEX) [self yourOwnHandle:^(FMDatabase *db, BOOL *rollback)
cocoa并发访问Sqlite中的死锁问题
xx_irish的专栏
11-04 793
在实际开发过程中， 如果涉及到数据库的频繁写入， 更新等操作， 在加上连续事件的有序操作， 死锁的问题就可能发生： 废话不多说了： 开发中使用最多sqlite三方库是FMDB， 最新版本的FMDB为了支持并发， 加入了FMDatabaseQueue， 其原理就是对一个databse的访问， 通过内部的一个serialQueue来控制对数据库的串行访问， 这就意味着所有的入口必须是统一的，全局仅
支持单表封装sqlite
04-04
在iOS开发中，SQLite是一种常用的嵌入式关系型数据库，因其小巧、轻便且无需额外服务器进程而广受欢迎。DBKit将SQLite的操作进行了封装，提供了更加便捷的API，使得开发者可以更专注于业务逻辑，而不是数据库底层...
30道iOS底层面试题
最新发布
07-25
在iOS开发领域，深入理解底层原理是提升技术能力的关键，也是面试中经常被考察的部分。...以上这些知识点是iOS底层面试中常见的主题，通过深入学习和实践，可以为面试做好充分准备，并且提升实际开发中的问题解决能力。
招人心得iOS47道面试题
10-27
- **文件系统**：了解如何在iOS中进行文件读写操作，包括使用SQLite数据库。 - **安全性**：注意保护敏感数据的安全，如使用加密技术。 ### 31. Bug修复 - **调试技巧**：掌握有效的调试技巧，如使用断言、日志记录...
sqlite死锁datebaselock解决方案
09-07
解决sqlite3 databaselocked 问题的代码实例，比较有参考价值。
sqlite3.30.1 数据库模块+支持库（彻底解决多线程死锁问题）-易语言
06-14
本次更新对于支持库来说，接口改动不大，模块版的话是尽量和支持库接口保持一致，所以对于以前的模块接口可能改动就大了。 要解决多线程问题，主要是对sqlite3的锁机制进行了解，和事务有密切的关系。本次更新的版本在开始事务时，增加了一个 事务锁状态 的参数。 拿简单的话来描述就是 开始事务 时如果 设置了 事务锁状态_ 立即 参数，那么这个时候其他线程的连接就不能写操作了，但是可以读操作，但是在提交事务时也要等待所有读操作完成了才能提交。 设置了 事务锁状态_ 独占 参数，那么这个时候其他线程的连接读写都不可以了。 在等待的时候就处于繁忙状态，我们可以设置 数据库.繁忙超时 （）来设置等待时间。 还有种情况还是会 死锁 ，就是记录集没有关闭，而且这次更新的支持库和模块都是必须 手动关闭记录集 的，所以一定注意。 当然多进程和多线程是一个道理，具体操作看例子。 esqlite3 V1.1 相对于1.0的更新 1、增加了全局命令： S3互斥体进入 S3互斥体退出 S3聚合上下文 S3取数据库自上下文 2、增加了zySqlite数据库 命令 繁忙超时 繁忙处理 取文件名 是否只读 取互斥体 是否自动提交 进度处理 取下一记录集 取总影响行 3、增加了 zySqlite记录集 命令 是否繁忙 是否只读 取数据库句柄 取行数 4、数据库.开始事务（） 增加了 事务锁状态 参数，此参数在多线程中非常重要。 5、记录集必须手动关闭，任何内部方法都不再自动关闭。
android sqlite数据库死锁,关闭sqlite数据库时出现死锁
weixin_35926197的博客
05-27 555
我正在调查我项目中的偶然事件。当后台有很多对数据库的请求,用户单击按钮,数据库作为注销的一部分被关闭时,就会发生这种情况。我用的是saferoom和rx-java2。这是来自测试项目的一些代码,我试着重现这个问题(重现大约30%的时间):class MainActivity : AppCompatActivity() {lateinit var db: TestDbprivate val disp...
ios- 死锁
FIGHTING的专栏
09-24 983
什么是死锁 ？ 什么时候会发生死锁？ 出现死锁我们怎么解决 死锁就是线程之间的相互等待 简单的来说 就是你等我 我等你  线程出现这种情况会导致死锁的放生 举个简单的例子 ： #import "GCDViewController.h" @interface GCDViewController () { /** * 串行队列 */
SQLite被锁定解决办法-iOS
Michael Zhan的博客
02-12 7470
第一次在项目中遇到使用SQLite，之前写Android的时候同样的流程没有出错。Android对SQLite的”增删改查”——SQLiteDatabase Android SQLite操作之“SQLiteOpenHelper” 这里也可能我只是写了一个Demo，就一个页面，所以没有发现那个错误。但是iOS的APP我是多出使用SQLite，而且我是把SQLite的操作写在Controller之外
iOS用中文字符串查询SQLite数据库多条数据的坑
路漫漫其修远
11-05 99
例如有这样一个数据表: Paste_Image.png 想要查询league="英超"的数据集. 可以直接写死let sql = " SELECT * FROM match where league = '英超'",这样可以查询想要的结果. 而如果使用let sql = "SELECT * FROM match where league = ?". 假如参数是let canshustr...
解决sqlite死锁 异常database is locked 案例
zhiaimm的专栏
08-20 1228
java操作sqlite经常出现死锁？出现异常：database is locked， http://download.csdn.net/detail/zhiaimm/4513636 死锁示例下载地址 http://download.csdn.net/detail/zhiaimm/4513630 android 滑动翻页 多点触控放大 http://download.csdn.net/d...
解决sqlite死锁示例异常database is locked
热门推荐
Dream It Possible
04-16 1万+
/* * sqlite的连接方式实际上为单连接方式，即使实用多线程也是用的一个连接 * getWritableDatabase()和getReadableDatabase()都为synchronized方法，但不是static方法 * 所以都只对同一个对象起同步作用，对于不同的对象没有任何作用 * 所以使用sqlite的时候可以提供一个单一的入口，防止多对象修改数据库而造成死锁 * 所以
使用sqlite的api执行删表操作被锁问题
m0_59119702的博客
05-10 588
使用sqlite的api执行删表操作被锁问题
iOS开发中使用SQLite数据库的原生实现
iOS中sqlite数据库的原生用法是指在iOS开发中使用sqlite数据库的原生API，sqlite数据库是一个轻巧的数据库，数据库仅一个文件，即建即用。下面将详细介绍如何在swift中使用原生的sqlite的API。 一、引入sqliteAPI ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值