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, 15:34

J%20Diaz's gravatar image

J Diaz
1.1k334159
accept rate: 10%

What error are you getting when you apply the transaction log?

(15 Nov, 15:45) Reg Domaratzki
Replies hidden

No error is given the process just hangs at ... recovery 0% complete

(15 Nov, 16:40) J Diaz

> 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.

(16 Nov, 09:38) Breck Carter
Replies hidden

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.

(16 Nov, 09:48) J Diaz

Recently sometime after our upgrade to SQLA 17 the application of the log files are failing occasionally.

So what version have you been using before?

(16 Nov, 10:03) Volker Barth
Replies hidden

Would you be able to generate a dump file from Task Manager of the dbsrv17 process when it's hung and provide :

  1. The dump file
  2. The dbsrv17 start line
  3. The output from dbsrv17
  4. The transaction log it was applying when it hung

If yes, I'll provide a location for you to upload to.

Reg

(16 Nov, 10:04) Reg Domaratzki

16.0.0.2798

(16 Nov, 12:31) J Diaz

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

(16 Nov, 15:32) J Diaz

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.

(17 Nov, 14:48) J Diaz
showing 3 of 9 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×71
×28

question asked: 15 Nov, 15:34

question was seen: 68 times

last updated: 17 Nov, 14:48