Info
Error Code:
1092
MariaDB Error 1092: Bulk Insert Outcome Summary
Description
This informational message (not an error) is returned by MariaDB after a bulk data insertion operation, such as `LOAD DATA INFILE` or `INSERT ... ON DUPLICATE KEY UPDATE`. It provides a summary of the operation's outcome, detailing the total records processed, the number of duplicate entries encountered, and any warnings generated during the process.
Error Message
Records: %ld Duplicates: %ld Warnings: %ld
Known Causes
3 known causesDuplicate Key Violations
Attempting to insert new rows that have values identical to existing unique keys (PRIMARY KEY or UNIQUE index) in the target table, leading to duplicate counts.
Data Type Mismatches
Inserting values that do not match the target column's data type, resulting in implicit conversions, data truncation, or other issues that generate warnings.
Malformed Input Data
The input data file (e.g., for `LOAD DATA INFILE`) contains rows that are not correctly formatted or have missing values for non-nullable columns, causing warnings.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service