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
-4
votes
1answer
37 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
0
votes
2answers
105 views
How do you correct a corrupted index in Oracle?
I have this ORA error in our logs:
Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: ...
0
votes
1answer
54 views
How do you correct a corrupted index in Oracle? [duplicate]
I have this ORA error in our logs:
Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921)
ORA-01110: data file 8: ...
0
votes
0answers
68 views
MySQL loses connection
I think we've got a corrupt table in this situation. A website with a Drupal setup we host shows the following error:
General error: 2006 MySQL server has gone away: SELECT expire, value FROM ...
5
votes
2answers
272 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
1answer
289 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 <>
...
1
vote
0answers
74 views
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB
I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query:
SELECT * FROM ...
3
votes
1answer
179 views
How to recover data around corrupted data in table? [closed]
I have a SQL Server database with some corrupted data unrepairable via DBCC CHECKDB in a table. I can get many of the rows before the corruption out - but how do I get the rows after the corruption ...
0
votes
1answer
65 views
View dropped, now shows as table “in use”, can't drop
I have a view on a MySQL/MyISAM setup, then the underlying table had a column dropped, and made that view invalid.
I tried dropping the view so I could recreate it, then MySQL said it was a table ...
1
vote
1answer
105 views
What would cause Mysql database entries to be truncated to 253 characters?
Randomly seeing database entries truncated to 253 characters on a php site and can't figure out why or if it could be malicious or a corruption issue. Any thoughts would be appreciated.
5
votes
1answer
4k views
Repairing corrupt SQL Server database backup?
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 ...
4
votes
4answers
25k 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 ...
2
votes
1answer
293 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 ...
0
votes
1answer
232 views
MySQL: Can't find record in tablename
After crash:
mysql> repair table lot_not_sold;
+------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | ...
1
vote
0answers
1k 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 ...
5
votes
1answer
607 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, ...
3
votes
1answer
127 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
...
6
votes
3answers
452 views
Attempt to fetch logical page (5:65424) in database 2 failed
I am getting 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 ...
2
votes
2answers
410 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 ...
4
votes
1answer
2k 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 ...
1
vote
2answers
259 views
Consistency errors for a SharePoint database
When I check my database (SQL Server 2008 R2, Windows Server 2008 R2, SharePoint 2007 DB) with the command:
DBCC CheckDB
I get 12 consistency errors (see below).
Is the only way to fix it with ...
2
votes
1answer
400 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:
...
2
votes
2answers
901 views
mysql 5.5 corrupt - missing temporary table
One of our mysql instances crashed and failed to start:
120422 10:04:13 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './databasename/#sql-29f6_45.ibd'!
...
1
vote
1answer
2k views
ora-01410 invalid RowID sporadically in a select statement
I have a select that looks up some data by a join. The system runs Oracle 10.02g and the select looks like this
SELECT distinct t1.crit
FROM table_name1 t1
INNER JOIN table_name2 t2
ON t1.crit ...
1
vote
1answer
178 views
SQL Server Database Corruption Problem [closed]
I have developed a simple App in Microsoft VB.Net 2008 in which I have implemented database connectivity with SQL Server 2000.
After 4 to 5 executions of the program I often find my database goes ...
1
vote
1answer
216 views
Consistency errors in SQL Server 2000
I have SQL Server 2000 and ever since upgrading from SP2 to SP4 random errors began happening. Mostly overflow errors, sometimes in SqlDateTime and sometimes in data type numeric.
For example, ...
2
votes
2answers
208 views
How do I recreate a deleted logfile on an Oracle database?
For my database assignment we were looking into "database corruption".
I was asked to delete the second redo log file, which I have done with the command: rm log02a.rdo this was in the ...
2
votes
1answer
1k 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
2answers
832 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 ...
1
vote
1answer
3k views
How do I fix this corrupted page?
My database is in simple recovery mode. One page got corrupted and I only have backups created using simple backup.
When I run this:
DBCC PAGE ('myDB', 1, 952663, 3)
I get:
DBCC PAGE error: ...
0
votes
1answer
163 views
Salvaging data from corrupt tables PostgreSQL
Am in the process of salvaging very crucial data from a corrupted database.
Am getting the following error from a very crucial table
ERROR: invalid page header in block 94206 of relation ...
5
votes
1answer
570 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 ...
2
votes
2answers
838 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 ...
2
votes
1answer
101 views
MySQL REPLACE appears to corrupt data
For reference, this issue was posted on StackOverflow.com before coming here.
In MySQL I am running multiple REPLACE queries to update hardcoded URLs in a database. Queries look like this:
UPDATE ...
7
votes
2answers
734 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 ...
2
votes
2answers
1k views
FoxPro DBF Index Corruption
We are running a pretty popular application in Russia and other CIS countries through a pretty old accounting system called BEST. It's all built on FoxPro (not Visual Foxpro) DBF/CDX tables. It's open ...
0
votes
0answers
61 views
Will ADS resolve our VFP index corruption issues?
I just came across Advantage Database Server (ADS) and its supposed use for Visual Foxpro Legacy programs.
We have been developing our accounting and payroll solutions in VFP and its DBF databases ...
2
votes
2answers
944 views
An inconsistency was detected
Am running asp.net application.Am searching records.if i click the view button i got this error,
an inconsistency was detected during an internal operation in
database(database name) on ...
1
vote
1answer
353 views
SQL Server 2005 query erroring with message 7105, slot for LOB data type node does not exist
SQL Server 2005 sp3 Standard on 64-bit Windows Server 2008
inconsistently receiving an error that seems to indicate corruption
select *
from some_table
where text_field like ‘%the fox did not go ...
1
vote
1answer
90 views
Logical page error while attempting to insert data
I am getting the following error while trying to insert a row in a table:
Attempt to fetch logical page (1:12032) in database 19 failed. It
belongs to allocation unit 72057594069450752 not to ...
5
votes
2answers
796 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?
9
votes
1answer
2k 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 ...
2
votes
1answer
167 views
When do you remove entries from a write-ahead log (WAL)?
If I understand correctly, when a user updates a database record and commits the transaction the commit() call will block until the following steps are done:
Database documents the change in the ...
3
votes
1answer
1k 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 ...
0
votes
1answer
225 views
How to avoid table crash?
Couple of days back I had a table with 7GB of data and it was showing 63MB of overhead in phpMyAdmin and I mistakenly started its optimization and after working of more than 40 mins it corrupted the ...
12
votes
1answer
711 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) ...
