Questions tagged [crash]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
39
votes
1answer
56k views

intermittent MySQL crashes with error “Fatal error: cannot allocate memory for the buffer pool”

Added on edit, 2013-05-29: Because this is a long question and discussion, here's a short summary of the question and the solution. I had problems running MySQL and Apache on a small Linux server (1 ...
28
votes
4answers
16k views

MySQL InnoDB crash post-mortem

MySQL crashed on me this morning. With the exception of the standard MySQL included databases everything I use is InnoDB. I attempted to restart the MySQL daemon but it failed twice. I then ...
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....
20
votes
1answer
514 views

Weird SQL Server instance crash on casting to numeric

While working with C# Entity Framework I noticed a crash of my SQL Server instance. I was able to track it down to this statement: SELECT * FROM dbo.[TestTable] where mpnr in (1099059904, 1038139906,...
9
votes
2answers
12k views

mysql.proc keeps crashing, cannot do a mysqldump?

Due to some problems with InnoDB, I'm going to dump all databases to a new server: mysqldump -E -R --all-databases | pv -b | mysql -u root -p -h new.server The dump process stopped with ...
9
votes
1answer
24k views

MySQL INNODB corruption after server crash during concurrent truncate command

My server crashed today I think due to a concurrent truncate table command on one of our INNODB tables. The server could be restarted, but after it starts up, everytime I try to issue an SQL command, ...
9
votes
2answers
11k views

How to trace SQL queries which are crashing SQL Server

We have a SQL Server 2008 database server (it happens to be running under MS Failover Clustering, but I don't think that is relevant here). Our application runs Hibernate for DB access, and since we ...
6
votes
2answers
26k 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: ./...
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 ...
5
votes
2answers
28k views

MySQL crashes randomly with “Database was not shut down normally” message in log

I am having an issue where, for no apparent reason, my MySQL server crashes and has to restart. Essentially, the error log has entries like this: 131128 12:16:35 mysqld_safe Number of processes ...
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 ...
4
votes
1answer
16k views

Shut Down MySQL during InnoDB rollback after crash

I am puzzled once again. We had a server crash last night during some huge queries. Upon restart in the morning MySQL went into recovery mode. I needed to shut down the MySQL service and it is ...
4
votes
1answer
3k views

Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included

We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large InnoDB tables, over 50+ gigs, randomly after a few hours of ...
4
votes
2answers
1k views

Configuring MySQL for Power Failure

I have an embedded device running a MySQL database with a web based application. The problem is when I shutdown my embedded device it just cuts off the power, and I can not have a controlled shutdown....
4
votes
1answer
3k views

MySQL 5.5 : (InnoDB) - Manually edited an .ibd file to test recovery, now entire MySQL installation is broken!

So I wanted to test MySQL recovery from Innodb corruption. file-per-table is enabled. I have a few test db's on the MySQL instance. I shutdown mysql. Manually edited/added random characters to an ....
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
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'; ...
3
votes
1answer
2k views

Passing NULL xml value to a certain CLR stored function crashes it when called in a certain way

Consider a CLR stored procedure that accepts an XML parameter and calls another stored procedure in the same schema: [SqlFunction(DataAccess = DataAccessKind.Read, IsDeterministic = false, ...
3
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 ...
3
votes
2answers
3k views

Oracle: Why is DBW terminating my Instance?

I was performing routine administrative tasks on an Oracle instance and I was not able to connect to it. I proceeded to do as follows to reach a diagnosis: I checked for Oracle processes in memory ...
3
votes
1answer
2k views

Oracle crashing on CentOS

Here is alert_XE.log: kkjcre1p: unable to spawn jobq slave process Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc: Process J000 died, see its trace file kkjcre1p: unable to ...
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
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 ...
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
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....
2
votes
1answer
2k views

Mysql shutting down during a mysqldump of a specific database

I have a server which is running Centos 6.6 with Cpanel. I have been attempting to do mysqldump backups on individual databases. All of the databases are under 5MB except for one. The database that ...
2
votes
2answers
8k views

Would increasing innodb buffer pool size prevent a mysql crash?

My server keeps running out of memory for mysql. I keep getting. 150708 3:39:09 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 258064 bytes) When I looked in my.cnf I saw that ...
2
votes
1answer
453 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 ...
2
votes
1answer
23k views

mysqld got signal 11 - it's my fault but how do I fix it?

I was copying the database tables from our production server to my dev machine, and in the middle of the transfer I found out users were being locked out of the system because the select had locked a ...
2
votes
1answer
875 views

What's the approach to figure out reason for mysql crash?

The database I'm using crashes a lot recently. And I can't find a decent way to dig into the issue. I looked into mysql error log, but don't know how to start. I know there was a "load data infile" ...
2
votes
1answer
5k views

MySql replication from 5.1 master to 5.6 slave keep crashing

I recently updated one of the replication slaves to mysql 5.6. After importing a recent dump from the master, I run mysql_upgrade with no errors. the database deamon started correctly with no error....
2
votes
1answer
2k views

Mongodb 2.6 Server crash and not restarting

We are using mongodb 2.6 with one Primary and 2 secondaries. One of the secondary has gone bad and not restarting. 2014-04-18T21:13:34.765+0000 [rsSync] replSet still syncing, not yet to minValid ...
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
1answer
371 views

Postgres reindex on crash folklore

I'm struggling with a problem of folk memory re Postgres. The folklore I am told that a long time ago in a galaxy far, far away (PostgreSQL 8.4 under Ubuntu 12.04), PostgreSQL frequently suffered ...
1
vote
4answers
101 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 ...
1
vote
2answers
261 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 ...
1
vote
2answers
855 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
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 ...
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 ...
1
vote
2answers
744 views

How to investegate MySQL crash on windows?

I have MySQL 5.6.19 running on Windows Server 2008 R2. I have 3 servers A, B, C Server A is a stand alone server. This server had data that can't be placed on SERVER B (ie. users information.) ...
1
vote
1answer
46 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 [...
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 ...
1
vote
2answers
296 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 ...
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
621 views

MySQL: Reducing amount of open files

So, I currently have a problem with my mySQL server opening far too many file handles. This requires me to restart to server each day, as otherwise, I get the infamous "errno 24, too many open ...
1
vote
1answer
256 views

Restore Postgresql data after hdd crash

My HDD crashed, so, I can't make a Postgresql backup. It seems that my data tables are OK (I can view the data via pgAdmin). However, when I run pg_dump I get this: pg_dump: Error message from server:...
1
vote
1answer
701 views

MySQL sudden restart

I have a strange issue with my MySQL server. It suddenly restarts. It's a rare but very big problem for me. This server is running as Master in Master-Slave replication. I'm using MySQL 5.6.16-1+sury....
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 ...