Unable to terminate process started from PLV8 function

2018-06-13 Thread Mukesh Chhatani
Hello Team, We are trying to use PLV8 function to calculate the histograms and while testing the function we found that with some of the data, function was going into the infinite loop. We tried to kill the session using pg_terminate_backend(pid) but process could not get killed, we terminated th

Postgres 10.4 crashing when using PLV8

2018-06-20 Thread Mukesh Chhatani
Hello Team, I am trying to use the PLV8 via function and while using the function created via PLV8 in one of the create materialized view, postgres crashes, attached is the log file with DEBUG5 turned on. SQL which is breaking the code and SQL function is attached. Creating materialized view - m

Re: Postgres 10.4 crashing when using PLV8

2018-06-20 Thread Mukesh Chhatani
Wed, Jun 20, 2018 at 12:46 PM, Mukesh Chhatani < > chhatani.muk...@gmail.com> wrote: > >> I am trying to use the PLV8 via function and while using the function >> created via PLV8 in one of the create materialized view, postgres crashes, >> attached is the log file w