Thread: BUG #1130: server terminated by signal 11 (easy to duplicate)

BUG #1130: server terminated by signal 11 (easy to duplicate)

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1130
Logged by:          Phil Walker

Email address:      phil.walker@hp.com

PostgreSQL version: 7.4

Operating system:   cygwin

Description:        server terminated by signal 11 (easy to duplicate)

Details:

Duplicated on two hardware systems:

1.8Ghz Pentium 4 laptop,
multi-processor industrial blade server (ECC memory)

Easy to duplicate, with the following command line:

$ psql -f pgbug.sql

The SQL file "pgbug.sql" follows:

BEGIN WORK;
SET CONSTRAINTS ALL DEFERRED;
CREATE TABLE ABSTRACTIONISTS(
    ANTIVIVISECTIONS        NUMERIC NOT NULL,
    ELECTROTHERAPISTS       NUMERIC NOT NULL
    );

CREATE TABLE ACKNOWLEDGEMENT(
    DISQUALIFICATIONS       NUMERIC NOT NULL,
    ACCLIMATIZATION         VARCHAR(1024) NOT NULL,
    ADVANTAGEOUSNESS        VARCHAR(32) NOT NULL,
    ALGORITHMICALLY         VARCHAR(32) NOT NULL,
    ALPHANUMERICALLY        VARCHAR(32) NOT NULL,
    CONSTRAINT ADVENTITIOUSNESS UNIQUE(DISQUALIFICATIONS,ALGORITHMICALLY)
    );

CREATE TABLE ADMINISTRATORSHIP(
    ACCOMPLISHMENTS         VARCHAR(10) NOT NULL,
    ACKNOWLEDGEMENTS        VARCHAR(128) NOT NULL,
    ACKNOWLEDGMENTS         VARCHAR(32) DEFAULT NULL,
    ACCOUNTABLENESS         VARCHAR(32) DEFAULT NULL,
    ACQUAINTANCESHIP        NUMERIC DEFAULT 0,
    ACHROMATICITIES         VARCHAR(16) DEFAULT NULL,
    ACQUAINTANCESHIPS       NUMERIC DEFAULT 0,
    ADMINISTRATIONS         NUMERIC DEFAULT 0,
    ACCOMMODATINGLY         VARCHAR(512) DEFAULT NULL,
    ADMISSIBILITIES         DATE DEFAULT CURRENT_DATE,
    ADMINISTRATIVELY        VARCHAR(16) DEFAULT NULL,
    ACKNOWLEDGEABLE         NUMERIC DEFAULT 0,
    ACQUISITIVENESS         VARCHAR(32),
    CONSTRAINT ADMINISTRATORSHIPS PRIMARY
KEY(ACCOMPLISHMENTS,ACKNOWLEDGEMENTS)
    );

CREATE TABLE AERODYNAMICALLY(
    CONNOISSEURSHIP         NUMERIC NOT NULL,
    CZECHOSLOVAKIAN         VARCHAR(17),
    ANESTHETIZATIONS        VARCHAR(32)
    );

CREATE TABLE AFFECTIONATENESS(
    AERODYNAMICISTS         NUMERIC,
    AGREEABILILTIES         NUMERIC DEFAULT 0,
    AGGRANDIZEMENTS         VARCHAR(64) NOT NULL,
    AGRICULTURALIST         VARCHAR(256)
    );

CREATE TABLE ANACHRONISTICALLY(
    CHROMOLITHOGRAPHY       VARCHAR(128),
    CONFIGURATIONAL         VARCHAR(32),
    DEMILITARISATION        VARCHAR(32),
    CONFIDENTIALITY         VARCHAR(32),
    AXIOMATIZATIONS         VARCHAR(64),
    AMBIDEXTROUSNESS        VARCHAR(32),
    ELECTROCARDIOGRAPHS     NUMERIC,
    BUREAUCRATICALLY        NUMERIC,
    ATRABILIOUSNESS         NUMERIC,
    ELECTROPHORUSES         NUMERIC
    );

CREATE TABLE ANTHROPOMORPHOUS(
    CONNOISSEURSHIP         NUMERIC NOT NULL,
    DENATIONALISING         VARCHAR(32) NOT NULL
    );

CREATE TABLE ANTHROPOPHAGOUS(
    CONNOISSEURSHIP         NUMERIC NOT NULL,
    DEMAGNETIZATION         NUMERIC NOT NULL,
    DISTINGUISHABLE         NUMERIC NOT NULL,
    BUREAUCRATIZING         NUMERIC NOT NULL
    );

CREATE TABLE ANTICLERICALISM(
    DISFRANCHISEMENT        NUMERIC NOT NULL,
    DISGRUNTLEMENTS         NUMERIC NOT NULL,
    DISTINGUISHABLE         NUMERIC NOT NULL,
    DIVERSIFICATION         NUMERIC,
    BUREAUCRATIZING         NUMERIC NOT NULL,
    BURGLARPROOFING         NUMERIC,
    ANTHROPOMORPHISM        NUMERIC NOT NULL,
    ANTHROPOMORPHICALLY     VARCHAR(16),
    DENDROCHRONOLOGY        CHAR(1) DEFAULT 'N'
    );

CREATE TABLE ATHEROSCLEROSIS(
    ATMOSPHERICALLY         VARCHAR(16),
    CONTRADICTORILY         VARCHAR(16),
    CONFIDENTIALNESS        VARCHAR(16),
    CZECHOSLOVAKIANS        VARCHAR(17),
    CONGRATULATIONS         VARCHAR(32),
    BRACHISTOCHRONE         VARCHAR(240),
    DENITRIFICATION         VARCHAR(16),
    ANAGRAMMATIZING         VARCHAR(16),
    DISESTABLISHMENT        VARCHAR(240),
    DENATIONALIZATION       VARCHAR(240),
    DENATIONALIZING         VARCHAR(240),
    DISINGENUOUSNESS        VARCHAR(240)
    );

CREATE TABLE BLOODTHIRSTINESS(
    DISILLUSIONIZING        VARCHAR(16),
    CIRCUMNAVIGATES         VARCHAR(16)
    );

CREATE TABLE BOUSTROPHEDONIC(
    DISILLUSIONMENT         VARCHAR(16),
    BRACHYCEPHALOUS         VARCHAR(240),
    DISILLUSIONMENTS        VARCHAR(16),
    ECCLESIASTICALLY        NUMERIC,
    CONGRATULATIONS         VARCHAR(32),
    DIFFERENTIATING         NUMERIC,
    ELECTROCARDIOGRAPHS     VARCHAR(240),
    CONSTRAINT BLASPHEMOUSNESS
UNIQUE(DISILLUSIONMENT,DISILLUSIONMENTS,CONGRATULATIONS,ELECTROCARDIOGRAPHS)
    );

CREATE TABLE CHARACTERIZATIONS(
    CHROMOLITHOGRAPHY       VARCHAR(128) NOT NULL,
    CHROMATOGRAPHIC         VARCHAR(80) NOT NULL,
    CINEMATOGRAPHER         VARCHAR(80) NOT NULL,
    CHROMOLITHOGRAPHIC      OID,
    CHRONOLOGICALLY         OID,
    CHROMOLITHOGRAPH        DATE DEFAULT CURRENT_DATE,
    CHRYSELEPHANTINE        DATE DEFAULT CURRENT_DATE,
    CINEMATOGRAPHERS        VARCHAR(10) DEFAULT NULL,
    CINEMATOGRAPHIC         VARCHAR(128) DEFAULT NULL,
    CHRONOGRAMMATIC         NUMERIC DEFAULT 0,
    CIRCUMAMBULATES         VARCHAR(16) DEFAULT 'NEW',
    CHECKERBOARDING         NUMERIC DEFAULT 0,
    CHROMOLITHOGRAPHER      NUMERIC DEFAULT 0,
    CIRCUMAMBULATED         VARCHAR(32),
    CHEMILUMINESCENCE       VARCHAR(10),
    CHOLECYSTOGRAPHY        VARCHAR(128),
    CONSTRAINT CIRCUMAMBULATING PRIMARY KEY(CHROMOLITHOGRAPHY),
    CONSTRAINT CIRCUMAMBULATION UNIQUE(CHROMATOGRAPHIC,CINEMATOGRAPHER)
    );

CREATE TABLE CIRCUMLOCUTIONARY(
    ELECTROPOSITIVE         NUMERIC NOT NULL,
    VALUE                   VARCHAR(1024) NOT NULL,
    ALGORITHMICALLY         VARCHAR(32) NOT NULL,
    DISQUALIFICATIONS       NUMERIC NOT NULL
    );

CREATE TABLE COMMENSURABILITY(
    CIRCUMSTANTIALLY        VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    APPROACHABILITY         NUMERIC,
    DIFFERENTIATION         NUMERIC
    );

CREATE TABLE COMMENSURATENESS(
    CIRCUMSTANTIALLY        VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    AUTORADIOGRAPHS         NUMERIC
    );

CREATE TABLE COMMONPLACENESS(
    CIRCUMSTANTIALLY        VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    CONTEMPORANEITY         NUMERIC
    );

CREATE TABLE COMPASSIONATELY(
    COMPARTMENTALLY         VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    COMPARTMENTALIZES       VARCHAR(32),
    EDUCATIONALISTS         VARCHAR(32),
    ENTREPRENEURIAL         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    ELECTROPOSITIVE         VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DODECASYLLABLES         NUMERIC,
    CONTEMPORANEITY         NUMERIC,
    DENATURALISATION        NUMERIC
    );

CREATE TABLE COMPENDIOUSNESS(
    COMPARTMENTALIZES       VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    DECARBONIZATION         VARCHAR(16),
    ELECTROPOSITIVE         NUMERIC,
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DODECASYLLABLES         NUMERIC,
    DENDROCHRONOLOGISTS     VARCHAR(16),
    DENATURALIZATION        VARCHAR(16),
    DENDROCHRONOLOGIST      VARCHAR(16)
    );

CREATE TABLE COMPETITIVENESS(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DIAGRAMMATIZING         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    DETERMINATENESS         VARCHAR(32),
    DISHONORABLENESS        NUMERIC,
    ELECTROPOSITIVE         VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    ELECTROCARDIOGRAMS      NUMERIC,
    CONTEMPORANEITY         NUMERIC
    );

CREATE TABLE COMPLEMENTATION(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DISSIMILARITIES         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    CONTRADICTORINESS       VARCHAR(16),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    COMPARTMENTALIZE        NUMERIC
    );

CREATE TABLE COMPREHENSIBILITY(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DISSIMILARITIES         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    CONTRADICTORINESS       VARCHAR(16),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    COMPARTMENTALIZE        NUMERIC
    );

CREATE TABLE COMPREHENSIVELY(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DIAGRAMMATIZING         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    DETERMINATENESS         VARCHAR(32),
    DISHONORABLENESS        NUMERIC,
    ELECTROPOSITIVE         VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    ELECTROCARDIOGRAMS      NUMERIC,
    CONTEMPORANEITY         NUMERIC
    );

CREATE TABLE COMPREHENSIVENESS(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DISSIMILARITIES         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    CONTRADICTORINESS       VARCHAR(16),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    COMPARTMENTALIZE        NUMERIC
    );

CREATE TABLE COMPRESSIBILITY(
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUS         VARCHAR(32),
    DISSIMILARITIES         VARCHAR(32),
    DENATIONALISING         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    CONTRADICTORINESS       VARCHAR(16),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DISSATISFACTORY         VARCHAR(32),
    DODECASYLLABLES         NUMERIC,
    COMPARTMENTALIZE        NUMERIC
    );

CREATE TABLE CONCEIVABLENESS(
    CONTEMPORANEITY         NUMERIC,
    EDUCATIONALISTS         VARCHAR(32),
    DENOMINATIONALISM       VARCHAR(40),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DODECASYLLABLES         NUMERIC,
    DOLICHOCEPHALIC         VARCHAR(32),
    DISHONOURABLENESS       NUMERIC,
    COMPARTMENTALIZES       VARCHAR(32),
    CONTEMPORANEOUSNESS     VARCHAR(32)
    );

CREATE TABLE CONSUBSTANTIATION(
    CONTEMPORANEITY         NUMERIC,
    EDUCATIONALISTS         VARCHAR(32),
    EFFICACIOUSNESS         VARCHAR(32),
    ENTREPRENEURIAL         VARCHAR(32),
    CONTEMPTIBILITY         VARCHAR(16),
    CONTEMPORANEOUS         VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DODECASYLLABLES         NUMERIC
    );

CREATE TABLE CONTRADISTINCTION(
    DEPERSONALIZING         NUMERIC,
    CHROMOLITHOGRAPHY       NUMERIC,
    ANTIVIVISECTIONS        NUMERIC,
    ARTIFICIALITIES         VARCHAR(32),
    ARBITRATORSHIPS         VARCHAR(32),
    ARBORICULTURIST         VARCHAR(32),
    ANTIVIVISECTIONISM      VARCHAR(64),
    APPROPRIATENESS         VARCHAR(16),
    ANTIPATHETICALLY        DATE
    );

CREATE TABLE CONTRADISTINCTIONS(
    DEPERSONALIZING         NUMERIC,
    CHROMOLITHOGRAPHY       NUMERIC,
    BASTARDIZATIONS         VARCHAR(8),
    AUTORADIOGRAPHS         NUMERIC,
    AUTOTRANSFORMER         NUMERIC,
    CONSTRUCTIBILITY        VARCHAR(32),
    CONSUBSTANTIALITY       NUMERIC,
    AGRICULTURALISTS        VARCHAR(10) DEFAULT 'None',
    ANTIPATHETICALLY        DATE
    );

CREATE TABLE CONTRADISTINGUISH(
    DEPERSONALIZING         NUMERIC,
    CHROMOLITHOGRAPHY       NUMERIC,
    ABSTRACTIONISMS         VARCHAR(80),
    DYSLOGISTICALLY         VARCHAR(32),
    DECONSECRATIONS         NUMERIC,
    ANTIPATHETICALLY        DATE
    );

CREATE TABLE CONTRARIOUSNESS(
    CORRESPONDINGLY         VARCHAR(32),
    CONCEPTUALIZATIONS      VARCHAR(10),
    CONVENTIONALIZED        VARCHAR(128),
    DIFFERENTIATION         NUMERIC,
    APPROACHABILITY         NUMERIC
    );

Re: BUG #1130: server terminated by signal 11 (easy to

From
Stephan Szabo
Date:
On Tue, 13 Apr 2004, PostgreSQL Bugs List wrote:

>
> The following bug has been logged online:
>
> Bug reference:      1130
> Logged by:          Phil Walker
>
> Email address:      phil.walker@hp.com
>
> PostgreSQL version: 7.4
>
> Operating system:   cygwin
>
> Description:        server terminated by signal 11 (easy to duplicate)
>
> Details:
>
> Duplicated on two hardware systems:
>
> 1.8Ghz Pentium 4 laptop,
> multi-processor industrial blade server (ECC memory)
>
> Easy to duplicate, with the following command line:
>
> $ psql -f pgbug.sql
>
> The SQL file "pgbug.sql" follows:

Is that the entire file?  There wasn't a commit and it worked fine
on my 7.4.2 machine under linux.

Re: BUG #1130: server terminated by signal 11 (easy to duplicate)

From
Tom Lane
Date:
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> The SQL file "pgbug.sql" follows:

I think maybe your test file got truncated?  It doesn't do anything
except create a few tables (which doesn't cause any problem here...)

            regards, tom lane

Re: BUG #1130: server terminated by signal 11 (easy to duplicate)

From
Tom Lane
Date:
"Walker, Philip M" <phil.walker@hp.com> writes:
> Attached is the entire file,

Thanks.  Unfortunately, I see no crash here ...

I tried it on 7.4.1 on a Linux PC, also on 7.4.2 and development tip
on HPUX.  Anyway there's not anything in the script that looks like
it would cause a problem --- certainly not in the area suggested by
the postmaster log.  There's no obvious difference between the CREATE
commands it gets through and the ones it doesn't.

It's barely possible that the difference is some post-7.4 bug fix,
but I can't think what.

I'd have to say that either you have a misbuilt Postgres executable
or there's something platform-specific going on.  You might try asking
on the pgsql-cygwin list to see if anyone recognizes the symptoms.

You should update to 7.4.2 just on general principles; if the problem is
a misbuilt executable then a fresh build should fix it.

            regards, tom lane