title: psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
body: <p>I Wrote a scrapy program to scrape data from a site, the program does scrape successfully if I am scraping to a json file or csv file, the issue arises when I try to scrape into my postgres database, the below picture shows the error I receive, How can I fix the error:</p>
  <p><a href="https://i.stack.imgur.com/aMJQt.png" rel="noreferrer"><img src="https://i.stack.imgur.com/aMJQt.png" alt="enter image description here" /></a></p>
  <pre><code>def process_item(self, item, spider):
      &quot;&quot;&quot;Save deals in the database.
      This method is called for every item pipeline component.
      &quot;&quot;&quot;
      self.cur.execute(&quot;insert into Deals (Name,Deal_Url,Image_Url,Old_Price,Special_Price,Final_Price) values(%s,%s,%s,%s,%s,%s)&quot;,(item['Name'],item['Product_URL'],item['Image_URL'],item['Old_Price'],item['Special_Price'],item['Final_Price']))
      self.connection.commit()
      return item
  </code></pre>