Bug #17884 java.sql.SQLException: Can't create/write to file 'D:\DOCUME~1\ADMINI~1
Submitted: 3 Mar 2006 3:53 Modified: 29 Oct 2007 12:46
Reporter: liang bingqiu Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:5 OS:Windows (window)
Assigned to: CPU Architecture:Any

[3 Mar 2006 3:53] liang bingqiu
java.sql.SQLException: Can't create/write to file 'D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\#sql_3e8_0.MYI' (Errcode: 13)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:822)
        at com.mysql.jdbc.Field.getCollation(Field.java:325)
        at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:626)
        at com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:697)
        at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:620)
        at com.sun.rowset.internal.CachedRowSetReader.readData(CachedRowSetReader.java:178)
        at com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:759)
        at com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:1421)
        at hmis.Dict.jTable1MouseClicked(Dict.java:166)
        at hmis.Dict.access$200(Dict.java:18)
        at hmis.Dict$2.mouseClicked(Dict.java:99)
        at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
        at java.awt.Component.processMouseEvent(Component.java:5491)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
        at java.awt.Component.processEvent(Component.java:5253)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3955)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3901)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1774)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

How to repeat:
use CachedRowSet , can't be repeated every time,but some time.
[3 Mar 2006 15:44] Mark Matthews
Not a JDBC driver bug, looks like server bug or misconfiguration (i.e. MySQL can't create temporary table).
[6 Mar 2006 11:58] Valeriy Kravchuk
Please, speicfy the exact version of MySQL server used and how you installed it? If it is on Windows, have you installed it as local Administrator? How much free space do you have on your disk?
[7 Mar 2006 9:27] liang bingqiu
version: mysql v5.0 for windows;
installed by install wizard;
installed as local administrator;

after installed,free space is 378m.
[7 Mar 2006 11:10] Valeriy Kravchuk
Exact server version is 5.0.x (5.0.18, for example). So, please, inform about the exact version used. Can you pinpoint SQL statement in your Java application that gives you this exception?
[7 Apr 2006 23:00] 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".
[11 Jul 2007 12:27] Dominic Oyeniran
I having a similar problem. OS is windows xp service pack 2, Mysql version is: 5.0.18-nt. Hibernate hql syntax to communication with Mysql
[11 Jul 2007 16:59] Valeriy Kravchuk
All reporters:

Please, try to repeat with a newerversion of server, 5.0.41 at least, and inform about the results.
[23 Jul 2007 14:23] Dominic Oyeniran
Thanks Valeriy,
I have installed version 5.5.45 . How ever this causes my application to fail with this message: "com.mysql.jdbc.exceptions.MySQLDataException: '21474836481' in column '15' is outside valid range for the datatype INTEGER."

There were no problems with the previous mysql version (5.5.18) that I updated. Any ideas? Thanks.
[24 Jul 2007 8:48] Dominic Oyeniran
Sorry I mean mysql 5.0.45
[29 Sep 2007 12:46] Valeriy Kravchuk
All reporters:

Please, specify the exact MySQL server and Connector/J versions used. Send your my.cnf/my.ini files content also.
[30 Oct 2007 0:00] 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".