· 8 years ago · Apr 22, 2018, 12:30 AM
1Aug 11 13:03:28 kutuphane mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
2Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 [Note] Plugin 'FEDERATED' is disabled.
3Aug 11 13:03:28 kutuphane mysqld: #007/usr/sbin/mysqld: Incorrect information in file: './mysql/plugin.frm'
4Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
5Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Initializing buffer pool, size = 8.0M
6Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Completed initialization of buffer pool
7Aug 11 13:03:28 kutuphane mysqld: InnoDB: The log sequence number in ibdata files does not match
8Aug 11 13:03:28 kutuphane mysqld: InnoDB: the log sequence number in the ib_logfiles!
9Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Database was not shut down normally!
10Aug 11 13:03:28 kutuphane mysqld: InnoDB: Starting crash recovery.
11Aug 11 13:03:28 kutuphane mysqld: InnoDB: Reading tablespace information from the .ibd files...
12Aug 11 13:03:28 kutuphane mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
13Aug 11 13:03:28 kutuphane mysqld: InnoDB: buffer...
14Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Error: page 5 log sequence number 0 69715
15Aug 11 13:03:28 kutuphane mysqld: InnoDB: is in the future! Current system log sequence number 0 69644.
16Aug 11 13:03:28 kutuphane mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
17Aug 11 13:03:28 kutuphane mysqld: InnoDB: tablespace but not the InnoDB log files. See
18Aug 11 13:03:28 kutuphane mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
19Aug 11 13:03:28 kutuphane mysqld: InnoDB: for more information.
20Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Started; log sequence number 0 69644
21Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
22Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm'
23Aug 11 13:03:28 kutuphane mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
24Aug 11 13:03:42 kutuphane /etc/init.d/mysql[3528]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
25Aug 11 13:03:42 kutuphane /etc/init.d/mysql[3528]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
26Aug 11 13:03:42 kutuphane /etc/init.d/mysql[3528]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
27Aug 11 13:03:42 kutuphane /etc/init.d/mysql[3528]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
28Aug 11 13:03:42 kutuphane /etc/init.d/mysql[3528]:
29
30[client]
31port = 3306
32socket = /var/run/mysqld/mysqld.sock
33
34# Here is entries for some specific programs
35# The following values assume you have at least 32M ram
36
37# This was formally known as [safe_mysqld]. Both versions are currently parsed.
38[mysqld_safe]
39socket = /var/run/mysqld/mysqld.sock
40nice = 0
41
42[mysqld]
43#
44# * Basic Settings
45#
46user = mysql
47pid-file = /var/run/mysqld/mysqld.pid
48socket = /var/run/mysqld/mysqld.sock
49port = 3306
50basedir = /usr
51datadir = /var/lib/mysql
52tmpdir = /tmp
53language = /usr/share/mysql/english
54skip-external-locking
55#
56# Instead of skip-networking the default is now to listen only on
57# localhost which is more compatible and is not less secure.
58bind-address = localhost
59#
60# * Fine Tuning
61#
62key_buffer = 16M
63max_allowed_packet = 16M
64thread_stack = 192K
65thread_cache_size = 8
66# This replaces the startup script and checks MyISAM tables if needed
67# the first time they are touched
68myisam-recover = BACKUP
69#max_connections = 1000
70#table_cache = 64
71#thread_concurrency = 10
72#
73# * Query Cache Configuration
74#
75query_cache_limit = 1M
76query_cache_size = 16M
77#
78# * Logging and Replication
79#
80# Both location gets rotated by the cronjob.
81# Be aware that this log type is a performance killer.
82# As of 5.1 you can enable the log at runtime!
83general_log_file = /var/log/mysql/mysql.log
84general_log = 1
85#
86# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
87#
88# Here you can see queries with especially long duration
89#log_slow_queries = /var/log/mysql/mysql-slow.log
90#long_query_time = 2
91#log-queries-not-using-indexes
92#
93# The following can be used as easy to replay backup logs or for replication.
94# note: if you are setting up a replication slave, see README.Debian about
95# other settings you may need to change.
96#server-id = 1
97#log_bin = /var/log/mysql/mysql-bin.log
98expire_logs_days = 10
99max_binlog_size = 100M
100#binlog_do_db = include_database_name
101#binlog_ignore_db = include_database_name
102#
103# * InnoDB
104#
105# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
106# Read the manual for more InnoDB related options. There are many!
107#
108# * Security Features
109#
110# Read the manual, too, if you want chroot!
111# chroot = /var/lib/mysql/
112#
113# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
114#
115# ssl-ca=/etc/mysql/cacert.pem
116# ssl-cert=/etc/mysql/server-cert.pem
117# ssl-key=/etc/mysql/server-key.pem
118
119
120
121[mysqldump]
122quick
123quote-names
124max_allowed_packet = 16M
125
126[mysql]
127#no-auto-rehash # faster start of mysql but no tab completition
128
129[isamchk]
130key_buffer = 16M
131
132#
133# * IMPORTANT: Additional settings that can override those from this file!
134# The files must end with '.cnf', otherwise they'll be ignored.
135#
136!includedir /etc/mysql/conf.d/
137
138Aug 22 16:47:14 kutuphane mysqld: #007/usr/sbin/mysqld: Incorrect information in file: './mysql/plugin.frm'
139Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 InnoDB: Initializing buffer pool, size = 8.0M
141Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 InnoDB: Completed initialization of buffer pool
142Aug 22 16:47:14 kutuphane mysqld: InnoDB: The log sequence number in ibdata files does not match
143Aug 22 16:47:14 kutuphane mysqld: InnoDB: the log sequence number in the ib_logfiles!
144Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 InnoDB: Database was not shut down normally!
145Aug 22 16:47:14 kutuphane mysqld: InnoDB: Starting crash recovery.
146Aug 22 16:47:14 kutuphane mysqld: InnoDB: Reading tablespace information from the .ibd files...
147Aug 22 16:47:14 kutuphane mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
148Aug 22 16:47:14 kutuphane mysqld: InnoDB: buffer...
149Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 InnoDB: Error: page 5 log sequence number 0 69715
150Aug 22 16:47:14 kutuphane mysqld: InnoDB: is in the future! Current system log sequence number 0 69644.
151Aug 22 16:47:14 kutuphane mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
152Aug 22 16:47:14 kutuphane mysqld: InnoDB: tablespace but not the InnoDB log files. See
153Aug 22 16:47:14 kutuphane mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
154Aug 22 16:47:14 kutuphane mysqld: InnoDB: for more information.
155Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 InnoDB: Started; log sequence number 0 69644
156Aug 22 16:47:14 kutuphane mysqld: InnoDB: !!! innodb_force_recovery is set to 1 !!!
157Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
158Aug 22 16:47:14 kutuphane mysqld: 160822 16:47:14 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm'
159Aug 22 16:47:14 kutuphane mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
160Aug 22 16:47:28 kutuphane /etc/init.d/mysql[24753]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
161Aug 22 16:47:28 kutuphane /etc/init.d/mysql[24753]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
162Aug 22 16:47:28 kutuphane /etc/init.d/mysql[24753]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
163Aug 22 16:47:28 kutuphane /etc/init.d/mysql[24753]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
164Aug 22 16:47:28 kutuphane /etc/init.d/mysql[24753]:
165
166Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Database was not shut down normally!
167Aug 11 13:03:28 kutuphane mysqld: InnoDB: Starting crash recovery.
168Aug 11 13:03:28 kutuphane mysqld: InnoDB: Reading tablespace information from the .ibd files...
169Aug 11 13:03:28 kutuphane mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
170Aug 11 13:03:28 kutuphane mysqld: InnoDB: buffer...
171Aug 11 13:03:28 kutuphane mysqld: 160811 13:03:28 InnoDB: Error: page 5 log sequence number 0 69715
172Aug 11 13:03:28 kutuphane mysqld: InnoDB: is in the future! Current system log sequence number 0 69644.
173Aug 11 13:03:28 kutuphane mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
174Aug 11 13:03:28 kutuphane mysqld: InnoDB: tablespace but not the InnoDB log files. See
175Aug 11 13:03:28 kutuphane mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
176
177[mysqld]
178innodb_force_recovery = 1