cancel
Showing results for 
Search instead for 
Did you mean: 

Load tran takes too long...

Former Member
0 Kudos

Hi guys.

I have taken a full dump of a ~3TB database on an ASE 12.5.4, loaded the dump into a new database with the "for load" option on an ASE 15.7. I havn't online'ed the database on the 15.7 as I want to be able to load in tran-dumps from the 12.5.4. Here's the issue. When I issue a "load tran testapay2 from "/usr/local/sybase/dump/tran/deltapay.log.20130523_081501"", the ASE quickly responds with "LOAD is complete (database testapay2).", but afterwards ASE waits for about 40 minutes before it continues with "Started estimating recovery log boundaries..." etc. There's only 15 minutes of transactions in the tran-dump and the file is 41MB. I would expect this to be done in 5 minutes or so. Have any of you experienced this?

This is what it looks like:

1> load tran testapay2 from "/usr/local/sybase/dump/tran/deltapay.log.20130523_081501"

2> go

Backup Server session id is: 46. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.

Backup Server: 6.28.1.1: Dumpfile name 'eltapay1314307405' section number 1 mounted on disk file '/usr/local/sybase/dump/tran/deltapay.log.20130523_081501'

Backup Server: 4.58.1.1: Database testapay2: 109184 kilobytes LOADED.

Backup Server: 3.42.1.1: LOAD is complete (database testapay2).

-- ~40 minutes before the next line gets printed to the screen

Started estimating recovery log boundaries for database 'testapay2'.

Database 'testapay2', checkpoint=(2040861, 5), first=(2040861, 4), last=(21551659, 10).

Completed estimating recovery log boundaries for database 'testapay2'.

Started ANALYSIS pass for database 'testapay2'.

Completed ANALYSIS pass for database 'testapay2'.

Started full REDO pass for database 'testapay2'. The total number of log records to process is 844028.

Redo pass for database 'testapay2': 42201 records done (4%); 801827 records left.

Redo pass for database 'testapay2': 84402 records done (9%); 759626 records left.

Redo pass for database 'testapay2': 126603 records done (14%); 717425 records left.

Redo pass for database 'testapay2': 168804 records done (19%); 675224 records left.

Redo pass for database 'testapay2': 211005 records done (24%); 633023 records left.

Redo pass for database 'testapay2': 253206 records done (29%); 590822 records left.

Redo pass for database 'testapay2': 295407 records done (34%); 548621 records left.

Redo pass for database 'testapay2': 337608 records done (39%); 506420 records left.

Redo pass for database 'testapay2': 379809 records done (44%); 464219 records left.

Redo pass for database 'testapay2': 422010 records done (49%); 422018 records left.

Redo pass for database 'testapay2': 464211 records done (54%); 379817 records left.

Redo pass for database 'testapay2': 506412 records done (59%); 337616 records left.

Redo pass for database 'testapay2': 548613 records done (64%); 295415 records left.

Redo pass for database 'testapay2': 590814 records done (69%); 253214 records left.

Redo pass for database 'testapay2': 633015 records done (74%); 211013 records left.

Redo pass for database 'testapay2': 675216 records done (79%); 168812 records left.

Redo pass for database 'testapay2': 717417 records done (84%); 126611 records left.

Redo pass for database 'testapay2': 759618 records done (89%); 84410 records left.

Redo pass for database 'testapay2': 801819 records done (94%); 42209 records left.

Redo pass for database 'testapay2': 844020 records done (99%); 8 records left.

Redo pass of recovery has processed 10857 committed and 0 aborted transactions.

Completed REDO pass for database 'testapay2'.

Use the ONLINE DATABASE command to bring this database online; ASE will not bring it online automatically.

Execution Time (ms.):     22

Clock Time (ms.): 2743390


Accepted Solutions (0)

Answers (1)

Answers (1)

kimon_moschandreou
Contributor
0 Kudos

Hello,

I don't think you can do anything on this, I suppose the "dump tran" file is big (several GB) and probably the version change (12.5.4 -> 15.7) is related.

Best regards,

Kimon

Former Member
0 Kudos

Hello.

I took more than a week for my post to get approved! So I did some testing during that time. Turns out, that if I disable directio on the database-devices, a tran-dump with 15 minutes of transactions takes about 5 minutes to load, versus ~40 minutes.

I have tested this several times, dropped the database and recreated it, and I can reproduce this everytime when I enable/disable directio...

Former Member
0 Kudos

Hi Kimon,

No the file is not big - as I write, it is 41mb.