Обсуждение: PG12 Server on crash on creating FTS dictionary
Hi Team,
I've encountered a server crash on creating FTS dictionary with below SQLs:
CREATE TEXT SEARCH TEMPLATE public.ftstemp (
INIT = varchar_support,
LEXIZE = dispell_lexize
);
INIT = varchar_support,
LEXIZE = dispell_lexize
);
CREATE TEXT SEARCH DICTIONARY public.mydicttemp (
TEMPLATE = public.ftstemp
);
TEMPLATE = public.ftstemp
);
The logs says:
2020-07-14 15:09:32.350 IST [19671] LOG: server process (PID 73228) was terminated by signal 11: Segmentation fault: 11
2020-07-14 15:09:32.350 IST [19671] DETAIL: Failed process was running: CREATE TEXT SEARCH DICTIONARY public.mydicttemp (
TEMPLATE = public.ftstemp
);
2020-07-14 15:09:32.350 IST [19671] DETAIL: Failed process was running: CREATE TEXT SEARCH DICTIONARY public.mydicttemp (
TEMPLATE = public.ftstemp
);
2020-07-14 15:09:32.350 IST [19671] LOG: terminating any other active server processes
Version:
postgres=# select version();PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit
(1 row)
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EDB India | Pune
"Don't Complain about Heat, Plant a TREE"
Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> writes:
> I've encountered a server crash on creating FTS dictionary with below SQLs:
> CREATE TEXT SEARCH TEMPLATE public.ftstemp (
> INIT = varchar_support,
> LEXIZE = dispell_lexize
> );
This is just pilot error; varchar_support() is surely not a suitable
init function for a text search template.
(The reason this command is superuser-only is exactly that we have to
trust the user to specify a sane set of functions.)
regards, tom lane
On Tue, Jul 14, 2020 at 7:29 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> writes:
> I've encountered a server crash on creating FTS dictionary with below SQLs:
> CREATE TEXT SEARCH TEMPLATE public.ftstemp (
> INIT = varchar_support,
> LEXIZE = dispell_lexize
> );
This is just pilot error; varchar_support() is surely not a suitable
init function for a text search template.
I have no particular use-case for this. It was just a test case and the server crashed. Thought of sharing. Thanks.
(The reason this command is superuser-only is exactly that we have to
trust the user to specify a sane set of functions.)
regards, tom lane
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"