DataPump Export (EXPDP) Stopped with ORA-27072 ORA-19502 When Directory Resides on S3FS Filesystem
(Doc ID 2451839.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
DataPump Export fails when dmp file is generated directly on Amazon Cloud (i.e. s3fs Filesystem):
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"<OWNER>"."<TABLENAME>"]
SELECT SYS.KUPW$WORKER.GET_CONTAINER_ID FROM SYS.DUAL
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 12237
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 3849
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 19477
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-19502: write error on file "/<DIR>/<FILENAME>.dmp", block number 1504672 (block size=4096)
ORA-27072: File I/O error
Additional information: 4
Additional information: 1504672
Additional information: 163840
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 11265
----- PL/SQL Call Stack -----
object line object
handle number name
0xc7dfb410 27116 package body SYS.KUPW$WORKER
0xc7dfb410 11286 package body SYS.KUPW$WORKER
0xc7dfb410 2135 package body SYS.KUPW$WORKER
0xb9690290 2 anonymous block
SELECT SYS.KUPW$WORKER.GET_CONTAINER_ID FROM SYS.DUAL
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 12237
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 3849
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 19477
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-19502: write error on file "/<DIR>/<FILENAME>.dmp", block number 1504672 (block size=4096)
ORA-27072: File I/O error
Additional information: 4
Additional information: 1504672
Additional information: 163840
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 11265
----- PL/SQL Call Stack -----
object line object
handle number name
0xc7dfb410 27116 package body SYS.KUPW$WORKER
0xc7dfb410 11286 package body SYS.KUPW$WORKER
0xc7dfb410 2135 package body SYS.KUPW$WORKER
0xb9690290 2 anonymous block
There is no space issue on target folder:
Filesystem Size Used Avail Use% Mounted on
s3fs 128T 0 128T 0% /amazon
s3fs 128T 0 128T 0% /amazon
The /tmp folder is filling during the export.
If dd command is used to generate a new file in Amazon Cloud, the /tmp is filling and the process is ending with error:
dd if=/dev/zero of=/amazon/test.dmp bs=1024k count=1000000
dd: error writing on /amazon/test.dmp : No space left on device
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |