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
0
votes
1answer
67 views

Error 23 on transaction log backup, full backup works fine

I have a database with the database files on the E: drive, and logs files on the D: drive. I'm getting the following error when trying to run a transaction log backup: Read on "D:\LOG\AOA_Log.ldf" ...
0
votes
0answers
24 views

MySQL Service won't start with error [ERROR] InnoDB: Trying to access page number 4294963199 in space 0

My MySQL installation on Ubuntu 18.04 crashed and now won't start. The error log says Trying to access page number 4294963199 in space 0, space name innodb_system, which is outside the ...
-1
votes
1answer
27 views

Is there a possibility of data corruption/lost when inserting large blob data from one table to another table in the same database?

I am trying to determine if data corruption/lost is possible when moving large data from one table to another in the same schema. I am new to programming and database is not my forte. Anyway I've ...
0
votes
1answer
38 views

Is it possible to restore a database from corrupted .mdf file?

I know that the answer of the question may vary depending on what exactly is broken in each .mdf file - only looking for advice if there is another way to approach this. So, I have received some bad ...
0
votes
0answers
39 views

Corrupted Access Database

I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules. I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that ...
0
votes
0answers
54 views

End of file reached. Error 38 in SQL. Passes verification checks

Having issues restoring a database in SSMS, error 38. The databases are transferred up to google via their Drive API. Download it on my side and has error. If I transfer it through teamviewer ...
0
votes
1answer
44 views

In a replication setup, does corrupted data also gets replicated?

Say one of the tables got corrupted, will that corrupted table still get replicated to the other DB? Or, will the replication stop to prevent the other DB from being corrupted too? Note: Question is ...
1
vote
0answers
25 views

How to get the corrupted table from a log file in hex?

I'm running a Magento 2 site, everyday we have a MySQL shutdown because of some corrupted data, we don't know the table causing the issue, this is what the error logs shows: Version: '5.7.26-...
0
votes
0answers
20 views

After upgrading from PG 9.3 to 10 indices became corrupted

So recently I was upgrading the database in production from Postgres 9.3 to 10. In addition to upgrade, we wanted to move the database to another machine. I know, doing it "in place" would be easier ...
0
votes
0answers
137 views

MariaDB corrupted after attempting full backup with mariabackup

I have Mariadb installed on a Raspberry Pi with a simple star schema for logging data that comes in on a Modbus server. Everything was running fine for about a month and a half until one day I was ...
0
votes
0answers
31 views

MS Access constant corruption issues since DFS, moved off DFS server, and still corrupting

Company has legacy MS Access databases that are being replaced by PERN (Postgres, Express, React, NodeJS) web app that is just now getting built. That is to say they still need to use the legacy ...
2
votes
0answers
141 views

Errors during CHECKDB

We have a db which reports errors when trying to do a backup: Starting to dig in, the first thing that was suggested was to run DBCC CHECKDB. I've been trying to run that all day now, and googling ...
0
votes
1answer
685 views

How to repair corrupted PostgreSQL pg_toast error

The hard drive on my PostgreSQL 9.5 server died, but I managed to recover most of the data. I've restored the database to a solid state hard drive, and I can access most of the data. However, when I ...
2
votes
1answer
81 views

PostgreSQL: Issue with a corrupted GiST index on ll_to_earth

I'm facing something that seems like an index corruption issue on a table that stores about 120k entries. Each entry has a latlon and this latlon is indexed using the ll_to_earth GiST implementation: ...
0
votes
0answers
215 views

What steps can I take to recover MySQL InnoDB databases when forced recovery fails?

Coming here from StackOverflow because I saw a similar question being closed as off-topic on there. I have corrupted my local MySQL instance in my development environment. I was running a set of ...
0
votes
1answer
374 views

InnoDB ibdata1 corrupted, innodb_force_recover not working

I think I have checked every post in the internet. Thing is my MySQL (MariaDB) won't come up and after much testing I have seen it is because of the InnoDB files. I have tried with different ...
0
votes
1answer
226 views

sp_MSforeachdb Continue on failure when running DBCC CHECKDB

I have the following maintenance script DECLARE @sql NVARCHAR(30) = 'DBCC CHECKDB(?)' EXEC sp_MSforeachdb @sql This checks every database for corruption. I have run this on my test server where I ...
-1
votes
1answer
105 views

Is mysql using some kind of auto repair due to “check table” warnings?

Today i noticed a "strange" behaviour of MySQL when using "CHECK TABLE" on a crashed table. First i got a warning like "Size of datafile is: * ... Should be: *" but i could still "insert into / select ...
1
vote
1answer
356 views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
2
votes
1answer
67 views

InnoDB: Getting rid of a phantom table

I was playing around on a test server and i actually removed both "frm" and "innodb" files of particular table. Ok - I tried creating that table again but got information that table already exists and ...
1
vote
1answer
637 views

error code 3417 - after installing CU for SQL SERVER 2016 SP1

I am getting below error message after installing cumulative updates for SQL Server 2016 Sp1. The description for Event ID 7024 from source Service Control Manager cannot be found. Either the ...
1
vote
0answers
101 views

Unable to drop table/database when using innodb_force_recovery = 3

I'm attempting to follow several guides to recover a corrupted database, by setting innodb_force_recovery to 3, dumping the database, dropping the database, and then importing it back in. I'm able to ...
1
vote
1answer
38 views

What may cause MyISAM index corruption?

I've had an error message telling about index corruption on the .myi file Reparing the table fixed the issue This table is accessed with select only, so what is likely to corrupt indexes ? CREATE ...
5
votes
1answer
2k 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] ...
11
votes
1answer
548 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 = ...
2
votes
3answers
528 views

Postgres cannot be restarted after disk ran out of space

My HD ran out of space while a postgres was running. I had to kill postgres and freed some space. Now I am not able to restart postgres with the following error message: LOG: listening on IPv4 ...
0
votes
1answer
102 views

corrupted Oracle 11g database

At a client site with a development Oracle 11.2.0.3/linux DB power outage and crash - no archivelog mode - no backups - Don't know how this was even running select file#,substr(name,1,70) name, ...
5
votes
3answers
736 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 ...
0
votes
1answer
415 views

ORA-31114: XDB configuration has been deleted or is corrupted

ORA-31114: XDB configuration has been deleted or is corrupted How to recreate the XDB configuration? Do I need to remove the existing component first? By the way I can't run UTLRP scritp for the ...
1
vote
1answer
2k views

LogWriter: Operating system error 1117

I am getting these errors on my dedicated server because of which database goes into recovery mode. I have seen the following error in SQL server error log file: 2018-01-20 05:32:19.83 spid7s ...
13
votes
1answer
572 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, ...
1
vote
1answer
295 views

Disabling SKIP_CORRUPT after using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS

Recently I was involved in recovering data after several blocks in production DB got corrupted. Disclaimer: I'm by no means a competent DBA, but rather a PL/SQL developer with quite a bit (I guess) ...
4
votes
3answers
3k 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 ...
1
vote
2answers
715 views

Running MySQL in virtualbox with data dir on shared folder sometimes results in data corruption

I'm trying to move our development environment onto a vagrant box (virtual machine using Oracle virtualbox). Currently I'm stuck on one problem: The environment needs a MySQL server and some ...
0
votes
1answer
2k views

How to rebuild SYSAUX corrupted tablespace?

I have database 10g 32-bit windows without backup. I want to migrate full database to 11g, but the SYSAUX tablespace is corrupted. Can I rebuild the SYSAUX tablespace?
1
vote
0answers
2k views

missing chunk number 0 for toast value x

our RAID10 failed miserably and we now have a corrupted psql database. I copied the main/ folder and now are working with a copy trying to recover data. I have progressed far enough to have made an ...
2
votes
3answers
912 views

DBCC CHECKDB REPAIR_REBUILD taking too long

I'm administrating a database that became corrupt and I tried to do a REPAIR_REBUILD. The server on this installation is a bit weak but the database isn't that big (roughly 2GB). It's been running ...
3
votes
0answers
152 views

Corrupted tables in postgresql: invalid relnatts, attrelid and typrelid

When trying to upgrade my databases from Postgresql 9.5.4 to 9.6.3, two tables are corrupted. $ /usr/local/Cellar/postgresql/9.5.4_1/bin/pg_catcheck -h localhost -p 5434 db_concepts_2 notice: ...
1
vote
1answer
242 views

SQL Server Corruption & Replication

I have a situation where storage was ripped out from under SQL Server. After running BBCC CheckDB I have received an "Extent (1:269886) in database ID 34 is allocated by more than one allocation ...
4
votes
2answers
4k 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 ...
1
vote
0answers
616 views

MySQL MyISAM corrupted table repair failure

My MyISAM tables got corrupted(I guess due to fs corruption) filesystem_cstor.MDS_DATA warning : Table is marked as crashed warning : Table is marked as crashed error : Key in wrong position at ...
0
votes
1answer
68 views

Frequent Corrupt Indexes in MySQL 5.6. Is this a MySQL bug?

I´m having problems with mysql indexes with INNODB getting corrupted. Initially I solved it by rebuilding the tables but now the tables are to large to rebuild, and i´m tired of mysql not showing ...
1
vote
3answers
699 views

Frequent Corrupt Indexes in MySQL 5.6. Is this a MySQL bug?

I´m having problems with mysql indexes with INNODB getting corrupted. Initially I solved it by rebuilding the tables but now the tables are to large to rebuild, and i´m tired of mysql not showing ...
0
votes
0answers
368 views

Inherited Database with Corruption and a Bad Checksum

We have inherited a corrupted database 'DBName', with no good backup available to us. The corruption apparently happened some months ago. We have tried a few thing: DBCC CHECKDB(DBName); --Shows no ...
4
votes
2answers
502 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?
2
votes
1answer
1k views

Finding or confirming absence of corrupted data in MongoDB

Background I have a directory full of .gz files that were produced by mongodump on a mongod running MongoDB 3.4.x, which I am writing into a different instance running MongoDB 3.4.2 using ...
1
vote
2answers
747 views

Export data using bcp to deal with corrupted data

I am getting consistency errors while running DBCC CHECKDB on a table that has corrupted rows on SQL Server 2014. I am running into corruption errors after the first 30,000 rows (total 1.4 million (14 ...
1
vote
0answers
106 views

Consistency Errors running CHECKDB on a couple of tables in SQL Server 2014 [duplicate]

While running DBCC CHECKDB I am getting consistency errors on a couple of tables in SQL Server 2014. I have tried REPAIR_REBUILD and rebuilding indexes on those tables but these are not helpful to ...
10
votes
1answer
18k 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 ...
0
votes
1answer
419 views

Drive with ldf files failed and some databases left in recovery pending status

We are keeping mdf and ldf files on seperate drives of a physical machine. One of the disks forming the drive for ldf files failed. Some of the databases that had their ldfs on that drive are now in "...