Problem with proutil

T

triqt

New Member
Hi,

I ran proutil command few times with different parameters, but I get the same error. I thought it was disk space, but it wasn't.

command:
proutil timeware -C idxbuild all -T /dump/db_dump -TB 31 -TM 32 -B 20000

Error:
Phase 1, processing block number 238848 of 277586 in area 8. (8367)
Phase 1, processing block number 239104 of 277586 in area 8. (8367)
SYSTEM ERROR: Seek error 22, file 5, addr -2147422208. (163)
** Save file named core for analysis by Progress Software Corporation. (439)
Quit
 
You've bumped into a 2GB file size limit.

What version of Progress are you running and what platform are you running it on?

Quick fix -- create a file called dbname.srt (replace "dbname" with your actual database name):

1000000 /tmp/
1000000 /tmp/
1000000 /tmp/
1000000 /tmp/
1000000 /tmp/
/tmp/

This is what is known as a "multi volume sort file". It will allow the index rebuild to use multiple "extents" when sorting data. In this case up to 5 1GB extents in the /tmp directory. Plus a 6th of whatever size Progress/OS/filesystem will allow. Rather than /tmp use a filesystem with lots of space and no activity (such as /dump/db_dump). The trailing "/" is important. Do not put any blank lines or tabs in the file either.
 
Tom,
We are running: PROGRESS Version 9.1D and Red Hat Linux release 7.3.

Correct me if I understand you correctly?
If my database name is "timeware.db", I need to create a file name timeware.srt with the content

1000000 /dump/db_dump/
1000000 /dump/db_dump/
1000000 /dump/db_dump/
1000000 /dump/db_dump/
1000000 /dump/db_dump/
/dump/db_dump/
 
Correct.

BTW -- I have no idea how much space you should allocate for the index rebuild. I used 5 1GB extents as an example. In reality you should probably allocate around 2x the largest table size.
 
Thank you Tom,

We have 5GB of space, but it went through as your advise. Many thanks again.

triqt
 
You must log in or register to reply here.
Back
Top