Errore Prestashopdatabaseexception Al Caricamento Di Un File Csv

[JRCFirewalker]

Salve a tutti,

 

da qualche giorno quando provo a caricare un file csv (o a fare anche altre operazioni), ricevo il seguente errore:

potreste darmi una mano?

Grazie

[PrestaShopDatabaseException]

Deadlock found when trying to get lock; try restarting transaction
 

        INSERT INTO `ps_product_tag` (`id_tag`, `id_product`, `id_lang`)
        VALUES (1,43,1),(22981,43,1),(387,43,1),(22982,43,1)
at line 791 in file classes/db/Db.php

 

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
  420. $this->result = $this->_query($sql);
  421. }
  422. }
  423.
  424. if (_PS_DEBUG_SQL_) {
  425. $this->displayError($sql);
  426. }
  427.
  428. return $this->result;
  429. }
  430.
• DbCore->query - [line 601 - classes/db/Db.php] - [1 Arguments]
  596. {
  597. if ($sql instanceof DbQuery) {
  598. $sql = $sql->build();
  599. }
  600.
  601. $this->result = $this->query($sql);
  602. if ($use_cache && $this->is_cache_enabled) {
  603. Cache::getInstance()->deleteQuery($sql);
  604. }
  605.
  606. return (bool)$this->result;
• DbCore->execute - [line 131 - classes/Tag.php] - [1 Arguments]
  126. }
  127. $data = rtrim($data, ',');
  128.
  129. $result = Db::getInstance()->execute('
  130.         INSERT INTO `'._DB_PREFIX_.'product_tag` (`id_tag`, `id_product`, `id_lang`)
  131.         VALUES '.$data);
  132.
  133. if ($list != array()) {
  134. self::updateTagCount($list);
  135. }
  136.
• TagCore::addTags - [line 1796 - controllers/admin/AdminImportController.php] - [4 Arguments]
  1791. foreach ($tags as $one_tag) {
  1792. $str .= $one_tag.$this->multiple_value_separator;
  1793. }
  1794. $str = rtrim($str, $this->multiple_value_separator);
  1795.
  1796. $is_tag_added = Tag::addTags($key, $product->id, $str, $this->multiple_value_separator);
  1797. if (!$is_tag_added) {
  1798. $this->addProductWarning(Tools::safeOutput($info['name']), (int)$product->id, 'Invalid tag(s) ('.$str.')');
  1799. break;
  1800. }
  1801. }
• AdminImportControllerCore->productImport - [line 3503 - controllers/admin/AdminImportController.php]
  3498. case $this->entities[$import_type = $this->l('Categories')]:
  3499. $this->categoryImport();
  3500. $this->clearSmartyCache();
  3501. break;
  3502. case $this->entities[$import_type = $this->l('Products')]:
  3503. $this->productImport();
  3504. $this->clearSmartyCache();
  3505. break;
  3506. case $this->entities[$import_type = $this->l('Customers')]:
  3507. $this->customerImport();
  3508. break;
• AdminImportControllerCore->postProcess - [line 178 - classes/controller/Controller.php]
  173. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
  174. $this->setMedia();
  175. }
  176.
  177. // postProcess handles ajaxProcess
  178. $this->postProcess();
  179.
  180. if (!empty($this->redirect_after)) {
  181. $this->redirect();
  182. }
  183.
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
  362. if (isset($params_hook_action_dispatcher)) {
  363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
  364. }
  365.
  366. // Running controller
  367. $controller->run();
  368. } catch (PrestaShopException $e) {
  369. $e->displayMessage();
  370. }
  371. }
  372.
• DispatcherCore->dispatch - [line 58 - admin/index.php]
  53. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) {
  54. $_REQUEST['controller'] = strtolower($_REQUEST['tab']);
  55. }
  56.
  57. // Prepare and trigger admin dispatcher
  58. Dispatcher::getInstance()->dispatch();

[Moris83]

Errore simile

 

hai risolto ?

[JRCFirewalker]

Errore simile

 

hai risolto ?

In parte sì e in parte no, nel senso che il problema risiede effettivamente nel time-out del server, per cui ho "risolto" acquistando un modulo che mi permette di caricare i listini "a pezzi" senza intasare il server. Il problema resta per tutte quelle operazioni lunghe che vanno oltre i listini. Per il momento non ho molto tempo per testare il tuo suggerimento, ma appena ho un attimo provo

 

Grazie!