Delayed Upvotes: SegFault in MySQL Server
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
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
!thumbup
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
!thumbup
Hello @tingtong12! You are fabulous!
command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!
My post from Yesterday and Today -
https://steemit.com/hive-152587/@iamjohn/focus-on-alternative-investments-that-can-help-improve-portfolio-diversification-my-future-financial-plan
https://steemit.com/hive-119463/@iamjohn/achieving-stability-through-personal-finance-taking-advantage-of-time
The vote didn't arrive in both of them.
!thumbup
Hello @iamjohn! You are superb!
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 upvote on my post . Could you please check that. Thanks
https://steemit.com/hive-176825/@yameen/splinterlands-daily-focus-rewards-or-completed-3-focus-chests-in-silver-league-or-10-04-2022
!thumbup
Hello @yameen! You are great!
command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!