Resi W wrote: > > 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. > > > "Becker, Holger" <[EMAIL PROTECTED]> wrote: > Becker, Holger wrote: > > > [EMAIL PROTECTED] wrote: > > > > > I observed the following in my SapDB-Installation (Server is > > > 7.4.3 under > > > Win NT4.0SP6): > > > > > > When I submit the query (via the SQL-Studio or JDBC does > not matter) > > > > > > SELECT REPLACE(field,'','x') FROM tab > > > > > > where field is an arbitrary character field in table tab, > > the database > > > shuts down. > > > > > > The query is of course not meaningful but I think this should > > > be fixed if > > > this is not specific to my configuration. > > > > You are totally right this is a bug and we will fix it in > one of the > > next versions (see > > http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID > > =1124520) > > Seems that there are to much bugs reporting to me because I already > mixed them up. > The right PTS message for this bug is > http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1124544 > > Sorry for this little confusion. > > Best regards, > Holger > SAP Labs Berlin > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > --------------------------------- > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
