API tools faq
paste
Advertisement
stdcerr

Untitled

stdcerr
Oct 19th, 2019
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.70 KB | None | 0 0
raw download clone embed print report
  1. after reboot
  2. $ sudo systemctl start mysqld
  3. [sudo] password for alarm:
  4. Job for mariadb.service failed because the control process exited with error code.
  5. See "systemctl status mariadb.service" and "journalctl -xe" for details.
  6. [alarm@raspi ~]$ sudo systemctl status mariadb.service
  7. * mariadb.service - MariaDB 10.4.8 database server
  8. Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  9. Active: failed (Result: exit-code) since Sat 2019-10-19 20:43:35 UTC; 51s ago
  10. Docs: man:mysqld(8)
  11. https://mariadb.com/kb/en/library/systemd/
  12. Process: 295 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  13. Process: 296 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environ>
  14. Process: 304 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  15. Main PID: 304 (code=exited, status=1/FAILURE)
  16. Status: "MariaDB server is down"
  17.  
  18. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  19. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Buffer pool(s) load completed at 191019 20:43:33
  20. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
  21. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
  22. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] Server socket created on IP: '::'.
  23. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
  24. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Aborting
  25. Oct 19 20:43:35 raspi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
  26. Oct 19 20:43:35 raspi systemd[1]: mariadb.service: Failed with result 'exit-code'.
  27. Oct 19 20:43:35 raspi systemd[1]: Failed to start MariaDB 10.4.8 database server.
  28.  
  29.  
  30.  
  31. $ sudo journalctl -xe
  32. Oct 19 20:43:19 raspi audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=systemd-rfkill comm="systemd" exe="/usr/lib/systemd/systemd>
  33. Oct 19 20:43:20 raspi kernel: audit: type=1131 audit(1571517799.984:27): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=systemd-rfkill comm="systemd" e>
  34. Oct 19 20:43:31 raspi sudo[292]: alarm : TTY=pts/0 ; PWD=/home/alarm ; USER=root ; COMMAND=/usr/bin/systemctl start mysqld
  35. Oct 19 20:43:31 raspi sudo[292]: pam_unix(sudo:session): session opened for user root by alarm(uid=0)
  36. Oct 19 20:43:31 raspi systemd[1]: Starting MariaDB 10.4.8 database server...
  37. -- Subject: A start job for unit mariadb.service has begun execution
  38. -- Defined-By: systemd
  39. -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  40. --
  41. -- A start job for unit mariadb.service has begun execution.
  42. --
  43. -- The job identifier is 304.
  44. Oct 19 20:43:32 raspi mysqld[304]: 2019-10-19 20:43:32 0 [Note] /usr/bin/mysqld (mysqld 10.4.8-MariaDB) starting as process 304 ...
  45. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Using Linux native AIO
  46. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  47. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Uses event mutexes
  48. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  49. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Number of pools: 1
  50. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Using generic crc32 instructions
  51. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
  52. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  53. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Completed initialization of buffer pool
  54. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be chang>
  55. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
  56. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  57. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait >
  58. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  59. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Waiting for purge to start
  60. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: 10.4.8 started; log sequence number 113847; transaction id 9
  61. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  62. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] InnoDB: Buffer pool(s) load completed at 191019 20:43:33
  63. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
  64. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
  65. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [Note] Server socket created on IP: '::'.
  66. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
  67. Oct 19 20:43:33 raspi mysqld[304]: 2019-10-19 20:43:33 0 [ERROR] Aborting
  68. Oct 19 20:43:35 raspi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
  69. -- Subject: Unit process exited
  70. -- Defined-By: systemd
  71. -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  72. --
  73. -- An ExecStart= process belonging to unit mariadb.service has exited.
  74. --
  75. -- The process' exit code is 'exited' and its exit status is 1.
  76. Oct 19 20:43:35 raspi systemd[1]: mariadb.service: Failed with result 'exit-code'.
  77. -- Subject: Unit failed
  78. -- Defined-By: systemd
  79. -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  80. --
  81. -- The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
  82. Oct 19 20:43:35 raspi systemd[1]: Failed to start MariaDB 10.4.8 database server.
  83. -- Subject: A start job for unit mariadb.service has failed
  84. -- Defined-By: systemd
  85. -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  86. --
  87. -- A start job for unit mariadb.service has finished with a failure.
  88. --
  89. -- The job identifier is 304 and the job result is failed.
  90. Oct 19 20:43:35 raspi audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" host>
  91. Oct 19 20:43:35 raspi kernel: audit: type=1130 audit(1571517815.594:28): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/us>
  92. Oct 19 20:43:35 raspi sudo[292]: pam_unix(sudo:session): session closed for user root
  93. Oct 19 20:43:44 raspi systemd[1]: systemd-hostnamed.service: Succeeded.
  94. -- Subject: Unit succeeded
  95. -- Defined-By: systemd
  96. -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  97. --
  98. -- The unit systemd-hostnamed.service has successfully entered the 'dead' state.
  99. Oct 19 20:43:44 raspi audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=systemd-hostnamed comm="systemd" exe="/usr/lib/systemd/syst>
  100. Oct 19 20:43:44 raspi kernel: audit: type=1131 audit(1571517824.374:29): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=systemd-hostnamed comm="systemd>
  101. Oct 19 20:43:49 raspi systemd-resolved[265]: /etc/hosts:4: address 'localhost' is invalid, ignoring: Invalid argument
  102. Oct 19 20:44:09 raspi systemd-timesyncd[266]: Synchronized to time server for the first time 192.99.2.8:123 (2.arch.pool.ntp.org).
  103. Oct 19 20:44:27 raspi sudo[338]: alarm : TTY=pts/0 ; PWD=/home/alarm ; USER=root ; COMMAND=/usr/bin/systemctl status mariadb.service
  104. Oct 19 20:44:27 raspi sudo[338]: pam_unix(sudo:session): session opened for user root by alarm(uid=0)
  105. Oct 19 20:45:38 raspi sudo[338]: pam_unix(sudo:session): session closed for user root
  106. Oct 19 20:45:54 raspi sudo[341]: alarm : TTY=pts/0 ; PWD=/home/alarm ; USER=root ; COMMAND=/usr/bin/journalctl -xe
  107. Oct 19 20:45:54 raspi sudo[341]: pam_unix(sudo:session): session opened for user root by alarm(uid=0)
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!