Bug #27547 Restore fails on Windows 2000
Submitted: 30 Mar 2007 13:03 Modified: 27 Sep 2008 10:33
Reporter: Samo Dadela Email Updates:
Status: Won't fix Impact on me:
Category:MaxDB Severity:S2 (Serious)
Version:7.6.00 OS:Microsoft Windows (Windows 2000)
Assigned to: CPU Architecture:Any
Tags: pipe closed, restore, windows 2000

[30 Mar 2007 13:03] Samo Dadela
The backup was created as this:
(default instance, overwrite off, RUNDIRECTORY c:\tmp\whatever)
- backup_start BACK1234 DATA

- set autolog on 
- load tutorial x3 (wait for file to appear on stage) 

- archive_stage BACK1234L BACK1234AL NOVERIFY REMOVE (save of archive logs)
- backup_start BACK1234L LOG (save of active logs)

(the instance was stopped and data and log directories were deleted) 
- db_activate recover BACK1234 DATA (works OK)
- autorecover_log (FAILS <----)

It fails when it requests the restore of the archive log - the pipe is suddenly closed. I also got some AK0*.dmp files in one case. I checked the files in RUNDIRECTORY - the dbm.* logs have nothing relevant (at least to me)... but the knl* files show some activiti around pipes and the dump. 

This happens only on Windows 2000 (I suspected it was missing updates, but the same happens after the machine is fully updated (windows update), I also increased the amount of memory, nothing helps). 

I tried to restore the files on Windows 2003 -> works. Again: only Windows 2000 (server) displays this problem. 

How to repeat:
See description. 

BACK1234 - Complete Data, Pipe, BACK
BACK1234L - Log, Pipe, BACK
BACK1234AL - AutoLog (c:\maxdb\stage\testlog FILE AUTO)

Suggested fix:
Wish I'd now ;)
[30 Mar 2007 13:30] Samo Dadela
I'm using a custom backint and backup solution. 
The process that feeds the pipe says: Pipe Closed. That means maxdb closed the pipe for some reason.
[30 Mar 2007 13:31] Samo Dadela
Change to Serious since restore is not possible on windows 2000.
[8 Sep 2007 3:44] Valeriy Kravchuk
Thank you for a problem report. What exact version, 7.6.00.xx you had used?
[21 Sep 2007 9:21] Samo Dadela
The version... I used the following packages:
- maxdb-all-win-32bit-i386-7_6_00_34.exe
- maxdb-dbmgui-setup-7_6_00-130190.exe
[4 Oct 2007 17:08] Valeriy Kravchuk
According to http://www.mysql.com/news-and-events/press-release/release_2007_40.html:

"support of the MaxDB database will revert back to SAP"
[27 Sep 2008 10:33] Konstantin Osipov
MaxDB is not under MySQL umbrella any more.