Subject | Re: Restore problems with grants |
---|---|
Author | hfsnell |
Post date | 2008-09-14T13:04:50Z |
I have got the same problem
Old server version: 1.5.5
I backed up successfully
New server version:2.1.1
I restored and failed with the following messages:
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
Database restore cancelled 19:41:07 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements
Engine Code : 335544342
Engine Message :
action cancelled by trigger (0) to preserve data integrity
could not find table/procedure for GRANT
Plz give me some hints
Thank in advance!
Phuoc
--- In firebird-support@yahoogroups.com, Bjoern Reimer
<bjoern.reimer@...> wrote:
Old server version: 1.5.5
I backed up successfully
New server version:2.1.1
I restored and failed with the following messages:
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
Database restore cancelled 19:41:07 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements
Engine Code : 335544342
Engine Message :
action cancelled by trigger (0) to preserve data integrity
could not find table/procedure for GRANT
Plz give me some hints
Thank in advance!
Phuoc
--- In firebird-support@yahoogroups.com, Bjoern Reimer
<bjoern.reimer@...> wrote:
>integrity
> Hi,
>
> had a similar or the same problem with another database:
>
> gbak: restoring privilege for user SYSDBA
>
> gbak: restoring privilege for user SYSDBA
>
> gbak: restoring privilege for user SYSDBA
>
> gbak: ERROR: action cancelled by trigger (0) to preserve data
>But
> gbak: ERROR: could not find table/procedure for GRANT
>
> gbak: Exiting before completion due to errors
>
>
> What's the cause?
>
> I think I've done a wrong grant on one of the system tables.
> which?
>
>
>
>