Re: [sqlite] Strange sqlite_busy deadlock behavior

But why is this deadlocking at all? I thought there shouldn't be a problem doing this, especially since thread B is using a transaction. Shouldn't either A or B prevent the other one from accessing the database until they are done? On 4/7/09, D. Richard Hipp wrote: > > On Apr 7,

[sqlite] Sqlite 2

Hello All, I need a sqlite 2 windows binary but can't find it on the sqlite site anywhere. Anyone know where I can download "sqlite.exe" ? Any v2 will be ok. Thanks in advance! Greetings, chuvke ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] import fails silently on fedora 5 - SQLite version 3.3.3

I have a database file with a schema and zero rows. When I try to import a data file into a table the sqlite prompt returns immediately and zero rows are actually imported. I can copy the database file and the file containing rows to another machine running Fedora 7(SQLite version 3.4.2), run

[sqlite] Sqlite, vb6 and date time field

Hi I received a Sqlite database from someone, and they also gave me SQLite2008Pro together with the ODBC Driver. They want a front end to view/query the data that I'm building in vb6. One of the fields is a DateStamp with a datatype DateTime. When I try to display that field I get an 'Invalid use

Re: [sqlite] Strange sqlite_busy deadlock behavior

On Apr 8, 2009, at 2:13 AM, Dave Brown wrote: > But why is this deadlocking at all? I thought there shouldn't be a > problem doing this, especially since thread B is using a transaction. > Shouldn't either A or B prevent the other one from accessing the > database until they are done? It is a

Re: [sqlite] Possible bug

On Apr 8, 2009, at 6:21 AM, Arthur Skowronek wrote: > > Running the sqlite3 CLI interface with the parameters > -init twdata.sql twdata.db crashes the SQLite library > with a segfault. SQLite should never segfault, so this is a bug. But without seeing the twdata.sql and twdata.db files, there

Re: [sqlite] Possible bug

on Wed, 8 Apr 2009 06:58:21 -0400 "D. Richard Hipp" wrote: > > On Apr 8, 2009, at 6:21 AM, Arthur Skowronek wrote: > > > > Running the sqlite3 CLI interface with the parameters > > -init twdata.sql twdata.db crashes the SQLite library > > with a segfault. > > SQLite should

[sqlite] UTF-16 API a second class citizen?

Wow man that is the page I've been looking for my whole life but didn't know it...finally an explanation for this mess. > From: "Igor Tandetnik" > > "The Absolute Minimum Every Software Developer > Absolutely, Positively > Must Know About Unicode and Character Sets (No >

Re: [sqlite] Possible bug

Hi, My attachments have been cutted out again... I have uploaded them now to my web space. They can be found at http://redsmile.org/twdata.tar cheers... ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Possible bug

Hello all, I'm new to this mailing list and I guess I found a bug in SQLite. I'm not sure how to use this mailing list since this is the first time I'm using one. so I will just append the plain sql file to this email with an backtrace generated with gdb. Running the sqlite3 CLI interface with

Re: [sqlite] UTF-16 API a second class citizen?

"Vinnie" wrote in message news:621704.45397...@web58202.mail.re3.yahoo.com > To be honest, thinking about character > encodings gives me a large headache "The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No

Re: [sqlite] Sqlite, vb6 and date time field

Can you provide maybe 10 samples of the dates on the database. Some databases have a different date format and you might have to format the date or convert it to a string and back into a date again. sqlite-users-boun...@sqlite.org wrote on 04/08/2009 06:20:09 AM: > Hi > > I received a

Re: [sqlite] Sqlite, vb6 and date time field

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

Re: [sqlite] Sqlite 2

Chuvke wrote: > Hello All, > > I need a sqlite 2 windows binary but can't find it on the sqlite site > anywhere. > Anyone know where I can download "sqlite.exe" ? Any v2 will be ok. > I am sure there better ways, but if nothing else comes up, I can email 2.8.17 to you. the zip file is only

Re: [sqlite] Sqlite 2

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

Re: [sqlite] Possible bug

Hi, Arthur, This mailing list, like many, will automatically strip attachments. Posting onto your own webspace is a great way, as you have discovered, to reference files. I'm writing just to say that I *did* reproduce a problem. I'm using Windows XP SP3. I narrowed the problem to the sql

Re: [sqlite] Possible bug

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

[sqlite] Attach the data return an error message

Hi all, I had the application using sqlite and executing the following sql statement: executeStmt: Error in executing the statment database TCPADDB is already in use. Error St = 1 , stmt =   ATTACH DATABASE \'/opt/phoenix/monitor/TCPFlowCurDayDB\'  as TCPADDB; insert into tcpFlowTable select

Re: [sqlite] Attach the data return an error message

> Hi all, > I had the application using sqlite and executing the following sql statement: > executeStmt: Error in executing the statment database TCPADDB is already in > use. Error St = 1 , stmt = ATTACH DATABASE > \'/opt/phoenix/monitor/TCPFlowCurDayDB\' as TCPADDB; insert into >

Re: [sqlite] Strange sqlite_busy deadlock behavior

I tried the BEGIN EXCLUSIVE method, but now the problem is that thread-A is in the middle of a query doing sqlite3_step() to get results, and thread-B tries a "begin exclusive" and gets back SQLITE_BUSY in the deadlock situation :) I guess I am forced to use your 2nd method?? On 4/8/09, D.

Re: [sqlite] Strange sqlite_busy deadlock behavior

I think the EXCLUSIVE pill (to avoid calling it poison) should have done the job and the busy state is expected and no dead lock, right ? I would like to assure that sqlite works great in such a thread environment, despite the sqlite parents seems not like the idea...;) Marcus > I tried the

Re: [sqlite] Strange sqlite_busy deadlock behavior

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave Brown Sent: Wednesday, April 08, 2009 1:16 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Strange sqlite_busy deadlock behavior I tried the BEGIN

Re: [sqlite] Strange sqlite_busy deadlock behavior

I understand what a deadlock is, and I know it's not technically a deadlock. This is why I stated the title as deadlock behavior. Anyway, like I said, I can set the busy timeout to 100 seconds, and it still hangs for 100 seconds, even though the queries being performed by either thread should not

Re: [sqlite] Strange sqlite_busy deadlock behavior

just for my curiosity: what is thread A doing after/within the 100 seconds that elapsed in thread B after trying to get the exclusive transaction? maybe you simply forgot to finalize the query in thread A ? > I understand what a deadlock is, and I know it's not technically a > deadlock. This is

[sqlite] what is the default for the commit when the connection is opened.

Hi All, When we use the sqlite3_open_v2 to open the database is this defautl to "Auto commit" ? Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what is the default for the commit when the connection is opened.

Hi, sqlite does not know an "auto commit". If you do not call "begin transaction", then every insert/update/delete statement is wrapped in its own transaction. This is like "auto commit" If you do call "begin transaction", you start a transaction which you have to finish with "commit" or

Re: [sqlite] what is the default for the commit when the connection is opened.

On Wed, Apr 08, 2009 at 10:12:15PM +0200, Martin Engelschalk scratched on the wall: > Hi, > > sqlite does not know an "auto commit". Actually, that's what the default mode is called. You're either in "autocommit" mode or you're in a transaction. Starting a transaction turns off

Re: [sqlite] Strange sqlite_busy deadlock behavior

Thread A is in the process of executing sqlite3_step(). I can post the full stack if you want. It goes all the way down to winSleep() in the sqlite3 codebase. After the full busy timeout, thread B (not A) gets SQLITE_BUSY returned. On 4/8/09, Marcus Grimm wrote: > just

[sqlite] SQLite performance on select/update with 11GB database file

Hi all, I have been trying to implement a couple of things in SQLite because I only need it for myself (so no concurrency issues here). I am working on Arch Linux (uname: 2.6.28-ARCH #1 SMP PREEMPT Sun Mar 8 10:18:28 UTC 2009 i686 Intel(R) Xeon(TM) CPU 3.40GHz). I have a flat text file

Re: [sqlite] Strange sqlite_busy deadlock behavior

On Apr 8, 2009, at 3:12 PM, Dave Brown wrote: > Thread A is in the process of executing sqlite3_step(). I can post the > full stack if you want. It goes all the way down to winSleep() in the > sqlite3 codebase. After the full busy timeout, thread B (not A) gets > SQLITE_BUSY returned. Does each

[sqlite] trigger with transaction

Hi all, A simple question... Say I have a bunch of db insert/updates performed as a transaction. If the table has a "AFTER INSERT" trigger, is it fired: 1) right after the insert statement? 2) right before transaction commit? 3) after commit? And what if the transaction fails if 1) or 2) is

Re: [sqlite] heap corruption?

thanks for the suggestions. i have tried all of these suggestions and we're working on this. is there a function in SQLite that i can call that will (in effect) verify the page cache? what i'd like to do is pepper the code that is calling into SQLite w/ verify_page_cache to attempt to figure

Re: [sqlite] trigger with transaction

Simon Chen wrote: > A simple question... Say I have a bunch of db insert/updates > performed as a transaction. If the table has a "AFTER INSERT" > trigger, is it fired: 1) right after the insert statement? > 2) right before transaction commit? > 3) after commit? Running

Re: [sqlite] Strange sqlite_busy deadlock behavior

Each thread has it's own connection handle (stated this in the original email). anyone want to see a stack trace? On Wed, Apr 8, 2009 at 2:22 PM, Lawrence Gold wrote: > On Apr 8, 2009, at 3:12 PM, Dave Brown wrote: > > > Thread A is in the process of executing

Re: [sqlite] trigger with transaction

I guess if the trigger contains database operations, they would be rolled-back as well. The question is, if the trigger externalizes some internal state, how can a rollback revoke that? A stupid example would be, a trigger sends out an email saying "a inserted", but this transaction actually

Re: [sqlite] trigger with transaction

"Simon Chen" wrote in message news:22963996.p...@talk.nabble.com > I guess if the trigger contains database operations, they would be > rolled-back as well. > The question is, if the trigger externalizes some internal state, how > can a rollback revoke that? It can't of

Re: [sqlite] trigger with transaction

Thanks for your reply. Another related question, during rollback, would triggers be called? For example, for a transaction, I may do a bunch of inserts, which in turn called some triggers. During rollback, those inserts are reverted. Would according delete triggers be called? Thanks! -Simon