mysqld: Disk is full writing

1 개요[ | ]

mysqld: Disk is full writing
2023-09-11 01:06:17+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.22+maria~ubu2004 started.
2023-09-11 01:06:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-09-11 01:06:17+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.22+maria~ubu2004 started.
2023-09-11 01:06:18+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2023-09-11 01:06:18+00:00 [Note] [Entrypoint]: MariaDB upgrade (mysql_upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2023-09-11  1:06:18 0 [Note] Starting MariaDB 10.5.22-MariaDB-1:10.5.22+maria~ubu2004-log source revision 7e650253dc488debcb0898ebe6d385bf6dfa3656 as process 1
2023-09-11  1:06:18 0 [Note] InnoDB: Uses event mutexes
2023-09-11  1:06:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-11  1:06:18 0 [Note] InnoDB: Number of pools: 1
2023-09-11  1:06:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-09-11  1:06:18 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-09-11  1:06:18 0 [Note] InnoDB: Using Linux native AIO
2023-09-11  1:06:18 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-09-11  1:06:18 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-11  1:06:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=92049161170,92049161170
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961206 was in the XA prepared state.
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961347 was in the XA prepared state.
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961208 was in the XA prepared state.
...
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961344 was in the XA prepared state.
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961615 was in the XA prepared state.
2023-09-11  1:06:18 0 [Note] InnoDB: Transaction 239961205 was in the XA prepared state.
2023-09-11  1:06:18 0 [Note] InnoDB: 199 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2023-09-11  1:06:18 0 [Note] InnoDB: Trx id counter is 239961828
2023-09-11  1:06:18 0 [Note] InnoDB: Starting final batch to recover 7107 pages from redo log.
2023-09-11  1:06:19 0 [Note] InnoDB: Last binlog file './primary-bin.000086', position 11293460
2023-09-11  1:06:19 0 [Note] InnoDB: 128 rollback segments are active.
2023-09-11  1:06:19 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2023-09-11  1:06:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-09-11  1:06:19 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2023-09-11  1:06:19 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-09-11  1:06:19 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-09-11  1:06:19 0 [Note] InnoDB: 10.5.22 started; log sequence number 92072090153; transaction id 239961829
2023-09-11  1:06:19 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-09-11  1:06:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-11  1:06:19 0 [Note] Recovering after a crash using primary-bin
2023-09-11  1:06:19 0 [ERROR] Error in Log_event::read_log_event(): 'Event truncated', data_len: 604, event_type: 2
2023-09-11  1:06:19 0 [Note] Starting crash recovery...
2023-09-11  1:06:19 0 [Note] InnoDB: Starting recovery for XA transactions...
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction 239961823 in prepared state after recovery
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction contains changes to 1 rows
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction 239961623 in prepared state after recovery
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction contains changes to 1 rows
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction 239961727 in prepared state after recovery
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction contains changes to 1 rows
...
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction contains changes to 1 rows
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction 239961247 in prepared state after recovery
2023-09-11  1:06:19 0 [Note] InnoDB: Transaction contains changes to 1 rows
2023-09-11  1:06:19 0 [Note] InnoDB: 199 transactions in prepared state after recovery
2023-09-11  1:06:19 0 [Note] Found 199 prepared transaction(s) in InnoDB
2023-09-11  1:06:19 0 [Note] Crash recovery finished.
2023-09-11  1:06:19 0 [Warning] mysqld: Disk is full writing './primary-bin.~rec~' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
2023-09-11  1:06:19 0 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2023-09-11  1:06:22 0 [Note] InnoDB: Buffer pool(s) load completed at 230911  1:06:22
2 같이 보기[ | ]

No space left on device