The crash tag has no wiki summary.
0
votes
0answers
21 views
InnoDB data back in 3 months after OS shutdown
I've got an interesting issue last week that after shutting down an instance of mine, all data were back in 3 months (like a big rollback), even though there is no sign of crashing, recovery crash ...
0
votes
0answers
87 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 ...
0
votes
1answer
38 views
MySQL server crashed.
Help! I managed to crash MySQL last night. I am on a Mac using the native version that came with Mountain Lion. I was upgrading from 5.5 to 5.6. I have followed instructions in this forum to delete ...
-1
votes
1answer
42 views
best database for a real estate system [closed]
Which is the best database suits for a real estate system.
Considering the storage space, security, crash recoveries, speed etc.
There will be around 1000 fields and trillions of rows!!!
6
votes
1answer
222 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 ...
1
vote
0answers
114 views
SQL Server keeps crashing [closed]
I have had SQL Server 2012 on my server for about 6 months. Over the last few weeks, a problem has developed, whereby the SQL Server stops functioning, and any attempt to connect or query returns the ...
1
vote
0answers
82 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 ...
5
votes
1answer
665 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, ...
2
votes
1answer
307 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 ...
3
votes
1answer
559 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 ...
7
votes
1answer
325 views
SQL Server 2008 R2 corrupted after changing MAXDOP
My SQL Server 2008 R2 doesn't work after changing the MAXDOP parameter on instances.
I have 6 instances located on the same physical server and I changed MAXDOP from 1 to 2 on 5 instances. After ...
0
votes
1answer
262 views
mysqld crash: is it a bug? [closed]
MySQL cluster forum doesn't seem to be very frequented these days, so I hope I get more help here.
I got the following error on several Windows machines with 32G RAM (using Server version: ...
1
vote
1answer
570 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 ...
5
votes
1answer
3k 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 ...
7
votes
1answer
2k 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 ...
