Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5098

embedded/in-memory: SQLNonTransientConnectionException: No current connection due to invalid page format


    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s:,,
    • Fix Version/s:,,,
    • Component/s: Store
    • Labels:
    • Environment:
      OS: windows 2008 R2 x64, AIX 7.1, possibly other
      JVM: SUN/Oracle 1.6.0_24 server x64, IBM J9 Java5 vm2.3.sr12.j9vmap6423-20100630, possibly others
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:



      In my case I am inserting many many rows in a in memory derby DB. After a while (a few minutes) I get a "SQLNonTransientConnectionException: No current connection" and the derby.log (see attachment) contains a complaint about an invalid page format with a dump of the page in question (which is completely zeros). The derby.log also contains another entry before the error (usually the same time stamp as the error): Cleanup action starting
      Maybe this is related to the error.
      Please find attached a test case to reproduce the issue. Just give it enough memory (-Xmx4g). It will insert a lot of rows to an in-memory derby DB with several threads over several connections. In case you want to run only one thread with one connection you might want to set these properties:
      -DuseSingleConnectionOnly=true -DuseSynchronousCommit=true -DnumberOfAsyncThreadsPerGenerator=1 -DnumberOfGeneratorThreads=1 -DnubmerOfRowsPerThread=100000000

      Thank you very much


        1. DerbyRepro5098.java
          8 kB
          Christian Deutsch
        2. derby.
          40 kB
          Christian Deutsch
        3. derby.
          120 kB
          Christian Deutsch
        4. derby.
          21 kB
          Christian Deutsch
        5. derby.
          60 kB
          Christian Deutsch
        6. derby.
          81 kB
          Christian Deutsch
        7. derby-5098-1a-overflow_fixes.diff
          2 kB
          Kristian Waagan
        8. derby-5098-1a-overflow_fixes.stat
          0.3 kB
          Kristian Waagan
        9. derby-5098-2a-remove_redundant_checks.diff
          1 kB
          Kristian Waagan



            • Assignee:
              kristwaa Kristian Waagan
              chrissid Christian Deutsch
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: