Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle on solaris 8 & Truss

Status
Not open for further replies.
Igaduma

Igaduma

Technical User
Nov 23, 2001
322
BE
Hi all,

I'm seeing strange behaviour of an oracle database here which is polled by an application every 5 hours, which imports network parameters (2 million lines insert and update) but at some point it stops and just sits there occupying the cpu.
After waiting it can 'snap' out of it and finishes, but mostly it just seems to hang without doing anything for hours on end.
Trussing the process outputs an error number which somebody might understand:

read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
semctl(983040, 8, 8, 1) = 0
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
write(13, "\0 7\0\006\0\0\0\0\0\b01".., 55) = 55
read(13, "\082\0\006\0\0\0\0\011 i".., 2064) = 130
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
semctl(983040, 8, 8, 1) = 0
lwp_cond_signal(0xFE933FA0) = 0
lwp_cond_wait(0xFE933FA0, 0xFE933FB0, 0x00000000) = 0
kaio(AIOWAIT, 0xFFFFFFFF) Err#22 EINVAL
pwrite64(407, "\b02\0\002 @\00302 I b 4".., 65536, 24576) = 65536
lwp_cond_signal(0xFE957FA0) = 0
lwp_cond_wait(0xFE957FA0, 0xFE957FB0, 0x00000000) = 0
kaio(AIOWAIT, 0xFFFFFFFF) Err#22 EINVAL
pread64(407, "\b02\0\002 @\00302 I b 4".., 32768, 24576) = 32768
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
semctl(983040, 8, 8, 1) = 0
kill(14542, SIGWINCH) = 0
lwp_cond_signal(0xFE921FA0) = 0
lwp_cond_wait(0xFE921FA0, 0xFE921FB0, 0x00000000) = 0
kaio(AIOWAIT, 0xFFFFFFFF) Err#22 EINVAL
pwrite64(407, "\b02\0\002 @\00302 I bB5".., 65536, 24576) = 65536
lwp_cond_signal(0xFE98DFA0) = 0
lwp_cond_wait(0xFE98DFA0, 0xFE98DFB0, 0x00000000) = 0
kaio(AIOWAIT, 0xFFFFFFFF) Err#22 EINVAL
pread64(407, "\b02\0\002 @\00302 I bB5".., 32768, 24576) = 32768
lwp_cond_signal(0xFE97BFA0) = 0
lwp_cond_wait(0xFE97BFA0, 0xFE97BFB0, 0x00000000) = 0
kaio(AIOWAIT, 0xFFFFFFFF) Err#22 EINVAL
pread64(407, "\b02\0\002 @\00702 I bB7".., 32768, 57344) = 32768
semctl(983040, 8, 8, 1) = 0
semctl(983040, 8, 8, 1) = 0
getcontext(0xFFBE6C68)
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
semop(983040, 0xFFBE6F74, 1) = 0
sigprocmask(SIG_BLOCK, 0xFFBE6D7C, 0x00000000) = 0
setitimer(ITIMER_REAL, 0xFFBE6D04, 0x00000000) = 0
sigprocmask(SIG_UNBLOCK, 0xFFBE6D7C, 0x00000000) = 0
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
write(13, "\0\v\0\0\f\0\0\001\001", 11) = 11
write(13, "\0\v\0\0\f\0\0\001\002", 11) = 11
read(13, "\0\v\0\0\f\0\0\001\002", 2064) = 11
lseek(9, 2560, SEEK_SET) = 2560
read(9, "\0\n\0\0\0\0\0 D\001\0\0".., 512) = 512
lseek(9, 117760, SEEK_SET) = 117760
read(9, "\0\n19 n\0\0\0 D19 o\0\0".., 512) = 512
lseek(9, 117760, SEEK_SET) = 117760
read(9, "\0\n19 n\0\0\0 D19 o\0\0".., 512) = 512
write(13, "\0B3\0\006\0\0\0\0\004\0".., 179) = 179
read(13, "\092\0\006\0\0\0\0\003 ^".., 2064) = 146
write(13, "\0 B\0\006\0\0\0\0\0\v05".., 66) = 66
read(13, "\09E\0\006\0\0\0\0\011 i".., 2064) = 158
pread64(406, "0602\0\00201A3E0\0 B O9D".., 8192, 0x347C0000) = 8192
pread64(406, "0602\0\002\0B7 0\0 B O9B".., 8192, 0x16E60000) = 8192
pread64(406, "0602\0\002\0B7 1\0 B O9B".., 8192, 0x16E62000) = 8192


Its the Err#22Einval which seems to be an &quot;invalid <something>&quot;.
Any help is greatly appriciated.

T
 
Sort by date Sort by votes
EINVAL, according to /usr/sys/include/errno.h, just means &quot;invalid argument&quot;.

My guess is that it would just be a red herring though. It may be quite normal for system calls to return errors in that situation.

Annihilannic.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arciua
  • Locked
  • Question
SUN Solaris 7: How to pin Workspace Menu?
Replies
0
Views
598
arciua
arciua
austinramsay
  • Locked
  • Question
Solaris 10 install hanging at 3%.. Where to find log file, or ideas?
Replies
1
Views
582
AvayaTier3
AvayaTier3
MauroCMSVR
  • Locked
  • Question
Print as PDF file in Solaris System
Replies
0
Views
468
MauroCMSVR
MauroCMSVR
thiruram
  • Locked
  • Question
SOLARIS 8
Replies
1
Views
500
SamBones
SamBones
ZahidHaseeb1978
  • Locked
  • Question
Start /SYS on SUN SPARC does not start machine [SUN SPARC ENTERPRISE T-5240]
Replies
0
Views
459
ZahidHaseeb1978
ZahidHaseeb1978

Part and Inventory Search

Sponsor

Back
Top