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.
