Jetbrains datagrip startup queries

Báo cáo chỉ chứa các nhật ký khởi động của DataGrip 2025.2.3 và không nêu tệp hoặc bài kiểm thử nào. Tái hiện kết nối với frontend của giao thức PostgreSQL, xác định truy vấn khởi động hoặc hành vi khi thiếu role nào là bất ngờ, và định nghĩa một bài kiểm thử thất bại ghi nhận kết quả mong đợi.

2025-09-14 11:23:18.048 UTC [70] FATAL:  role "sunng" does not exist
2025-09-14 11:23:26.328 UTC [71] FATAL:  role "sunng" does not exist
2025-09-14 11:24:01.803 UTC [73] LOG:  execute <unnamed>: SET extra_float_digits = 3
2025-09-14 11:24:01.810 UTC [73] LOG:  execute <unnamed>: SET application_name = ''
2025-09-14 11:24:01.853 UTC [73] LOG:  execute <unnamed>: select version()
2025-09-14 11:24:01.887 UTC [73] LOG:  execute <unnamed>: SET application_name = 'DataGrip 2025.2.3'
2025-09-14 11:24:01.965 UTC [73] LOG:  execute <unnamed>: select current_database() as a, current_schemas(false) as b
2025-09-14 11:24:02.019 UTC [73] LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2025-09-14 11:24:02.084 UTC [74] LOG:  execute <unnamed>: SET extra_float_digits = 3
2025-09-14 11:24:02.089 UTC [74] LOG:  execute <unnamed>: SET application_name = ''
2025-09-14 11:24:02.095 UTC [74] LOG:  execute <unnamed>: select version()
2025-09-14 11:24:02.107 UTC [74] LOG:  execute <unnamed>: SET application_name = 'DataGrip 2025.2.3'
2025-09-14 11:24:02.137 UTC [74] LOG:  execute <unnamed>: select current_database() as a, current_schemas(false) as b
2025-09-14 11:24:02.163 UTC [74] LOG:  execute <unnamed>: select current_database(), current_schema(), current_user
2025-09-14 11:24:02.206 UTC [74] LOG:  execute <unnamed>: select round(extract(epoch from pg_postmaster_start_time() at time zone 'UTC')) as startup_time
2025-09-14 11:24:02.273 UTC [74] LOG:  execute <unnamed>: select L.transactionid::varchar::bigint as transaction_id
        from pg_catalog.pg_locks L
        where L.transactionid is not null
        order by pg_catalog.age(L.transactionid) desc
        limit 1
2025-09-14 11:24:02.293 UTC [74] LOG:  execute <unnamed>: select case
          when pg_catalog.pg_is_in_recovery()
            then null
          else
            (pg_catalog.txid_current() % 4294967296)::varchar::bigint
          end as current_txid
2025-09-14 11:24:02.313 UTC [74] LOG:  execute <unnamed>: select N.oid::bigint as id,
               datname as name,
               D.description,
               datistemplate as is_template,
               datallowconn as allow_connections,
               pg_catalog.pg_get_userbyid(N.datdba) as "owner"
        from pg_catalog.pg_database N
          left join pg_catalog.pg_shdescription D on N.oid = D.objoid
        order by case when datname = pg_catalog.current_database() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.358 UTC [74] LOG:  execute <unnamed>: select N.oid::bigint as id,
               N.xmin as state_number,
               nspname as name,
               D.description,
               pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
        from pg_catalog.pg_namespace N
          left join pg_catalog.pg_description D on N.oid = D.objoid
        order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.372 UTC [74] LOG:  execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid   FROM pg_catalog.pg_type   LEFT JOIN (sel
2025-09-14 11:24:02.372 UTC [74] DETAIL:  Parameters: $1 = '28'
2025-09-14 11:24:02.429 UTC [74] LOG:  execute <unnamed>: show DateStyle
2025-09-14 11:24:02.449 UTC [74] LOG:  execute <unnamed>: select name, is_dst from pg_catalog.pg_timezone_names
        union distinct
        select abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs
2025-09-14 11:24:02.658 UTC [74] LOG:  execute <unnamed>: select R.oid::bigint as role_id, rolname as role_name,
          rolsuper is_super, rolinherit is_inherit,
          rolcreaterole can_createrole, rolcreatedb can_createdb,
          rolcanlogin can_login, rolreplication /* false */ is_replication,
          rolconnlimit conn_limit, rolvaliduntil valid_until,
          rolbypassrls /* false */ bypass_rls, rolconfig config,
          D.description
        from pg_catalog.pg_roles R
          left join pg_catalog.pg_shdescription D on D.objoid = R.oid
2025-09-14 11:24:02.687 UTC [74] LOG:  execute <unnamed>: select member id, roleid role_id, admin_option
                  from pg_catalog.pg_auth_members order by id, roleid::text
2025-09-14 11:24:02.710 UTC [74] LOG:  execute <unnamed>: select T.oid::bigint as id, T.spcname as name,
               T.xmin as state_number, pg_catalog.pg_get_userbyid(T.spcowner) as owner,
               pg_catalog.pg_tablespace_location(T.oid) /* null */ as location,
               T.spcoptions /* null */ as options,
               D.description as comment
        from pg_catalog.pg_tablespace T
          left join pg_catalog.pg_shdescription D on D.objoid = T.oid
        --  where pg_catalog.age(T.xmin) <= #TXAGE
2025-09-14 11:24:02.735 UTC [74] LOG:  execute <unnamed>: select T.oid as object_id,
                         T.spcacl as acl
                  from pg_catalog.pg_tablespace T
                  union all
                  select T.oid as object_id,
                         T.datacl as acl
                  from pg_catalog.pg_database T
2025-09-14 11:24:02.745 UTC [74] LOG:  execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid   FROM pg_catalog.pg_type   LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas(false))[s.r] as nspname                    from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE pg_type.oid = $1  ORDER BY sp.r, pg_type.oid DESC
2025-09-14 11:24:02.745 UTC [74] DETAIL:  Parameters: $1 = '1034'
2025-09-14 11:24:02.751 UTC [74] LOG:  execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
2025-09-14 11:24:02.751 UTC [74] DETAIL:  Parameters: $1 = '1034'
2025-09-14 11:24:02.757 UTC [74] LOG:  execute <unnamed>: SELECT e.oid, n.nspname = ANY(current_schemas(true)), n.nspname, e.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_type e ON t.typelem = e.oid JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1
2025-09-14 11:24:02.757 UTC [74] DETAIL:  Parameters: $1 = '1034'
2025-09-14 11:24:02.762 UTC [74] LOG:  execute <unnamed>: SELECT typinput='pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid   FROM pg_catalog.pg_type   LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas(false))[s.r] as nspname                    from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE pg_type.oid = $1  ORDER BY sp.r, pg_type.oid DESC
2025-09-14 11:24:02.762 UTC [74] DETAIL:  Parameters: $1 = '1033'
2025-09-14 11:24:02.799 UTC [74] LOG:  execute <unnamed>: select N.oid::bigint as id,
               N.xmin as state_number,
               nspname as name,
               D.description,
               pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
        from pg_catalog.pg_namespace N
          left join pg_catalog.pg_description D on N.oid = D.objoid
        order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end
2025-09-14 11:24:02.820 UTC [74] LOG:  execute <unnamed>: select N.oid::bigint as id,
               N.xmin as state_number,
               nspname as name,
               D.description,
               pg_catalog.pg_get_userbyid(N.nspowner) as "owner"
        from pg_catalog.pg_namespace N
          left join pg_catalog.pg_description D on N.oid = D.objoid
        order by case when nspname = pg_catalog.current_schema() then -1::bigint else N.oid::bigint end