--- In firebird-support@yahoogroups.com, "Sean" <firebird_tmc@...> wrote:

>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@> wrote:
> >
> > At 03:08 AM 10/01/2007, you wrote:
> > >Hi, I meet this problem occasionally while I have no clue why this is
> > >happening and it bothers me:
> > >
> > >Copy a new firebird DB and start the application to connect to the DB
> > >in embedded embedded mode, sometimes it gives an error of "i/o

error".

> > >If I run the application again, it works fine since then. Seems
> > >something was rectified after 1st failure.
> > >
> > >Not sure if it is caused by the way I created the database. Here are
> > >the steps:
> > >1. generate SQL from my development DB.
> > >2. Run SQL to generate an empty database
> > >3. Open the empty database in IBExpert in superserver mode, run
> > >another sql to create some pre-defined records, the close the DB
> > >connection.
> > >
> > >Unfortunately I cannot duplicate the problem. For one same

database it

> > >may have problem on one computer, but works fine on another one...
> > >
> > >Does anyone have a clue?
> >
> > It's probably due to not explicitly committing the script's work in
> > IBExpert. Check how you have it configured with regard to committing
> > transactions.
> >
> > ./heLen
> >
>
> After running the script, Script Executive asks "There are uncommited
> statements. Commit them?". I always answer yes. Then I disconnect
> from the database and copy the database file out.
>
> I notice that after I disconnect from database, the fbserver.exe still
> hold a handle to the database file. If I copy the db file with the
> handle open, is that a problem?

Potentially yes.

Superserver has a garbage collection thread, so just because *YOU* are
not doing anything with the file does not mean that the database
engine isn't doing stuff.

I do not know IBExpert so I can not comment on the correct way to do
this, but if you can not rename the database file then it is
potentially not safe to copy it.

Adam