Online-Schema-Change core dump adding new columns (After) with Comments
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
Constantly getting a Segmentation Fault when trying to add two new float columns AFTER a column and adding 'comments'.
I have added many new columns before - successfully. So I have no clue what's going on here?
I have managed to narrow this down to the following...
When I remove the "AFTER column" - this appears to work.... at least a dry-run does not core dump?
BUT - we need to be able to get these columns in a particular order.
My statement is as follows:
pt-online-
Thanks ~ Dave
The table I am trying to add the columns to - looks like this... ement` varchar(15) DEFAULT NULL COMMENT 'MEMS Accelerometer Sense Element', ment` varchar(15) DEFAULT NULL COMMENT 'MEMS Gyro Sense Element', ng','production ','samples' ) DEFAULT 'production' COMMENT 'Type of Spec', ,'approved' ,'obsolete' ,'rejected' ) DEFAULT NULL COMMENT 'Approval Status of Spec', ,'Initial' ,'Verify' ) DEFAULT NULL, etpts` varchar(50) DEFAULT NULL COMMENT 'Comma separated list of temperatures. First Temp is considered Room Temp. These are the temperatures for temperature compensation is performed and thermal performance is measured at',
CREATE TABLE `AccelGyroTestSpec` (
`SpecIndex` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`Part_No` varchar(50) DEFAULT NULL COMMENT 'Name of Product',
`ASIC` varchar(10) DEFAULT NULL COMMENT 'Which ASIC is in product',
`AccelSenseEl
`GyroSenseEle
`SpecType` enum('engineeri
`Approved` enum('pending'
`ApprovedBy` varchar(3) DEFAULT NULL COMMENT 'Approver of Spec',
`CreatedBy` varchar(5) DEFAULT NULL COMMENT 'Creation Date of Spec',
`DateApproved` date DEFAULT NULL COMMENT 'Approval Date of Spec',
`DateObsolete` date DEFAULT NULL COMMENT 'Date Spec Obsoleted',
`BasedOn` int(10) unsigned DEFAULT NULL COMMENT 'SpecIndex of Prior Spec',
`Comments` varchar(200) DEFAULT NULL,
`ReelSize` int(5) DEFAULT NULL COMMENT 'Default number of parts on a reel',
`AuditParts` int(5) DEFAULT NULL COMMENT 'Number of Audit Parts on each Reel',
`TpgmPath` varchar(260) DEFAULT NULL COMMENT 'SPEA Test Program Path',
`DeviceName` varchar(150) DEFAULT NULL COMMENT 'SPEA Device Name',
`HumidityScrn` enum('None'
`TemperatureS
`PROMMask` varchar(256) DEFAULT NULL,
`PROMImage` varchar(256) DEFAULT NULL,
`DefaultRAMImage` varchar(256) DEFAULT NULL,
`RegisterMask` varchar(256) DEFAULT NULL COMMENT 'Mask defining which register bits to test',
`I2C_Address` char(7) DEFAULT NULL COMMENT 'String of seven ones and zeros representing I2C Address (MSB first). An 8th (LSB) is added when communicating with the device to signify Read (1) vs Write (0)',
`Vdd` float DEFAULT NULL COMMENT 'Units: V',
`VddIO` float DEFAULT NULL COMMENT 'Units: V',
`VddRatioHigh` float DEFAULT NULL,
`VddRatioLow` float DEFAULT NULL,
`RegulatorTarget` float DEFAULT NULL COMMENT 'Target (V) for Regulator Trim',
`RegulatorTol` float DEFAULT NULL COMMENT 'Tolerance (% of Target) for Regulator Trim',
`OSCTarget` float DEFAULT NULL COMMENT 'Oscillator (OSC) Target (Hz)',
`OSCTol` float DEFAULT NULL COMMENT 'Oscillator (OSC) Tolerance (Hz)',
`VCOTarget` float DEFAULT NULL COMMENT 'VCO Target (Hz)',
`VCOTol` float DEFAULT NULL COMMENT 'VCO Tolerance (Hz)',
`WDTTarget` float DEFAULT NULL COMMENT 'WatchDogTimer (WDT) Target (Hz)',
`WDTTol` float DEFAULT NULL COMMENT 'WatchDogTimer (WDT) Tolerance (Hz)',
`CurrentMin` float DEFAULT NULL COMMENT 'Minimum Operating Current (mA)',
`CurrentMax` float DEFAULT NULL COMMENT 'Maximum Operating Current (mA)',
`AltCurrent1Min` float DEFAULT NULL COMMENT 'Max for Alternate Current 1 Measurement',
`AltCurrent1Max` float DEFAULT NULL COMMENT 'Max for Alternate Current 1 Measurem...