Unanswered: Transaction Log keeps getting corrupted console DB
I have a problem with one of my client's database, where the Console DB log file keps getting corrupted (It's happened 3 times in the last 4 months).
The version of Sybase is v18.104.22.16860 and the database size is about 42GB
Here is the message that I'm getting in the replication log:
E. 2016-09-20 15:00:03. Log file corrupted (invalid page number found)
E. 2016-09-20 15:00:03. Corruption of log starts at offset 0155035214042
E. 2016-09-20 15:00:03. Log operation at offset 0155034463396 has bad data at offset 0155035214043
E. 2016-09-20 15:00:03. Sending messages failed
The DB is running on Windows server 2008R2 on a Microsoft Azure VM and we have 3 disks running as RAID5 and 9 disks running as RAID0.
All the disks are showing as healthy in disk management.
Could anyone please tell me why this keeps happening and what to do to prevent it to happen again ?