determine whether sqlite database is locked

user4592357

i need to determine whether the sqlite database is locked. i found this function which returns that info. but, in order to call this function, i need sqlite3.h and sqlite3.c which doesn't come with qt. so i need to download these files and link them with my project.
is there a better way to determine whether the database is locked?

SGaist

Hi,

From the looks of the documentation, it's rather for when a table is locked. So is it really what you want ?

user4592357

@sgaist
yeah i know but that's what i found. i didn't find any other way

fcarney

It is included. Here is how I got to it when playing with sqlite specific functions. You may need to alter some paths if those changed between revisions of Qt:
https://forum.qt.io/topic/101018/qsqldatabase-sqlite-how-to-load-into-memory-and-save-memory-to-disk/13

user4592357

@fcarney
my application uses a custom built qt (not the one downloaded from the website), and i looked at qtsql, sqldrivers folders, performed a search and didn't find the header file...

fcarney

Did you look in this directory? $$[QT_INSTALL_PREFIX]/../Src/qtbase/src/3rdparty/sqlite

user4592357

@fcarney
the directory structure is different
i have

qt/
    include/
        qtcore,qtgui,...
    plugins/
        sqldrivers

fcarney

I dunno then. If your version supports sqlite I would think it would have to be in there somewhere. The other option is getting a copy of sqlite and using that.

mrjj

Hi
But do you really need to know of its locked?
You will get an error if you try to perform operations and it is indeed locked.
So that case could be treated like any other type of db failure.

user4592357

@mrjj
yes i first need to check if the db is locked. because in that case i need to show another dialog, and in all other db access failure cases should be handled differently (just print a message, etc.)

mrjj

@user4592357
ok. it was worth a shot. :)

i would download the source (version wise) of the Qt used to build your
custom Qt and take the sqlite files from there to be 100% sure its
compatible. or at least check the version used and download that from their site.

JonB

@user4592357

@mrjj said:

You will get an error if you try to perform operations and it is indeed locked.

You said:

yes i first need to check if the db is locked. because in that case i need to show another dialog,

So since this is proving so difficult, can you not initially try one operation which will raise an error if db is locked, then put up you dialog, and treat any subsequent errors in your standard dialog way?

user4592357

what if the database is locked during the running of the application? in that case i need to perform "is database locked?" before executing each query (even selects). so i guess i need to perform this check before executing each query.

user4592357

okay i downloaded the files and built with my project.
so i set the db connection timeout to 0:

	auto db = QSqlDatabase::database();
	db.setDatabaseName(m_sDatabasePath);
	db.setConnectOptions("QSQLITE_BUSY_TIMEOUT=0");
	if (!db.open())
		return false;

and then i do this:

bool isDatabaseLocked(const QSqlDatabase &db)
{
	if (auto driver = db.driver())
	{
		// get driver handler
		QVariant v = driver->handle();
		if (v.isValid() && qstrcmp(v.typeName(), "sqlite3*") == 0)
		{
			// v.data() returns a pointer to the handle
			auto handle = *static_cast<sqlite3 **>(v.data());
			if (handle)
			{
				std::cout << sqlite3_busy_handler(handle, cb, nullptr) << std::endl;
				std::cout << sqlite3_busy_timeout(handle, 0) << std::endl;
			}
		}
	}

	return true;
}

int cb(void *data, int)
{
	std::cout << "cb" << std::endl;
	return 0;
}

both these functions return 0 (SQLITE_OK) while i'd expect to get 5 (SQLITE_BUSY). and the callback function isn't called either. so what's wrong?

JonB

@user4592357 said in determine whether sqlite database is locked:

what if the database is locked during the running of the application? in that case i need to perform "is database locked?" before executing each query (even selects). so i guess i need to perform this check before executing each query.

Absolutely not! If it's locked, you'll find out on your genuine call, not an extra check each time!

user4592357

This post is deleted!

user4592357

@jonb
yes i know, with lastError(). but what about handling it? should i check if (lastError().startWith("database is locked")) then show dialog else do something else? i don't like this

JonB

@user4592357
If you are are issuing some SQL statement which can only error in your "locked" case then you know where you are. If the "locked" can be returned from any SQL call then it looks like you have little choice but to look at lastError(), since I do not see that Qt returns any information about a SQLite native error number you could examine.

Yes, it's not perfect. Personally I'd still prefer that to having to bring in extra files and compile the driver myself just to get it perfect. What is this locked all about, is your app so critical that you have to get this case perfect, and why are you subject to this issue when loads of other people are using Qt with SQLite without worrying about this?

user4592357

@jonb
yes i need to process the locked state of the database because it can potentially be opened from another application as well (in a nutshell, these two apps can talk to each other).

i actually downloaded the files and compiled them. two posts above i show the code which i'm using but it doesn't return anything related to sqlite being busy or locked. is the code actually correct?

Call for Presentations - Qt World Summit

Unsolved determine whether sqlite database is locked