>>> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>>> gbak: ERROR: table/procedure has non-SQL security class defined
>>> gbak:Exiting before completion due to errors
>>>
>>> What does the error signify?
28.01.2013 15:25, Alex Peshkoff wrote:
>> Probably a bug. Can it be reproduced with metadata-only backup? If yes,
>> can we take a look at that .gbak?
Yes, in fact I am working with a metadata-only backup of a customer's database.
If you would still like to look at it, I can ask permission.
I'm not asking about this to solve a support problem, though. It's just that
we don't seem to have any documentation of this change in Userland and I think
we need to.
At 01:07 a.m. 29/01/2013, Dmitry Yemanov wrote:
>AFAIR, this is a known issue. ODS 11.2 databases cannot be restored on
>older FB versions because it has other conventions to name security
>classes (SQL$number instead of SQL$tablename, this was done to fix the
>old security issue with longer than 27 chars metadata names) and these
>new names, after being backed up successfully, are not accepted by older
>FB versions due to their system triggers expecting the name in the old
>format (SQL$tablename).
>
>I don't know about any solution other than migrating via a script.
So far, it seems that the backward-restore of the database (at least
metadata-only) succeeds and only restoration of privileges starts to fail once
it reaches the user objects. Is there a strong possibility that this would be
consistent, provided other 2.5-only features have not been used?
A related issue: This particular database has a very large amount of metadata
and the extract script was rejected by isql -input as being too large for its
buffer. Do we know what the limit on isql's buffer size is?
I note that the RDB$ADMIN role is not restored in the downgraded database. The
database does not use roles, so I don't know whether a) this means we didn't
far enough through the restore to start restoring roles or b) ODS 11.2 roles
are affected by the other security class changes and thus could not be
back-restored at all. Could you comment on that?
Thanks,
Helen
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
