|
Any Update on the issue ?? This is critical production issue
|
|
Is it reproducible by re-running the same query? I assume it must be, if you are saying it's a critical production issue.
Please provide the output of
SHOW CREATE TABLE product_matching_candidates;
|
SHOW INDEX IN product_matching_candidates;
|
SHOW GLOBAL VARIABLES;
|
|
|
[^Tableinfo&Indexinfo.txt globalvariables.txt ]
Including Attachments and waiting for reply.
|
|
Are you waiting for anything from my end ?
|
Are you waiting for anything from my end ?
Actually yes, an answer to the question "Is it reproducible by re-running the same query?"
|
|
We are not able to reproduce the crash every time we ran the query and Table is crashing due to Select,alter,update and insert queries.
We do not have a continuous crash.
We narrowed down the issue and found its because of stored generated field in the table.
Can you confirm us if there is any bug in stored generated column's ?
|
|
We have some known bugs related to virtual generated columns, although i can't find anything obviously related about stored columns. We might still have something, but due to a missing stack trace in the error log we cannot match this crash with any particular known bug. Would you be able to acquire a coredump and run gdb --batch --eval-command="thread apply all bt" <path to mysqld binary> <path to coredump> on it?
|
|
Hi,
Can you provide any other solution or is it mandatory to run acquire a coredump and run gdb --batch --eval-command="thread apply all bt" <path to mysqld binary> <path to coredump> ?
We are still having this issue. To make a note this database is in docker and there are stored generated columns in the tables, either one of the above things is causing crash ?
|
|
An alternative solution would be to acquire a support contract, as it's customary for critical production environments. In this case support engineers could assist you at investigating the problem. If you already have a support contract, please submit a support ticket.
|
Error.log