[MDEV-9535] Trigger doing "SET NEW.auctionStart = NOW();" on a timestamp kills MariaDB server. - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.11
Fix Version/s: 10.1.12
Component/s: Data Manipulation - Update
Labels:
Environment:
Ubuntu 14.04, 15.04. Up to data packages.

Sprint:
10.1.12

Description

Issuing a query that triggers a trigger on a timestamp field makes the mysql server go away.
Query are inside file query.log and syslog.log contain a trace.

You need two databases JosmWeb and josm_web, load JosmWeb with JosmWeb.Auction.schema.sql and JosmWeb.AuctionHasAuctionItems.schema.sql. Load josm_web with objlistaJosm.sql, run the update query inside query.log.

The same update query works in Oracle mysql-server-5.6 (and even back to 5.0).
Tested on clean install of both MariaDB 10.1 and MySQL 5.6.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

JosmWeb.Auction.schema.sql
2016-02-09 13:36
4 kB
jostein martinsen
JosmWeb.AuctionHasAuctionItems.schema.sql
2016-02-09 13:36
2 kB
jostein martinsen
objlistaJosm.sql
2016-02-09 13:36
9 kB
jostein martinsen
query.log
2016-02-09 13:35
0.6 kB
jostein martinsen
syslog.log
2016-02-09 13:35
7 kB
jostein martinsen

Issue Links

duplicates

MDEV-9341 Update using subquery segfaults

Closed

is duplicated by

MDEV-9574 Trigger Update kills Maria-DB Server

Closed

relates to

MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: jostein martinsen

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-02-09 13:38

Updated:: 2020-10-18 20:49

Resolved:: 2016-02-23 11:59

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.