Hi Alvaro,
25.08.2023 14:38, Alvaro Herrera wrote:
> I have now pushed this again. Hopefully it'll stick this time.
Starting from b0e96f31, pg_upgrade fails with inherited NOT NULL constraint:
For example upgrade from 9c13b6814a (or REL_12_STABLE .. REL_16_STABLE) to
b0e96f31 (or master) with
at 7:36 PM wenjing wrote:
>
>
> Andrew Bille 于2021年12月21日周二 14:00写道：
>
>> Hi!
>> Thanks for new patches.
>> Yet another crash reproduced on master with v63 patches:
>>
>> CREATE TABLESPACE ts LOCATION '/tmp/ts';
>> CREATE GLOBAL TEMP TABLE tbl (n
at 7:42 PM wenjing zeng wrote:
> Post GTT v63 to fixed conflicts with the latest code.
>
>
>
> Hi Andrew
>
> Have you found any new bugs recently?
>
>
>
> Wenjing
>
>
>
>
> 2021年11月20日 01:31，wenjing 写道：
>
>
>
> Andrew Bille 于2021年11月15日周一
Thanks for the patches. The feature has become much more stable.
However, there is another simple case that generates an error:
Master with v61 patches
CREATE GLOBAL TEMPORARY TABLE t AS SELECT 1 AS a;
ERROR: could not open file "base/13560/t3_16384": No such file or directory
Andrew
On Thu,
Thanks, the "group by" is fixed
Yet another crash (on v58 patches), reproduced with:
psql -t -c "create global temp table t(b text)
with(on_commit_delete_rows=true); create index idx_b on t (b); insert into
t values('test'); alter table t alter b type varchar;"
server closed the connection
gc=3, argv=) at
postmaster.c:1473
#22 0x55ad0bbe8e31 in main (argc=3, argv=0x55ad0c3c6660) at main.c:198
On Thu, Oct 21, 2021 at 4:25 PM wenjing wrote:
>
>
> Andrew Bille 于2021年10月20日周三 上午2:59写道：
>
>> Another thanks for the fix. It works for me.
>>
>> But I found ano
Another thanks for the fix. It works for me.
But I found another crash!
On master with the v56 patches applied:
initdb -D data
pg_ctl -w -t 5 -D data -l server.log start
echo "create global temp table t(i int4); insert into t values (1); vacuum
t;" > tmp.sql
psql < tmp.sql
CREATE TABLE
INSERT
On master with the v55 patches applied the following script leads to crash:
initdb -D data
pg_ctl -w -t 5 -D data -l server.log start
psql -t -c "begin; create global temp table gtt_with_index(a int primary
key, b text); commit; select pg_sleep(5);" >psql1.log &
psql -t -c "select pg_sleep(1);
Thanks for the fix. It works for me.
Now I'm exploring another crash related to GTT, but I need a few days to
present a simple repro.
On Sat, Oct 9, 2021 at 2:41 PM wenjing wrote:
>
> Thank you for pointing it out.
> This is a bug that occurs during transaction rollback and process exit, I
>
On master with the v54 patches applied the following script leads to crash:
export
ASAN_OPTIONS=detect_leaks=0:abort_on_error=1:disable_coredump=0:strict_string_checks=1:check_initialization_order=1:strict_init_order=1
initdb -D data
pg_ctl -w -t 5 -D data -l server.log start
psql -c "create
10 matches
Mail list logo
