[MDEV-33809] Bulk insert or DDL fails if a BLOB is too long - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
Fix Version/s: 10.11.8, 11.0.6, 11.1.5, 11.2.4
Component/s: Storage Engine - InnoDB
Labels:
- regression

Description

As noted in ~~MDEV-33585~~, there is a limit on how much data a single system call can write. On FreeBSD, Linux, and Microsoft Windows, this limit would be much smaller than the size of a BLOB that could be buffered in a 64-bit address space of the server process.

Specifically, row_merge_write_blob_to_tmp_file() does not limit the size of a single os_file_write() request to at most 0x7fffff000 bytes, which is the limit on Linux.

Attachments

Issue Links

blocks

MDEV-33087 ALTER TABLE...ALGORITHM=COPY should build indexes more efficiently

Closed

is caused by

MDEV-27318 SIGSEGV in row_merge_tuple_sort and Assertion `data_size < srv_sort_buf_size' failed in row_merge_bulk_buf_add on INSERT with unique_checks and foreign_key_checks disabled

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2024-04-02 11:16

Updated:: 2024-04-16 13:52

Resolved:: 2024-04-16 13:51

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.