Python到MySQL数据库。错误编号9，文件描述符无效。

Question

Python到MySQL数据库。错误编号9，文件描述符无效。

4

简单来说，我正在尝试从一个网站读取HTML并将表格中的值放入本地MySQL数据库。我成功地使用BeautifulSoup4提取了表格中的所有信息，但是在将其放入MySQL数据库时遇到了问题。

我正在使用与Python 2.7.5兼容的mysql.connector。以下是我的代码：

import urllib2
from bs4 import BeautifulSoup
import mysql.connector
from mysql.connector import errorcode

# Opens MySQL db and handles all connection errors
dbConfig = {'user':'root',
            'password':'pimovi',
            'host':'127.0.0.1',
            'database':'RateYourMusic'}
try:
    db = mysql.connector.connect(**dbConfig)
    cursor = db.cursor()
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print "Something is wrong with your user name or password"
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print "Database does not exist"
    else:
        print err
else:
    db.close()

url = 'http://rateyourmusic.com/customchart'
req = urllib2.Request(url, headers={'User-Agent':'Mozilla/5.0'})
read = urllib2.urlopen(req)
soup = BeautifulSoup(read)

table = soup.find('table', {'class':'mbgen'})

for row in table.findAll('tr'):
    try:
        cells = row.findAll('td')
        rank = int(cells[0].find(class_='ooookiig').text)
        artist = cells[2].find(class_='artist').text
        album = cells[2].find(class_='album').text
        year = cells[2].find(class_='mediumg').text
        year = int(year[1:5])

        entry = {'Rank':rank, 'Artist':artist, 'Album':album, 'Year':year}
        add_album = ("INSERT INTO chartinfo "
                     "(rank_info, artist_info, album_info, year_info) "
                     "VALUES (rank, artist, album, year)")
        cursor.execute(add_album)
        db.commit()
        print entry
    except AttributeError:
        pass

cursor.close()
db.close()

回溯[来自评论区]

Traceback (most recent call last): 
File "C:\Programming\RateYourMusicCrawler\AlbumInfoCrawler.py", line 52, in <module> 
    cursor.execute(add_album) 
File "C:\Python27\lib\site-packages\mysql\connector\cursor.py", line 393, in execute
    self._handle_result(self._connection.cmd_query(stmt)) 
File "C:\Python27\lib\site-packages\mysql\connector\connection.py", line 586, in cmd_query 
    statement)) 
File "C:\Python27\lib\site-packages\mysql\connector\connection.py", line 386, in _send_cmd 
    packet_number) 
File "C:\Python27\lib\site-packages\mysql\connector\network.py", line 104, in send_plain
    raise errors.OperationalError(str(err)) 
mysql.connector.errors.OperationalError: [Errno 9] Bad file descriptor

- The Nomad

你有什么问题？ - admdrew

为什么会出现 [Errno 9] 坏的文件描述符？ - The Nomad

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- admdrew · Accepted Answer

这可能是由以下原因引起的：

else:
    db.close()

如果您的try块没有发生任何异常，则会关闭连接。尝试将其删除。