Troubleshooting database file size (file write fails)

Administrator Guide : Troubleshooting and support : Troubleshooting a problem : Troubleshooting database file size (file write fails)

If your database has reached the maximum size specified by the IndexFile.FileSpec parameter, you need to increase the maximum file size limit or divide the database into multiple files.

Symptom

solidDB^® goes down with

Error 11003 File write failed, configuration exceeded (SU_ERR_FILE_WRITE_CFG_EXCEEDED).

Resolving the problem

▪Add a new database file by using the following command:

ADMIN COMMAND 'filespec -a "file_name max_file_size_in_bytes [device_number]"]'

For example:

ADMIN COMMAND 'filespec -a "solid2.db 2147483647"'

You can add new database files only with the ADMIN COMMAND 'filespec ‑a' command, you cannot modify the size of existing database files.

The new database file specification is stored in the solid.ini configuration file at next shutdown.

1 Shut down solidDB^®.

2 Modify the IndexFile.FileSpec parameter in the solid.ini file.

▪Increase the maximum limit for the database file.

▪Divide the database into multiple files by using the FileSpec_[1..n] format.

For example:

[IndexFile]
FileSpec_1 = solid.db 2147483647
FileSpec_2 = solid.db2 2147483647
FileSpec_3 = solid.db3 2147483647

If you have not defined the FileSpec_1 parameter earlier, use the default file size (2147483647) as shown above.

3 Restart solidDB^®.

Related information

Managing parameters

ADMIN COMMAND syntax