> my database has freezed again.
> See attachement for x_cons output.
> Can you describe me what does it mean ?
> Where should I search for problem ?

ID   UKT UNIX   TASK       APPL Current         Timeout Region     Wait 
          tid   type        pid state          priority cnt try    item 
T135   7     -1 User      3992* Vwait                 0 0           252
36171(s)
T136   7     -1 User       968* Vwait                 0 0           251
36171(s)
T139   7     -1 User      3544* Vwait                 0 0           252
36171(s)
T140   7     -1 User     97304* Vwait                 0 0            46
36171(s)


The database is waiting for a lock release. All of those application PIDs
are waiting for the item 36171.

Unfortunately I don't know how to find out via command line what exactly
this lock is. 

Anyone of the development can give a hint here?


Greetz,


SIEGENIA-AUBI KG
Informationswesen
 
i.A.
 
Markus Döhr
SAP-CC/BC, SAPDB-DBA

Tel.:    +49 6503 917-152
Fax:     +49 6503 917-7152
E-Mail: [EMAIL PROTECTED]
Internet: http://www.siegenia-aubi.com 
  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to