enterprise-support team mailing list archive

[Calvin Li <calli@xxxxxxxxxxx>]

Public bug reported:

OS:  Ubuntu 14.04.1 LTS
Perl v5.18.2
DBD::mysql version: 4.025
mysql version: 5.6.22

Hi, I'm new to using RQG, and while using gentest with one of the
example grammars,

perl ~/project/randgen/gentest.pl \
        --queries=1 \
        --threads=1 \
        --seed=10 \
        --reporters='' \
        --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \
        --grammar=conf/optimizer/optimizer_no_subquery.yy \

I got the following error in the query:

# 2015-02-20T23:00:27 Starting: /home/calli/project/randgen/gentest.pl --queries=1 --threads=1 --seed=10 --reporters= --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test --grammar=conf/optimizer/optimizer_no_subquery.yy
# 2015-02-20T23:00:27 -------------------------------
# 2015-02-20T23:00:27 Configuration
# 2015-02-20T23:00:27   debug_server => ['']
# 2015-02-20T23:00:27   dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test']
# 2015-02-20T23:00:27   duration => 3600
# 2015-02-20T23:00:27   generator => FromGrammar
# 2015-02-20T23:00:27   grammar => conf/optimizer/optimizer_no_subquery.yy
# 2015-02-20T23:00:27   queries => 1
# 2015-02-20T23:00:27   reporters => ['']
# 2015-02-20T23:00:27   seed => 10
# 2015-02-20T23:00:27   threads => 1
# 2015-02-20T23:00:27   transformers => ['']
# 2015-02-20T23:00:27   validators => ['']
# 2015-02-20T23:00:27   views => ['', '']
# 2015-02-20T23:00:27 Reporters: (none)
# 2015-02-20T23:00:27 Validators: ErrorMessageCorruption
# 2015-02-20T23:00:27 Caching schema metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
# 2015-02-20T23:00:27 Starting 1 processes, 1 queries each, duration 3600 seconds.
# 2015-02-20T23:00:27 GenTest::ErrorFilter(27207) started
# 2015-02-20T23:00:27 Loading Validator GenTest::Validator::ErrorMessageCorruption.
 SELECT DISTINCT   SUM(  alias2 . `col_varchar_key` ) AS field1 FROM ( B AS alias1 , ( view_CC AS alias2 , A AS alias3 ) ) WHERE alias2 . `pk` = alias1 . `pk`   ORDER BY field1 , alias1 . `col_date_key` ASC
# 2015-02-20T23:00:27 Child worker process completed successfully.
# 2015-02-20T23:00:27 Query:  SELECT DISTINCT   SUM(  alias2 . `col_varchar_key` ) AS field1 FROM ( B AS alias1 , ( view_CC AS alias2 , A AS alias3 ) ) WHERE alias2 . `pk` = alias1 . `pk`   ORDER BY field1 , alias1 . `col_date_key` ASC  failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed.
# 2015-02-20T23:00:27 Started periodic reporting process...
# 2015-02-20T23:00:28 Killing periodic reporting process with pid 27208...
# 2015-02-20T23:00:28 Kill GenTest::ErrorFilter(27207)
# 2015-02-20T23:00:28 Test completed successfully.

I'm using the database generated by runall.pl.

The error message says table '%s' rather than a specific table. Is that
supposed to happen? If it is, how should I resolve the error?

Thanks!

** Affects: randgen
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1424136

Title:
  "Table %s doesn't exist" error when trying to test a query

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/1424136/+subscriptions