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
6 views

What is the cause of Access' stability issues?

When discussing what database software to use I've been given advice to avoid Microsoft Access 360 due to stability issues. Having seen another person suffer from frequently corrupted data I take ...
user avatar
0 votes
1 answer
31 views

What is recommended approach for fixing corruption related errors?

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?
user avatar
  • 2,142
0 votes
1 answer
32 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 ...
user avatar
  • 2,142
0 votes
1 answer
40 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:- ...
user avatar
1 vote
0 answers
13 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 ...
user avatar
0 votes
1 answer
58 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 ...
user avatar
-1 votes
1 answer
35 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 ...
user avatar
0 votes
2 answers
46 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 ...
user avatar
0 votes
1 answer
58 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. ...
user avatar
0 votes
2 answers
156 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 ...
user avatar
  • 101
2 votes
0 answers
23 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/...
user avatar
  • 21
-2 votes
1 answer
45 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?
user avatar
  • 2,142
0 votes
1 answer
17 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 ...
user avatar
  • 101
1 vote
1 answer
73 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 ...
user avatar
2 votes
0 answers
136 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 ...
user avatar
0 votes
1 answer
166 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 [...
user avatar
0 votes
2 answers
46 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 ...
user avatar
  • 11
1 vote
2 answers
83 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, @...
user avatar
  • 11
0 votes
0 answers
579 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 ...
user avatar
  • 101
5 votes
1 answer
225 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?
user avatar
1 vote
1 answer
99 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 ...
user avatar
  • 1,007
-1 votes
1 answer
24 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 ...
user avatar
0 votes
2 answers
148 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 ...
user avatar
  • 135
0 votes
2 answers
447 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 ...
user avatar
  • 25
2 votes
1 answer
283 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 ...
user avatar
  • 141
6 votes
1 answer
202 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 ...
user avatar
0 votes
1 answer
726 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 ...
user avatar
0 votes
0 answers
99 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 ...
user avatar
0 votes
1 answer
530 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 ...
user avatar
  • 1,163
1 vote
0 answers
91 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 ...
user avatar
  • 4,384
1 vote
0 answers
187 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 ...
user avatar
  • 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 ...
user avatar
  • 121
0 votes
1 answer
149 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 ...
user avatar
  • 327
0 votes
0 answers
44 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 ...
user avatar
1 vote
1 answer
112 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 ...
user avatar
0 votes
2 answers
465 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 ...
user avatar
  • 216
0 votes
1 answer
76 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 ...
user avatar
-1 votes
1 answer
162 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 ...
user avatar
  • 1
1 vote
1 answer
296 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 ...
user avatar
1 vote
1 answer
671 views

Is it safe to restart PostgreSQL if process terminated for some reason?

I am writing a docker-compose config with a container with PostgreSQL in it. docker-compose has a configuration options called restart. If I enable it then whenever the Postgres process stops it will ...
user avatar
  • 151
4 votes
2 answers
834 views

PFS Page corruption issue and question

We recently encountered PFS page corruption in our production DB.  We are in the process of checking old backups to find which ones are clean, but I was wondering if a different process would work to ...
user avatar
1 vote
0 answers
375 views

MySQL Won't Start - InnoDB Table Corruption

I've found lots of articles and questions related to this issue, but none that seem to apply or work in my situation. MySQL will not start after I had to do a fsck repair on my server's hard drive (...
user avatar
0 votes
2 answers
203 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" ...
user avatar
  • 1
1 vote
0 answers
2k views

MySQL Service won't start with error [ERROR] InnoDB: Trying to access page number 4294963199 in space 0

My MySQL installation on Ubuntu 18.04 crashed and now won't start. The error log says Trying to access page number 4294963199 in space 0, space name innodb_system, which is outside the ...
user avatar
  • 1,450
-1 votes
1 answer
122 views

Is there a possibility of data corruption/lost when inserting large blob data from one table to another table in the same database?

I am trying to determine if data corruption/lost is possible when moving large data from one table to another in the same schema. I am new to programming and database is not my forte. Anyway I've ...
user avatar
  • 3
0 votes
1 answer
55 views

Is it possible to restore a database from corrupted .mdf file?

I know that the answer of the question may vary depending on what exactly is broken in each .mdf file - only looking for advice if there is another way to approach this. So, I have received some bad ...
user avatar
  • 3,609
0 votes
0 answers
56 views

Corrupted Access Database

I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules. I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that ...
user avatar
0 votes
1 answer
390 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 ...
user avatar
0 votes
1 answer
459 views

In a replication setup, does corrupted data also gets replicated?

Say one of the tables got corrupted, will that corrupted table still get replicated to the other DB? Or, will the replication stop to prevent the other DB from being corrupted too? Note: Question is ...
user avatar
  • 159
1 vote
0 answers
50 views

How to get the corrupted table from a log file in hex?

I'm running a Magento 2 site, everyday we have a MySQL shutdown because of some corrupted data, we don't know the table causing the issue, this is what the error logs shows: Version: '5.7.26-...
user avatar

1
2 3 4 5