这篇文章主要介绍“mysqld得到了信号举例分析",在日常操作中,相信很多人在mysqld收到信号举例分析问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答“mysqld得到了信号举例分析"的疑惑有所帮助!接下来,请跟着小编一起来学习吧!
描述选择ongfroimestampbasedrangepartition时为:其中tablehasnopartitionto和evalueslesthanmaxvalue和selectconditionreadsfromtlastpartition rgcreator,mysqldgetsasignal8 .
Repeatablewith5.5.23,5。5 .24和5.5.25,不是5.5.20,5.5.21,5。5 .22如何重复:[revin @ forge msb _ 5 _ 5 _ 24]$ ./usetest
正在读取completionoftable和columname的表信息
您可以使用构成动植物的古名或拉丁化的现代名将此功能集合到一起
WelcometotheMySQLmonitor .命令结束于或\g .
您的MySQLconnectionidis1
服务器版本:5 .5 .24数据库社区服务器(GPL)
版权所有2000年、2011年,Oracleand/oris附属公司。保留所有权利。
oracleisaregisteredtrademarkrclection和/或orits
附属公司。其他名称电子地图软件各自
业主。
键入“帮助”;或" \h "获取帮助,键入" \c "清除当前语句。
mysql[localhost]{msandbox}(测试)showcreatetabletabletable _ XXXXX \ G
* * * * * * * * * * * * * * * * * * * * * 1 .行* * * * * * * * * * * * * * * * * * * * * * * *
表:表_XXXXX
create table : create table ` table _ xxxxx `(
` record _ type ` small int(5)unsignedNOTNULL,
` timestamp ' int(10)unsignedNOTNULL,
` meta_pos_id`smal
lint(5) unsigned NOT NULL,
`value` mediumint(8) unsigned NOT NULL,
KEY `ts_rtype` (`timestamp`,`record_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (timestamp)
(PARTITION 2012y03m VALUES LESS THAN (1333238400) ENGINE = InnoDB,
PARTITION 2012y04m VALUES LESS THAN (1335830400) ENGINE = InnoDB,
PARTITION 2012y05m VALUES LESS THAN (1338508800) ENGINE = InnoDB,
PARTITION 2012y06m VALUES LESS THAN (1341100800) ENGINE = InnoDB) */
1 row in set (0.00 sec)
mysql [localhost] {msandbox} (test) > SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1338508800;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
mysql [localhost] {msandbox} (test) > SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799;
ERROR 2013 (HY000): Lost connection to MySQL server during query Suggested fix: NA, but a workaround is to add a partition to handle values less than MAXVALUE.
Backtrace from core file during one of the crashes. Attachment: 23293-backtrace.txt (text/plain), 13.89 KiB.
Error log from sandbox creation to crash then restart. Attachment: 23293-error-log.txt (text/plain), 9.63 KiB.
Thank you for the bug report. Indeed repeatable with 5.5.24 but not anymore with current source: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. h:\dbs>55 h:\dbs>h:\dbs\5.5\bin\mysql -uroot --port=3540 --prompt="mysql 5.5 >" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.24 Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.5 >use test Database changed mysql 5.5 >CREATE TABLE `table_XXXXX` ( -> `record_type` smallint(5) unsigned NOT NULL, -> `timestamp` int(10) unsigned NOT NULL, -> `meta_pos_id` smallint(5) unsigned NOT NULL, -> `value` mediumint(8) unsigned NOT NULL, -> KEY `ts_rtype` (`timestamp`,`record_type`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (timestamp) -> (PARTITION 2012y03m VALUES LESS THAN (1333238400) ENGINE = InnoDB, -> PARTITION 2012y04m VALUES LESS THAN (1335830400) ENGINE = InnoDB, -> PARTITION 2012y05m VALUES LESS THAN (1338508800) ENGINE = InnoDB, -> PARTITION 2012y06m VALUES LESS THAN (1341100800) ENGINE = InnoDB) */; Query OK, 0 rows affected (0.88 sec) mysql 5.5 >SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1338508800; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql 5.5 >SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql 5.5 > Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. d:\dbs>55 d:\dbs>d:\dbs\5.5\bin\mysql -uroot --port=3541 --prompt="mysql 5.5 >" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.26 Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.5 >use test Database changed mysql 5.5 >CREATE TABLE `table_XXXXX` ( -> `record_type` smallint(5) unsigned NOT NULL, -> `timestamp` int(10) unsigned NOT NULL, -> `meta_pos_id` smallint(5) unsigned NOT NULL, -> `value` mediumint(8) unsigned NOT NULL, -> KEY `ts_rtype` (`timestamp`,`record_type`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (timestamp) -> (PARTITION 2012y03m VALUES LESS THAN (1333238400) ENGINE = InnoDB, -> PARTITION 2012y04m VALUES LESS THAN (1335830400) ENGINE = InnoDB, -> PARTITION 2012y05m VALUES LESS THAN (1338508800) ENGINE = InnoDB, -> PARTITION 2012y06m VALUES LESS THAN (1341100800) ENGINE = InnoDB) */; Query OK, 0 rows affected (0.24 sec) mysql 5.5 >SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1338508800; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.05 sec) mysql 5.5 >SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql 5.5 >
Miguel, have you tried with 5.5.25 official Oracle binaries as I did?
Not sure why this is still marked as can't repeat - have you tested with official Oracle binaries yet?
The problem still exists on 5.5.25a, not sure why this is still can't repeat? [revin@forge mysql]$ sb 5525 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.25a MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql [localhost] {msandbox} ((none)) > use test; Database changed mysql [localhost] {msandbox} (test) > CREATE TABLE `table_XXXXX` ( -> `record_type` smallint(5) unsigned NOT NULL, -> `timestamp` int(10) unsigned NOT NULL, -> `meta_pos_id` smallint(5) unsigned NOT NULL, -> `value` mediumint(8) unsigned NOT NULL, -> KEY `ts_rtype` (`timestamp`,`record_type`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (timestamp) -> (PARTITION 2012y03m VALUES LESS THAN (1333238400) ENGINE = InnoDB, -> PARTITION 2012y04m VALUES LESS THAN (1335830400) ENGINE = InnoDB, -> PARTITION 2012y05m VALUES LESS THAN (1338508800) ENGINE = InnoDB, -> PARTITION 2012y06m VALUES LESS THAN (1341100800) ENGINE = InnoDB) */ -> ; Query OK, 0 rows affected (0.01 sec) mysql [localhost] {msandbox} (test) > SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1338508800; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql [localhost] {msandbox} (test) > SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql [localhost] {msandbox} (test) >
This is a know bug that is fixed in current code: macbook-pro:5.5 openxs$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.28-debug Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE TABLE `table_XXXXX` ( -> `record_type` smallint(5) unsigned NOT NULL, -> `timestamp` int(10) unsigned NOT NULL, -> `meta_pos_id` smallint(5) unsigned NOT NULL, -> `value` mediumint(8) unsigned NOT NULL, -> KEY `ts_rtype` (`timestamp`,`record_type`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (timestamp) -> (PARTITION 2012y03m VALUES LESS THAN (1333238400) ENGINE = InnoDB, -> PARTITION 2012y04m VALUES LESS THAN (1335830400) ENGINE = InnoDB, -> PARTITION 2012y05m VALUES LESS THAN (1338508800) ENGINE = InnoDB, -> PARTITION 2012y06m VALUES LESS THAN (1341100800) ENGINE = InnoDB) */; Query OK, 0 rows affected (0.07 sec) mysql> SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1338508800; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) So, please, wait for the official release of 5.5.27 with the fix.
Valeriy, Thanks - looks like Miguel tested with 5.5.26 - is this coming to .26 or .27 as you mentioned?
Ahh, nvm, found my answer :) http://dev.mysql.com/doc/refman/5.5/en/news-5-5-26.html
到此,关于“mysqld got signal举例分析”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注网站,小编会继续努力为大家带来更多实用的文章!
内容来源网络,如有侵权,联系删除,本文地址:https://www.230890.com/zhan/104203.html