Skip to content

DataError: value too long for type character varying(255)

My setup is as described here: https://groups.google.com/d/topic/mayan-edms/1vDxSIvulNI/discussion I'd post the setup here, but I need an excuse to send you to that topic, just in case you have some help for my questions there. ;)

I just was able to get an actual error after installing the python-regex package. I think we had figured that out in one of my earlier issues, but I forgot...

If I upload this image:

albertsons

The following is output to the work-slow-stderr.log file.

document_analyzer.backends.regextool <1812> [DEBUG] "execute() running regex (?ims)(?P<albertsons>(.*Albertsons.*)) on page Page 1 out of 1 of albertsons.png."
[2018-02-16 04:12:52,771: DEBUG/Worker-1] running regex (?ims)(?P<albertsons>(.*Albertsons.*)) on page Page 1 out of 1 of albertsons.png.
document_analyzer.backends.regextool <1812> [DEBUG] "execute() regex match:albertsons=Albertsons
Albertsons
‘Albertsons
Albertsons
Albertsons
v
Albertsons
‘Albertsons
Albertsons
Albertsons
Albertsans
Albertsons
v
‘Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
‘Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons"
[2018-02-16 04:12:52,773: DEBUG/Worker-1] regex match:albertsons=Albertsons
Albertsons
‘Albertsons
Albertsons
Albertsons
v
Albertsons
‘Albertsons
Albertsons
Albertsons
Albertsans
Albertsons
v
‘Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
‘Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
Albertsons
document_analyzer.managers <1812> [DEBUG] "process_version() [(u'albertsons', u'Albertsons\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nv\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsans\nalbertsons\nv\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons')]"
[2018-02-16 04:12:52,774: DEBUG/Worker-1] [(u'albertsons', u'Albertsons\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nv\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsans\nalbertsons\nv\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\n\u2018albertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons\nalbertsons')]
[2018-02-16 04:12:52,783: ERROR/MainProcess] Task ocr.tasks.task_do_ocr[4db89cd2-5a5a-465d-bcfe-64682c5494b7] raised unexpected: DataError('value too long for type character varying(255)\n',)
Traceback (most recent call last):
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in __protected_call__
    return self.run(*args, **kwargs)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/ocr/tasks.py", line 43, in task_do_ocr
    document_version=document_version
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/ocr/managers.py", line 56, in process_document_version
    sender=document_version.__class__, instance=document_version
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 191, in send
    response = receiver(signal=self, sender=sender, **named)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/document_analyzer/handlers.py", line 12, in analyze_document
    Result.objects.process_version(document_version=instance)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/document_analyzer/managers.py", line 25, in process_version
    analyzer=analyzer, document_version=document_version, parameter=parameter, value=value
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 399, in create
    obj.save(force_insert=True, using=self.db)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/base.py", line 796, in save
    force_update=force_update, update_fields=update_fields)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/base.py", line 824, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/base.py", line 908, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/base.py", line 947, in _do_insert
    using=using, raw=raw)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 1045, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1054, in execute_sql
    cursor.execute(sql, params)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/share/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
DataError: value too long for type character varying(255)

Any ideas on if I can fix that?