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
0answers
14 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 ...
5
votes
3answers
709 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 ...
2
votes
3answers
492 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 ...
-1
votes
1answer
23 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 ...
2
votes
2answers
4k 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
426 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, ...
0
votes
1answer
34 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
1answer
199 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 ...
0
votes
0answers
52 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
0answers
38 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
1answer
345 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
2answers
181 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?
0
votes
2answers
200 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. ...
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 '...
10
votes
1answer
17k 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
37 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
21 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
17 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 ...
5
votes
1answer
728 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
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 ...
2
votes
1answer
19k views

Database 'msdb' cannot be opened. it has been marked suspect by recovery

I'm using SQL Server 2008. I got suddenly today an error while i was accessing a database from Visual Studio. The error is: Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. ...
0
votes
0answers
113 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
30 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 ...
23
votes
4answers
45k 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 ...
2
votes
0answers
136 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 ...
2
votes
1answer
1k views

Mysterious disappearing consistency errors in SharePoint DBs

We have a pre-production SharePoint SQL server which threw an 824 error yesterday evening on the Content DB. As part of my investigation today, I ran DBCC CHECKDB on this DB and it came up clean. ...
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 ...
0
votes
1answer
626 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 ...
3
votes
3answers
13k 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. (...
2
votes
1answer
80 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
208 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 ...
9
votes
6answers
23k 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 ...
-1
votes
1answer
97 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
325 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
59 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
564 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
96 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 ...
11
votes
1answer
531 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 = ...
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 ...
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] ...
0
votes
1answer
98 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, ...
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 ...
0
votes
1answer
396 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 ...
13
votes
1answer
552 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
281 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) ...
1
vote
0answers
605 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 ...
1
vote
2answers
679 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 ...