Re: [sqlite] sqlite database is locked when query SQLITE_MASTER table

2016-06-17 Thread Simon Slavin
Are you programming in a programming language ? If so, which language are you using and which library are you using to execute SQLite commands ? If you are scripting instead please tell us which scripting language you're using. If you are using multi-threading or multi-processing, please tell

[sqlite] sqlite database is locked when query SQLITE_MASTER table

2016-06-17 Thread Bhavesh Patel
I have the huge size of the database file (approx 5.5GB). I have two processes. 1.The first process: It executes master table query. (Ex. "SELECT "type", "tbl_name" FROM "SQLite_MASTER"). It creates the new table using the dump of the existing table and database file size has been increased