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.
