Postgres 10.4 crashing when using PLV8
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 - mat_view_by_product - is the one which causes
the crash.
I have tested the same in below environments
1. Test 1 - Passed
Mac , Postgres - 10.4, PLV8 - 2.1.0
2. Test 2 - Passed
AWS RDS , Postgres - 9.6.6 , PLV8 - 1.5.0
3. Test 3 - Fail, This test was passing earlier on 10.3 but fails on 10.4
AWS EC2 , Postgres - 10.4, PLV8 - 2.3.4
4. Test 4 - Fail
AWS RDS , Postgres - 10.3 , PLV8 - 2.1.0
Please let me know if any more information is required to assist in this
problem.
Thanks for your help.
On Wed, Jun 20, 2018 at 12:46 PM, Mukesh Chhatani <chhatani.mukesh@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 with DEBUG5 turned on.
These are not the correct place to post possible bug reports for
third-party extensions. plV8 has an active Issues listing on GitHub and
you should post your observations there. They can report upstream to us if
there is indeed something specific in core causing their code to fail.
Additionally, in the future if you find that your email is indeed a core
PostgreSQL issue please just submit it to one of the available lists. If
you are unsure pgsql-general is a safe choice. For this email enough
information has been provided that our official pgsql-bugs email list (or
form) would be acceptable and indeed preferred.
David J.
Thanks David for the response, I have opened a issue with PLV8 team.
Let me know if I should report this bug to postgres or not, since I was not
sure thus I sent email earlier.
Regards,
Mukesh
On Wed, Jun 20, 2018 at 3:02 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:
Show quoted text
On Wed, Jun 20, 2018 at 12:46 PM, Mukesh Chhatani <
chhatani.mukesh@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 with DEBUG5 turned on.These are not the correct place to post possible bug reports for
third-party extensions. plV8 has an active Issues listing on GitHub and
you should post your observations there. They can report upstream to us if
there is indeed something specific in core causing their code to fail.Additionally, in the future if you find that your email is indeed a core
PostgreSQL issue please just submit it to one of the available lists. If
you are unsure pgsql-general is a safe choice. For this email enough
information has been provided that our official pgsql-bugs email list (or
form) would be acceptable and indeed preferred.David J.