AFAIK you are limiting the memory your VM will ever know about to 4g with this:
JAVA_OPTS=-Xms512m -Xmx4076m therefore this Mem: 8174516k total, 3465712k used, 4708804k free, does not mean that the VM could use the 4708804k you still have free. In the eyes of the VM, you're out of memory: On Wed, May 1, 2013 at 11:53 AM, neelima kaliki <[email protected]>wrote: > Thanks for your reply. > > Below are the memory details of the linux box when the query is executing. > > > Cpu(s): 25.0%us, 0.2%sy, 0.0%ni, 74.7%id, 0.0%wa, 0.0%hi, 0.1%si, > 0.0%st > Mem: 8174516k total, 3465712k used, 4708804k free, 148888k buffers > Swap: 0k total, 0k used, 0k free, 1096344k cached > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 3478 kn40169 17 0 2409m 1.6g 9808 S 100.9 20.0 19:40.60 java > > JVM parameters for the H2 is as below: > > JAVA_OPTS=-Xms512m -Xmx4076m > > I could not see any exceptions in the logs. There is almost 4GB free > memory available in that box as well. Please guide me further. > > Thanks, > > Neelima.Kaliki > > > On Wednesday, May 1, 2013 10:57:50 AM UTC-4, Kartweel wrote: > >> Sounds like you are running out of memory. >> >> What is the memory usage of the java process? and what JVM parameters >> are you using? >> >> You'd expect CPU to be maxed out for an in-memory database. Something >> would have to max out. >> >> >> On 1/05/2013 9:40 PM, neelima kaliki wrote: >> > Below are my System details: >> > OS: Linux >> > Processors : 4 >> > Memory: 8 GB >> > Below are my Application details: >> > Tables: In-Memory tables >> > Mode: Server/Embedded mode >> > Data: Arround 10 Million records >> > CPU utiliztion is more than 100% when a query is executing on huge >> > records and the system just hangs on. After couple of hours, getting >> > message as Database is closed and all my tables in Memory is getting >> > dropped off. This keeps repeating every time. The problem is same in >> > Server mode or Embedded mode. >> > Response is normal for less number records in the memory tables. >> > Please suggest to solve this issue. >> > Thanks, >> > Neelima.Kaliki >> > -- >> > You received this message because you are subscribed to the Google >> > Groups "H2 Database" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an email to h2-database...@**googlegroups.com. >> > To post to this group, send email to [email protected]. >> > Visit this group at >> > http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>. >> >> > For more options, visit >> > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>. >> >> > >> > >> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
