jsonb_plperl, jsonb_plpython: Fix unguarded recursion and loops.
Tom Lane <tgl@sss.pgh.pa.us>
jsonb_plperl, jsonb_plpython: Fix unguarded recursion and loops. Add check_stack_depth() to Jsonb_to_SV, SV_to_JsonbValue, PLyObject_FromJsonbContainer, and PLyObject_ToJsonbValue. Without this, deeply nested JSONB values can crash the backend with SIGSEGV instead of raising a proper error. Also add CHECK_FOR_INTERRUPTS() to the while loop in SV_to_JsonbValue that dereferences chains of Perl references, so that a circular reference (e.g. $x = \$x) can be cancelled by the user instead of spinning indefinitely. (We looked at detecting such circular references, but it seems more trouble than it's worth.) Author: Aleksander Alekseev <aleksander@tigerdata.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CAJ7c6TPbjkzUk4qJ5dHvDNEz0hBuFue3A-XWz_=897z+BC+z8A@mail.gmail.com Backpatch-through: 14
Files
| Path | Change | +/− |
|---|---|---|
| contrib/jsonb_plperl/jsonb_plperl.c | modified | +15 −0 |
| contrib/jsonb_plpython/jsonb_plpython.c | modified | +7 −0 |
Discussion
- [PATCH] Fix segmentation fault and infinite loop in jsonb_{plperl,plpython} 11 messages · 2026-06-16 → 2026-06-18