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
286 questions
7
votes
2
answers
731
views
Microsoft SQL Server | Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)
Details:
I am running Microsoft SQL Server 2022
Microsoft SQL Server 2022 (RTM-GDR) (KB5046861) - 16.0.1135.2 (X64)
Oct 18 2024 15:31:58
Copyright (C) 2022 Microsoft Corporation
Standard Edition (64-...
3
votes
1
answer
153
views
500 million is becoming a horrible negative number on replicas
I need some assistance understanding what looks like a corrupted value in replicas.
Here's the scenario: 1 primary database, 8 read replicas. Database is MySQL, deployed with Amazon RDS. There is a ...
- 89
3
votes
1
answer
338
views
How to recreate corrupt innodb tables with innodb_file_per_table?
MySQL refuses to start up and I was only able to start in read-only mode using innodb_force_recovery = 6. Every answer I've found on this topic suggests making a backup, deleting ibdata and ...
- 810
0
votes
0
answers
24
views
Commit Log Corruption & Cluster Resilience in K8ssandra on GKE
I'm Eran Betzalel from ExposeBox. We're migrating our big data infrastructure from Hadoop/HDFS/HBase VMs to a modern stack using GKE, GCS, and K8ssandra. While the move is exciting, we're currently ...
- 101
0
votes
1
answer
110
views
How can I know that it is safe to failover a Basic Availability Group?
Today, I learned the hard way that you cannot corruption check a Basic Availability Group's secondary. Given this limitation, how can I know that it is safe to failover a BAG? For all I know, the ...
- 1,248
3
votes
2
answers
610
views
Why is running database integrity checks in parallel beneficial if you are following best practice on Enterprise Edition?
On Enterprise Edition and Development edition, database integrity checks (e.g. DBCC CHECKDB) can run in parallel. According to best practice, backups should be tested regularly. So if I'm following ...
- 1,248
0
votes
1
answer
160
views
How to fix corrupted index "item order invariant violated" in PostgreSQL?
amcheck reports following error:
select bt_index_parent_check(34465);
ERROR: item order invariant violated for index "admin_access_rights_pkey"
DETAIL: Lower index tid=(282,71) (points to ...
- 1,180
0
votes
0
answers
119
views
mariadb-backup consistently produces corrupt backups after 11.4 upgrade
We recently upgraded mariadb 10.3 to 11.4. Upgrade went surprisingly smoothly, but now backups taken using mariabackup are consistently corrupted.
We use mariabackup to create replicas using the ...
- 1
0
votes
1
answer
52
views
Why my mysqldumps are corrupted?
Every night laravel scheduler runs "mysqldump -h $dbHost -u $dbUsername -p$dbPassword $dbDatabase > $path/$filename" command through exec() functon.
And sometimes the dump is corrupted in ...
- 1
0
votes
2
answers
111
views
corrupted system files, how to recover databases for a fresh install?
newbie here. Our system files got corrupted and we no longer can access the control panel or phpmyadmin, but we do have access to SSH and FTP, and to my understanding, you can backup databases locally ...
- 1
0
votes
1
answer
238
views
Deleting table with metadata corruption on SQL Server
We are trying to recover from an event and struggling with some issues that have been created within our database. One of our tables (Users) seems to have gotten corrupted somehow, as we get this ...
0
votes
1
answer
90
views
What is the minimum level of DBCC CHECKDB needed to check full-text indexes?
I have a database containing an unreasonably large full-text index. DBCC CHECKDB WITH PHYSICAL_ONLY takes about 25 minutes on this database, but DBCC CHECKDB WITH DATA_PURITY, EXTENDED_LOGICAL_CHECKS ...
- 1,248
3
votes
3
answers
1k
views
MariaDB Crashes Every Time Restarted
OSX Sonoma, OSX Monterey
Latest MariaDB from Homebrew (11.4.2-MariaDB, client 15.2 for osx10.17 (x86_64))
MariaDB won't start every time I restart the brew service or restart the computer. I ...
- 31
-1
votes
1
answer
119
views
Does anyone have a resolution for this: metadata is inconsistent error when restoring a backed up database to a higher level SQL server [closed]
The corruption does not appear to be in the user data tables but in the internal database system tables. However, when the database is restored, because a system table is corrupt, the database is not ...
- 1
3
votes
1
answer
3k
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 (...
- 189