Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Bugs: org.h2.jdbc.JdbcSQLException: File not found

Bottom of Page

1 to 8 of 8

  1.  
    • CommentAuthorNikolayB
    • CommentTimeAug 26th 2009
     
    I have generated new Jet Profiler Project and then have written it in a file on a disk.

    When I have tried to open the project has received an error message:

    An internal database error has occurred.
    The application needs to quit. Error details:

    org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\257.t65.lob.db [90124-106]

    And so repeats over and over again. Including at attempt to restore "the lost data" at program start.
  2.  
    That sounds strange. It might be that the internal database used by Jet Profiler to store statistics (h2), has gone corrupt.

    Could you please paste the full error stack trace? You should be able to find it in the logs directory (e.g. C:\Program Files\Jet Profiler for MySQL\logs).
    • CommentAuthorNikolayB
    • CommentTimeSep 7th 2009
     
    ================================================================================
    ONE
    ================================================================================
    2009-08-25 21:46:48,993 INFO [Foxtrot Single Worker Thread #1] fe - Opening project D:\tp.jpp
    2009-08-25 21:46:51,384 ERROR [Foxtrot Single Worker Thread #1] h2database - proj:jdbc[21] Uncaught Exception
    org.h2.message.InternalException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.convertToInternal(Message.java:298)
    at org.h2.value.ValueLob.getReader(ValueLob.java:627)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    2009-08-25 21:46:51,384 ERROR [AWT-EventQueue-0] Catch.all - Internal database error on [AWT-EventQueue-0]: An internal database error has occurred.
    The application needs to quit. Error details:

    org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    fk: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106] - query: SELECT * FROM query
    at cq.a(SourceFile:344)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.getSQLException(Message.java:103)
    at org.h2.message.Message.getSQLException(Message.java:114)
    at org.h2.message.Message.getSQLException(Message.java:77)
    at org.h2.engine.Database.openFile(Database.java:397)
    at org.h2.value.ValueLob.getInputStream(ValueLob.java:635)
    at org.h2.value.ValueLob.getReader(ValueLob.java:625)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    ... 16 more
    2009-08-25 21:46:56,743 INFO [br2] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    2009-08-25 21:46:56,743 INFO [br1] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    • CommentAuthorNikolayB
    • CommentTimeSep 7th 2009
     
    ================================================================================
    TWO
    ================================================================================
    2009-08-25 21:47:25,353 INFO [Foxtrot Single Worker Thread #1] fe - Opening project D:\18-21.jpp
    2009-08-25 21:47:31,588 ERROR [Foxtrot Single Worker Thread #1] h2database - proj:jdbc[21] Uncaught Exception
    org.h2.message.InternalException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\257.t65.lob.db [90124-106]
    at org.h2.message.Message.convertToInternal(Message.java:298)
    at org.h2.value.ValueLob.getReader(ValueLob.java:627)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    2009-08-25 21:47:31,603 ERROR [AWT-EventQueue-0] Catch.all - Internal database error on [AWT-EventQueue-0]: An internal database error has occurred.
    The application needs to quit. Error details:

    org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\257.t65.lob.db [90124-106]
    fk: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\257.t65.lob.db [90124-106] - query: SELECT * FROM query
    at cq.a(SourceFile:344)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\257.t65.lob.db [90124-106]
    at org.h2.message.Message.getSQLException(Message.java:103)
    at org.h2.message.Message.getSQLException(Message.java:114)
    at org.h2.message.Message.getSQLException(Message.java:77)
    at org.h2.engine.Database.openFile(Database.java:397)
    at org.h2.value.ValueLob.getInputStream(ValueLob.java:635)
    at org.h2.value.ValueLob.getReader(ValueLob.java:625)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    ... 16 more
    2009-08-25 21:47:36,697 INFO [br2] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    2009-08-25 21:47:36,697 INFO [br1] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    • CommentAuthorNikolayB
    • CommentTimeSep 7th 2009
     
    ================================================================================
    THREE Part 1
    ================================================================================
    2009-08-26 13:01:05,629 INFO [Foxtrot Single Worker Thread #1] fe - Opening project D:\22-11.jpp
    2009-08-26 13:01:28,786 ERROR [Foxtrot Single Worker Thread #1] h2database - proj:jdbc[21] Uncaught Exception
    org.h2.message.InternalException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.convertToInternal(Message.java:298)
    at org.h2.value.ValueLob.getReader(ValueLob.java:627)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    2009-08-26 13:01:28,786 ERROR [AWT-EventQueue-0] Catch.all - Internal database error on [AWT-EventQueue-0]: An internal database error has occurred.
    The application needs to quit. Error details:

    org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    fk: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106] - query: SELECT * FROM query
    at cq.a(SourceFile:344)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.getSQLException(Message.java:103)
    at org.h2.message.Message.getSQLException(Message.java:114)
    at org.h2.message.Message.getSQLException(Message.java:77)
    at org.h2.engine.Database.openFile(Database.java:397)
    at org.h2.value.ValueLob.getInputStream(ValueLob.java:635)
    at org.h2.value.ValueLob.getReader(ValueLob.java:625)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    ... 16 more
    2009-08-26 13:01:33,787 INFO [br1] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    2009-08-26 13:01:33,802 INFO [br2] brx - Failed to report bug: The host did not accept the connection within timeout of 5000 ms
    aG: The host did not accept the connection within timeout of 5000 ms
    at hb.a(SourceFile:152)
    at hb.a(SourceFile:57)
    at cG.run(SourceFile:76)
    at java.lang.Thread.run(Unknown Source)
    • CommentAuthorNikolayB
    • CommentTimeSep 7th 2009
     
    ================================================================================
    THREE Part 2
    ================================================================================
    2009-08-26 13:06:32,327 INFO [AWT-EventQueue-0] aP - Starting version 1.0.4
    2009-08-26 13:06:42,546 ERROR [Foxtrot Single Worker Thread #1] h2database - proj:jdbc[21] Uncaught Exception
    org.h2.message.InternalException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.convertToInternal(Message.java:298)
    at org.h2.value.ValueLob.getReader(ValueLob.java:627)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    2009-08-26 13:06:42,546 ERROR [AWT-EventQueue-0] Catch.all - Internal database error on [AWT-EventQueue-0]: An internal database error has occurred.
    The application needs to quit. Error details:

    org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    l: F.a() failed - File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106] - query: SELECT * FROM query
    at ap.a(SourceFile:94)
    at ap.b(SourceFile:73)
    at dt.run(SourceFile:74)
    at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
    Caused by: fk: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106] - query: SELECT * FROM query
    at cq.a(SourceFile:344)
    at aA.a(SourceFile:373)
    at aA.a(SourceFile:364)
    at aA.a(SourceFile:288)
    at aA.a(SourceFile:301)
    at eI.d(SourceFile:90)
    at eI.a(SourceFile:80)
    at eI.c(SourceFile:63)
    at eI.a(SourceFile:100)
    at dT.a(SourceFile:224)
    at z.run(SourceFile:135)
    at foxtrot.AbstractWorkerThread$1.run(AbstractWorkerThread.java:40)
    at java.security.AccessController.doPrivileged(Native Method)
    at foxtrot.AbstractWorkerThread.runTask(AbstractWorkerThread.java:36)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:199)
    at foxtrot.workers.SingleWorkerThread.run(SingleWorkerThread.java:182)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.h2.jdbc.JdbcSQLException: File not found: C:\Program Files\Jet Profiler for MySQL\db\proj.lobs.db\1.lobs.db\258.t65.lob.db [90124-106]
    at org.h2.message.Message.getSQLException(Message.java:103)
    at org.h2.message.Message.getSQLException(Message.java:114)
    at org.h2.message.Message.getSQLException(Message.java:77)
    at org.h2.engine.Database.openFile(Database.java:397)
    at org.h2.value.ValueLob.getInputStream(ValueLob.java:635)
    at org.h2.value.ValueLob.getReader(ValueLob.java:625)
    at org.h2.value.ValueLob.getString(ValueLob.java:555)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)
    at be.a(SourceFile:18)
    at cv.a(SourceFile:305)
    at cu.a(SourceFile:267)
    at cq.a(SourceFile:342)
    ... 16 more
  7.  
    Thanks a lot for posting the stacktraces, Nikolay! I am pretty convinced this bug is caused by a bug in the underlying database engine h2. A recent bug fix from them reveal the following:

    "Recovery did not work if there were more than 255 lobs stored as files."

    Which seems to be just the case - Jet Profiler runs a recovery when projects are loaded, and the recovery fails when restoring query lob file #257.

    Anyway, we'll make sure to upgrade the internal h2 database version with the next JP release. In the meantime, I'm not sure there is anything you can do about it. Load and save will be unstable when dealing with lots of queries. I apologize for the inconvenience. If you are interested, I can enroll you in our beta testing programme which will get you the release a week earlier or so.
  8.  
    The latest release (1.0.7) has a new h2 engine which fixes the lob.db file problem above.

1 to 8 of 8

  1.