Hi Viji, The NFS FAQ: http://www.sunhelp.org/faq/nfs.html 4.7 Indicates that it is a mis-configured NFS Daemon (that is the server serving the nfs mount point).
I would question why a nfs mount is used for temporary files, this would be a huge performance bottleneck and also can cause the process to lock (i.e. nfs hard mount and network packet loss). Donal. On Dec 8, 3:00 am, 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.
