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

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

    XMLWordPrintable

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
          jostein martinsen
        2. JosmWeb.AuctionHasAuctionItems.schema.sql
          2 kB
          jostein martinsen
        3. objlistaJosm.sql
          9 kB
          jostein martinsen
        4. query.log
          0.6 kB
          jostein martinsen
        5. syslog.log
          7 kB
          jostein martinsen

        Issue Links

          Activity

            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.