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
-
MDEV-7113 difference between check_vcol_func_processor and check_partition_func_processor
-
- Stalled
-
So basicly, you are not going to fix the segfault, you are just forbidding to use some functions in virtual columns? In my opinion this is not the best solution, because it already works most of the time. It just crashes sometims. Also not having a FROM_UNIXTIME in virtual columns renders them pretty much useless for everyone who has to deal with a lot of PHP inserted timestamps.