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 <neelima...@gmail.com>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 h2-da...@googlegroups.com. >> > 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
