Information

Title	Extent exceeds 2 GB file size limit - Enable large file support

URL Name	P11518

Article Number	000154019

Environment	Product: Progress Version: 9.1C, 9.1D, 9.1E Product: OpenEdge Version: 10.x, 11.x OS: All supported platforms

Question/Problem Description

Database Extent exceeds 2 GB file size limit - Enable large file support
Any Database Extent exceeds the 2 GB default limit

Steps to Reproduce

Clarifying Information

File system configured for Large File Support in UNIX and NTFS on Windows
Enterprise Database License installed
Sum of area extents do not exceed MAXAREA limit

Error Message	SYSTEM ERROR: Unable to extend database within area <pareaName>. (8897) SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (10601) SYSTEM ERROR: Unable to extend the database. (111) <function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (6091) <function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset 2147467264, file <file-name>. (6091) bkxtn: write error, file <file-name> errno: <number>. (3646) SYSTEM ERROR: File <file-name> too small <length>, blocksize <blocksize> extend failed." (4524) Unable to extend data files enough to proceed. (6743) SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (9452)

Error Message

SYSTEM ERROR: Unable to extend database within area <pareaName>. (8897)
SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (10601)
SYSTEM ERROR: Unable to extend the database. (111)
<function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (6091)
<function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset 2147467264, file <file-name>. (6091)
bkxtn: write error, file <file-name> errno: <number>. (3646)
SYSTEM ERROR: File <file-name> too small <length>, blocksize <blocksize> extend failed." (4524)
Unable to extend data files enough to proceed. (6743)
SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (9452)

Defect Number

Enhancement Number

Cause

Database extent file size is near the 2 GB limit and could not be extended further in order to be written to.

In the case of Progress 9.1C or later database versions, this could mean:

1) The file system was not created with large file support.

For an Operating System to support large files, the File System must be created with large file support. This is done via an operating system administration utility or an option supplied to mkfs or crfs to include large file support. It generally cannot be "turned on' after the file system has been created.

2) Operating System file size limit issue.

Users ulimit -f is not set large enough for them to create a file greater than 2 gig on UNIX or
Quota limits prevent files larger than 2GB on WINDOWS

3) Database Large file support

Large file support needs to be explicitly enabled on a Progress Enterprise database where the largefiles feature is available

Progress 9.1D first supported largefiles.
Progress 9.1E first supported large files on Linux,
Progress OpenEdge does not support largefiles on SCO Operating Systems.

Resolution

If the file system accommodates large files, filesize limits are set appropriately and an Enterprise Database License is in use, then enable large file support in Progress.

$ proutil dbname -C EnableLargeFiles

Once Large File Support is enabled, restart the database and it should proceed through crash recovery.

Workaround

Depending on the Database Extent that has reached the 2GB limit:

If it is a Data Area, add extents to the Storage Area. Refer to Article Recovering from 2GB Progress limit on extents
If it is a BI file, refer to Article How to recover when Bi file grows to 2GB with error 9452.
If it is an AI file, refer to Article ai extent reaches 2GB and returns error 4524

Notes

Progress Articles:

How to determine Operating System File Size limit - ulimit
When does the 2 billion rowid limit per Storage Area apply?

How to allow database extents larger than 2GB? (embedded video)

Keyword Phrase

Last Modified Date	11/20/2020 7:36 AM