Streaming Replication, can't select row in backup without specifying collation

2022-07-25 Thread Kelly Burkhart
I have a primary and backup database running 12.10 and synced with streaming replication. I have a simple table that is returning different results for the same query in the primary vs backup database. On the primary DB: > select tag::bytea, * from sentinel where tag = 'quote_merge_locs_mnj_NSX_

Re: Crash and core on 10.1 and 10.2

2018-03-08 Thread Kelly Burkhart
.4 without any issue for a very long time. (Although we use no json or gin stuff there). -K On Thu, Mar 8, 2018 at 11:00 AM, Tom Lane wrote: > Kelly Burkhart writes: > > Hello, I've had two core dumps in the last couple of weeks. The most > > recent, yesterday was on versi

Crash and core on 10.1 and 10.2

2018-03-08 Thread Kelly Burkhart
Hello, I've had two core dumps in the last couple of weeks. The most recent, yesterday was on version 10.2: (gdb) bt #0 0x7f317a043886 in get_next_seq () from /lib64/libc.so.6 #1 0x7f317a044acc in strcoll_l () from /lib64/libc.so.6 #2 0x007ced5f in varstrfastcmp_locale () #3 0