Hi, Thanks a lot for all of your valuable suggestion. We are using local storage for storing the database files. Finally, we understand that we are using so many threads, to update the database. We reduce the number of threads. The problems seems to be solved now.
But our setup will scale soon to much larger degree. We are really keeping our fingers crossed. We will definitely try your suggestions later. Thanks. Viji On Dec 8, 5:03 am, andreis <[email protected]> wrote: > You can try fixing the library yourself. In method > {{Database.createTempFile()}} change from "boolean inTempDir = > readOnly" to "boolean inTempDir = true". It will use "java.io.tmpdir" > for temporary files. (But, of cource, I would prefer introducing some > h2 parameter for that). > Second, you can try reconfiguring your h2 instance to avoid buffering. > Look at "SET > MAX_MEMORY_ROWS"http://www.h2database.com/html/grammar.html#set_max_memory_rows. > Also, look at "SET MAX_MEMORY_UNDO", "SET MAX_OPERATION_MEMORY". > Third, you can try optimizing your queries to reduce number of rows in > a result set. > > On Dec 7, 10:00 pm, Viji <[email protected]> wrote: > > > > > > > > > Hi Noel, > > We are in great pressure in one of the projects we are bumping into > > this error. Otherwise, we really like H2. Can you please suggest us > > some solution. It is kind of URGENT. > > > Thanks a lot. > > Viji > > > On Dec 7, 6:01 am, Noel Grandin <[email protected]> wrote: > > > > That sounds like a reasonable suggestion to me. > > > (not that I'm volunteering to implement it, little busy on another > > > open-source project right now). > > > > andreis wrote: > > > > I've got that exception a couple of times. It was not related to H2. > > > > We were not able to find the reason and the solution. We decided it's > > > > related to high load on NFS. > > > > And here is my question: Thomas, what is the purpose to keep temporary > > > > files next to the DB file? It creates unnecesary presure on a network > > > > if the DB is placed on NFS volume (or ZFS on SAN). I'm talking about > > > > the current implementation of Database.createTempFile(). A parameter > > > > to set a directory for tmp files would reduce remote IO on big inserts/ > > > > updates/selects. > > > > > On Dec 4, 4:16 pm, Viji <[email protected]> wrote: > > > >> Hi Andreis, > > > >> Yes. The home directory is NFS mounted and it has lot of disk space > > > >> too. > > > >> Thanks. > > > >> Viji > > > > >> On Dec 1, 11:43 pm, andreis <[email protected]> wrote: > > > > >>>> Is it related to IO on the local machine. "What is meant is Bad > > > >>>> file> number". > > > >>>http://docs.oracle.com/cd/E19455-01/806-1075/msgs-1050/index.html > > > >>> "Either a file descriptor refers to no open file, > > > >>> or a read(2)--or a write(2)--request is made to a file that is open > > > >>> only for writing or reading." > > > >>> I think the problem is in your environment. Is the home directory > > > >>> mounted via NFS? -- 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.
