Delayed Upvotes: SegFault in MySQL Server

in blurt •  2 years ago 

There was a 8 hour delay in daily upvotes, and also the ranking page stats. It was caused by MySQL crash and unfortunately, I was asleep, and also the auto restart didn't fix it.

Here is the logs from /var/log/mysql/error.log
It suggests a Bug or a Hardware Failure.

00:13:25 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f6f00000b60
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 = 7f6f1fffebf0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x55b7458214c1]
/usr/sbin/mysqld(print_fatal_signal(int)+0x2fb) [0x55b7446c0fbb]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0x55b7446c1075]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x14420) [0x7f6fb08ac420]
/usr/sbin/mysqld(ut_delay(unsigned long)+0x4) [0x55b745aada14]
[0x7f6f1fffeb68]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 0
Status: NOT_KILLED

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.
2022-10-04T00:13:30.418455Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2022-10-04T00:13:30.454659Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 2974893
2022-10-04T00:13:30.549759Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
00:13:30 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
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
2022-10-04T00:13:31.379704Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2022-10-04T00:13:31.414684Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 2974926
2022-10-04T00:13:31.490589Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

Anyway, I've restarted the services manually, and it seems working fine now.


Follow me: https://steemyy.com

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE BLURT!