I made a mistake in migrating data times:
[error]: error inserting data
Error SQLCode:[-271]
Error message:Could not insert new row into the table:(-271) ISAM error:no free disk space(-131)
After checking the storage space, it is found that the space is free. After inquiry, it is found that the database built by Informix will often report an error when importing a large amount of data.
You can search for settings about Informix’s extend size and next size.
How Informix determines the extent size and next size_ The growth of database technology… – CSDN blog
Then my solution is as like as two peas: i migrated data, so I set up a table structure that is exactly the same as the database to be migrated in the destination database, but the value of extent size and next size is needed to build the table statement. For example, if I want to migrate a 34 g table, set the value of my extent size to 33554430 (the default unit is KB, which is the maximum value, 32g) and the next size to 1048576 (1 g or 2 g). Of course, the table space is extensible.
Create table table name(
id CHAR(64),
age INTEGER
)
extent size 33554430 next size 1048576;
In tablespace name;
The values of ext size and next size are about the same as the data size, because my table space is extensible. If it is not extensible, it is better to be larger than the data size.
Read More:
- U disk installation Linux system could not boot, / dev / root does not exist and the identified hard disk space is not available
- Tomcat Error: because there was insufficient free space available after evicting expired cache entries
- Solve to the cache because there was insufficient free space available after evict
- Linux view folder size, remaining disk space (DU / DF)
- How to clean up the disk space of Linux server
- When installing software in Ubuntu, it prompts: E: You don’t have enough free space in /var/cache/apt/archives/.
- Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space
- The computer can’t turn on ERROR: NO BOOT DISK HAS BEEN DETECTED OR THE DISK HAS FAILED
- Error when creating partitions in Linux: no free sectors available solution
- MySQL workbench insert data prompt error: 1046 (errorcode: 1046. No database select…)
- Insert keyframe giving keying set failed to insert any key frames (solved)
- -bash: cannot create temp file for here-document: No space left on device
- Disk read error solution for new hard disk installation
- Insert keyframe giving keying set failed to insert any key frames
- Solve the problem of non system disk or disk error, replace and strike any key when ready
- Non system disk or disk error
- The solution of no space left on device always appears when using TF’s debug tool (tfdbg)
- QInotifyFileSystemWatcherEngine::addPaths: inotify_add_Watch failed: there is no space on the device
- Syntax error, insert “;” to complete Statement, insert “}” to complete Block
- Error splicing file: No space left on device