Not much we can do about a flakey NFS connection. Why exactly are you writing what looks like a temporary database to an NFS server? Why not save it on the local storage?
On Thu, Dec 8, 2011 at 05:00, 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. > -- 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.
