While running a query on Classic 2.1 I received the following error:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statments. operating system
directive write failed. Invalid argument.

The query:


select c.rxcui,c.sab,c.tty,c.str from rxnsat n, rxnconso c
where c.rxcui = n.rxcui
and (((c.SAB = 'RXNORM') and c.TTY in ('SCD','SBD','IN'))) OR
((c.sab = 'VANDF') and (n.atn in
('DDF','VA_CLASS_NAME','VA_GENERIC_NAME') and (c.tty = 'IN')) OR
((c.sab = 'MTHFDA') and (c.tty in ('CD','MTH_RXN_CD','IN')))
)
order by 1,3
rows 100

Table specs:

RXNSAT: 4,200,000+ rows
RXNCONSO: 700,000+ rows

Plan info:
PLAN SORT (JOIN (N NATURAL, C INDEX (X_RXNCONSO_RXCUI, X_RXNCONSO_TTY,
IDX_RXNCONSO_SAB, X_RXNCONSO_TTY, X_RXNCONSO_TTY, X_RXNCONSO_TTY,
IDX_RXNCONSO_SAB)))

------ Performance info ------
Prepare time = 15ms
Execute time = 7m 16s 0ms
Current memory = 9,875,344
Max memory = 88,566,372
Memory buffers = 512
Reads from disk to cache = 842,415
Writes from cache to disk = 0
Fetches from cache = 21,266,516


The platform:

MandrivaOne Linux 2009

3.0 GB RAM
cat /proc/meminfo:

MemTotal: 3635128 kB
MemFree: 3393716 kB
Buffers: 28408 kB
Cached: 127836 kB
SwapCached: 0 kB
Active: 183700 kB
Inactive: 3240 kB
HighTotal: 2752256 kB
HighFree: 2590856 kB
LowTotal: 882872 kB
LowFree: 802860 kB
SwapTotal: 4088500 kB
SwapFree: 4088412 kB
Dirty: 68 kB
Writeback: 0 kB
AnonPages: 30552 kB
Mapped: 23724 kB
Slab: 36364 kB
SReclaimable: 30160 kB
SUnreclaim: 6204 kB
PageTables: 1076 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 5906064 kB
Committed_AS: 62664 kB
VmallocTotal: 114680 kB
VmallocUsed: 13208 kB
VmallocChunk: 100728 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 4096 kB
DirectMap4k: 4096 kB
DirectMap4M: 913408 kB

df -h:
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 22G 2.1G 20G 10% /
/dev/sda6 200G 4.5G 196G 3% /data
/dev/sda7 20G 38M 20G 1% /home
/dev/ram0 1.8G 0 1.8G 0% /mnt/ramdisk
//10.20.30.23/David_Code
297G 72G 225G 25% /mnt/WELLBACK/DavidCode

I can't find any documentation on this, does anyone have any advice?

Thanks.

David Keith