Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6C0AB9FB7A2 for ; Wed, 8 Aug 2007 06:38:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 84513-08 for ; Wed, 8 Aug 2007 06:38:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fmmailgate05.web.de (fmmailgate05.web.de [217.72.192.243]) by postgresql.org (Postfix) with ESMTP id 5B3AB9FB787 for ; Wed, 8 Aug 2007 06:38:13 -0300 (ADT) Received: from web.de by fmmailgate05.web.de (Postfix) with SMTP id 3970E2850971; Wed, 8 Aug 2007 11:38:12 +0200 (CEST) Received: from [217.86.138.6] by freemailng0203.web.de with HTTP; Wed, 08 Aug 2007 11:38:11 +0200 Date: Wed, 08 Aug 2007 11:38:11 +0200 Message-Id: <2041191463@web.de> MIME-Version: 1.0 From: pingu.freak@web.de To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Transaction-Overflow Precedence: fm-user Organization: http://freemail.web.de/ X-Provags-Id: V01U2FsdGVkX1//vhsl/icDuB2QMmHHHLtWfnpOflA+CaURLqXIs7shmnx1/ 8Ue6nwfSS/xDIs4V4lkenrM4IZRRXTP1QpnAyUi6iZ61qRz6UNH/5/XQMXDz w== Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.697 tagged_above=0 required=5 tests=AWL=-1.300, BAYES_50=0.001, MIME_QP_LONG_LINE=1.396, SARE_BAYES_5x8=0.8, SARE_BAYES_6x8=0.8, SARE_BAYES_7x8=1 X-Spam-Level: ** X-Archive-Number: 200708/63 X-Sequence-Number: 26394 Hi, first thanks for your answers. Now I found some ECC-exceptions in the Kernel.: EDAC MC0: CE page 0xfeb8e, offset 0x0, grain 4096, syndrome 0xb32, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE - no information available: e7xxx CE log register overflow EDAC MC0: CE page 0xfeb8e, offset 0x0, grain 4096, syndrome 0xb32, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE - no information available: e7xxx CE log register overflow EDAC MC0: CE page 0xfeb8e, offset 0x0, grain 4096, syndrome 0xb32, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE - no information available: e7xxx CE log register overflow EDAC MC0: CE page 0xfeb8e, offset 0x0, grain 4096, syndrome 0xb32, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE - no information available: e7xxx CE log register overflow EDAC MC0: CE page 0xfeb8e, offset 0x0, grain 4096, syndrome 0xb32, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE - no information available: e7xxx CE log register overflow This is on both servers, production and backup. Right know, I'm updating t= he Kernel to 2.6.22.1. Hopefully this helps :/. But I think there is no hope. There are also Traces in dmesg: Code: f3 a5 89 c1 f3 a4 eb 21 89 c8 83 f9 07 76 18 89 f9 f7 d9 83 e1 07 29= c8 f3 a4 89 c1 c1 e9 02 83 e0 03 90 f3 a5 89 c1 f3 a4 5e 89 5f c3 57= 85 c9 56 89 c7 89 d6 79 08 0f 0b 0a 03 71 ce 2c c0=20 EIP: [] =5F=5Fcopy=5Ffrom=5Fuser=5Fll=5Fnozero+0xd7/0xda SS:ESP 0068:dca2fd9= 4 <4>EDAC MC0: CE page 0xb4124, offset 0x0, grain 4096, syndrome 0xfc1, row= 4, channel 0, label "": e7xxx CE EDAC MC0: CE page 0xb4124, offset 0x0, grain 4096, syndrome 0xfc1, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE page 0xb4124, offset 0x0, grain 4096, syndrome 0xfc1, row 4, = channel 0, label "": e7xxx CE EDAC MC0: CE page 0xb4124, offset 0x0, grain 4096, syndrome 0xfc1, row 4, = channel 0, label "": e7xxx CE BUG: unable to handle kernel NULL pointer dereference at virtual address 0= 0000002 printing eip: c01c3a2c *pde =3D 2f39e001 Oops: 0000 [#3] SMP=20 last sysfs file: /devices/pci0000:00/0000:00:00.0/class Modules linked in: nfs lockd nfs=5Facl sunrpc iptable=5Ffilter ip=5Ftables x=5Ftab= les lp parport=5Fpc parport af=5Fpacket joydev st sr=5Fmod ipv6 button battery a= c apparmor aamatch =5Fpcre loop dm=5Fmod e1000 ide=5Fcd cdrom i2c=5Fi801 e7xxx=5Fedac edac=5Fmc i2c=5Fcore = ext3 mbcache jbd edd fan sg gdth aic79xx scsi=5Ftransport=5Fspi piix thermal p= rocessor sd=5Fmod sc si=5Fmod ide=5Fdisk ide=5Fcore CPU: 0 EIP: 0060:[] Tainted: G U VLI EFLAGS: 00010206 (2.6.18.2-34-bigsmp #1)=20 EIP is at =5F=5Fcopy=5Ffrom=5Fuser=5Fll=5Fnozero+0xd7/0xda eax: e5f17dbc ebx: 00000001 ecx: 00000006 edx: bff0ef9a esi: 00000000 edi: 01de802f ebp: 00000006 esp: e5f17d94 ds: 007b es: 007b ss: 0068 Process postmaster (pid: 13414, ti=3De5f16000 task=3De93710b0 task.ti=3De5f16000= ) Stack: c01a81f2 00000000 00003466 0000000e e5f17dbc 00000000 00000000 0000= 0001=20 00000002 00000000 ffff0002 c0100000 00000000 b6b86840 b6b85000 c1d9= df20=20 00001000 d4f6ae9c 21741707 46b611a0 c0125770 3b9aca00 00000163 8000= 0000=20 Call Trace: [] exit=5Fsem+0x58/0x14c [] current=5Ffs=5Ftime+0x4f/0x5b [] get=5Fpage=5Ffrom=5Ffreelist+0x2f1/0x371 [] find=5Flock=5Fpage+0x1a/0x77 [] shmem=5Fgetpage+0x4f2/0x552 [] shmem=5Fnopage+0xa4/0xb6 [] =5F=5Fhandle=5Fmm=5Ffault+0x63e/0xb9c [] autoremove=5Fwake=5Ffunction+0x0/0x35 [] sys=5Fipc+0x5e/0x1bb [] sysenter=5Fpast=5Fesp+0x56/0x79 Code: f3 a5 89 c1 f3 a4 eb 21 89 c8 83 f9 07 76 18 89 f9 f7 d9 83 e1 07 29= c8 f3 a4 89 c1 c1 e9 02 83 e0 03 90 f3 a5 89 c1 f3 a4 5e 89 5f c3 57= 85 c9 56 89 c7 89 d6 79 08 0f 0b 0a 03 71 ce 2c c0=20 EIP: [] =5F=5Fcopy=5Ffrom=5Fuser=5Fll=5Fnozero+0xd7/0xda SS:ESP 0068:e5f17d9= 4 <6>device eth0 left promiscuous mode The hardware is 5 years old... It was not possible to get new hardware for this project. :/ Regards, Martin -----Urspr=FCngliche Nachricht----- Von: Tom Lane Gesendet: 07.08.07 20:41:08 An: pingu.freak@web.de CC: pgsql-admin@postgresql.org Betreff: Re: [ADMIN] Transaction-Overflow=20 pingu.freak@web.de writes: > On the top in the log file is this, do you know why the pid is killed wi= th =3D > 11=3F I'm a little bit confused :(. > LOG: Serverprozess (PID 30399) wurde von Signal 11 beendet SIG 11 (ie SIGSEGV) is pretty much the typical "generic crash" indication. It most likely means you ran into a software bug or corrupted data. There is no reason at all to think that it's got anything to do with transaction ID wraparound --- that message is only coming out because it always comes out at a database restart. What you ought to look into is what *did* cause the crash. Did it produce a core file, and if so can you get a gdb stack trace from the core=3F regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Jetzt neu! Sch=FCtzen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate kostenlos testen. http://www.pc-sicherheit.web.de/startseite/=3Fmc=3D022220