thomas, doing lsof -u tomcat i find a list of open files like the one below for each workspace. i think that is expected for derby and is conform to what you explained. in addition tomcat has open files to the jars that are needed and i do not see any suspicious files so i will leave it for now like it is and check again later.
regards, ulf. java 3045 tomcat 576u REG 3,7 1048576 134580311 /srv/docker/workspaces/AWK314/db/log/log4.dat java 3045 tomcat 577uw REG 3,7 4 101034512 /srv/docker/workspaces/AWK314/db/dbex.lck java 3045 tomcat 578u REG 3,7 8192 152017578 /srv/docker/workspaces/AWK314/db/seg0/c10.dat java 3045 tomcat 579u REG 3,7 8192 152017597 /srv/docker/workspaces/AWK314/db/seg0/cc0.dat java 3045 tomcat 580u REG 3,7 8192 152017598 /srv/docker/workspaces/AWK314/db/seg0/cd1.dat java 3045 tomcat 581u REG 3,7 8192 152017590 /srv/docker/workspaces/AWK314/db/seg0/c60.dat java 3045 tomcat 582u REG 3,7 8192 152017591 /srv/docker/workspaces/AWK314/db/seg0/c71.dat java 3045 tomcat 583u REG 3,7 20480 152017593 /srv/docker/workspaces/AWK314/db/seg0/c90.dat java 3045 tomcat 584u REG 3,7 24576 152017594 /srv/docker/workspaces/AWK314/db/seg0/ca1.dat java 3045 tomcat 585u REG 3,7 28672 152017583 /srv/docker/workspaces/AWK314/db/seg0/c20.dat java 3045 tomcat 586u REG 3,7 8192 152017589 /srv/docker/workspaces/AWK314/db/seg0/c51.dat java 3045 tomcat 587u REG 3,7 245760 152017425 /srv/docker/workspaces/AWK314/db/seg0/c230.dat java 3045 tomcat 588u REG 3,7 24576 152017426 /srv/docker/workspaces/AWK314/db/seg0/c241.dat java 3045 tomcat 589u REG 3,7 16384 152017427 /srv/docker/workspaces/AWK314/db/seg0/c251.dat java 3045 tomcat 590u REG 3,7 8192 152017408 /srv/docker/workspaces/AWK314/db/seg0/c150.dat java 3045 tomcat 591u REG 3,7 8192 152017409 /srv/docker/workspaces/AWK314/db/seg0/c161.dat java 3045 tomcat 592u REG 3,7 8192 152017435 /srv/docker/workspaces/AWK314/db/seg0/c2d0.dat java 3045 tomcat 593u REG 3,7 8192 152017436 /srv/docker/workspaces/AWK314/db/seg0/c2e1.dat java 3045 tomcat 594u REG 3,7 8192 152017592 /srv/docker/workspaces/AWK314/db/seg0/c81.dat java 3045 tomcat 595u REG 3,7 8192 152017599 /srv/docker/workspaces/AWK314/db/seg0/ce1.dat java 3045 tomcat 596u REG 3,7 32768 152017414 /srv/docker/workspaces/AWK314/db/seg0/c180.dat java 3045 tomcat 597u REG 3,7 16384 152017415 /srv/docker/workspaces/AWK314/db/seg0/c191.dat java 3045 tomcat 598u REG 3,7 131072 152021397 /srv/docker/workspaces/AWK314/db/seg0/c400.dat java 3045 tomcat 599u REG 3,7 16384 152021398 /srv/docker/workspaces/AWK314/db/seg0/c411.dat java 3045 tomcat 600u REG 3,7 8192 152017382 /srv/docker/workspaces/AWK314/db/seg0/cf0.dat java 3045 tomcat 601u REG 3,7 8192 152017405 /srv/docker/workspaces/AWK314/db/seg0/c121.dat java 3045 tomcat 602u REG 3,7 8192 152017406 /srv/docker/workspaces/AWK314/db/seg0/c130.dat java 3045 tomcat 603u REG 3,7 8192 152017407 /srv/docker/workspaces/AWK314/db/seg0/c141.dat java 3045 tomcat 604r REG 3,7 133707 168906123 /srv/docker/workspaces/AWK314/index/_5q/_0.cfs java 3045 tomcat 605r REG 3,7 133707 168906123 /srv/docker/workspaces/AWK314/index/_5q/_0.cfs -- ulf schneider +49 163 2505164 mail: [email protected] blog: http://allesagil.net datenlabor gmbh sitz: paderborn, hrb 8819 geschäftsführer: ulf schneider http://datenlabor.net Am 28.11.2011 um 15:25 schrieb Thomas Mueller: > Hi, > >> and as far as i can see the failure is gone. > > Depending on what the problem is, that might only be a temporary solution. > I really would try to find out what the problem is, using "lsof -p <pid>". > To get the pid, use "jps -l". > >> @thomas: you suggested to use H2. would it be possible to replace derby >> with H2 but reuse the file structure that has already been created by >> derby? > > H2 only needs one file per database (plus one temporary file to lock the > database file, plus possibly a log file). Derby uses many files per > database (one per table or index, plus a few for the transaction log, and > so on). So: no. You need to create a new database / new databases. > > Regards, > Thomas >
