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
2
votes
1answer
176 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
2k 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
1k 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....
7
votes
3answers
3k 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 '...
3
votes
3answers
10k 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
232 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
144 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
396 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 ...
0
votes
1answer
2k views

mongod 2.6 corruption (Assertion failure isOk() src/mongo/db/storage/extent.h 80)

I have been using mongo 2.6.0 for some time on 64-bit centos (with journaling enabled). One fine day when we were testing to insert a document to one of the collections, we started seeing data ...
1
vote
0answers
2k views

PostgreSQL 9.4.4 Crashing

We are having 9.4.4 version running on linux( PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit) which is crashing unexpectedly and coming ...
1
vote
1answer
268 views

Unable to load mysql dump file

I recently had to deal with migrating some servers over (rather was forced to by the hosting company) and we took too long to migrate our data so they did it for us. Unfortunately they just copied /...
2
votes
1answer
755 views

Postgres 9.2 - postgres - FATAL: XX000: relation mapping file “global/pg_filenode.map” contains incorrect checksum

We have a ~400GB Postgres database (v9.2.6) (running on CentOS 6.5) that had a problem with free space and with every command (ls, pwd etc) we were seeing a segmentation fault error. We were able to ...
0
votes
0answers
41 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
1
vote
1answer
1k views

MySql Innodb corruption recovery

I have a MySql database, just containing Innodb tables, that seems to have corrupted itself. It replicates to another server and it has corrupted that one too! The symptom is that I can restart the ...
1
vote
1answer
236 views

Should database directory and file access be restricted to only the db user?

I don't know exactly how to word this question and I haven't been able to find any specifics on it so apologies if it's a duplicate. I know that it's standard practice to have database server ...
1
vote
1answer
2k views

MYSQL crashes on XAMPP while working with drupal

Good day, just today morning i was using drupal to add some content, it crashed and mysql shutdown unexpectedly at xampp!! last thing i was doing was inserting a data into a field with "auto complete ...
0
votes
2answers
2k views

Clipper / DBF error

I'm not able to open a Clipper application (the app is 15 years old) because I'm getting : error dbfntx/1012 corruption detected Is there anyway to fix corrupted dbf files besides restoring from the ...
0
votes
0answers
1k views

Dropping a corrupt table in innodb_force_recovery 6

As often happens in mysterious shutdowns during large queries, things ran afowl with InnoDB on my XAMPP MySQL installation (Windows 7 x64). I rebooted and ran Startup Repair, then loaded MySQL to ...
1
vote
1answer
1k views

how to prevent an oracle block corruption from duplicating a database with a few nologging tables

I got a few data corruptions in a test db when I performed a duplicate from a production db where a few tables have the nologging option. Oracle support suggested to turn on the force logging option ...
0
votes
0answers
83 views

Mysql - too many Deletion - Insertion

I'm creating cron jobs for my OLAP system. I have a cron job that deletes the records from the summary table first and then insert the records in it again: Say Deleting 1 month records, and ...
3
votes
0answers
1k views

Receiving error when running DBCC CheckDB - multiple IAM pages

Running DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS results in this error: Table error: Multiple IAM pages for object ID 813245952, index ID 1, partition ID 72057594073972736, ...
1
vote
1answer
176 views

Possible to restore a damaged database's PRIMARY filegroup only?

I have a database (MyDatabase) with 2 filegroups, [PRIMARY] and [SECONDARY]. The [SECONDARY] filegroup has 2 datafiles, [DataFileA] and [DataFileB]. [DataFileA] is damaged (even after DBCC CHECKDB ...
2
votes
1answer
409 views

Very weird Innodb Corruption Issue

I'll try to keep this to the point. System: OPenVZ VPS, debian 6, 512 MB RAM, 50 GB HDD (25GB free) I have a mysqldump dump file (3GB), that was created when the innodb database was working fine. ...
3
votes
0answers
581 views

Database corrupt after restore and upgrade on another instance

We have SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) instances. There is a process of backup on SQL Server 2008 R2 and restore to SQL Server 2014. Everything was going fine, until ...
2
votes
1answer
6k views

CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object

Msg 8906, Level 16, State 1, Line 1 Page (1:99122) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:97056), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'. ...
2
votes
2answers
2k views

Detecting and fixing database corruption on SQL Server mirrored database

I’m new to my current company and we have a System Administrator but no DBA. In the past I’ve taken care of DBA related issues at other companies. I’ve run into and corrected database corruption in ...
-1
votes
1answer
181 views

full windows server backup with database files but not backed up through sql server

I am new to this and I have been backing up a windows sbs2011 server each night doing a full backup. The sql files are included but not backed up using sql backup program. Now one of the database ...
2
votes
0answers
510 views

postgresql 9.3 with Ubuntu 14.04.1 LTS throw 's ERROR: invalid page in block 105 of relation base/16385/17407

This is Ubuntu 14.04.1 LTS with postgresql 9.3 in production, Now i got this below error's in log. # tail -f /var/log/postgresql/postgresql-9.3-main.log 2015-01-08 14:10:16 IST CONTEXT: automatic ...
0
votes
1answer
59 views

Will canceling InnoDB compression that's already in progress corrupt data?

I have a 155GB table that is in the process of being compressed. ALTER TABLE $table_name ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; This compression has been running for a long time and is impeding my ...
0
votes
1answer
2k views

Corrupt DB for a noob

Please help me! I am not a DB admin, and I have been thrust into the role after taking a new job. I need as much step by step as you can give me... I've already done the dbcc checkdb(‘DB-NAME’,...
3
votes
0answers
2k views

How do I recover from MySQL InnoDB table/index corruption?

While trying to upgrade a database (in place) I got the following error. The server starts up and everything seems to be fine, except that the table mentioned in the message is no longer accessible. ...
4
votes
3answers
27k 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 ...
1
vote
0answers
738 views

mysqldump with --single-transaction seems to be “fixing” InnoDB tables with page corruption - why?

I'm trying to find out what exactly is happening here. I've been intentionally corrupting index pages in InnoDB tables, changing bytes in user record areas that actually contain information (largest ...
1
vote
1answer
103 views

How to guard against backup corruption due to spurious bit errors?

There's always a very small chance that a backup that was just written to disk is corrupted. Disks are not 100% reliable. Bits can be flipped with very low probability. I have seen that happen on ...
2
votes
2answers
3k views

how to resolve mssqlsystemresource.mdf corruption?

Desperate for help, but fearing the worst here :( Something crashed SQLSERVER 2005 this afternoon approx 3pm. Since then I have been trying to get running again. Original log file messages told that ...
3
votes
3answers
15k 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. (...
0
votes
1answer
492 views

How do I fix and prevent corrupted MySQL tables?

We have developed software that uses MySQL. After some months of usage, some of the database tables had been corrupted and need to be repaired. Because of the corruption,we are not able to create a ...
2
votes
1answer
9k views

How can I correct SQL Server Error 8928?

I received the following error message in an application running against one of my databases: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xfdff74c9; ...
0
votes
1answer
913 views

Database going to Suspect mode [closed]

I have a frequent problem, that is one of my databases goes to suspect mode. Many times I have recovered it with: ALTER DATABASE Your_Db SET EMERGENCY DBCC checkdb('Your_Db') ALTER DATABASE Your_Db ...
2
votes
2answers
6k views

DBCC CHECKDB Results: page ID contains an incorrect page ID in its page header

DBCC CHECKDB results for 'tablename': Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 1637580872, index ID 1, partition ID 72057596516040704, alloc unit ID 72057594048020480 (type ...
1
vote
1answer
770 views

Postgresql pgAdmin, count(*), max(pk_field) giving inconsistent results

I am running postgresql 9.3.4 on a Centos 6.5 server as a back end for a web app which I am currently load testing. Presently, if I visit the state table in pgAdmin, right click on "count", I get a ...
1
vote
1answer
520 views

Checking records consistency after mongorestore --noobjcheck

I had an HDD malfunction on a Mongo node. After running fsck and mongod --repair I was able to dump the needed collection with mongodump and move it to another server. However, some records appear ...
3
votes
1answer
2k 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....
1
vote
0answers
227 views

Corrupted Filesystem: Possible to restore databases from the contents of /var/lib/mysql?

Using CentOS 6.4 x64. Not sure what happened but somehow my VPS filesystem got corrupted and it is now in a permanent read-only state. I've been working with my hosting provider's sys. admin. but ...
0
votes
2answers
3k views

Error while taking backup in SQL Server

Before few month box of SQL has been crashed. We have almost database back with some tools and running application smoothly on it. But when i try to take backup of database at that time it gives error ...
1
vote
0answers
5k views

Possible schema corruption. Run DBCC CHECKCATALOG

Good Evening to all. I was working with sql server 2008. Thing i did: Actually i was noticed that the free space available in C drive reaches below 1 GB .So i thought to Club the D drive with C ...
3
votes
1answer
1k views

MyISAM : Should I be concerned by these warnings?

I restored some tables from recent Databases backups. Because Im supporting a legacy system that only uses MyISAM tables in their DBs, for backing up I used a little script that pretty much copies all ...
1
vote
0answers
508 views

CHECKDB Allocation Errors Msg 2576, could not repair, object id does not exist

I inherited a database that has no value in LastKnownGood. I ran repair allow data loss, says it was successfully repaired, but no change to the errors when I run checkdb again. In case it was a SQL ...
2
votes
2answers
13k views

Fixing a corrupt Log File in small downtime window

I am working with a client who has been receiving the following error from their Log backups of one of their SharePoint databases: Backup detected log corruption in database FOOPORTAL_SP2010_Config. ...
5
votes
2answers
21k 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 ...