Re: [sqlite] added new db with other journal mode. Any issue?
this the sequence of sqlite statements: -- sqlite3_open sqlite3_key sqlite3_prepare_v2 sqlite3_step sqlite3_finalize sqlite3_prepare_v2 --- //my application crashed here On Wed, Nov 14, 2012 at 5:14 PM, Durga D wrote: > sqlite_source_id(): 2012-03-20 11:35:50 > 00bb9c9ce4f465e6ac321ced2a9d0062dc364669 > > I will send the sequence of sql stmts. > > > On Wed, Nov 14, 2012 at 4:51 PM, Richard Hipp wrote: > >> On Wed, Nov 14, 2012 at 3:41 AM, Durga D wrote: >> >> > I got the below error: >> > --- >> > The database disk image is malformed. >> > >> >> Please send: >> >> (1) The version of SQLite you are running - the output of "SELECT >> sqlite_source_id();". >> (2) The exact sequence of SQL statements and API calls you used to create >> the error above. Be specific, please. >> >> Thanks. >> >> >> > >> > I am able to open. It's throwing above error when I try to set journal >> mode >> > as truncate after db open before tables creation. How to solve this? >> > >> > >> > On Wed, Nov 14, 2012 at 11:59 AM, Simon Slavin >> > wrote: >> > >> > > >> > > On 14 Nov 2012, at 7:35am, Durga D wrote: >> > > >> > > > I have 8 sqlite databases with TRUNCATE journal mode. I have added >> new >> > > > database with WAL journal mode. Now, 9 databases in my application. >> > Will >> > > it >> > > > give any database corruption? >> > > >> > > You can mix different modes for different databases without problems. >> > > >> > > Simon. >> > > ___ >> > > sqlite-users mailing list >> > > sqlite-users@sqlite.org >> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > >> > ___ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] added new db with other journal mode. Any issue?
sqlite_source_id(): 2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669 I will send the sequence of sql stmts. On Wed, Nov 14, 2012 at 4:51 PM, Richard Hipp wrote: > On Wed, Nov 14, 2012 at 3:41 AM, Durga D wrote: > > > I got the below error: > > --- > > The database disk image is malformed. > > > > Please send: > > (1) The version of SQLite you are running - the output of "SELECT > sqlite_source_id();". > (2) The exact sequence of SQL statements and API calls you used to create > the error above. Be specific, please. > > Thanks. > > > > > > I am able to open. It's throwing above error when I try to set journal > mode > > as truncate after db open before tables creation. How to solve this? > > > > > > On Wed, Nov 14, 2012 at 11:59 AM, Simon Slavin > > wrote: > > > > > > > > On 14 Nov 2012, at 7:35am, Durga D wrote: > > > > > > > I have 8 sqlite databases with TRUNCATE journal mode. I have added > new > > > > database with WAL journal mode. Now, 9 databases in my application. > > Will > > > it > > > > give any database corruption? > > > > > > You can mix different modes for different databases without problems. > > > > > > Simon. > > > ___ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > D. Richard Hipp > d...@sqlite.org > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] added new db with other journal mode. Any issue?
On Wed, Nov 14, 2012 at 3:41 AM, Durga D wrote: > I got the below error: > --- > The database disk image is malformed. > Please send: (1) The version of SQLite you are running - the output of "SELECT sqlite_source_id();". (2) The exact sequence of SQL statements and API calls you used to create the error above. Be specific, please. Thanks. > > I am able to open. It's throwing above error when I try to set journal mode > as truncate after db open before tables creation. How to solve this? > > > On Wed, Nov 14, 2012 at 11:59 AM, Simon Slavin > wrote: > > > > > On 14 Nov 2012, at 7:35am, Durga D wrote: > > > > > I have 8 sqlite databases with TRUNCATE journal mode. I have added new > > > database with WAL journal mode. Now, 9 databases in my application. > Will > > it > > > give any database corruption? > > > > You can mix different modes for different databases without problems. > > > > Simon. > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] added new db with other journal mode. Any issue?
I got the below error: --- The database disk image is malformed. I am able to open. It's throwing above error when I try to set journal mode as truncate after db open before tables creation. How to solve this? On Wed, Nov 14, 2012 at 11:59 AM, Simon Slavin wrote: > > On 14 Nov 2012, at 7:35am, Durga D wrote: > > > I have 8 sqlite databases with TRUNCATE journal mode. I have added new > > database with WAL journal mode. Now, 9 databases in my application. Will > it > > give any database corruption? > > You can mix different modes for different databases without problems. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] added new db with other journal mode. Any issue?
On 14 Nov 2012, at 7:35am, Durga D wrote: > I have 8 sqlite databases with TRUNCATE journal mode. I have added new > database with WAL journal mode. Now, 9 databases in my application. Will it > give any database corruption? You can mix different modes for different databases without problems. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] added new db with other journal mode. Any issue?
Hi All, I have 8 sqlite databases with TRUNCATE journal mode. I have added new database with WAL journal mode. Now, 9 databases in my application. Will it give any database corruption? Regards, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users