Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
    MSG                             Point-1
    WHO_AM_I                        SYSDBA
    WHO_WAS_GRANTED                 TMP$C5248_USR1
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    2
    MSG                             Point-1
    WHO_AM_I                        SYSDBA
    WHO_WAS_GRANTED                 TMP$C5248_USR2
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      TMP$C5248_USR1
    GRANT_OPTION                    0
    Records affected: 2
    MSG                             Point-2
    WHO_AM_I                        SYSDBA
    WHO_WAS_GRANTED                 TMP$C5248_USR2
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      TMP$C5248_USR1
    GRANT_OPTION                    0
    Records affected: 1
    MSG                             Point-3
    WHO_AM_I                        TMP$C5248_USR0
    WHO_WAS_GRANTED                 TMP$C5248_USR3
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    0
    Records affected: 1
    Records affected: 0
    MSG                             Point-5
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR1
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    2
    MSG                             Point-5
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR3
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    0
    Records affected: 2
    MSG                             Point-6
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR1
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    2
    Records affected: 1
    Statement failed, SQLSTATE = 28000
    unsuccessful metadata update
    -DROP ROLE TMP_ROLE1 failed
  - -no permission for DROP access to ROLE TMP_ROLE1
  + -no permission for DROP access to ROLE "TMP_ROLE1"
    COUNT                           1
    MSG                             Point-6
    WHO_AM_I                        TMP$C5248_USR0
    WHO_WAS_GRANTED                 TMP$C5248_USR1
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    2
    MSG                             Point-6
    WHO_AM_I                        TMP$C5248_USR0
    WHO_WAS_GRANTED                 TMP$C5248_USR3
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    0
    MSG                             Point-6
    WHO_AM_I                        TMP$C5248_USR0
    WHO_WAS_GRANTED                 TMP$C5248_USR2
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      TMP$C5248_USR1
    GRANT_OPTION                    0
    Records affected: 3
    MSG                             Point-7
    RDB$ROLE_NAME                   <null>
    RDB$OWNER_NAME                  <null>
    RDB$DESCRIPTION                 <null>
    RDB$SYSTEM_FLAG                 <null>
    RDB$SECURITY_CLASS              <null>
    RDB$SYSTEM_PRIVILEGES           <null>
    Records affected: 1
    MSG                             Point-8
    WHO_AM_I                        <null>
    WHO_WAS_GRANTED                 <null>
    PRIVILEGE_TYPE                  <null>
    ROLE_NAME                       <null>
    ROLE_OWNER                      <null>
    GRANTED_BY                      <null>
    GRANT_OPTION                    <null>
    Records affected: 1
    MSG                             Point-9
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR1
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    2
    MSG                             Point-9
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR3
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      SYSDBA
    GRANT_OPTION                    0
    MSG                             Point-9
    WHO_AM_I                        TMP$C5248_USR1
    WHO_WAS_GRANTED                 TMP$C5248_USR2
    PRIVILEGE_TYPE                  M
    ROLE_NAME                       TMP_ROLE1
    ROLE_OWNER                      TMP$C5248_USR0
    GRANTED_BY                      TMP$C5248_USR1
    GRANT_OPTION                    0
    Records affected: 3
    MSG                             Point-10
    RDB$ROLE_NAME                   <null>
    RDB$OWNER_NAME                  <null>
    RDB$DESCRIPTION                 <null>
    RDB$SYSTEM_FLAG                 <null>
    RDB$SECURITY_CLASS              <null>
    RDB$SYSTEM_PRIVILEGES           <null>
    Records affected: 1
    MSG                             Point-11
    WHO_AM_I                        <null>
    WHO_WAS_GRANTED                 <null>
    PRIVILEGE_TYPE                  <null>
    ROLE_NAME                       <null>
    ROLE_OWNER                      <null>
    GRANTED_BY                      <null>
    GRANT_OPTION                    <null>
    Records affected: 1

LOG DETAILS:

2025-06-29 06:35:42.238
2025-06-29 06:35:42.238 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 06:35:42.238 tmp_usr0 = <firebird.qa.plugin.User object at [hex]>
2025-06-29 06:35:42.238 tmp_usr1 = <firebird.qa.plugin.User object at [hex]>
2025-06-29 06:35:42.239 tmp_usr2 = <firebird.qa.plugin.User object at [hex]>
2025-06-29 06:35:42.239 tmp_usr3 = <firebird.qa.plugin.User object at [hex]>
2025-06-29 06:35:42.239 tmp_usr4 = <firebird.qa.plugin.User object at [hex]>
2025-06-29 06:35:42.239 tmp_role = <firebird.qa.plugin.Role object at [hex]>
2025-06-29 06:35:42.239
2025-06-29 06:35:42.239     @pytest.mark.version('>=4.0')
2025-06-29 06:35:42.239     def test_2(act: Action, tmp_usr0: User, tmp_usr1: User, tmp_usr2: User, tmp_usr3: User, tmp_usr4: User, tmp_role: Role):
2025-06-29 06:35:42.239
2025-06-29 06:35:42.239         test_sql = f"""
2025-06-29 06:35:42.239             set list on;
2025-06-29 06:35:42.239             set count on;
2025-06-29 06:35:42.239             -- #############
2025-06-29 06:35:42.239             set autoddl OFF;
2025-06-29 06:35:42.239             -- #############
2025-06-29 06:35:42.239             connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
2025-06-29 06:35:42.239
2025-06-29 06:35:42.239             recreate view v_grants as
2025-06-29 06:35:42.239             select
2025-06-29 06:35:42.239                  current_user                    as who_am_i
2025-06-29 06:35:42.239                 ,p.RDB$USER                      as who_was_granted
2025-06-29 06:35:42.240                 ,p.RDB$PRIVILEGE                 as privilege_type
2025-06-29 06:35:42.240                 ,p.RDB$RELATION_NAME             as role_name
2025-06-29 06:35:42.240                 ,r.RDB$OWNER_NAME                as role_owner
2025-06-29 06:35:42.240                 ,p.RDB$GRANTOR                   as granted_by
2025-06-29 06:35:42.240                 ,p.RDB$GRANT_OPTION              as grant_option
2025-06-29 06:35:42.240             from rdb$user_privileges p
2025-06-29 06:35:42.240             left join rdb$roles r on p.rdb$relation_name = r.rdb$role_name
2025-06-29 06:35:42.240             where p.rdb$object_type=13
2025-06-29 06:35:42.240             ;
2025-06-29 06:35:42.240             commit;
2025-06-29 06:35:42.240             grant select on v_grants to public;
2025-06-29 06:35:42.240             commit;
2025-06-29 06:35:42.240
2025-06-29 06:35:42.240             grant create role to user {tmp_usr0.name};
2025-06-29 06:35:42.240             commit;
2025-06-29 06:35:42.240
2025-06-29 06:35:42.240             connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
2025-06-29 06:35:42.240             create role {tmp_role.name}; -- {tmp_usr0.name} is owner of role {tmp_role.name}
2025-06-29 06:35:42.240             commit;
2025-06-29 06:35:42.240
2025-06-29 06:35:42.240             connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
2025-06-29 06:35:42.241             grant {tmp_role.name} to {tmp_usr1.name} with admin option;
2025-06-29 06:35:42.241             grant {tmp_role.name} to {tmp_usr3.name};
2025-06-29 06:35:42.241             commit;
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
2025-06-29 06:35:42.241             grant {tmp_role.name} to {tmp_usr2.name}; ----------------------- {tmp_usr1.name} grants role to {tmp_usr2.name}
2025-06-29 06:35:42.241             commit;
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             -- 1. revoke - avoid cascade grants delete
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             select 'Point-1' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr2.name}') );  -- must contain 2 records
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             revoke {tmp_role.name} from {tmp_usr1.name}; -- Q: whether grant on role '{tmp_role.name}' remains to user '{tmp_usr2.name}' after revoking from '{tmp_usr1.name}' ?
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             select 'Point-2' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr2.name}') );  -- must contain 1 record for {tmp_usr2.name}
2025-06-29 06:35:42.241
2025-06-29 06:35:42.241             -- return grant to {tmp_usr1.name} because it was revoked just now:
2025-06-29 06:35:42.242             rollback;
2025-06-29 06:35:42.242
2025-06-29 06:35:42.242             /***********************************************
2025-06-29 06:35:42.242             ############################################
2025-06-29 06:35:42.242             DISABLED 08.03.2025, after GH-8462 was fixed
2025-06-29 06:35:42.242             ############################################
2025-06-29 06:35:42.242             -- 2. revoke: user who has 'admin option' can revoke role from anyone EXCEPT himself
2025-06-29 06:35:42.242             connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
2025-06-29 06:35:42.242
2025-06-29 06:35:42.242             -- Following REVOKE should fail with:
2025-06-29 06:35:42.242             -- Statement failed, SQLSTATE = 42000
2025-06-29 06:35:42.242             -- unsuccessful metadata update
2025-06-29 06:35:42.242             -- -REVOKE failed
2025-06-29 06:35:42.242             -- -{tmp_usr1.name} is not grantor of Role on {tmp_role.name} to {tmp_usr1.name}.
2025-06-29 06:35:42.242             revoke {tmp_role.name} from {tmp_usr1.name};
2025-06-29 06:35:42.242
2025-06-29 06:35:42.242             select * from v_grants where upper(who_was_granted) = upper('{tmp_usr1.name}'); -- record should remain
2025-06-29 06:35:42.242             rollback;
2025-06-29 06:35:42.242             ***********************************************/
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             -- 3. revoke - check role owner rights
2025-06-29 06:35:42.243             connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             select 'Point-3' as msg, v.* from v_grants v where upper(v.who_was_granted) = upper('{tmp_usr3.name}');
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             -- current user = {tmp_usr0.name} - is owner of role {tmp_role.name}, but this role was granted to {tmp_usr3.name} by SYSDBA.
2025-06-29 06:35:42.243             -- Q: should user '{tmp_usr0.password}' (current) be able to revoke role which he did NOT grant but owns ?
2025-06-29 06:35:42.243             -- A: yes.
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             revoke {tmp_role.name} from {tmp_usr3.name};  -- NO error/warning should be here
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             select 'Point-4' as msg, v.* from v_grants v where upper(v.who_was_granted) = upper('{tmp_usr3.name}'); -- record should NOT appear.
2025-06-29 06:35:42.243             rollback;
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             -- 4. revoke - check admin option
2025-06-29 06:35:42.243             connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
2025-06-29 06:35:42.243
2025-06-29 06:35:42.243             select 'Point-5' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr3.name}') ); -- two records should be here
2025-06-29 06:35:42.243
2025-06-29 06:35:42.244             -- current user = {tmp_usr1.name} - is NOT owner of role {tmp_role.name} but he was granted to use it WITH ADMIN option
2025-06-29 06:35:42.244             -- (grant {tmp_role.name} to {tmp_usr1.name} with admin option).
2025-06-29 06:35:42.244             -- Q: should user '{tmp_usr1.name}' (current) be able to revoke role which he neither did grant nor owns but has admin option ?
2025-06-29 06:35:42.244             -- A: yes.
2025-06-29 06:35:42.244
2025-06-29 06:35:42.244             revoke {tmp_role.name} from {tmp_usr3.name};
2025-06-29 06:35:42.244
2025-06-29 06:35:42.244             select 'Point-6' as msg, v.* from v_grants v where upper(v.who_was_granted) in (upper('{tmp_usr1.name}'), upper('{tmp_usr3.name}')); -- only one record should be here
2025-06-29 06:35:42.244             rollback;
2025-06-29 06:35:42.244
2025-06-29 06:35:42.244             -- 5a. drop role - should fail
2025-06-29 06:35:42.244             connect '{act.db.dsn}' user {tmp_usr4.name} password '{tmp_usr4.password}';
2025-06-29 06:35:42.244
2025-06-29 06:35:42.244             -- Statement failed, SQLSTATE = 28000
2025-06-29 06:35:42.244             -- unsuccessful metadata update
2025-06-29 06:35:42.244             -- -DROP ROLE {tmp_role.name} failed
2025-06-29 06:35:42.244             -- -no permission for DROP access to ROLE {tmp_role.name}
2025-06-29 06:35:42.244
2025-06-29 06:35:42.244             drop role {tmp_role.name}; -- should fail: this user is not owner of this role and he was not granted to use it with admin option
2025-06-29 06:35:42.244
2025-06-29 06:35:42.245             set count off;
2025-06-29 06:35:42.245             select count(*) from rdb$roles where rdb$role_name = '{tmp_role.name}';
2025-06-29 06:35:42.245             set count on;
2025-06-29 06:35:42.245             rollback;
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             select 'Point-6' as msg, v.* from v_grants v where upper(v.role_name) = upper('{tmp_role.name}'); -- should output 3 records
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             drop role {tmp_role.name}; -- current user: '{tmp_usr0.name}' - is owner of role {tmp_role.name}
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             select 'Point-7' as msg, r.* from rdb$database d left join rdb$roles r on upper(r.rdb$role_name) = upper('{tmp_role.name}'); -- should output NULLs
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             select 'Point-8' as msg, v.* from rdb$database d left join v_grants v on upper(v.role_name) = upper('{tmp_role.name}'); -- should output NULLs
2025-06-29 06:35:42.245             rollback;
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             -- 6. drop role - check admin option
2025-06-29 06:35:42.245             connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
2025-06-29 06:35:42.245
2025-06-29 06:35:42.245             -- current user: '{tmp_usr1.name}' - HAS grant on role {tmp_role.name} with admin option (but he is NOT owner of this role).
2025-06-29 06:35:42.245
2025-06-29 06:35:42.246             select 'Point-9' as msg, v.* from v_grants v where upper(v.role_name) = upper('{tmp_role.name}'); -- should output 3 records
2025-06-29 06:35:42.246
2025-06-29 06:35:42.246             drop role {tmp_role.name}; -- current user: '{tmp_usr0.name}' - is owner of role {tmp_role.name}
2025-06-29 06:35:42.246
2025-06-29 06:35:42.246             select 'Point-10' as msg, r.* from rdb$database d left join rdb$roles r on upper(r.rdb$role_name) = upper('{tmp_role.name}'); -- should output NULLs
2025-06-29 06:35:42.246             select 'Point-11' as msg, v.* from rdb$database d left join v_grants v on upper(role_name) = upper('{tmp_role.name}');      -- should output NULLs
2025-06-29 06:35:42.246             rollback;
2025-06-29 06:35:42.246         """
2025-06-29 06:35:42.246
2025-06-29 06:35:42.246
2025-06-29 06:35:42.246         act.expected_stdout = """
2025-06-29 06:35:42.246             MSG                             Point-1
2025-06-29 06:35:42.246             WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.246             WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.246             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.246             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.246             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.246             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.246             GRANT_OPTION                    2
2025-06-29 06:35:42.246             MSG                             Point-1
2025-06-29 06:35:42.247             WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.247             WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.247             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.247             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.247             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.247             GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.247             GRANT_OPTION                    0
2025-06-29 06:35:42.247             Records affected: 2
2025-06-29 06:35:42.247             MSG                             Point-2
2025-06-29 06:35:42.247             WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.247             WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.247             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.247             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.247             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.247             GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.247             GRANT_OPTION                    0
2025-06-29 06:35:42.247             Records affected: 1
2025-06-29 06:35:42.247             MSG                             Point-3
2025-06-29 06:35:42.247             WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.247             WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.248             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.248             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.248             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.248             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.248             GRANT_OPTION                    0
2025-06-29 06:35:42.248             Records affected: 1
2025-06-29 06:35:42.248             Records affected: 0
2025-06-29 06:35:42.248             MSG                             Point-5
2025-06-29 06:35:42.248             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.248             WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.248             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.248             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.248             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.248             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.248             GRANT_OPTION                    2
2025-06-29 06:35:42.248             MSG                             Point-5
2025-06-29 06:35:42.248             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.248             WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.248             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.248             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.249             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.249             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.249             GRANT_OPTION                    0
2025-06-29 06:35:42.249             Records affected: 2
2025-06-29 06:35:42.249             MSG                             Point-6
2025-06-29 06:35:42.249             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.249             WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.249             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.249             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.249             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.249             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.249             GRANT_OPTION                    2
2025-06-29 06:35:42.249             Records affected: 1
2025-06-29 06:35:42.249             Statement failed, SQLSTATE = 28000
2025-06-29 06:35:42.249             unsuccessful metadata update
2025-06-29 06:35:42.249             -DROP ROLE TMP_ROLE1 failed
2025-06-29 06:35:42.249             -no permission for DROP access to ROLE TMP_ROLE1
2025-06-29 06:35:42.249             COUNT                           1
2025-06-29 06:35:42.249             MSG                             Point-6
2025-06-29 06:35:42.249             WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.250             WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.250             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.250             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.250             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.250             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.250             GRANT_OPTION                    2
2025-06-29 06:35:42.250             MSG                             Point-6
2025-06-29 06:35:42.250             WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.250             WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.250             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.250             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.250             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.250             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.250             GRANT_OPTION                    0
2025-06-29 06:35:42.250             MSG                             Point-6
2025-06-29 06:35:42.250             WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.250             WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.250             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.250             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.250             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.250             GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.251             GRANT_OPTION                    0
2025-06-29 06:35:42.251             Records affected: 3
2025-06-29 06:35:42.251             MSG                             Point-7
2025-06-29 06:35:42.251             RDB$ROLE_NAME                   <null>
2025-06-29 06:35:42.251             RDB$OWNER_NAME                  <null>
2025-06-29 06:35:42.251             RDB$DESCRIPTION                 <null>
2025-06-29 06:35:42.251             RDB$SYSTEM_FLAG                 <null>
2025-06-29 06:35:42.251             RDB$SECURITY_CLASS              <null>
2025-06-29 06:35:42.251             RDB$SYSTEM_PRIVILEGES           <null>
2025-06-29 06:35:42.251             Records affected: 1
2025-06-29 06:35:42.251             MSG                             Point-8
2025-06-29 06:35:42.251             WHO_AM_I                        <null>
2025-06-29 06:35:42.251             WHO_WAS_GRANTED                 <null>
2025-06-29 06:35:42.251             PRIVILEGE_TYPE                  <null>
2025-06-29 06:35:42.251             ROLE_NAME                       <null>
2025-06-29 06:35:42.251             ROLE_OWNER                      <null>
2025-06-29 06:35:42.251             GRANTED_BY                      <null>
2025-06-29 06:35:42.251             GRANT_OPTION                    <null>
2025-06-29 06:35:42.251             Records affected: 1
2025-06-29 06:35:42.251             MSG                             Point-9
2025-06-29 06:35:42.252             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.252             WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.252             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.252             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.252             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.252             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.252             GRANT_OPTION                    2
2025-06-29 06:35:42.252             MSG                             Point-9
2025-06-29 06:35:42.252             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.252             WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.252             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.252             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.252             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.252             GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.252             GRANT_OPTION                    0
2025-06-29 06:35:42.252             MSG                             Point-9
2025-06-29 06:35:42.252             WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.252             WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.252             PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.253             ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.253             ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.253             GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.253             GRANT_OPTION                    0
2025-06-29 06:35:42.253             Records affected: 3
2025-06-29 06:35:42.253             MSG                             Point-10
2025-06-29 06:35:42.253             RDB$ROLE_NAME                   <null>
2025-06-29 06:35:42.253             RDB$OWNER_NAME                  <null>
2025-06-29 06:35:42.253             RDB$DESCRIPTION                 <null>
2025-06-29 06:35:42.253             RDB$SYSTEM_FLAG                 <null>
2025-06-29 06:35:42.253             RDB$SECURITY_CLASS              <null>
2025-06-29 06:35:42.253             RDB$SYSTEM_PRIVILEGES           <null>
2025-06-29 06:35:42.253             Records affected: 1
2025-06-29 06:35:42.253             MSG                             Point-11
2025-06-29 06:35:42.253             WHO_AM_I                        <null>
2025-06-29 06:35:42.253             WHO_WAS_GRANTED                 <null>
2025-06-29 06:35:42.253             PRIVILEGE_TYPE                  <null>
2025-06-29 06:35:42.253             ROLE_NAME                       <null>
2025-06-29 06:35:42.253             ROLE_OWNER                      <null>
2025-06-29 06:35:42.253             GRANTED_BY                      <null>
2025-06-29 06:35:42.254             GRANT_OPTION                    <null>
2025-06-29 06:35:42.254             Records affected: 1
2025-06-29 06:35:42.254         """
2025-06-29 06:35:42.254         act.isql(switches = ['-q'], input = test_sql, combine_output = True, connect_db = False, io_enc = locale.getpreferredencoding())
2025-06-29 06:35:42.254 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 06:35:42.254 E       assert
2025-06-29 06:35:42.254 E           MSG                             Point-1
2025-06-29 06:35:42.254 E           WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.254 E           WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.254 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.254 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.254 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.254 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.254 E           GRANT_OPTION                    2
2025-06-29 06:35:42.254 E           MSG                             Point-1
2025-06-29 06:35:42.254 E           WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.254 E           WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.254 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.254 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.254 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.255 E           GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.255 E           GRANT_OPTION                    0
2025-06-29 06:35:42.255 E           Records affected: 2
2025-06-29 06:35:42.255 E           MSG                             Point-2
2025-06-29 06:35:42.255 E           WHO_AM_I                        SYSDBA
2025-06-29 06:35:42.255 E           WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.255 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.255 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.255 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.255 E           GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.255 E           GRANT_OPTION                    0
2025-06-29 06:35:42.255 E           Records affected: 1
2025-06-29 06:35:42.255 E           MSG                             Point-3
2025-06-29 06:35:42.255 E           WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.255 E           WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.255 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.255 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.255 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.255 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.255 E           GRANT_OPTION                    0
2025-06-29 06:35:42.256 E           Records affected: 1
2025-06-29 06:35:42.256 E           Records affected: 0
2025-06-29 06:35:42.256 E           MSG                             Point-5
2025-06-29 06:35:42.256 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.256 E           WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.256 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.256 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.256 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.256 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.256 E           GRANT_OPTION                    2
2025-06-29 06:35:42.256 E           MSG                             Point-5
2025-06-29 06:35:42.256 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.256 E           WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.256 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.256 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.256 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.256 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.256 E           GRANT_OPTION                    0
2025-06-29 06:35:42.256 E           Records affected: 2
2025-06-29 06:35:42.257 E           MSG                             Point-6
2025-06-29 06:35:42.257 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.257 E           WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.257 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.257 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.257 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.257 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.257 E           GRANT_OPTION                    2
2025-06-29 06:35:42.257 E           Records affected: 1
2025-06-29 06:35:42.257 E           Statement failed, SQLSTATE = 28000
2025-06-29 06:35:42.257 E           unsuccessful metadata update
2025-06-29 06:35:42.257 E           -DROP ROLE TMP_ROLE1 failed
2025-06-29 06:35:42.257 E         - -no permission for DROP access to ROLE TMP_ROLE1
2025-06-29 06:35:42.257 E         + -no permission for DROP access to ROLE "TMP_ROLE1"
2025-06-29 06:35:42.257 E           COUNT                           1
2025-06-29 06:35:42.257 E           MSG                             Point-6
2025-06-29 06:35:42.257 E           WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.257 E           WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.257 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.258 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.258 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.258 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.258 E           GRANT_OPTION                    2
2025-06-29 06:35:42.258 E           MSG                             Point-6
2025-06-29 06:35:42.258 E           WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.258 E           WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.258 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.258 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.258 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.258 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.258 E           GRANT_OPTION                    0
2025-06-29 06:35:42.258 E           MSG                             Point-6
2025-06-29 06:35:42.258 E           WHO_AM_I                        TMP$C5248_USR0
2025-06-29 06:35:42.258 E           WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.258 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.258 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.258 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.258 E           GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.258 E           GRANT_OPTION                    0
2025-06-29 06:35:42.259 E           Records affected: 3
2025-06-29 06:35:42.259 E           MSG                             Point-7
2025-06-29 06:35:42.259 E           RDB$ROLE_NAME                   <null>
2025-06-29 06:35:42.259 E           RDB$OWNER_NAME                  <null>
2025-06-29 06:35:42.259 E           RDB$DESCRIPTION                 <null>
2025-06-29 06:35:42.259 E           RDB$SYSTEM_FLAG                 <null>
2025-06-29 06:35:42.259 E           RDB$SECURITY_CLASS              <null>
2025-06-29 06:35:42.259 E           RDB$SYSTEM_PRIVILEGES           <null>
2025-06-29 06:35:42.259 E           Records affected: 1
2025-06-29 06:35:42.259 E           MSG                             Point-8
2025-06-29 06:35:42.259 E           WHO_AM_I                        <null>
2025-06-29 06:35:42.259 E           WHO_WAS_GRANTED                 <null>
2025-06-29 06:35:42.259 E           PRIVILEGE_TYPE                  <null>
2025-06-29 06:35:42.259 E           ROLE_NAME                       <null>
2025-06-29 06:35:42.259 E           ROLE_OWNER                      <null>
2025-06-29 06:35:42.259 E           GRANTED_BY                      <null>
2025-06-29 06:35:42.259 E           GRANT_OPTION                    <null>
2025-06-29 06:35:42.259 E           Records affected: 1
2025-06-29 06:35:42.259 E           MSG                             Point-9
2025-06-29 06:35:42.259 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.260 E           WHO_WAS_GRANTED                 TMP$C5248_USR1
2025-06-29 06:35:42.260 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.260 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.260 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.260 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.260 E           GRANT_OPTION                    2
2025-06-29 06:35:42.260 E           MSG                             Point-9
2025-06-29 06:35:42.260 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.260 E           WHO_WAS_GRANTED                 TMP$C5248_USR3
2025-06-29 06:35:42.260 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.260 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.260 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.260 E           GRANTED_BY                      SYSDBA
2025-06-29 06:35:42.260 E           GRANT_OPTION                    0
2025-06-29 06:35:42.260 E           MSG                             Point-9
2025-06-29 06:35:42.260 E           WHO_AM_I                        TMP$C5248_USR1
2025-06-29 06:35:42.260 E           WHO_WAS_GRANTED                 TMP$C5248_USR2
2025-06-29 06:35:42.260 E           PRIVILEGE_TYPE                  M
2025-06-29 06:35:42.260 E           ROLE_NAME                       TMP_ROLE1
2025-06-29 06:35:42.260 E           ROLE_OWNER                      TMP$C5248_USR0
2025-06-29 06:35:42.261 E           GRANTED_BY                      TMP$C5248_USR1
2025-06-29 06:35:42.261 E           GRANT_OPTION                    0
2025-06-29 06:35:42.261 E           Records affected: 3
2025-06-29 06:35:42.261 E           MSG                             Point-10
2025-06-29 06:35:42.261 E           RDB$ROLE_NAME                   <null>
2025-06-29 06:35:42.261 E           RDB$OWNER_NAME                  <null>
2025-06-29 06:35:42.261 E           RDB$DESCRIPTION                 <null>
2025-06-29 06:35:42.261 E           RDB$SYSTEM_FLAG                 <null>
2025-06-29 06:35:42.261 E           RDB$SECURITY_CLASS              <null>
2025-06-29 06:35:42.261 E           RDB$SYSTEM_PRIVILEGES           <null>
2025-06-29 06:35:42.261 E           Records affected: 1
2025-06-29 06:35:42.261 E           MSG                             Point-11
2025-06-29 06:35:42.261 E           WHO_AM_I                        <null>
2025-06-29 06:35:42.261 E           WHO_WAS_GRANTED                 <null>
2025-06-29 06:35:42.261 E           PRIVILEGE_TYPE                  <null>
2025-06-29 06:35:42.261 E           ROLE_NAME                       <null>
2025-06-29 06:35:42.261 E           ROLE_OWNER                      <null>
2025-06-29 06:35:42.261 E           GRANTED_BY                      <null>
2025-06-29 06:35:42.261 E           GRANT_OPTION                    <null>
2025-06-29 06:35:42.261 E           Records affected: 1
2025-06-29 06:35:42.261
2025-06-29 06:35:42.262 tests\bugs\core_5248_test.py:337: AssertionError
2025-06-29 06:35:42.262 ---------------------------- Captured stdout setup ----------------------------
2025-06-29 06:35:42.262 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_242\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2025-06-29 06:35:42.262 CREATE user: TMP$C5248_USR0 PLUGIN: Srp
2025-06-29 06:35:42.262 CREATE user: TMP$C5248_USR1 PLUGIN: Srp
2025-06-29 06:35:42.262 CREATE user: TMP$C5248_USR2 PLUGIN: Srp
2025-06-29 06:35:42.262 CREATE user: TMP$C5248_USR3 PLUGIN: Srp
2025-06-29 06:35:42.262 CREATE user: TMP$C5248_USR4 PLUGIN: Srp
2025-06-29 06:35:42.262 -------------------------- Captured stdout teardown ---------------------------
2025-06-29 06:35:42.262 DROP role: TMP_ROLE1
2025-06-29 06:35:42.262 DROP user: TMP$C5248_USR4 PLUGIN: Srp
2025-06-29 06:35:42.262 DROP user: TMP$C5248_USR3 PLUGIN: Srp
2025-06-29 06:35:42.262 DROP user: TMP$C5248_USR2 PLUGIN: Srp
2025-06-29 06:35:42.262 DROP user: TMP$C5248_USR1 PLUGIN: Srp
2025-06-29 06:35:42.262 DROP user: TMP$C5248_USR0 PLUGIN: Srp
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
tmp_usr0 = <firebird.qa.plugin.User pytest object at [hex]>
tmp_usr1 = <firebird.qa.plugin.User pytest object at [hex]>
tmp_usr2 = <firebird.qa.plugin.User pytest object at [hex]>
tmp_usr3 = <firebird.qa.plugin.User pytest object at [hex]>
tmp_usr4 = <firebird.qa.plugin.User pytest object at [hex]>
tmp_role = <firebird.qa.plugin.Role pytest object at [hex]>

    @pytest.mark.version('>=4.0')
    def test_2(act: Action, tmp_usr0: User, tmp_usr1: User, tmp_usr2: User, tmp_usr3: User, tmp_usr4: User, tmp_role: Role):
    
        test_sql = f"""
            set list on;
            set count on;
            -- #############
            set autoddl OFF;
            -- #############
            connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
    
            recreate view v_grants as
            select
                 current_user                    as who_am_i
                ,p.RDB$USER                      as who_was_granted
                ,p.RDB$PRIVILEGE                 as privilege_type
                ,p.RDB$RELATION_NAME             as role_name
                ,r.RDB$OWNER_NAME                as role_owner
                ,p.RDB$GRANTOR                   as granted_by
                ,p.RDB$GRANT_OPTION              as grant_option
            from rdb$user_privileges p
            left join rdb$roles r on p.rdb$relation_name = r.rdb$role_name
            where p.rdb$object_type=13
            ;
            commit;
            grant select on v_grants to public;
            commit;
    
            grant create role to user {tmp_usr0.name};
            commit;
    
            connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
            create role {tmp_role.name}; -- {tmp_usr0.name} is owner of role {tmp_role.name}
            commit;
    
            connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
            grant {tmp_role.name} to {tmp_usr1.name} with admin option;
            grant {tmp_role.name} to {tmp_usr3.name};
            commit;
    
            connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
            grant {tmp_role.name} to {tmp_usr2.name}; ----------------------- {tmp_usr1.name} grants role to {tmp_usr2.name}
            commit;
    
            -- 1. revoke - avoid cascade grants delete
    
            connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
    
            select 'Point-1' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr2.name}') );  -- must contain 2 records
    
            revoke {tmp_role.name} from {tmp_usr1.name}; -- Q: whether grant on role '{tmp_role.name}' remains to user '{tmp_usr2.name}' after revoking from '{tmp_usr1.name}' ?
    
            select 'Point-2' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr2.name}') );  -- must contain 1 record for {tmp_usr2.name}
    
            -- return grant to {tmp_usr1.name} because it was revoked just now:
            rollback;
    
            /***********************************************
            ############################################
            DISABLED 08.03.2025, after GH-8462 was fixed
            ############################################
            -- 2. revoke: user who has 'admin option' can revoke role from anyone EXCEPT himself
            connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
    
            -- Following REVOKE should fail with:
            -- Statement failed, SQLSTATE = 42000
            -- unsuccessful metadata update
            -- -REVOKE failed
            -- -{tmp_usr1.name} is not grantor of Role on {tmp_role.name} to {tmp_usr1.name}.
            revoke {tmp_role.name} from {tmp_usr1.name};
    
            select * from v_grants where upper(who_was_granted) = upper('{tmp_usr1.name}'); -- record should remain
            rollback;
            ***********************************************/
    
            -- 3. revoke - check role owner rights
            connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
    
            select 'Point-3' as msg, v.* from v_grants v where upper(v.who_was_granted) = upper('{tmp_usr3.name}');
    
            -- current user = {tmp_usr0.name} - is owner of role {tmp_role.name}, but this role was granted to {tmp_usr3.name} by SYSDBA.
            -- Q: should user '{tmp_usr0.password}' (current) be able to revoke role which he did NOT grant but owns ?
            -- A: yes.
    
            revoke {tmp_role.name} from {tmp_usr3.name};  -- NO error/warning should be here
    
            select 'Point-4' as msg, v.* from v_grants v where upper(v.who_was_granted) = upper('{tmp_usr3.name}'); -- record should NOT appear.
            rollback;
    
            -- 4. revoke - check admin option
            connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
    
            select 'Point-5' as msg, v.* from v_grants v where upper(v.who_was_granted) in ( upper('{tmp_usr1.name}'), upper('{tmp_usr3.name}') ); -- two records should be here
    
            -- current user = {tmp_usr1.name} - is NOT owner of role {tmp_role.name} but he was granted to use it WITH ADMIN option
            -- (grant {tmp_role.name} to {tmp_usr1.name} with admin option).
            -- Q: should user '{tmp_usr1.name}' (current) be able to revoke role which he neither did grant nor owns but has admin option ?
            -- A: yes.
    
            revoke {tmp_role.name} from {tmp_usr3.name};
    
            select 'Point-6' as msg, v.* from v_grants v where upper(v.who_was_granted) in (upper('{tmp_usr1.name}'), upper('{tmp_usr3.name}')); -- only one record should be here
            rollback;
    
            -- 5a. drop role - should fail
            connect '{act.db.dsn}' user {tmp_usr4.name} password '{tmp_usr4.password}';
    
            -- Statement failed, SQLSTATE = 28000
            -- unsuccessful metadata update
            -- -DROP ROLE {tmp_role.name} failed
            -- -no permission for DROP access to ROLE {tmp_role.name}
    
            drop role {tmp_role.name}; -- should fail: this user is not owner of this role and he was not granted to use it with admin option
    
            set count off;
            select count(*) from rdb$roles where rdb$role_name = '{tmp_role.name}';
            set count on;
            rollback;
    
            connect '{act.db.dsn}' user {tmp_usr0.name} password '{tmp_usr0.password}';
    
            select 'Point-6' as msg, v.* from v_grants v where upper(v.role_name) = upper('{tmp_role.name}'); -- should output 3 records
    
            drop role {tmp_role.name}; -- current user: '{tmp_usr0.name}' - is owner of role {tmp_role.name}
    
            select 'Point-7' as msg, r.* from rdb$database d left join rdb$roles r on upper(r.rdb$role_name) = upper('{tmp_role.name}'); -- should output NULLs
    
            select 'Point-8' as msg, v.* from rdb$database d left join v_grants v on upper(v.role_name) = upper('{tmp_role.name}'); -- should output NULLs
            rollback;
    
            -- 6. drop role - check admin option
            connect '{act.db.dsn}' user {tmp_usr1.name} password '{tmp_usr1.password}';
    
            -- current user: '{tmp_usr1.name}' - HAS grant on role {tmp_role.name} with admin option (but he is NOT owner of this role).
    
            select 'Point-9' as msg, v.* from v_grants v where upper(v.role_name) = upper('{tmp_role.name}'); -- should output 3 records
    
            drop role {tmp_role.name}; -- current user: '{tmp_usr0.name}' - is owner of role {tmp_role.name}
    
            select 'Point-10' as msg, r.* from rdb$database d left join rdb$roles r on upper(r.rdb$role_name) = upper('{tmp_role.name}'); -- should output NULLs
            select 'Point-11' as msg, v.* from rdb$database d left join v_grants v on upper(role_name) = upper('{tmp_role.name}');      -- should output NULLs
            rollback;
        """
    
    
        act.expected_stdout = """
            MSG                             Point-1
            WHO_AM_I                        SYSDBA
            WHO_WAS_GRANTED                 TMP$C5248_USR1
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    2
            MSG                             Point-1
            WHO_AM_I                        SYSDBA
            WHO_WAS_GRANTED                 TMP$C5248_USR2
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      TMP$C5248_USR1
            GRANT_OPTION                    0
            Records affected: 2
            MSG                             Point-2
            WHO_AM_I                        SYSDBA
            WHO_WAS_GRANTED                 TMP$C5248_USR2
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      TMP$C5248_USR1
            GRANT_OPTION                    0
            Records affected: 1
            MSG                             Point-3
            WHO_AM_I                        TMP$C5248_USR0
            WHO_WAS_GRANTED                 TMP$C5248_USR3
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    0
            Records affected: 1
            Records affected: 0
            MSG                             Point-5
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR1
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    2
            MSG                             Point-5
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR3
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    0
            Records affected: 2
            MSG                             Point-6
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR1
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    2
            Records affected: 1
            Statement failed, SQLSTATE = 28000
            unsuccessful metadata update
            -DROP ROLE TMP_ROLE1 failed
            -no permission for DROP access to ROLE TMP_ROLE1
            COUNT                           1
            MSG                             Point-6
            WHO_AM_I                        TMP$C5248_USR0
            WHO_WAS_GRANTED                 TMP$C5248_USR1
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    2
            MSG                             Point-6
            WHO_AM_I                        TMP$C5248_USR0
            WHO_WAS_GRANTED                 TMP$C5248_USR3
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    0
            MSG                             Point-6
            WHO_AM_I                        TMP$C5248_USR0
            WHO_WAS_GRANTED                 TMP$C5248_USR2
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      TMP$C5248_USR1
            GRANT_OPTION                    0
            Records affected: 3
            MSG                             Point-7
            RDB$ROLE_NAME                   <null>
            RDB$OWNER_NAME                  <null>
            RDB$DESCRIPTION                 <null>
            RDB$SYSTEM_FLAG                 <null>
            RDB$SECURITY_CLASS              <null>
            RDB$SYSTEM_PRIVILEGES           <null>
            Records affected: 1
            MSG                             Point-8
            WHO_AM_I                        <null>
            WHO_WAS_GRANTED                 <null>
            PRIVILEGE_TYPE                  <null>
            ROLE_NAME                       <null>
            ROLE_OWNER                      <null>
            GRANTED_BY                      <null>
            GRANT_OPTION                    <null>
            Records affected: 1
            MSG                             Point-9
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR1
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    2
            MSG                             Point-9
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR3
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      SYSDBA
            GRANT_OPTION                    0
            MSG                             Point-9
            WHO_AM_I                        TMP$C5248_USR1
            WHO_WAS_GRANTED                 TMP$C5248_USR2
            PRIVILEGE_TYPE                  M
            ROLE_NAME                       TMP_ROLE1
            ROLE_OWNER                      TMP$C5248_USR0
            GRANTED_BY                      TMP$C5248_USR1
            GRANT_OPTION                    0
            Records affected: 3
            MSG                             Point-10
            RDB$ROLE_NAME                   <null>
            RDB$OWNER_NAME                  <null>
            RDB$DESCRIPTION                 <null>
            RDB$SYSTEM_FLAG                 <null>
            RDB$SECURITY_CLASS              <null>
            RDB$SYSTEM_PRIVILEGES           <null>
            Records affected: 1
            MSG                             Point-11
            WHO_AM_I                        <null>
            WHO_WAS_GRANTED                 <null>
            PRIVILEGE_TYPE                  <null>
            ROLE_NAME                       <null>
            ROLE_OWNER                      <null>
            GRANTED_BY                      <null>
            GRANT_OPTION                    <null>
            Records affected: 1
        """
        act.isql(switches = ['-q'], input = test_sql, combine_output = True, connect_db = False, io_enc = locale.getpreferredencoding())
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           MSG                             Point-1
E           WHO_AM_I                        SYSDBA
E           WHO_WAS_GRANTED                 TMP$C5248_USR1
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    2
E           MSG                             Point-1
E           WHO_AM_I                        SYSDBA
E           WHO_WAS_GRANTED                 TMP$C5248_USR2
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      TMP$C5248_USR1
E           GRANT_OPTION                    0
E           Records affected: 2
E           MSG                             Point-2
E           WHO_AM_I                        SYSDBA
E           WHO_WAS_GRANTED                 TMP$C5248_USR2
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      TMP$C5248_USR1
E           GRANT_OPTION                    0
E           Records affected: 1
E           MSG                             Point-3
E           WHO_AM_I                        TMP$C5248_USR0
E           WHO_WAS_GRANTED                 TMP$C5248_USR3
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    0
E           Records affected: 1
E           Records affected: 0
E           MSG                             Point-5
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR1
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    2
E           MSG                             Point-5
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR3
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    0
E           Records affected: 2
E           MSG                             Point-6
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR1
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    2
E           Records affected: 1
E           Statement failed, SQLSTATE = 28000
E           unsuccessful metadata update
E           -DROP ROLE TMP_ROLE1 failed
E         - -no permission for DROP access to ROLE TMP_ROLE1
E         + -no permission for DROP access to ROLE "TMP_ROLE1"
E           COUNT                           1
E           MSG                             Point-6
E           WHO_AM_I                        TMP$C5248_USR0
E           WHO_WAS_GRANTED                 TMP$C5248_USR1
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    2
E           MSG                             Point-6
E           WHO_AM_I                        TMP$C5248_USR0
E           WHO_WAS_GRANTED                 TMP$C5248_USR3
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    0
E           MSG                             Point-6
E           WHO_AM_I                        TMP$C5248_USR0
E           WHO_WAS_GRANTED                 TMP$C5248_USR2
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      TMP$C5248_USR1
E           GRANT_OPTION                    0
E           Records affected: 3
E           MSG                             Point-7
E           RDB$ROLE_NAME                   <null>
E           RDB$OWNER_NAME                  <null>
E           RDB$DESCRIPTION                 <null>
E           RDB$SYSTEM_FLAG                 <null>
E           RDB$SECURITY_CLASS              <null>
E           RDB$SYSTEM_PRIVILEGES           <null>
E           Records affected: 1
E           MSG                             Point-8
E           WHO_AM_I                        <null>
E           WHO_WAS_GRANTED                 <null>
E           PRIVILEGE_TYPE                  <null>
E           ROLE_NAME                       <null>
E           ROLE_OWNER                      <null>
E           GRANTED_BY                      <null>
E           GRANT_OPTION                    <null>
E           Records affected: 1
E           MSG                             Point-9
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR1
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    2
E           MSG                             Point-9
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR3
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      SYSDBA
E           GRANT_OPTION                    0
E           MSG                             Point-9
E           WHO_AM_I                        TMP$C5248_USR1
E           WHO_WAS_GRANTED                 TMP$C5248_USR2
E           PRIVILEGE_TYPE                  M
E           ROLE_NAME                       TMP_ROLE1
E           ROLE_OWNER                      TMP$C5248_USR0
E           GRANTED_BY                      TMP$C5248_USR1
E           GRANT_OPTION                    0
E           Records affected: 3
E           MSG                             Point-10
E           RDB$ROLE_NAME                   <null>
E           RDB$OWNER_NAME                  <null>
E           RDB$DESCRIPTION                 <null>
E           RDB$SYSTEM_FLAG                 <null>
E           RDB$SECURITY_CLASS              <null>
E           RDB$SYSTEM_PRIVILEGES           <null>
E           Records affected: 1
E           MSG                             Point-11
E           WHO_AM_I                        <null>
E           WHO_WAS_GRANTED                 <null>
E           PRIVILEGE_TYPE                  <null>
E           ROLE_NAME                       <null>
E           ROLE_OWNER                      <null>
E           GRANTED_BY                      <null>
E           GRANT_OPTION                    <null>
E           Records affected: 1

tests\bugs\core_5248_test.py:337: AssertionError
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 6.0.0.881 2025.06.27 7035d F F 4192 2446 2025.06.29 02:29:44.539 2025.06.29 02:29:48.731 2025.06.29 00:53:08.457 2025.06.29 00:53:10.903
2 6.0.0.877 2025.06.26 8e38f F F 4223 2415 2025.06.27 02:30:50.002 2025.06.27 02:30:54.225 2025.06.27 00:53:26.005 2025.06.27 00:53:28.420
3 6.0.0.876 2025.06.25 b1bec F F 4198 2408 2025.06.26 02:36:12.356 2025.06.26 02:36:16.554 2025.06.26 00:58:53.841 2025.06.26 00:58:56.249
4 6.0.0.863 2025.06.24 c3c20 F F 4231 2394 2025.06.25 07:20:31.185 2025.06.25 07:20:35.416 2025.06.25 00:52:57.705 2025.06.25 00:53:00.099
5 6.0.0.858 2025.06.24 cbbbf F F 4464 2429 2025.06.24 17:02:40.377 2025.06.24 17:02:44.841 2025.06.24 15:25:06.110 2025.06.24 15:25:08.539
6 6.0.0.858 2025.06.23 d377c F F 4572 2407 2025.06.24 08:14:40.297 2025.06.24 08:14:44.869 2025.06.24 06:37:36.312 2025.06.24 06:37:38.719
7 6.0.0.854 2025.06.23 10b58 F F 4487 2370 2025.06.23 14:55:35.824 2025.06.23 14:55:40.311 2025.06.23 13:17:00.533 2025.06.23 13:17:02.903
8 6.0.0.849 2025.06.20 7b79c F F 4190 2413 2025.06.21 02:34:18.029 2025.06.21 02:34:22.219 2025.06.21 00:53:26.077 2025.06.21 00:53:28.490
9 6.0.0.848 2025.06.19 c483c F F 4213 2422 2025.06.20 02:33:51.037 2025.06.20 02:33:55.250 2025.06.20 00:53:31.062 2025.06.20 00:53:33.484
10 6.0.0.845 2025.06.18 20191 F F 4238 2383 2025.06.19 02:33:28.005 2025.06.19 02:33:32.243 2025.06.19 00:53:19.368 2025.06.19 00:53:21.751
11 6.0.0.843 2025.06.16 995f4 F F 4406 2395 2025.06.18 02:33:11.583 2025.06.18 02:33:15.989 2025.06.18 00:53:10.027 2025.06.18 00:53:12.422
12 6.0.0.840 2025.06.14 29bca F F 4341 2428 2025.06.15 02:40:50.357 2025.06.15 02:40:54.698 2025.06.15 00:55:30.198 2025.06.15 00:55:32.626
13 6.0.0.838 2025.06.13 0e28a F F 4392 2430 2025.06.14 02:38:56.837 2025.06.14 02:39:01.229 2025.06.14 00:54:02.485 2025.06.14 00:54:04.915
14 6.0.0.834 2025.06.11 e889f F F 4217 2460 2025.06.12 02:36:49.275 2025.06.12 02:36:53.492 2025.06.12 00:54:33.769 2025.06.12 00:54:36.229
15 6.0.0.800 2025.06.10 1f226 P P 3962 2214 2025.06.11 01:38:25.295 2025.06.11 01:38:29.257 2025.06.11 00:34:39.517 2025.06.11 00:34:41.731
16 6.0.0.799 2025.06.07 be644 P P 4032 2201 2025.06.10 01:38:00.897 2025.06.10 01:38:04.929 2025.06.10 00:34:30.771 2025.06.10 00:34:32.972
17 6.0.0.797 2025.06.06 303e8 P P 3911 2195 2025.06.07 01:37:07.445 2025.06.07 01:37:11.356 2025.06.07 00:34:30.501 2025.06.07 00:34:32.696
18 6.0.0.795 2025.05.29 7a71a P P 3930 2200 2025.06.06 01:37:01.258 2025.06.06 01:37:05.188 2025.06.06 00:34:25.506 2025.06.06 00:34:27.706
19 6.0.0.792 2025.05.28 ee5a8 P P 4030 2200 2025.05.29 01:36:05.091 2025.05.29 01:36:09.121 2025.05.29 00:34:21.244 2025.05.29 00:34:23.444
20 6.0.0.791 2025.05.27 02db8 P P 4221 2233 2025.05.28 01:36:20.678 2025.05.28 01:36:24.899 2025.05.28 00:34:18.445 2025.05.28 00:34:20.678
21 6.0.0.789 2025.05.21 64051 P P 3872 2233 2025.05.25 01:36:23.669 2025.05.25 01:36:27.541 2025.05.25 00:34:25.207 2025.05.25 00:34:27.440
22 6.0.0.787 2025.05.20 230ad P P 4103 2250 2025.05.21 01:35:01.664 2025.05.21 01:35:05.767 2025.05.21 00:33:53.544 2025.05.21 00:33:55.794
23 6.0.0.783 2025.05.12 37320 P P 3873 2182 2025.05.19 01:34:58.656 2025.05.19 01:35:02.529 2025.05.19 00:33:58.674 2025.05.19 00:34:00.856
24 6.0.0.779 2025.05.11 136fa P P 3911 2210 2025.05.12 01:37:07.650 2025.05.12 01:37:11.561 2025.05.12 00:34:26.676 2025.05.12 00:34:28.886
25 6.0.0.778 2025.05.07 d735e P P 3983 2593 2025.05.11 01:36:31.805 2025.05.11 01:36:35.788 2025.05.11 00:34:38.144 2025.05.11 00:34:40.737
26 6.0.0.776 2025.05.06 007cd P P 4097 2227 2025.05.07 01:35:52.560 2025.05.07 01:35:56.657 2025.05.07 00:34:23.036 2025.05.07 00:34:25.263
27 6.0.0.770 2025.05.05 82c4a P P 4121 2198 2025.05.06 01:36:13.879 2025.05.06 01:36:18.000 2025.05.06 00:34:27.008 2025.05.06 00:34:29.206
28 6.0.0.767 2025.05.01 cdd29 P P 3914 2235 2025.05.02 01:36:47.878 2025.05.02 01:36:51.792 2025.05.02 00:35:19.166 2025.05.02 00:35:21.401
29 6.0.0.762 2025.04.30 5cb15 P P 3894 2291 2025.05.01 01:35:21.685 2025.05.01 01:35:25.579 2025.05.01 00:34:31.010 2025.05.01 00:34:33.301
30 6.0.0.755 2025.04.29 739c6 P P 3888 2355 2025.04.30 01:35:19.532 2025.04.30 01:35:23.420 2025.04.30 00:34:13.376 2025.04.30 00:34:15.731
31 6.0.0.753 2025.04.27 29ab3 P P 3856 2181 2025.04.29 01:35:42.527 2025.04.29 01:35:46.383 2025.04.29 00:34:33.576 2025.04.29 00:34:35.757
32 6.0.0.745 2025.04.21 78ad8 P P 3967 2264 2025.04.26 01:36:38.631 2025.04.26 01:36:42.598 2025.04.26 00:34:26.244 2025.04.26 00:34:28.508
33 6.0.0.744 2025.04.19 e883a P P 3945 2719 2025.04.20 01:36:11.010 2025.04.20 01:36:14.955 2025.04.20 00:34:23.912 2025.04.20 00:34:26.631
34 6.0.0.742 2025.04.17 abc3b P P 3988 2274 2025.04.19 01:35:39.780 2025.04.19 01:35:43.768 2025.04.19 00:34:06.217 2025.04.19 00:34:08.491
35 6.0.0.737 2025.04.16 fe52b P P 3890 2233 2025.04.17 01:36:14.208 2025.04.17 01:36:18.098 2025.04.17 00:34:22.508 2025.04.17 00:34:24.741
36 6.0.0.736 2025.04.14 3e6be P P 3981 2311 2025.04.15 01:36:54.460 2025.04.15 01:36:58.441 2025.04.15 00:34:37.333 2025.04.15 00:34:39.644
37 6.0.0.735 2025.04.13 6635c P P 3936 2280 2025.04.14 01:36:14.659 2025.04.14 01:36:18.595 2025.04.14 00:34:23.741 2025.04.14 00:34:26.021
38 6.0.0.734 2025.04.12 e2fd1 P P 3875 2218 2025.04.13 01:34:17.200 2025.04.13 01:34:21.075 2025.04.13 00:34:20.340 2025.04.13 00:34:22.558
39 6.0.0.730 2025.04.11 240b8 P P 3968 2289 2025.04.12 01:40:15.266 2025.04.12 01:40:19.234 2025.04.12 00:35:02.782 2025.04.12 00:35:05.071
40 6.0.0.726 2025.04.10 d79c6 P P 4042 2275 2025.04.11 01:40:08.274 2025.04.11 01:40:12.316 2025.04.11 00:35:03.899 2025.04.11 00:35:06.174
41 6.0.0.725 2025.04.09 a2b05 P P 3987 2332 2025.04.10 01:40:01.396 2025.04.10 01:40:05.383 2025.04.10 00:34:59.797 2025.04.10 00:35:02.129
42 6.0.0.722 2025.04.08 a8b86 P P 4066 2261 2025.04.09 01:36:20.496 2025.04.09 01:36:24.562 2025.04.09 00:34:33.526 2025.04.09 00:34:35.787
43 6.0.0.719 2025.04.06 90fd9 P P 3951 2325 2025.04.08 01:36:38.426 2025.04.08 01:36:42.377 2025.04.08 00:34:31.492 2025.04.08 00:34:33.817
44 6.0.0.717 2025.04.04 53d70 P P 3997 2305 2025.04.05 01:36:39.878 2025.04.05 01:36:43.875 2025.04.05 00:34:37.215 2025.04.05 00:34:39.520
45 6.0.0.716 2025.04.03 fc636 P P 4008 2433 2025.04.04 01:36:41.634 2025.04.04 01:36:45.642 2025.04.04 00:34:42.658 2025.04.04 00:34:45.091
46 6.0.0.715 2025.04.02 907ed P P 3961 2281 2025.04.03 01:36:37.509 2025.04.03 01:36:41.470 2025.04.03 00:34:29.567 2025.04.03 00:34:31.848
47 6.0.0.710 2025.04.01 40651 P P 3987 2273 2025.04.02 01:36:53.263 2025.04.02 01:36:57.250 2025.04.02 00:35:12.584 2025.04.02 00:35:14.857
48 6.0.0.708 2025.03.31 cb069 P P 3995 2335 2025.04.01 01:36:09.239 2025.04.01 01:36:13.234 2025.04.01 00:34:32.598 2025.04.01 00:34:34.933
49 6.0.0.707 2025.03.28 4bd4f P P 4001 2320 2025.03.31 01:36:14.799 2025.03.31 01:36:18.800 2025.03.31 00:34:31.190 2025.03.31 00:34:33.510
50 6.0.0.702 2025.03.27 86f4d P P 3948 2547 2025.03.28 01:53:17.194 2025.03.28 01:53:21.142 2025.03.28 00:35:08.674 2025.03.28 00:35:11.221
51 6.0.0.698 2025.03.26 d72a7 P P 4279 2466 2025.03.27 15:18:59.679 2025.03.27 15:19:03.958 2025.03.27 14:15:05.991 2025.03.27 14:15:08.457
52 6.0.0.693 2025.03.25 8aac2 P P 4180 2521 2025.03.26 01:39:44.055 2025.03.26 01:39:48.235 2025.03.26 00:35:29.609 2025.03.26 00:35:32.130
53 6.0.0.693 2025.03.24 0b559 P P 4221 2518 2025.03.25 01:39:28.808 2025.03.25 01:39:33.029 2025.03.25 00:35:35.089 2025.03.25 00:35:37.607
54 6.0.0.687 2025.03.22 730aa P P 4011 2324 2025.03.24 01:40:03.166 2025.03.24 01:40:07.177 2025.03.24 00:35:49.498 2025.03.24 00:35:51.822
55 6.0.0.686 2025.03.20 71bf6 P P 3981 2578 2025.03.21 01:37:02.449 2025.03.21 01:37:06.430 2025.03.21 00:34:50.926 2025.03.21 00:34:53.504
56 6.0.0.685 2025.03.19 a8577 P P 4006 2350 2025.03.20 01:37:19.574 2025.03.20 01:37:23.580 2025.03.20 00:35:19.626 2025.03.20 00:35:21.976
57 6.0.0.680 2025.03.18 90d29 P P 3999 2312 2025.03.19 01:37:38.459 2025.03.19 01:37:42.458 2025.03.19 00:35:11.241 2025.03.19 00:35:13.553
58 6.0.0.677 2025.03.16 c0a60 P P 3994 2563 2025.03.18 01:35:45.684 2025.03.18 01:35:49.678 2025.03.18 00:35:04.734 2025.03.18 00:35:07.297
59 6.0.0.676 2025.03.15 11cfb P P 3942 2263 2025.03.16 01:34:43.972 2025.03.16 01:34:47.914 2025.03.16 00:34:36.058 2025.03.16 00:34:38.321
60 6.0.0.674 2025.03.14 7d82c P P 3957 2470 2025.03.15 01:33:42.165 2025.03.15 01:33:46.122 2025.03.15 00:34:46.777 2025.03.15 00:34:49.247
61 6.0.0.673 2025.03.13 40f5b P P 4062 2281 2025.03.14 14:05:11.803 2025.03.14 14:05:15.865 2025.03.14 13:04:55.042 2025.03.14 13:04:57.323
62 6.0.0.671 2025.03.12 a4fff P P 4175 2481 2025.03.13 01:38:34.773 2025.03.13 01:38:38.948 2025.03.13 00:35:44.824 2025.03.13 00:35:47.305
63 6.0.0.663 2025.03.11 65970 P P 4201 2274 2025.03.12 01:38:13.072 2025.03.12 01:38:17.273 2025.03.12 00:35:42.768 2025.03.12 00:35:45.042
64 6.0.0.661 2025.03.07 b9869 P P 4212 2497 2025.03.11 01:38:17.085 2025.03.11 01:38:21.297 2025.03.11 00:35:44.787 2025.03.11 00:35:47.284
65 6.0.0.660 2025.03.04 a6700 P P 4289 2530 2025.03.06 01:38:33.474 2025.03.06 01:38:37.763 2025.03.06 00:35:33.752 2025.03.06 00:35:36.282
66 6.0.0.658 2025.03.03 f15f8 P P 4062 2591 2025.03.04 01:35:56.911 2025.03.04 01:36:00.973 2025.03.04 00:35:06.445 2025.03.04 00:35:09.036
67 6.0.0.656 2025.02.27 25fb4 P P 4030 2325 2025.03.03 01:36:10.741 2025.03.03 01:36:14.771 2025.03.03 00:35:11.872 2025.03.03 00:35:14.197
68 6.0.0.655 2025.02.25 6e3e0 P P 4316 2534 2025.02.27 01:37:09.007 2025.02.27 01:37:13.323 2025.02.27 00:35:16.282 2025.02.27 00:35:18.816
69 6.0.0.654 2025.02.24 b7141 P P 4009 2524 2025.02.25 01:34:48.988 2025.02.25 01:34:52.997 2025.02.25 00:35:02.022 2025.02.25 00:35:04.546
70 6.0.0.652 2025.02.22 22662 P P 4230 2320 2025.02.24 01:33:51.020 2025.02.24 01:33:55.250 2025.02.24 00:34:39.492 2025.02.24 00:34:41.812
71 6.0.0.647 2025.02.21 9fccb P P 4009 2351 2025.02.22 01:33:12.426 2025.02.22 01:33:16.435 2025.02.22 00:34:18.938 2025.02.22 00:34:21.289
72 6.0.0.640 2025.02.19 9b8ac P P 4230 2314 2025.02.20 01:34:08.100 2025.02.20 01:34:12.330 2025.02.20 00:34:35.002 2025.02.20 00:34:37.316
73 6.0.0.639 2025.02.18 201a4 P P 4199 2471 2025.02.19 01:35:01.118 2025.02.19 01:35:05.317 2025.02.19 00:35:22.422 2025.02.19 00:35:24.893
74 6.0.0.637 2025.02.12 6d0f5 P P 4100 2339 2025.02.14 01:35:56.120 2025.02.14 01:36:00.220 2025.02.14 00:35:24.367 2025.02.14 00:35:26.706
75 6.0.0.636 2025.02.11 0424f P P 4041 2312 2025.02.12 01:35:18.723 2025.02.12 01:35:22.764 2025.02.12 00:34:58.312 2025.02.12 00:35:00.624
76 6.0.0.635 2025.02.10 f640f P P 4047 2359 2025.02.11 01:34:46.887 2025.02.11 01:34:50.934 2025.02.11 00:34:47.820 2025.02.11 00:34:50.179
77 6.0.0.629 2025.02.07 194f9 P P 4026 2346 2025.02.08 01:34:45.382 2025.02.08 01:34:49.408 2025.02.08 00:34:48.592 2025.02.08 00:34:50.938
78 6.0.0.628 2025.02.06 859d5 P P 4107 2360 2025.02.07 10:31:59.782 2025.02.07 10:32:03.889 2025.02.07 09:25:46.913 2025.02.07 09:25:49.273
79 6.0.0.621 2025.02.05 34fe7 P P 4035 2366 2025.02.07 01:42:02.120 2025.02.07 01:42:06.155 2025.02.07 00:35:22.813 2025.02.07 00:35:25.179
80 6.0.0.609 2025.02.04 76d57 P P 4032 2333 2025.02.05 01:41:50.109 2025.02.05 01:41:54.141 2025.02.05 00:35:17.134 2025.02.05 00:35:19.467
81 6.0.0.607 2025.02.03 1985b P P 4047 2353 2025.02.04 01:41:42.427 2025.02.04 01:41:46.474 2025.02.04 00:34:55.256 2025.02.04 00:34:57.609
82 6.0.0.601 2025.02.01 6af07 P P 4079 2364 2025.02.02 01:34:35.510 2025.02.02 01:34:39.589 2025.02.02 00:34:48.406 2025.02.02 00:34:50.770
83 6.0.0.600 2025.01.27 188de P P 4203 2392 2025.01.28 01:34:40.695 2025.01.28 01:34:44.898 2025.01.28 00:34:39.935 2025.01.28 00:34:42.327
84 6.0.0.599 2025.01.25 ba588 P P 4099 2303 2025.01.26 01:34:16.784 2025.01.26 01:34:20.883 2025.01.26 00:34:40.654 2025.01.26 00:34:42.957
85 6.0.0.598 2025.01.23 ddbc3 P P 4078 2327 2025.01.25 11:22:47.954 2025.01.25 11:22:52.032 2025.01.25 10:22:21.669 2025.01.25 10:22:23.996
86 6.0.0.595 2025.01.22 e62f3 P P 4043 2310 2025.01.23 01:34:28.577 2025.01.23 01:34:32.620 2025.01.23 00:34:41.367 2025.01.23 00:34:43.677
87 6.0.0.594 2025.01.21 47fb6 P P 4018 2371 2025.01.22 01:34:18.193 2025.01.22 01:34:22.211 2025.01.22 00:34:39.822 2025.01.22 00:34:42.193
88 6.0.0.590 2025.01.20 3d7c0 P P 4050 2378 2025.01.21 01:34:39.993 2025.01.21 01:34:44.043 2025.01.21 00:34:38.490 2025.01.21 00:34:40.868
89 6.0.0.588 2025.01.19 b1c4e P P 4142 2309 2025.01.20 01:34:04.107 2025.01.20 01:34:08.249 2025.01.20 00:34:35.280 2025.01.20 00:34:37.589
90 6.0.0.587 2025.01.18 63e6e P P 3999 2296 2025.01.19 01:33:47.459 2025.01.19 01:33:51.458 2025.01.19 00:34:29.796 2025.01.19 00:34:32.092
91 6.0.0.585 2025.01.16 2d6bb P P 3937 2500 2025.01.18 01:33:14.298 2025.01.18 01:33:18.235 2025.01.18 00:35:17.035 2025.01.18 00:35:19.535
92 6.0.0.584 2025.01.15 a0aa2 P P 4299 2565 2025.01.16 01:35:35.356 2025.01.16 01:35:39.655 2025.01.16 00:35:16.656 2025.01.16 00:35:19.221
93 6.0.0.581 2025.01.15 69690 P P 4256 2353 2025.01.15 17:45:33.818 2025.01.15 17:45:38.074 2025.01.15 16:44:24.864 2025.01.15 16:44:27.217
94 6.0.0.581 2025.01.14 21e9e P P 4023 2316 2025.01.15 01:35:23.624 2025.01.15 01:35:27.647 2025.01.15 00:34:56.411 2025.01.15 00:34:58.727
95 6.0.0.577 2025.01.14 91dce P P 4082 2361 2025.01.14 16:56:18.065 2025.01.14 16:56:22.147 2025.01.14 15:56:16.356 2025.01.14 15:56:18.717
96 6.0.0.577 2025.01.13 7e293 P P 4064 2340 2025.01.14 11:19:10.987 2025.01.14 11:19:15.051 2025.01.14 10:19:37.484 2025.01.14 10:19:39.824
97 6.0.0.576 2025.01.12 05898 P P 4052 2426 2025.01.13 01:35:56.345 2025.01.13 01:36:00.397 2025.01.13 00:35:19.210 2025.01.13 00:35:21.636
98 6.0.0.573 2025.01.10 c20f3 P P 4198 2544 2025.01.11 01:36:02.386 2025.01.11 01:36:06.584 2025.01.11 00:35:28.800 2025.01.11 00:35:31.344
99 6.0.0.571 2024.12.31 81bba P P 4070 2360 2025.01.01 01:34:58.089 2025.01.01 01:35:02.159 2025.01.01 00:35:10.061 2025.01.01 00:35:12.421
100 6.0.0.570 2024.12.30 c3c8d P P 4066 2632 2024.12.31 01:35:22.012 2024.12.31 01:35:26.078 2024.12.31 00:35:37.435 2024.12.31 00:35:40.067
101 6.0.0.565 2024.12.28 5fc59 P P 4065 2315 2024.12.29 17:30:33.968 2024.12.29 17:30:38.033 2024.12.29 16:30:39.406 2024.12.29 16:30:41.721
102 6.0.0.564 2024.12.26 12514 P P 4092 2315 2024.12.27 01:34:48.592 2024.12.27 01:34:52.684 2024.12.27 00:35:07.709 2024.12.27 00:35:10.024
103 6.0.0.560 2024.12.25 fa83e P P 4106 2328 2024.12.26 01:34:52.156 2024.12.26 01:34:56.262 2024.12.26 00:34:51.237 2024.12.26 00:34:53.565
104 6.0.0.559 2024.12.23 cc800 P P 4063 2303 2024.12.25 01:34:53.419 2024.12.25 01:34:57.482 2024.12.25 00:34:51.160 2024.12.25 00:34:53.463
105 6.0.0.556 2024.12.22 a0404 P P 4080 2327 2024.12.23 01:34:33.697 2024.12.23 01:34:37.777 2024.12.23 00:35:04.618 2024.12.23 00:35:06.945
106 6.0.0.555 2024.12.19 6990a P P 4285 2397 2024.12.21 12:29:40.989 2024.12.21 12:29:45.274 2024.12.21 11:29:19.044 2024.12.21 11:29:21.441
107 6.0.0.553 2024.12.17 d1f8a P P 4030 2297 2024.12.18 01:34:17.198 2024.12.18 01:34:21.228 2024.12.18 00:35:03.696 2024.12.18 00:35:05.993
108 6.0.0.552 2024.12.11 85e25 P P 4034 2308 2024.12.16 01:33:45.101 2024.12.16 01:33:49.135 2024.12.16 00:34:38.007 2024.12.16 00:34:40.315
109 6.0.0.550 2024.12.10 b37ac P P 4894 2537 2024.12.11 01:36:15.099 2024.12.11 01:36:19.993 2024.12.11 00:35:12.719 2024.12.11 00:35:15.256
110 6.0.0.548 2024.12.08 2cc77 P P 4394 2423 2024.12.09 01:38:25.730 2024.12.09 01:38:30.124 2024.12.09 00:38:16.207 2024.12.09 00:38:18.630
111 6.0.0.544 2024.12.05 96943 P P 4368 2354 2024.12.06 01:34:19.780 2024.12.06 01:34:24.148 2024.12.06 00:35:26.482 2024.12.06 00:35:28.836
112 6.0.0.543 2024.12.03 30b77 P P 4140 2351 2024.12.04 01:34:17.499 2024.12.04 01:34:21.639 2024.12.04 00:36:08.205 2024.12.04 00:36:10.556
113 6.0.0.540 2024.12.02 4a1f4 P P 4057 2339 2024.12.03 01:33:51.794 2024.12.03 01:33:55.851 2024.12.03 00:35:29.882 2024.12.03 00:35:32.221
114 6.0.0.539 2024.11.28 1f283 P P 4069 2353 2024.11.30 01:33:15.100 2024.11.30 01:33:19.169 2024.11.30 00:35:07.679 2024.11.30 00:35:10.032
115 6.0.0.535 2024.11.27 6551a P P 4071 2333 2024.11.28 01:31:59.759 2024.11.28 01:32:03.830 2024.11.28 00:34:45.577 2024.11.28 00:34:47.910
116 6.0.0.535 2024.11.26 77b95 P P 4078 2327 2024.11.27 01:32:19.903 2024.11.27 01:32:23.981 2024.11.27 00:35:01.528 2024.11.27 00:35:03.855
117 6.0.0.534 2024.11.25 e9584 P P 4079 2333 2024.11.26 01:32:31.014 2024.11.26 01:32:35.093 2024.11.26 00:34:47.014 2024.11.26 00:34:49.347
118 6.0.0.533 2024.11.17 933ac P P 4256 2321 2024.11.22 01:32:58.159 2024.11.22 01:33:02.415 2024.11.22 00:34:52.072 2024.11.22 00:34:54.393
119 6.0.0.532 2024.11.17 1a471 P P 4048 2332 2024.11.17 14:07:02.200 2024.11.17 14:07:06.248 2024.11.17 13:09:42.693 2024.11.17 13:09:45.025
120 6.0.0.532 2024.11.16 9e263 P P 4031 2315 2024.11.17 01:31:23.076 2024.11.17 01:31:27.107 2024.11.17 00:34:34.271 2024.11.17 00:34:36.586
121 6.0.0.530 2024.11.15 49804 P P 4078 2281 2024.11.16 01:30:34.530 2024.11.16 01:30:38.608 2024.11.16 00:34:42.703 2024.11.16 00:34:44.984
122 6.0.0.528 2024.11.14 9625b P P 4130 2555 2024.11.15 01:33:53.298 2024.11.15 01:33:57.428 2024.11.15 00:35:06.728 2024.11.15 00:35:09.283
123 6.0.0.526 2024.11.12 65b80 P P 4049 2323 2024.11.14 01:33:31.032 2024.11.14 01:33:35.081 2024.11.14 00:34:56.738 2024.11.14 00:34:59.061
124 6.0.0.523 2024.11.08 8ca23 P P 4020 2303 2024.11.11 01:31:43.406 2024.11.11 01:31:47.426 2024.11.11 00:34:32.601 2024.11.11 00:34:34.904
125 6.0.0.520 2024.11.08 52657 P P 4031 2282 2024.11.08 18:06:09.645 2024.11.08 18:06:13.676 2024.11.08 17:09:43.851 2024.11.08 17:09:46.133
126 6.0.0.520 2024.11.07 4eefa P P 4072 2317 2024.11.08 01:30:59.561 2024.11.08 01:31:03.633 2024.11.08 00:34:43.688 2024.11.08 00:34:46.005
127 6.0.0.516 2024.11.04 b0c36 P P 4071 2357 2024.11.05 01:32:02.447 2024.11.05 01:32:06.518 2024.11.05 00:34:33.348 2024.11.05 00:34:35.705
128 6.0.0.515 2024.10.30 d53f3 P P 4030 2311 2024.11.04 01:31:37.471 2024.11.04 01:31:41.501 2024.11.04 00:34:43.343 2024.11.04 00:34:45.654
129 6.0.0.512 2024.10.29 833ef P P 4119 2409 2024.10.30 01:33:40.779 2024.10.30 01:33:44.898 2024.10.30 00:35:11.728 2024.10.30 00:35:14.137
130 6.0.0.511 2024.10.26 c4bc9 P P 4097 2344 2024.10.29 01:33:27.491 2024.10.29 01:33:31.588 2024.10.29 00:34:54.235 2024.10.29 00:34:56.579
131 6.0.0.508 2024.10.24 a8f5b P P 4143 2350 2024.10.26 09:40:06.830 2024.10.26 09:40:10.973 2024.10.26 08:41:29.114 2024.10.26 08:41:31.464
132 6.0.0.502 2024.10.22 6bfd7 P P 4313 2353 2024.10.23 01:32:57.030 2024.10.23 01:33:01.343 2024.10.23 00:34:55.461 2024.10.23 00:34:57.814
133 6.0.0.500 2024.10.21 be565 P P 4082 2338 2024.10.22 01:33:22.734 2024.10.22 01:33:26.816 2024.10.22 00:35:10.219 2024.10.22 00:35:12.557
134 6.0.0.499 2024.10.19 6214b P P 4047 2578 2024.10.20 01:32:44.179 2024.10.20 01:32:48.226 2024.10.20 00:34:56.715 2024.10.20 00:34:59.293
135 6.0.0.498 2024.10.18 591a7 P P 4078 2302 2024.10.19 01:32:10.582 2024.10.19 01:32:14.660 2024.10.19 00:34:36.296 2024.10.19 00:34:38.598
136 6.0.0.494 2024.10.17 042ce P P 4078 2328 2024.10.18 01:32:50.010 2024.10.18 01:32:54.088 2024.10.18 00:34:43.224 2024.10.18 00:34:45.552
137 6.0.0.491 2024.10.14 dc5fb P P 4325 2325 2024.10.15 01:32:29.030 2024.10.15 01:32:33.355 2024.10.15 00:34:31.448 2024.10.15 00:34:33.773
138 6.0.0.489 2024.10.11 2ba59 P P 4072 2360 2024.10.12 01:31:35.418 2024.10.12 01:31:39.490 2024.10.12 00:34:16.711 2024.10.12 00:34:19.071
139 6.0.0.488 2024.10.09 1c93e P P 4011 2535 2024.10.10 01:31:54.649 2024.10.10 01:31:58.660 2024.10.10 00:34:54.769 2024.10.10 00:34:57.304
140 6.0.0.487 2024.10.06 065a3 P P 4133 2331 2024.10.07 01:33:16.675 2024.10.07 01:33:20.808 2024.10.07 00:35:03.209 2024.10.07 00:35:05.540
141 6.0.0.485 2024.10.05 9f5f7 P P 4124 2411 2024.10.06 01:32:54.257 2024.10.06 01:32:58.381 2024.10.06 00:35:04.899 2024.10.06 00:35:07.310
142 6.0.0.485 2024.10.04 e95c1 P P 4094 2315 2024.10.05 01:32:30.333 2024.10.05 01:32:34.427 2024.10.05 00:34:47.784 2024.10.05 00:34:50.099
143 6.0.0.483 2024.10.02 5e5ae P P 4321 2344 2024.10.03 01:33:31.817 2024.10.03 01:33:36.138 2024.10.03 00:35:27.358 2024.10.03 00:35:29.702
144 6.0.0.478 2024.09.30 b5010 P P 4059 2355 2024.10.01 01:33:00.820 2024.10.01 01:33:04.879 2024.10.01 00:34:46.696 2024.10.01 00:34:49.051
145 6.0.0.474 2024.09.26 e4efb P P 4079 2376 2024.09.30 01:32:36.900 2024.09.30 01:32:40.979 2024.09.30 00:34:56.611 2024.09.30 00:34:58.987
146 6.0.0.471 2024.09.25 dab71 P P 4074 2334 2024.09.26 01:32:45.022 2024.09.26 01:32:49.096 2024.09.26 00:34:59.469 2024.09.26 00:35:01.803
147 6.0.0.471 2024.09.24 01b51 P P 4048 2404 2024.09.25 01:33:31.054 2024.09.25 01:33:35.102 2024.09.25 00:35:04.398 2024.09.25 00:35:06.802
148 6.0.0.470 2024.09.23 77cc0 P P 4083 2330 2024.09.24 01:32:42.064 2024.09.24 01:32:46.147 2024.09.24 00:35:15.769 2024.09.24 00:35:18.099
149 6.0.0.467 2024.09.21 ea0b8 P P 4109 2566 2024.09.23 01:33:53.570 2024.09.23 01:33:57.679 2024.09.23 00:35:38.717 2024.09.23 00:35:41.283
150 6.0.0.466 2024.09.20 32dc6 P P 4062 2354 2024.09.21 01:32:16.420 2024.09.21 01:32:20.482 2024.09.21 00:34:56.617 2024.09.21 00:34:58.971
151 6.0.0.461 2024.09.17 2c895 P P 4087 2272 2024.09.18 01:31:29.634 2024.09.18 01:31:33.721 2024.09.18 00:34:10.733 2024.09.18 00:34:13.005
152 6.0.0.460 2024.09.11 3c253 P P 4049 2310 2024.09.17 01:31:32.777 2024.09.17 01:31:36.826 2024.09.17 00:34:20.779 2024.09.17 00:34:23.089
153 6.0.0.457 2024.09.09 fdc6f P P 4089 2314 2024.09.10 01:32:19.893 2024.09.10 01:32:23.982 2024.09.10 00:34:46.912 2024.09.10 00:34:49.226
154 6.0.0.455 2024.09.07 500d8 P P 4078 2389 2024.09.08 01:32:44.438 2024.09.08 01:32:48.516 2024.09.08 00:35:14.929 2024.09.08 00:35:17.318
155 6.0.0.454 2024.09.05 4d70f P P 4067 2339 2024.09.06 01:32:51.906 2024.09.06 01:32:55.973 2024.09.06 00:34:51.353 2024.09.06 00:34:53.692
156 6.0.0.452 2024.09.04 9ff9c P P 4086 2289 2024.09.05 01:32:25.897 2024.09.05 01:32:29.983 2024.09.05 00:35:00.708 2024.09.05 00:35:02.997
157 6.0.0.450 2024.09.02 27124 P P 4088 2305 2024.09.04 01:32:57.947 2024.09.04 01:33:02.035 2024.09.04 00:35:00.074 2024.09.04 00:35:02.379
158 6.0.0.447 2024.09.01 901b4 P P 4295 2335 2024.09.02 01:22:52.417 2024.09.02 01:22:56.712 2024.09.02 00:24:54.076 2024.09.02 00:24:56.411
159 6.0.0.446 2024.08.30 fe1b2 P P 4087 2311 2024.09.01 01:21:33.881 2024.09.01 01:21:37.968 2024.09.01 00:24:49.030 2024.09.01 00:24:51.341
160 6.0.0.444 2024.08.28 785d4 P P 4128 2365 2024.08.30 01:21:25.325 2024.08.30 01:21:29.453 2024.08.30 00:25:09.891 2024.08.30 00:25:12.256
161 6.0.0.442 2024.08.21 4a68f P P 4094 2320 2024.08.28 01:21:34.560 2024.08.28 01:21:38.654 2024.08.28 00:24:58.655 2024.08.28 00:25:00.975
162 6.0.0.441 2024.08.20 75042 P P 4068 2295 2024.08.21 01:20:15.740 2024.08.21 01:20:19.808 2024.08.21 00:24:31.789 2024.08.21 00:24:34.084
163 6.0.0.438 2024.08.16 088b5 P P 4098 2412 2024.08.19 01:22:26.023 2024.08.19 01:22:30.121 2024.08.19 00:24:45.903 2024.08.19 00:24:48.315
164 6.0.0.437 2024.08.14 3c88b P P 4240 2573 2024.08.16 01:25:18.454 2024.08.16 01:25:22.694 2024.08.16 00:25:46.043 2024.08.16 00:25:48.616
165 6.0.0.436 2024.08.13 b8e75 P P 4243 2377 2024.08.14 01:24:11.008 2024.08.14 01:24:15.251 2024.08.14 00:25:38.229 2024.08.14 00:25:40.606
166 6.0.0.432 2024.08.11 e82ac P P 4142 2364 2024.08.13 01:23:07.485 2024.08.13 01:23:11.627 2024.08.13 00:25:12.733 2024.08.13 00:25:15.097
167 6.0.0.431 2024.08.11 16bb1 P P 4158 2375 2024.08.11 17:28:17.860 2024.08.11 17:28:22.018 2024.08.11 16:30:21.519 2024.08.11 16:30:23.894
168 6.0.0.431 2024.08.09 de5a7 P P 4175 2359 2024.08.10 17:01:58.342 2024.08.10 17:02:02.517 2024.08.10 16:04:33.364 2024.08.10 16:04:35.723
169 6.0.0.428 2024.08.08 9191b P P 4336 2385 2024.08.10 01:22:27.043 2024.08.10 01:22:31.379 2024.08.10 00:25:16.234 2024.08.10 00:25:18.619
170 6.0.0.423 2024.08.07 33b41 P P 4132 2345 2024.08.08 08:21:46.264 2024.08.08 08:21:50.396 2024.08.08 07:24:33.464 2024.08.08 07:24:35.809
171 6.0.0.421 2024.08.06 ed60d P P 4155 2284 2024.08.07 01:19:03.705 2024.08.07 01:19:07.860 2024.08.07 00:24:24.247 2024.08.07 00:24:26.531
172 6.0.0.419 2024.08.05 3505a P P 4505 2267 2024.08.06 01:17:30.008 2024.08.06 01:17:34.513 2024.08.06 00:24:15.966 2024.08.06 00:24:18.233
173 6.0.0.409 2024.08.02 ec18f P P 4218 2344 2024.08.05 01:16:50.791 2024.08.05 01:16:55.009 2024.08.05 00:23:45.578 2024.08.05 00:23:47.922
174 6.0.0.406 2024.08.01 b20be P P 4166 2397 2024.08.02 01:15:27.595 2024.08.02 01:15:31.761 2024.08.02 00:23:13.043 2024.08.02 00:23:15.440
175 6.0.0.405 2024.07.31 a62ac P P 4238 2531 2024.08.01 01:23:00.609 2024.08.01 01:23:04.847 2024.08.01 00:26:27.977 2024.08.01 00:26:30.508
176 6.0.0.403 2024.07.29 30f03 P P 4255 2418 2024.07.30 01:18:12.306 2024.07.30 01:18:16.561 2024.07.30 00:24:02.076 2024.07.30 00:24:04.494
177 6.0.0.401 2024.07.26 24e41 P P 4306 2372 2024.07.27 01:17:39.716 2024.07.27 01:17:44.022 2024.07.27 00:23:49.823 2024.07.27 00:23:52.195
178 6.0.0.400 2024.07.24 5bb78 P P 4327 2391 2024.07.25 01:18:15.766 2024.07.25 01:18:20.093 2024.07.25 00:23:52.811 2024.07.25 00:23:55.202
179 6.0.0.398 2024.07.23 85b18 P P 4349 2474 2024.07.24 01:41:11.695 2024.07.24 01:41:16.044 2024.07.24 00:23:53.122 2024.07.24 00:23:55.596
180 6.0.0.397 2024.07.22 c734c P P 4252 2403 2024.07.23 01:18:05.443 2024.07.23 01:18:09.695 2024.07.23 00:24:00.084 2024.07.23 00:24:02.487
181 6.0.0.396 2024.07.13 cf952 P P 4555 2407 2024.07.22 01:18:19.555 2024.07.22 01:18:24.110 2024.07.22 00:24:04.047 2024.07.22 00:24:06.454
182 6.0.0.395 2024.07.10 845f4 P P 4204 2328 2024.07.13 01:17:11.479 2024.07.13 01:17:15.683 2024.07.13 00:23:43.014 2024.07.13 00:23:45.342
183 6.0.0.392 2024.07.09 ea301 P P 4198 2322 2024.07.10 01:19:41.223 2024.07.10 01:19:45.421 2024.07.10 00:24:09.391 2024.07.10 00:24:11.713
184 6.0.0.391 2024.07.08 7d50c P P 4349 2386 2024.07.09 01:20:27.225 2024.07.09 01:20:31.574 2024.07.09 00:24:28.512 2024.07.09 00:24:30.898
185 6.0.0.389 2024.07.05 cc71c P P 4638 2415 2024.07.06 01:21:07.787 2024.07.06 01:21:12.425 2024.07.06 00:24:47.251 2024.07.06 00:24:49.666
186 6.0.0.388 2024.06.30 e5700 P P 4383 2411 2024.07.01 01:21:21.092 2024.07.01 01:21:25.475 2024.07.01 00:24:39.107 2024.07.01 00:24:41.518
187 6.0.0.387 2024.06.27 7c28a P P 4328 2620 2024.06.28 01:21:05.410 2024.06.28 01:21:09.738 2024.06.28 00:24:55.225 2024.06.28 00:24:57.845
188 6.0.0.386 2024.06.23 7c57f P P 4242 2379 2024.06.24 01:18:19.196 2024.06.24 01:18:23.438 2024.06.24 00:24:18.451 2024.06.24 00:24:20.830
189 6.0.0.384 2024.06.21 24d99 P P 4501 2386 2024.06.22 01:15:36.217 2024.06.22 01:15:40.718 2024.06.22 00:23:13.875 2024.06.22 00:23:16.261
190 6.0.0.374 2024.06.13 0097d P P 4326 2364 2024.06.21 18:02:24.849 2024.06.21 18:02:29.175 2024.06.21 17:10:06.273 2024.06.21 17:10:08.637
191 6.0.0.373 2024.06.09 363f0 P P 4938 1735 2024.06.12 23:18:12.280 2024.06.12 23:18:17.218 2024.06.12 22:31:01.737 2024.06.12 22:31:03.472
192 6.0.0.372 2024.06.08 9e7f2 P P 4063 1719 2024.06.09 18:45:43.342 2024.06.09 18:45:47.405 2024.06.09 17:59:55.665 2024.06.09 17:59:57.384
193 6.0.0.368 2024.06.03 25f3e P P 4547 2359 2024.06.15 11:38:43.156 2024.06.15 11:38:47.703 2024.06.15 10:48:06.920 2024.06.15 10:48:09.279
194 6.0.0.366 2024.05.28 8e46f P P 4079 1735 2024.06.10 19:39:36.025 2024.06.10 19:39:40.104 2024.06.10 18:53:39.305 2024.06.10 18:53:41.040
195 6.0.0.363 2024.05.28 95442 P P 4079 1750 2024.06.10 15:59:48.209 2024.06.10 15:59:52.288 2024.06.10 15:13:51.970 2024.06.10 15:13:53.720
196 6.0.0.363 2024.05.28 40d0b P P 4094 1735 2024.06.10 17:53:06.886 2024.06.10 17:53:10.980 2024.06.10 17:07:13.067 2024.06.10 17:07:14.802
197 6.0.0.362 2024.05.24 ecc49 P P 4720 1719 2024.05.24 23:18:06.566 2024.05.24 23:18:11.286 2024.05.24 22:31:04.560 2024.05.24 22:31:06.279
198 6.0.0.359 2024.05.23 9cb11 P P 4704 1719 2024.05.23 23:18:40.628 2024.05.23 23:18:45.332 2024.05.23 22:31:26.580 2024.05.23 22:31:28.299
199 6.0.0.358 2024.05.21 995dd P P 4704 1734 2024.05.22 23:18:23.277 2024.05.22 23:18:27.981 2024.05.22 22:31:04.409 2024.05.22 22:31:06.143
200 6.0.0.357 2024.05.18 bf6c4 P P 4782 1719 2024.05.20 23:17:54.446 2024.05.20 23:17:59.228 2024.05.20 22:31:03.165 2024.05.20 22:31:04.884
201 6.0.0.356 2024.05.17 eab06 P P 4672 1734 2024.05.17 23:17:59.072 2024.05.17 23:18:03.744 2024.05.17 22:31:26.105 2024.05.17 22:31:27.839
202 6.0.0.355 2024.05.16 8dd6e P P 4829 1735 2024.05.16 23:17:53.923 2024.05.16 23:17:58.752 2024.05.16 22:31:09.438 2024.05.16 22:31:11.173
203 6.0.0.354 2024.05.15 d3adc P P 4797 1703 2024.05.15 23:18:11.592 2024.05.15 23:18:16.389 2024.05.15 22:31:26.249 2024.05.15 22:31:27.952
204 6.0.0.351 2024.05.14 2e3e0 P P 4703 1735 2024.05.14 23:17:41.726 2024.05.14 23:17:46.429 2024.05.14 22:31:05.182 2024.05.14 22:31:06.917
205 6.0.0.348 2024.05.08 e1ec4 P P 4704 1751 2024.05.13 23:18:03.498 2024.05.13 23:18:08.202 2024.05.13 22:31:25.493 2024.05.13 22:31:27.244
206 6.0.0.346 2024.05.07 9d7de P P 4766 1735 2024.05.07 23:18:15.108 2024.05.07 23:18:19.874 2024.05.07 22:31:23.351 2024.05.07 22:31:25.086
207 6.0.0.345 2024.05.06 154a0 P P 4719 1797 2024.05.06 23:17:50.080 2024.05.06 23:17:54.799 2024.05.06 22:31:05.116 2024.05.06 22:31:06.913
208 6.0.0.344 2024.05.02 b49d8 P P 4703 2703 2024.05.02 23:17:15.195 2024.05.02 23:17:19.898 2024.05.02 22:30:52.029 2024.05.02 22:30:54.732
209 6.0.0.342 2024.04.29 e6247 P P 4688 1734 2024.04.29 23:17:27.579 2024.04.29 23:17:32.267 2024.04.29 22:31:12.159 2024.04.29 22:31:13.893
210 6.0.0.339 2024.04.28 0bcba P P 4688 1703 2024.04.28 23:17:15.159 2024.04.28 23:17:19.847 2024.04.28 22:30:52.941 2024.04.28 22:30:54.644
211 6.0.0.336 2024.04.24 7d2ac P P 4704 1734 2024.04.26 23:17:15.284 2024.04.26 23:17:19.988 2024.04.26 22:30:56.794 2024.04.26 22:30:58.528
212 6.0.0.333 2024.04.23 85d98 P P 4688 1735 2024.04.23 23:17:50.606 2024.04.23 23:17:55.294 2024.04.23 22:31:13.650 2024.04.23 22:31:15.385
213 6.0.0.328 2024.04.22 485d0 P P 4735 1735 2024.04.22 23:17:25.592 2024.04.22 23:17:30.327 2024.04.22 22:30:56.792 2024.04.22 22:30:58.527
214 6.0.0.327 2024.04.19 eeed9 P P 4688 1734 2024.04.21 23:17:50.696 2024.04.21 23:17:55.384 2024.04.21 22:31:16.637 2024.04.21 22:31:18.371
215 6.0.0.325 2024.04.18 f5930 P P 4797 1734 2024.04.18 23:17:30.990 2024.04.18 23:17:35.787 2024.04.18 22:30:54.718 2024.04.18 22:30:56.452
216 6.0.0.324 2024.04.17 84ac9 P P 4657 1734 2024.04.17 23:17:38.786 2024.04.17 23:17:43.443 2024.04.17 22:31:16.655 2024.04.17 22:31:18.389
217 6.0.0.321 2024.04.16 eba22 P P 4719 1735 2024.04.16 23:17:07.750 2024.04.16 23:17:12.469 2024.04.16 22:30:58.959 2024.04.16 22:31:00.694
218 6.0.0.315 2024.04.15 4e80d P P 4703 1750 2024.04.15 23:17:35.247 2024.04.15 23:17:39.950 2024.04.15 22:31:12.943 2024.04.15 22:31:14.693
219 6.0.0.313 2024.04.14 b6eab P P 3891 1688 2024.04.14 23:15:54.600 2024.04.14 23:15:58.491 2024.04.14 22:31:14.211 2024.04.14 22:31:15.899
220 6.0.0.313 2024.04.12 aaf5f P P 3938 1703 2024.04.12 23:15:31.461 2024.04.12 23:15:35.399 2024.04.12 22:30:54.889 2024.04.12 22:30:56.592
221 6.0.0.312 2024.04.12 ff9f0 P P 3922 1687 2024.04.12 10:02:35.634 2024.04.12 10:02:39.556 2024.04.12 09:18:13.934 2024.04.12 09:18:15.621
222 6.0.0.312 2024.04.04 3496c P P 3750 1562 2024.04.09 23:16:02.355 2024.04.09 23:16:06.105 2024.04.09 22:31:35.212 2024.04.09 22:31:36.774
223 6.0.0.310 2024.04.03 e93f6 P P 3798 1547 2024.04.04 09:28:56.970 2024.04.04 09:29:00.768 2024.04.04 08:46:34.200 2024.04.04 08:46:35.747
224 6.0.0.308 2024.04.03 fa979 P P 3766 1578 2024.04.03 16:42:18.479 2024.04.03 16:42:22.245 2024.04.03 16:00:03.269 2024.04.03 16:00:04.847
225 6.0.0.308 2024.04.02 65562 P P 3798 1548 2024.04.03 00:22:44.629 2024.04.03 00:22:48.427 2024.04.02 23:41:13.623 2024.04.02 23:41:15.171
226 6.0.0.305 2024.04.01 8a4f6 P P 3813 1562 2024.04.02 08:35:09.943 2024.04.02 08:35:13.756 2024.04.02 07:53:34.521 2024.04.02 07:53:36.083
227 6.0.0.303 2024.03.31 ecb39 P P 3870 1546 2024.04.01 08:41:03.740 2024.04.01 08:41:07.610 2024.04.01 05:20:40.594 2024.04.01 05:20:42.140
228 6.0.0.301 2024.03.25 69d0a P P 3765 1546 2024.03.28 22:39:30.164 2024.03.28 22:39:33.929 2024.03.28 21:58:01.287 2024.03.28 21:58:02.833
229 6.0.0.299 2024.03.22 b1ba8 P P 3765 1546 2024.03.24 00:09:18.549 2024.03.24 00:09:22.314 2024.03.23 23:26:49.259 2024.03.23 23:26:50.805
230 6.0.0.295 2024.03.22 ef66a P P 3765 1546 2024.03.22 13:00:07.037 2024.03.22 13:00:10.802 2024.03.22 12:17:42.806 2024.03.22 12:17:44.352
231 6.0.0.295 2024.03.21 bf5ab P P 3781 1546 2024.03.21 22:20:06.941 2024.03.21 22:20:10.722 2024.03.21 21:37:37.571 2024.03.21 21:37:39.117
232 6.0.0.294 2024.03.20 bd00d P P 3749 1530 2024.03.21 01:22:59.372 2024.03.21 01:23:03.121 2024.03.21 00:40:38.788 2024.03.21 00:40:40.318
233 6.0.0.293 2024.03.20 fb994 P P 3750 1531 2024.03.20 17:55:34.595 2024.03.20 17:55:38.345 2024.03.20 17:12:39.134 2024.03.20 17:12:40.665

Elapsed time, ms. Chart for last 150 runs:

Last commits information (all timestamps in UTC):