Issue Details (XML | Word | Printable)

Key: CORE-3726
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Unassigned
Reporter: Zeki Gürsoy
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Create User Returning an error, GSEC too.

Created: 12/Jan/12 01:13 AM   Updated: 12/Jan/12 10:42 AM
Component/s: GSEC
Affects Version/s: 2.5.1
Fix Version/s: None

Environment: Win XP Pro x32, Manager Interface is FlameRobin


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 12/Jan/12 08:57 AM
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.