Re: "HPUX-ia64 Error: 27: File too large" (1562 Views)
Reply
Advisor
GSK_2
Posts: 47
Registered: ‎01-09-2006
Message 1 of 11 (1,562 Views)

"HPUX-ia64 Error: 27: File too large"

Hi Guys,

We are getting these erroe while creating indexes in the database as oracle user. The mount point to where these creation is taking place has large files enabled. I have checked ulimit as well. Is that anything i still need to do to make the oracle team going ahead with creating indexes.
Error Begin ==>
ORA-12801: error signaled in parallel query server P004

ORA-27059: could not reduce file size

HPUX-ia64 Error: 27: File too large

Additional information: 2

ORA-27059: could not reduce file size

HPUX-ia64 Error: 27: File too large
=======
ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 4293702676
stack(kbytes) 131072
memory(kbytes) unlimited
coredump(blocks) 4194303

=======
When i checked for this ("ORA-27059: could not reduce file size")error in google.
It gave these info:
ORA-27059: could not reduce file size
Cause: ftruncate system call returned error
Action: check errno


Can you please advice as to what needs to be done to get past this error. Thanks in advance.

Regards,
Satish
Honored Contributor
Yogeeraj_1
Posts: 4,613
Registered: ‎11-25-2001
Message 2 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

hi Satish,

please clarify:
1. Is the file system NFS mounted?
2. Do you have enough free space available on the file system?
3. what is the approximate size of the index which you are trying to create?


revert
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Advisor
GSK_2
Posts: 47
Registered: ‎01-09-2006
Message 3 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"


Hi,

We have sufficient space left on filesystem.
The size of the FS is 445Gig and it is now 12% used. It is a local FS. The size of the indexes which are getting created is 3gb.
Just for info
/dev/u51/lvol1 /u51 vxfs rw,suid,largefiles,delaylog,datainlog 0 2

Regards,
satish
Honored Contributor
Yogeeraj_1
Posts: 4,613
Registered: ‎11-25-2001
Message 4 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

hi again,

can you do a simple copy test to confirm if this is an Oracle or OS issue?

cp /u51/tmp

you may take any huge file (preferrably greater than 3GB)

In case of an OS issue, the error ...






No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Advisor
GSK_2
Posts: 47
Registered: ‎01-09-2006
Message 5 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

Hi Yogeeraj,

We have already created 12GB file on this FS without any problem.

Regards,
Satish
Honored Contributor
Patrick Wallek
Posts: 13,786
Registered: ‎06-21-2000
Message 6 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

Are you absolutely sure the filesystem on this LV was created as largefiles?

What does the following return:

# fsadm -F vxfs /u51
Honored Contributor
Hein van den Heuvel
Posts: 6,588
Registered: ‎05-19-2003
Message 7 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

Satish,

Sound to me like Oracle is confused about the actual datafile sizes. Maybe you want to query those and compare with actuals?

Talk to us some more about the commands used and the tablespaces/datafile uses.

The error occurs on a CREATE INDEX?
Are the datafiles pre-allocated or growing?
Using Oracle ASM, Raw, LVM, Filesystems ?
Which Oracle version?

A google for this message brought up a topic with 'Veritas QuickIO'. I don't suppose that applies here?

Also, the error suggests you are using degrees of parralel to create the index.
If you do a 'normal' create, does it work albeit slower?


Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
Honored Contributor
Yogeeraj_1
Posts: 4,613
Registered: ‎11-25-2001
Message 8 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

hi again,

After you run Patrick's test, can you try to create a test tablespace on this file system?

e.g.

CREATE TABLESPACE LARGE01 DATAFILE
'//large_datafile.dbf' SIZE 4096M AUTOEXTEND ON NEXT 50M MAXSIZE 33554416K
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
/

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Honored Contributor
Yogeeraj_1
Posts: 4,613
Registered: ‎11-25-2001
Message 9 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

Hi again,

can you also post your create index script?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Advisor
GSK_2
Posts: 47
Registered: ‎01-09-2006
Message 10 of 11 (1,562 Views)

Re: "HPUX-ia64 Error: 27: File too large"

Hi,

The above fsadm command gave largefiles as output.
Yes, while creating the index.
The index size is around 3gb...
The filesystem is LVM
The error occured at the time of create index
we are running in parallel processes to make it fast...
oracle version is 10.2
the datafiles are growing...

Regards,
Satish
Occasional Visitor
Yves Wouters_1
Posts: 1
Registered: ‎03-23-2003
Message 11 of 11 (1,372 Views)

Re: "HPUX-ia64 Error: 27: File too large"

There is also a known bug which can cause this kind of error

 

 

      PHKL_41594: 11.31 VRTS 5.0.1 GARP3P5 VRTSvxfs Kernel Patch

      (SR: QXCR1001061554 )

      SYMANTEC Incident Number:  2160728 (2106668)

      A write operation followed by an fsadm(1M) resize operation

      may cause an error and generate the following message:

      "write error : File too big"

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.