I'm using the SQLiteJDBC in a servlet. Each thread going against a different db/file. When I run multiple threads (by running a client program multiple times), the JVM aborts (see below dump..) If I run the client program (which posts an HTTP request) like 20,000 times, it works fine .. So I'm thinking this is a multiple threads issue...
It also seems to abort at different points... For example, multiple runs generate STACKS as follows: I will try to work on a stand alone program to duplicate the problem.. If I'm *lucky* I may be able to find this, and I will surely submit the fix... But in the meantime, I thought I post this in case someone else out there is having the same issue.. Thanks in advance. PS: I wish David Crawshaw could respond.. Dave, any idea.. ---------------------------------------------------------------------------------------------------------------------------------------------------------------- RUN A Stack: [0x0b450000,0x0b490000), sp=0x0b48f478, free space=253k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [sqlitejdbc.dll+0x45471] C [sqlitejdbc.dll+0x4560e] C [sqlitejdbc.dll+0x23da] J org.sqlite.NativeDB.bind_text(JILjava/lang/String;)I J org.sqlite.DB.sqlbind(JILjava/lang/Object;)I J org.sqlite.DB.executeBatch(JI[Ljava/lang/Object;)[I j org.sqlite.PrepStmt.executeBatch()[I+21 j util.jdbc.UCPersistSqlite.executePrepBatch(Lutil/jdbc/PrepStmt;)V+6 J Main.UCReader.doPrepStatementInserts()V j Main.UCReader.persist()V+65 j Main.processRequest(Ljavax/servlet/http/HttpServletRequest;Ljavax/ servlet/http/HttpServletResponse;)V+413 j Main.doPost(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/ http/HttpServletResponse;)V+3 j javax.servlet.http.HttpServlet.service(Ljavax/servlet/http/ HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+139 ---------------------------------------------------------------------------------------------------------------------------------------------------------------- RUN B Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [sqlitejdbc.dll+0x45471] C [sqlitejdbc.dll+0x4560e] C [sqlitejdbc.dll+0x23da] J org.sqlite.NativeDB.bind_text(JILjava/lang/String;)I J org.sqlite.DB.sqlbind(JILjava/lang/Object;)I J org.sqlite.DB.executeBatch(JI[Ljava/lang/Object;)[I j org.sqlite.PrepStmt.executeBatch()[I+21 j util.jdbc.UCPersistSqlite.executePrepBatch(Lutil/jdbc/PrepStmt;)V+6 J Main.UCReader.doPrepStatementInserts()V j Main.UCReader.persist()V+65 j Main.processRequest(Ljavax/servlet/http/HttpServletRequest;Ljavax/ servlet/http/HttpServletResponse;)V+413 j Main.doPost(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/ http/HttpServletResponse;)V+3 ---------------------------------------------------------------------------------------------------------------------------------------------------------------- # # An unexpected error has been detected by HotSpot Virtual Machine: # # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x6bafe323, pid=9064, tid=7228 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_09-b03 mixed mode) # Problematic frame: # C [sqlitejdbc.dll+0x3e323] # --------------- T H R E A D --------------- Current thread (0x0b21a0f8): JavaThread "btpool0-7" [_thread_in_native, id=7228] siginfo: ExceptionCode=0xc0000005, reading address 0x00000000 Registers: EAX=0x00000000, EBX=0x00000000, ECX=0x00000000, EDX=0x00000001 ESP=0x0b4ced80, EBP=0x0b4ced98, ESI=0x00000001, EDI=0x0b4cedbc EIP=0x6bafe323, EFLAGS=0x00010246 Top of Stack: (sp=0x0b4ced80) 0x0b4ced80: 0adc1218 0aee66a8 0b4ceda8 0ad97f70 0x0b4ced90: 0ad97f70 00000000 0b4cedc8 6baff494 0x0b4ceda0: 00000000 0b4cedbc 00000001 6bac7fb7 0x0b4cedb0: 0aee66a8 0000002c 0adc1618 0aee66a8 0x0b4cedc0: 0aee66a8 0ad97f70 0b4cede8 6baff53b 0x0b4cedd0: 0ad97f70 00000001 0b4cede8 0aec4dd8 0x0b4cede0: 0af217f0 0af258b4 0b4cf188 6bb014bd 0x0b4cedf0: 0ad97f70 fffffff8 00000001 6bb07774 Instructions: (pc=0x6bafe323) 0x6bafe313: f0 46 80 fa 03 0f 94 c0 0f b6 c0 8b 5d 08 01 c3 0x6bafe323: 80 3b 2d 0f 94 c2 80 3b 2b 0f 94 c0 09 d0 a8 01 Stack: [0x0b490000,0x0b4d0000), sp=0x0b4ced80, free space=251k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [sqlitejdbc.dll+0x3e323] C [sqlitejdbc.dll+0x3f494] C [sqlitejdbc.dll+0x3f53b] C [sqlitejdbc.dll+0x414bd] C [sqlitejdbc.dll+0x44b1a] C [sqlitejdbc.dll+0x44c44] C [sqlitejdbc.dll+0x1ef5] J org.sqlite.NativeDB.step(J)I J org.sqlite.DB.executeBatch(JI[Ljava/lang/Object;)[I J util.jdbc.UCPersistSqlite.executePrepBatch(Lutil/jdbc/PrepStmt;)V J Main.UCReader.doPrepStatementInserts()V --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
