免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1800 | 回复: 3

[OpenStack] mariadb报错 [复制链接]

论坛徽章:
2
IT运维版块每日发帖之星
日期:2015-08-23 06:20:00IT运维版块每日发帖之星
日期:2015-09-23 06:20:00
发表于 2015-09-17 21:28 |显示全部楼层
执行 neutron agent-list 报错 经分析发现mysql起不来了,
[root@controller mariadb]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

贴出mariadb.log日志,请大神帮忙看看
  1. 150917  8:05:35 [ERROR] mysqld got signal 6 ;
  2. This could be because you hit a bug. It is also possible that this binary
  3. or one of the libraries it was linked against is corrupt, improperly built,
  4. or misconfigured. This error can also be caused by malfunctioning hardware.

  5. To report this bug, see http----(----我添加的)://kb.askmonty.org/en/reporting-bugs

  6. We will try our best to scrape up some info that will hopefully help
  7. diagnose the problem, but since we have already crashed,
  8. something is definitely wrong and this may fail.

  9. Server version: 5.5.44-MariaDB
  10. key_buffer_size=134217728
  11. read_buffer_size=131072
  12. max_used_connections=0
  13. max_threads=153
  14. thread_count=0
  15. It is possible that mysqld could use up to
  16. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466713 K  bytes of memory
  17. Hope that's ok; if not, decrease some variables in the equation.

  18. Thread pointer: 0x0x0
  19. Attempting backtrace. You can use the following information to find out
  20. where mysqld died. If you see no messages after this, something went
  21. terribly wrong...
  22. stack_bottom = 0x0 thread_stack 0x48000
  23. /usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x7f10b65af15d]
  24. /usr/libexec/mysqld(handle_fatal_signal+0x515)[0x7f10b61c43b5]
  25. /lib64/libpthread.so.0(+0xf130)[0x7f10b58f4130]
  26. /lib64/libc.so.6(gsignal+0x37)[0x7f10b40a95d7]
  27. /lib64/libc.so.6(abort+0x148)[0x7f10b40aacc8]
  28. /usr/libexec/mysqld(+0x2d5688)[0x7f10b5ffa688]
  29. /usr/libexec/mysqld(+0x6eb590)[0x7f10b6410590]
  30. /usr/libexec/mysqld(+0x64bbbe)[0x7f10b6370bbe]
  31. /usr/libexec/mysqld(+0x665133)[0x7f10b638a133]
  32. /usr/libexec/mysqld(+0x65afbd)[0x7f10b637ffbd]
  33. /usr/libexec/mysqld(+0x65cda1)[0x7f10b6381da1]
  34. /usr/libexec/mysqld(+0x6559df)[0x7f10b637a9df]
  35. /usr/libexec/mysqld(+0x73e96c)[0x7f10b646396c]
  36. /usr/libexec/mysqld(+0x73fdfa)[0x7f10b6464dfa]
  37. /usr/libexec/mysqld(+0x653d79)[0x7f10b6378d79]
  38. /usr/libexec/mysqld(+0x654446)[0x7f10b6379446]
  39. /lib64/libpthread.so.0(+0x7df5)[0x7f10b58ecdf5]
  40. /lib64/libc.so.6(clone+0x6d)[0x7f10b416a1ad]
  41. The manual page at http----(----我添加的)://dev.mysql.com/doc/mysql/en/crashing.html contains
  42. information that should help you find out what is causing the crash.
  43. 150917 08:05:36 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
  44. 150917 08:33:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  45. 150917  8:33:14 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 4517 ...
  46. 150917  8:33:14 InnoDB: The InnoDB memory heap is disabled
  47. 150917  8:33:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  48. 150917  8:33:14 InnoDB: Compressed tables use zlib 1.2.7
  49. 150917  8:33:14 InnoDB: Using Linux native AIO
  50. 150917  8:33:14 InnoDB: Initializing buffer pool, size = 128.0M
  51. 150917  8:33:14 InnoDB: Completed initialization of buffer pool
  52. 150917  8:33:14 InnoDB: highest supported file format is Barracuda.
  53. InnoDB: Log scan progressed past the checkpoint lsn 9326855
  54. 150917  8:33:14  InnoDB: Database was not shut down normally!
  55. InnoDB: Starting crash recovery.
  56. InnoDB: Reading tablespace information from the .ibd files...
  57. InnoDB: Restoring possible half-written data pages from the doublewrite
  58. InnoDB: buffer...
  59. InnoDB: Doing recovery: scanned up to log sequence number 9327504
  60. InnoDB: 1 transaction(s) which must be rolled back or cleaned up
  61. InnoDB: in total 1 row operations to undo
  62. InnoDB: Trx id counter is 9B00
  63. 150917  8:33:15  InnoDB: Starting an apply batch of log records to the database...
  64. InnoDB: Progress in percents: 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  65. InnoDB: Apply batch completed
  66. 150917  8:33:15  InnoDB: Waiting for the background threads to start
  67. InnoDB: Starting in background the rollback of uncommitted transactions
  68. 150917  8:33:15  InnoDB: Rolling back trx with id 990F, 1 rows to undo
  69. 150917  8:33:15  InnoDB: Assertion failure in thread 140695227995904 in file fut0lst.ic line 83
  70. InnoDB: Failing assertion: addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA
  71. InnoDB: We intentionally generate a memory trap.
  72. InnoDB: Submit a detailed bug report to http----(----我添加的)://bugs.mysql.com.
  73. InnoDB: If you get repeated assertion failures or crashes, even
  74. InnoDB: immediately after the mysqld startup, there may be
  75. InnoDB: corruption in the InnoDB tablespace. Please refer to
  76. InnoDB: http----(----我添加的)://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
  77. InnoDB: about forcing recovery.
复制代码

论坛徽章:
45
2016猴年福章徽章
日期:2016-02-18 16:42:24平安夜徽章
日期:2015-12-27 09:46:0315-16赛季CBA联赛之八一
日期:2015-12-15 17:08:23黄金圣斗士
日期:2015-12-11 09:16:31天蝎座
日期:2015-12-11 09:16:22戌狗
日期:2015-12-11 09:16:19程序设计版块每周发帖之星
日期:2015-12-11 09:15:21操作系统版块每周发帖之星
日期:2015-12-11 09:15:16IT运维版块每周发帖之星
日期:2015-12-11 09:15:09IT运维版块每月发帖之星
日期:2015-12-11 09:15:01CU十四周年纪念徽章
日期:2015-12-11 09:14:40操作系统版块每日发帖之星
日期:2015-12-11 09:13:36
发表于 2015-09-18 14:52 |显示全部楼层
看看防火墙

论坛徽章:
2
IT运维版块每日发帖之星
日期:2015-08-23 06:20:00IT运维版块每日发帖之星
日期:2015-09-23 06:20:00
发表于 2015-09-18 18:24 |显示全部楼层
回复 2# csoho2000


    防火墙已经关闭。经分析是由于电脑突然死机,导致了mysql临时数据过多,已经重新部署。

论坛徽章:
0
发表于 2015-09-22 11:13 |显示全部楼层
不错的,看来支持呢
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP