Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
-1 votes
1 answer
66 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 ...
Deanne R's user avatar
3 votes
1 answer
232 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 (...
KaliTheGreat's user avatar
1 vote
2 answers
65 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, ...
J. Mini's user avatar
  • 431
0 votes
0 answers
79 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 ...
Robin Singh's user avatar
1 vote
0 answers
81 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 ...
Arjun Lajpal's user avatar
0 votes
1 answer
404 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 ...
Chris Samaritano's user avatar
0 votes
1 answer
217 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 ...
Girish Agarwal's user avatar
0 votes
0 answers
233 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) ...
Ananth Mahadevan's user avatar
1 vote
1 answer
121 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 ...
sastewa's user avatar
  • 11
0 votes
1 answer
342 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: ...
Fabian's user avatar
  • 103
1 vote
1 answer
591 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 ...
user avatar
1 vote
0 answers
66 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 ...
user2233709's user avatar
0 votes
1 answer
140 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 ...
WhoKnows's user avatar
  • 103
2 votes
2 answers
532 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/...
Rajin Tamrakar's user avatar
0 votes
1 answer
46 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). ...
user avatar
0 votes
1 answer
154 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 ...
user125942's user avatar
1 vote
0 answers
87 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 ...
DBANoob's user avatar
  • 29
0 votes
0 answers
166 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 ...
Sicilian-Najdorf's user avatar
2 votes
2 answers
284 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 ...
Isaac King's user avatar
1 vote
1 answer
741 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 ...
Peter Li's user avatar
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 ...
lyeaf's user avatar
  • 177
0 votes
1 answer
355 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 ...
Alex's user avatar
  • 3
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 ...
David Harrison's user avatar
1 vote
1 answer
81 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 ...
Dominic Legendre's user avatar
1 vote
1 answer
756 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 ...
Rawkon's user avatar
  • 11
0 votes
0 answers
108 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 ...
Frederik Vanderhaegen's user avatar
1 vote
0 answers
76 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 ...
variable's user avatar
  • 3,634
3 votes
1 answer
511 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 ...
Tom's user avatar
  • 191
4 votes
2 answers
901 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 ...
variable's user avatar
  • 3,634
0 votes
1 answer
723 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 ...
ConanTheGerbil's user avatar
2 votes
1 answer
4k 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 ...
emreyanik's user avatar
5 votes
2 answers
391 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 ...
Dave C's user avatar
  • 153
-3 votes
2 answers
210 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 ...
Mahmoud Mahmad's user avatar
1 vote
3 answers
140 views

Can someone help explain the specifics of why a DBA would be against database clustering?

I'm a system admin and do not manage databases on a daily basis. My organization is considering database clustering to practically eliminate downtime for certain services. We use mostly oracle ...
soldiercasey's user avatar
1 vote
0 answers
359 views

MariaDB Server crashes when performing mysqlcheck

I'm checking my databases and I'm using this command : mysqlcheck --all-databases -c -uroot -pxxxxxxx But I'm getting this error : mysqlcheck: Got error: 2013: Lost connection to MySQL server ...
Abdaljaleel Thamer's user avatar
0 votes
1 answer
214 views

SQL Server fix deleted mdf

I have a database which my indexes are in separate filegroups and space (SSD). The SSD which contains indexes is break down, my actual data which are on tables are secured but because of SSD break ...
Amirali Samiei's user avatar
-2 votes
1 answer
31 views

Does the SQL AG based corruption resolution work for a enterprise edition read scale AG and for basic AG?

SQL provides 2 kinds of AG architecture. Basic AG (when either of the server has standard SQL edition) Enterprise edition AG for HA Enterprise edition AG for read scale (this doesn't require WSFC) I ...
variable's user avatar
  • 3,634
0 votes
0 answers
279 views

InnoDB Corruption

We had a previous client who's server crashed. They were running MySql 5 on Debian Lenny and doing daily backups. When they contacted us to help them restore the database from the backups we realized ...
esen's user avatar
  • 1
0 votes
2 answers
268 views

Take Backup of a Database without the Corrupted rows

I have DB of size 170GB. One of the table has 339500 rows out of which around 2000 rows are corrupted. When I tried backing up the database I get "Backup with 'Checksum' gave error" SQL ...
IT Researcher143's user avatar
-2 votes
1 answer
46 views

What is recommended approach for fixing corruption related errors? [closed]

When there are errors of code 823 in the log or dbcc has detected corruption, then should the 1st choice to solve this be: dbcc checkdb with no data loss or restore from full backup+tlog backups?
variable's user avatar
  • 3,634
0 votes
1 answer
84 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 ...
variable's user avatar
  • 3,634
0 votes
1 answer
2k views

Mysql service down with [ERROR] InnoDB: Page log sequence number is in the future

I have a Centos 7.9 server with MariaDB version 10.2.43. All of a sudden on May 2 2022, I have started receiving mysql down alerts. On checking I could see below log information in logs. Error 2:- ...
nisamudeen97's user avatar
1 vote
0 answers
143 views

Data in one or more tables corrupt after recovering tables with alter table discard/import tablespace

I accidentally dropped my schema and had to recover all the tables per the steps in this post; Recover schema and the data in it from accidentally deleted schema However, I notice that all of the ...
Citizen1138x's user avatar
1 vote
1 answer
846 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 ...
nisamudeen97's user avatar
-1 votes
1 answer
84 views

Recreate broken Database

Here is the scenario - I have a Database that is suffering from Error 824, dbcc checkdb repair_allow_loss has not rectified it and unfortunately the Backups are also corrupt. However, I am able to ...
TheDemonLord's user avatar
0 votes
2 answers
123 views

Where can we find a copy of the "sakila" toy database with uncorrupted city names?

The "sakila" toy database which is available by download as https://downloads.mysql.com/docs/sakila-db.zip from https://dev.mysql.com/doc/index-other.html contains a city table whose city ...
Tim Stewart's user avatar
0 votes
1 answer
207 views

Corrupted database. How to restore it from an old backup and add newer changes after?

I have a corrupted database with the following error Msg 8952, Level 16, State 1, Line 1 Table error: table 'sys.syscolpars' (ID 41). Index row of index 'nc' (ID 2) does not match any row of data. ...
charade's user avatar
0 votes
2 answers
4k views

How to fix "could not write to file pg_wal/xlogtemp" after a failed command?

I ran vacuum full analyze, but it took too long and it was using 100% of RAM, so I killed it. Now, Postgres won't start. I got: * Starting PostgreSQL 14 database server ...
Leo Jiang's user avatar
  • 111
2 votes
0 answers
315 views

mysql stopped working after no free space on file system [corruption]

I am experiencing the following error when launching MySQL. can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket '/var/...
zerunio's user avatar
  • 21
-2 votes
1 answer
380 views

How to repair database corruption from backup? [closed]

I am learning about dbcc checkdb and that it detects corruption. Suppose checkdb results show corruption in db. What is the way to fix the corruption suppose I have the db backup?
variable's user avatar
  • 3,634

1
2 3 4 5 6