<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.yoctoproject.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugzilla.yoctoproject.org/"
          
          maintainer="it-coreprojects-helpdesk@linuxfoundation.org"
>

    <bug>
          <bug_id>8475</bug_id>
          
          <creation_ts>2015-10-09 22:24:02 +0000</creation_ts>
          <short_desc>mysql max length of LogMessage message</short_desc>
          <delta_ts>2015-11-06 12:32:21 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>7</classification_id>
          <classification>Build System, Metadata &amp; Runtime</classification>
          <product>Toaster</product>
          <component>toaster</component>
          <version>2.0</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>VERIFIED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>2.0</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Michael Wood">michael.g.wood</reporter>
          <assigned_to name="Michael Wood">michael.g.wood</assigned_to>
          <cc>alexandru.costinx.roman</cc>
    
    <cc>belen.barros.pena</cc>
    
    <cc>jessica.zhang</cc>
    
    <cc>stanciux.mihail</cc>
          
          <qa_contact name="Alexandru Roman">alexandru.costinx.roman</qa_contact>
          <cf_os>---</cf_os>
          <cf_regression_type>---</cf_regression_type>
          
          <cf_docchange>No (bug/feature does not impact docs)</cf_docchange>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>55135</commentid>
    <comment_count>0</comment_count>
    <who name="Michael Wood">michael.g.wood</who>
    <bug_when>2015-10-09 22:24:02 +0000</bug_when>
    <thetext>Traceback (most recent call last):
  File &quot;/var/www/toaster/toaster-next/bitbake/lib/toaster/manage.py&quot;, line 10, in &lt;module&gt;
    execute_from_command_line(sys.argv)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py&quot;, line 399, in execute_from_command_line
    utility.execute()
  File &quot;/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py&quot;, line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/core/management/base.py&quot;, line 242, in run_from_argv
    self.execute(*args, **options.__dict__)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/core/management/base.py&quot;, line 285, in execute
    output = self.handle(*args, **options)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/core/management/base.py&quot;, line 415, in handle
    return self.handle_noargs(**options)
  File &quot;/var/www/toaster/toaster-next/bitbake/lib/toaster/bldcontrol/management/commands/runbuilds.py&quot;, line 131, in handle_noargs
    self.cleanup()
  File &quot;/var/www/toaster/toaster-next/bitbake/lib/toaster/bldcontrol/management/commands/runbuilds.py&quot;, line 101, in cleanup
    LogMessage.objects.create(build = br.build, level = LogMessage.EXCEPTION, message = brerror.errmsg)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py&quot;, line 157, in create
    return self.get_queryset().create(**kwargs)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/query.py&quot;, line 319, in create
    obj.save(force_insert=True, using=self.db)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/base.py&quot;, line 545, in save
    force_update=force_update, update_fields=update_fields)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/base.py&quot;, line 573, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/base.py&quot;, line 654, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/base.py&quot;, line 687, in _do_insert
    using=using, raw=raw)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py&quot;, line 232, in _insert
    return insert_query(self.model, objs, fields, **kwargs)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/query.py&quot;, line 1511, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py&quot;, line 898, in execute_sql
    cursor.execute(sql, params)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py&quot;, line 69, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py&quot;, line 53, in execute
    return self.cursor.execute(sql, params)
  File &quot;/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py&quot;, line 124, in execute
    return self.cursor.execute(query, args)
  File &quot;/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py&quot;, line 176, in execute
    if not self._defer_warnings: self._warning_check()
  File &quot;/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py&quot;, line 92, in _warning_check
    warn(w[-1], self.Warning, 3)
_mysql_exceptions.Warning: Data truncated for column &apos;message&apos; at row 1


We currently have LogMessage . message defined in the orm as a CharField this doesn&apos;t seem right as it as a restriction on number of characters is only 240. If we switch this to a text field the problem doesn&apos;t happen.

-    message=models.CharField(max_length=240)
+    message=models.TextField(blank=True, null=True)</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>55804</commentid>
    <comment_count>1</comment_count>
    <who name="Michael Wood">michael.g.wood</who>
    <bug_when>2015-10-27 10:02:23 +0000</bug_when>
    <thetext>http://git.yoctoproject.org/cgit/cgit.cgi/poky/commit/?id=62e200e3e3f51e74fabfb16b506649cd47b7cc42</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>56283</commentid>
    <comment_count>2</comment_count>
    <who name="Alexandru Roman">alexandru.costinx.roman</who>
    <bug_when>2015-11-06 12:32:21 +0000</bug_when>
    <thetext>Verified on master: fc45deac89ef63ca1c44e763c38ced7dfd72cbe1</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>