Info
Error Code:
1087
MariaDB Error 1087: Data Load Status Information
Description
Error 1087 in MariaDB is an informational message, not an error indicating a failure. It reports the summary of a data loading operation, such as `LOAD DATA INFILE`. This message provides counts for records processed, deleted, skipped, and the total number of warnings encountered during the operation.
Error Message
Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
Known Causes
4 known causesSuccessful Data Import Operation
This message inherently appears after any `LOAD DATA` statement or similar bulk import operation completes, providing a statistical summary of its execution.
Skipped Records Due to Data Issues
Records may be skipped if they violate table constraints, have duplicate primary keys, or contain data that cannot be inserted into the target columns.
Warnings During Data Processing
Warnings are generated when data is truncated, type conversions occur, or other non-fatal issues arise during the import, indicating potential data quality concerns.
Deletion of Existing Records
If the `REPLACE` option is used with `LOAD DATA INFILE`, existing records matching new ones are deleted before insertion, contributing to the 'Deleted' count.
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