General error: "java.lang.ClassCastException: org.h2.store.PageStreamData cannot be cast to org.h2.index.PageData" [50000-129]

[GoogleCodeExporter]

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. when I process with the table that contains many records,
2. I change the max rows select then some value of max rows view the
exception below :
3.An error occurred while performing the operation:
General error: "java.lang.ClassCastException: org.h2.store.PageStreamData
cannot be cast to org.h2.index.PageData" [50000-129]

The expected output is list all record.

I use the DbVisualizer tool.

I use Windows7. and the latest version of H2 DB.

Original issue reported on code.google.com by vietti...@gmail.com on 26 Feb 2010 at 1:40

[GoogleCodeExporter]

This looks like a serious problem. I have a few questions:

- Could you send the full stack trace of the exception including message text?
- What is your database URL?
- Did you use multiple connections?
- Do you use temporary tables?
- A workarounds is: use the tool org.h2.tools.Recover to create
    the SQL script file, and then re-create the database using this script.
    Does it work when you do this?
- With which version of H2 was this database created?
    You can find it out using:
    select * from information_schema.settings where name='CREATE_BUILD'
    or have a look in the SQL script created by the recover tool.
- Did the application run out of memory (once, or multiple times)?
- Do you use any settings or special features (for example cache settings,
    two phase commit, linked tables)?
- Do you use any H2-specific system properties?
- Is the application multi-threaded?
- What operating system, file system, and virtual machine
    (java -version) do you use?
- How did you start the Java process (java -Xmx... and so on)?
- Is it (or was it at some point) a networked file system?
- How big is the database (file sizes)?
- How much heap memory does the Java process have?
- Is the database usually closed normally, or is process terminated
    forcefully or the computer switched off?
- Is it possible to reproduce this problem using a fresh database
    (sometimes, or always)?
- Are there any other exceptions (maybe in the .trace.db file)?
    Could you send them please?
- Do you still have any .trace.db files, and if yes could you send them?
- Could you send the .h2.db file where this exception occurs?

Original comment by thomas.t...@gmail.com on 26 Feb 2010 at 8:38

[GoogleCodeExporter]

I'm setting the bug to 'works for me'. Please provide more information.

Original comment by thomas.t...@gmail.com on 21 Mar 2010 at 11:34

• Changed state: WorksForMe