Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [crash]

109 questions
40
votes
1 answer

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 GB of memory). Apache kept demanding more…
Teemu Leisti
  • 503
  • 1
  • 4
  • 9
29
votes
4 answers

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 restarted the entire server and MySQL started correctly…
Patrick
  • 4,329
  • 7
  • 29
  • 28
23
votes
5 answers

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. I am aware that SQL Server is not designed for…
Heinzi
  • 3,210
  • 2
  • 32
  • 43
21
votes
1 answer

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…
SteLoe
  • 362
  • 1
  • 9
12
votes
3 answers

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: ./panel_financiero_v2/kpis_analytics.ibd, Space ID:93, Flags: 33.…
Felipe Alonso
  • 223
  • 1
  • 2
  • 6
10
votes
2 answers

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 error: 59.9kB assword: 59.9kB ERROR 145 (HY000) at…
quanta
  • 1,006
  • 9
  • 22
  • 36
10
votes
3 answers

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'; GRANT ALL PRIVILEGES ON sbb2_test.* To…
HelloWorld
  • 103
  • 1
  • 1
  • 5
9
votes
2 answers

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 upgraded recently from v3.1 to 3.6, we have been…
Pete Storey
  • 281
  • 1
  • 2
  • 4
9
votes
1 answer

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, I get the following error: ERROR 2006 (HY000):…
Andrew
  • 93
  • 1
  • 1
  • 6
6
votes
2 answers

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. Given this situation how can I configure MySQL…
Farrukh Arshad
  • 169
  • 2
6
votes
1 answer

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 Copyright (c) Microsoft Corporation Enterprise Edition…
Shaul Behr
  • 2,963
  • 8
  • 34
  • 42
5
votes
2 answers

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 running now: 0 131128 12:16:35 mysqld_safe mysqld…
Tola Odejayi
  • 201
  • 1
  • 3
  • 8
5
votes
1 answer

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 solve the problem. We are on a db.r5.large…
Nigel McLaughlin
  • 59
  • 1
  • 4
4
votes
1 answer

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 waiting for... I assume the background rollback for…
Dmitri Zyuzin
  • 75
  • 1
  • 1
  • 5
4
votes
1 answer

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 .idb file within a DB. ... I wanted to test…
Tom Geee
  • 327
  • 2
  • 6
  • 10
1
2 3 4 5 6 7 8