monaasn wrote:

>
> ... today, the error still occur. The
> detail message is : 'General SQL error. Internal gds software
> consistency check (can't continue after bugcheck)'

That error never occurs without a prior serious error. Please check the
log and find the previous error message. With that, we may be able to
help. Let me translate that error into standard English:

General SQL error -> the SQL standard doesn't have an error code for
this problem.

Internal gds software consistency check -> this error was generated
inside the Firebird (formerly called gds) database engine and reflects a
possible inconsistent state of in-memory data structures that control
the operation of the database engine.

can't continue after bugcheck -> a previous fatal error has stopped all
processing. You asked for something after the fatal error, but the
engine has stopped all operations because it considers it's in-memory
data structures to be corrupt.

The only solution is to restart the server (in SuperServer) or abandon
the connection and reconnect (in classic).

Regards,


Ann