SQLA 17.0.10.6160 Our operations center performs full backups of our consolidated database weekly and incremental backups before and after each dbremote run. These incremental backups are applied to the validated full database backup daily. This process has been in place for years. Recently sometime after our upgrade to SQLA 17 the application of the log files are failing occasionally. I have received three log files which failed to apply on three different occasions, each of these files when translated included a SQL Remote passthrough statement. I believe we may have a BUG... Thanks for the help. Jim asked 15 Nov '21, 15:34 J Diaz |
What error are you getting when you apply the transaction log?
No error is given the process just hangs at ... recovery 0% complete
> a SQL Remote passthrough statement
What kind of statement(s)? Different kinds, or the same kind on all three occasions?
Can you create a small, separate reproducible? I.e., tiny databases with just enough DDL to reproduce the symptom.
Let me see what I can do to recreate on a smaller database. I will also get a copy of the last db log file that caused the error.
So what version have you been using before?
Would you be able to generate a dump file from Task Manager of the dbsrv17 process when it's hung and provide :
If yes, I'll provide a location for you to upload to.
Reg
16.0.0.2798
I've requested this data but I'm not sure what's available at the very least I can arrange for them to collect it after the next passthrough
Reg,
I've got everything but a dump file there was none because the process hung it didn't crash. Let me know how best to get this to you.