Stack Overflow
Stack Overflow

Questions tagged [mysql-error-1205]

8 questions
11
votes
2 answers

MySQL Error Code: 1205. Lock wait timeout during update with inner join

I am trying to update the Time_Stamp field in my table, simple_pack_data, to match the values in the similarly titled field in my temp_data table. The tables each have fields called Test_Number and Time_Marker, which I'm using to INNER JOIN the…
eh_whatever
  • 193
  • 1
  • 3
  • 13
1
vote
1 answer

MySql transaction lock timeout (1205) when insert into two databases which have foreign key on primary

I have two database in mysql running with innoDB and the second db has foreign key related to primary key of the first one. In my code I need to insert in the first DB and get id for that and insert to the second one. All goes well unless I start…
Ramin Rabii
  • 359
  • 4
  • 14
1
vote
0 answers

MySQL error code 1205: Lock wait timeout exceeded when trying to delete multiple rows with the same id

I am getting a "Lock wait timeout exceeded error..." message (code 1205) when trying to delete multiple rows with the same id from my table. If I use SELECT instead of DELETE, the query works fine and returns the rows that I want to remove. This is…
jezB
  • 11
  • 3
1
vote
2 answers

mysql insert error both in python and mysql command line

I want to insert some items to mysql db. When I did it in my python script, I got: Error 1062: Duplicate entry '222' for key 'product_code'. product_code is an unique field. When I did it in mysql command line, I got: Error 1205(HY000):Lock wait…
Minglong
  • 119
  • 2
  • 7
0
votes
2 answers

Efficient way to delete a large amount of records from a big table using python

I have a large table (About 10 million rows) that I need to delete records that are "older" than 10 days (according to created_at column). I have a python script that I run to do this. created_at is a varchar(255) and has values like for e.g.…
Saffik
  • 911
  • 4
  • 19
  • 45
0
votes
1 answer

Magento SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

I recently made a copy of my large 32Gig Database to use for my development environment. Now getting this error when I try to create, delete, update items. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting…
Hector
  • 682
  • 3
  • 14
  • 27
0
votes
2 answers

SQL query times out when updating using inner join?

This query dies when I try to execute it in PHP code and in phpMyAdmin. UPDATE Inventory INNER JOIN InventorySuppliers ON Inventory.LocalSKU = InventorySuppliers.LocalSKU SET Inventory.Integer2 = '1' WHERE InventorySuppliers.SupplierSKU =…
Zaffar Saffee
  • 6,167
  • 5
  • 39
  • 77
0
votes
1 answer

1205 error: table still locked after a lot of time

I had a query, which I executed in Mysql workbench on my own computer, the database is on a remote computer. After some time I got a 2013 error(Lost connection to MySQL server during query), there was no effect of the query. Later I tried some…
Borut Flis
  • 15,715
  • 30
  • 92
  • 119