Comments (4)
Version: '5.6.12' socket: 'sock' port: 3306 MySQL Community Server (GPL)
==27811== Thread 24:
==27811== Conditional jump or move depends on uninitialised value(s)
==27811== at 0x5E87C1: fill_index_stats(THD*, TABLE_LIST*, Item*) (table_stats.cc:692)
==27811== by 0x757581: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7195)
==27811== by 0x73A884: JOIN::prepare_result(List<Item>**) (sql_select.cc:844)
==27811== by 0x6F8B5B: JOIN::exec() (sql_executor.cc:116)
==27811== by 0x73EB14: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, SQL_I_List<st_order>*, SQL_I_List<st_order>*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:1121)
==27811== by 0x73F403: handle_select(THD*, select_result*, unsigned long) (sql_select.cc:125)
==27811== by 0x5A7DEF: execute_sqlcom_select(THD*, TABLE_LIST*, unsigned long long*) [clone .isra.149] (sql_parse.cc:5534)
==27811== by 0x71C349: mysql_execute_command(THD*, unsigned long long*, unsigned long long*) (sql_parse.cc:2969)
==27811== by 0x72081E: mysql_parse(THD*, char*, unsigned int, Parser_state*, unsigned long long*, char*) (sql_parse.cc:6694)
==27811== by 0x721E8A: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1402)
==27811== by 0x6F0181: do_handle_one_connection(THD*) (sql_connect.cc:1001)
==27811== by 0x6F022F: handle_one_connection (sql_connect.cc:917)
==27811== by 0x3537607D13: start_thread (pthread_create.c:309)
==27811== by 0x35372F168C: clone (clone.S:115)
0x00000000005e87c1 in fill_index_stats (thd=thd@entry=0x13adf890, tables=tables@entry=0x13aef538, cond=<optimized out>) at /home/sbester/build/facebook/mysql-5.6/trunk/sql/table_stats.cc:692
692 index_stats->rows_requested == 0 &&
(gdb) p *index_stats
$1 = {
name = "PRIMARY", '\000' <repeats 185 times>,
rows_inserted = 0,
rows_updated = 0,
rows_deleted = 0,
rows_read = 0,
rows_requested = 0,
rows_index_first = 0,
rows_index_next = 0,
io_perf_read = {
bytes = 0,
requests = 0,
svc_time = 0,
svc_time_max = 0,
wait_time = 0,
wait_time_max = 0,
slow_ios = 0
},
n_pages = 0,
n_pages_freed = 0,
n_btr_compress = 0,
n_btr_compress_failure = 0,
n_page_split = 0
}
(gdb) p mysql_parse::thd->query_string
$2 = {
string = {
str = 0x13ed99a0 "select IS_HASHED from `information_schema`.`INNODB_SYS_TABLESPACES` as `INNODB_SYS_TABLESPACES` cross join `information_schema`.`PROCESSLIST` as `PROCESSLIST` on (INNODB_SYS_TABLESPACES.FLAG && PROCESSLIST.DB ) inner join `information_schema`.`INNODB_BUFFER_PAGE_LRU` as `INNODB_BUFFER_PAGE_LRU` on (INNODB_SYS_TABLESPACES.FLAG is not null ) inner join `information_schema`.`INDEX_STATISTICS` as `INDEX_STATISTICS` on (INNODB_SYS_TABLESPACES.NAME <=> INDEX_STATISTICS.IO_READ_SLOW_IOS )",
length = 489
},
cs = 0x138a1e0
}
from mysql-5.6.
Testcase.....
drop procedure if exists p1;
delimiter $
create procedure p1()
begin
declare continue handler for sqlexception begin end;
repeat
if rand()>0.5 then drop table if exists t1; end if;
if rand()>0.5 then create table if not exists `t1`(`a` int primary key,b char(1), key(b))engine=innodb; end if;
if rand()>0.5 then select IS_HASHED from `information_schema`.`INNODB_SYS_TABLESPACES` as `INNODB_SYS_TABLESPACES` cross join `information_schema`.`PROCESSLIST` as `PROCESSLIST` on (INNODB_SYS_TABLESPACES.FLAG && PROCESSLIST.DB ) inner join `information_schema`.`INNODB_BUFFER_PAGE_LRU` as `INNODB_BUFFER_PAGE_LRU` on (INNODB_SYS_TABLESPACES.FLAG is not null ) inner join `information_schema`.`INDEX_STATISTICS` as `INDEX_STATISTICS` on (INNODB_SYS_TABLESPACES.NAME <=> INDEX_STATISTICS.IO_READ_SLOW_IOS ) into @a; end if;
if rand()>0.5 then select ROUTINE_BODY from `information_schema`.`INNODB_SYS_FOREIGN` as `INNODB_SYS_FOREIGN` right outer join `information_schema`.`INDEX_STATISTICS` as `INDEX_STATISTICS` on 2 natural left outer join `information_schema`.`ROUTINES` as `ROUTINES` inner join t1 on ( 1 )group by ROUTINES.DEFINER desc into @a; end if;
if rand()>0.5 then flush tables; end if;
if rand()>0.5 then rename table t1 to t2; end if;
if rand()>0.5 then rename table t2 to t1; end if;
if rand()>0.5 then alter table t1 add key g(b); end if;
if rand()>0.5 then alter table t1 add key g(a); end if;
if rand()>0.5 then alter table t1 drop key g; end if;
if rand()>0.5 then select * from `information_schema`.`INDEX_STATISTICS`; end if;
until 1=2 end repeat;
end $
delimiter ;
call p1();
from mysql-5.6.
Thanks for the detailed info.
Sorry for the crash bug - we've actually already fixed this in our current dev branch, which is based on 5.6.16. We just haven't had a chance to push an updated version here yet. We should be pushing a completely up-to-date branch up here some time in the next few weeks.
Once we do, we'd certainly love any more feedback you have.
Again, thanks!
from mysql-5.6.
Now that WebScaleSQL is public, we also pushed our 5.6.16 branch (which is based on WebScaleSQL now). That includes a fix for this bug.
from mysql-5.6.
Related Issues (20)
- Make compilation faster HOT 1
- How to achieve ~20% replication throughput improvement using Read Free Replication (RFR) feature
- Keep long-running MyRocks mtr tests in their own suite HOT 1
- MyRocks 8.0.28 has poor performance of primary key range query HOT 1
- create secondary index needs attention
- issue while install HOT 1
- Error during create secondary index
- Update the Build Steps page HOT 1
- MyRocks engine should respect WITH_UNIT_TESTS
- Allow users to manually set the number of block cache shards HOT 1
- Provide a counter to show pending compaction bytes for RocksDB
- MyRocks does commit step non-durably under server group 2PC protocol HOT 1
- alter talbe add index optimization
- Range lock support HOT 2
- Cached RocksDB transaction object accessed after delete by XA COMMIT
- optimize table has no effect on HIDDEN_PK table
- Rdb_iterator_base::next_with_direction: too many compares for eof check HOT 2
- Determin secondary index value emptiness by datadic
- undefined reference to `sgemm_' When compiling vector DB
- -DWITH_LZ4=system doesn't find the lz4 library on the fb-mysql-8.0.28 branch
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-5.6.