Skip site navigation (1) Skip section navigation (2)

problem fermeture de connection <signal 11> par un déclencheur

From: andy petrella <andy(dot)petrella(at)gmail(dot)com>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: problem fermeture de connection <signal 11> par un déclencheur
Date: 2005-10-02 16:04:28
Message-ID: 7159e12c0510020904l3903b9e6k@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Bonjour a tous,

j'ai un trigger qui me coupe a chaque fois la connection, en renvoyant
un signal 11. Et je vois po pk !

Voila le log....

NOTICE:  cote_expand: SPI_exec (begin ...) returned -8
LOG:  server process (PID 14388) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2005-10-02 17:35:03 CEST
LOG:  checkpoint record is at 0/FC0E88
LOG:  redo record is at 0/FC0E88; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 871; next OID: 26380
LOG:  database system was not properly shut down; automatic recovery in progress


On voie qu'il me renvoie un beau -8 ??? d'un spi_exec.


Merci de votre aide.

Responses

pgsql-fr-generale by date

Next:From: thomas.silviDate: 2005-10-02 16:29:15
Subject: Re: [pgsql-fr-generale] problem fermeture de connection <signal 11> par un déclencheur
Previous:From: Mathieu ArnoldDate: 2005-10-02 14:55:57
Subject: Re: Postgresql et les utilisateurs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group