Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

2.1 beta 2 can't restore DB with rights granted to non-ascii users [CORE1585] #2005

Open
firebird-automations opened this issue Nov 10, 2007 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Nikolay Ponomarenko (pnv82)

On 2.0 i've an database, where was several grants for users, which names was in win1251 letters, but gnat's was given in "none" collation connect.

2.0 restores this db without errors, but when i try to restore it's backup under 2.1 - got error:
gbak: restoring privilege for user SYS$GROUP_ADD
gbak: restoring privilege for user ?????
gbak: ERROR:arithmetic exception, numeric overflow, or string truncation
gbak: ERROR: Cannot transliterate character between character sets
gbak: ERROR: At trigger 'RDB$TRIGGER_9'
gbak:Exiting before completion due to errors

How can such databases can be restored on 2.1(except of deleting rows from user_priveleges)?

@firebird-automations
Copy link
Collaborator Author

Commented by: Nikolay Ponomarenko (pnv82)

if gant is given in 2.1 - all work's fine

@firebird-automations
Copy link
Collaborator Author

Modified by: Nikolay Ponomarenko (pnv82)

description: On 2.0 i've an database, where was several grants for users, which names was in win1251 letters.
2.0 restores this db without errors, but when i try to restore it's backup under 2.1 - got error:
gbak: restoring privilege for user SYS$GROUP_ADD
gbak: restoring privilege for user ?????
gbak: ERROR:arithmetic exception, numeric overflow, or string truncation
gbak: ERROR: Cannot transliterate character between character sets
gbak: ERROR: At trigger 'RDB$TRIGGER_9'
gbak:Exiting before completion due to errors

is it problem of 2.0, which can't store unicode_fss correct or bug of 2.1?
How can such databases can be restored on 2.1(except of deleting rows from user_priveleges)?

=>

On 2.0 i've an database, where was several grants for users, which names was in win1251 letters, but gnat's was given in "none" collation connect.

2.0 restores this db without errors, but when i try to restore it's backup under 2.1 - got error:
gbak: restoring privilege for user SYS$GROUP_ADD
gbak: restoring privilege for user ?????
gbak: ERROR:arithmetic exception, numeric overflow, or string truncation
gbak: ERROR: Cannot transliterate character between character sets
gbak: ERROR: At trigger 'RDB$TRIGGER_9'
gbak:Exiting before completion due to errors

How can such databases can be restored on 2.1(except of deleting rows from user_priveleges)?

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 13400 ] => Firebird [ 14023 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant