Database Upgrade Utility Corrupts Log File

[former_SQLA_member1694934]

When auditing is turned on the dbupgrade utility corrupts the log file it creates in the process:

Log file was generated with missing connect operation Log operation at offset 0219742914739 has bad data at offset 0219742914746 An error occurred while attempting to translate the log file '180723AB.LOG'.

This is seen consistently using the SQLA 16

[chris_keating]

What version is the database that gets upgraded?

[chris_keating]

I tried upgrading a v12.0.1 Build 4436 with auditing enabled and it appears to work. Can you provide the steps to repro?

[former_SQLA_member1694934]

Upgrading from 12.0.1.4436 to 16.0.0.2614. I have the procedure we used and would be happy to send it to you.

[former_SQLA_member1694934]

I am creating a new database with 12 and will try to recreate this issue. It is very repeatable with existing databases but they are a bit large to send to you.

[former_SQLA_member1694934]

I just created a database from scratch and was able to repeat the issue Log file corrupted (invalid page number found) Log operation at offset 0000600412 has bad data at offset 0000600432 An error occurred while attempting to translate the log file 'D:\\SQL Anywhere 16\\Database Files\\Conversion Test\\180723AA.LOG'.

[former_SQLA_member1694934]

Must translate the log file created during upgrade process to find the issue. We did this to replicating (SQLRemote) databases and found it on the next send operation. Identical issue can be found with detran.

[chris_keating]

Can you send me the procedure? My email is first.last@sap.com. I will try with the same v16 version you are testing also.

[former_SQLA_member1694934]

This is a confirmed bug in SQLA 16