Здравствуйте.
У меня есть проблема падает сервер mariadb
Вот лог:
190115 14:
10:
45 mysqld_safe mysqld
from pid file /var/run/mariadb/mariadb.pid ended
190115 14:
11:
12 mysqld_safe
Starting mysqld daemon
with databases from /var/lib/mysql
190115 14:
11:
12 [Note
] /usr/libexec/mysqld
(mysqld
5.5.60-MariaDB
) starting as process
2467 ...
190115 14:
11:
12 InnoDB: The
InnoDB memory heap
is disabled
190115 14:
11:
12 InnoDB: Mutexes
and rw_locks
use GCC atomic builtins
190115 14:
11:
12 InnoDB: Compressed tables
use zlib
1.2.7
190115 14:
11:
12 InnoDB:
Using Linux native AIO
190115 14:
11:
12 InnoDB: Initializing buffer pool, size =
340.0M
190115 14:
11:
12 InnoDB: Completed initialization of buffer pool
190115 14:
11:
12 InnoDB: highest supported file
format is Barracuda.
190115 14:
11:
12 InnoDB: Waiting for the background threads
to start
190115 14:
11:
13 Percona XtraDB
(<a href=
"http://www.percona.com">http://www.percona.com</a>
) 5.5.59-MariaDB
-38.11 started;
log sequence number
2211812043
190115 14:
11:
13 [Note
] Plugin
'FEEDBACK' is disabled.
190115 14:
11:
13 [Note
] Server socket created
on IP:
'127.0.0.1'.
190115 14:
11:
13 [Note
] Event Scheduler: Loaded
0 events
190115 14:
11:
13 [Note
] /usr/libexec/mysqld: ready for connections.
Version:
'5.5.60-MariaDB' socket:
'/var/lib/mysql/mysql.sock' port:
3306 MariaDB Server
190115 14:
44:
35 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 14:44:35 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 14:
45:
00 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 14:45:00 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 14:
49:
52 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 14:49:52 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 14:
51:
17 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 14:51:17 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 14:
51:
52 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 14:51:52 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 15:
03:
14 [ERROR
] Cannot find
or open
table ecopolza_db/tovar_product_price_1c_
from
the internal
data dictionary of
InnoDB though the .frm file for the
table exists. Maybe you have deleted
and recreated
InnoDB data
files but have forgotten
to delete the corresponding .frm files
of
InnoDB tables,
or you have moved .frm files
to another database?
or, the
table contains indexes that this version of the
engine
doesn
't support.
See <a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/5.5/en/ … oting.html</a>
how you can resolve the problem.
InnoDB: Error: trying to load index GEN_CLUST_INDEX for table ecopolza_db/tovar_product_price_1c_vrem_xml
InnoDB: but the index tree has been freed!
190115 15:03:14 [ERROR] Cannot find or open table ecopolza_db/tovar_product_price_1c_vrem_xml from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html">http://dev.mysql.com/doc/refman/
5.5/en/ … oting.html</a>
how you can resolve the problem.
190115 15:
15:
04 mysqld_safe Number of processes running
now:
0
190115 15:
15:
04 mysqld_safe mysqld restarted
190115 15:
15:
04 [Note
] /usr/libexec/mysqld
(mysqld
5.5.60-MariaDB
) starting as process
4215 ...
190115 15:
15:
04 InnoDB: The
InnoDB memory heap
is disabled
190115 15:
15:
04 InnoDB: Mutexes
and rw_locks
use GCC atomic builtins
190115 15:
15:
04 InnoDB: Compressed tables
use zlib
1.2.7
190115 15:
15:
04 InnoDB:
Using Linux native AIO
190115 15:
15:
04 InnoDB: Initializing buffer pool, size =
340.0M
190115 15:
15:
04 InnoDB: Completed initialization of buffer pool
190115 15:
15:
04 InnoDB: highest supported file
format is Barracuda.
190115 15:
15:
04 InnoDB:
Starting crash recovery
from checkpoint LSN=
2219946969
InnoDB: Restoring possible half-written
data pages
from the doublewrite buffer...
190115 15:
15:
04 InnoDB:
Starting final batch
to recover
5 pages
from redo
log
190115 15:
15:
05 InnoDB: Error:
table 'ecopolza_db/tovar_product_price_1c_vrem_xml'
InnoDB:
in InnoDB data dictionary has tablespace id
1256,
InnoDB: but a tablespace
with that id does
not exist. There
is
InnoDB: a tablespace of name ./ecopolza_db/tovar_product_price_1c_vrem_xml.ibd
and id
1258, though. Have
InnoDB: you deleted
or moved .ibd files?
InnoDB: Please refer
to
InnoDB: <a href=
"http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html">http://dev.mysql.com/doc/refman/
5.5/en/ … adict.html</a>
InnoDB: for how
to resolve the issue.
190115 15:
15:
05 InnoDB: Waiting for the background threads
to start
190115 15:
15:
06 Percona XtraDB
(<a href=
"http://www.percona.com">http://www.percona.com</a>
) 5.5.59-MariaDB
-38.11 started;
log sequence number
2219947361
190115 15:
15:
06 [Note
] Plugin
'FEEDBACK' is disabled.
190115 15:
15:
06 [Note
] Server socket created
on IP:
'127.0.0.1'.
190115 15:
15:
06 [Note
] Event Scheduler: Loaded
0 events
190115 15:
15:
06 [Note
] /usr/libexec/mysqld: ready for connections.
Version:
'5.5.60-MariaDB' socket:
'/var/lib/mysql/mysql.sock' port:
3306 MariaDB Server
190115 16:
00:
03 mysqld_safe Number of processes running
now:
0
190115 16:
00:
03 mysqld_safe mysqld restarted
190115 16:
00:
03 [Note
] /usr/libexec/mysqld
(mysqld
5.5.60-MariaDB
) starting as process
5339 ...
190115 16:
00:
03 InnoDB: The
InnoDB memory heap
is disabled
190115 16:
00:
03 InnoDB: Mutexes
and rw_locks
use GCC atomic builtins
190115 16:
00:
03 InnoDB: Compressed tables
use zlib
1.2.7
190115 16:
00:
03 InnoDB:
Using Linux native AIO
190115 16:
00:
03 InnoDB: Initializing buffer pool, size =
340.0M
InnoDB: mmap
(365920256 bytes
) failed; errno
12
190115 16:
00:
03 InnoDB: Completed initialization of buffer pool
190115 16:
00:
03 InnoDB: Fatal error: cannot allocate
memory for the buffer pool
190115 16:
00:
03 [ERROR
] Plugin
'InnoDB' init function returned error.
190115 16:
00:
03 [ERROR
] Plugin
'InnoDB' registration
as a STORAGE
ENGINE failed.
190115 16:
00:
03 [Note
] Plugin
'FEEDBACK' is disabled.
190115 16:
00:
03 [ERROR
] Unknown/unsupported storage
engine:
InnoDB
190115 16:
00:
03 [ERROR
] Aborting
190115 16:
00:
03 [Note
] /usr/libexec/mysqld: Shutdown complete
190115 16:
00:
03 mysqld_safe mysqld
from pid file /var/run/mariadb/mariadb.pid ended
190115 16:
00:
04 mysqld_safe
Starting mysqld daemon
with databases from /var/lib/mysql
190115 16:
00:
04 [Note
] /usr/libexec/mysqld
(mysqld
5.5.60-MariaDB
) starting as process
5983 ...
190115 16:
00:
04 InnoDB: The
InnoDB memory heap
is disabled
190115 16:
00:
04 InnoDB: Mutexes
and rw_locks
use GCC atomic builtins
190115 16:
00:
04 InnoDB: Compressed tables
use zlib
1.2.7
190115 16:
00:
04 InnoDB:
Using Linux native AIO
190115 16:
00:
04 InnoDB: Initializing buffer pool, size =
340.0M
InnoDB: mmap
(365920256 bytes
) failed; errno
12
190115 16:
00:
04 InnoDB: Completed initialization of buffer pool
190115 16:
00:
04 InnoDB: Fatal error: cannot allocate
memory for the buffer pool
190115 16:
00:
04 [ERROR
] Plugin
'InnoDB' init function returned error.
190115 16:
00:
04 [ERROR
] Plugin
'InnoDB' registration
as a STORAGE
ENGINE failed.
190115 16:
00:
04 [Note
] Plugin
'FEEDBACK' is disabled.
190115 16:
00:
04 [ERROR
] Unknown/unsupported storage
engine:
InnoDB
190115 16:
00:
04 [ERROR
] Aborting
190115 16:
00:
04 [Note
] /usr/libexec/mysqld: Shutdown complete
190115 16:
00:
04 mysqld_safe mysqld
from pid file /var/run/mariadb/mariadb.pid ended
190115 16:
00:
58 mysqld_safe
Starting mysqld daemon
with databases from /var/lib/mysql
190115 16:
00:
58 [Note
] /usr/libexec/mysqld
(mysqld
5.5.60-MariaDB
) starting as process
6646 ...
190115 16:
00:
58 InnoDB: The
InnoDB memory heap
is disabled
190115 16:
00:
58 InnoDB: Mutexes
and rw_locks
use GCC atomic builtins
190115 16:
00:
58 InnoDB: Compressed tables
use zlib
1.2.7
190115 16:
00:
58 InnoDB:
Using Linux native AIO
190115 16:
00:
58 InnoDB: Initializing buffer pool, size =
340.0M
InnoDB: mmap
(365920256 bytes
) failed; errno
12
190115 16:
00:
58 InnoDB: Completed initialization of buffer pool
190115 16:
00:
58 InnoDB: Fatal error: cannot allocate
memory for the buffer pool
190115 16:
00:
58 [ERROR
] Plugin
'InnoDB' init function returned error.
190115 16:
00:
58 [ERROR
] Plugin
'InnoDB' registration
as a STORAGE
ENGINE failed.
190115 16:
00:
58 [Note
] Plugin
'FEEDBACK' is disabled.
190115 16:
00:
58 [ERROR
] Unknown/unsupported storage
engine:
InnoDB
190115 16:
00:
58 [ERROR
] Aborting
190115 16:
00:
58 [Note
] /usr/libexec/mysqld: Shutdown complete
190115 16:
00:
58 mysqld_safe mysqld
from pid file /var/run/mariadb/mariadb.pid ended
