Skip site navigation (1)Skip section navigation (2) 
Date:      Tue, 25 Dec 2001 15:45:51 +0700
From:      Eugene Grosbein <eugen@www.svzserv.kemerovo.su>
To:        stable@freebsd.org
Subject:   IBCS2 support broken in STABLE?
Message-ID:  <20011225154551.A74620@svzserv.kemerovo.su>
next in thread | raw e-mail | index | archive | help 

Hi!

I need to connect to remote Oracle server from FreeBSD so I installed
a part of Oracle Workgroup server for FreeBSD (ex. SCO version) v. 7.3.3.0
(not database itself but some files).

My kernel is compiled with IBCS2 and SHMEM support and SQL*Plus worked
fine. All was fine with FreeBSD 3.5-STABLE.

Then I've upgraded my system to 4.4-RELEASE using binary upgrade
and then to 4.4-STABLE (2 Novermber 2001) via cvsup. 
All run just fine but not sqlplus. It starts as usual, 
asks for username/password then breaks with signal 12 and 
'Bad system call' message. 
And for some unknown reason I get zero-sized corefile.
I have coredumpsize unlimited and there is enough of disk space.

So, is IBCS2 support (partially) broken in STABLE?
tnsping still work as usual, however.

Here is a very tail of kdump output:

 ........
 75781 sqlplus  CALL  write(0x9,0x462abe,0x108)
 75781 sqlplus  GIO   fd 9 wrote 264 bytes
       "\^A\b\0\0\^A\0\0\0\^A5\^A,\f\^A\b\0\^T\0N\0\0\^A\0\0\0002\0\0\b\0\^A\
	\^A\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0(DESCRIPTION=(ADDRESS=(PROTOCOL=beq\
	)(PROGRAM=/usr/local/oraclient/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRI\
	PTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=\
	(CID=(PROGRAM=)(HOST=www)(USER=root))))"
 75781 sqlplus  RET   write 264/0x108
 75781 sqlplus  CALL  read(0xa,0x46228a,0x800)
 75781 sqlplus  GIO   fd 10 read 24 bytes
       "\0\^X\0\0\^B\0\0\0\^A5\f\^A\b\0\^T\0\^A\0\0\0\0\^X\^A\^A"
 75781 sqlplus  RET   read 24/0x18
 75781 sqlplus  CALL  getegid(0xbfbfb3b0)
 75781 sqlplus  RET   getegid 2142687096/0x7fb6cf78
 75781 sqlplus  CALL  getpid
 75781 sqlplus  RET   getpid 75781/0x12805
 75781 sqlplus  CALL  getegid(0xbfbfb028)
 75781 sqlplus  RET   getegid 2142687096/0x7fb6cf78
 75781 sqlplus  CALL  write(0x9,0x462abe,0x9b)
 75781 sqlplus  GIO   fd 9 wrote 155 bytes
       "\0\0\0\^F\0\0\0\0\0ޭ\0\^B00\0\0\^D\0\0\^D\0\^C\0\0\0\0\0\^D\0\^E\
	\^A\0\^P\0\0\b\0\^A\0\^A(\^E\^?x\0\^R\0\^Aޭ\0\^C\0\0\0\^D\0\^D\0\
	\^A\0\^A\0\^B\0\^A\0\^E\0\0\0\0\0\^D\0\^E\^B00\0\0\^B\0\^C\0\^B\0\^F\
	\0\^A\0\^B\^B\0\^C\0\0beq\0\^B\0\^B\0\0\0\0\0\^D\0\^E\^B0\^A\0\0\^A\
	\0\^A\0\0\^C\0\^B\0\0\0\0\0\^D\0\^E\^B0\^A\0\0\^A\0\^A\0"
 75781 sqlplus  RET   write 155/0x9b
 75781 sqlplus  CALL  read(0xa,0x46228a,0x800)
 75781 sqlplus  GIO   fd 10 read 139 bytes
       "\0\0\0\^F\0\0\0\0\0ޭ\0\^B00\0\0\^D\0\0\^D\0\^C\0\0\0\0\0\^D\0\^E\
	\^A\0\^P\0\0\^B\0\^F\0\^_\0\^N\0\^Aޭ\0\^C\0\0\0\^B\0\^D\0\^A\0\^A\0\
	\^D\0\0\0\0\0\^D\0\^E\^B00\0\0\^B\0\^F\0\^A\0\^B\^B\0\^C\0\0beq\0\^B\
	\0\^B\0\0\0\0\0\^D\0\^E\^B0\^A\0\0\^A\0\^B\0\0\^C\0\^B\0\0\0\0\0\^D\0\
	\^E\^B0\^A\0\0\^A\0\^B\0"
 75781 sqlplus  RET   read 139/0x8b
 75781 sqlplus  CALL  old.sigprocmask(0x118,0x1)
 75781 sqlplus  RET   old.sigprocmask 0
 75781 sqlplus  CALL  ioctl(0,0x5401 ,0xbfbfe1ca)
 75781 sqlplus  RET   ioctl 0
 75781 sqlplus  CALL  sendmsg(0,0xbfbfe1b8)
 75781 sqlplus  RET   sendmsg 0
 75781 sqlplus  CALL  open(0x448665,0x80,0x43ee24)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/"
 75781 sqlplus  RET   open 8
 75781 sqlplus  CALL  old.fstat(0x8,0x2,0x1)
 75781 sqlplus  RET   old.fstat 0
 75781 sqlplus  CALL  sendmsg(0x8,0xbfbfe08c)
 75781 sqlplus  RET   sendmsg 0
 75781 sqlplus  CALL  getpgrp(0x8,0x45d6dc,0x418)
 75781 sqlplus  RET   getpgrp 526/0x20e
 75781 sqlplus  CALL  getpgrp(0x8,0x45d6dc,0x418)
 75781 sqlplus  RET   getpgrp 0
 75781 sqlplus  CALL  old.lseek(0x8,0,0x1)
 75781 sqlplus  RET   old.lseek 512/0x200
 75781 sqlplus  CALL  old.lseek(0x8,0,0)
 75781 sqlplus  RET   old.lseek 0
 75781 sqlplus  CALL  getpgrp(0x8,0x45d6dc,0x418)
 75781 sqlplus  RET   getpgrp 526/0x20e
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/."
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/."
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/.."
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/dev/.."
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/X0R"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/X0R"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/socksys"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/socksys"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/spx"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/spx"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/null"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/null"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/nfsd"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/nfsd"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getpgrp(0x8,0x45d6dc,0x418)
 75781 sqlplus  RET   getpgrp 0
 75781 sqlplus  CALL  old.lseek(0x8,0,0x1)
 75781 sqlplus  RET   old.lseek 512/0x200
 75781 sqlplus  CALL  old.lseek(0x8,0,0)
 75781 sqlplus  RET   old.lseek 0
 75781 sqlplus  CALL  getpgrp(0x8,0x45d6dc,0x418)
 75781 sqlplus  RET   getpgrp 526/0x20e
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/X0R"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/X0R"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/socksys"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/socksys"
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  getfsstat(0x448665,0xbfbfe120)
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/spx"
 75781 sqlplus  NAMI  "/compat/ibcs2"
 75781 sqlplus  NAMI  "/compat/ibcs2/dev/spx"
 75781 sqlplus  PSIG  SIGCHLD caught handler=0x4ea5c mask=0x0 code=0x0
 75781 sqlplus  RET   getfsstat 0
 75781 sqlplus  CALL  old.sigprocmask(0x112,0)
 75781 sqlplus  RET   old.sigprocmask 2
 75781 sqlplus  CALL  old.sethostname
 75781 sqlplus  PSIG  SIGSYS SIG_DFL
 75781 sqlplus  NAMI  "sqlplus.core"

Eugene Grosbein

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-stable" in the body of the message

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20011225154551.A74620>