Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9535

Trigger doing "SET NEW.auctionStart = NOW();" on a timestamp kills MariaDB server.

Details

    • 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

        1. JosmWeb.Auction.schema.sql
          4 kB
        2. JosmWeb.AuctionHasAuctionItems.schema.sql
          2 kB
        3. objlistaJosm.sql
          9 kB
        4. query.log
          0.6 kB
        5. syslog.log
          7 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9341 Update using subquery segfaults

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9574 Trigger Update kills Maria-DB Server

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Progress
            		11d 7h 10m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            		1h 12m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		2d 13h 58m 1

            People

              serg Sergei Golubchik
              jostmart jostein martinsen
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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