--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> Arda wrote:
> >
> > I've been using v1.5 and I've switched to FirebirdCS-2.0.3.12981 about
> > a month ago. When I try to create an index on a table and I'm getting
> > this error. I've never faced an error like this before when I was
> > using v1.5 or v1.0. Is this a bug or is this a feature?
>
> Feature. The only way to create a consistence index is to block the
> entire table from concurrent writes.
>
> > It'a bad habit but I'm continuous modifying and developing with the
> > same database which is also under production and I need to
> > create-modify indexes when the database file is online or I'll be
> > working at the night shift too.
>
> The easiest workaround would be to set transaction option for CREATE
> INDEX to WAIT instead of NO_WAIT.
>
>
> Dmitry

Thank you Dmitry, but when I set the transaction option to WAIT and
try, it never starts creating the index and waits for ever. There are
about 150 users on the site. Can this be because one of the clients
crashed when it was in the middle of a transaction?