Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1221
  • Last Modified:

UPDATE MySql table simultaneously no possible?

Hello,

why can I not make a sql UPDATE at the same time on a MySql table. Me and my colleague are updating the same table at the same time.

The below Exceptions are from me. My colleague gets the error message, that he can not read dataset.



05.05.2009 08:54:53|ERROR|MySqlException in Methode threadLoop, Message: Fatal error encountered during command execution., Number:0
05.05.2009 08:54:53|ERROR|Nicht behandelter Fehlercode, in MySql Dokumentation nachschauen, Message: Fatal error encountered during command execution., InnerException:MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.IOException: Von der Übertragungsverbindung können keine Daten gelesen werden: Eine vorhandene Verbindung wurde vom Remotehost geschlossen. ---> System.Net.Sockets.SocketException: Eine vorhandene Verbindung wurde vom Remotehost geschlossen
   bei System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   bei System.IO.BufferedStream.ReadByte()
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   bei MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   bei MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   bei MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

Open in new window

0
MSFanboy
Asked:
MSFanboy
  • 4
  • 4
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
table structure? engine? indexes?
update/select statements?
0
 
MSFanboyAuthor Commented:
if you mean the storage engine I think its MyISAM. About the table structure I can not say anything due to company...
 private int disableArticle(string str_Artnr)
        {
            mycomm = mycon.CreateCommand(); 
            mycomm.CommandText = "UPDATE tablename SET bbactiv = 0 WHERE artnum = " + str_Artnr;            
            return mycomm.ExecuteNonQuery();
        }


0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
does the field artnum have a index? is it the primary key?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MSFanboyAuthor Commented:
No its not a Primary Key. It has varchar(255) AND set to "Not Null"
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please ensure that field does have a index on it, eventually a primary key (at least it looks to me that it might be the primary key)
0
 
MSFanboyAuthor Commented:
artnum is my PK
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
then the optimization is ok, so far.

anything else needs deep investigations, like server settings (key_buffer_size, for example)
check if you have any logs in the mysql logs ...
0
 
MSFanboyAuthor Commented:
too bad we can not check the mysql logs because the database is a webshop database from a sort of rent webshop system :/ We can just programm against the database but we cant touch the server settings etc...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now