Re: tablecrash on MySQL-Max-4.0.16
Sinisa Milivojevic <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Vidar writes: > > Hi > > Thank you for your reply > > > Where exactly on our ftp site did you upload the above process list ?? > support.mysql.com/pub/mysql/secret/ > > > Can you just send the relevant snippet form it ?? > 96325 db32vl localhost db32vl Query 34 Locked UPDATE > ezsession\n SET expiration_time='1071019479', > data='[SNIP]'\n WHERE session_key='[SNIP]' > > All queries have status "Locked". And only queries concerning ezsession is > running on the server when I do a "show full processlist;" If a table were corrupted, a query would not run. UPDATE would simply and immediately return the error to the client. The aboev could be simply long running command or some problem with file system or external locking is used. Or binary has problems. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]