Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1wBW-0003OI-6o for pgsql-admin@arkaria.postgresql.org; Mon, 17 Sep 2018 16:15:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1wBU-0003AE-GJ for pgsql-admin@arkaria.postgresql.org; Mon, 17 Sep 2018 16:15:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1wBT-0003A5-UI for pgsql-admin@lists.postgresql.org; Mon, 17 Sep 2018 16:15:36 +0000 Received: from mail-oi0-x244.google.com ([2607:f8b0:4003:c06::244]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g1wBR-0007lo-3p for pgsql-admin@lists.postgresql.org; Mon, 17 Sep 2018 16:15:34 +0000 Received: by mail-oi0-x244.google.com with SMTP id 8-v6so19489098oip.0 for ; Mon, 17 Sep 2018 09:15:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=W6oZJZipvcv4i2SzHQzOSeKabtFMYG0mlvEXkAlY2f4=; b=Kn+VgohFYaMfq3e7WC8REjDDv98oY7eWhevxggaKbj0JPuvKrbvecFX7QXg7UJN1Ne JoWqlET2kYJ7xcIOMX9BJEHxj6jhhdUIHgjs8s6mFRHr488RJ//oxAz5FSjvVJJ2Uu15 DlQbmrzsZ0QwTfTkrH1d4yIRocvlt/sEQzk6yis6BRpPQwa58Yq0W8Oly8stJAnVkuGQ Wv/RSAhJ0wax8ZAaUomxytdC1GvA/3sZ5uaVJeK9Qqd9exEK5dqhb7yEocmIEjKMbjAE 42QX0yiVm14u32zcPCk6ZBuAmw6xEQqbGQw4IPEoxFU3pDiAGFunQqA2dqeoG75swTbX vwMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=W6oZJZipvcv4i2SzHQzOSeKabtFMYG0mlvEXkAlY2f4=; b=a9pJxll8bZE9ZdVZMFzyoQZ6474y5SvgKlODL88pAsV+K7ID+Cq6a8lGUe1ikkzKoH glGimz9WZSeDV7hbMjF+JVp2Lz4RggjfNj4H6tfQ6ARScsodAW+N9l4uXIZYKZ91zFG3 6RXUWGA4GojMmLIzNgNnWU83h2jWY5IGlMJ3/llpA02YHSQHr4DlikvXt//c2T35Dacd gy2jKpvTUXMzP209IGBJNPHmeQZYB3Iba4z62qWQznK3tc3PXfk9xmpgbG9UOV3BRjjE TXZb34/Tr8PNGrN1iDQB2fb0yuhcLe4J1mhXroAaVzVJO1zAPKKlJFaRcj0q6EcHVvOZ +IEQ== X-Gm-Message-State: APzg51DrET0qMN9bQdSh7zaWs4mkJKRN+4dw0zDXHFihAJlE+s38hxAt J7Xw+T3m7vjDeA06tVqs3msWlobW X-Google-Smtp-Source: ANB0VdZjoJq+FA/6aWB2Q045QyxGiaGDch/zbt+XmX5RYElm+Ls79etPxtaFCc+X63gICqe5QKjZ7w== X-Received: by 2002:aca:3ec5:: with SMTP id l188-v6mr16508195oia.181.1537200931676; Mon, 17 Sep 2018 09:15:31 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id q204-v6sm6303324oih.49.2018.09.17.09.15.30 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 17 Sep 2018 09:15:30 -0700 (PDT) Subject: Re: Segmentation fault postgres 9.6 To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <93391cf1-52c9-8079-e930-629b1aaa8407@gmail.com> Date: Mon, 17 Sep 2018 11:15:29 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------E732E88254944A651A59F484" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------E732E88254944A651A59F484 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit How did you determine that?   (What line of the log file says it?) On 09/17/2018 09:04 AM, Shreeyansh Dba wrote: > > Hi Mariel, > > it seems kernel shared memory parameter issue which blocking or creating a > new process, which requires for data purpose. > > Check your kernel shared memory parameters. > > > On Mon, Sep 17, 2018 at 5:46 PM Mariel Cherkassky > > wrote: > > Hi, > I'm trying to insert a few values into a foreign table via sqllite_fdw > and my postgresql database crushes : > 2018-09-17 12:09:54 UTC  43444  LOG: server process (PID 43831) was > terminated by signal 11: Segmentation fault > 2018-09-17 12:09:54 UTC  43444 DETAIL:  Failed process was running: > insert into vip_foreign values (2,2,2); > 2018-09-17 12:09:54 UTC  43444  LOG: terminating any other active > server processes > 2018-09-17 12:09:54 UTC  43451 WARNING:  terminating connection > because of crash of another server process > 2018-09-17 12:09:54 UTC  43451 DETAIL:  The postmaster has commanded > this server process to roll back the current transaction and exit, > because another server process exited abnormally and possibly > corrupted shared memory. > 2018-09-17 12:09:54 UTC  43451  HINT: In a moment you should be able > to reconnect to the database and repeat your command. > 2018-09-17 12:09:54 UTC  43444  LOG: archiver process (PID 43452) > exited with exit code 1 > 2018-09-17 12:09:54 UTC  43444  LOG: all server processes terminated; > reinitializing > 2018-09-17 12:09:54 UTC  43840  LOG: database system was interrupted; > last known up at 2018-09-17 12:08:35 UTC > 2018-09-17 12:09:56 UTC  43840  LOG: database system was not properly > shut down; automatic recovery in progress > 2018-09-17 12:09:56 UTC  43840  LOG: redo starts at 0/6000098 > 2018-09-17 12:09:56 UTC  43840  LOG: invalid record length at > 0/60000D0: wanted 24, got 0 > 2018-09-17 12:09:56 UTC  43840  LOG: redo done at 0/6000098 > 2018-09-17 12:09:56 UTC  43840  LOG: checkpoint starting: > end-of-recovery immediate > 2018-09-17 12:09:56 UTC  43840  LOG: checkpoint complete: wrote 0 > buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 > recycled; write=0.006 s, sync=0.000 s, total=0.030 s; sync files=0, > longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB > 2018-09-17 12:09:56 UTC  43840  LOG: MultiXact member wraparound > protections are now enabled > 2018-09-17 12:09:56 UTC  43444  LOG: database system is ready to > accept connections > 2018-09-17 12:09:56 UTC  43844  LOG: autovacuum launcher started > > any idea how can I investigate if the problem in the wrapper or in the > database ? > -- Angular momentum makes the world go 'round. --------------E732E88254944A651A59F484 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit How did you determine that?   (What line of the log file says it?)

On 09/17/2018 09:04 AM, Shreeyansh Dba wrote:

Hi Mariel,

it seems kernel shared memory parameter issue which blocking or creating a new process, which requires for data purpose. 

Check your kernel shared memory parameters.

On Mon, Sep 17, 2018 at 5:46 PM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
Hi,
I'm trying to insert a few values into a foreign table via sqllite_fdw and my postgresql database crushes : 
2018-09-17 12:09:54 UTC  43444  LOG:  server process (PID 43831) was terminated by signal 11: Segmentation fault
2018-09-17 12:09:54 UTC  43444  DETAIL:  Failed process was running: insert into vip_foreign values (2,2,2);
2018-09-17 12:09:54 UTC  43444  LOG:  terminating any other active server processes
2018-09-17 12:09:54 UTC  43451  WARNING:  terminating connection because of crash of another server process
2018-09-17 12:09:54 UTC  43451  DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2018-09-17 12:09:54 UTC  43451  HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2018-09-17 12:09:54 UTC  43444  LOG:  archiver process (PID 43452) exited with exit code 1
2018-09-17 12:09:54 UTC  43444  LOG:  all server processes terminated; reinitializing
2018-09-17 12:09:54 UTC  43840  LOG:  database system was interrupted; last known up at 2018-09-17 12:08:35 UTC
2018-09-17 12:09:56 UTC  43840  LOG:  database system was not properly shut down; automatic recovery in progress
2018-09-17 12:09:56 UTC  43840  LOG:  redo starts at 0/6000098
2018-09-17 12:09:56 UTC  43840  LOG:  invalid record length at 0/60000D0: wanted 24, got 0
2018-09-17 12:09:56 UTC  43840  LOG:  redo done at 0/6000098
2018-09-17 12:09:56 UTC  43840  LOG:  checkpoint starting: end-of-recovery immediate
2018-09-17 12:09:56 UTC  43840  LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.000 s, total=0.030 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB
2018-09-17 12:09:56 UTC  43840  LOG:  MultiXact member wraparound protections are now enabled
2018-09-17 12:09:56 UTC  43444  LOG:  database system is ready to accept connections
2018-09-17 12:09:56 UTC  43844  LOG:  autovacuum launcher started

any idea how can I investigate if the problem in the wrapper or in the database ?

--
Angular momentum makes the world go 'round.
--------------E732E88254944A651A59F484--