[MDEV-29939] free(): invalid pointer st_mysql_lex_stringbPb Created: 2022-11-03 Updated: 2022-11-03 Resolved: 2022-11-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication, Triggers |
| Affects Version/s: | 10.9.3 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | nilin | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | crash | ||
| Environment: |
k8s (Ubuntu 21.10 5.13.0-52-generic) |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
The error is observed on the slave instance of mariadb. Replication makes changes to table data. With each change, it executes a trigger that marks the day in the results table for which data needs to be recalculated. The trigger in the results table sees the modify label and recalculates the value for the updated day The messages table has triggers for insert/update/delete to copy data to an analytics staging table like: Table messages_1 has triggers to mark changed days in the results table like: Result table: Trigger in results table like: CREATE PROCEDURE stats_time.upd_all(dateStart DATE, dateEnd DATE, newComment varchar(100)) CREATE DEFINER=`root`@`%` PROCEDURE stats_time.x_1_3_1(dateStart DATE, dateEnd DATE, newComment varchar(100)) CREATE DEFINER=`root`@`%` FUNCTION stats_time.calc_x_1_3_1(calcDate DATE) Also tried to stop replication when the stats_upd trigger is activated and put the trigger commands in a transaction - the same result. |
| Comments |
| Comment by Alice Sherepa [ 2022-11-03 ] |
|
Thank you very much for the report! |