giullianopaz / openvt

GNU General Public License v3.0
4 stars 2 forks source link

Erro ao executar o extract.py - Tem um pacote maior que os bytes 'max_allowed_packet' #2

Open SabrinaWinckler opened 5 years ago

SabrinaWinckler commented 5 years ago

Não sei se tem alguma maneira de contornar isto, pois é um problema no tamanho dos pacotes q estão sendo extraídos. Ao executar o arquivo extract.py obtive o seguinte erro: python extract.py | 0.4086% | 33.089MB | Descriptor Extractor: [KAZE] | 0.4090% | 33.121MB | Images: [100] | 0.4090% | 33.121MB | Connecting to the MySQL database... OK | 0.4246% | 34.386MB | Dropping the existing image table... OK | 0.4246% | 34.390MB | Creating image table... OK | 0.4246% | 34.390MB | Extracting Descriptors 27%|████████████▉ | 27/100 [00:09<00:15, 4.71images/s] Traceback (most recent call last): File "extract.py", line 128, in <module> extract() File "extract.py", line 96, in extract raise e File "extract.py", line 92, in extract dumps([elem for elem in des]) # array-descriptors em JSON File "C:\Users\sabri\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py", line 206, in execute res = self._query(query) File "C:\Users\sabri\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\cursors.py", line 312, in _query db.query(q) File "C:\Users\sabri\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", line 224, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1153, "Got a packet bigger than 'max_allowed_packet' bytes")

giullianopaz commented 5 years ago

Olá, Eu nunca tive esse problema usando a OpenVT, nem durante o desenvolvimento. Isso parece ser configuração do teu MySQL. Eu achei uns links que podem te ajudar.

https://www.dbrnd.com/2016/02/mysql-error-1153-got-a-packet-bigger-than-max_allowed_packet-bytes/

https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes