From owner-freebsd-emulation@FreeBSD.ORG Thu Mar 29 19:19:09 2012 Return-Path: Delivered-To: freebsd-emulation@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id B94DA106566B for ; Thu, 29 Mar 2012 19:19:09 +0000 (UTC) (envelope-from jjuanino@gmail.com) Received: from mail-bk0-f54.google.com (mail-bk0-f54.google.com [209.85.214.54]) by mx1.freebsd.org (Postfix) with ESMTP id 3F6818FC14 for ; Thu, 29 Mar 2012 19:19:08 +0000 (UTC) Received: by bkcjc3 with SMTP id jc3so3061424bkc.13 for ; Thu, 29 Mar 2012 12:19:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=L9Vv8UG61gxqwwea33gECWTa37og0B9YEwYCb05sfi4=; b=zkc3irznelIMGxF+8dSSbQN3ruzOx7ccrEsp0H0wafeD892M8ibxE+OHAi3CE36dCE q+RmwDoyOQlV85eC/Z72sJ+FMTZM8OGuh/zOvjmA0d6YoXGxrX2hWGO0DKoDbmNT/jS6 827SZcVnsx1HQBpxX5vXib4bscFWKkQfd158hOTFIb/USCKSEOtpsRdvGv2Z6c4IrYY/ AOFp122Yb8FiHnsVSwIyCu+IML/p+jHpz/HFbyQyvjkUoj+8HvMnI+25gltiC/ENdK2e dg8IRLfN09a1J/xN+X2i1MJwVVeuvB/+Vc6F8FiA7mbGXsZQqybkqsQKa8KmC0aaYo/1 cEsA== MIME-Version: 1.0 Received: by 10.205.132.145 with SMTP id hu17mr14788446bkc.66.1333048747731; Thu, 29 Mar 2012 12:19:07 -0700 (PDT) Received: by 10.205.81.70 with HTTP; Thu, 29 Mar 2012 12:19:07 -0700 (PDT) Date: Thu, 29 Mar 2012 21:19:07 +0200 Message-ID: From: =?ISO-8859-1?Q?Jos=E9_Garc=EDa_Juanino?= To: freebsd-emulation@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Subject: sqlplus crashes receiving INT signal (only for 11.2.0 release database server) X-BeenThere: freebsd-emulation@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Development of Emulators of other operating systems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 29 Mar 2012 19:19:09 -0000 Hi, I am running FreeBSD 9.0-RELEASE. My company has several Oracle Database servers. At this moment, we are using 11.2.0 on Sun Solaris. After start sqlplus oracle client and doing a CONTROL+C, client connection crashes: $ uname FreeBSD $ sqlplus /nolog SQL> connect user/password@database11_2_0 Connected. SQL> [Hit CONTROL+C to send INT signal to sqlplus] (At this point, sockstat -c4 -p 1521 shows a socket between my host and the oracle server) SQL> select 1 from dual; select 1 from dual * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE (At this point, the previous socket has gone out) The ktrace - linux_kdump shows: "SQL> " 29849 sqlplus RET write 5 29849 sqlplus CALL linux_fstat64(0,0xbfbf8d3c,0x34ee4ff4) 29849 sqlplus UNKNOWN(8) 29849 sqlplus RET linux_fstat64 0 29849 sqlplus CALL linux_mmap2(0,0x1000,0x3,0x22,0xffffffff,0) 29849 sqlplus RET linux_mmap2 886091776/0x34d0b000 29849 sqlplus CALL read(0,0x34d0b000,0x1000) 29849 sqlplus RET read RESTART 29849 sqlplus PSIG SIGINT caught handler=3D0x347fec2c mask=3D0x0 code=3D= 0x0 29849 sqlplus CALL linux_rt_sigprocmask(0,0xbfbf8bec,0,0x8) 29849 sqlplus RET linux_rt_sigprocmask 0 29849 sqlplus CALL linux_rt_sigprocmask(0x1,0xbfbf8bec,0,0x8) 29849 sqlplus RET linux_rt_sigprocmask 0 29849 sqlplus CALL linux_rt_sigreturn(0xbfbf8d50) 29849 sqlplus RET linux_rt_sigreturn JUSTRETURN 29849 sqlplus CALL read(0,0x34d0b000,0x1000) 29849 sqlplus GIO fd 0 read 1 byte " " 29849 sqlplus RET read 1 29849 sqlplus CALL write(0x1,0x34d0a000,0x1) 29849 sqlplus GIO fd 1 wrote 1 byte " " 29849 sqlplus RET write 1 29849 sqlplus CALL write(0x1,0x34d0a000,0x5) 29849 sqlplus GIO fd 1 wrote 5 bytes "SQL> " 29849 sqlplus RET write 5 29849 sqlplus CALL read(0,0x34d0b000,0x1000) 29849 sqlplus GIO fd 0 read 26 bytes "select 1 from dual; " 29849 sqlplus RET read 26/0x1a 29849 sqlplus CALL gettimeofday(0xbfbfae44,0) 29849 sqlplus RET gettimeofday 0 29849 sqlplus CALL linux_socketcall(0x9,0xbfbf5b00) 29849 sqlplus GIO fd 4 wrote 1 byte "!" 29849 sqlplus RET linux_socketcall 1 29849 sqlplus CALL write(0x4,0xbfbf5d00,0xb) 29849 sqlplus GIO fd 4 wrote 11 bytes "\0\v\0\0\f\0\0\0\^A\0\^B" 29849 sqlplus RET write 11/0xb 29849 sqlplus CALL read(0x4,0x80caf7e,0x810) 29849 sqlplus GIO fd 4 read 10 bytes "\0 \0\0\^F\0\0\0\0@" 29849 sqlplus RET read 10/0xa 29849 sqlplus CALL linux_socketcall(0xe,0xbfbf64b4) 29849 sqlplus RET linux_socketcall 0 29849 sqlplus CALL linux_socketcall(0xe,0xbfbf64b4) 29849 sqlplus RET linux_socketcall 0 29849 sqlplus CALL close(0x4) 29849 sqlplus RET close 0 29849 sqlplus CALL close(0x3) 29849 sqlplus RET close 0 29849 sqlplus CALL linux_fcntl64(0x80bdcb0,0x2,0x1) 29849 sqlplus RET linux_fcntl64 -1 errno 9 Bad file descriptor 29849 sqlplus CALL write(0x1,0x34d0a000,0x19) 29849 sqlplus GIO fd 1 wrote 25 bytes "select 1 from dual " 29849 sqlplus RET write 25/0x19 29849 sqlplus CALL write(0x1,0x34d0a000,0x2) 29849 sqlplus GIO fd 1 wrote 2 bytes "* " 29849 sqlplus RET write 2 29849 sqlplus CALL write(0x1,0x34d0a000,0x11) 29849 sqlplus GIO fd 1 wrote 17 bytes "ERROR at line 1: " 29849 sqlplus RET write 17/0x11 29849 sqlplus CALL write(0x1,0x34d0a000,0x30) 29849 sqlplus CALL write(0x1,0x34d0a000,0x30) 29849 sqlplus GIO fd 1 wrote 48 bytes "ORA-03113: end-of-file on communication channel The same issue happens with oracle linux instantclient 10.2.0.5 and 11.2.0.3, but it does *not* arise when oracle database server version is 10.2.0. Here you can see a similar ktrace-linux_kdump, but with a Oracle Database Server version =3D 10.2.0: "SQL> " 30272 sqlplus RET write 5 30272 sqlplus CALL linux_fstat64(0,0xbfbf8d3c,0x34ee4ff4) 30272 sqlplus UNKNOWN(8) 30272 sqlplus RET linux_fstat64 0 30272 sqlplus CALL linux_mmap2(0,0x1000,0x3,0x22,0xffffffff,0) 30272 sqlplus RET linux_mmap2 886091776/0x34d0b000 30272 sqlplus CALL read(0,0x34d0b000,0x1000) 30272 sqlplus RET read RESTART 30272 sqlplus PSIG SIGINT caught handler=3D0x347fec2c mask=3D0x0 code=3D= 0x0 30272 sqlplus CALL linux_rt_sigprocmask(0,0xbfbf8bec,0,0x8) 30272 sqlplus RET linux_rt_sigprocmask 0 30272 sqlplus CALL linux_rt_sigprocmask(0x1,0xbfbf8bec,0,0x8) 30272 sqlplus RET linux_rt_sigprocmask 0 30272 sqlplus CALL linux_rt_sigreturn(0xbfbf8d50) 30272 sqlplus RET linux_rt_sigreturn JUSTRETURN 30272 sqlplus CALL read(0,0x34d0b000,0x1000) 30272 sqlplus GIO fd 0 read 1 byte " " 30272 sqlplus RET read 1 30272 sqlplus CALL write(0x1,0x34d0a000,0x1) 30272 sqlplus GIO fd 1 wrote 1 byte " " 30272 sqlplus RET write 1 30272 sqlplus CALL write(0x1,0x34d0a000,0x5) 30272 sqlplus GIO fd 1 wrote 5 bytes "SQL> " 30272 sqlplus RET write 5 30272 sqlplus CALL read(0,0x34d0b000,0x1000) 30272 sqlplus GIO fd 0 read 20 bytes "select 1 from dual; " 30272 sqlplus RET read 20/0x14 30272 sqlplus CALL gettimeofday(0xbfbfae44,0) 30272 sqlplus RET gettimeofday 0 30272 sqlplus CALL linux_socketcall(0x9,0xbfbf5b00) 30272 sqlplus GIO fd 4 wrote 1 byte "!" 30289 sqlplus RET linux_socketcall 1 30289 sqlplus CALL write(0x4,0xbfbf5d00,0xb) 30289 sqlplus GIO fd 4 wrote 11 bytes "\0\v\0\0\f\0\0\0\^A\0\^B" 30289 sqlplus RET write 11/0xb 30289 sqlplus CALL read(0x4,0x80ca796,0x810) 30289 sqlplus GIO fd 4 read 11 bytes "\0\v\0\0\f\0\0\0\^A\0\^B" 30289 sqlplus RET read 11/0xb 30289 sqlplus CALL read(0x4,0x80c83e6,0x810) 30289 sqlplus GIO fd 4 read 101 bytes "\0e\0\0\^F\0\0\0\0\0\^D\^A\^A\^A\^X\^A\^A\^B\^C=F5\0\0\^A\^C\0/\0\0= \0\0\ \0\0\0\0\0\0\0\0\^Z\0\^A\^A\0\0\0\0006ORA-01013: user requested can= cel\ of current operation " 30289 sqlplus RET read 101/0x65 30289 sqlplus CALL write(0x4,0x80c8c06,0x55) 30289 sqlplus GIO fd 4 wrote 85 bytes "\0U\0\0\^F\0\0\0\0\0\^Qi\^[\^A\^A\^B\^A\^A\^A\^C\^C^\^\\^B\M^@a\0\^= A\ \^A\^R\^A\^A\r\0\^A\0\^A\^A\0\0\0\0\0\0\0\^A\^A\0\0\0\^A\^Rselect 1= fr\ om dual\^A\^A\0\0\0\0\0\0\^A\^A\0\0\0\0\0" 30289 sqlplus RET write 85/0x55 30289 sqlplus CALL read(0x4,0x80ca796,0x810) 30289 sqlplus GIO fd 4 read 147 bytes "\0\M^S\0\0\^F\0\0\0\0\0\^P\^W}M=C9=B4#=F0=BC=FBQ\^Br=ED=AA=E0\M^V= =C8xp\^C\^]\^V\^B\^C\^A\ \^B\^A\^AM\^B\0\0\0\^A\^B\0\0\0\0\0\0\0\^A\^A\^A\^A\^A1\0\0\0\^A\a\= axp\ \^C\^]\^V\^R\^B\^A\^A\^B\^_=E8\^A\^B\^A\^B\^F\^B\^A\^A\0\^A\^A\0\0\= 0\a\ \^B=C1\^B\b\^A\^F\^D=D9E\^V"\^A\^B\^A\^A\0\0\0\0\0\0\^D\^A\^A\^A\^Z= \^A\^A\ \0\0\0\^A\^A\0\^C\0\0\0\0\0\0\0\0\0\0\0\0\^\\0\^A\^A\0\0\0\0" 30289 sqlplus RET read 147/0x93 30289 sqlplus CALL write(0x4,0x80c8c06,0x11) 30289 sqlplus GIO fd 4 wrote 17 bytes "\0\^Q\0\0\^F\0\0\0\0\0\^C\^E\^]\^A\^A\^A\^O" 30289 sqlplus RET write 17/0x11 30289 sqlplus CALL read(0x4,0x80c83e6,0x810) 30289 sqlplus GIO fd 4 read 72 bytes "\0H\0\0\^F\0\0\0\0\0\^D\^A\^A\^A\^[\^A\^A\^B\^E{\0\0\^A\^A\0\^C\0\0= \0\ \0\0\0\0\0\0\0\0\0\^]\0\^A\^A\0\0\0\0\^YORA-01403: no data found " 30289 sqlplus RET read 72/0x48 30289 sqlplus CALL write(0x1,0x34d0a000,0x1) 30289 sqlplus GIO fd 1 wrote 1 byte " " 30289 sqlplus RET write 1 30289 sqlplus CALL write(0x1,0x34d0a000,0x4) 30289 sqlplus GIO fd 1 wrote 4 bytes " 1 " 30289 sqlplus RET write 4 30289 sqlplus CALL write(0x1,0x34d0a000,0xb) 30289 sqlplus GIO fd 1 wrote 11 bytes Any advice will be appreciated, and sorry for my poor english. Please keep me in Cc: as I am not subscribed to the list. Best regards