Message: Error DataBase::getInstance()->prepareStatement() [execute]: Deadlock found when trying to get lock; try restarting transaction - Query: UPDATE `geo_db_cn`.`cn_city2` SET `cn_city2`.`country_code`=?, `cn_city2`.`format_name`=?, `cn_city2`.`name`=?, `cn_city2`.`code_region`=?, `cn_city2`.`population`=?, `cn_city2`.`latitude`=?, `cn_city2`.`longitude`=?, `cn_city2`.`elevation`=?, `cn_city2`.`capital`=?, `cn_city2`.`name_en`=?, `cn_city2`.`name_fr`=?, `cn_city2`.`name_de`=?, `cn_city2`.`name_it`=?, `cn_city2`.`name_pl`=?, `cn_city2`.`name_es`=?, `cn_city2`.`name_pt`=?, `cn_city2`.`name_ru`=?, `cn_city2`.`name_hi`=?, `cn_city2`.`name_cn`=?, `cn_city2`.`name_jp`=?, `cn_city2`.`name_ar`=?, `cn_city2`.`postal_code`=?, `cn_city2`.`link`=?, `cn_city2`.`geonames_nb_cities_found`=?, `cn_city2`.`is_geonames_data`=?, `cn_city2`.`geonames_id`=?, `cn_city2`.`geonames_date`=?, `cn_city2`.`latitude_orig`=?, `cn_city2`.`longitude_orig`=?, `cn_city2`.`parent_city_code`=?, `cn_city2`.`is_city_created_manually`=?, `cn_city2`.`is_duplicate_url_detected`=?, `cn_city2`.`is_histo_rate_migrate`=?, `cn_city2`.`pic_json`=?, `cn_city2`.`pic_json_date`=?, `cn_city2`.`nb_news`=?, `cn_city2`.`pic_json_validated`=?, `cn_city2`.`pic_json_date_validated`=? WHERE `cn_city2`.`city_code`=? [types: ssssidddissssssssssssssiissddsiiississi] [values: BD, chak enaetpur, Chak Enaetpur, 71, 0, 25.4166667, 88.9166667, 30, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 1, NULL, 2015-09-26 20:12:13, 25.4166667, 88.9166667, NULL, 0, 1, 1, {\"id\":\"1423392111\",\"owner\":\"9684802@N08\",\"secret\":\"451fa043a8\",\"server\":\"1209\",\"farm\":2,\"title\":\"Bangla 012\",\"ispublic\":1,\"isfriend\":0,\"isfamily\":0}, 2024-10-21 00:00:00, 0, NULL, NULL, 149695]
File: /home/weather/www/wsp/class/database/DataBase.class.php
Line: 211
Class :
Method :

Trace:

file: 185 - /home/weather/www/wsp/class/database/DataRowIterator.class.php
call: DataBase->prepareStatement("UPDATE `geo_db_cn`.`cn_city2` SET `cn_city2`.`country_code`=?, `...", Array(39))

file: 84 - /home/weather/www/wsp/class/database/DataRowIterator.class.php
call: DataRowIterator->updateRow(Object(DataRow), "`cn_city2`.`city_code`=?", Array(39), Array(1))

file: 295 - /home/weather/www/wsp/class/database_model/wsp/CnCity2WSPObject.class.php
call: DataRowIterator->save()

file: 32 - /home/weather/www/pages/includes/utils-picture.inc.php
call: CnCity2WSPObject->save()

file: 344 - /home/weather/www/pages/pictures.php
call: saveFirstCityPicture(False, Object(stdClass), 149695)

file: 111 - /home/weather/www/pages/pictures.php
call: Pictures->saveFirstCityPicture(False, Object(stdClass), 149695)

file: 131 - /home/weather/www/index.php
call: Pictures->Load()