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
1 answer
1k 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 ...
2 votes
2 answers
1k views

SQL Server database has corruption, but displays no errors

We have an extensive database of tables. I moved over a table from our dev db to our production db using a program called SQL Compare. I just copy paste the SQL it produces into Management Studio and ...
0 votes
1 answer
1k 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 ...
1 vote
1 answer
75 views

What is the way to handle corruption in db having simple recovery model?

A database in simple recovery model cannot have log backups. In this situation what is the way to handle corruptions reported by dbcc checkdb without data loss? The documentation says: Use the REPAIR ...
3 votes
1 answer
194 views

Finding all the index corruptions in the entire Postgres DB

There is DB with unknown amount of corrupted unique indexes. Currently I discover them one by one when I try REINDEX DATABASE CONCURRENTLY <db_name>, handle the specific duplication violation (...
0 votes
2 answers
151 views

mysql table tables_priv index is corrupted and the best possible way to repair it

I am using MySQL with XAMPP. For sometime now I keep getting a server unavailable error and upon digging deeper I noticed that my mysql.tables_priv table index is corrupted (ARIA Database Type). I ...
1 vote
1 answer
454 views

Orig DB = No Corruption, Backup/restore = Corruption?

We are setting up offline DBCC CHECKDBs on an offline server so we can still do our checks, but not interfere with production. When we backup the Master DB and restore it (even directly on a local SSD ...
1 vote
2 answers
439 views

Database corruption on VM shutdown

We moved a SQL Server database to a virtual machine in Azure. Since the database only contains historical data and does not have transactions anymore we want to turn off and turn on the VM on a ...
0 votes
1 answer
142 views

Shrink data file corruption risks?

Are there any risks of data file corruption resulting from shrinking sql data files?
1 vote
2 answers
62 views

My backup failed DBCC CHECKDB. Now what?

Assume the following: I have a database on a production server. I do not regularly run DBCC CHECKDB on it. I regularly take full, dif, and transaction log backups on my database. As is good practice, ...
8 votes
1 answer
1k 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 ...
0 votes
2 answers
583 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
1 answer
568 views

PostgreSQL data corruption tools?

Are there any techniques/tools/methodologies for investigating row level corruption within a PostgreSQL table? Most proposed solutions on this forum boil down to: try doing a VACUUM FULL to rebuild ...
3 votes
3 answers
4k views

database corruption

The database is corrupted and there is no recent backup, Error from DBCC CHECKDB Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type ...
0 votes
0 answers
47 views

Getting PANIC: could not open file "pg_wal/0000000100000038000000DE": Operation not permitted in production. How to solve this?

We are getting below mentioned logs in our production postgresql 10 database. We faced a downtime due to the same error and postgresql wont start. We re-initialized the data directory, restored the ...
8 votes
1 answer
2k 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
1 answer
487 views

DBCC Check DB fails due to operating system error 665

We have a SQL Server 2017 Standard version where recently the CHECKDB is failing with the operating system error 665. The fragmentation level of the disk drive is 0% as it is automatically ...
0 votes
1 answer
600 views

Restoring SQL Server DB trans log files error

I am getting error when restoring DB trans log files. Running RESTORE VERIFYONLY FROM DISK = xxxxxx is returning a message The backup set on file 1 is valid However when running RESTORE LOG [...
1 vote
1 answer
814 views

Mysql service stops with [ERROR] InnoDB: CORRUPT LOG RECORD FOUND

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with MySQL version 10.2.43-MariaDB. All of a sudden database stopped working. Mysql service never comes up on start ...
4 votes
2 answers
7k 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 ...
1 vote
0 answers
73 views

Foreign key constraint wrongly gives the error in mariadb

We are using AWS RDS for mariadb. There are several tables out of which I am mentioning two which are causing the issue: Table 1: PRODUCT_OFFERING Table 2: CHARACTERISTIC Related by foreign key as ...
0 votes
1 answer
317 views

No catalog entry found for partition ID in database 7

I would like some help to fix the database problem. I went to restore a database and I couldn't, so I executed DBCC CHECKDB (N'DATABASE_NAME') and the following result is displayed: CHECKDB found 0 ...
1 vote
1 answer
100 views

Cassandra 3.11.15 corrupting SSTables during cleanup

After we upgraded to Cassandra 3.11.15 from 3.11.14 we began to find that some small number of SSTables became corrupt when we ran cleanup. We have tried running a scrub on the corrupt SSTables but ...
4 votes
2 answers
12k views

FATAL: catalog is missing 1 attribute(s) for relid 2662

I have a server with PostgreSQL9.1-903 (Windows 7 Professional). After a power cut my database is inaccessible (I presume that the database is corrupted). The postgreSQL service starts but the ...
2 votes
1 answer
19k 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 ...
0 votes
0 answers
191 views

Mariadb index creation on large table leads to corruption

I am trying to create an index for a very large table called reception_edges_denorm (200GB) in MariaDB. The table has 4,916,267,670 rows and the following schema : src_trs_id: bigint(20) ...
0 votes
1 answer
262 views

Fix invalid checksum in database that causes pg_dump to fail

I have a Postgres 9.6 database that is corrupted. The hardware it was running on went bad, and there is at least one corrupted page in the DB. When running pg_dump I get the following error: pg_dump: ...
1 vote
1 answer
415 views

How to fix table with corrupt rows

I was inserting records into a table, when I suddenly got disconnected from the DB server When I tried doing a row count on the table, I got a fatal error 824 I tried DBCC CHECKTABLE and it indicated ...
0 votes
0 answers
58 views

Slave database is ok but get corrupted when promoted as master

I have had a problem with a PostgreSQL database that is replicated on several machines. On the master server, I had requests that failed with missing chunk number 121 for toast value 146485 in ...
0 votes
1 answer
127 views

MariaDB Power Outage Issue

We have a desktop application on Windows OS that installs with MariaDB server 10.4.10. Sometimes the client loses power and after restarting of PC MariaDB database becomes corrupted and Windows Server ...
2 votes
2 answers
412 views

Recovery attempt for database corruption of catalog, corruption of internal tables

The issue was noticed when we ran dbbc checkdb. EDIT: I looked up altering system tables and was successful in deleting the internal table from sys.sysschobjs$ from its id. https://www.sqlskills.com/...
0 votes
1 answer
82 views

What is the difference between dbcc checks and suspect pages table in terms of data page corruption?

Dbcc checkdb returns errors if it detects corruption on data pages. Similarly the suspect pages table hold corruption info of data pages. What is the difference between dbcc checks and suspect pages ...
0 votes
1 answer
36 views

Mysql MYISAM force operating on a crashed database

Is theres a way to forcibly operate on a database that crashed (even if it's not possible through mysql cli at least a way to remove the dirty bit that marks it as crashed by editing with an editor). ...
0 votes
1 answer
139 views

MS SQL corruption repair manually investigate pages

I have a corrupt MS SQL db. We do have a good backup prior to the issue we had. All is now fixed. However, we are left with a corrupt database, with 2 weeks of good data in it. The issue is we can't ...
2 votes
2 answers
248 views

Why can a database file become corrupted if it's copied while in use?

Many sources online claim that copying a database file while it's in use can corrupt that file. But I couldn't find any explanation for why this is an issue, and I'm confused about it. Copying a file ...
1 vote
0 answers
79 views

There are Suspect Pages but DBCC CHECKDB returned no errors?

As the question states, there are 3 suspect pages on a database, but when I ran DBCC CHECKDB (DB, REPIAR_REBUILD), after almost 4 hours, it completed with no errors. I know suspect pages might not ...
0 votes
0 answers
142 views

Dealing with Corruption

I started getting Error 823 alerts from my SQL Server. When I checked SQL Server error log, I found lots of this: A read of the file 'path\to\my\file.ndf' at offset 0x00000d5f850000 succeeded after ...
1 vote
1 answer
596 views

Unable to Repair MariaDB Database Because It Is Read-Only

A recent incident corrupted my MariaDB database and I'm trying to repair it. I followed the instructions on the MariaDB site and successfully started my database at innodb_force_recovery=5. I have ...
2 votes
2 answers
1k views

Database keeps crashing every few hours

The MariaDB server will crash every few hours(it's been a week so yeah, dozens of crashes), and restart automatically. In 2 previous crashes it went as far as the server not starting up again, and I ...
0 votes
1 answer
333 views

PostgreSQL duplicate non-null values despite unique constraint

I have a database with a unique constraint in a field that is apparently being ignored. That table also includes two rows with the same value for that field, but somehow querying by that value only ...
0 votes
0 answers
37 views

Is a negative index_id in the innochecksum results normal?

We're running MariaDB 10.1.38 on Linux with innodb_file_per_table on. When I run innochecksum -v -S /var/lib/mysql/ibdata1, the summary results show as below. I'm concerned about that last line with ...
1 vote
1 answer
78 views

Can't drop and recreate FK in SQL

I have a DBCC check that will always fail with the following error: Msg 8992, Level 16, State 1, Line 2 Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=517752334,key_index_id=1) of ...
1 vote
1 answer
721 views

MariaDB Doesn't Work After System Crash

I'm using MacOS Monterey 12.6.1 with Homebrew 3.6.6 and MariaDB 10.8.3 The OS crashed out of nowhere and rebooted itself. After the reboot I was unable to connect to the database: Can't connect to ...
0 votes
0 answers
96 views

Corruption in backup but valid checksum

We have corruption in one of our full backups but I can't find an explanation how it happened. The server is a SQL Server 2019 Enterprise edition (CU17) with 5 databases in an AG. The backups are ...
3 votes
3 answers
1k views

Why does data get corrupted in "large" text files - Reasons to use database

I am just starting to learn about databases and using mysql. I read that databases are more reliable than having large ascii text files and that ascii text files are more prone to corruption as they ...
3 votes
1 answer
470 views

Table Consistency Errors

We have encountered database corruption / consistancy issue in one of our database tables, which I'd like to run past the community. Disclaimer: This is a MSSQL database we (the DBA team) have ...
4 votes
2 answers
898 views

What is the SQL server mechanism to ensure that the page being restored isn't corrupted?

Assuming dbcc checkdb shows corruption on 1 page. Suppose I want to fix this by restoring the corrupted page only. So I go to the Restore page UI, click the button to find the corrupted page, enter ...
-3 votes
2 answers
193 views

cant attach mdf file because of suspect mode

Please I need Help i cant attach Mdf Database , As last time it was suspect , i made detach and i cant now attache it again . and i recieve this message An exception occurred while executing a ...
2 votes
1 answer
3k views

Detect corrupted Indexes

How to detect corrupted indexes in PostgreSQL? When I pull data from a column with primary key attribute in a table with where condition, it brings incomplete results. Likewise, when I sort with order ...
5 votes
2 answers
381 views

Random Error 824 - All Environments

We have been experiencing seemingly random error 824 on our DEV/QA/PROD SQL 2017 Enterprise servers. The servers run nearly identical code ingesting identical daily files via an ETL process into our ...

1
2 3 4 5 6