Resi W <[EMAIL PROTECTED]> wrote:
Hi,
As requested, here is the knldiag as of 7 Oct. The server crashed at 06 Oct.
What could be the cause of the crash ? I suspect because it is full. But why can't it be restarted ?
And if it did crashed because db full, is there any way to tell the db to grow dynamically (both in volume or add new devspaces).
In addition, I'd like to correct the situation. I mentioned in my previous email that my partner has changed some of the parameters in db. Apparently he did not. So why did the db told me that I cannot add new devspace because parameters have been changed (pls read my prev email for detail).
Thanks in advance.
Resi
>
> Hi,
>
> My company has a SAP DB 7.4 under Win 2K sp4 installation. We
> have been using this server for around 3 months. Yesterday
> the server crashed, and couldn't be restarted again. Whenever
> I tried to START it it gave an error :
>
> Error Code : -24895
> Description : shutdown of database occured [db_warm -f]; -71
> , connection broken.
At first we should check what is the reason for this.
Please provide the knldiag
Elke
SAP Labs Berlin
> However, I can still go to admin mode.
>
> After I investigated, it's probably because the database was
> full, and ppl were still attempted to upload files to it.
> Made it crashed.
>
> To resolve this, I tried to add new devspaces since we can
> still do that in admin mode.
> But when I tried that it refused and gave this error msg :
>
> " You can not add devspaces now, the parameter file is changed.
> Stop and then restart the database to get the new parameters active. "
>
> After I investigated, I learned that my co-worker has
> attempted to change a few of the parameters (after the crash).
>
> Now I am facing some sort of a deadlock - The server can't be
> restarted due to disk full, and I can't add new devspaces
> because the parameter has been changed, thus the database
> instance needs to be restarted (which I can't do) before I
> can add devspaces.
>
> What I would like to know :
>
> 1. Why does the database can't be started (by looking at the
> error msg) ? Is it because the database was full ?
>
> 2. How to solve the 'deadlock' problem I mentioned above, I
> can't add new devspaces.
>
> Thanks in advance for the help.
>
> Regards,
>
> Resi W.
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
knldiag2.zip
Description: knldiag2.zip
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
