pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #18779: Segmentation fault while trying to connect via psql
3+ messages / 3 participants
[nested] [flat]

* BUG #18779: Segmentation fault while trying to connect via psql
@ 2025-01-17 11:36  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2025-01-17 11:36 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: dan-eli@mail.ru

The following bug has been logged on the website:

Bug reference:      18779
Logged by:          Daniel Elishakov
Email address:      dan-eli@mail.ru
PostgreSQL version: 16.6
Operating system:   Debian GNU/Linux 12 (bookworm)
Description:        

This bug takes place in Debian-based operating systems. To replicate this
bug please do following:
1) Install and initialize PostgreSQL dbms
2) Switch user to root (sudo -i)
3) Switch user to postgres
4) run command psql -U postgres -h localhost (may run multiple times to see
the bug)

Looks like this bug occurs because root user has ENV variable KRB5CCNAME,
while postgres does not. Please try to check it in other PostgreSQL versions
and other Debian linuxes.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #18779: Segmentation fault while trying to connect via psql
@ 2025-01-19 02:32  Jeff Janes <jeff.janes@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Jeff Janes @ 2025-01-19 02:32 UTC (permalink / raw)
  To: dan-eli@mail.ru; pgsql-bugs@lists.postgresql.org

On Fri, Jan 17, 2025 at 6:51 AM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      18779
> Logged by:          Daniel Elishakov
> Email address:      dan-eli@mail.ru
> PostgreSQL version: 16.6
> Operating system:   Debian GNU/Linux 12 (bookworm)
> Description:
>
> This bug takes place in Debian-based operating systems. To replicate this
> bug please do following:
> 1) Install and initialize PostgreSQL dbms
>

I think we need more details. There are multiple ways to do both of those
things.


> 2) Switch user to root (sudo -i)
> 3) Switch user to postgres
>

What if you just use one command, sudo -i -u postgres?


> 4) run command psql -U postgres -h localhost (may run multiple times to see
> the bug)
>
> Looks like this bug occurs because root user has ENV variable KRB5CCNAME,
> while postgres does not.


What did you do to make this happen?  A default debian installation does
have KRB5CCNAME set for root.

Cheers,

Jeff

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

*  Re: BUG #18779: Segmentation fault while trying to connect via psql
@ 2025-01-22 08:28  Даниил Элишаков <dan-eli@mail.ru>
  parent: Jeff Janes <jeff.janes@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Даниил Элишаков @ 2025-01-22 08:28 UTC (permalink / raw)
  To: Jeff Janes <jeff.janes@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org



Here is a gif with bug scenario. Gif starts while already being switched to root user. The phrase ‘’Ошибка сегментирования’’ stands for Segmentation fault. Sorry for mixing up the issue and it’s possible causes in the previous letter. Hope this gif will make it clear
 
Regards,
Daniil  
>Воскресенье, 19 января 2025, 5:32 +03:00 от Jeff Janes <jeff.janes@gmail.com>:
> 
>On Fri, Jan 17, 2025 at 6:51AM PG Bug reporting form < noreply@postgresql.org > wrote:
>>The following bug has been logged on the website:
>>
>>Bug reference:      18779
>>Logged by:          Daniel Elishakov
>>Email address:       dan-eli@mail.ru
>>PostgreSQL version: 16.6
>>Operating system:   Debian GNU/Linux 12 (bookworm)
>>Description:       
>>
>>This bug takes place in Debian-based operating systems. To replicate this
>>bug please do following:
>>1) Install and initialize PostgreSQL dbms
> 
>I think we need more details. There are multiple ways to do both of those things.
>  
>>2) Switch user to root (sudo -i)
>>3) Switch user to postgres
> 
>What if you just use one command, sudo -i -u postgres?
>  
>>4) run command psql -U postgres -h localhost (may run multiple times to see
>>the bug)
>>
>>Looks like this bug occurs because root user has ENV variable KRB5CCNAME,
>>while postgres does not.
> 
>What did you do to make this happen?  A default debian installation does have KRB5CCNAME set for root.
> 
>Cheers,
> 
>Jeff 
 
 
С уважением,
Даниил Элишаков
dan-eli@mail.ru
 

Attachments:

bug_seg_fault.gif (image/gif, 483.5K) download view image
^ permalink raw reply [nested|flat] 3+ messages in thread


end of thread, other threads:[~2025-01-22 08:28 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-17 11:36 BUG #18779: Segmentation fault while trying to connect via psql PG Bug reporting form <noreply@postgresql.org>
2025-01-19 02:32 ` Jeff Janes <jeff.janes@gmail.com>
2025-01-22 08:28   ` Даниил Элишаков <dan-eli@mail.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox