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
0 answers
30 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 ...
  • 2,800
2 votes
1 answer
44 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 ...
  • 161
4 votes
2 answers
861 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 ...
  • 2,800
0 votes
1 answer
64 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
212 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 ...
  • 153
-3 votes
2 answers
27 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 ...
1 vote
3 answers
67 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 ...
1 vote
0 answers
73 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 ...
0 votes
1 answer
72 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 ...
-2 votes
1 answer
25 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 ...
  • 2,800
0 votes
0 answers
51 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 ...
  • 1
0 votes
2 answers
104 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 ...
-2 votes
1 answer
45 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?
  • 2,800
0 votes
1 answer
35 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 ...
  • 2,800
0 votes
1 answer
554 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:- ...
1 vote
0 answers
37 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 ...
0 votes
1 answer
335 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 has stopped working. Mysql service never comes up on start ...
-1 votes
1 answer
41 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 ...
0 votes
2 answers
54 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 ...
0 votes
1 answer
75 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. ...
0 votes
2 answers
959 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 ...
  • 111
2 votes
0 answers
41 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/...
  • 21
-2 votes
1 answer
50 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?
  • 2,800
0 votes
1 answer
21 views

How can MySQL be optimized for unattended operation on unreliable hardware?

I run some personal services on a not-entirely-reliable single-board computer. Sometimes it locks up and needs to be power cycled. One of these services is currently configured to use MySQL with ...
  • 101
1 vote
1 answer
184 views

Data corruption-Errors found in off-row data- am I loosing data?

I need your help with understanding what is going on in my database. Check DB job detected some issues in one of the tables. There are two types of error messages. A lot of errors like below: Table ...
2 votes
0 answers
210 views

Slave index corruption mariadb 10.5

We have a simple mariadb replication with a master and a bunch of slaves. without any prior alert or warning, randomly in our slaves some indexes ( some of them are not present in master) become ...
0 votes
1 answer
316 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 [...
's user avatar
0 votes
2 answers
58 views

Oracle: Corrupt datafile will not turn back online?

need immediate assistance on an issue... Oracle Support is taking way too long to respond back on. We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
  • 11
1 vote
2 answers
109 views

DBCC CHECKDB not sending an alert when Corruption Found for Severity Level 16

I have setup this alert that I got from Brent Ozar's Website. EXEC msdb.dbo.sp_add_alert @name=N'Severity 016', @message_id=0, @severity=16, @enabled=1, @delay_between_responses=60, @...
  • 11
1 vote
0 answers
979 views

Corrupted ibdata1 and can't run server

I am running a local dev environment on OSX. I restarted the machine earlier, and since then, I cannot load mysql server. I am running mysql 8.0.23 I get the following message when I try to load ...
  • 111
5 votes
1 answer
235 views

Corrupt a database page in a certain table then restore it

I want to corrupt a page inside a certain table and restore it. How do I do that on SQL Server?
1 vote
1 answer
159 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 ...
  • 1,007
-1 votes
1 answer
25 views

Oracle can not find a record with a specific field

In our application we face an weird situation, consider a table name TAX exists in the database, when I query it with select * from tax where fk_pay = 123456 a record is returned with id = 654321 but ...
0 votes
2 answers
218 views

PostgreSQL 9.5 database showing signs of corruption in logs, though clients work normally

We have a database server running PostgreSQL 9.5 on a Ubuntu 16.04 LTS box, with the total data size just under 30 GB. We've set archive_mode to on, and archive_command is rsyncing WAL files to ...
  • 135
0 votes
2 answers
581 views

Oracle 12cR1 - RMAN-11003, ORA-00354, ORA-00353 - Corrupt Redo Log

Oracle 12cR1, disaster database. ORA-00283: recovery session canceled due to errors ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 8 change 80357235718 time 11/01/2020 ...
  • 35
2 votes
1 answer
411 views

DBCC CheckDB : Operating System Error 27(The drive cannot find the sector requested)

So my regular DBCC check had this lovely message waiting for me in the error logs this morning. I've been trying to find out more about this issue and what can be done about it. Manually running DBCC ...
  • 141
6 votes
1 answer
204 views

How do pages get updated checksum when switching page verification mode from torn page to checksum?

Have an older but large db (6tb on the san) that still has its page verification option set to TORN_PAGE_DETECTION. How do you apply the new checksum to all existing pages when changing page ...
0 votes
1 answer
868 views

Backend on server keeps getting into an inconsistent state

I built an Access database. It was originally meant to be for 6 people but I see that it's up to about 20, so that could be the problem. Anyway, the backend gets into an inconsistent state a couple of ...
0 votes
0 answers
127 views

PFS Corruption after restoring SQL Server 2012 database to 2016

We migrated few SQL Server 2012 databases over to SQL Server 2016 over the weekend. Old Server Details SQL Server 2012 SP4 11.0.7493.4 DB set to compatibility 110 TDE Enabled - Yes Recovery Model is ...
0 votes
1 answer
663 views

What is difference between starting Instance with -T3608 and with -f?

I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs and articles about it I stuck on the question, what is difference between starting ...
  • 1,193
1 vote
0 answers
107 views

Is there any way to recklessly drop a principal leaving orphaned objects or should I assume only data corruption could cause it?

Given that SQL Server blocks me when I try to DROP a principal that owns an object in the database, if I see an object which the owner no longer exists, should I assume right away it was data ...
  • 4,717
1 vote
0 answers
220 views

Database in suspect mode

I'm experiencing a tough issue for me. When I was updating some columns into the database I have previously installed, the main memory corruption led the database jump into the suspect mode. I follow ...
  • 11
0 votes
1 answer
31 views

Database system checksumming to prevent network corruption not caught by TCP checksumming

Since TCP checksumming is not sufficient to detect/prevent all corruption, do modern database systems (e.g. SQL Server, MariaDB / MySQL, Oracle, etc.) use any additional checksumming of network ...
  • 121
0 votes
1 answer
184 views

SSD used for tablespace died. How can I recover data?

I have a postgres cluster with two databases Database A uses the default tablespace. It holds important information but has very few writes per day (< 20) and only has a few tables with a few ...
  • 327
0 votes
0 answers
53 views

Restore got failed in sql server

While i restore my database i got the below error. But i have more space in my drive. modify file encountered error 112 (Ther is not enough space on the disk)while attempting to expand the physical ...
1 vote
1 answer
122 views

SQL Server 2016 table corrupt [closed]

I have an SQL Server 2016 v13.0.5101.9 hosting Sharepoint databases. The weekly DBCC CHECKDB job discovered database corruption (or inconsistency): Msg 8928, and Msg 8965 popping up. I narrowed it ...
0 votes
2 answers
679 views

Load PostgreSQL database from corrupt drive [duplicate]

I suffered corruption of a hard drive but managed to recover files for a PostgreSQL server. We are running on the assumption that the files themselves are not corrupted (yet to be able to tell). My ...
  • 236
0 votes
1 answer
95 views

SQL Server - SQL Agent Alerts - Alert 824 warning about old problems

I have alerts enabled on a SQL Server 2017 where corruption was encountered and repaired over a year ago. I have also confirmed that there is no new corruption on any database on this server. When ...
-1 votes
1 answer
182 views

how can I solve RAID 5 corrupted data? [closed]

I installed Windows Server 2012 on my server using RAID 5. But a problem occurred on my server. I extracted the data from 10 hard disks with data recovery. When I attached the extracted data files in ...
  • 1
1 vote
1 answer
343 views

Entries in suspect_pages but checkdb shows no error

I am using Microsoft SQL Server 2016 (SP2-GDR) (KB4505220) - 13.0.5101.9 (X64) Jun 15 2019 23:15:58 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 ...

1
2 3 4 5