Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar-debug/builds/2348/steps/test/logs/stdio

      rocksdb.bulk_load_unsorted               w2 [ fail ]  timeout after 900 seconds
       
      == /home/buildbot/maria-slave/power8-vlp06-bintar-debug/build/mysql-test/var/2/log/bulk_load_unsorted.log == 
      test.t2	analyze	status	OK
      test.t3	analyze	status	OK
      SHOW TABLE STATUS WHERE name LIKE 't%';
      Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
      t1	ROCKSDB	10	Fixed	5000000	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
      t2	ROCKSDB	10	Fixed	5000000	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
      t3	ROCKSDB	10	Fixed	5000000	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL	partitioned	
      select count(a) from t1;
      count(a)
      5000000
      select count(b) from t1;
      count(b)
      5000000
      select count(a) from t2;
      count(a)
      5000000
      select count(b) from t2;
      count(b)
      5000000
      select count(a) from t3;
      

      Attachments

        Activity

          Note that it has almost made it.
          Looking at the .result file I can see that there was only one big query left:

          select count(b) from t3;
          count(b)
          5000000
          

          psergei Sergei Petrunia added a comment - Note that it has almost made it. Looking at the .result file I can see that there was only one big query left: select count(b) from t3; count(b) 5000000

          Test run times on my machine:

          rocksdb.bulk_load                        [ pass ]  746,492
          rocksdb.bulk_load_unsorted               [ pass ]  153,006
          

          psergei Sergei Petrunia added a comment - Test run times on my machine: rocksdb.bulk_load [ pass ] 746,492 rocksdb.bulk_load_unsorted [ pass ] 153,006

          Possible solutions:

          • "Scale down" the test
          • Mark the test as "big".
          psergei Sergei Petrunia added a comment - Possible solutions: "Scale down" the test Mark the test as "big".

          t2.2xlarge, release build:

          rocksdb.bulk_load_unsorted               [ pass ]  47,032
          rocksdb.bulk_load                        [ pass ]  153,462
          

          psergei Sergei Petrunia added a comment - t2.2xlarge, release build: rocksdb.bulk_load_unsorted [ pass ] 47,032 rocksdb.bulk_load [ pass ] 153,462

          Elenst's windows builder, debug build: bulk_load_unsorted took 821 seconds.

          psergei Sergei Petrunia added a comment - Elenst's windows builder, debug build: bulk_load_unsorted took 821 seconds.

          A t2.2xlarge instance, and current 10.2

          debug build:

          rocksdb.bulk_load_unsorted               [ pass ]  582,258
          

          release build:

          rocksdb.bulk_load_unsorted               [ pass ]  46,926
          

          psergei Sergei Petrunia added a comment - A t2.2xlarge instance, and current 10.2 debug build: rocksdb.bulk_load_unsorted [ pass ] 582,258 release build: rocksdb.bulk_load_unsorted [ pass ] 46,926

          Down-scaled the test by a factor of 2x

          psergei Sergei Petrunia added a comment - Down-scaled the test by a factor of 2x

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.