Hi, I have a relatively simple test case now where I also get the same problem. It looks it occurs with large databases (50 GB and more), as well as with small page size. I think it's relatively easy to fix.
Regards, Thomas On Tuesday, October 11, 2011, Lizard Lizard wrote: > I'm going to answer as many questions as I can, but I am not sure > about sending data, as it's proprietary. I'm honestly unsure if even > the field names, etc, might be considered private, and I'm waiting for > confirmation/approval from my boss. Would field names or data be in > the trace file? This all makes it sound much more exciting than it is, > trust me. We're not tracking terrorists. There's just a few thousand > data confidentiality hoops to jump through on one side and proprietary > model development hoops on the other, and I take my responsibilities > seriously when I work with data. I may be over-paranoid on this, but > I'd rather be paranoid than breach a trust. > > On Tue, Oct 11, 2011 at 2:08 AM, Thomas Mueller > <[email protected]> wrote: > > Hi, > > The import seems to be still running, but the database is busy managing > the > > cache (specially removing old entries from the cache). I have a few > > questions: > > - What version of H2 do you use? > 1.3.159 > > > - What is your database URL? > > jdbc:h2:file:K:\large files\variskDB; AUTO_SERVER=true > > > - Do you use any H2-specific system properties? > > I don't think so. > > > - Did you use any special settings? > > No. > > > - Is there a .trace.db file, and if yes could you post the contents? > > Would this contain any data elements? (Yes, there is a trace file, and > I'll be happy to send it if it doesn't contain anything which could > compromise the data.) > > > - How does the table definition and the data look like (could you post a > few > > example lines)? > > > - What statement(s) did you run exactly? > > The statement is generated dynamically from a data mapping performed > by the user within a java application. Leaving out the bulk of the > data until I get a confirm I can post it, the generated statement > looks like this: > > CREATE TABLE tablename (ACTIVITYDT VARCHAR(55),LOANID > VARCHAR(55),LOANNO VARCHAR(20),....ROW_ID IDENTITY )AS SELECT > coalesce(ACTIVITYDT,''),coalesce(LOANID,''),coalesce(LOANNO,''),..., > NULL from CSVREAD ('K:\Large Files\\inputfile.csv',NULL,NULL,char(9)) > > (It's much larger, of course, around 200-odd fields.) > > The "coalesce" is there because the user can specify a value to be > used for each field if it is null. > > > - What operating system, file system, and virtual machine > > (java -version) do you use? > > Window 7 64-bit, NTFS, 1.6.0.24 (64 bit) > > > - How did you start the Java process (java -Xmx... and so on)? > > java -Xms512m -Xmx4096m -cp VAriskH2c_v5.jar exec.FrontEndLauncher > > > - How big is the database (file sizes)? > > Currently, it is 241 GB. It was created when this process started and > contained only some automatically-created utility tables we use as > part of the program, none of which was of any meaningful size (either > 0 or 1 rows, all very small) > > > - How much heap memory does the Java process have? > > According to task manager, it has 540 MB of RAM, and is using 10% of > CPU. It's been at those levels for three days, roughly. > > I hope this helps. The process has been running since 10/7, and based > on initial performance, I expected it to take ~20 hours. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" 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/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en.
