Re: Weird failures on lorikeet

Is there something going on with lorikeet again?  I see this:

2020-06-25 01:55:13.380 EDT [5ef43c40.21e0:85] pg_regress/typed_table LOG:  statement: SELECT
c.oid::pg_catalog.regclass
    FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i
    WHERE c.oid = i.inhparent AND i.inhrelid = '21420'
      AND c.relkind != 'p' AND c.relkind != 'I'
    ORDER BY inhseqno;
*** starting debugger for pid 4456, tid 2644
2020-06-25 01:55:13.393 EDT [5ef43c40.21e0:86] pg_regress/typed_table LOG:  statement: SELECT
c.oid::pg_catalog.regclass,c.relkind, pg_catalog.pg_get_expr(c.relpartbound, c.oid)
 
    FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i
    WHERE c.oid = i.inhrelid AND i.inhparent = '21420'
    ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT', c.oid::pg_catalog.regclass::pg_catalog.text;
      1 [main] postgres 4456 try_to_debug: Failed to start debugger, Win32 error 2
2020-06-25 01:55:13.455 EDT [5ef43c40.21e0:87] pg_regress/typed_table LOG:  statement: CREATE TABLE persons3 OF
person_type(
 
        PRIMARY KEY (id),
        name NOT NULL DEFAULT ''
    );
*** continuing pid 4456 from debugger call (0)
*** starting debugger for pid 4456, tid 2644
  48849 [main] postgres 4456 try_to_debug: Failed to start debugger, Win32 error 2
*** continuing pid 4456 from debugger call (0)
2020-06-25 01:55:18.181 EDT [5ef43bd6.2824:4] LOG:  server process (PID 4456) was terminated by signal 11: Segmentation
fault
2020-06-25 01:55:18.181 EDT [5ef43bd6.2824:5] DETAIL:  Failed process was running: drop table some_tab cascade;


On 2018-Mar-06, Thomas Munro wrote:
> On Thu, Feb 22, 2018 at 7:06 AM, Andres Freund <andres@anarazel.de> wrote:

> > I noticed your animal lorikeet failed in the last two runs:
> > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lorikeet&dt=2018-02-21%2009%3A47%3A17
> > TRAP: FailedAssertion("!(((PageHeader) (page))->pd_special >= (__builtin_offsetof (PageHeaderData, pd_linp)))",
File:"/home/andrew/bf64/root/HEAD/pgsql/src/include/storage/bufpage.h", Line: 313)
 
> >
> > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lorikeet&dt=2018-02-20%2012%3A46%3A17
> > TRAP: FailedAssertion("!(PMSignalState->PMChildFlags[slot] == 1)", File:
"/home/andrew/bf64/root/HEAD/pgsql.build/../pgsql/src/backend/storage/ipc/pmsignal.c",Line: 229)
 
> > 2018-02-20 08:07:14.054 EST [5a8c1c3b.21d0:3] LOG:  select() failed in postmaster: Bad address
> > 2018-02-20 08:07:14.073 EST [5a8c1c3b.21d0:4] LOG:  database system is shut down

> Bad memory?  Assorted output from recent runs:
> 
> + ERROR:  index "pg_toast_28546_index" contains corrupted page at block 1
> 
> TRAP: FailedAssertion("!(PMSignalState->PMChildFlags[slot] == 1)",
> File: "/home/andrew/bf64/root/HEAD/pgsql.build/../pgsql/src/backend/storage/ipc/pmsignal.c",
> Line: 229)
> 
> TRAP: FailedAssertion("!(entry->trans == ((void *)0))", File:
> "/home/andrew/bf64/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/pgstat.c",
> Line: 871)


-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services