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
51
questions with no upvoted or accepted answers
6
votes
1answer
779 views
RDS MYSQL instance rebooted and won't load INNODB table
So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
3
votes
0answers
199 views
Corrupted tables in postgresql: invalid relnatts, attrelid and typrelid
When trying to upgrade my databases from Postgresql 9.5.4 to 9.6.3, two tables are corrupted.
$ /usr/local/Cellar/postgresql/9.5.4_1/bin/pg_catcheck -h localhost -p 5434 db_concepts_2
notice: ...
3
votes
0answers
225 views
VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping
Log shipping has been working for a very long time, but now and then it breaks. I found it sometimes breaks (causes the transaction log to become corrupt and I get the message : "media family on ...
3
votes
0answers
1k views
Receiving error when running DBCC CheckDB - multiple IAM pages
Running DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS results in this error:
Table error:
Multiple IAM pages for object ID 813245952, index ID 1,
partition ID 72057594073972736, ...
3
votes
0answers
581 views
Database corrupt after restore and upgrade on another instance
We have SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) instances. There is a process of backup on SQL Server 2008 R2 and restore to SQL Server 2014.
Everything was going fine, until ...
3
votes
0answers
2k views
How do I recover from MySQL InnoDB table/index corruption?
While trying to upgrade a database (in place) I got the following error. The server starts up and everything seems to be fine, except that the table mentioned in the message is no longer accessible.
...
3
votes
0answers
4k views
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB
I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query:
SELECT * FROM sys....
2
votes
0answers
298 views
Errors during CHECKDB
We have a db which reports errors when trying to do a backup:
Starting to dig in, the first thing that was suggested was to run DBCC CHECKDB. I've been trying to run that all day now, and googling ...
2
votes
0answers
1k views
How to get records from corrupted ibd file
Ok, in the last two days I thoroughly searched through the internet, and found multiple propositions on how to handle this, but nothing worked so far.
Here is what the problem is and what I tried so ...
2
votes
0answers
9k views
Cannot continue the execution because the session is in the kill state
When I query a table in my database, I am getting the error message as below.
Msg 596, Level 21, State 1, Line 0 Cannot continue the execution
because the session is in the kill state. Msg 0, ...
2
votes
0answers
2k views
mysqldump show Table doesn´t exist when doing LOCK TABLES
Our server had power outage and after start some of mysql tables was inaccessible. I tried many things but nothing helped and currently i am at freeze point.
I used command :
mysqldump database ...
2
votes
0answers
657 views
Database Corruption - object in sys.parameters does not have a matching row in sys.objects
I'm using SQL Server 2008 R2 and I have a strange db corruption.
I ran dbcc check db and the output is:
Attribute (object_id=1096186) of row (object_id=1096186,parameter_id=1) in sys.parameters ...
2
votes
0answers
1k views
Data Corruption - ERROR: could not open segment 2 of relation
I am getting the below error for a production database. I am new to PostgreSQL databases. I need help to get this fixed.
2015-10-28 10:25:04,154 [monitor-thread-pool1-thread-6] ERROR [org.hibernate....
2
votes
0answers
232 views
Old records disappearing after upgrade from 9.4.1 to 9.4.4
I recently upgraded from 9.4.1 to 9.4.4. Since then millions of rows have disappeared from several tables containing historical data.
The severity of data loss seems to be directly proportional to ...
2
votes
0answers
510 views
postgresql 9.3 with Ubuntu 14.04.1 LTS throw 's ERROR: invalid page in block 105 of relation base/16385/17407
This is Ubuntu 14.04.1 LTS with postgresql 9.3 in production, Now i got this below error's in log.
# tail -f /var/log/postgresql/postgresql-9.3-main.log
2015-01-08 14:10:16 IST CONTEXT: automatic ...
1
vote
1answer
61 views
SQL Server 2016 table corrupt
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 ...
1
vote
0answers
96 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 (...
1
vote
0answers
33 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-...
1
vote
0answers
131 views
Unable to drop table/database when using innodb_force_recovery = 3
I'm attempting to follow several guides to recover a corrupted database, by setting innodb_force_recovery to 3, dumping the database, dropping the database, and then importing it back in.
I'm able to ...
1
vote
0answers
2k views
missing chunk number 0 for toast value x
our RAID10 failed miserably and we now have a corrupted psql database. I copied the main/ folder and now are working with a copy trying to recover data. I have progressed far enough to have made an ...
1
vote
0answers
714 views
MySQL MyISAM corrupted table repair failure
My MyISAM tables got corrupted(I guess due to fs corruption)
filesystem_cstor.MDS_DATA
warning : Table is marked as crashed
warning : Table is marked as crashed
error : Key in wrong position at ...
1
vote
0answers
1k views
'mysqlcheck' hangs over a database
Sometime ago I noticed my WordPress sites wont load. I found the problem with MySQL.
The server I am running on is a VPS server with:
Debian 8.1
MariaDB - Ver 15.1 Distrib 10.1.14-MariaDB
2048 MB ...
1
vote
0answers
409 views
Three Vital Postgres Columns Corrupted
I run a small website which uses a Postgres database. There are regular back ups based on the amount of traffic we have every few days but there was a recent surge of activity just before a power cut ...
1
vote
0answers
1k views
“mysqld got signal 11” error
I have a MySQL 5.6.22 InnoDB database and just now, suddenly out of nowhere, when I try to start it up using /etc/init.d/mysqld start, I see this error in the error log and the server won't start up :
...
1
vote
0answers
2k views
PostgreSQL 9.4.4 Crashing
We are having 9.4.4 version running on linux( PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit) which is crashing unexpectedly and coming ...
1
vote
0answers
737 views
mysqldump with --single-transaction seems to be “fixing” InnoDB tables with page corruption - why?
I'm trying to find out what exactly is happening here. I've been intentionally corrupting index pages in InnoDB tables, changing bytes in user record areas that actually contain information (largest ...
1
vote
0answers
227 views
Corrupted Filesystem: Possible to restore databases from the contents of /var/lib/mysql?
Using CentOS 6.4 x64.
Not sure what happened but somehow my VPS filesystem got corrupted and it is now in a permanent read-only state. I've been working with my hosting provider's sys. admin. but ...
1
vote
0answers
5k views
Possible schema corruption. Run DBCC CHECKCATALOG
Good Evening to all.
I was working with sql server 2008.
Thing i did:
Actually i was noticed that the free space available in C drive reaches below 1 GB .So i thought to Club the D drive with C ...
1
vote
0answers
507 views
CHECKDB Allocation Errors Msg 2576, could not repair, object id does not exist
I inherited a database that has no value in LastKnownGood. I ran repair allow data loss, says it was successfully repaired, but no change to the errors when I run checkdb again. In case it was a SQL ...
1
vote
0answers
972 views
mysql doesnt have write access in data dir?
I am running a MySQL on my Windows 7 64 bit development machine at work and I can't seem to get around a database corruption issue. In my unit tests it is telling me that the storage engine (which is ...
1
vote
1answer
394 views
Repair with data loss did not fix index corruption. What now?
A few months ago we migrated our SQL Server 2014 database to a virtual environment.
Soon afterwards, corruption started showing up in indexes, causing all sorts of trouble.
I've made repairs using ...
0
votes
0answers
19 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
100 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" ...
0
votes
0answers
423 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 ...
0
votes
0answers
42 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 ...
0
votes
1answer
114 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 ...
0
votes
0answers
37 views
After upgrading from PG 9.3 to 10 indices became corrupted
So recently I was upgrading the database in production from Postgres 9.3 to 10. In addition to upgrade, we wanted to move the database to another machine. I know, doing it "in place" would be easier ...
0
votes
0answers
239 views
MariaDB corrupted after attempting full backup with mariabackup
I have Mariadb installed on a Raspberry Pi with a simple star schema for logging data that comes in on a Modbus server. Everything was running fine for about a month and a half until one day I was ...
0
votes
1answer
717 views
InnoDB ibdata1 corrupted, innodb_force_recover not working
I think I have checked every post in the internet.
Thing is my MySQL (MariaDB) won't come up and after much testing I have seen it is because of the InnoDB files.
I have tried with different ...
0
votes
0answers
406 views
Inherited Database with Corruption and a Bad Checksum
We have inherited a corrupted database 'DBName', with no good backup available to us. The corruption apparently happened some months ago.
We have tried a few thing:
DBCC CHECKDB(DBName); --Shows no ...
0
votes
0answers
2k views
SQL Server 2012 service will not start after each server reboot - corrupt SQLBOOT.DLL
When I tried to start the service manually from a command prompt, I get a dialog stating:
Your SQL Server installation is either corrupt or has been tampered with (Unable to load SQLBOOT.DLL (HRESULT ...
0
votes
0answers
132 views
DBCC REPAIR_REBUILD adds rows
SQL Server 2008 R2, an update corrupted my table somehow, likely to do with the storage subsystem. I am on a dev database, so aren't overly concerned about losing data, it isn't business critical. But ...
0
votes
0answers
393 views
Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file
I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server.
I am using sql server 2014.
This is where you can see the routine I use to run the backups:
How ...
0
votes
0answers
41 views
Oracle DB - DR corruption
One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
0
votes
0answers
1k views
Dropping a corrupt table in innodb_force_recovery 6
As often happens in mysterious shutdowns during large queries, things ran afowl with InnoDB on my XAMPP MySQL installation (Windows 7 x64). I rebooted and ran Startup Repair, then loaded MySQL to ...
0
votes
0answers
83 views
Mysql - too many Deletion - Insertion
I'm creating cron jobs for my OLAP system.
I have a cron job that deletes the records from the summary table first and then insert the records in it again:
Say Deleting 1 month records, and ...
0
votes
1answer
59 views
Will canceling InnoDB compression that's already in progress corrupt data?
I have a 155GB table that is in the process of being compressed.
ALTER TABLE $table_name ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
This compression has been running for a long time and is impeding my ...
-1
votes
1answer
163 views
Is mysql using some kind of auto repair due to “check table” warnings?
Today i noticed a "strange" behaviour of MySQL when using "CHECK TABLE" on a crashed table. First i got a warning like "Size of datafile is: * ... Should be: *" but i could still "insert into / select ...
-1
votes
2answers
230 views
PostgreSQL 8.1 Corruption Issue
I have an old Postgres server that some major corruption problems on one of the databases. We first noticed the issue when the drives started to fill up on a database that should have plenty of space. ...
