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
274
questions
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 ...