Bug #1081 ERROR 1015: Can't lock file (errno: -30982)
Submitted: 18 Aug 2003 12:58 Modified: 20 Sep 2003 22:17
Reporter: Michel Veillette Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.0 Apha OS:Windows (Windows 2000/XP)
Assigned to: CPU Architecture:Any

[18 Aug 2003 12:58] Michel Veillette
Description:
Database curruption created by a SQL statement.

How to repeat:
Just run the following statement on the database "cerbere" available for download from "http://www.nertec.com/tmp/data.zip".

SELECT r.*, ss.*, text
FROM reading r left outer join sensor_source ss on
        (r.device_id = ss.device_id
         AND r.sensor_source_id = ss.sensor_source_id
        AND ss.sensor_change_time =
            (SELECT max(s.sensor_change_time)
            FROM sensor_source s
            WHERE s.device_id = ss.device_id
            AND s.sensor_source_id = ss.sensor_source_id
            AND s.sensor_change_time <= r.time))
    left outer join code on (ss.uom = code.code
                             AND code.id = 'sensor_source.uom'
                             AND code.language = 'en_US')
    WHERE r.device_id = 'NC_PHIL'
    AND r.data_description = 1000001
    AND r.tier = 0
ORDER BY r.time
[20 Aug 2003 22:17] MySQL Verification Team
I wasn't able for to download the file data.zip from the
mentioned URL.
Could you please can upload it at:

ftp://support.mysql.com/pub/mysql/secret

with a name identifying the bug #1081
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".