datafusion-contrib / datafusion-contrib/datafusion-postgres
Jetbrains datagrip startup queries
Open
Nobody has claimed this yet.
module:pg_catalog
- Dominant language
- Rust
- Stars
- 160
- Forks
- 44
- Avg merge
- 1d 4h
- Merged PRs (30d)
- 14
Description
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The report contains only DataGrip 2025.2.3 startup logs and no named file or test. Reproduce the connection against the PostgreSQL protocol frontend, identify which startup query or missing-role behavior is unexpected, and define a failing test that captures the expected result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, rust
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100