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

Filter by
Sorted by
Tagged with
1
vote
1answer
760 views

SQl Server: Corrupt Logs Files: Why?

I have a SQL Server 2008r2 database server running on Windows Server 2008. On this server every week the log of at least one database throws this error: Backup detected log corruption in database ...
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 ...
1
vote
2answers
615 views

Do I face corruption issues?

I have found out the msdb.dbo.suspect_pages has 15 entries. 14 of those are last updated in 2014 and of type 7 ("Deallocated"). One entry is of type 1 (823 or 824 error) with a count of 1 and last ...
2
votes
0answers
890 views

How to get records from corrupted ibd file

Ok, in the last two days I thoroughly searched through the internet, and found multiple propositions on how to handle this, but nothing worked so far. Here is what the problem is and what I tried so ...
3
votes
1answer
216 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 ...
0
votes
1answer
852 views

Can the view “v$database_block_corruption” get refresh after the corrupted block get fixed?

I have a table that contain several corrupted data blocks and I use the stored procedure reside in the “DBMS_REPAIR” to mark the data blocks as corrupted data blocks so that I can keep query to the ...
2
votes
0answers
9k views

Cannot continue the execution because the session is in the kill state

When I query a table in my database, I am getting the error message as below. Msg 596, Level 21, State 1, Line 0 Cannot continue the execution because the session is in the kill state. Msg 0, ...
0
votes
1answer
930 views

Restoring corrupted bak file

Our server & Backup data got crashed and we had a recovered the data using the recovery Tool. Currently I am having .BAK Files. When we are trying to rebuild the DB using the recovered .bak file ...
2
votes
1answer
158 views

Hi, I have sitution where my Database has corrupted but some how we have recovered it but while restoring the .bak file it shows an error

this is the error show while restoring the corrupted file .. Pls help if any one know Thanks
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, ...
1
vote
1answer
62 views

Is it OK for the database to be completely overwritten for many times?

A simple and maybe too amateur question, but: is it good for a table on the database to be consistently (for example, every day) completely overwritten? I get regularly (every day) the data for the ...
0
votes
1answer
524 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 ...
0
votes
1answer
812 views

index-*.wt: encountered an illegal file format or internal - WT_PANIC: WiredTiger library panic - aborting after fassert() failure

One hypervisor went down for 7 seconds and afterwords I couldn't start mongod. See error. Replicaset with 3 nodes. I use /var/lib/mongodb-mms-automation/mongodb-linux-x86_64-3.2.8/bin/mongod. I fixed ...
1
vote
1answer
865 views

After Oracle 11gR2 restore & recover database, “ghost” NOLOGGING corrupt blocks

I recently restored (from full, level 0 cold backup) an ARCHIVELOG database & recovered it to a point in time about 24 hours after backup. I ran RMAN validate and numerous blocks turned up in V$...
0
votes
2answers
204 views

PostgreSQL 8.1 Corruption Issue

I have an old Postgres server that some major corruption problems on one of the databases. We first noticed the issue when the drives started to fill up on a database that should have plenty of space. ...
2
votes
0answers
2k views

mysqldump show Table doesn´t exist when doing LOCK TABLES

Our server had power outage and after start some of mysql tables was inaccessible. I tried many things but nothing helped and currently i am at freeze point. I used command : mysqldump database ...
1
vote
0answers
846 views

'mysqlcheck' hangs over a database

Sometime ago I noticed my WordPress sites wont load. I found the problem with MySQL. The server I am running on is a VPS server with: Debian 8.1 MariaDB - Ver 15.1 Distrib 10.1.14-MariaDB 2048 MB ...
1
vote
1answer
359 views

Repair with data loss did not fix index corruption. What now?

A few months ago we migrated our SQL Server 2014 database to a virtual environment. Soon afterwards, corruption started showing up in indexes, causing all sorts of trouble. I've made repairs using ...
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 ...
5
votes
1answer
3k 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, ...
0
votes
1answer
2k views

Postgres Error: could not read block 167593 in file… SQL state: XX001

When creating a new column on a table, I'm getting the following error: ERROR: could not read block 167593 in file "pg_tblspc/16384/PG_9.4_201409291/16386/157223695.1": read only 0 of 8192 bytes SQL ...
2
votes
1answer
882 views

Attach corrupted database

In a little C# tool, I use an a mdf file to save my data. The file became inconsistent, which isn't really a problem as there only a few changes since my last backup. Anyway, I would still like to ...
0
votes
0answers
2k views

SQL Server 2012 service will not start after each server reboot - corrupt SQLBOOT.DLL

When I tried to start the service manually from a command prompt, I get a dialog stating: Your SQL Server installation is either corrupt or has been tampered with (Unable to load SQLBOOT.DLL (HRESULT ...
4
votes
1answer
153 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 ...
0
votes
2answers
190 views

How does one create a notification upon corruption being found during Automatic Page Repair under database mirroring?

I read: https://msdn.microsoft.com/en-us/library/bb677167(v=sql.120).aspx#UnrepairablePageTypes But, I am unclear how I can set up a notification so I am aware when this occurs. Any advice?
2
votes
1answer
777 views

How to check a database for a specific page

I am working on repairing a database, I have about 80 errors that I need to fix and there seem to be three types of problems that I don't know how to fix other than doing a REPAIR_WITH_DATA_LOSS. I ...
3
votes
2answers
4k 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 ...
0
votes
1answer
648 views

Preventing MySQL index corruption

I'm having a recurring issue with a MySQL database where one index in particular has been getting corrupted. Originally I saw a corruption event about every 2-3 weeks and this week I've seen it happen ...
2
votes
1answer
847 views

Msg 8905: DBCC CHECKALLOC Error Messages

We recently experienced a database corruption and run integrity checks. DBCC CHECKDB returned a lot of consistency errors and 2 allocation errors. We have fixed consistency errors by moving data, ...
0
votes
1answer
675 views

Oracle: dbms_repair outputs zero errors about known corrupted object

In an Oracle 9i instance we have a datafile with corrupted blocks as evidenced by the log generated by the exp utility: . . exporting table IMPORTANT_TABLE EXP-00056: ORACLE error ...
1
vote
1answer
839 views

Real corruption?

We have a production database for Solarwinds Orion Network Performance Monitor in which we discovered corruption in a MapStudioFiles table following DBCC CHECKDB errors. CHECKDB Output: Msg 8961, ...
1
vote
0answers
344 views

Three Vital Postgres Columns Corrupted

I run a small website which uses a Postgres database. There are regular back ups based on the amount of traffic we have every few days but there was a recent surge of activity just before a power cut ...
3
votes
1answer
768 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
668 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 ?
2
votes
0answers
552 views

Database Corruption - object in sys.parameters does not have a matching row in sys.objects

I'm using SQL Server 2008 R2 and I have a strange db corruption. I ran dbcc check db and the output is: Attribute (object_id=1096186) of row (object_id=1096186,parameter_id=1) in sys.parameters ...
6
votes
2answers
713 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 ...
1
vote
2answers
4k views

Logical consistency-based I/O error

I am using SQL Server 2008 R2. My server got accidentally shutdown. After restarting it, I am not able to access my database. I am getting the following error for a few tables: SQL Server detected ...
0
votes
2answers
129 views

Update row count on corrupt table

I have a corrupt table, 1 dodgy page about 1.6 million rows into a 2.9 million row table. I want to attempt this: ALTER DATABASE [CorruptDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DBCC CHECKDB (...
0
votes
0answers
1k views

“mysqld got signal 11” error

I have a MySQL 5.6.22 InnoDB database and just now, suddenly out of nowhere, when I try to start it up using /etc/init.d/mysqld start, I see this error in the error log and the server won't start up : ...
3
votes
0answers
190 views

VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping

Log shipping has been working for a very long time, but now and then it breaks. I found it sometimes breaks (causes the transaction log to become corrupt and I get the message : "media family on ...
0
votes
0answers
113 views

DBCC REPAIR_REBUILD adds rows

SQL Server 2008 R2, an update corrupted my table somehow, likely to do with the storage subsystem. I am on a dev database, so aren't overly concerned about losing data, it isn't business critical. But ...
1
vote
1answer
428 views

BACKUP Detected Corruption in the database log

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...
2
votes
1answer
162 views

Troubleshoot corruption in SQL Server Database [closed]

I have been asked by my interviewer "How do you troubleshoot corrupted data in SQL in SQL Server 2012?"
1
vote
1answer
1k views

Postgres corrupted index on update

Sometimes, when doing an update on a specific table record, i get this error: index "myIndexName" contains corrupted page at block 468 Please REINDEX it. But on the next update it works, without ...
2
votes
0answers
981 views

Data Corruption - ERROR: could not open segment 2 of relation

I am getting the below error for a production database. I am new to PostgreSQL databases. I need help to get this fixed. 2015-10-28 10:25:04,154 [monitor-thread-pool1-thread-6] ERROR [org.hibernate....
6
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 '...
2
votes
2answers
8k views

Corrupted InnoDB table, mysqlcheck and mysqldump crash server

I manage a Percona XtraDB Cluster that uses a network storage with a flapping connection. Periodically we experience a high iowait with crashes and remount of the fs in read-only. Replacing the ...
2
votes
0answers
229 views

Old records disappearing after upgrade from 9.4.1 to 9.4.4

I recently upgraded from 9.4.1 to 9.4.4. Since then millions of rows have disappeared from several tables containing historical data. The severity of data loss seems to be directly proportional to ...
2
votes
1answer
139 views

Dealing with corruption: file-level backup vs. pg_basebackup

The wiki on corruption recommends immediately taking a file-level backup of your database by stopping the postmaster and using tar, but I was under the impression that using pg_basebackup was a better ...
0
votes
0answers
336 views

Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file

I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server. I am using sql server 2014. This is where you can see the routine I use to run the backups: How ...