On 2011.12.09 1:46 PM, call.assist wrote:

>
> Firebird v2.1.3 classic on Linux
>
> We have a table with a column on it, which when we run a simple sql to
> insert a new row with data in that column it doesnt populate the column
> (simple varchar(50) )
>
> it works for all other columns in the table, and works for updates
>
> if i do a backup/restore to a new database it works again and i can
> update the column, but as we are a 24/7 company id rather not take the
> DB down if possible.
>
> Anyone any ideas why this has happened and another suggestion to fix?
>
> Cheers
> Andrew
>

I would check the transactions , if you do something with that.
Take a look to monitoring tables to see what happening in your database.


Regards,

--

Mercea Paul
Administrator




[Non-text portions of this message have been removed]