Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [corruption]

Data corruption refers to errors in computer data that occur during writing, reading, storage, transmission, or processing, which introduce unintended changes to the original data

25
votes
1answer
2k views

PostgreSQL DELETE FROM fails with `Error: attempted to delete invisible tuple`

The error Trying to delete tuples containing invalid timestamps with DELETE FROM comments WHERE date > '1 Jan 9999' OR date < '1 Jan 2000' OR date_found > '1 Jan 9999' OR date_found < '1 ...
23
votes
4answers
43k views

MySQL relay log corrupted, how do I fix it? Tried but failed

A MySQL v5.1.61 relay got corrupted when the machine suddenly shut down. I tried to fix it but it didn't work. — How do I fix it? Did I do something wrong? As far as I've read, corrupted MySQL relay ...
16
votes
1answer
2k views

What types of corruption can DBCC CheckDB miss?

This question was prompted by this earlier post and my having a database filed away for future investigation that was restored following: BACKUP 'BrokenDatabase' detected an error on page (1:123456) ...
14
votes
2answers
2k views

DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition

TL;DR: I've got an unfixable corruption in an indexed view. Here are the details: Running DBCC CHECKDB([DbName]) WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS on one of my ...
13
votes
1answer
499 views

Backup Compression Causing Corruption In SQL 2017 TDE Database

On SQL Server 2017 (CU3), whenever I enable backup compression on one of my TDE databases, the backup process always corrupts a specific page in the database. If I run the backup without compression, ...
12
votes
1answer
12k views

PostgreSQL Database Data File Integrity Check

When running a PostgreSQL database system how do I know my database as a whole has 100% integrity? Basically how do I know if my data files and pages are all 100% good with no corruption? In the ...
11
votes
1answer
6k views

How to find corrupt page in SQL Server 2008

I know I can execute a DBCC CHECKDB and get a status of my database. Questions How can I find if there is some corrupt data page into my database? If an error is throwndue to page corruption, where ...
11
votes
1answer
437 views

Backup detects corruption, but CHECKDB does not

I have a database where when I run the backup command BACKUP DATABASE [MyDatabase] TO DISK = 'G:\Backup\MyDatabase_01_01_2018.bak' WITH NOFORMAT, NOSKIP, COMPRESSION, INIT, BUFFERCOUNT = ...
9
votes
6answers
22k views

Attempt to fetch logical page (5:65424) in database 2 failed

I am getting the following SqlException on calling a stored procedure: Attempt to fetch logical page (5:65424) in database 2 failed. It belongs to allocation unit 7349876362857938944 not to ...
9
votes
1answer
18k 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, ...
8
votes
1answer
15k views

Master database is corrupt, instance won't start - what are my options?

Help! My master database is corrupt, I can't even bring the SQL instance online! What are my options to get my server back up? I do have a backup of master, but the MSDN page "Restoring the master ...
7
votes
1answer
3k views

Msg 2534 : DBCC CHECKDB allocation errors

We recently moved our intranet production database from an SQL Server 2008 to an SQL Server 2008 R2 brand new server. The backup Job have been failing since migrating, due to DBCC Errors (Check ...
7
votes
2answers
13k views

Fixing corrupted Firebird database

I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. When I try to do a backup I get: database file appears corrupt <> ...
6
votes
2answers
4k views

SQL Server 2005 database corruption. Advise

I have encounter some database corruptions in the past but I knew which object has hit the road. In this situation I run a DBCC CHECKDB against a problematic SQL Server 2005 database and I get the ...
6
votes
2answers
671 views

SQL Server Backup transaction error

Hi I am attempting to backup the transaction log file to setup mirroring in SQL Server I execute BACKUP LOG CUSTOMER TO DISK ='K:\JonDB\CUSTOMER.trn' WITH INIT GO And I receive Processed 6587361 ...
6
votes
1answer
2k views

How to get online the database which has missing/corrupted FILESTREAM files?

I've corrupted the files related to FILESTREAM in a database. The .mdf and .ldf files are still intact, but when I try to get the database online, it complains, saying that the files related to ...
6
votes
2answers
2k views

ANALYZE TABLE..VALIDATE STRUCTURE runs forever

So, as I've mentioned before, I am a SQL Server DBA/Consultant who is helping out a customer with their Oracle databases. Mostly, I've been able to figure out what I need to and work through things ...
6
votes
2answers
2k views

How can I corrupt a table in SQL Server?

I have to write a program that detects corrupted tables and tries to repair them. For this I need to corrupt tables regularly. Is there anyway to corrupt tables manually?
5
votes
3answers
99k views

SQL Server 2008 R2 (Suspect) mode - how to repair?

I have SQL Server 2008 R2 database in Suspect mode. I tried to fix it running this query: EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(’yourDBname’) ALTER ...
5
votes
1answer
1k views

How to repair corruption for “Possible chain linkage problem.”

I have large table with 15 000 000 record and suddenly Select Top stopped working. I use MS SQL Management Studio. This is not working, the query return 0 records: SELECT TOP (10) [Id] ...
5
votes
1answer
4k views

Attaching a MDF with a missing LDF [duplicate]

Possible Duplicate: How do I attach a database in SQL Server? I was given an MDF for a database, no backups and not LDF that I was asked to attach the database to a SQL server. I get the ...
5
votes
1answer
17k views

Repairing corrupt SQL Server database backup? [closed]

I'm looking at a problem for someone who was backing up to a cloud-based service. Apparently the customer's server crashed while it was performing some maintenance on the cloud-based service's ...
5
votes
1answer
2k views

InnoDB “corruption”

I use: 5.1.63-0ubuntu0.11.10.1 Apache/2.2.20 (Ubuntu) MySQL client version: 5.1.63 The system is continuously displaying the following error during reading data from a MySQL database: InnoDB: ...
5
votes
1answer
2k views

DBCC CHECKDB errors

I am having some issues with my SQL Server database. When I run this: select * from dbo.Entity where Oid='191FAF30-4729-4145-8106-60E34A8E164C' ...it spits out the following error. Msg 823, ...
5
votes
3answers
2k views

How to run OPTIMIZE TABLE on a 3-node cluster?

I've my hands on a 3-node Percona XtraDB Cluster where, according to mysqlcheck, some tables are corrupted (some indexes contain the wrong number of entries): mydb.mytable Warning : InnoDB: Index '...
5
votes
1answer
694 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
4
votes
2answers
418 views

How I can corrupt a data base page and again restore the same

I want to corrupt a database page, and restore the same page. How do I do that?
4
votes
3answers
18k views

Cannot access Properties page of a database

I'm in the process of decommissioning a database server and migrating the databases from one server to another. I was attempting to get the the properties of the database and received a SQL Error ...
4
votes
2answers
4k views

Recover PostgreSQL database from WAL errors on startup?

I'm trying to set up an OpenStreetMap server on an Ubuntu 12.04 machine using the Ubuntu packages listed at switch2osm.org. I initially installed and set up everything using a Northeast US-only map ...
4
votes
3answers
2k views

How can I repair a TokuDB table?

I have a TokuDB table that works fine for most queries, but segfaults on others. I did a CHECK TABLE which indicated that the table had errors. However, TokuDB doesn't support REPAIR TABLE. How can I ...
4
votes
2answers
7k views

Optimize command issuing “'View is not base table” and “Corrupt” error messages

I have no experience with MySQL. My boss ran an optimize against a MySQL database. Against a bunch of views we got the message "tablexyz" is not BASE TABLE and the next has message is Corrupt ...
4
votes
2answers
3k views

Verify that postgres 9.3 db has no corruption

I have a postgres 9.3 db running on ubuntu server. About a month ago we've had some problems with the hardware on the server which was resolved by our VPS hosting company. The problem was resolved ...
4
votes
1answer
15k views

innodb_force_recovery when InnoDB corruption

When I start mysqld (in /etc/init.d), it failed with InnoDB: corruption in the InnoDB tablespace. What's the best innodb_force_recovery value to force mysqld to start? I have tried 4 and 6, but ...
4
votes
1answer
607 views

Database corruption: QueryStore internal table

This morning, the following email alert was received: DATE/TIME: 2/28/2018 9:26:42 AM DESCRIPTION: Attempt to fetch logical page (1:3948712) in database 9 failed. It belongs to ...
4
votes
1answer
140 views

MySQL Killed by OOM after Corrupted Database

One of our web-app servers recently had an issue where MySQL was taking more memory than we have physical RAM. This server has 64GB of memory and 8GB in swap, and MySQL was OOM-ed because it was ...
4
votes
3answers
26k views

unable to bring database online from recovery pending

I am trying to bring a SQL Server database online and accessible that is in Recovery Pending state. The SQL Server service uses an Active directory account that is a domain administrator and a ...
4
votes
1answer
2k 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
3answers
2k views

How to restore corrupted InnoDB tables?

We have a data loss: the MySQL database is dropped and we have to restore the tables from ibd files. The backup is too old so we have to undelete the deleted database files. Most of the tables are ...
3
votes
3answers
12k views

SQL Server Database is corrupted

Unfortunately hard disk of my system is damaged, now I recovered my database. But it cannot be attached again to SQL management studio 2005. The error is: myfile.mdf is not a primary database file. (...
3
votes
2answers
630 views

Is there a Maintenance Plan that checks my database for corruption?

Is there any way to make a maintenance plan check all my databases on a single instance? Is the maintenance plan Check Database Integrity Task enough ?
3
votes
1answer
720 views

Reattaching MDF files recovered from RAID 5

We had been running a SQL Server 2005 server for many years at our company when just recently, we ran into some trouble. The server was configured with RAID 5 and had one hot spare disk in the array. ...
3
votes
2answers
5k views

Trouble recovering data from corrupted PostgreSQL tables

I'm trying to recover my database after a recent corruption of the same. Now I have two tables that are really giving me trouble. When I do select count(*) One table returns: ERROR: could not ...
3
votes
3answers
1k views

Why does data get corrupted in “large” text files - Reasons to use database

I am just starting to learn about databases and using mysql. I read that databases are more reliable than having large ascii text files and that ascii text files are more prone to corruption as they ...
3
votes
2answers
3k views

Table Corruption Error

I have a problem with my SQL Server database. Today I opened it and saw an error – SQL Server Table Corruption Error. I don't know the reason for this error. I applied SQL Server Management Studio, ...
3
votes
1answer
186 views

PostgreSQL 9.1 runs into inconsistent data, but pg_dump corrects the problem?

We are running a PostgreSQL 9.1.20 with a database of about 50GB. All things works fine. After some days strange unexpected values appear in numeric columns, like negative or bigger values in ...
3
votes
2answers
3k views

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

Working through a database corruption issue. I am working on a copy in a development environment. Some were corrupt indexes in which case I just dropped and recreated it. These however are data ...
3
votes
1answer
500 views

An inconsistency in SQL Server 2008 R2

(could be) possible duplicate with An inconsistency was detected I have small table that returns from query UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-...
3
votes
1answer
6k views

SQL Server Rebuild/Reorganize Fragmented Indexes causes CRC error or consistency errors

In our test lab I've been experimenting with different jobs to keep our critical indexes from becoming too fragmented. I'm currently using the approach described here: sys.dm_db_index_physical_stats ...
3
votes
2answers
1k views

MySQL corruption even after full dump and re-import

We have a production issue where MySQL has started spitting InnoDB corrupt page errors and falling over. The error message seem to relate to indexes so I assume the data itself is ok and when I ...
3
votes
1answer
1k views

mysql Wrong bytesec: 0-0-0 at linkstart: 0

I have several MySQL (MyISAM) tables that have been corrupted. Running CHECK TABLE mytable returns: > +-----------------+-------+----------+----------------------------------- | > clldata....