Questions tagged [crash]

The tag has no usage guidance.

29 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
3k views

AWS Aurora running out of freeable memory and crashing

We have an issue with our AWS Aurora MySQL instance running out of freeable memory and crashing as a result. AWS's response was to upgrade to a bigger instance, but I don't feel that will necessarily ...
3
votes
1answer
76 views

In PostgreSQL, if crashes during VACUUM, will it recover from a checkpoint that is before the frozen transaction ID of VACUUM?

When VACUUM starts, it will calculate a frozen transaction ID and freeze all tuples older than it. Will this frozen TXID be younger than the latest checkpoint? If this is the case, then when the ...
3
votes
1answer
2k views

MongoDB crashes with out-of-memory or is being killed by oom-killer

A two shards MongoDB database regularly crashes with out-of-memory error or is being killed by the oom-killer. The system runs on GCE Debian 9.4 with MongoDB v3.6.5, WiredTiger storage engine and ...
3
votes
0answers
1k views

Mongos process memory usage and crashes

So our MongoS instances use up A LOT of memory. More than even the shards and sometimes crash because of it. Cluster structure 3x mongos 3x mongod Shards 3x mongod Replicas (one for each shard) 3x ...
2
votes
0answers
544 views

MySQL 5.7 Crashing Every Few Days from Assertion failure

There's seems to be a lot of these sort of questions, all with varying error messages, but I seem to have found a relatively new one. There is a bug report here, https://bugs.launchpad.net/percona-...
2
votes
0answers
2k views

Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum

Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum. It happens on a specific database but spans multiple ...
1
vote
0answers
29 views

MySQL 8.0.24 Windows 10 crashes are resolved by reboot, why?

MySQL 8.0.24 on Windows 10 (10.0.18363.0) crashes near the same point when running a final results query, but only after data input queries with many more records have been run. A restart of the MySQL ...
1
vote
2answers
98 views

CPU High usage crashing our server

The server where my database is running is suffering from CPU spikes. We're having trouble identifying what is causing these CPU spikes, and consequently how to mitigate them. I've tried adding some ...
1
vote
0answers
78 views

MySQL router on server with tomcat memory leak

Memory is slowly used by mysql router. I am running mysql router version 8.0.20 (I found there was a memory leak on mysql router 2.1.2 but mysql router 8.x is newer) I have a 3 node single-primary ...
1
vote
0answers
146 views

MSSQL Linux Crashes with data files on EXT4 formated ZVOL Reason: 0x00000003

Reason: 0x00000003 Message: 0 == (m_PhysicalSectorSize % m_LogicalSectorSize) Stacktrace: 0000558d9d8c90c1 0000558d9d91ff08 0000558d9d8cd02c 0000558d9d8d0965 0000558d9d8cdc3b ...
1
vote
0answers
113 views

mariadb won't restart after storage space induced crash

I have a large mariadb instance running (400 gb or so). Due to running out of storage space it crashed. I went ahead and resized my volume (I am using AWS), and went to restart the service service ...
1
vote
0answers
822 views

1 Node crashed of 3 node mariadb galera cluster

Heading I have three nodes Galera cluster MariaDB, a node in June 4, 2016 suddenly crash, the following is log error Red Hat Enterprise Linux Server release 6.5 Server version: 5.5.39-MariaDB-wsrep-...
1
vote
0answers
3k views

MySQL installation broken after Windows crash - how to repair MySQL and recover data?

recently my PC powered off abruptly for no apparent reason, leaving my Windows 7 installation severly damaged. I can still log onto the machine, but tons of Windows system files have been corrupted ...
1
vote
0answers
392 views

Database instance keeps restarting

From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
0
votes
1answer
27 views

MySQL8 crash recovery

My dev MySQL-8 server crashed last night and would not restart. The error is: [ERROR] [MY-012646] [InnoDB] File ./ibdata1: 'open' returned OS error 71. Cannot continue operation I tried the classic &...
0
votes
1answer
25 views

postgresql crash in master node with streaming replication

We have a master/slave postgresql cluster with streaming replication and pgpool. Versions in both postgresql servers are. postgres: 9.4 OS: Debian GNU/Linux 8 (jessie) PGPOOL server: version pgpool: ...
0
votes
0answers
27 views

Warning in MySql Command line client

I have installed MySQL on my laptop but when I open the command line client it gives the warning, and when I type the password and hit enter, it suddenly crashes. please help me what should I do.
0
votes
1answer
170 views

mysql (mariadb) won't start after power outage (MacOS)

/var/log/system.log says (over and over) Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1 Oct 13 19:34:01 Data-Server com.apple.xpc....
0
votes
0answers
107 views

MySQL says “check that your my.cnf matches the ibdata files”. How?

After trying to copy some columns of big tables (500k records) into another one, my MySQL dockers (5.7) images stoped. Trying to start it again I get the following error: [ERROR] InnoDB: Trying to ...
0
votes
1answer
31 views

mongodb 2.4.1 instance shutdown without log

I am running mongodb in a replica set of 3 nodes (no sharding). But since 5 days the secondary instance shuts down intermittently, once in 2 days. Log does not indicate any event related to shutdown, ...
0
votes
0answers
150 views

MariaDB Cluster node crashes after upgrade

I have a 3 node MariaDB galera cluster running. It was running fine until I updated one node from MariaDB 10.3.14 to 10.3.16 (the other nodes are still on 10.3.14). Since then, this one node regularly ...
0
votes
0answers
303 views

Mysql 5.7.25 crash on first query to corrupted innodb table

Setup: Ubuntu 18.04.1 LTS 4.15.0-34-generic #37-Ubuntu Docker: 18.06.1-ce build e68fc7a mysql:5@sha256:e47e309f72c831cf880cc0e1990b9c5ac427016acdc71346a36c83806ca79bb4 mysql --version = Ver 14.14 ...
0
votes
1answer
371 views

MySQL 8.0.15 starts normally but any connection hangs

I dropped a large table (80G) Friday morning and got a crash: InnoDB: ###### Diagnostic info printed to the standard error stream 2019-04-19T18:48:55.445507Z 0 [ERROR] [MY-012872] [InnoDB] Semaphore ...
0
votes
1answer
324 views

Mysql 5.7.20 crashes after jemalloc installation

Recently i faced memory leak issue in one my mysql instance (5.7.20) where eventhough allocated buffer pool size was 50% of the RAM, but mysqld memory utilization was constantly pegging at 90%. I ...
0
votes
2answers
301 views

MySQL 5.7 intermittent max connections errors

I’m having a problem with MySQL 5.7 with « too many connections » causing services crashes. The max_connections system variable is set at 1000 and on average there are +/- 250 sessions/thread, so it’s ...
0
votes
1answer
111 views

Constant MysQL crashes. How to fix?

MysQL is frequently going down. Error logs contain: [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it | 149 occurrences [ERROR] Native table 'performance_schema'....
0
votes
1answer
483 views

Safe method to rename a crashed myisam table

I have a large MyISAM table which has crashed. Repairing the table will take some time. The table only INSERTed to and SELECTed from, never updated. To allow the application to continue working, ...
0
votes
1answer
132 views

Procedure to replace a BDR server

I have set up a 2-node PG 9.4 system with BDR. Replication works great. Now, let's suppose that one of the two nodes needs to be replaced. In fact, let's be more specific. Let's say that the node on ...
0
votes
0answers
2k views

slave mysql server crash : mysqld got signal 6

Hi I am trying import a mysql logical backup file on server A.Server A and B are in master slave configuration and both running on same unix server.slave is running while import is in progress.Due to ...