Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 5.5.39, 10.0.14
-
Debian Linux with kernel 3.14-1-amd64
Description
Hey,
since i added two virtual columns to a table querying that table cause some random segfaults.
The table looks like that:
|
CREATE TABLE |
CREATE TABLE `tl_astars_reservation_group` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
|
`pid` int(10) unsigned NOT NULL DEFAULT '0',
|
`resid` int(10) unsigned NOT NULL DEFAULT '0',
|
`time` int(10) unsigned NOT NULL DEFAULT '0',
|
`time_hr` int(10) unsigned AS (`time`/3600) VIRTUAL,
|
`repeatEach` varchar(64) NOT NULL DEFAULT '',
|
`recurrDayWise` varchar(64) NOT NULL DEFAULT '',
|
`duration` int(10) unsigned NOT NULL DEFAULT '0',
|
`seriesBegin` int(10) unsigned NOT NULL DEFAULT '0',
|
`seriesBeginWeekdayHr` varchar(50) AS (DATE_FORMAT(FROM_UNIXTIME(`seriesBegin`), '%W')) VIRTUAL,
|
`seriesEnd` int(10) unsigned NOT NULL DEFAULT '0',
|
`onhold` char(1) NOT NULL DEFAULT '',
|
`locked` char(1) NOT NULL DEFAULT '',
|
`season` varchar(64) NOT NULL DEFAULT '',
|
`specialprice` decimal(20,4) DEFAULT NULL,
|
`paid` char(1) NOT NULL DEFAULT '',
|
`weeks` varchar(64) NOT NULL DEFAULT '',
|
`day` varchar(7) NOT NULL DEFAULT '0',
|
`downpayment` decimal(20,4) DEFAULT NULL,
|
PRIMARY KEY (`id`),
|
KEY `pid` (`pid`),
|
KEY `resid` (`resid`),
|
KEY `locked` (`locked`)
|
) ENGINE=MyISAM AUTO_INCREMENT=9885 DEFAULT CHARSET=utf8
|
The new colums are the following ones:
`time_hr` int(10) unsigned AS (`time`/3600) VIRTUAL,
|
`seriesBeginWeekdayHr` varchar(50) AS (DATE_FORMAT(FROM_UNIXTIME(`seriesBegin`), '%W')) VIRTUAL,
|
You can find the entire stacktrace as an attachment. The IRC user `tanj` recommended to try the following command to fix the issue:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
|
But this did not solve the problem at all.
If you need more data, please contact me. I am happy to provide them.
Greetings
Leo
Attachments
Issue Links
- relates to
-
-
- Stalled
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Elena Stepanova [ elenst ] |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 5.5.39 [ 16301 ] | |
| Affects Version/s | 5.3.12 [ 12000 ] | |
| Affects Version/s | 10.0.14 [ 17101 ] | |
| Affects Version/s | 10.0.13 [ 16300 ] | |
| Assignee | Elena Stepanova [ elenst ] | Igor Babaev [ igor ] |
| Labels | virtual_columns | |
| Summary | segfault in in libgcc_s.so.1 | segfault in Item_func_from_unixtime::get_date on updating table with virtual columns |
| Assignee | Igor Babaev [ igor ] | Sergei Petrunia [ psergey ] |
| Assignee | Sergei Petrunia [ psergey ] | Sergei Golubchik [ serg ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Component/s | Virtual Columns [ 10803 ] | |
| Fix Version/s | 10.0.15 [ 17300 ] | |
| Fix Version/s | 5.5.41 [ 17600 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 55030 ] | MariaDB v3 [ 65332 ] |
| Workflow | MariaDB v3 [ 65332 ] | MariaDB v4 [ 148259 ] |