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
54
questions with no upvoted or accepted answers
5
votes
1answer
728 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 ...
4
votes
3answers
3k views
How to restore corrupted InnoDB tables?
We have a data loss: the MySQL database is dropped and we have to restore the tables from ibd files. The backup is too old so we have to undelete the deleted database files. Most of the tables are ...
3
votes
0answers
147 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
184 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
914 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
569 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 ...
2
votes
0answers
135 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
852 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
535 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
946 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
229 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
1k 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.
...
2
votes
0answers
3k 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....
1
vote
0answers
21 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
96 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
605 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
815 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
330 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
1answer
426 views
BACKUP Detected Corruption in the database log
I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012).
One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...
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
483 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
0answers
677 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
218 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
438 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
799 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
353 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
10 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
38 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
0answers
52 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
17 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
113 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
0answers
30 views
MS Access constant corruption issues since DFS, moved off DFS server, and still corrupting
Company has legacy MS Access databases that are being replaced by PERN (Postgres, Express, React, NodeJS) web app that is just now getting built. That is to say they still need to use the legacy ...
0
votes
0answers
208 views
What steps can I take to recover MySQL InnoDB databases when forced recovery fails?
Coming here from StackOverflow because I saw a similar question being closed as off-topic on there.
I have corrupted my local MySQL instance in my development environment.
I was running a set of ...
0
votes
1answer
343 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
1answer
198 views
sp_MSforeachdb Continue on failure when running DBCC CHECKDB
I have the following maintenance script
DECLARE @sql NVARCHAR(30) = 'DBCC CHECKDB(?)'
EXEC sp_MSforeachdb @sql
This checks every database for corruption. I have run this on my test server where I ...
0
votes
1answer
68 views
Frequent Corrupt Indexes in MySQL 5.6. Is this a MySQL bug?
I´m having problems with mysql indexes with INNODB getting corrupted. Initially I solved it by rebuilding the tables but now the tables are to large to rebuild, and i´m tired of mysql not showing ...
0
votes
0answers
366 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
2answers
200 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. ...
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
2answers
181 views
How does one create a notification upon corruption being found during Automatic Page Repair under database mirroring?
I read: https://msdn.microsoft.com/en-us/library/bb677167(v=sql.120).aspx#UnrepairablePageTypes
But, I am unclear how I can set up a notification so I am aware when this occurs.
Any advice?
0
votes
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 :
...
0
votes
0answers
101 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
322 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 ...
