odyssey icon indicating copy to clipboard operation
odyssey copied to clipboard

Database name is cropped in "show pools" output (but not in "show clients")

Open Firm opened this issue 3 years ago • 6 comments

Hi,

I have following databases in odyssey.conf:

database "dbmine" {
# skipped
}

database "dbmine_web" {
# skipped
}

database "dbmine_wrk" {
# skipped
}

I see connections to all these entries in show clients output (in database field). But show pools command displays all databases as dbmine, stripping suffixes.

Regards,

Firm avatar Sep 11 '21 15:09 Firm

Hmm, I had observed similar bug few times but could not reproduce this. Did you reload config? Or how do you achieve this?

x4m avatar Sep 11 '21 16:09 x4m

I tried:

  • reloading config by sending -HUP to odyssey process
  • restarting odyssey completely
  • replacing underscores with dashes

No luck so far.

Firm avatar Sep 11 '21 17:09 Firm

So do you observe problem constantly or absence of problem?

x4m avatar Sep 11 '21 17:09 x4m

Constantly. Moreover, it looks that user field is affected too (only first 6 characters). And this happens only for show pools command's output.

Firm avatar Sep 11 '21 17:09 Firm

Stats output (to file, like /var/log/odyssey.log) is affected too.

Firm avatar Sep 12 '21 20:09 Firm

We also encountered this after switching from pgbouncer about 2 years ago

uspen avatar Jul 27 '22 14:07 uspen