[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Postgresql 12 Beta2 Crashes for any Insert/Update
From:       Mohsen Bande <mohsenbande () gmail ! com>
Date:       2019-06-30 12:59:37
Message-ID: CAFdu22pKAAsz4z7piJ24=qeqkt_7s99rKZUgwTm+4a6qVOW-Mg () mail ! gmail ! com
[Download RAW message or body]

After Investigating deeper, I found the root cause.
Actually, the problem exists in certain tables, which i have created a
trigger on them calling a function from a custom dynamic extension.
the extension needs to rebuild (make && make install) against new PG
development header files.


On Sun, Jun 30, 2019 at 3:29 PM Mohsen Bande <mohsenbande@gmail.com> wrote:

> I've created a new database, and started to copy current data into it. it
> seems to work.
> it seems that the problem relates to upgrade process of database catalogs
> from Beta1 to Beta2.
> if the problem persists, it will investigate the stacktrace.
> Thanks
>
> On Thu, Jun 27, 2019 at 9:40 PM Peter Geoghegan <pg@bowt.ie> wrote:
>
>> On Thu, Jun 27, 2019 at 1:28 AM Mohsen Bande <mohsenbande@gmail.com>
>> wrote:
>> > i have a working database in PG 12 Beta 1. today i upgraded it to Beta
>> 2. everything goes fine and server is up and running. but trying to
>> INSERT/UPDATE anything, server crashes:
>>
>> Is it possible for you to send us a stacktrace?
>>
>>
>> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
>>
>> Thanks
>> --
>> Peter Geoghegan
>>
>

[Attachment #3 (text/html)]

<div dir="ltr"><div>After Investigating deeper, I found the root \
cause.<br></div><div>Actually, the problem exists in certain tables, which i have \
created a trigger on them calling a function from a custom dynamic \
extension.</div><div>the extension needs to rebuild (make &amp;&amp; make install) \
against new PG development header files.</div><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Jun 30, 2019 at 3:29 PM \
Mohsen Bande &lt;<a href="mailto:mohsenbande@gmail.com">mohsenbande@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="ltr"><div>I&#39;ve created a new database, and started to copy current data into \
it. it seems to work.</div><div>it seems that the problem relates to upgrade process \
of database catalogs from Beta1 to Beta2.</div><div>if the problem persists, it will \
investigate the stacktrace.</div><div>Thanks<br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 27, 2019 at 9:40 PM \
Peter Geoghegan &lt;<a href="mailto:pg@bowt.ie" target="_blank">pg@bowt.ie</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu, Jun 27, 2019 \
at 1:28 AM Mohsen Bande &lt;<a href="mailto:mohsenbande@gmail.com" \
target="_blank">mohsenbande@gmail.com</a>&gt; wrote:<br> &gt; i have a working \
database in PG 12 Beta 1. today i upgraded it to Beta 2. everything goes fine and \
server is up and running. but trying to INSERT/UPDATE anything, server crashes:<br> \
<br> Is it possible for you to send us a stacktrace?<br>
<br>
<a href="https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend" \
rel="noreferrer" target="_blank">https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend</a><br>
 <br>
Thanks<br>
-- <br>
Peter Geoghegan<br>
</blockquote></div>
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]