سلام و وقت بخیر. من یه سرور ابری دارم که سیستم عاملش دبیان ۱۱ هست. دایرکت ادمین روش نصب کردم که در کنارش mysql رو داره.
دیشب سرویس mysqld ام بعد از اجرای service mysqld start خاموش شد و هیچجوره دوباره استارت نمیشه. تمامی راه هایی که داخل اینترنت بود رو زیر رو رو کردم یه روزه تمومه به هیچ نتیجه ای نرسیدم. ممنون میشم اگر راهکاری دارین بگین. اگر هم چیزی میخوایین ارسال کنم حتما بگید تا بفرستم.
اگر کسی میتونه من مشکلی ندارم دسترسی سرور رو بهش بدم تا خودش هم یه چکی بکنه.
- - - Updated - - -
محتویات فایل debian-c3-medium1-ba-1.novalocal.err در /var/lib/mysql
کد HTML:230407 22:21:39 mysqld_safe Starting mariadbd daemon with databases from /usr/local/mysql/data 2023-04-07 22:21:39 0 [Note] /usr/local/mysql/bin/mariadbd (server 10.6.9-MariaDB) starting as process 376313 ... 2023-04-07 22:21:39 0 [ERROR] mariadbd: Can't lock aria control file '/usr/local/mysql/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2023-04-07 22:22:09 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/usr/local/mysql/data/aria_log_contr> 2023-04-07 22:22:09 0 [ERROR] Plugin 'Aria' init function returned error. 2023-04-07 22:22:09 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2023-04-07 22:22:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2023-04-07 22:22:09 0 [Note] InnoDB: Number of pools: 1 2023-04-07 22:22:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-04-07 22:22:09 0 [Note] InnoDB: Using Linux native AIO 2023-04-07 22:22:09 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2023-04-07 22:22:09 0 [Note] InnoDB: Completed initialization of buffer pool 2023-04-07 22:22:09 0 [Note] InnoDB: 128 rollback segments are active. 2023-04-07 22:22:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-04-07 22:22:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-04-07 22:22:09 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-04-07 22:22:09 0 [Note] InnoDB: 10.6.9 started; log sequence number 11712447012; transaction id 3285602 2023-04-07 22:22:09 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2023-04-07 22:22:09 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: Permission denied 2023-04-07 22:22:09 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-04-07 22:22:09 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded 2023-04-07 22:22:09 0 [ERROR] Failed to initialize plugins. 2023-04-07 22:22:09 0 [ERROR] Aborting 230407 22:22:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/debian-c3-medium1-ba-1.novalocal.pid ended 230407 23:59:55 mysqld_safe Starting mariadbd daemon with databases from /usr/local/mysql/data 2023-04-07 23:59:55 0 [Note] /usr/local/bin/mariadbd (server 10.6.9-MariaDB) starting as process 380211 ... 2023-04-07 23:59:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2023-04-07 23:59:55 0 [Note] InnoDB: Number of pools: 1 2023-04-07 23:59:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-04-07 23:59:55 0 [Note] InnoDB: Using Linux native AIO 2023-04-07 23:59:55 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2023-04-07 23:59:55 0 [Note] InnoDB: Completed initialization of buffer pool 2023-04-07 23:59:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11712439973,11712439973 2023-04-07 23:59:55 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 11712439973 between the checkpoint 11712439973 and the end 11712439985. 2023-04-07 23:59:55 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-04-07 23:59:55 0 [Note] InnoDB: Starting shutdown... 2023-04-07 23:59:55 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-04-07 23:59:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-04-07 23:59:55 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-04-07 23:59:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-04-07 23:59:55 0 [ERROR] Aborting 230407 23:59:55 mysqld_safe mysqld from pid file /usr/local/mysql/data/debian-c3-medium1-ba-1.novalocal.pid ended





 
			
			 
  
  مشکل خاموش شدن mysqld
 مشکل خاموش شدن mysqld
				 
					
					
					
						 پاسخ با نقل قول
  پاسخ با نقل قول