Доброго времени суток.
Создал скрипт на ЯП Питон, который парсит информацию с определенного сайта и закачивает все в одну таблицу БД на движке MyIsam. Пару дней назад, при попытке входа в БД (у меня их несколько, проблемы только с этой) через терминал - выкидывает данную ошибку:
1.
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
При вводе комманды
mysql> select * from my_table where id=1;
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: my_db
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
ERROR:
Can't connect to the server
В самом скрипте прописал чтобы ошибки записывались в отдельном файле, вот что пишет:
1.
(1114, "The table 'my_table' is full")
На ПК установлен также MySQL Workbench, вот что пишет:
1.
Error: MySQL server has gone away
Вот что пишет MySQL в error логе:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
2020-03-24T06:08:11.044877Z 5 [ERROR] InnoDB: Trying to access page number 262663 in space 26, space name my_db/my_table, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
2020-03-24T06:08:11.044930Z 5 [ERROR] InnoDB: Server exits.
2020-03-24T06:08:11.445193Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:08:11.445281Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:08:11.646417Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:08:11.649552Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 11314 ...
2020-03-24T06:08:11.655581Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:08:11.655635Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:08:11.655646Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:08:11.655656Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:08:11.655666Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:08:11.655676Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:08:11.656026Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:08:11.656166Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:08:11.658108Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:08:11.671803Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:08:11.673989Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:08:11.687555Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:08:11.688741Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3769023529
2020-03-24T06:08:11.688770Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3769023538
2020-03-24T06:08:11.688782Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-24T06:08:11.688793Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-24T06:08:11.858459Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:08:11.858507Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:08:11.858581Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:08:12.043216Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:08:12.044716Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:08:12.044732Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:08:12.045292Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-24T06:08:12.095556Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023538
2020-03-24T06:08:12.095852Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:08:12.098486Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:08:12
2020-03-24T06:08:12.096141Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:08:12.107609Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:08:12.107649Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:08:12.107665Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:08:12.107763Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:08:12.122627Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:08:12.122941Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:08:12.448541Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-24T06:38:54.139264Z 3 [ERROR] InnoDB: Trying to access page number 262663 in space 26, space name my_db/my_table, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
2020-03-24T06:38:54.139307Z 3 [ERROR] InnoDB: Server exits.
2020-03-24T06:38:54.449291Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:38:54.449388Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:38:54.653296Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:38:54.656835Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 11704 ...
2020-03-24T06:38:54.663166Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:38:54.663253Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:38:54.663265Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:38:54.663276Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:38:54.663286Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:38:54.663297Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:38:54.663727Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:38:54.663890Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:38:54.666085Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:38:54.680175Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:38:54.682484Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:38:54.696118Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:38:54.697315Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3769023557
2020-03-24T06:38:54.697344Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3769023566
2020-03-24T06:38:54.697356Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-24T06:38:54.697367Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-24T06:38:54.869141Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:38:54.869208Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:38:54.869338Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:38:55.052767Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:38:55.054473Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:38:55.054494Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:38:55.054904Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-24T06:38:55.105119Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023566
2020-03-24T06:38:55.105301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:38:55.105570Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:38:55.108070Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:38:55
2020-03-24T06:38:55.112619Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:38:55.112663Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:38:55.112678Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:38:55.112766Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:38:55.132884Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:38:55.133200Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:38:55.463693Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-24T06:39:06.919712Z 3 [ERROR] InnoDB: Trying to access page number 262663 in space 26, space name my_db/my_table, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
2020-03-24T06:39:06.919752Z 3 [ERROR] InnoDB: Server exits.
2020-03-24T06:39:07.193762Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:39:07.193850Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:39:07.390411Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:39:07.393896Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 11755 ...
2020-03-24T06:39:07.399768Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:39:07.399822Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:39:07.399832Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:39:07.399842Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:39:07.399852Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:39:07.399862Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:39:07.400214Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:39:07.400360Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:39:07.402303Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:39:07.416002Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:39:07.418277Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:39:07.431883Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:39:07.433073Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3769023585
2020-03-24T06:39:07.433107Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3769023594
2020-03-24T06:39:07.433120Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-24T06:39:07.433131Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-24T06:39:07.589757Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:39:07.589804Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:39:07.589890Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:39:07.792075Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:39:07.793768Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:39:07.794784Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:39:07.795234Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-24T06:39:07.845407Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023594
2020-03-24T06:39:07.845578Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:39:07.845865Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:39:07.848454Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:39:07
2020-03-24T06:39:07.853375Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:39:07.853413Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:39:07.853429Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:39:07.853519Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:39:07.865585Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:39:07.865902Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:39:08.196487Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-24T06:39:08.421810Z 2 [ERROR] InnoDB: Trying to access page number 262663 in space 26, space name my_db/my_table, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
2020-03-24T06:39:08.421845Z 2 [ERROR] InnoDB: Server exits.
2020-03-24T06:39:08.697897Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:39:08.697981Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:39:08.890754Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:39:08.894176Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 11806 ...
2020-03-24T06:39:08.900342Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:39:08.900402Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:39:08.900412Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:39:08.900422Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:39:08.900432Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:39:08.900442Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:39:08.900798Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:39:08.900937Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:39:08.902934Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:39:08.916696Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:39:08.918989Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:39:08.932597Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:39:08.933771Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3769023585
2020-03-24T06:39:08.933800Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3769023594
2020-03-24T06:39:08.933812Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-24T06:39:08.933822Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-24T06:39:09.102963Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:39:09.103013Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:39:09.103109Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:39:09.295333Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:39:09.297047Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:39:09.297068Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:39:09.297747Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-24T06:39:09.347959Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023594
2020-03-24T06:39:09.348192Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:39:09.348429Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:39:09.350621Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:39:09
2020-03-24T06:39:09.364699Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:39:09.364737Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:39:09.364752Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:39:09.364841Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:39:09.376942Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:39:09.377178Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:39:09.700460Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-24T06:40:36.493697Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-03-24T06:40:36.493749Z 0 [Note] Shutting down slave threads
2020-03-24T06:40:36.493759Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-03-24T06:40:36.493773Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-24T06:40:36.493830Z 0 [Note] Binlog end
2020-03-24T06:40:36.494335Z 0 [Note] Shutting down plugin 'ngram'
2020-03-24T06:40:36.494350Z 0 [Note] Shutting down plugin 'partition'
2020-03-24T06:40:36.494359Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-03-24T06:40:36.494367Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-03-24T06:40:36.494376Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-03-24T06:40:36.494385Z 0 [Note] Shutting down plugin 'MEMORY'
2020-03-24T06:40:36.494393Z 0 [Note] Shutting down plugin 'MyISAM'
2020-03-24T06:40:36.494405Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-03-24T06:40:36.494455Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-03-24T06:40:36.494465Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-03-24T06:40:36.494473Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-03-24T06:40:36.494481Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-03-24T06:40:36.494489Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-03-24T06:40:36.494498Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-03-24T06:40:36.494506Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-03-24T06:40:36.494514Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-03-24T06:40:36.494522Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-03-24T06:40:36.494530Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-03-24T06:40:36.494539Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-03-24T06:40:36.494549Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-03-24T06:40:36.494560Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-03-24T06:40:36.494568Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-03-24T06:40:36.494576Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-03-24T06:40:36.494584Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-03-24T06:40:36.494593Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-03-24T06:40:36.494601Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-03-24T06:40:36.494609Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-03-24T06:40:36.494617Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-03-24T06:40:36.494626Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-03-24T06:40:36.494634Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-03-24T06:40:36.494642Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-03-24T06:40:36.494650Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-03-24T06:40:36.494658Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-03-24T06:40:36.494688Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-03-24T06:40:36.494699Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-03-24T06:40:36.494707Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-03-24T06:40:36.494715Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-03-24T06:40:36.494723Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-03-24T06:40:36.494731Z 0 [Note] Shutting down plugin 'InnoDB'
2020-03-24T06:40:36.494805Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-03-24T06:40:36.494942Z 0 [Note] InnoDB: Starting shutdown...
2020-03-24T06:40:36.595111Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-03-24T06:40:36.595334Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200324 8:40:36
2020-03-24T06:40:38.375288Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3769023622
2020-03-24T06:40:38.378983Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:40:38.379023Z 0 [Note] Shutting down plugin 'CSV'
2020-03-24T06:40:38.379047Z 0 [Note] Shutting down plugin 'sha256_password'
2020-03-24T06:40:38.379056Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-03-24T06:40:38.379239Z 0 [Note] Shutting down plugin 'binlog'
2020-03-24T06:40:38.379619Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-03-24T06:41:01.956201Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:41:01.956291Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:41:02.159800Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:41:02.163185Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 11974 ...
2020-03-24T06:41:02.169245Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:41:02.169300Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:41:02.169311Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:41:02.169322Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:41:02.169332Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:41:02.169342Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:41:02.169701Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:41:02.169839Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:41:02.171848Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:41:02.185531Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:41:02.187813Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:41:02.201383Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:41:02.267058Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:41:02.267178Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:41:02.456239Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:41:02.457740Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:41:02.457760Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:41:02.458427Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023622
2020-03-24T06:41:02.458598Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:41:02.458898Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:41:02.460882Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:41:02
2020-03-24T06:41:02.465625Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:41:02.465660Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:41:02.465674Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:41:02.465757Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:41:02.476417Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:41:02.476648Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:41:02.962483Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-24T06:41:18.433194Z 3 [ERROR] InnoDB: Trying to access page number 262663 in space 26, space name my_db/my_table, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server.
2020-03-24T06:41:18.433231Z 3 [ERROR] InnoDB: Server exits.
2020-03-24T06:41:18.704507Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-24T06:41:18.704588Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-24T06:41:18.905039Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-24T06:41:18.908632Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1) starting as process 12023 ...
2020-03-24T06:41:18.914588Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-24T06:41:18.914648Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-24T06:41:18.914659Z 0 [Note] InnoDB: Uses event mutexes
2020-03-24T06:41:18.914705Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-24T06:41:18.914718Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-24T06:41:18.914728Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-24T06:41:18.915084Z 0 [Note] InnoDB: Number of pools: 1
2020-03-24T06:41:18.915262Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-24T06:41:18.917291Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-24T06:41:18.930867Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-24T06:41:18.933254Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-24T06:41:18.946749Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-24T06:41:18.947924Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3769023641
2020-03-24T06:41:18.947958Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3769023650
2020-03-24T06:41:18.947970Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-24T06:41:18.947981Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-24T06:41:19.102161Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-24T06:41:19.102214Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-24T06:41:19.102315Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-24T06:41:19.303185Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-24T06:41:19.304697Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-24T06:41:19.304713Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-24T06:41:19.305149Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-24T06:41:19.355376Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 3769023650
2020-03-24T06:41:19.355628Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-24T06:41:19.355934Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-24T06:41:19.358224Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200324 8:41:19
2020-03-24T06:41:19.363484Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-24T06:41:19.363521Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-24T06:41:19.363536Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-24T06:41:19.363630Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-24T06:41:19.375729Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-24T06:41:19.375954Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.26-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-03-24T06:41:19.702284Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
Содержание my.cnf:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
#socket=/var/run/mysqld/mysqld.sock
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
Содержание /etc/mysql/mysql.conf.d/mysqld.cnf:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
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.
100.
101.
102.
103.
104.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
1.
Linux asus 4.4.0-155-generic #182-Ubuntu SMP Tue Jul 2 14:42:54 UTC 2019 i686 i686 i686 GNU/Linux
1.
2.
3.
4.
5.
6.
7.
8.
9.
Файл.система Размер Использовано Дост Использовано% Cмонтировано в
udev 2.0G 0 2.0G 0% /dev
tmpfs 404M 17M 387M 5% /run
/dev/sda1 228G 56G 161G 26% /
tmpfs 2.0G 1.5M 2.0G 1% /dev/shm
tmpfs 5.0M 4.0K 5.0M 1% /run/lock
tmpfs 2.0G 0 2.0G 0% /sys/fs/cgroup
cgmfs 100K 0 100K 0% /run/cgmanager/fs
tmpfs 404M 36K 404M 1% /run/user/1000
Параметры ПК:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
H/W path Устройство Класс Описание
===================================================================
system G31M-ES2L
/0 bus G31M-ES2L
/0/0 memory 128KiB BIOS
/0/4 processor Intel(R) Core(TM)2 Quad CPU
/0/4/8 memory 64KiB L1 кэш
/0/4/9 memory 2MiB L2 кэш
/0/4/2.1 processor Логический ЦПУ
/0/4/2.2 processor Логический ЦПУ
/0/4/2.3 processor Логический ЦПУ
/0/4/2.4 processor Логический ЦПУ
/0/19 memory 4GiB Системная па
/0/19/0 memory 2GiB DIMMProject-Id-Version:
/0/19/1 memory 2GiB DIMMProject-Id-Version:
/0/1 processor
/0/1/2.1 processor Логический ЦПУ
/0/1/2.2 processor Логический ЦПУ
/0/1/2.3 processor Логический ЦПУ
/0/1/2.4 processor Логический ЦПУ
/0/2 processor
/0/2/2.1 processor Логический ЦПУ
/0/2/2.2 processor Логический ЦПУ
/0/2/2.3 processor Логический ЦПУ
/0/2/2.4 processor Логический ЦПУ
/0/3 processor
/0/3/2.1 processor Логический ЦПУ
/0/3/2.2 processor Логический ЦПУ
/0/3/2.3 processor Логический ЦПУ
/0/3/2.4 processor Логический ЦПУ
/0/100 bridge 82G33/G31/P35/P31 Express DRA
/0/100/2 display 82G33/G31 Express Integrated
/0/100/1b multimedia NM10/ICH7 Family High Definit
/0/100/1c bridge NM10/ICH7 Family PCI Express
/0/100/1c.1 bridge NM10/ICH7 Family PCI Express
/0/100/1c.1/0 enp2s0 network RTL8111/8168/8411 PCI Express
/0/100/1d bus NM10/ICH7 Family USB UHCI Con
/0/100/1d/1 usb2 bus UHCI Host Controller
/0/100/1d.1 bus NM10/ICH7 Family USB UHCI Con
/0/100/1d.1/1 usb3 bus UHCI Host Controller
/0/100/1d.2 bus NM10/ICH7 Family USB UHCI Con
/0/100/1d.2/1 usb4 bus UHCI Host Controller
/0/100/1d.2/1/1 input Multimedia Keyboard
/0/100/1d.2/1/2 input Usb Mouse
/0/100/1d.3 bus NM10/ICH7 Family USB UHCI Con
/0/100/1d.3/1 usb5 bus UHCI Host Controller
/0/100/1d.7 bus NM10/ICH7 Family USB2 EHCI Co
/0/100/1d.7/1 usb1 bus EHCI Host Controller
/0/100/1e bridge 82801 PCI Bridge
/0/100/1f bridge 82801GB/GR (ICH7 Family) LPC
/0/100/1f.2 storage NM10/ICH7 Family SATA Control
/0/100/1f.3 bus NM10/ICH7 Family SMBus Contro
/0/5 scsi0 storage
/0/5/0.0.0 /dev/sda disk 250GB SCSI Disk
/0/5/0.0.0/1 /dev/sda1 volume 230GiB Том EXT4
/0/5/0.0.0/2 /dev/sda2 volume 1981MiB Linux swap volume
ПС:
Аналогичный случай произошел где-то пол года назад, точно такая же БД но на движке InnoDB, обьем той базы был 4,5 гб (когда выдала
1.
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
а сейчас 4,6 гб, странное совпадение.
Подскажите как решить данную проблему.
Заранее спасибо
