Plantage du postmaster.

From: Toffe <toffe(at)nah-ko(dot)org>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: Plantage du postmaster.
Date: 2004-06-03 20:15:10
Message-ID: 40BF86CE.9080600@nah-ko.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

Bonsoir,

J'ai eu un soucis ce matin avec mon serveur sql perso, ça a donné ça
dans mes logs:

Jun 3 07:51:32 titou postgres[458]: [5-1] LOG: checkpoint process (PID
19822) was terminated by signal 11
Jun 3 07:51:32 titou postgres[458]: [6-1] LOG: terminating any other
active server processes
Jun 3 07:51:32 titou postgres[458]: [7-1] LOG: all server processes
terminated; reinitializing
Jun 3 07:51:32 titou postgres[19823]: [8-1] LOG: database system was
interrupted at 2004-06-03 07:46:32 CEST
Jun 3 07:51:32 titou postgres[19823]: [9-1] LOG: checkpoint record is
at 0/EABF6320
Jun 3 07:51:32 titou postgres[19823]: [10-1] LOG: redo record is at
0/EABE8060; undo record is at 0/0; shutdown FALSE
Jun 3 07:51:32 titou postgres[19823]: [11-1] LOG: next transaction ID:
1621995; next OID: 812878
Jun 3 07:51:32 titou postgres[19823]: [12-1] LOG: database system was
not properly shut down; automatic recovery in progress
Jun 3 07:51:32 titou kernel: Unable to handle kernel NULL pointer
dereference at virtual address 00000000
Jun 3 07:51:32 titou kernel: printing eip:
Jun 3 07:51:32 titou kernel: 00000000
Jun 3 07:51:32 titou kernel: *pde = 00000000
Jun 3 07:51:32 titou kernel: Oops: 0000
Jun 3 07:51:32 titou kernel: CPU: 0
Jun 3 07:51:32 titou kernel: EIP: 0010:[<00000000>] Not tainted
Jun 3 07:51:32 titou kernel: EFLAGS: 00010286
Jun 3 07:51:32 titou kernel: eax: c03810c0 ebx: c51c1802 ecx:
00000001 edx: 00000018
Jun 3 07:51:32 titou kernel: esi: c51c7740 edi: c0132530 ebp:
00000000 esp: c2873e98
Jun 3 07:51:32 titou kernel: ds: 0018 es: 0018 ss: 0018
Jun 3 07:51:32 titou kernel: Process postmaster (pid: 19822,
stackpage=c2873000)
Jun 3 07:51:32 titou kernel: Stack: c01f62e1 c03810c0 00000001 c51c7740
00000000 c51c7740 00000008 00000001
Jun 3 07:51:32 titou kernel: 00000000 c01f6390 00000001 c51c7740
0000000c c2873f50 00000014 00000000
Jun 3 07:51:32 titou kernel: c0132584 00000001 c51c7740 c06512c0
c55b31a0 c013263b c2873efc 00000020
Jun 3 07:51:32 titou kernel: Call Trace: [<c01f62e1>] [<c01f6390>]
[<c0132584>] [<c013263b>] [<c0132676>]
Jun 3 07:51:32 titou kernel: [<c0132746>] [<c0132833>] [<c0132887>]
[<c0107013>]
Jun 3 07:51:32 titou kernel:
Jun 3 07:51:32 titou kernel: Code: Bad EIP value.
Jun 3 07:51:32 titou postgres[19823]: [13-1] LOG: redo starts at
0/EABE8060
Jun 3 07:51:32 titou postgres[19823]: [14-1] LOG: record with zero
length at 0/EAC20D4C
Jun 3 07:51:32 titou postgres[19823]: [15-1] LOG: redo done at 0/EAC20D28

Je sais, c'est largement imbitable mais j'ai pas trop le choix...
ensuite, à chaque tentative de connection à la BDD:

Jun 3 07:53:03 titou postgres[19918]: [8-1] LOG: connection received:
host=172.24.8.1 port=47525
Jun 3 07:53:03 titou postgres[19918]: [9-1] FATAL: the database system
is starting up

Ce qui fait que rien ne marchait ! Le seul moyen de remettre ça en route
a été de rebooter la machine... avec le doigt vu que rien d'autre ne
prenait !

Bref, j'ai pas encore trouvé d'où viens l'erreur alors si vous avez une
idée, je suis preneur !

Merci d'avance.

P.S.: après le reboot tout est redevenu normal...

--
Toffe
UIN #39872819
http://www.nah-ko.org/ - http://www.zrx21.com/
Microsoft est aux systèmes d'éxploitation et à la sécuritée...
...ce que Mc Donalds est aux fin gourmet.

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Toffe 2004-06-04 06:52:55 Re: Plantage du postmaster.
Previous Message siruphi 2004-06-02 11:10:07 Re: pgsql-fr-generale@postgresql.org