Project

Profile

Help

Task #7897

SQL table is not found during writing performance_test results

Added by Mark Zaslavskiy over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
High
Category:
performance
Sprint/Milestone:
Start date:
10.01.2017
Due date:
% Done:

0%

Estimated time:
Target branch:
Test scenario:

Wiki updated: https://dev.osll.ru/projects/mdbci/wiki/Prepare_slave_for_run_test#section-5

Testing: goto maxtst1 server and check tables at test_results_db database and open second terminal and go to maxtst2 server and check tables at test_results_db database there.

Expectations: tables quantity shoud be equal.

Testing: checking tables
run next command:
mysql --defaults-file=/home/vagrant/build_parser_db_password -e "use test_results_db; show tables;"

Expectation: output
+---------------------------+
| Tables_in_test_results_db |
+---------------------------+
| maxscale_parameters |
| performance_test_run |
| results |
| sysbench_results |
| test_run |
+---------------------------+


Description

"Error during writing to DB, Table 'test_results_db.performance_test_run' doesn't exist
write_db_result_to_env_file Error during writing to DB, Table 'test_results_db.performance_test_run' doesn't exist, /home/vagrant/workspace/performance_test/env_results_86"

http://max-tst-01.mariadb.com:8089/view/All/job/performance_test/86/console

Please check that all needed DBS and tables exist.

History

#1 Updated by Mark Zaslavskiy over 4 years ago

  • Assignee changed from Tatyana Berlenko to Alexander Kaluzhny

#2 Updated by Mark Zaslavskiy over 4 years ago

  • Description updated (diff)

#3 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from New to Active / In progress

#4 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from Active / In progress to Review
  • Assignee changed from Alexander Kaluzhny to Mark Zaslavskiy
  • Test scenario updated (diff)

Wiki updated: https://dev.osll.ru/projects/mdbci/wiki/Prepare_slave_for_run_test#section-5

Testing: goto maxtst1 server and check tables at test_results_db database and open second terminal and go to maxtst2 server and check tables at test_results_db database there.

Expectations: tables quantity shoud be equal.

#5 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from Review to New
  • Assignee changed from Mark Zaslavskiy to Alexander Kaluzhny

Please provide commands for checking tables.

#6 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from New to Active / In progress

#7 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from Active / In progress to Review
  • Assignee changed from Alexander Kaluzhny to Mark Zaslavskiy
  • Test scenario updated (diff)

Wiki updated: https://dev.osll.ru/projects/mdbci/wiki/Prepare_slave_for_run_test#section-5

Testing: goto maxtst1 server and check tables at test_results_db database and open second terminal and go to maxtst2 server and check tables at test_results_db database there.

Expectations: tables quantity shoud be equal.

Testing: checking tables
run next command:
mysql --defaults-file=/home/vagrant/build_parser_db_password -e "use test_results_db; show tables;"

Expectation: output
------------------------- | Tables_in_test_results_db |
------------------------- | maxscale_parameters | | performance_test_run | | results | | sysbench_results | | test_run |
-------------------------

#8 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from Review to New
  • Assignee changed from Mark Zaslavskiy to Alexander Kaluzhny

max-tst02 is ok, but max-tst03 needs to be fixed:

vagrant@max-tst-03:~$ mysql --defaults-file=/home/vagrant/build_parser_db_password e "use test_results_db; show tables;"
--------------------------
| Tables_in_test_results_db |
------------------------- | results | | test_run |
-------------------------

#9 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from New to Active / In progress

#10 Updated by Alexander Kaluzhny over 4 years ago

  • Status changed from Active / In progress to Review
  • Assignee changed from Alexander Kaluzhny to Mark Zaslavskiy

Mark Zaslavskiy wrote:

max-tst02 is ok, but max-tst03 needs to be fixed:

vagrant@max-tst-03:~$ mysql --defaults-file=/home/vagrant/build_parser_db_password e "use test_results_db; show tables;"
--------------------------
| Tables_in_test_results_db |
------------------------- | results | | test_run |
-------------------------

Fixed.
vagrant@max-tst-03:~$ mysql --defaults-file=/home/vagrant/build_parser_db_password e "use test_results_db; show tables;"
--------------------------
| Tables_in_test_results_db |
------------------------- | maxscale_parameters | | performance_test_run | | results | | sysbench_results | | test_run |
-------------------------

#11 Updated by Mark Zaslavskiy over 4 years ago

  • Status changed from Review to Closed

Also available in: Atom PDF