Details

    Description

      Zulip report

      Problem: BuildBot not testing the right revision for Pull Requests
      Affected build (one of many) https://buildbot.mariadb.org/#/builders/1/builds/54818
      where:

      • got_revision (what is actually in the tarball) is: 0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33
      • and revision (what metadata buildbot received via webhook) is f041b02ec1e28ca0f743abf3bf07e2349b2fab1e

      How to reproduce

      $ git clone --no-checkout --depth 1 https://github.com/MariaDB/server .
       
      ### Try with pull/#ID#/merge - WHAT BUILDBOT DOES
      $ git fetch https://github.com/MariaDB/server refs/pull/3826/merge --depth 1
      ...
      ...
      From https://github.com/MariaDB/server
       * branch              refs/pull/3826/merge -> FETCH_HEAD
       
      $ git checkout FETCH_HEAD
      ...
      ...
      HEAD is now at 0202b071 Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1
       
      ### ONE DAY OLD COMMIT
      git log
      commit 0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33 (grafted, HEAD)
      Author: Marko Mäkelä <marko.makela@mariadb.com>
      Date:   Mon Mar 17 08:52:31 2025 +0100
       
          Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1
       
      ### THIS IS NOT OK, LIMIT 45000 shouldn't be present as per PR.
      $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g"
      INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g LIMIT 45000;
       
       
      ### Now let's try with pull/#ID#/head
      $ git fetch https://github.com/MariaDB/server refs/pull/3826/head --depth 1
      ...
      ...
      From https://github.com/MariaDB/server
       * branch              refs/pull/3826/head -> FETCH_HEAD
       
       
      $ git checkout FETCH_HEAD
      ...
      ...
      HEAD is now at 1f278e70 squash! a878a8ffde539c9c8c1693290d58d1f2d9ba70a8
       
      ### THIS IS OK
      $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g;"
      INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g;
      
      

      As seen from the printscreen below 1f278e70 is the right commit to test.
      BuildBot will use the /merge branch and its HEAD commit is what is packaged on ci.mariadb.org and tested by all builders.

      Attachments

        Activity

          rvarzaru Varzaru Razvan-Liviu created issue -
          rvarzaru Varzaru Razvan-Liviu made changes -
          Field Original Value New Value
          Description [Zulip report|https://mariadb.zulipchat.com/#narrow/channel/236699-Buildbot/topic/corrupted.20file.20system.20on.20x86/near/506490342]

          *Problem*: BuildBot not testing the right revision for Pull Requests
          *Affected build (one of many)* https://buildbot.mariadb.org/#/builders/1/builds/54818
          where:
          - *got_revision* (what is actually in the tarball) is: *0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33*

          - and *revision* (what metadata buildbot received via webhook) is *f041b02ec1e28ca0f743abf3bf07e2349b2fab1e*

          *How to reproduce*
          {code:bash}
          $ git clone --no-checkout --depth 1 https://github.com/MariaDB/server .

          ### Try with pull/#ID#/merge - WHAT BUILDBOT DOES
          $ git fetch https://github.com/MariaDB/server refs/pull/3826/merge --depth 1
          ...
          ...
          From https://github.com/MariaDB/server
           * branch refs/pull/3826/merge -> FETCH_HEAD

          $ git checkout FETCH_HEAD
          ...
          ...
          HEAD is now at 0202b071 Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1

          ### ONE DAY OLD COMMIT
          git log
          commit 0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33 (grafted, HEAD)
          Author: Marko Mäkelä <marko.makela@mariadb.com>
          Date: Mon Mar 17 08:52:31 2025 +0100

              Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1

          ### THIS IS NOT OK, LIMIT 45000 shouldn't be present as per PR.
          $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g"
          INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g LIMIT 45000;


          ### Now let's try with pull/#ID#/head
          $ git fetch https://github.com/MariaDB/server refs/pull/3826/head --depth 1
          ...
          ...
          From https://github.com/MariaDB/server
           * branch refs/pull/3826/head -> FETCH_HEAD


          $ git checkout FETCH_HEAD
          ...
          ...
          HEAD is now at 1f278e70 squash! a878a8ffde539c9c8c1693290d58d1f2d9ba70a8

          ### THIS IS OK
          $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g;"
          INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g;

          {code}


          As seen from the printscreen below *1f278e70* is the right commit to test.
          BuildBot will use the */merge* branch and the HEAD of it is what is packaged and tested by all builders.

          !image-2025-03-18-18-12-16-638.png|thumbnail!
          [Zulip report|https://mariadb.zulipchat.com/#narrow/channel/236699-Buildbot/topic/corrupted.20file.20system.20on.20x86/near/506490342]

          *Problem*: BuildBot not testing the right revision for Pull Requests
          *Affected build (one of many)* https://buildbot.mariadb.org/#/builders/1/builds/54818
          where:
          - *got_revision* (what is actually in the tarball) is: *0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33*

          - and *revision* (what metadata buildbot received via webhook) is *f041b02ec1e28ca0f743abf3bf07e2349b2fab1e*

          *How to reproduce*
          {code:bash}
          $ git clone --no-checkout --depth 1 https://github.com/MariaDB/server .

          ### Try with pull/#ID#/merge - WHAT BUILDBOT DOES
          $ git fetch https://github.com/MariaDB/server refs/pull/3826/merge --depth 1
          ...
          ...
          From https://github.com/MariaDB/server
           * branch refs/pull/3826/merge -> FETCH_HEAD

          $ git checkout FETCH_HEAD
          ...
          ...
          HEAD is now at 0202b071 Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1

          ### ONE DAY OLD COMMIT
          git log
          commit 0202b071ab0bcf6cf8663f48c1ab934a3f1b8f33 (grafted, HEAD)
          Author: Marko Mäkelä <marko.makela@mariadb.com>
          Date: Mon Mar 17 08:52:31 2025 +0100

              Merge ca561443a28dfbd1b3fb6315187315a12e9fa221 into 839828e57fdf734b15c81cb9cb76d3760a9161f1

          ### THIS IS NOT OK, LIMIT 45000 shouldn't be present as per PR.
          $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g"
          INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g LIMIT 45000;


          ### Now let's try with pull/#ID#/head
          $ git fetch https://github.com/MariaDB/server refs/pull/3826/head --depth 1
          ...
          ...
          From https://github.com/MariaDB/server
           * branch refs/pull/3826/head -> FETCH_HEAD


          $ git checkout FETCH_HEAD
          ...
          ...
          HEAD is now at 1f278e70 squash! a878a8ffde539c9c8c1693290d58d1f2d9ba70a8

          ### THIS IS OK
          $ cat mysql-test/suite/innodb/r/lock_memory_debug.result | grep "t1 g;"
          INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e, t1 f, t1 g;

          {code}


          As seen from the printscreen below *1f278e70* is the right commit to test.
          BuildBot will use the */merge* branch and its HEAD commit is what is packaged on ci.mariadb.org and tested by all builders.

          !image-2025-03-18-18-12-16-638.png|thumbnail!
          danblack Daniel Black made changes -
          Worklog Id 134781 [ 134781 ]
          Remaining Estimate 0d [ 0 ]
          Time Spent 1.5h [ 5400 ]
          vlad.radu Vlad Radu made changes -
          Sprint Sprint 6 (24.03.2025) [ 791 ]
          vlad.radu Vlad Radu made changes -
          Rank Ranked higher
          vlad.radu Vlad Radu made changes -
          Assignee Varzaru Razvan-Liviu [ JIRAUSER55297 ]
          vlad.radu Vlad Radu made changes -
          Original Estimate 0.5d [ 14400 ]
          vlad.radu Vlad Radu made changes -
          Remaining Estimate 0d [ 0 ] 0.5d [ 14400 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Affects Version/s BB V1.04 [ 30120 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Fix Version/s BB V1.05 [ 30132 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Status In Progress [ 3 ] In Review [ 10002 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Status In Review [ 10002 ] In Testing [ 10301 ]
          vlad.radu Vlad Radu made changes -
          Sprint Sprint 6 (24.03.2025) [ 791 ] Sprint 6 (24.03.2025), Sprint 7 (07.04.2025) [ 791, 796 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Status In Testing [ 10301 ] Verified [ 10102 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Worklog Id 135539 [ 135539 ]
          Remaining Estimate 0.5d [ 14400 ] 0.25d [ 7200 ]
          Time Spent 1.5h [ 5400 ] 3.5h [ 12600 ]
          rvarzaru Varzaru Razvan-Liviu made changes -
          Resolution Fixed [ 1 ]
          Status Verified [ 10102 ] Closed [ 6 ]

          People

            rvarzaru Varzaru Razvan-Liviu
            rvarzaru Varzaru Razvan-Liviu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 0.5d Original Estimate - 0.5d
                0.5d
                Remaining:
                Time Spent - 3.5h Remaining Estimate - 0.25d
                0.25d
                Logged:
                Time Spent - 3.5h Remaining Estimate - 0.25d
                3.5h