Informix

 View Only

create table taby as select * from tabx PANIC informix server

  • 1.  create table taby as select * from tabx PANIC informix server

    Posted Fri May 27, 2022 05:30 PM
      |   view attached
    On informix 12.10 and 14.10 can create table as select from.
    I used the informix demo DB to test.
    But when send two create table as select from two SQL at same request like below PANIC the informix server:
      create table itemxx as select * from items; create table custxx as select * from customer
     
    The online log message:
    13:01:03  Assert Failed: No Exception Handler
    13:01:03  IBM Informix Dynamic Server Version 14.10.FC6WE
    13:01:03   Who: Session(99, informix@192.168.125.103, 18132, 700020000782ab8)
                    Thread(453, sqlexec, 700020000745680, 1)
                    File: mtex.c Line: 564
    13:01:03   Results: Exception Caught. Type: MT_EX_OS, Context: mem
    13:01:03   Action: Please notify IBM Informix Technical Support.
    13:01:03   See Also: /home/ids14fc6/tmp/af.5ad5b0e
    13:01:18  Thread ID 453 will NOT be suspended because
              it is holding a buffer.
    13:01:18   See Also: /home/ids14fc6/tmp/af.5ad5b0e
    13:01:18  mtex.c, line 564, thread 453, proc id 12911096, No Exception Handler.
    13:01:18  The Master Daemon Died
    13:01:18  PANIC: Attempting to bring system down

    The af.xxxx file is attached.


    ------------------------------
    Regards.

    Philip Yeh
    ------------------------------

    Attachment(s)

    zip
    af.zip   340 KB 1 version