You are not logged in.

Pages: 1

#1 2017-10-01 11:41:16

Empty
Member
Registered: 2017-10-01
Posts: 2

Problems with the mysqld

I was installed mysql server using aur package. In the logs I have found temporary password, and made all required changes that was described here https://wiki.archlinux.org/index.php/MySQL
My /var/log/mysql/mysql.error.log

2017-09-30T16:33:40.623872Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-09-30T16:33:40.623915Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-09-30T16:33:40.624068Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-30T16:33:40.624077Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-30T16:33:40.624082Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-09-30T16:33:40.626216Z 0 [Warning] One can only use the --user switch if running as root

2017-09-30T16:33:41.378533Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-09-30T16:33:41.501339Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-09-30T16:33:41.572477Z 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: 1e897aa3-a5fd-11e7-9146-d8cb8a7a3ee2.
2017-09-30T16:33:41.577162Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-30T16:33:41.977720Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-30T16:33:42.097936Z 1 [Note] A temporary password is generated for root@localhost: ELec;aYFt5Wh
2017-09-30T16:35:37.725314Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-09-30T16:35:37.725397Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-09-30T16:35:37.885904Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-30T16:35:37.885929Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-30T16:35:37.885932Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-09-30T16:35:37.885949Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-09-30T16:35:37.885971Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 21410 ...
2017-09-30T16:35:37.889307Z 0 [Warning] One can only use the --user switch if running as root

2017-09-30T16:35:37.890873Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-09-30T16:35:37.890902Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-30T16:35:37.890908Z 0 [Note] InnoDB: Uses event mutexes
2017-09-30T16:35:37.890913Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-30T16:35:37.890918Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-09-30T16:35:37.890923Z 0 [Note] InnoDB: Using Linux native AIO
2017-09-30T16:35:37.891160Z 0 [Note] InnoDB: Number of pools: 1
2017-09-30T16:35:37.891273Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-09-30T16:35:37.892814Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-09-30T16:35:37.901646Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-09-30T16:35:37.903840Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-09-30T16:35:37.916187Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-30T16:35:37.925778Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-09-30T16:35:37.925851Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-09-30T16:35:37.996354Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-09-30T16:35:37.997774Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-09-30T16:35:37.997804Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-09-30T16:35:37.998358Z 0 [Note] InnoDB: Waiting for purge to start
2017-09-30T16:35:38.048640Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539315
2017-09-30T16:35:38.049105Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-09-30T16:35:38.053715Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170930 19:35:38
2017-09-30T16:35:38.059971Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-09-30T16:35:38.059991Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-09-30T16:35:38.060491Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-30T16:35:38.060510Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-09-30T16:35:38.060562Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-09-30T16:35:38.060572Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-09-30T16:35:38.060622Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-09-30T16:35:38.067292Z 0 [Note] Event Scheduler: Loaded 0 events
2017-09-30T16:35:38.067489Z 0 [Note] mysqld: ready for connections.
Version: '5.7.19'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2017-09-30T16:35:38.067501Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 
2017-09-30T16:35:38.067507Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-09-30T16:35:38.077752Z 0 [Note] End of list of non-natively partitioned tables
2017-09-30T16:35:39.022628Z 3 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:39.397029Z 4 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:39.896137Z 5 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:40.391518Z 6 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:40.896310Z 7 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:40.950307Z 8 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-09-30T16:35:41.396083Z 9 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
2017-09-30T16:35:41.871413Z 10 [Note] Your password has expired. To log in you must change it using a client that supports expired passwords.
2017-10-01T00:37:05.097120Z 12 [Note] Aborted connection 12 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets)
2017-10-01T03:43:46.698708Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-10-01T03:43:46.698750Z 0 [Note] Shutting down slave threads
2017-10-01T03:43:46.698762Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-10-01T03:43:46.698772Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-10-01T03:43:46.698837Z 0 [Note] Binlog end
2017-10-01T03:43:46.699407Z 0 [Note] Shutting down plugin 'validate_password'
2017-10-01T03:43:46.699420Z 0 [Note] Shutting down plugin 'ngram'
2017-10-01T03:43:46.699425Z 0 [Note] Shutting down plugin 'partition'
2017-10-01T03:43:46.699430Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-10-01T03:43:46.699436Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-10-01T03:43:46.699440Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-10-01T03:43:46.699471Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-10-01T03:43:46.699477Z 0 [Note] Shutting down plugin 'MyISAM'
2017-10-01T03:43:46.699484Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-10-01T03:43:46.699490Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-10-01T03:43:46.699495Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-10-01T03:43:46.699499Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-10-01T03:43:46.699504Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-10-01T03:43:46.699509Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-10-01T03:43:46.699519Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-10-01T03:43:46.699524Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-10-01T03:43:46.699528Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-10-01T03:43:46.699532Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-10-01T03:43:46.699535Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-10-01T03:43:46.699540Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-10-01T03:43:46.699544Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-10-01T03:43:46.699548Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-10-01T03:43:46.699552Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-10-01T03:43:46.699556Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-10-01T03:43:46.699560Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-10-01T03:43:46.699564Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-10-01T03:43:46.699568Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-10-01T03:43:46.699572Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-10-01T03:43:46.699576Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-10-01T03:43:46.699580Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-10-01T03:43:46.699584Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-10-01T03:43:46.699588Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-10-01T03:43:46.699592Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-10-01T03:43:46.699596Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-10-01T03:43:46.699600Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-10-01T03:43:46.699604Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-10-01T03:43:46.699608Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-10-01T03:43:46.699612Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-10-01T03:43:46.699616Z 0 [Note] Shutting down plugin 'InnoDB'
2017-10-01T03:43:46.700381Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-10-01T03:43:46.700786Z 0 [Note] InnoDB: Starting shutdown...
2017-10-01T03:43:46.801391Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-10-01T03:43:46.801571Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171001  6:43:46
2017-10-01T03:43:48.520573Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2539572
2017-10-01T03:43:48.526044Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-10-01T03:43:48.526070Z 0 [Note] Shutting down plugin 'MEMORY'
2017-10-01T03:43:48.526082Z 0 [Note] Shutting down plugin 'CSV'
2017-10-01T03:43:48.526093Z 0 [Note] Shutting down plugin 'sha256_password'
2017-10-01T03:43:48.526102Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-10-01T03:43:48.526480Z 0 [Note] Shutting down plugin 'binlog'
2017-10-01T03:43:48.526825Z 0 [Note] mysqld: Shutdown complete

2017-10-01T03:52:39.801951Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-10-01T03:52:39.801995Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-10-01T03:52:39.959416Z 0 [ERROR] --verbose is for use with --help; did you mean --log-error-verbosity?
2017-10-01T03:52:39.959433Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-01T03:52:39.959441Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-10-01T03:52:39.959444Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-10-01T03:52:39.959461Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-10-01T03:52:39.959483Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 4593 ...
2017-10-01T03:52:39.962341Z 0 [Warning] One can only use the --user switch if running as root

2017-10-01T03:52:39.965820Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-10-01T03:52:39.965868Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-01T03:52:39.965873Z 0 [Note] InnoDB: Uses event mutexes
2017-10-01T03:52:39.965878Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-10-01T03:52:39.965882Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-10-01T03:52:39.965887Z 0 [Note] InnoDB: Using Linux native AIO
2017-10-01T03:52:39.966707Z 0 [Note] InnoDB: Number of pools: 1
2017-10-01T03:52:39.969918Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-10-01T03:52:39.972153Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-10-01T03:52:39.982005Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-10-01T03:52:39.984978Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-10-01T03:52:40.003502Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-01T03:52:40.027170Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-10-01T03:52:40.027260Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-10-01T03:52:40.096471Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-10-01T03:52:40.098056Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-10-01T03:52:40.098084Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-10-01T03:52:40.098702Z 0 [Note] InnoDB: Waiting for purge to start
2017-10-01T03:52:40.148993Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539572
2017-10-01T03:52:40.149546Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-10-01T03:52:40.168610Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-10-01T03:52:40.168639Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-10-01T03:52:40.170218Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171001  6:52:40
2017-10-01T03:52:40.171412Z 0 [Warning] CA certificate ca.pem is self signed.
2017-10-01T03:52:40.171462Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-10-01T03:52:40.171913Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-10-01T03:52:40.171925Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-10-01T03:52:40.171957Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-10-01T03:52:40.171987Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2017-10-01T03:52:40.171991Z 0 [ERROR] Unable to setup unix socket lock file.
2017-10-01T03:52:40.171995Z 0 [ERROR] Aborting

2017-10-01T03:52:40.172005Z 0 [Note] Binlog end
2017-10-01T03:52:40.172057Z 0 [Note] Shutting down plugin 'validate_password'
2017-10-01T03:52:40.172071Z 0 [Note] Shutting down plugin 'ngram'
2017-10-01T03:52:40.172075Z 0 [Note] Shutting down plugin 'partition'
2017-10-01T03:52:40.172079Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-10-01T03:52:40.172083Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-10-01T03:52:40.172086Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-10-01T03:52:40.172153Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-10-01T03:52:40.172157Z 0 [Note] Shutting down plugin 'MyISAM'
2017-10-01T03:52:40.172527Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-10-01T03:52:40.172532Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-10-01T03:52:40.172536Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-10-01T03:52:40.172539Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-10-01T03:52:40.172542Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-10-01T03:52:40.172545Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-10-01T03:52:40.172548Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-10-01T03:52:40.172551Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-10-01T03:52:40.172562Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-10-01T03:52:40.172566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-10-01T03:52:40.172569Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-10-01T03:52:40.172572Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-10-01T03:52:40.172575Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-10-01T03:52:40.172578Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-10-01T03:52:40.172582Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-10-01T03:52:40.172585Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-10-01T03:52:40.172588Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-10-01T03:52:40.172591Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-10-01T03:52:40.172595Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-10-01T03:52:40.172598Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-10-01T03:52:40.172601Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-10-01T03:52:40.172604Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-10-01T03:52:40.172607Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-10-01T03:52:40.172610Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-10-01T03:52:40.172614Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-10-01T03:52:40.172617Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-10-01T03:52:40.172620Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-10-01T03:52:40.172623Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-10-01T03:52:40.172626Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-10-01T03:52:40.172629Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-10-01T03:52:40.172632Z 0 [Note] Shutting down plugin 'InnoDB'
2017-10-01T03:52:40.172827Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-10-01T03:52:40.172903Z 0 [Note] InnoDB: Starting shutdown...
2017-10-01T03:52:40.273336Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-10-01T03:52:40.273672Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171001  6:52:40
2017-10-01T03:52:41.785795Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2539591
2017-10-01T03:52:41.788874Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-10-01T03:52:41.788887Z 0 [Note] Shutting down plugin 'MEMORY'
2017-10-01T03:52:41.788908Z 0 [Note] Shutting down plugin 'CSV'
2017-10-01T03:52:41.788915Z 0 [Note] Shutting down plugin 'sha256_password'
2017-10-01T03:52:41.788921Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-10-01T03:52:41.789161Z 0 [Note] Shutting down plugin 'binlog'
2017-10-01T03:52:41.789246Z 0 [Note] mysqld: Shutdown complete

I think that problem is in

Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

, but can't recognize how to fix it. Which rights should be set and where?

Last edited by Empty (2017-10-01 12:18:17)

Offline

#2 2017-10-01 12:03:13

WorMzy
Administrator
From: Scotland
Registered: 2010-06-16
Posts: 13,721
Website

Re: Problems with the mysqld

Welcome to the Arch Linux forums, Empty. Please edit your post to use code tags, not quote tags, for logs/terminal output.

See https://wiki.archlinux.org/index.php/Co … s_and_code

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

Offline

#3 2017-10-01 12:25:30

Empty
Member
Registered: 2017-10-01
Posts: 2

Re: Problems with the mysqld

Done. It was helpful to my problem smile

Another info:
systemctl start mysqld is not works (from mysql user). But mysqld starts server (from local user), and it's fine.

/var/run/mysqld

drwxrwxrwx  2 mysql mysql  40 Oct  1 15:15 .
drwxr-xr-x 19 root  root  440 Oct  1 06:44 ..

/var/lib/mysql

drwxrwxrwx  5 mysql mysql     4096 Oct  1 15:21 .
drwxr-xr-x 24 root  root      4096 Oct  1 00:00 ..
-rw-r-----  1 mysql mysql       56 Oct  1 15:14 auto.cnf
-rwxrwxrwx  1 mysql mysql        6 Oct  1 15:14 brain.pid
-rwxrwxrwx  1 mysql mysql     1680 Sep 30 19:33 ca-key.pem
-rwxrwxrwx  1 mysql mysql     1075 Sep 30 19:33 ca.pem
-rwxrwxrwx  1 mysql mysql     1079 Sep 30 19:33 client-cert.pem
-rwxrwxrwx  1 mysql mysql     1676 Sep 30 19:33 client-key.pem
-rwxrwxrwx  1 mysql mysql      286 Oct  1 14:58 ib_buffer_pool
-rwxrwxrwx  1 mysql mysql 50331648 Oct  1 15:14 ib_logfile0
-rwxrwxrwx  1 mysql mysql 50331648 Sep 30 19:33 ib_logfile1
-rwxrwxrwx  1 mysql mysql 12582912 Oct  1 15:14 ibdata1
drwxrwxrwx  2 mysql mysql     4096 Sep 30 19:33 mysql
drwxrwxrwx  2 mysql mysql     4096 Sep 30 19:33 performance_schema
-rwxrwxrwx  1 mysql mysql     1680 Sep 30 19:33 private_key.pem
-rwxrwxrwx  1 mysql mysql      452 Sep 30 19:33 public_key.pem
-rwxrwxrwx  1 mysql mysql     1079 Sep 30 19:33 server-cert.pem
-rwxrwxrwx  1 mysql mysql     1680 Sep 30 19:33 server-key.pem
drwxrwxrwx  2 mysql mysql    12288 Sep 30 19:33 sys

Last edited by Empty (2017-10-01 12:26:09)

Offline

#4 2017-10-01 12:34:15

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,734
Website

Re: Problems with the mysqld

What is the output of

systemctl status mysqld

AUR packages • Zsh and other configs

Offline

Pages: 1

Board footer

Powered by FluxBB