Error in mailman3 debian package, python error
Hi!
Mailman Core Version GNU Mailman 3.2.1 (La Villa Strangiato) Mailman Core API Version 3.0 Mailman Core Python Version 3.7.3 (default, Apr 3 2019, 05:39:12) [GCC 8.3.0]
Since yesterday our mailman3 (debian package) throws this error:
Internal Server Error: /mailman3/hyperkitty/api/mailman/archive
OperationalError at /hyperkitty/api/mailman/archive
(1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subject at row 1")
Request Method: POST Request URL: http://localhost/mailman3/hyperkitty/api/mailman/archive?key=zMxTGlteq4tqkL5... Django Version: 1.11.22 Python Executable: /usr/bin/uwsgi-core Python Version: 3.7.3 Python Path: ['.', '', '/usr/lib/python37.zip', '/usr/lib/python3.7', '/usr/lib/python3.7/lib-dynload', '/usr/local/lib/python3.7/dist-packages', '/usr/lib/python3/dist-packages'] Server time: Wed, 7 Aug 2019 08:03:47 +0000 Installed Applications: ('hyperkitty', 'postorius', 'django_mailman3', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'django_gravatar', 'compressor', 'haystack', 'django_extensions', 'django_q', 'allauth', 'allauth.account', 'allauth.socialaccount', 'django_mailman3.lib.auth.fedora') Installed Middleware: ('django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.middleware.security.SecurityMiddleware', 'django_mailman3.middleware.TimezoneMiddleware', 'postorius.middleware.PostoriusMiddleware')
Traceback:
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py" in execute 64. return self.cursor.execute(sql, params)
File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py" in execute 101. return self.cursor.execute(query, args)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in execute 250. self.errorhandler(self, exc, value)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py" in defaulterrorhandler 50. raise errorvalue
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in execute 247. res = self._query(query)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in _query 411. rowcount = self._do_query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in _do_query 374. db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py" in query 292. _mysql.connection.query(self, query)
The above exception ((1366, "Incorrect string value:'\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subject at row 1")) was the direct
cause of the following exception:
File "/usr/lib/python3/dist-packages/django/core/handlers/exception.py" in inner 41. response = get_response(request)
File "/usr/lib/python3/dist-packages/django/core/handlers/base.py" in _get_response 187. response = self.process_exception_by_middleware(e, request)
File "/usr/lib/python3/dist-packages/django/core/handlers/base.py" in _get_response 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/lib/python3/dist-packages/django/views/decorators/http.py" in inner 40. return func(request, *args, **kwargs)
File "/usr/lib/python3/dist-packages/hyperkitty/views/mailman.py" in _decorator 69. return func(request, *args, **kwargs)
File "/usr/lib/python3/dist-packages/django/views/decorators/csrf.py" in wrapped_view 58. return view_func(*args, **kwargs)
File "/usr/lib/python3/dist-packages/hyperkitty/views/mailman.py" in archive 115. add_to_list(mlist_fqdn, msg)
File "/usr/lib/python3/dist-packages/hyperkitty/lib/incoming.py" in add_to_list 151. email.save()
File "/usr/lib/python3/dist-packages/django/db/models/base.py" in save 808. force_update=force_update, update_fields=update_fields)
File "/usr/lib/python3/dist-packages/django/db/models/base.py" in save_base 838. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/usr/lib/python3/dist-packages/django/db/models/base.py" in _save_table 924. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/usr/lib/python3/dist-packages/django/db/models/base.py" in _do_insert 963. using=using, raw=raw)
File "/usr/lib/python3/dist-packages/django/db/models/manager.py" in manager_method 85. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/lib/python3/dist-packages/django/db/models/query.py" in _insert 1079. return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py" in execute_sql 1112. cursor.execute(sql, params)
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py" in execute 64. return self.cursor.execute(sql, params)
File "/usr/lib/python3/dist-packages/django/db/utils.py" in __exit__ 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/lib/python3/dist-packages/django/utils/six.py" in reraise 685. raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py" in execute 64. return self.cursor.execute(sql, params)
File "/usr/lib/python3/dist-packages/django/db/backends/mysql/base.py" in execute 101. return self.cursor.execute(query, args)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in execute 250. self.errorhandler(self, exc, value)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py" in defaulterrorhandler 50. raise errorvalue
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in execute 247. res = self._query(query)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in _query 411. rowcount = self._do_query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py" in _do_query 374. db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py" in query 292. _mysql.connection.query(self, query)
Exception Type: OperationalError at /hyperkitty/api/mailman/archive
Exception Value: (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E'
for column mailman3web.hyperkitty_email.subject at row 1")
Request information:
USER: AnonymousUser
Has anyone a idea what went wrong or howto fix it?
MfG, Lars Schimmer
TU Graz, Institut für ComputerGraphik & WissensVisualisierung Tel: +43 316 873-5405 E-Mail: l.schimmer@cgv.tugraz.at Fax: +43 316 873-5402 PGP-Key-ID: 0x4A9B1723
Am 07. August 2019 um 11:57 Uhr +0200 schrieb Lars Schimmer:
OperationalError at /hyperkitty/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subjectat row 1")[...] Has anyone a idea what went wrong or howto fix it?
U+1F34E RED APPLE (which is what the string value above evaluates to in UTF-8) is not a valid e-mail address. If you didn't create user accounts via another way than the Hyperkitty UI, this looks like a bug in Hyperkitty's e-mail validator to me. Such a value should never have entered the database.
Maybe you can delete the user with that "e-mail address" with your DB's command line tool.
Marvin
-- Blog: https://mg.guelker.eu
On Wed, Aug 7, 2019, at 3:50 AM, Marvin Gülker wrote:
Am 07. August 2019 um 11:57 Uhr +0200 schrieb Lars Schimmer:
OperationalError at /hyperkitty/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subjectat row 1")[...] Has anyone a idea what went wrong or howto fix it?
U+1F34E RED APPLE (which is what the string value above evaluates to in UTF-8) is not a valid e-mail address. If you didn't create user accounts via another way than the Hyperkitty UI, this looks like a bug in Hyperkitty's e-mail validator to me. Such a value should never have entered the database.
It is not in the database, the exception originates from Mailman Core trying to archive a message coming from this sender and Hyperkitty failing to archive the message.
This should have been handled properly and a better exception message should have been raised instead of this error traceback.
Can you open a bug report about this Hyperkitty's issue tracker?
https://gitlab.com/mailman/hyperkitty/issuesMaybe you can delete the user with that "e-mail address" with your DB's command line tool.
Marvin
-- Blog: https://mg.guelker.eu
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
-- thanks, Abhilash Raj (maxking)
On 08.08.2019 03:19, Abhilash Raj wrote:
On Wed, Aug 7, 2019, at 3:50 AM, Marvin Gülker wrote:
Am 07. August 2019 um 11:57 Uhr +0200 schrieb Lars Schimmer:
OperationalError at /hyperkitty/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subjectat row 1")[...] Has anyone a idea what went wrong or howto fix it?
U+1F34E RED APPLE (which is what the string value above evaluates to in UTF-8) is not a valid e-mail address. If you didn't create user accounts via another way than the Hyperkitty UI, this looks like a bug in Hyperkitty's e-mail validator to me. Such a value should never have entered the database.
It is not in the database, the exception originates from Mailman Core trying to archive a message coming from this sender and Hyperkitty failing to archive the message.
This should have been handled properly and a better exception message should have been raised instead of this error traceback.
Can you open a bug report about this Hyperkitty's issue tracker?
https://gitlab.com/mailman/hyperkitty/issues
It is issue #248 now.
Maybe you can delete the user with that "e-mail address" with your DB's command line tool.
Marvin
-- Blog: https://mg.guelker.eu
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
MfG, Lars Schimmer
TU Graz, Institut für ComputerGraphik & WissensVisualisierung Tel: +43 316 873-5405 E-Mail: l.schimmer@cgv.tugraz.at Fax: +43 316 873-5402 PGP-Key-ID: 0x4A9B1723
On 08.08.2019 03:19, Abhilash Raj wrote:
On Wed, Aug 7, 2019, at 3:50 AM, Marvin Gülker wrote:
Am 07. August 2019 um 11:57 Uhr +0200 schrieb Lars Schimmer:
OperationalError at /hyperkitty/api/mailman/archive (1366, "Incorrect string value: '\\xF0\\x9F\\x8D\\x8E' for column
mailman3web.hyperkitty_email.subjectat row 1")[...] Has anyone a idea what went wrong or howto fix it?
U+1F34E RED APPLE (which is what the string value above evaluates to in UTF-8) is not a valid e-mail address. If you didn't create user accounts via another way than the Hyperkitty UI, this looks like a bug in Hyperkitty's e-mail validator to me. Such a value should never have entered the database.
It is not in the database, the exception originates from Mailman Core trying to archive a message coming from this sender and Hyperkitty failing to archive the message.
This should have been handled properly and a better exception message should have been raised instead of this error traceback.
Can you open a bug report about this Hyperkitty's issue tracker?
https://gitlab.com/mailman/hyperkitty/issues
But, as it is not in the database, howto fix this?
thank you.
Maybe you can delete the user with that "e-mail address" with your DB's command line tool.
Marvin
-- Blog: https://mg.guelker.eu
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
MfG, Lars Schimmer
TU Graz, Institut für ComputerGraphik & WissensVisualisierung Tel: +43 316 873-5405 E-Mail: l.schimmer@cgv.tugraz.at Fax: +43 316 873-5402 PGP-Key-ID: 0x4A9B1723
participants (3)
-
Abhilash Raj -
Lars Schimmer -
Marvin Gülker