Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't connect to local MySQL server through socket '/tmp/sockets/mysql.sock' #733

Closed
gyh1621 opened this issue Sep 28, 2018 · 1 comment
Closed

Can't connect to local MySQL server through socket '/tmp/sockets/mysql.sock' #733

gyh1621 opened this issue Sep 28, 2018 · 1 comment

Comments

@gyh1621
Copy link

gyh1621 commented Sep 28, 2018

ubuntu 16.04

Apache

Status

● snap.nextcloud.apache.service - Service for snap application nextcloud.apache
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.apache.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
  Process: 14919 ExecStop=/usr/bin/snap run --command=stop nextcloud.apache (code=exited, status=0/SUCCESS)
 Main PID: 15230 (run-httpd)
    Tasks: 3
   Memory: 2.3M
      CPU: 286ms
   CGroup: /system.slice/snap.nextcloud.apache.service
           ├─15230 /bin/sh /snap/nextcloud/8971/bin/run-httpd -k start -DFOREGROUND
           ├─15279 /bin/sh /snap/nextcloud/8971/bin/setup_nextcloud
           └─17456 sleep 1

9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.apache.
9月 28 14:21:55 msi nextcloud.apache[15230]: Making sure nextcloud is setup...

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.apache.
9月 28 14:13:09 msi nextcloud.apache[6590]: Making sure nextcloud is setup...
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.apache...
9月 28 14:14:00 msi nextcloud.apache[8225]: No certificates are active: using HTTP only
9月 28 14:14:00 msi nextcloud.apache[8225]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
9月 28 14:14:00 msi nextcloud.apache[8225]: httpd (no pid file) not running
9月 28 14:14:00 msi nextcloud.apache[6590]: Waiting for PHP...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.apache.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.apache.
9月 28 14:14:01 msi nextcloud.apache[8705]: Making sure nextcloud is setup...
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.apache...
9月 28 14:14:32 msi nextcloud.apache[9723]: No certificates are active: using HTTP only
9月 28 14:14:32 msi nextcloud.apache[9723]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
9月 28 14:14:32 msi nextcloud.apache[9723]: httpd (no pid file) not running
9月 28 14:14:32 msi nextcloud.apache[8705]: Waiting for PHP...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.apache.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.apache.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.apache.
9月 28 14:16:35 msi nextcloud.apache[10853]: Making sure nextcloud is setup...
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.apache...
9月 28 14:21:55 msi nextcloud.apache[14919]: No certificates are active: using HTTP only
9月 28 14:21:55 msi nextcloud.apache[14919]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
9月 28 14:21:55 msi nextcloud.apache[14919]: httpd (no pid file) not running
9月 28 14:21:55 msi nextcloud.apache[10853]: Waiting for PHP...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.apache.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.apache.
9月 28 14:21:55 msi nextcloud.apache[15230]: Making sure nextcloud is setup...

PHP

Status

● snap.nextcloud.php-fpm.service - Service for snap application nextcloud.php-fpm
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.php-fpm.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
 Main PID: 14947 (start-php-fpm)
    Tasks: 2
   Memory: 2.5M
      CPU: 307ms
   CGroup: /system.slice/snap.nextcloud.php-fpm.service
           ├─14947 /bin/sh /snap/nextcloud/8971/bin/start-php-fpm
           └─17454 sleep 1

9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.php-fpm.

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.php-fpm.
9月 28 14:13:11 msi nextcloud.php-fpm[6567]: Waiting for configure hook... done
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.php-fpm...
9月 28 14:14:00 msi nextcloud.php-fpm[6567]: Waiting for MySQL...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.php-fpm.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.php-fpm.
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.php-fpm...
9月 28 14:14:32 msi nextcloud.php-fpm[8260]: Waiting for MySQL...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.php-fpm.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.php-fpm.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.php-fpm.
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.php-fpm...
9月 28 14:21:55 msi nextcloud.php-fpm[10879]: Waiting for MySQL...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.php-fpm.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.php-fpm.

MySQL

Status

● snap.nextcloud.mysql.service - Service for snap application nextcloud.mysql
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
  Process: 14924 ExecStop=/usr/bin/snap run --command=stop nextcloud.mysql (code=exited, status=0/SUCCESS)
 Main PID: 15088 (start_mysql)
    Tasks: 2
   Memory: 4.9M
      CPU: 1.541s
   CGroup: /system.slice/snap.nextcloud.mysql.service
           ├─15088 /bin/sh /snap/nextcloud/8971/bin/start_mysql
           └─17455 sleep 1

9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.147176Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180928 14:21:59
9月 28 14:22:00 msi nextcloud.mysql[15088]: 2018-09-28T06:22:00.586239Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1316708
9月 28 14:22:00 msi nextcloud.mysql[15088]: 2018-09-28T06:22:00.586315Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
9月 28 14:22:00 msi nextcloud.mysql[15088]: Starting MySQL
9月 28 14:22:01 msi nextcloud.mysql[15088]: . * The server quit without updating PID file (/tmp/pids/mysql.pid).
9月 28 14:22:01 msi nextcloud.mysql[15088]: Generating root mysql password... done
9月 28 14:22:01 msi nextcloud.mysql[15088]: Generating nextcloud mysql password... done
9月 28 14:22:01 msi nextcloud.mysql[15088]: Setting up users and nextcloud database... ERROR 2002 (HY000): Can't connect to loc...ck' (2)
9月 28 14:22:01 msi nextcloud.mysql[15088]: Failed to initialize-- reverting...
9月 28 14:22:01 msi nextcloud.mysql[15088]:  * MySQL server PID file could not be found!
Hint: Some lines were ellipsized, use -l to show in full.

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:16:35 msi nextcloud.mysql[10863]: 2018-09-28T06:16:35.783566Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0d65b31c-c2e6-11e8-a96d-e4f89c8fa886.
9月 28 14:16:35 msi nextcloud.mysql[10863]: 2018-09-28T06:16:35.791555Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
9月 28 14:16:35 msi nextcloud.mysql[10863]: 2018-09-28T06:16:35.802308Z 1 [Note] Creating the system database
9月 28 14:16:35 msi nextcloud.mysql[10863]: 2018-09-28T06:16:35.802323Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
9月 28 14:16:35 msi nextcloud.mysql[10863]: 2018-09-28T06:16:35.805398Z 1 [Note] Creating the system tables
9月 28 14:16:37 msi nextcloud.mysql[10863]: 2018-09-28T06:16:37.531367Z 1 [Note] Filling in the system tables, part 1
9月 28 14:16:37 msi nextcloud.mysql[10863]: 2018-09-28T06:16:37.533039Z 1 [Note] Filling in the system tables, part 2
9月 28 14:16:37 msi nextcloud.mysql[10863]: 2018-09-28T06:16:37.533050Z 1 [Note] Filling in the mysql.help table
9月 28 14:16:37 msi nextcloud.mysql[10863]: 2018-09-28T06:16:37.533053Z 1 [Note] Creating user for internal session service
9月 28 14:16:37 msi nextcloud.mysql[10863]: 2018-09-28T06:16:37.533310Z 1 [Note] Creating the sys schema
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.486229Z 1 [Note] Bootstrapping complete
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.486462Z 0 [Note] Giving 0 client threads a chance to die gracefully
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.486483Z 0 [Note] Shutting down slave threads
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.486491Z 0 [Note] Forcefully disconnecting 0 remaining clients
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.486574Z 0 [Note] Binlog end
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.491281Z 0 [Note] InnoDB: FTS optimize thread exiting.
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.491386Z 0 [Note] InnoDB: Starting shutdown...
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.591611Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/snap/nextcloud/8971/mysql/ib_buffer_pool
9月 28 14:16:38 msi nextcloud.mysql[10863]: 2018-09-28T06:16:38.591869Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180928 14:16:38
9月 28 14:16:39 msi nextcloud.mysql[10863]: 2018-09-28T06:16:39.933215Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1316708
9月 28 14:16:39 msi nextcloud.mysql[10863]: 2018-09-28T06:16:39.933304Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
9月 28 14:16:39 msi nextcloud.mysql[10863]: Starting MySQL
9月 28 14:16:40 msi nextcloud.mysql[10863]: . * The server quit without updating PID file (/tmp/pids/mysql.pid).
9月 28 14:16:41 msi nextcloud.mysql[10863]: Generating root mysql password... done
9月 28 14:16:41 msi nextcloud.mysql[10863]: Generating nextcloud mysql password... done
9月 28 14:16:41 msi nextcloud.mysql[10863]: Setting up users and nextcloud database... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/sockets/mysql.sock' (2)
9月 28 14:16:41 msi nextcloud.mysql[10863]: Failed to initialize-- reverting...
9月 28 14:16:41 msi nextcloud.mysql[10863]:  * MySQL server PID file could not be found!
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.mysql...
9月 28 14:21:55 msi nextcloud.mysql[14924]:  * MySQL server PID file could not be found!
9月 28 14:21:55 msi nextcloud.mysql[10863]: Waiting for MySQL...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.mysql.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.mysql.
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.645929Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.645995Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.646031Z 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap.
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.646054Z 0 [Note] mysqld (mysqld 5.7.22-log) starting as process 15210 ...
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.646850Z 0 [Note] --initialize specifed on an existing data directory.
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657586Z 0 [Note] InnoDB: PUNCH HOLE support available
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657722Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657736Z 0 [Note] InnoDB: Uses event mutexes
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657745Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657749Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.657754Z 0 [Note] InnoDB: Using Linux native AIO
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.658916Z 0 [Note] InnoDB: Number of pools: 1
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.659081Z 0 [Note] InnoDB: Using CPU crc32 instructions
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.666552Z 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.679007Z 0 [Note] InnoDB: Completed initialization of buffer pool
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.691609Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.691844Z 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.737320Z 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.737642Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
9月 28 14:21:55 msi nextcloud.mysql[15088]: 2018-09-28T06:21:55.937598Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.164873Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.164968Z 0 [Warning] InnoDB: New log files created, LSN=45790
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.164982Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.165027Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.212612Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.212783Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.246437Z 0 [Note] InnoDB: Doublewrite buffer created
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.256983Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.257003Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.257364Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.268155Z 0 [Note] InnoDB: Foreign key constraint system tables created
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.268202Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.274423Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.274473Z 0 [Note] InnoDB: Creating sys_virtual system tables.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.282503Z 0 [Note] InnoDB: sys_virtual table created
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.282783Z 0 [Note] InnoDB: Waiting for purge to start
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.332900Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 0
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.354588Z 0 [Note] Salting uuid generator variables, current_pid: 15210, server_start_time: 1538115715, bytes_sent: 0,
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.354636Z 0 [Note] Generated uuid: 'cc78f6f0-c2e6-11e8-b3b9-e4f89c8fa886', server_start_time: 4281234397307208685, bytes_sent: 64606992
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.354647Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cc78f6f0-c2e6-11e8-b3b9-e4f89c8fa886.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.362921Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.371247Z 1 [Note] Creating the system database
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.371260Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
9月 28 14:21:56 msi nextcloud.mysql[15088]: 2018-09-28T06:21:56.371388Z 1 [Note] Creating the system tables
9月 28 14:21:58 msi nextcloud.mysql[15088]: 2018-09-28T06:21:58.105901Z 1 [Note] Filling in the system tables, part 1
9月 28 14:21:58 msi nextcloud.mysql[15088]: 2018-09-28T06:21:58.108240Z 1 [Note] Filling in the system tables, part 2
9月 28 14:21:58 msi nextcloud.mysql[15088]: 2018-09-28T06:21:58.108272Z 1 [Note] Filling in the mysql.help table
9月 28 14:21:58 msi nextcloud.mysql[15088]: 2018-09-28T06:21:58.108280Z 1 [Note] Creating user for internal session service
9月 28 14:21:58 msi nextcloud.mysql[15088]: 2018-09-28T06:21:58.108863Z 1 [Note] Creating the sys schema
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.043990Z 1 [Note] Bootstrapping complete
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.044228Z 0 [Note] Giving 0 client threads a chance to die gracefully
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.044247Z 0 [Note] Shutting down slave threads
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.044255Z 0 [Note] Forcefully disconnecting 0 remaining clients
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.044331Z 0 [Note] Binlog end
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.046606Z 0 [Note] InnoDB: FTS optimize thread exiting.
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.046679Z 0 [Note] InnoDB: Starting shutdown...
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.146900Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/snap/nextcloud/8971/mysql/ib_buffer_pool
9月 28 14:21:59 msi nextcloud.mysql[15088]: 2018-09-28T06:21:59.147176Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180928 14:21:59
9月 28 14:22:00 msi nextcloud.mysql[15088]: 2018-09-28T06:22:00.586239Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1316708
9月 28 14:22:00 msi nextcloud.mysql[15088]: 2018-09-28T06:22:00.586315Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
9月 28 14:22:00 msi nextcloud.mysql[15088]: Starting MySQL
9月 28 14:22:01 msi nextcloud.mysql[15088]: . * The server quit without updating PID file (/tmp/pids/mysql.pid).
9月 28 14:22:01 msi nextcloud.mysql[15088]: Generating root mysql password... done
9月 28 14:22:01 msi nextcloud.mysql[15088]: Generating nextcloud mysql password... done
9月 28 14:22:01 msi nextcloud.mysql[15088]: Setting up users and nextcloud database... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/sockets/mysql.sock' (2)
9月 28 14:22:01 msi nextcloud.mysql[15088]: Failed to initialize-- reverting...
9月 28 14:22:01 msi nextcloud.mysql[15088]:  * MySQL server PID file could not be found!

Redis

Status

● snap.nextcloud.redis-server.service - Service for snap application nextcloud.redis-server
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.redis-server.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
 Main PID: 15140 (start-redis-ser)
    Tasks: 5
   Memory: 2.8M
      CPU: 169ms
   CGroup: /system.slice/snap.nextcloud.redis-server.service
           ├─15140 /bin/sh /snap/nextcloud/8971/bin/start-redis-server
           └─15228 redis-server 127.0.0.1:0

9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.redis-server.

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.redis-server.
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.redis-server...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.redis-server.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.redis-server.
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.redis-server...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.redis-server.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.redis-server.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.redis-server.
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.redis-server...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.redis-server.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.redis-server.

mDNS Publisher

Status

● snap.nextcloud.mdns-publisher.service - Service for snap application nextcloud.mdns-publisher
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.mdns-publisher.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
 Main PID: 14925 (delay-on-failur)
    Tasks: 7
   Memory: 2.2M
      CPU: 48ms
   CGroup: /system.slice/snap.nextcloud.mdns-publisher.service
           ├─14925 /bin/sh /snap/nextcloud/8971/bin/delay-on-failure mdns-publisher nextcloud
           └─15042 mdns-publisher nextcloud

9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.mdns-publisher.
9月 28 14:21:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:21:55 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:21:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:21:55 Publishing msi.local -> [192.168.99.116 fe80::27ac:3c23...nd TTL
9月 28 14:22:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:22:55 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:23:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:23:55 WARNING: interface "enp4s0" has no IP addresses
Hint: Some lines were ellipsized, use -l to show in full.

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.mdns-publisher.
9月 28 14:13:10 msi nextcloud.mdns-publisher[6543]: 2018/09/28 14:13:10 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:13:10 msi nextcloud.mdns-publisher[6543]: 2018/09/28 14:13:10 Publishing msi.local -> [192.168.99.116 fe80::27ac:3c23:b56:68a] with 60-second TTL
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.mdns-publisher...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.mdns-publisher.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.mdns-publisher.
9月 28 14:14:00 msi nextcloud.mdns-publisher[8230]: 2018/09/28 14:14:00 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:14:00 msi nextcloud.mdns-publisher[8230]: 2018/09/28 14:14:00 Publishing msi.local -> [192.168.99.116 fe80::27ac:3c23:b56:68a] with 60-second TTL
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.mdns-publisher...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.mdns-publisher.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.mdns-publisher.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.mdns-publisher.
9月 28 14:16:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:16:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:16:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:16:35 Publishing msi.local -> [192.168.99.116 fe80::27ac:3c23:b56:68a] with 60-second TTL
9月 28 14:17:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:17:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:18:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:18:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:19:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:19:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:20:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:20:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:21:35 msi nextcloud.mdns-publisher[10859]: 2018/09/28 14:21:35 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.mdns-publisher...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.mdns-publisher.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.mdns-publisher.
9月 28 14:21:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:21:55 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:21:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:21:55 Publishing msi.local -> [192.168.99.116 fe80::27ac:3c23:b56:68a] with 60-second TTL
9月 28 14:22:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:22:55 WARNING: interface "enp4s0" has no IP addresses
9月 28 14:23:55 msi nextcloud.mdns-publisher[14925]: 2018/09/28 14:23:55 WARNING: interface "enp4s0" has no IP addresses

Certificate Renewer

Status

● snap.nextcloud.renew-certs.service - Service for snap application nextcloud.renew-certs
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.renew-certs.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
 Main PID: 14967 (renew-certs)
    Tasks: 2
   Memory: 1.7M
      CPU: 897ms
   CGroup: /system.slice/snap.nextcloud.renew-certs.service
           ├─14967 /bin/sh /snap/nextcloud/8971/bin/renew-certs
           └─15382 sleep 1d

9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.renew-certs.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.renew-certs.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: Saving debug log to /var/snap/nextcloud/current/certs/certbot/logs/letsencrypt.log
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: No renewals were attempted.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: No hooks were run.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.renew-certs.
9月 28 14:13:11 msi nextcloud.renew-certs[6594]: Saving debug log to /var/snap/nextcloud/current/certs/certbot/logs/letsencrypt.log
9月 28 14:13:11 msi nextcloud.renew-certs[6594]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:13:11 msi nextcloud.renew-certs[6594]: No renewals were attempted.
9月 28 14:13:11 msi nextcloud.renew-certs[6594]: No hooks were run.
9月 28 14:13:11 msi nextcloud.renew-certs[6594]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.renew-certs...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.renew-certs.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.renew-certs.
9月 28 14:14:01 msi nextcloud.renew-certs[8279]: Saving debug log to /var/snap/nextcloud/current/certs/certbot/logs/letsencrypt.log
9月 28 14:14:01 msi nextcloud.renew-certs[8279]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:14:01 msi nextcloud.renew-certs[8279]: No renewals were attempted.
9月 28 14:14:01 msi nextcloud.renew-certs[8279]: No hooks were run.
9月 28 14:14:01 msi nextcloud.renew-certs[8279]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.renew-certs...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.renew-certs.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.renew-certs.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.renew-certs.
9月 28 14:16:35 msi nextcloud.renew-certs[10889]: Saving debug log to /var/snap/nextcloud/current/certs/certbot/logs/letsencrypt.log
9月 28 14:16:35 msi nextcloud.renew-certs[10889]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:16:35 msi nextcloud.renew-certs[10889]: No renewals were attempted.
9月 28 14:16:35 msi nextcloud.renew-certs[10889]: No hooks were run.
9月 28 14:16:35 msi nextcloud.renew-certs[10889]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.renew-certs...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.renew-certs.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.renew-certs.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: Saving debug log to /var/snap/nextcloud/current/certs/certbot/logs/letsencrypt.log
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: No renewals were attempted.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: No hooks were run.
9月 28 14:21:56 msi nextcloud.renew-certs[14967]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Nextcloud Cron

Status

● snap.nextcloud.nextcloud-cron.service - Service for snap application nextcloud.nextcloud-cron
   Loaded: loaded (/etc/systemd/system/snap.nextcloud.nextcloud-cron.service; enabled; vendor preset: enabled)
   Active: active (running) since 五 2018-09-28 14:21:55 CST; 2min 14s ago
 Main PID: 14939 (nextcloud-cron)
    Tasks: 2
   Memory: 1.6M
      CPU: 275ms
   CGroup: /system.slice/snap.nextcloud.nextcloud-cron.service
           ├─14939 /bin/sh /snap/nextcloud/8971/bin/nextcloud-cron
           └─17453 sleep 1

9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.nextcloud-cron.

Journal

-- Logs begin at 五 2018-09-28 14:10:07 CST, end at 五 2018-09-28 14:24:10 CST. --
9月 28 14:13:09 msi systemd[1]: Started Service for snap application nextcloud.nextcloud-cron.
9月 28 14:14:00 msi systemd[1]: Stopping Service for snap application nextcloud.nextcloud-cron...
9月 28 14:14:00 msi nextcloud.nextcloud-cron[6600]: Waiting for Nextcloud config dir...
9月 28 14:14:00 msi systemd[1]: Stopped Service for snap application nextcloud.nextcloud-cron.
9月 28 14:14:00 msi systemd[1]: Started Service for snap application nextcloud.nextcloud-cron.
9月 28 14:14:32 msi systemd[1]: Stopping Service for snap application nextcloud.nextcloud-cron...
9月 28 14:14:32 msi nextcloud.nextcloud-cron[8247]: Waiting for Nextcloud config dir...
9月 28 14:14:32 msi systemd[1]: Stopped Service for snap application nextcloud.nextcloud-cron.
9月 28 14:16:35 msi systemd[1]: Stopped Service for snap application nextcloud.nextcloud-cron.
9月 28 14:16:35 msi systemd[1]: Started Service for snap application nextcloud.nextcloud-cron.
9月 28 14:21:55 msi systemd[1]: Stopping Service for snap application nextcloud.nextcloud-cron...
9月 28 14:21:55 msi nextcloud.nextcloud-cron[10874]: Waiting for Nextcloud config dir...
9月 28 14:21:55 msi systemd[1]: Stopped Service for snap application nextcloud.nextcloud-cron.
9月 28 14:21:55 msi systemd[1]: Started Service for snap application nextcloud.nextcloud-cron.

@gyh1621
Copy link
Author

gyh1621 commented Sep 28, 2018

After looking into the logs, I thought maybe the mysql installed on the system got broken. So I removed mysql on my system and reinstall nextcloud, nothing goes wrong anymore.

@gyh1621 gyh1621 closed this as completed Sep 28, 2018
@cestpasphoto cestpasphoto mentioned this issue Mar 11, 2019
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@gyh1621