انجمن‌های فارسی اوبونتو

لطفاً به انجمن‌ها وارد شده و یا جهت ورود ثبت‌نام نمائید

لطفاً جهت ورود نام کاربری و رمز عبورتان را وارد نمائید

نویسنده موضوع: مشکل خاموش شدن mysqld  (دفعات بازدید: 223 بار)

0 کاربر و 1 مهمان درحال مشاهده موضوع.

آفلاین rayamand

  • Newbie
  • *
  • ارسال: 5
  • جنسیت : پسر
مشکل خاموش شدن mysqld
« : 19 فروردین 1402، 02:05 ب‌ظ »
  سلام و وقت بخیر. من یه سرور ابری دارم که سیستم عاملش دبیان ۱۱ هست. دایرکت ادمین روش نصب کردم که در کنارش mysql رو داره.
  دیشب سرویس mysqld ام بعد از اجرای service mysqld start خاموش شد و هیچجوره دوباره استارت نمیشه. تمامی راه هایی که داخل اینترنت بود رو زیر رو رو کردم یه روزه تمومه به هیچ نتیجه ای نرسیدم. ممنون میشم اگر راهکاری دارین بگین. اگر هم چیزی میخوایین ارسال کنم حتما بگید تا بفرستم.

    اگر کسی میتونه من مشکلی ندارم دسترسی سرور رو بهش بدم تا خودش هم یه چکی بکنه.


آفلاین rayamand

  • Newbie
  • *
  • ارسال: 5
  • جنسیت : پسر
پاسخ : مشکل خاموش شدن mysqld
« پاسخ #1 : 19 فروردین 1402، 02:06 ب‌ظ »
محتویات فایل debian-c3-medium1-ba-1.novalocal.err در /var/lib/mysql

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