2017-07-05T23:20:46.493568Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2017-07-05T23:20:46.514804Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-07-05T23:20:46.523123Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2017-07-05T23:20:46.523236Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2017-07-05T23:20:46.763106Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-07-05T23:20:46.768312Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18) starting as process 30813 ... 2017-07-05T23:20:46.774778Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-07-05T23:20:46.774826Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-07-05T23:20:46.774832Z 0 [Note] InnoDB: Uses event mutexes 2017-07-05T23:20:46.774837Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-07-05T23:20:46.774842Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-07-05T23:20:46.774846Z 0 [Note] InnoDB: Using Linux native AIO 2017-07-05T23:20:46.775498Z 0 [Note] InnoDB: Number of pools: 1 2017-07-05T23:20:46.775800Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-07-05T23:20:46.780235Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-07-05T23:20:46.799894Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-07-05T23:20:46.805330Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-07-05T23:20:46.825169Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-07-05T23:20:46.828894Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4533006964 2017-07-05T23:20:46.828926Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4533007261 2017-07-05T23:20:46.829265Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 4533007261 2017-07-05T23:20:46.830550Z 0 [Note] InnoDB: Database was not shutdown normally! 2017-07-05T23:20:46.830573Z 0 [Note] InnoDB: Starting crash recovery. 2017-07-05T23:20:46.869246Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 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 2017-07-05T23:20:46.872999Z 0 [Note] InnoDB: Apply batch completed 2017-07-05T23:20:47.013933Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-07-05T23:20:47.013975Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-07-05T23:20:47.014048Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-07-05T23:20:47.075860Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-07-05T23:20:47.079877Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-07-05T23:20:47.079905Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-07-05T23:20:47.080419Z 0 [Note] InnoDB: Waiting for purge to start 2017-07-05T23:20:47.130789Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 4533007261 2017-07-05T23:20:47.131562Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-07-05T23:20:47.132875Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-07-05T23:20:47.163142Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170705 23:20:47 2017-07-05T23:20:47.164548Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2017-07-05T23:20:47.165474Z 0 [Warning] CA certificate ca.pem is self signed. 2017-07-05T23:20:47.171138Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-07-05T23:20:47.171387Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-07-05T23:20:47.171454Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2017-07-05T23:20:47.211945Z 0 [Note] Event Scheduler: Loaded 0 events 2017-07-05T23:20:47.212272Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.18' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2017-07-05T23:20:47.212303Z 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-07-05T23:20:47.212309Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-07-05T23:20:47.288980Z 0 [Note] End of list of non-natively partitioned tables Killed 2017-07-05T23:22:04.090207Z mysqld_safe Number of processes running now: 0 2017-07-05T23:22:04.105256Z mysqld_safe mysqld restarted 2017-07-05T23:22:04.158523Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2017-07-05T23:22:04.158657Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2017-07-05T23:22:04.712037Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-07-05T23:22:04.731812Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18) starting as process 31192 ... 2017-07-05T23:22:04.771935Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-07-05T23:22:04.772031Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-07-05T23:22:04.772040Z 0 [Note] InnoDB: Uses event mutexes 2017-07-05T23:22:04.772046Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-07-05T23:22:04.772051Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-07-05T23:22:04.772056Z 0 [Note] InnoDB: Using Linux native AIO 2017-07-05T23:22:04.773305Z 0 [Note] InnoDB: Number of pools: 1 2017-07-05T23:22:04.775499Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-07-05T23:22:04.787061Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-07-05T23:22:04.795639Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12 2017-07-05T23:22:04.795683Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2017-07-05T23:22:04.795698Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2017-07-05T23:22:04.795715Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2017-07-05T23:22:04.795722Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-07-05T23:22:04.795731Z 0 [ERROR] Failed to initialize plugins. 2017-07-05T23:22:04.795740Z 0 [ERROR] Aborting 2017-07-05T23:22:04.795757Z 0 [Note] Binlog end 2017-07-05T23:22:04.797699Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2017-07-05T23:22:04.845097Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid endedbu hatayı alıyorum mysql log da ve mysql duruyor sorun ne arkadaşlar?
Hata ne?
1
●337
- 06-07-2017, 02:25:42Üyeliği durduruldu
- 08-07-2017, 16:51:54Ram yetersiz gibi duruyor. mmap fonksiyonu ram'de yer ayırmak için kullanılır. Altında ise Cannot allocate memory diyor.
Sent from my iPhone using Tapatalk Pro