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

Create User Returning an error, GSEC too. [CORE3726] #4073

Closed
firebird-automations opened this issue Jan 12, 2012 · 3 comments
Closed

Create User Returning an error, GSEC too. [CORE3726] #4073

firebird-automations opened this issue Jan 12, 2012 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Zeki Gürsoy (zeki)

Hello,

When I execute & commit create user statement, return an error in flamerobin statistics.

"CREATE USER test PASSWORD '123' GRANT ADMIN ROLE;"

If restart my computer executed succusfull.
but, run tool GSEC -display and after execute create user statement return error again.

Original message is:
*** IBPP::SQLException ***
Context: Transaction::Commit

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Engine Code : 336723987
Engine Message :
add record error
I/O error during "ReadFile" operation for file "C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\SECURITY2.FDB"
Error while trying to read from file
Bellek konumuna geçersiz erişim.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

fbs2 bin #⁠ ./isql employee
Database: employee
SQL> CREATE USER test PASSWORD '123' GRANT ADMIN ROLE;
SQL>
fbs2 bin #⁠ ./gsec -di
user name uid gid admin full name
------------------------------------------------------------------------------------------------
SYSDBA 0 0 Sql Server Administrator
MAN1 0 0
QQ 0 0
NEWUSER 0 0 admin
ZZ 0 0
SUPER 0 0 admin
MORE 0 0
6524783264278364 0 0
BLANKPASS 0 0
TEST 0 0 admin

I.e everything works as expected.
When you receive <I/O error during "ReadFile" operation> message, you should check your HDD or other HW, not add tickets to the tracker.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

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