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
265
questions
1
vote
0
answers
51
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 ...
- 111
0
votes
1
answer
171
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 ...
0
votes
1
answer
54
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 ...
0
votes
0
answers
76
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)
...
1
vote
1
answer
60
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 ...
- 11
0
votes
1
answer
142
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: ...
- 103
1
vote
1
answer
227
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 ...
jambajuice
0
votes
0
answers
38
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 ...
- 193
0
votes
1
answer
94
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 ...
- 103
2
votes
2
answers
288
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
26
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).
...
drk1
0
votes
1
answer
103
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 ...
1
vote
0
answers
65
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 ...
- 29
0
votes
0
answers
124
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 ...
- 319
2
votes
2
answers
197
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 ...
- 121
1
vote
1
answer
408
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 ...
- 13
2
votes
2
answers
900
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 ...
- 167
0
votes
1
answer
278
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 ...
- 3
0
votes
0
answers
36
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
73
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
654
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 ...
- 11
0
votes
0
answers
76
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 ...
- 1,994
1
vote
0
answers
42
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 ...
- 1
3
votes
1
answer
398
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 ...
- 191
4
votes
2
answers
896
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 ...
- 1
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 ...
- 21
5
votes
2
answers
365
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
161
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
125
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 ...
- 11
1
vote
0
answers
303
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
173
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 ...
- 103
-2
votes
1
answer
30
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 ...
- 1
0
votes
0
answers
239
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
200
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
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?
- 1
0
votes
1
answer
78
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 ...
- 1
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:- ...
- 150
1
vote
0
answers
128
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 ...
- 19
1
vote
1
answer
750
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 ...
- 150
-1
votes
1
answer
76
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 ...
- 193
0
votes
2
answers
113
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 ...
- 101
0
votes
1
answer
165
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. ...
- 1
0
votes
2
answers
3k
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
280
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
366
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?
- 1
0
votes
1
answer
27
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
580
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 ...
- 192
2
votes
0
answers
341
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 ...
- 21
0
votes
1
answer
554
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 [...
syl
0
votes
2
answers
103
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