MSQL server has gone away

[Baptou Perrinos]

Hello

I have a probleme

After one day ghiro task stop,

i have the log,but have you got a solution ?

2015-09-15 08:45:19,033 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:20,036 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:21,039 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:22,042 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:23,053 [DEBUG] lib.analyzer.processing - Processing task 4502
2015-09-15 08:45:23,067 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:23,140 [ERROR] lib.analyzer.processing - Critical error in plugin <class 'plugins.analyzer.gexiv.GexivAnalyzer'>, skipping: (2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "/var/www/html/ghiro/lib/analyzer/processing.py", line 57, in _process_image
output = current.run(task)
File "/var/www/html/ghiro/plugins/analyzer/gexiv.py", line 120, in run
self._get_exif()
File "/var/www/html/ghiro/plugins/analyzer/gexiv.py", line 64, in _get_exif
self._add_key(key, self.metadata.get(key))
File "/var/www/html/ghiro/plugins/analyzer/gexiv.py", line 49, in _add_key
add_metadata_description(key, self.metadata.get_tag_description(key))
File "/var/www/html/ghiro/lib/utils.py", line 108, in add_metadata_description
AnalysisMetadataDescription.objects.get(key=key.lower())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 151, in get
return self.get_queryset().get(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 304, in get
num = len(clone)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 77, in __len__
self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 857, in _fetch_all
self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 220, in iterator
for row in compiler.results_iter():
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 713, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 786, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 69, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 124, in execute
return self.cursor.exe:cute(query, args)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (2006, 'MySQL server has gone away')
2015-09-15 08:45:24,073 [DEBUG] lib.analyzer.processing - No tasks. Waiting...
2015-09-15 08:45:25,080 [DEBUG] lib.analyzer.processing - Processing task 4503
2015-09-15 08:45:25,093 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:26,102 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:27,107 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:27,927 [ERROR] lib.analyzer.processing - Critical error in plugin <class 'plugins.analyzer.hashcomparer.HashComparerAnalyzer'>, skipping: (2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "/var/www/html/ghiro/lib/analyzer/processing.py", line 57, in _process_image
output = current.run(task)
File "/var/www/html/ghiro/plugins/analyzer/hashcomparer.py", line 27, in run
hash_lists = List.objects.filter(cipher=key).filter(Q(owner=task.owner) | Q(public=True))
File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/related.py", line 320, in __get__
rel_obj = qs.get()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 304, in get
num = len(clone)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 77, in __len__
self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 857, in _fetch_all
self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 220, in iterator
for row in compiler.results_iter():
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 713, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 786, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 69, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 124, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (2006, 'MySQL server has gone away')
2015-09-15 08:45:28,035 [INFO] lib.analyzer.processing - Processed task 4502 with success
Process AnalysisRunner-1:
Traceback (most recent call last):
File "/usr/lib/python2.7/multiprocessing/process.py", line 258, in _bootstrap
self.run()
File "/var/www/html/ghiro/lib/analyzer/processing.py", line 39, in run
self._process_image(task)
File "/var/www/html/ghiro/lib/analyzer/processing.py", line 77, in _process_image
task.save()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 545, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 570, in save_base
with transaction.commit_on_success_unless_managed(using=using, savepoint=False):
File "/usr/local/lib/python2.7/dist-packages/django/db/transaction.py", line 280, in __enter__
connection.set_autocommit(False)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py", line 340, in set_autocommit
self._set_autocommit(autocommit)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 461, in _set_autocommit
self.connection.autocommit(autocommit)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 461, in _set_autocommit
self.connection.autocommit(autocommit)
File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", line 243, in autocommit
_mysql.connection.autocommit(self, on)
OperationalError: (2006, 'MySQL server has gone away')
2015-09-15 08:45:28,110 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:29,113 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:30,115 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:31,117 [DEBUG] lib.analyzer.processing - Queue full. Waiting...
2015-09-15 08:45:32,120 [DEBUG] lib.analyzer.processing - Queue full. Waiting...

[Alessandro Tanasi]

Hello,
thanks for reporting it.
'MySQL server has gone away' is a common Mysql error when the mysql
server is restarted or give up before time.
It could depend by many issues out of ghiro, for example if a cron
script or an update is restarting mysql.
Are you using the ghiro appliance?

Thanks.

Regards,
Alessandro Tanasi (@jekil)

[Baptou Perrinos]

hello,

I don't use aplliance but after search on net i write in /etc/musql/my.cnf
repertory [mysqld] connect_timeout=172800 after 2 days mysql clonnection is close, i test for connect_timeout=0.

Thank for your reply.
Sorry for my english

[Alessandro Tanasi]

Hello,
yes, it depends by mysql settings about connection timeout.
You can add CONN_MAX_AGE to the database options in ghiro.

By the way, I opened a issue https://github.com/Ghirensics/ghiro/issues/9 so you can track the status of your reported issue.

Regards,
Alessandro Tanasi (@jekil)

> --
> You received this message because you are subscribed to the Google Groups "Ghiro image forensics mailing list" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to ghiro+un...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.