| From: | Mukesh Chhatani <chhatani(dot)mukesh(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Postgres 10.4 crashing when using PLV8 |
| Date: | 2018-06-20 19:46:47 |
| Message-ID: | CACnmOYKebo1y6j5ZOS5aWNyRmq8LFU2WoCPUsPhi1nj-c_kwrA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| Attachment | Content-Type | Size |
|---|---|---|
| postgres_10_4_crash_logs.txt | text/plain | 22.6 KB |
| postgres_10_4_crash_schema.sql | application/octet-stream | 19.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2018-06-20 19:49:34 | Re: Is there a way to be notified on the CREATE TABLE execution? |
| Previous Message | Hellmuth Vargas | 2018-06-20 19:21:11 | Re: Is postorder tree traversal possible with recursive CTE's? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2018-06-20 20:02:19 | Re: Postgres 10.4 crashing when using PLV8 |
| Previous Message | Stephen Frost | 2018-06-20 19:45:56 | Re: [PATCH] Include application_name in "connection authorized" log message |