Hi, Did you check if transactions are closed? This could be a reason why the database grows more than expected. The connection pool 1000 is huge, this should be reduced for sure. I never worked with so many connections and so i don't know if this could be a reason for that exception. Check that the server is running in SS not as CS mode. After you reduce connection pool you can switch back to CS but this is another story. Regards., ...michal
Sean napisaĆ(a): > Hi there, > > I have a server which is heavily loaded 7x24. Sometimes it can be a hundred > threads (trying) writing into the database. After running the server for > 3~4 days, the database grows to 800MB or so, then I got exceptions of > "FirebirdSql.Data.FirebirdClient.FbException: I/O error for file CreateFile > (open) "tmcdb.fdb" Error while trying to open file" for all following DB > operations. By examining the database I found a checksum error. > > My feeling is that the big amount of connection may cause database > corruption. I wildly set the connection pool size to 1000, basically pool > all connections. > > My question is, shall I reduce the connection pool size to limit the amount > of simultaneous transactions? what size shall I use, 20, 50, 100, etc? > > Thanks a lot! > Sean > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider