[MDEV-24785] ALTER TABLE with CHECK CONSTRAINTS gives "Out of Memory" error even table is empty and just created. Also, already confirmed that there is enough memory on the instance. Created: 2021-02-04 Updated: 2021-02-05 Resolved: 2021-02-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | 10.4.16 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | pk | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
centos7 |
||
| Issue Links: |
|
||||||||
| Description |
|
I am getting the error "ERROR 1041 (HY000): Out of memory." on creating check constraints. Also for any ALTER table command the same error is being thrown. please help in understanding and resolving the issue. |
| Comments |
| Comment by Alice Sherepa [ 2021-02-04 ] |
|
Is it the same problem as |
| Comment by pk [ 2021-02-05 ] |
|
yes it seems like its the same issue. please let me know if this is fixed in any other version and when was it introduced so that we can plan a proper version accordingly and decide on our next steps for future security updates and version updates. MariaDB [test]> CREATE TABLE `tab` ( -> CONSTRAINT `caller_id` CHECK (`caller_id` regexp '^[A-Z]{2} $') MariaDB [test]> alter table tab force; |