Edit report at https://bugs.php.net/bug.php?id=71600&edit=1
ID: 71600
Comment by: nick dot saraniti at gmail dot com
Reported by: nick dot saraniti at gmail dot com
Summary: oci_fetch_all results in segfault on apache 2.4
Status: Feedback
Type: Bug
Package: OCI8 related
Operating System: CentOS 7.2.1511
PHP Version: 7.0.3
Block user comment: N
Private report: N
New Comment:
--------------------------------------------------------
-- File created - Monday-March-07-2016
--------------------------------------------------------
-- Unable to render TABLE DDL for object CSA.DRUG with DBMS_METADATA attempting internal generator.
CREATE TABLE CSA.DRUG
(
DELETEDFLAG NUMBER
, LASTACCESS NUMBER
, DRUGNBRSTOREID NUMBER
, DRUGNBRKEY NUMBER
, DRUGNDCTYPE NUMBER
, DRUGNDCNBR VARCHAR2(15 BYTE)
, ALTTYPE NUMBER
, ALTNBR VARCHAR2(15 BYTE)
, NAME VARCHAR2(28 BYTE)
, GENERICCODE NUMBER
, THERAPYCODE NUMBER
, TAXABLE NUMBER
, FORM VARCHAR2(5 BYTE)
, STRENGTH VARCHAR2(12 BYTE)
, COLOR VARCHAR2(16 BYTE)
, SHAPE VARCHAR2(16 BYTE)
, PIXLINKSTOREID NUMBER
, PIXLINKKEY NUMBER
, DRUGTYPE NUMBER
, DEACLASS NUMBER
, CATEGORY NUMBER
, OBSOLETEFLAG NUMBER
, AWP NUMBER(14, 6)
, MAC NUMBER(14, 6)
, REORDERPOINT NUMBER
, REORDERQTY NUMBER
, PACKAGESIZE NUMBER(14, 6)
, LASTUPDATE NUMBER
, PACKAGER VARCHAR2(13 BYTE)
, COUNSEL01 NUMBER
, COUNSEL02 NUMBER
, COUNSEL03 NUMBER
, COUNSEL04 NUMBER
, COUNSEL05 NUMBER
, COUNSEL06 NUMBER
, COUNSEL07 NUMBER
, COUNSEL08 NUMBER
, USERCOUNSELLINK NUMBER
, ZONE NUMBER
, FACTORTYPE NUMBER
, FACTOR01 NUMBER
, FACTOR02 NUMBER
, FACTOR03 NUMBER
, FACTOR04 NUMBER
, MOVEMENTYEAR01 NUMBER
, MOVEMENTYEAR02 NUMBER
, MOVEMENTYEAR03 NUMBER
, MOVEMENTYEAR04 NUMBER
, MOVEMENTYEAR05 NUMBER
, MOVEMENTYEAR06 NUMBER
, MOVEMENTYEAR07 NUMBER
, MOVEMENTYEAR08 NUMBER
, MOVEMENTYEAR09 NUMBER
, MOVEMENTYEAR10 NUMBER
, MOVEMENTYEAR11 NUMBER
, MOVEMENTYEAR12 NUMBER
, MOVEMENTYEAR13 NUMBER
, MOVEMENTYEAR14 NUMBER
, MOVEMENTYEAR15 NUMBER
, MOVEMENTYEAR16 NUMBER
, MOVEMENTYEAR17 NUMBER
, MOVEMENTYEAR18 NUMBER
, MOVEMENTYEAR19 NUMBER
, MOVEMENTYEAR20 NUMBER
, MOVEMENTYEAR21 NUMBER
, MOVEMENTYEAR22 NUMBER
, MOVEMENTYEAR23 NUMBER
, MOVEMENTYEAR24 NUMBER
, MOVEMENT01 NUMBER
, MOVEMENT02 NUMBER
, MOVEMENT03 NUMBER
, MOVEMENT04 NUMBER
, MOVEMENT05 NUMBER
, MOVEMENT06 NUMBER
, MOVEMENT07 NUMBER
, MOVEMENT08 NUMBER
, MOVEMENT09 NUMBER
, MOVEMENT10 NUMBER
, MOVEMENT11 NUMBER
, MOVEMENT12 NUMBER
, MOVEMENT13 NUMBER
, MOVEMENT14 NUMBER
, MOVEMENT15 NUMBER
, MOVEMENT16 NUMBER
, MOVEMENT17 NUMBER
, MOVEMENT18 NUMBER
, MOVEMENT19 NUMBER
, MOVEMENT20 NUMBER
, MOVEMENT21 NUMBER
, MOVEMENT22 NUMBER
, MOVEMENT23 NUMBER
, MOVEMENT24 NUMBER
, INTERACTIONCODE NUMBER
, UPDTCTL NUMBER
, PECLINK NUMBER
, PHARMEX01 NUMBER
, PHARMEX02 NUMBER
, PHARMEX03 NUMBER
, PHARMEX04 NUMBER
, PHARMEX05 NUMBER
, PHARMEX06 NUMBER
, PHARMEX07 NUMBER
, PHARMEX08 NUMBER
, PHARMEX09 NUMBER
, PHARMEX10 NUMBER
, UNITDOSEAVAIL NUMBER
, DESI NUMBER
, RETAILQTY NUMBER
, RETAILPRICE NUMBER
, INVDAYSUPPLY NUMBER
, GENERICDIFF NUMBER
, CASHSCHSTORE01 NUMBER
, CASHSCHRECORDTYPE01 NUMBER
, CASHSCHKEY01 NUMBER
, CASHSCHSTORE02 NUMBER
, CASHSCHRECORDTYPE02 NUMBER
, CASHSCHKEY02 NUMBER
, CASHSCHSTORE03 NUMBER
, CASHSCHRECORDTYPE03 NUMBER
, CASHSCHKEY03 NUMBER
, DEPT VARCHAR2(5 BYTE)
, GENERICNAME VARCHAR2(31 BYTE)
, INGREDDRUGSTOREID01 NUMBER
, INGREDDRUGKEY01 NUMBER
, INGREDQTY01 NUMBER(14, 6)
, INGREDUOM01 NUMBER
, INGREDPERIOD01 NUMBER
, INGREDDRUGSTOREID02 NUMBER
, INGREDDRUGKEY02 NUMBER
, INGREDQTY02 NUMBER(14, 6)
, INGREDUOM02 NUMBER
, INGREDPERIOD02 NUMBER
, INGREDDRUGSTOREID03 NUMBER
, INGREDDRUGKEY03 NUMBER
, INGREDQTY03 NUMBER(14, 6)
, INGREDUOM03 NUMBER
, INGREDPERIOD03 NUMBER
, INGREDDRUGSTOREID04 NUMBER
, INGREDDRUGKEY04 NUMBER
, INGREDQTY04 NUMBER(14, 6)
, INGREDUOM04 NUMBER
, INGREDPERIOD04 NUMBER
, INGREDDRUGSTOREID05 NUMBER
, INGREDDRUGKEY05 NUMBER
, INGREDQTY05 NUMBER(14, 6)
, INGREDUOM05 NUMBER
, INGREDPERIOD05 NUMBER
, INGREDDRUGSTOREID06 NUMBER
, INGREDDRUGKEY06 NUMBER
, INGREDQTY06 NUMBER(14, 6)
, INGREDUOM06 NUMBER
, INGREDPERIOD06 NUMBER
, INGREDDRUGSTOREID07 NUMBER
, INGREDDRUGKEY07 NUMBER
, INGREDQTY07 NUMBER(14, 6)
, INGREDUOM07 NUMBER
, INGREDPERIOD07 NUMBER
, INGREDDRUGSTOREID08 NUMBER
, INGREDDRUGKEY08 NUMBER
, INGREDQTY08 NUMBER(14, 6)
, INGREDUOM08 NUMBER
, INGREDPERIOD08 NUMBER
, INGREDDRUGSTOREID09 NUMBER
, INGREDDRUGKEY09 NUMBER
, INGREDQTY09 NUMBER(14, 6)
, INGREDUOM09 NUMBER
, INGREDPERIOD09 NUMBER
, INGREDDRUGSTOREID10 NUMBER
, INGREDDRUGKEY10 NUMBER
, INGREDQTY10 NUMBER(14, 6)
, INGREDUOM10 NUMBER
, INGREDPERIOD10 NUMBER
, INGREDDRUGSTOREID11 NUMBER
, INGREDDRUGKEY11 NUMBER
, INGREDQTY11 NUMBER(14, 6)
, INGREDUOM11 NUMBER
, INGREDPERIOD11 NUMBER
, INGREDDRUGSTOREID12 NUMBER
, INGREDDRUGKEY12 NUMBER
, INGREDQTY12 NUMBER(14, 6)
, INGREDUOM12 NUMBER
, INGREDPERIOD12 NUMBER
, INGREDDRUGSTOREID13 NUMBER
, INGREDDRUGKEY13 NUMBER
, INGREDQTY13 NUMBER(14, 6)
, INGREDUOM13 NUMBER
, INGREDPERIOD13 NUMBER
, INGREDDRUGSTOREID14 NUMBER
, INGREDDRUGKEY14 NUMBER
, INGREDQTY14 NUMBER(14, 6)
, INGREDUOM14 NUMBER
, INGREDPERIOD14 NUMBER
, INGREDDRUGSTOREID15 NUMBER
, INGREDDRUGKEY15 NUMBER
, INGREDQTY15 NUMBER(14, 6)
, INGREDUOM15 NUMBER
, INGREDPERIOD15 NUMBER
, HICSEQ NUMBER
, HICCODE01 VARCHAR2(7 BYTE)
, HICCODE02 VARCHAR2(7 BYTE)
, HICCODE03 VARCHAR2(7 BYTE)
, HICCODE04 VARCHAR2(7 BYTE)
, HICCODE05 VARCHAR2(7 BYTE)
, HICCODE06 VARCHAR2(7 BYTE)
, HICCODE07 VARCHAR2(7 BYTE)
, HICCODE08 VARCHAR2(7 BYTE)
, HICCODE09 VARCHAR2(7 BYTE)
, INDICATION01 NUMBER
, INDICATION02 NUMBER
, INDICATION03 NUMBER
, INDICATION04 NUMBER
, INDICATION05 NUMBER
, INDICATION06 NUMBER
, INDICATION07 NUMBER
, INDICATION08 NUMBER
, INDICATION09 NUMBER
, INDICATION10 NUMBER
, INDICATION11 NUMBER
, INDICATION12 NUMBER
, INDICATION13 NUMBER
, INDICATION14 NUMBER
, CONTRAIND01 NUMBER
, CONTRAIND02 NUMBER
, CONTRAIND03 NUMBER
, CONTRAIND04 NUMBER
, CONTRAIND05 NUMBER
, CONTRAIND06 NUMBER
, CONTRAIND07 NUMBER
, CONTRAIND08 NUMBER
, CONTRAIND09 NUMBER
, CONTRAIND10 NUMBER
, CONTRAIND11 NUMBER
, CONTRAIND12 NUMBER
, CONTRAIND13 NUMBER
, CONTRAIND14 NUMBER
, SIDEEFFECT01 NUMBER
, SIDEEFFECT02 NUMBER
, SIDEEFFECT03 NUMBER
, SIDEEFFECT04 NUMBER
, SIDEEFFECT05 NUMBER
, SIDEEFFECT06 NUMBER
, SIDEEFFECT07 NUMBER
, SIDEEFFECT08 NUMBER
, SIDEEFFECT09 NUMBER
, SIDEEFFECT10 NUMBER
, SIDEEFFECT11 NUMBER
, SIDEEFFECT12 NUMBER
, SIDEEFFECT13 NUMBER
, SIDEEFFECT14 NUMBER
, DOSAGELINK NUMBER
, DRUGFOOD01 NUMBER
, DRUGFOOD02 NUMBER
, DRUGFOOD03 NUMBER
, DRUGFOOD04 NUMBER
, DRUGFOOD05 NUMBER
, GERIATRIC01 NUMBER
, GERIATRIC02 NUMBER
, GERIATRIC03 NUMBER
, GERIATRIC04 NUMBER
, GERIATRIC05 NUMBER
, GERIATRIC06 NUMBER
, PEDIATRIC01 NUMBER
, PEDIATRIC02 NUMBER
, PEDIATRIC03 NUMBER
, PEDIATRIC04 NUMBER
, PEDIATRIC05 NUMBER
, PEDIATRIC06 NUMBER
, PREGNANCY01 NUMBER
, PREGNANCY02 NUMBER
, PREGNANCY03 NUMBER
, PREGNANCY04 NUMBER
, PREGNANCY05 NUMBER
, PREGNANCY06 NUMBER
, LACTATION01 NUMBER
, LACTATION02 NUMBER
, LACTATION03 NUMBER
, LACTATION04 NUMBER
, LACTATION05 NUMBER
, LACTATION06 NUMBER
, CASESIZE NUMBER
, MEMOLINKSTOREID NUMBER
, MEMOLINKKEY NUMBER
, NHDRUGCLASS VARCHAR2(4 BYTE)
, EXPIREDAYS NUMBER
, REBATE NUMBER
, UNITOFMEASURE NUMBER
, VENDORNBRSTOREID NUMBER
, VENDORNBRKEY NUMBER
, REORDERCODE VARCHAR2(13 BYTE)
, ALTVENDORNBRSTOREID NUMBER
, ALTVENDORNBRKEY NUMBER
, ALTREORDERCODE VARCHAR2(14 BYTE)
, SIG01 VARCHAR2(10 BYTE)
, SIG02 VARCHAR2(10 BYTE)
, OLDAWP NUMBER(14, 6)
, OLDMAC NUMBER(14, 6)
, OLDCOST NUMBER(14, 6)
, AWPDATE NUMBER
, MACDATE NUMBER
, COSTDATE NUMBER
, TRIPLICATEFLAG NUMBER
, AWPFACTOR NUMBER
, NUTRILINK NUMBER
, ORANGEBOOKCODE VARCHAR2(4 BYTE)
, IMPRINT01 VARCHAR2(41 BYTE)
, IMPRINT02 VARCHAR2(41 BYTE)
, GENBRANDSTOREID NUMBER
, GENBRANDKEY NUMBER
, HOTLISTQTY01 NUMBER
, HOTLISTQTY02 NUMBER
, HOTLISTQTY03 NUMBER
, HOTLISTQTY04 NUMBER
, INACTIVE NUMBER
, SPARE VARCHAR2(100 BYTE)
, CREATED NUMBER
, INSERTEDAT NUMBER
, UPDATEDAT NUMBER
, ALIASTYPE NUMBER
, ALIASNBR VARCHAR2(15 BYTE)
, FLAGB340 NUMBER
, BRANDNAME VARCHAR2(28 BYTE)
, LOADEDAT TIMESTAMP(6)
, INSERTEDSTOREID NUMBER(6, 0)
, UPDATEDSTOREID NUMBER(6, 0)
, FLAG340B NUMBER
, PKG_DS NUMBER
, HISTORICAL NUMBER(3, 0)
, RXNET_SAVE_PSSTORE NUMBER
, RXNET_SAVE_PSRECORDTYPE NUMBER
, RXNET_SAVE_PSKEY NUMBER
, WAC NUMBER(14, 6)
, OLDWAC NUMBER(14, 6)
, WACDATE NUMBER
, PO_GROUP NUMBER
, FORMULARY NUMBER
, REFRIGERATE NUMBER
, DOSAGEFORM VARCHAR2(3 BYTE)
, ROUTEOFADMIN NUMBER
, CMPD_TYPE NUMBER
, LEVEL_OF_EFFORT NUMBER
, COMPOUND_INSSTOREID NUMBER
, COMPOUND_INSKEY NUMBER
, COST_BASIS VARCHAR2(3 BYTE)
, DRUGPROGS NUMBER
)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOCOMPRESS
NOPARALLELCREATE UNIQUE INDEX CSA.DRUG_DRUGNBRSTOREID_DRUGNBRIDX ON CSA.DRUG (DRUGNBRSTOREID ASC,
DRUGNBRKEY ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG01_IDX ON CSA.DRUG (INGREDDRUGSTOREID01 ASC, INGREDDRUGKEY01 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG02_IDX ON CSA.DRUG (INGREDDRUGSTOREID02 ASC, INGREDDRUGKEY02 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG03_IDX ON CSA.DRUG (INGREDDRUGSTOREID03 ASC, INGREDDRUGKEY03 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG04_IDX ON CSA.DRUG (INGREDDRUGSTOREID04 ASC, INGREDDRUGKEY04 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG05_IDX ON CSA.DRUG (INGREDDRUGSTOREID05 ASC, INGREDDRUGKEY05 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG06_IDX ON CSA.DRUG (INGREDDRUGSTOREID06 ASC, INGREDDRUGKEY06 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG07_IDX ON CSA.DRUG (INGREDDRUGSTOREID07 ASC, INGREDDRUGKEY07 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG08_IDX ON CSA.DRUG (INGREDDRUGSTOREID08 ASC, INGREDDRUGKEY08 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG09_IDX ON CSA.DRUG (INGREDDRUGSTOREID09 ASC, INGREDDRUGKEY09 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG10_IDX ON CSA.DRUG (INGREDDRUGSTOREID10 ASC, INGREDDRUGKEY10 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG11_IDX ON CSA.DRUG (INGREDDRUGSTOREID11 ASC, INGREDDRUGKEY11 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG12_IDX ON CSA.DRUG (INGREDDRUGSTOREID12 ASC, INGREDDRUGKEY12 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG13_IDX ON CSA.DRUG (INGREDDRUGSTOREID13 ASC, INGREDDRUGKEY13 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG14_IDX ON CSA.DRUG (INGREDDRUGSTOREID14 ASC, INGREDDRUGKEY14 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_INGREDDRUG15_IDX ON CSA.DRUG (INGREDDRUGSTOREID15 ASC, INGREDDRUGKEY15 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_NAME_IDX ON CSA.DRUG (NAME ASC)
NOLOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_NDC_IDX ON CSA.DRUG (DRUGNDCNBR ASC)
NOLOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE INDEX CSA.DRUG_UPDATEDAT_IDX ON CSA.DRUG (UPDATEDAT ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_DRUGNBRSTOREID_DRUGNBRIDX with DBMS_METADATA
attempting internal generator.
CREATE UNIQUE INDEX CSA.DRUG_DRUGNBRSTOREID_DRUGNBRIDX ON CSA.DRUG (DRUGNBRSTOREID ASC, DRUGNBRKEY
ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_NDC_IDX with DBMS_METADATA attempting internal
generator.
CREATE INDEX CSA.DRUG_NDC_IDX ON CSA.DRUG (DRUGNDCNBR ASC)
NOLOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_NAME_IDX with DBMS_METADATA attempting internal
generator.
CREATE INDEX CSA.DRUG_NAME_IDX ON CSA.DRUG (NAME ASC)
NOLOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG01_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG01_IDX ON CSA.DRUG (INGREDDRUGSTOREID01 ASC, INGREDDRUGKEY01 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG02_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG02_IDX ON CSA.DRUG (INGREDDRUGSTOREID02 ASC, INGREDDRUGKEY02 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG03_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG03_IDX ON CSA.DRUG (INGREDDRUGSTOREID03 ASC, INGREDDRUGKEY03 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG04_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG04_IDX ON CSA.DRUG (INGREDDRUGSTOREID04 ASC, INGREDDRUGKEY04 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG05_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG05_IDX ON CSA.DRUG (INGREDDRUGSTOREID05 ASC, INGREDDRUGKEY05 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG06_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG06_IDX ON CSA.DRUG (INGREDDRUGSTOREID06 ASC, INGREDDRUGKEY06 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG07_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG07_IDX ON CSA.DRUG (INGREDDRUGSTOREID07 ASC, INGREDDRUGKEY07 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG08_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG08_IDX ON CSA.DRUG (INGREDDRUGSTOREID08 ASC, INGREDDRUGKEY08 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG09_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG09_IDX ON CSA.DRUG (INGREDDRUGSTOREID09 ASC, INGREDDRUGKEY09 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG10_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG10_IDX ON CSA.DRUG (INGREDDRUGSTOREID10 ASC, INGREDDRUGKEY10 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG11_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG11_IDX ON CSA.DRUG (INGREDDRUGSTOREID11 ASC, INGREDDRUGKEY11 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG12_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG12_IDX ON CSA.DRUG (INGREDDRUGSTOREID12 ASC, INGREDDRUGKEY12 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG13_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG13_IDX ON CSA.DRUG (INGREDDRUGSTOREID13 ASC, INGREDDRUGKEY13 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG14_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG14_IDX ON CSA.DRUG (INGREDDRUGSTOREID14 ASC, INGREDDRUGKEY14 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_INGREDDRUG15_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_INGREDDRUG15_IDX ON CSA.DRUG (INGREDDRUGSTOREID15 ASC, INGREDDRUGKEY15 ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
-- Unable to render INDEX DDL for object CSA.DRUG_UPDATEDAT_IDX with DBMS_METADATA attempting
internal generator.
CREATE INDEX CSA.DRUG_UPDATEDAT_IDX ON CSA.DRUG (UPDATEDAT ASC)
LOGGING
TABLESPACE CS
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLEL
Previous Comments:
------------------------------------------------------------------------
[2016-03-08 00:45:58] sixd@php.net
Please post the DDL to create the table used in your testcase. Thanks
------------------------------------------------------------------------
[2016-03-08 00:21:00] bigmage at web dot de
maybe you should change the topic to: oci_fetch_all
------------------------------------------------------------------------
[2016-02-22 14:58:01] nick dot saraniti at gmail dot com
camporter1 thanks for confirming, For me at least this only happens about 40% of the time when
returning multi-row sets from oracle. I'm trying to find some commonality on the queries which
fail, possibly with returned NULL values from oracle?
------------------------------------------------------------------------
[2016-02-22 07:33:04] camporter1 at gmail dot com
The issue seems to be that when more than one row is in the result, the first row writes over
outarrs[i]->value when zend_hash_index_update is called. The address of the first bucket's
key is the same as outarrs[i]. I haven't figured out why. The key gets set to NULL, which
erases the value in outarrs[i], which causes the segfault.
------------------------------------------------------------------------
[2016-02-17 02:03:12] nick dot saraniti at gmail dot com
Some more info,
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Used rpm to install instaclient's, PECL for oci8
[New Thread 0x7ffff7f396c0 (LWP 7676)]
Program received signal SIGSEGV, Segmentation fault.
0x00007fffea529df5 in _zend_hash_index_update ()
from /etc/httpd/modules/libphp7.so
(gdb)
(gdb) bt
#0 0x00007fffea529df5 in _zend_hash_index_update ()
from /etc/httpd/modules/libphp7.so
#1 0x00007fffddd3c395 in zif_oci_fetch_all (execute_data=<optimized out>,
return_value=0x7fffe8217500) at /var/tmp/oci8/oci8_interface.c:1495
#2 0x00007fffea50b35b in dtrace_execute_internal ()
from /etc/httpd/modules/libphp7.so
#3 0x00007fffea596db3 in ?? () from /etc/httpd/modules/libphp7.so
#4 0x00007fffea558fcb in execute_ex () from /etc/httpd/modules/libphp7.so
#5 0x00007fffea50b239 in dtrace_execute_ex ()
from /etc/httpd/modules/libphp7.so
#6 0x00007fffea596a90 in ?? () from /etc/httpd/modules/libphp7.so
#7 0x00007fffea558fcb in execute_ex () from /etc/httpd/modules/libphp7.so
#8 0x00007fffea50b239 in dtrace_execute_ex ()
from /etc/httpd/modules/libphp7.so
#9 0x00007fffea5a0378 in ?? () from /etc/httpd/modules/libphp7.so
#10 0x00007fffea558fcb in execute_ex () from /etc/httpd/modules/libphp7.so
#11 0x00007fffea50b239 in dtrace_execute_ex ()
from /etc/httpd/modules/libphp7.so
#12 0x00007fffea5a0378 in ?? () from /etc/httpd/modules/libphp7.so
#13 0x00007fffea558fcb in execute_ex () from /etc/httpd/modules/libphp7.so
#14 0x00007fffea50b239 in dtrace_execute_ex ()
from /etc/httpd/modules/libphp7.so
#15 0x00007fffea5a2cef in zend_execute () from /etc/httpd/modules/libphp7.so
#16 0x00007fffea51af63 in zend_execute_scripts ()
from /etc/httpd/modules/libphp7.so
#17 0x00007fffea4bc3a8 in php_execute_script ()
from /etc/httpd/modules/libphp7.so
#18 0x00007fffea5a46ad in ?? () from /etc/httpd/modules/libphp7.so
#19 0x0000555555593270 in ap_run_handler ()
#20 0x00005555555937b9 in ap_invoke_handler ()
#21 0x00005555555a7b3a in ap_process_async_request ()
#22 0x00005555555a7e14 in ap_process_request ()
#23 0x00005555555a47a2 in ?? ()
#24 0x000055555559c840 in ap_run_process_connection ()
#25 0x00007fffeda1980f in ?? () from /etc/httpd/modules/mod_mpm_prefork.so
#26 0x00007fffeda19a0c in ?? () from /etc/httpd/modules/mod_mpm_prefork.so
#27 0x00007fffeda1a791 in ?? () from /etc/httpd/modules/mod_mpm_prefork.so
#28 0x00005555555795ae in ap_run_mpm ()
#29 0x0000555555572b36 in main ()
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=71600
--
Edit this bug report at https://bugs.php.net/bug.php?id=71600&edit=1