问答

数据库启动失败,删也删不掉。 Lost connection to server at 'r

作者:admin 2021-09-24 我要评论

服务器一直在跑脚本插入数据,昨天突然提示:“The table '表名' is full”。 我查了下资料,在配置加上 [mysqld]tmp_table_size = 32Mmax_heap_table_size = 32...

在说正事之前,我要推荐一个福利:你还在原价购买阿里云、腾讯云、华为云服务器吗?那太亏啦!来这里,新购、升级、续费都打折,能够为您省60%的钱呢!2核4G企业级云服务器低至69元/年,点击进去看看吧>>>)

服务器一直在跑脚本插入数据,昨天突然提示:“The table '表名' is full”。
我查了下资料,在配置加上

[mysqld]
tmp_table_size = 32M
max_heap_table_size = 32M

重启之后,数据库就连不上了。

2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "Internal error/check

试着把上面加的去掉也连不上,以下是连接时的错误日志

2020-03-06T20:28:16.993326Z 4 [ERROR] InnoDB: Trying to access page number 95434 in space 25, space name xx/zz, 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-06T20:28:16.993362Z 4 [ERROR] InnoDB: Server exits.
2020-03-06T20:28:17.215657Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-06T20:28:17.215723Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-06T20:28:17.370993Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-06T20:28:17.372372Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 5126 ...
2020-03-06T20:28:17.375452Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-06T20:28:17.375484Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-06T20:28:17.375492Z 0 [Note] InnoDB: Uses event mutexes
2020-03-06T20:28:17.375498Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-06T20:28:17.375507Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-06T20:28:17.375512Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-06T20:28:17.375687Z 0 [Note] InnoDB: Number of pools: 1
2020-03-06T20:28:17.375766Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-06T20:28:17.376743Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-06T20:28:17.383201Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-06T20:28:17.384424Z 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-06T20:28:17.396355Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-06T20:28:17.397055Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3936945843
2020-03-06T20:28:17.397074Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3936945852
2020-03-06T20:28:17.397080Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-06T20:28:17.397085Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-06T20:28:17.513131Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-06T20:28:17.513169Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-06T20:28:17.513225Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-06T20:28:17.607539Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-06T20:28:17.608370Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-06T20:28:17.608389Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-06T20:28:17.608660Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-06T20:28:17.658834Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3936945852
2020-03-06T20:28:17.659022Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-06T20:28:17.659075Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06T20:28:17.660668Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200307  4:28:17
2020-03-06T20:28:17.663727Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-03-06T20:28:17.663752Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-03-06T20:28:17.664383Z 0 [Warning] CA certificate ca.pem is self signed.
2020-03-06T20:28:17.664421Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-03-06T20:28:17.664504Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-06T20:28:17.664539Z 0 [Note] IPv6 is available.
2020-03-06T20:28:17.664549Z 0 [Note]   - '::' resolves to '::';
2020-03-06T20:28:17.664591Z 0 [Note] Server socket created on IP: '::'.
2020-03-06T20:28:17.670021Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-06T20:28:17.670134Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-03-06T20:28:18.215890Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-06T20:29:43.123782Z 3 [ERROR] InnoDB: Trying to access page number 95434 in space 25, space name xxx/zzz, 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-06T20:29:43.123820Z 3 [ERROR] InnoDB: Server exits.
2020-03-06T20:29:43.470936Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-06T20:29:43.470991Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-06T20:29:43.619154Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-06T20:29:43.620482Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 5173 ...
2020-03-06T20:29:43.623478Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-06T20:29:43.623508Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-06T20:29:43.623514Z 0 [Note] InnoDB: Uses event mutexes
2020-03-06T20:29:43.623519Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-06T20:29:43.623524Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-06T20:29:43.623528Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-06T20:29:43.623715Z 0 [Note] InnoDB: Number of pools: 1
2020-03-06T20:29:43.623802Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-06T20:29:43.624870Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-06T20:29:43.631842Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-06T20:29:43.632988Z 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-06T20:29:43.644937Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-06T20:29:43.645609Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3936945871
2020-03-06T20:29:43.645630Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3936945880
2020-03-06T20:29:43.645635Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-06T20:29:43.645640Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-06T20:29:43.762453Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-06T20:29:43.762492Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-06T20:29:43.762533Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-06T20:29:43.856978Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-06T20:29:43.858007Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-06T20:29:43.858031Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-06T20:29:43.858354Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-06T20:29:43.908571Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3936945880
2020-03-06T20:29:43.908782Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-06T20:29:43.908810Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06T20:29:43.910674Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200307  4:29:43
2020-03-06T20:29:43.913701Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-03-06T20:29:43.913723Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-03-06T20:29:43.914236Z 0 [Warning] CA certificate ca.pem is self signed.
2020-03-06T20:29:43.914277Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-03-06T20:29:43.914381Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-06T20:29:43.914418Z 0 [Note] IPv6 is available.
2020-03-06T20:29:43.914430Z 0 [Note]   - '::' resolves to '::';
2020-03-06T20:29:43.914476Z 0 [Note] Server socket created on IP: '::'.
2020-03-06T20:29:43.919802Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-06T20:29:43.919990Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-03-06T20:29:44.460867Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-06T20:38:40.262202Z 3 [ERROR] InnoDB: Trying to access page number 95434 in space 25, space name xxx/zzz, 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-06T20:38:40.262242Z 3 [ERROR] InnoDB: Server exits.
2020-03-06T20:38:40.458309Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-06T20:38:40.458349Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-06T20:38:40.611334Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-06T20:38:40.612771Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 5226 ...
2020-03-06T20:38:40.615678Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-06T20:38:40.615704Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-06T20:38:40.615710Z 0 [Note] InnoDB: Uses event mutexes
2020-03-06T20:38:40.615715Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-06T20:38:40.615720Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-06T20:38:40.615725Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-06T20:38:40.615897Z 0 [Note] InnoDB: Number of pools: 1
2020-03-06T20:38:40.615979Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-06T20:38:40.617021Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-06T20:38:40.623351Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-06T20:38:40.624508Z 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-06T20:38:40.636334Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-06T20:38:40.638268Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3936949893
2020-03-06T20:38:40.638287Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3936949902
2020-03-06T20:38:40.638293Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-06T20:38:40.638298Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-06T20:38:40.754131Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-06T20:38:40.754218Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-06T20:38:40.754271Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-06T20:38:40.845139Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-06T20:38:40.845959Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-06T20:38:40.845977Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-06T20:38:40.846196Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-06T20:38:40.896365Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3936949902
2020-03-06T20:38:40.896589Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-06T20:38:40.896613Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06T20:38:40.898223Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200307  4:38:40
2020-03-06T20:38:40.901146Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-03-06T20:38:40.901169Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-03-06T20:38:40.901639Z 0 [Warning] CA certificate ca.pem is self signed.
2020-03-06T20:38:40.901669Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-03-06T20:38:40.901733Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-06T20:38:40.901762Z 0 [Note] IPv6 is available.
2020-03-06T20:38:40.901772Z 0 [Note]   - '::' resolves to '::';
2020-03-06T20:38:40.901813Z 0 [Note] Server socket created on IP: '::'.
2020-03-06T20:38:40.907189Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-06T20:38:40.907313Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-03-06T20:38:41.465803Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-06T20:38:59.887653Z 3 [ERROR] InnoDB: Trying to access page number 95434 in space 25, space name xxx/zzz, 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-06T20:38:59.887700Z 3 [ERROR] InnoDB: Server exits.
2020-03-06T20:39:00.214443Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-03-06T20:39:00.214491Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2020-03-06T20:39:00.370992Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-06T20:39:00.372348Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 5272 ...
2020-03-06T20:39:00.375281Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-06T20:39:00.375304Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-06T20:39:00.375309Z 0 [Note] InnoDB: Uses event mutexes
2020-03-06T20:39:00.375314Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-06T20:39:00.375318Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-03-06T20:39:00.375322Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-06T20:39:00.375526Z 0 [Note] InnoDB: Number of pools: 1
2020-03-06T20:39:00.375608Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-06T20:39:00.376579Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-06T20:39:00.382909Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-06T20:39:00.384007Z 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-06T20:39:00.395841Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-06T20:39:00.396608Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3936949921
2020-03-06T20:39:00.396639Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3936949930
2020-03-06T20:39:00.396645Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-03-06T20:39:00.396650Z 0 [Note] InnoDB: Starting crash recovery.
2020-03-06T20:39:00.513118Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-06T20:39:00.513156Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-06T20:39:00.513200Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-06T20:39:00.606893Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-06T20:39:00.607742Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-06T20:39:00.607762Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-06T20:39:00.608063Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-06T20:39:00.658311Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3936949930
2020-03-06T20:39:00.658535Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-06T20:39:00.658568Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06T20:39:00.660410Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200307  4:39:00
2020-03-06T20:39:00.663477Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-03-06T20:39:00.663501Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-03-06T20:39:00.664011Z 0 [Warning] CA certificate ca.pem is self signed.
2020-03-06T20:39:00.664043Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-03-06T20:39:00.664163Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-06T20:39:00.664226Z 0 [Note] IPv6 is available.
2020-03-06T20:39:00.664238Z 0 [Note]   - '::' resolves to '::';
2020-03-06T20:39:00.664301Z 0 [Note] Server socket created on IP: '::'.
2020-03-06T20:39:00.669579Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-06T20:39:00.669697Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-03-06T20:39:01.223092Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)

版权声明:本文转载自网络,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。本站转载出于传播更多优秀技术知识之目的,如有侵权请联系QQ/微信:153890879删除

相关文章
  • 数据库启动失败,删也删不掉。 Lost co

    数据库启动失败,删也删不掉。 Lost co

  • vue init webpack demo的时候,为什么V

    vue init webpack demo的时候,为什么V

  • vue uni-app如何选中每一个数组 中规格

    vue uni-app如何选中每一个数组 中规格

  • 访问数组里面对象的属性,第一次进入浏

    访问数组里面对象的属性,第一次进入浏

腾讯云代理商
海外云服务器