Delayed Upvotes: SegFault in MySQL Server

in #witness-category2 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

Sort:  

Ah, that's why my latest post didn't get upvote yet.

Kindly visit and upvote it sir. Thank you.

https://steemit.com/chess/@satriotomo/bermain-melawan-stoktonslap-dari-ukraina-di-chess-com-04-10-2022

Hello @satriotomo! You are fabulous!


command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!

hello,
sir @justyy.
I didn't get an upvote on my last post. please can you kindly check it.
https://steemit.com/photography/@tingtong12/2dtash-photography-post-day-10

Hello @tingtong12! You are fabulous!


command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!

Hello @yameen! You are great!


command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!

Coin Marketplace

STEEM 0.20
TRX 0.14
JST 0.029
BTC 67443.68
ETH 3234.73
USDT 1.00
SBD 2.65