Questions tagged [crash]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
20 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
36 views

Mysql on Ubuntu crashing periodically [duplicate]

I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day . Here is the logs that I found in /var/log/mysql/error.log: 2021-02-23T08:35:08.249856Z 18 [Note] ...
1
vote
1answer
45 views

MySQL crashed suddenly

MySQL seems to crash suddenly but recovered in around 2minutes. I am running on Ubuntu 18.04 (16vcpu, 32GB RAM). I dont know what caused it. Here is my.ini [mysql] default-character-set=utf8mb4 [...
0
votes
1answer
22 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
23 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
46 views

postgres cluster: Crash of master crashes the replicas too

Environment: Postgres version: 9.6 Cluster of 3 servers, with Patroni and etcd Scenario: When index of tables were started with 16 parallel requests (on a 16CPU machine), postgres on the master ...
1
vote
2answers
97 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 ...
0
votes
1answer
147 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....
1
vote
0answers
72 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 ...
0
votes
0answers
106 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 ...
3
votes
1answer
70 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 ...
1
vote
4answers
98 views

Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus

Warning up front: unfortunately I'm limited to using SQL*Plus on remote site, with no other tools available. This is Oracle 12c (12.2.0.1.0) Standard Edition running on Windows Server 2012R2. Over ...
0
votes
1answer
30 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, ...
4
votes
1answer
2k 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 ...
0
votes
0answers
148 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
295 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
362 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
56 views

Mariadb times out on startup after system reboot

This is continued from: https://stackoverflow.com/q/55071021/8644833 Mariadb shuts down after running for a minute or two. If I remove Mariadb and reinstall (keeping my databases), everything works ...
0
votes
1answer
322 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
4answers
400 views

Group Replication plugin crashes MySQL 8.0

Problem description: INSTALL PLUGIN group_replication SONAME 'group_replication.so'; results in ERROR 2013 (HY000): Lost connection to MySQL server during query Specs: MySQL version: 8.0.13 ...
0
votes
2answers
300 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 ...
3
votes
2answers
4k views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
1
vote
2answers
252 views

Why do uncommitted transactions rollback instead of redo after a crash in ARIES?

Since all actions within a transaction are idempotent in crash recovery algorithms like ARIES that use write-ahead logging why do we rollback after a crash during an uncommitted transaction to get ...
20
votes
5answers
3k views

Can SQL Server's crash resilience be improved?

We have PCs running SQL Server (2008 SP4 and 2016 SP1) which regularly lose power. Obviously, this sometimes leads to (index) corruption of the SQL Server database, which we need to restore afterwards....
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 ...
0
votes
1answer
402 views

mysqli::query(): (HY000/1194)

I have a server on Azure with a MySQL database, we have two apps there and sometimes we get this error on the code: Warning: mysqli::query(): (HY000/1194): Table 'noticia' is marked as crashed and ...
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 ...
5
votes
2answers
25k views

Won't start: InnoDB: Corrupted page … Tablespace was not found

After a server crash (Ubuntu 16.04), when I try to start Mysql (Mysql 5.7) using innodb_force_recovery=0 it doesn't start and error.log shows: InnoDB: Checksum mismatch in datafile: ./...
3
votes
2answers
17k views

Mysql Workbench crashing when connecting

I have created an user i intend to give access to one db only. But when i try connecting with him, the program crashes. When i connect with the root user, it works. create user 'test'@'localhost'; ...
2
votes
1answer
449 views

Effect of over allocating shared_buffers

I have a 9.6 PostgreSQL RDS instance that I am tending to, but did not initially configure, and have been struggling with two different symptoms: the system (a db.r3.2xlarge w/ 61GB memory) would ...
1
vote
2answers
843 views

How to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)

I'm running MySQL 5.7 with 1GB of innodb_log_file_size on CentOS 7 x64 and I can't change the value of that parameter right now. In the case of crashes, it takes about 20 minutes to recover, but ...
1
vote
1answer
2k views

MySQL memory usage slowly increasing then crash - what's causing this? [duplicate]

So I have a Server that's constantly receiving 30k clicks/day. However, in the meantime does certain insert/update/select cronjobs as well. My server has 4CPUs, 8GM RAM. Using MySQL 5.7.18 + PHP. I ...
2
votes
2answers
1k views

Running MySQL in virtualbox with data dir on shared folder sometimes results in data corruption

I'm trying to move our development environment onto a vagrant box (virtual machine using Oracle virtualbox). Currently I'm stuck on one problem: The environment needs a MySQL server and some ...
2
votes
1answer
9k views

MySQL Crashed - InnoDB

Im using mysql 5.5 All of my Tables are in innoDB. Today my app went down and the mysql was unable to start. Here are my findings. The manual page at http://dev.mysql.com/doc/mysql/en/crashing....
1
vote
0answers
111 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
votes
1answer
37 views

Mysql crashes on fresh installation

I try to run mysqld and here's the dump I get: https://pastebin.com/TCk2YWQN I tried re-installing mysql, but the same thing happens. Just running mysql returns ERROR 2002 (HY000): Can't connect to ...
-2
votes
2answers
2k views

Rootcause Oracle database crash due to open connections

We have a Windows 2003 server with a Oracle 11g DB installed and running a Java backend application that mines and inserts data onto the DB. The data is then distributed with PHP via a web server ...
1
vote
2answers
294 views

Mysql configuration and power failure

I'd like to know if there are certain configurations of Mysql that should be considered to keep the effect of the power failure as low as possible. Which configuration points should be noted and what ...
2
votes
0answers
539 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-...
4
votes
2answers
1k views

MySql: Frequent crashes on server with substantial resources

My MySQL server running the latest version of MySql on Ubuntu 16.x keeps crashing once or twice a day. Sometimes it repairs itself fairly quickly (10 minutes). Sometimes I have to reboot and do an ...
6
votes
1answer
1k views

Worker threads issue: How to read this crash dump, and what to do about it?

Our production SQL Server froze up yesterday. Had to kill the windows process to get it to restart. Microsoft SQL Server 2016 (SP1-CU1) (KB3208177) - 13.0.4411.0 (X64) Jan 6 2017 14:24:37 ...
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
2k views

Mysql Crash SIGSEGV signal 11, recovered after killing apport

My mysql instance (ver 5.6.33) on AWS ( r3.4xlarge CPU Cores : 16 , RAM : 120 GB , filesystem : XFS ) is crashing with signal 11 . The instance is EBS optimised with EBS for storage. At around 9:04 ...
1
vote
2answers
3k views

MySQL crash/restart during mysqldump

General: Standalone MySQL-5.5.43 in OpenVZ on ProxMox-3.4-6/102d4547 (Debian, 2.6.32-39-pve). Container uses 18Gb of RAM and 100Gb of disk. This container runs this service more than a year. There's ...
0
votes
1answer
479 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
708 views

Mysql MyIsam tables get corrupted

I am facing the myisam tables get Corrupted frequently but I don't know exact root-cause for this problem. However I will do Repair/MyIsamchk --auto-repair whenever the table gets corrupted. Please ...
1
vote
1answer
2k views

MySQL keeps crashing

MySQL keeps crashing randomly - recent errors in error logs says this 160626 21:50:42 [Warning] IP address '113.108.21.*' could not be resolved: Name or service not known 160626 22:42:57 [Warning] IP ...
1
vote
2answers
2k views

mysqld is terminated because the system is low on memory; what to do?

I did recently a site migration; during that I had to erase all plugins and the reinstalling only the minimum as the site was causing the server to crash (A Vps with 1gb of ram), the most problematic ...
1
vote
1answer
2k views

ERROR 1091 (42000): Can't DROP 'PRIMARY'; on “mysql_upgrade”

I updated MySQL from 5.5.50 to 5.6.31 on a Centos 6.8 box with Plesk 12.5.30. Using those steps. The upgrade was successful but I ran into trouble with mysql_upgrade. I had to rebuild the permission ...
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 ...