Brian,
What changed in Drizzle recently in staging to break this query? What needs
to change?
"SELECT table_schema, ".
"table_name, ".
"CASE WHEN table_type = 'BASE TABLE' THEN 'table' ".
"WHEN table_type = 'VIEW' THEN 'view' ".
"WHEN table_type = 'SYSTEM VIEW' then 'view' ".
"ELSE 'misc' END, ".
"column_name, ".
"CASE WHEN column_key = 'PRI' THEN 'primary' ".
"WHEN column_key = 'MUL' THEN 'indexed' ".
"WHEN column_key = 'UNI' THEN 'indexed' ".
"ELSE 'ordinary' END ".
"FROM data_dictionary.tables INNER JOIN ".
"data_dictionary.columns USING(table_schema, table_name)";
On Fri, Feb 26, 2010 at 6:58 PM, <[email protected]> wrote:
> See <http://hudson.drizzle.org/job/drizzle-staging-randgen/180/>
>
> ------------------------------------------
> [...truncated 925 lines...]
> Fri Feb 26 18:58:18 2010 INFO: Dropping any test database previously setup.
> Fri Feb 26 18:58:18 2010 INFO: Creating test database.
> Fri Feb 26 18:58:18 2010 INFO: Running : limit_compare with
> ./gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> --threads=5 --queries=1000 --engine=Innodb --gendata=conf/drizzle.zz
> --grammar=conf/limit_compare.yy
> Fri Feb 26 18:58:20 2010 INFO: limit_compare FAILED
> # 18:58:18 Starting
> # 18:58:18 ./gentest.pl \
> # 18:58:18
> --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 18:58:18 --threads=5 \
> # 18:58:18 --queries=1000 \
> # 18:58:18 --engine=Innodb \
> # 18:58:18 --gendata=conf/drizzle.zz \
> # 18:58:18 --grammar=conf/limit_compare.yy
> # 18:58:18 -------------------------------
> # 18:58:18 Configuration
> # 18:58:18 dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 18:58:18 duration => 3600
> # 18:58:18 engine => Innodb
> # 18:58:18 gendata => conf/drizzle.zz
> # 18:58:18 grammar => conf/limit_compare.yy
> # 18:58:18 queries => 1000
> # 18:58:18 reporters => ['']
> # 18:58:18 seed => 1
> # 18:58:18 threads => 5
> # 18:58:18 validators => ['']
> # 18:58:18 Default schema: test
> # 18:58:18 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:18 # Creating Drizzle table test.table0_innodb_int_autoinc .
> # 18:58:18 # Creating Drizzle table test.table1_innodb_int_autoinc .
> # 18:58:18 # Creating Drizzle table test.table10_innodb_int_autoinc .
> # 18:58:18 # Creating Drizzle table test.table100_innodb_int_autoinc .
> # 18:58:18 Reporters: ErrorLog, Backtrace
> # 18:58:18 Validators: ErrorMessageCorruption
> # 18:58:18 Starting 5 processes, 1000 queries each, duration 3600 seconds.
> # 18:58:18 GenTest::ErrorFilter(8005) started
> # 18:58:18 Default schema: test
> # 18:58:18 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:18 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:19 Default schema: test
> # 18:58:19 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:19 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:19 Default schema: test
> # 18:58:19 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:19 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:19 Default schema: test
> # 18:58:19 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:19 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:19 Default schema: test
> # 18:58:19 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:19 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:19 Started periodic reporting process...
> # 18:58:20 Killing periodic reporting process with pid 8006...
> # 18:58:20 Kill GenTest::ErrorFilter(8005)
> # 18:58:20 Test completed with failure status 11.
> Fri Feb 26 18:58:20 2010 INFO: Stopping Drizzled server on port 9306
> Fri Feb 26 18:58:23 2010 INFO: Clearing Drizzled server on port 9306
> Fri Feb 26 18:58:23 2010 INFO: Starting Drizzled server on port 9306
> Fri Feb 26 18:58:24 2010 INFO: Dropping any test database previously setup.
> Fri Feb 26 18:58:24 2010 INFO: Creating test database.
> Fri Feb 26 18:58:24 2010 INFO: Running : subquery_semijoin_nested with ./
> gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> --threads=5 --queries=1000 --engine=Innodb --gendata=conf/drizzle.zz
> --grammar=conf/subquery_semijoin_nested_drizzle.yy
> Fri Feb 26 18:58:26 2010 INFO: subquery_semijoin_nested FAILED
> # 18:58:24 Starting
> # 18:58:24 ./gentest.pl \
> # 18:58:24
> --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 18:58:24 --threads=5 \
> # 18:58:24 --queries=1000 \
> # 18:58:24 --engine=Innodb \
> # 18:58:24 --gendata=conf/drizzle.zz \
> # 18:58:24 --grammar=conf/subquery_semijoin_nested_drizzle.yy
> # 18:58:24 -------------------------------
> # 18:58:24 Configuration
> # 18:58:24 dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 18:58:24 duration => 3600
> # 18:58:24 engine => Innodb
> # 18:58:24 gendata => conf/drizzle.zz
> # 18:58:24 grammar => conf/subquery_semijoin_nested_drizzle.yy
> # 18:58:24 queries => 1000
> # 18:58:24 reporters => ['']
> # 18:58:24 seed => 1
> # 18:58:24 threads => 5
> # 18:58:24 validators => ['']
> # 18:58:24 Default schema: test
> # 18:58:24 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:24 # Creating Drizzle table test.table0_innodb_int_autoinc .
> # 18:58:24 # Creating Drizzle table test.table1_innodb_int_autoinc .
> # 18:58:24 # Creating Drizzle table test.table10_innodb_int_autoinc .
> # 18:58:24 # Creating Drizzle table test.table100_innodb_int_autoinc .
> # 18:58:25 Reporters: ErrorLog, Backtrace
> # 18:58:25 Validators: ErrorMessageCorruption
> # 18:58:25 Starting 5 processes, 1000 queries each, duration 3600 seconds.
> # 18:58:25 GenTest::ErrorFilter(8055) started
> # 18:58:25 Default schema: test
> # 18:58:25 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:25 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:25 Default schema: test
> # 18:58:25 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:25 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:25 Default schema: test
> # 18:58:25 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:25 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:25 Default schema: test
> # 18:58:25 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:25 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:25 Default schema: test
> # 18:58:25 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:25 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:25 Started periodic reporting process...
> # 18:58:26 Killing periodic reporting process with pid 8056...
> # 18:58:26 Kill GenTest::ErrorFilter(8055)
> # 18:58:26 Test completed with failure status 11.
> Fri Feb 26 18:58:26 2010 INFO: Stopping Drizzled server on port 9306
> Fri Feb 26 18:58:29 2010 INFO: Clearing Drizzled server on port 9306
> Fri Feb 26 18:58:29 2010 INFO: Starting Drizzled server on port 9306
> Fri Feb 26 18:58:30 2010 INFO: Dropping any test database previously setup.
> Fri Feb 26 18:58:30 2010 INFO: Creating test database.
> Fri Feb 26 18:58:30 2010 INFO: Running :
> database_consistency_after_recovery with
> ./gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> --threads=5 --queries=1000 --engine=Innodb --gendata=conf/transactions.zz
> --grammar=conf/transactions.yy --reporters=RecoveryConsistency
> Fri Feb 26 18:58:32 2010 INFO: database_consistency_after_recovery FAILED
> # 18:58:30 Starting
> # 18:58:30 ./gentest.pl \
> # 18:58:30
> --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 18:58:30 --threads=5 \
> # 18:58:30 --queries=1000 \
> # 18:58:30 --engine=Innodb \
> # 18:58:30 --gendata=conf/transactions.zz \
> # 18:58:30 --grammar=conf/transactions.yy \
> # 18:58:30 --reporters=RecoveryConsistency
> # 18:58:30 -------------------------------
> # 18:58:30 Configuration
> # 18:58:30 dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 18:58:30 duration => 3600
> # 18:58:30 engine => Innodb
> # 18:58:30 gendata => conf/transactions.zz
> # 18:58:30 grammar => conf/transactions.yy
> # 18:58:30 queries => 1000
> # 18:58:30 reporters => ['RecoveryConsistency']
> # 18:58:30 seed => 1
> # 18:58:30 threads => 5
> # 18:58:30 validators => ['']
> # 18:58:30 Default schema: test
> # 18:58:30 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:30 # Creating Drizzle table test.table10_innodb_int_autoinc .
> # 18:58:30 # Creating Drizzle table test.table100_innodb_int_autoinc .
> # 18:58:30 Reporters: RecoveryConsistency
> # 18:58:30 Validators: ErrorMessageCorruption
> # 18:58:30 Starting 5 processes, 1000 queries each, duration 3600 seconds.
> # 18:58:30 GenTest::ErrorFilter(8105) started
> # 18:58:30 Default schema: test
> # 18:58:30 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:30 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:30 Default schema: test
> # 18:58:30 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:30 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:31 Default schema: test
> # 18:58:31 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:31 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:31 Default schema: test
> # 18:58:31 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:31 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:31 Default schema: test
> # 18:58:31 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:31 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:31 Started periodic reporting process...
> # 18:58:32 Killing periodic reporting process with pid 8106...
> # 18:58:32 Kill GenTest::ErrorFilter(8105)
> # 18:58:32 Test completed with failure status 11.
> Fri Feb 26 18:58:32 2010 INFO: Stopping Drizzled server on port 9306
> Fri Feb 26 18:58:35 2010 INFO: Clearing Drizzled server on port 9306
> Fri Feb 26 18:58:35 2010 INFO: Starting Drizzled server on port 9306
> Fri Feb 26 18:58:36 2010 INFO: Dropping any test database previously setup.
> Fri Feb 26 18:58:36 2010 INFO: Creating test database.
> Fri Feb 26 18:58:36 2010 INFO: Running : optimizer_subquery_portable with
> ./gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> --threads=5 --queries=1000 --engine=Innodb --gendata=conf/drizzle.zz
> --grammar=conf/optimizer_subquery_portable.yy --validators=SelectStability
> Fri Feb 26 18:58:38 2010 INFO: optimizer_subquery_portable FAILED
> # 18:58:36 Starting
> # 18:58:36 ./gentest.pl \
> # 18:58:36
> --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> \
> # 18:58:36 --threads=5 \
> # 18:58:36 --queries=1000 \
> # 18:58:36 --engine=Innodb \
> # 18:58:36 --gendata=conf/drizzle.zz \
> # 18:58:36 --grammar=conf/optimizer_subquery_portable.yy \
> # 18:58:36 --validators=SelectStability
> # 18:58:36 -------------------------------
> # 18:58:36 Configuration
> # 18:58:36 dsn =>
> ['dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test']
> # 18:58:36 duration => 3600
> # 18:58:36 engine => Innodb
> # 18:58:36 gendata => conf/drizzle.zz
> # 18:58:36 grammar => conf/optimizer_subquery_portable.yy
> # 18:58:36 queries => 1000
> # 18:58:36 reporters => ['']
> # 18:58:36 seed => 1
> # 18:58:36 threads => 5
> # 18:58:36 validators => ['SelectStability']
> # 18:58:36 Default schema: test
> # 18:58:36 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:36 # Creating Drizzle table test.table0_innodb_int_autoinc .
> # 18:58:36 # Creating Drizzle table test.table1_innodb_int_autoinc .
> # 18:58:36 # Creating Drizzle table test.table10_innodb_int_autoinc .
> # 18:58:36 # Creating Drizzle table test.table100_innodb_int_autoinc .
> # 18:58:36 Reporters: ErrorLog, Backtrace
> # 18:58:36 Validators: SelectStability
> # 18:58:36 Starting 5 processes, 1000 queries each, duration 3600 seconds.
> # 18:58:36 GenTest::ErrorFilter(8155) started
> # 18:58:36 Default schema: test
> # 18:58:36 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:36 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:37 Default schema: test
> # 18:58:37 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:37 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:37 Default schema: test
> # 18:58:37 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:37 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:37 Default schema: test
> # 18:58:37 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:37 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:37 Default schema: test
> # 18:58:37 Executor initialized, id GenTest::Executor::Drizzle 2010.02.1313
> ()
> # 18:58:37 Caching metadata for
> dbi:drizzle:host=localhost:port=9306:user=root:password=:database=test
> Can't use an undefined value as an ARRAY reference at
> lib/GenTest/Executor.pm line 225.
> # 18:58:37 Started periodic reporting process...
> # 18:58:38 Killing periodic reporting process with pid 8156...
> # 18:58:38 Kill GenTest::ErrorFilter(8155)
> # 18:58:38 Test completed with failure status 11.
> Fri Feb 26 18:58:38 2010 INFO: Stopping Drizzled server on port 9306
> Fri Feb 26 18:58:41 2010 INFO: Clearing Drizzled server on port 9306
> Fri Feb 26 18:58:41 2010 INFO: Starting Drizzled server on port 9306
> Fri Feb 26 18:58:42 2010 INFO: Dropping any test database previously setup.
> Fri Feb 26 18:58:42 2010 INFO: Creating test database.
> Fri Feb 26 18:58:42 2010 INFO: Stopping Drizzled server on port 9306
> Fri Feb 26 18:58:42 2010 INFO: 0 tests passed
> Fri Feb 26 18:58:42 2010 INFO: 19 tests failed
>
>
> _______________________________________________
> Mailing list:
> https://launchpad.net/~drizzle-builds<https://launchpad.net/%7Edrizzle-builds>
> Post to : [email protected]
> Unsubscribe :
> https://launchpad.net/~drizzle-builds<https://launchpad.net/%7Edrizzle-builds>
> More help : https://help.launchpad.net/ListHelp
>
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-builds
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-builds
More help : https://help.launchpad.net/ListHelp
