API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 18th, 2017
304
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.14 KB | None | 0 0
raw download clone embed print report
  1. root@manager:/opt/mysql/server-5.7# bin/mysql_install_db --user=mysql
  2. 2017-03-18 20:13:31 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
  3. 2017-03-18 20:13:31 [ERROR] The data directory needs to be specified.
  4. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  5. mysqld mysqld-debug mysqld_multi mysqld_safe mysqldump mysqldumpslow
  6. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  7. mysqld mysqld-debug mysqld_multi mysqld_safe mysqldump mysqldumpslow
  8. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  9. bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
  10. root@manager:/opt/mysql/server-5.7# apt-get install numactl
  11. Leyendo lista de paquetes... Hecho
  12. Creando árbol de dependencias
  13. Leyendo la información de estado... Hecho
  14. Se instalarán los siguientes paquetes extras:
  15. libnuma1
  16. Se instalarán los siguientes paquetes NUEVOS:
  17. libnuma1 numactl
  18. 0 actualizados, 2 nuevos se instalarán, 0 para eliminar y 141 no actualizados.
  19. Se necesita descargar 78,3 kB de archivos.
  20. Se utilizarán 160 kB de espacio de disco adicional después de esta operación.
  21. ¿Desea continuar? [S/n] s
  22. Des:1 http://ftp.es.debian.org/debian/ jessie/main libnuma1 i386 2.0.10-1 [33,7 kB]
  23. Des:2 http://ftp.es.debian.org/debian/ jessie/main numactl i386 2.0.10-1 [44,7 kB]
  24. Descargados 78,3 kB en 0s (193 kB/s)
  25. Seleccionando el paquete libnuma1:i386 previamente no seleccionado.
  26. (Leyendo la base de datos ... 70197 ficheros o directorios instalados actualmente.)
  27. Preparando para desempaquetar .../libnuma1_2.0.10-1_i386.deb ...
  28. Desempaquetando libnuma1:i386 (2.0.10-1) ...
  29. Seleccionando el paquete numactl previamente no seleccionado.
  30. Preparando para desempaquetar .../numactl_2.0.10-1_i386.deb ...
  31. Desempaquetando numactl (2.0.10-1) ...
  32. Procesando disparadores para man-db (2.7.0.2-5) ...
  33. Configurando libnuma1:i386 (2.0.10-1) ...
  34. Configurando numactl (2.0.10-1) ...
  35. Procesando disparadores para libc-bin (2.19-18+deb8u1) ...
  36. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  37. mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
  38. 2017-03-18T19:16:31.580801Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  39. 2017-03-18T19:16:31.587701Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
  40. 2017-03-18T19:16:31.588350Z 0 [ERROR] Aborting
  41.  
  42. 2017-03-18T19:16:31.611289Z 0 [Note] Binlog end
  43. root@manager:/opt/mysql/server-5.7# ls /var/lib/
  44. apt/ dpkg/ libxml-sax-perl/ os-prober/ update-rc.d/
  45. aptitude/ emacsen-common/ logrotate/ pam/ urandom/
  46. aspell/ exim4/ man-db/ python-support/ usbutils/
  47. container/ initramfs-tools/ misc/ sgml-base/ vim/
  48. dbus/ initscripts/ mlocate/ systemd/ xml-core/
  49. dhcp/ insserv/ mysql-cluster/ tex-common/
  50. dictionaries-common/ ispell/ nfs/ ucf/
  51. root@manager:/opt/mysql/server-5.7# mkdir /var/lib/mysql-files
  52. root@manager:/opt/mysql/server-5.7#
  53. root@manager:/opt/mysql/server-5.7#
  54. root@manager:/opt/mysql/server-5.7#
  55. root@manager:/opt/mysql/server-5.7#
  56. root@manager:/opt/mysql/server-5.7#
  57. root@manager:/opt/mysql/server-5.7#
  58. root@manager:/opt/mysql/server-5.7#
  59. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  60. mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2 - No such file or directory)
  61. 2017-03-18T19:18:15.099299Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  62. 2017-03-18T19:18:15.099387Z 0 [Warning] Can't create test file /var/lib/mysql/manager.lower-test
  63. 2017-03-18T19:18:15.099397Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
  64. 2017-03-18T19:18:15.099421Z 0 [Note] bin/mysqld (mysqld 5.7.17-ndb-7.5.5-cluster-gpl) starting as process 21290 ...
  65. 2017-03-18T19:18:15.185002Z 0 [Warning] Can't create test file /var/lib/mysql/manager.lower-test
  66. 2017-03-18T19:18:15.185027Z 0 [Warning] Can't create test file /var/lib/mysql/manager.lower-test
  67. 2017-03-18T19:18:15.185564Z 0 [ERROR] failed to set datadir to /var/lib/mysql/
  68. 2017-03-18T19:18:15.187419Z 0 [ERROR] Aborting
  69.  
  70. 2017-03-18T19:18:15.187801Z 0 [Note] Binlog end
  71. 2017-03-18T19:18:15.188166Z 0 [Note] bin/mysqld: Shutdown complete
  72.  
  73. root@manager:/opt/mysql/server-5.7# mkdir /var/lib/mysql
  74. root@manager:/opt/mysql/server-5.7# bin/mysqld --user=mysql
  75. 2017-03-18T19:19:04.064933Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  76. 2017-03-18T19:19:04.065896Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
  77. 2017-03-18T19:19:04.065925Z 0 [Note] bin/mysqld (mysqld 5.7.17-ndb-7.5.5-cluster-gpl) starting as process 21292 ...
  78. 2017-03-18T19:19:04.135971Z 0 [Note] InnoDB: PUNCH HOLE support available
  79. 2017-03-18T19:19:04.136456Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  80. 2017-03-18T19:19:04.136757Z 0 [Note] InnoDB: Uses event mutexes
  81. 2017-03-18T19:19:04.137955Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  82. 2017-03-18T19:19:04.137969Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  83. 2017-03-18T19:19:04.137977Z 0 [Note] InnoDB: Using Linux native AIO
  84. 2017-03-18T19:19:04.156710Z 0 [Note] InnoDB: Number of pools: 1
  85. 2017-03-18T19:19:04.170341Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  86. 2017-03-18T19:19:04.172013Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  87. 2017-03-18T19:19:04.202587Z 0 [Note] InnoDB: Completed initialization of buffer pool
  88. 2017-03-18T19:19:04.228229Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  89. 2017-03-18T19:19:04.238599Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
  90. 2017-03-18T19:19:04.238764Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
  91. 2017-03-18T19:19:04.238772Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
  92. 2017-03-18T19:19:04.238778Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
  93. 2017-03-18T19:19:04.238782Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
  94. 2017-03-18T19:19:04.238786Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
  95. 2017-03-18T19:19:04.238794Z 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
  96. 2017-03-18T19:19:04.238801Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before trying to start up again.
  97. 2017-03-18T19:19:04.841967Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  98. 2017-03-18T19:19:04.841994Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  99. 2017-03-18T19:19:04.842000Z 0 [ERROR] Failed to initialize plugins.
  100. 2017-03-18T19:19:04.842002Z 0 [ERROR] Aborting
  101.  
  102. 2017-03-18T19:19:04.842007Z 0 [Note] Binlog end
  103. 2017-03-18T19:19:04.842135Z 0 [Note] Shutting down plugin 'MyISAM'
  104. 2017-03-18T19:19:04.842387Z 0 [Note] bin/mysqld: Shutdown complete
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!