Yet another error I encounter whilst running DBT2 tests. This time it was a problem with generating the final reports. They are generated using a Python library which uses R under the hood. This is the error. Traceback (most recent call last): File “/usr/local/bin/dbt2-post-process”, line 14, in import rpy2.robjects as robjects File “/usr/local/lib64/python2.7/site-packages/rpy2/robjects/__init__.py”, line 15, [...]
Another issue with the DBT2 benchmarking suite. mysql reports SQL STMT: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1 Just edit the payment stored procedure and change; ?View Code MYSQLDECLARE out_w_city VARCHAR(10); To; ?View Code MYSQLDECLARE out_w_city VARCHAR(20);
I’ve been working with dbt2 benchmarking tool recently and had a few issues I thought I’d detail here for anyone else having the same issues. I was attempting to load the dbt2 database with test data; ?View Code BASHsh mysql_load_db.sh –database dbt2 –path /tmp/dbt2-w3 –mysql-path /usr/bin/mysql –user root –password secret The script threw the following error; [...]
Just recording the process I used to install the DBT2 bench-marking tool. I used OpenSuSE 12.1 for this but should work on many distributions. ?View Code BASHcd /opt/src wget http://downloads.mysql.com/source/dbt2-0.37.50.3.tar.gz tar xvf dbt2-0.37.50.3.tar.gz cd dbt2-0.37.50.3/ ./configure –with-mysql make make install Don’t forget to read the documentaiton to start running MySQL benchmarks… cat README-MYSQL
After I upgraded an instance to MySQL 5.7 I noted the following errors in the log; 2013-05-23 11:40:24 30199 [ERROR] Native table ‘performance_schema’.'events_statements_current’ has the wrong structure 2013-05-23 11:40:24 30199 [ERROR] Native table ‘performance_schema’.'events_statements_history’ has the wrong structure 2013-05-23 11:40:24 30199 [ERROR] Native table ‘performance_schema’.'events_statements_history_long’ has the wrong structure 2013-05-23 11:40:24 30199 [ERROR] Native table ‘performance_schema’.'events_statements_summary_by_thread_by_event_name’ [...]
