MySQL Master Need (DB Problems from ASP Record Insert Pages)
I think I'm MEMORIZING the MySQL docs, trying to hunt this down problem down. :-)
Problem: Table Corruption that seems to be caused by
insert statements not properly closing the table.
The level of multiuser contention against this table
is fairly low, but does happen, as recordset queries
are being run against this table fairly constantly,
with record inserts happening several hundred times a
IIS v5.0 on Windows 2000 server
Table type: MyISAM
I think I've narrowed the problem down: It seems to
be caused by insert statements not properly closing
the database table. At any rate, this is from the
This is what I get if I do an insert into the table that's getting corrupted, then do a "CHECK TABLE tab_customer;" within a few seconds afterward.
If you get the following warning from CHECK TABLE or myisamchk:
# clients is using or hasn't closed the table properly
this means that this counter has come out of sync. This doesn't mean that the table is corrupted, but means that you should at least do a check on the table to verify that it's okay.
Often it will show the error:
When that happens, queries subsequently run against
IPS.tab_customer | check | warning | 1 clients is using or hasn't closed the table properly
IPS.tab_customer | check | error | Found 7833 keys of 7834
IPS.tab_customer | check | error | corrupt
the table from my ASP pages to select a record return
Here's the code I'm using to do the record insert.
It's pretty straightforward (the code block is
actually created by MacroMedia UltraDev:
...where (of course) MM_editConnection is the
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
connection string and MM_editQuery is the SQl
statement that handles the insert.
Data IS being correctly inserted. So, why wouldn't
the table get closed properly?
Thanks for any help that any of you MySQL masters