Conference orarep::nomahs::sql

3894.0. "SQL help command followed by ctl-Z bugchk" by ORAREP::ESOSRV::BATOR () Tue Jun 03 1997 13:16

Running VMS V6.1 and SQL V6.0-0.  Why should a SQL help command cause a
    bugcheck. After help, I do a ctl-Z and first one works, but
    second one causes a bugcheck. It's repeatable.  
    Enclosed is a .log of the session.
    
    =============================================================
    $type dick.log
    
System MLOPCS. Unauthorized access is prohibited.

Username: BATOR
Password: 
              Property of Digital Equipment Corporation.
              Unauthorized access prohibited.

              This is OpenVMS VAX V6.1  (CVMS V4.7-47 kernel)

    Last interactive login on Tuesday,  3-JUN-1997 08:53
    Last non-interactive login on Tuesday,  3-JUN-1997 10:51
=

#3            CCS EASTERN SITES
#4            CCS EASTERN SITES
(0             lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk(B
             (0x(B      You are on the MLOPCS cluster, node ESOSRV      (0x(B
             (0x(B     FOR ASSISTANCE CALL THE HELPDESK AT 223-2420     (0x(B
(0             mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj(B

             (B)0You currently have 32539 out of 50000 blocks available.
              lwqqqqwqqqqwqqqqwqqqqwqqqqwqqqqwqqqqwqqqqwqqqqwqqqqwk
              xx    x    x    x    x    x    x    x    x    x    xx
              mvqqqqvqqqqvqqqqvqqqqvqqqqvqqqqvqqqqvqqqqvqqqqvqqqqvj
               0    10   20   30   40   50   60   70   80   90  100 %


   3-JUN-1997 13:13:23
=
MLOPCS $ sql
)0
=


SQL> help creat view

CREATE

  VIEW

       Creates a view definition. A view is a logical structure that
       refers to rows stored in other tables. Data in a view is not
       physically stored in the database. You can include in a view
       definition combinations of rows and columns from other tables and
       view definitions in the schema. You define a view by specifying a
       select expression, that:

       o  Names the criteria for selecting the tables, rows, and columns
          for the view

       o  Specifies a set of columns from those tables

       When the CREATE VIEW statement executes, SQL adds the view
       definition to the physical database.If you declared the schema
       with the PATHNAME argument, the definition is also stored in the



 Press RETURN for more: 


       repository.
     



    Additional information available:

    Environment           Format     Arguments  Examples




CREATE VIEW Subtopic? ar

CREATE

  VIEW

    Arguments

       



      Additional information available:

      check-option-clause   column-name           CONSTRAINT select-expr
      STORED_NAME_IS        sql-and-dtr-clause    view-name




CREATE VIEW Arguments Subtopic? e

CREATE

  VIEW

    Arguments
      Sorry, no documentation on CREATE VIEW ARGUMENTS E


      Additional information available:

      check-option-clause   column-name           CONSTRAINT select-expr
      STORED_NAME_IS        sql-and-dtr-clause    view-name




CREATE VIEW Arguments Subtopic? 
7 Exit 8
=
)0
=



CREATE VIEW Subtopic? 
7 Exit 8
=
%SQL-I-BUGCHKDMP, generating bugcheck dump file USR01:[BATOR]SQLBUGCHK.DMP;4
%SYSTEM-F-ACCVIO, access violation, reason mask=01, virtual address=21FCA53C, PC=00094362, PSL=0BC00008
)0
=


SQL> exit
=
MLOPCS $ dir *.dmp

Directory USR01:[BATOR]

SQLBUGCHK.DMP;4           55/56        3-JUN-1997 13:13:44.76
SQLBUGCHK.DMP;3           55/56        3-JUN-1997 13:12:47.13
SQLBUGCHK.DMP;2           55/56        3-JUN-1997 13:09:47.19
SQLBUGCHK.DMP;1           55/56        3-JUN-1997 13:08:38.43

Total of 4 files, 220/224 blocks.
MLOPCS $ lo
  BATOR        logged out at  3-JUN-1997 13:13:55.32

first, please upgrade to the current rdb v6.0
ECO (V6.1A ECO 6 I believe).  Zillions of problems
have been corrected since 6.0-0 (circa march, 1994).

Second, if the problem persists, you'll need to post
the first several pages of the sql bugcheck dump file
for more specific information.

    See RDB_60 note 136
    
    Peter