mysql down after three days transfer to new server
[root@site ~]# tail -f /var/log/mysql/error.logtail: cannot open '/var/log/mysql/error.log' for reading: No such file or directory
tail: no files remaining
[root@site ~]# systemctl status mysqld.service● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mysqld.service.d
└─limits.conf
Active: activating (start) since Mon 2024-07-08 11:35:45 CEST; 2s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1677894 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 1677918 (mysqld)
Status: "Server startup in progress"
Tasks: 21 (limit: 408609)
Memory: 146.8M
CGroup: /system.slice/mysqld.service
└─1677918 /usr/sbin/mysqld
Jul 08 11:35:45 name.server.com systemd[1]: Starting MySQL Server...
[root@site ~]# tail -100 /var/log/mysqld.log
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7fdd98b55d20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*,std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7fdd978d6b23]
/lib64/libpthread.so.0(+0x81ca) [0x7fdd98b4b1ca]
/lib64/libc.so.6(clone+0x43) [0x7fdd96edd8d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2024-07-08T09:37:48.451067Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-08T09:37:48.451090Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1680674
2024-07-08T09:37:48.460809Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2024-07-08T09:37:48.461834Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-08T09:37:50.801280Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-08T09:37:51Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213f031]
/usr/sbin/mysqld(print_fatal_signal(int)+0x397) [0xffa557]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7f0c6e95bd20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*,std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7f0c6d6dcb23]
/lib64/libpthread.so.0(+0x81ca) [0x7f0c6e9511ca]
/lib64/libc.so.6(clone+0x43) [0x7f0c6cce38d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2024-07-08T09:37:51.451045Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-08T09:37:51.451058Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1680729
2024-07-08T09:37:51.459934Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2024-07-08T09:37:51.460967Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-08T09:37:53.847219Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-08T09:37:54Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213f031]
/usr/sbin/mysqld(print_fatal_signal(int)+0x397) [0xffa557]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7f9fbb883d20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*,std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7f9fba604b23]
/lib64/libpthread.so.0(+0x81ca) [0x7f9fbb8791ca]
/lib64/libc.so.6(clone+0x43) [0x7f9fb9c0b8d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2024-07-08T09:37:54.451037Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-08T09:37:54.451050Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1680794
2024-07-08T09:37:54.460525Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2024-07-08T09:37:54.461537Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-08T09:37:56.828699Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-08T09:37:57Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213f031]
/usr/sbin/mysqld(print_fatal_signal(int)+0x397) [0xffa557]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7fab254d4d20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*,std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7fab24255b23]
/lib64/libpthread.so.0(+0x81ca) [0x7fab254ca1ca]
/lib64/libc.so.6(clone+0x43) [0x7fab2385c8d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2024-07-08T09:37:57.421046Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-08T09:37:57.421073Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1680855
2024-07-08T09:37:57.431517Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2024-07-08T09:37:57.432552Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-08T09:37:59.794453Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-08T09:38:00Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=539914406f129270c6bd39a48640d0f1eeecc1af
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x213f031]
/usr/sbin/mysqld(print_fatal_signal(int)+0x397) [0xffa557]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xffa615]
/lib64/libpthread.so.0(+0x12d20) [0x7f6881a4ad20]
/usr/sbin/mysqld(Validate_files::check(__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)+0x909) [0x218ddb9]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, std::function<void (__gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*,std::allocator<dd::Tablespace const*> > > const&, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, std::allocator<dd::Tablespace const*> > > const&, unsigned long)>, __gnu_cxx::__normal_iterator<dd::Tablespace const* const*, std::vector<dd::Tablespace const*, /lib64/libstdc++.so.6(+0xc2b23) [0x7f68807cbb23]
/lib64/libpthread.so.0(+0x81ca) [0x7f6881a401ca]
/lib64/libc.so.6(clone+0x43) [0x7f687fdd28d3]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
This problem has been happening to me for a week since I was transferred to the new server and I haven't found a solution. I formatted the server, installed a new system, and transferred the websites again, and they worked again. Today, after a restart, this problem occurred again. Note that I opened a ticket with technical support, but the matter was not resolved.
any help
Thanks
-
You should search existing recent threads
https://support.cpanel.net/hc/en-us/community/posts/24546812407575
Downgrade to 8.0.37:
Use versionlock to lock the version so that it doesn't upgrade to 8.0.38 after you downgrade. But be prepared to remove the versionlock once the bug is fixed in 8.0.38:
https://support.cpanel.net/hc/en-us/articles/1500013004522-How-to-version-lock-RPM-packages
0
Please sign in to leave a comment.
Comments
1 comment