UUID binary field make error while loading referenced table [PYFB75]

[firebird-automations]

Submitted by: Emmanuel Belair (ebelair)

Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error:

Schema: import uuid

from django.db import models

class AgdeEtab(models.Model): etab_id = models.UUIDField(primary_key=True, default=uuid.uuid4, blank=False, null=False) activite_commerce = models.ForeignKey('AgdeActiviteCommerce', models.DO_NOTHING, blank=True, null=True)

class Meta:
    managed = False
    db\_table = 'agde\_etab'

class AgdeActiviteCommerce(models.Model): activite_commerce_id = models.UUIDField(primary_key=True, default=uuid.uuid4) activite_commerce_lib = models.CharField(unique=True, max_length=60)

class Meta:
    managed = False
    db\_table = 'agde\_activite\_commerce'

In console :

>>> from agde.models import AgdeEtab >>> etab = AgdeEtab.objects.get(enseigne__startswith='MIDAS') >>> etab.activite_commerce

Traceback (most recent call last): File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 158, in __get__ rel_obj = self.field.get_cached_value(instance) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/mixins.py", line 13, in get_cached_value return instance._state.fields_cache[cache_name] KeyError: 'activite_commerce'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "<input>", line 1, in <module> File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 164, in __get__ rel_obj = self.get_object(instance) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 139, in get_object return qs.get(self.field.get_reverse_related_filter(instance)) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 397, in get num = len(clone) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 254, in __len__ self._fetch_all() File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 1182, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 53, in __iter__ results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1068, in execute_sql cursor.execute(sql, params) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 100, in execute return super().execute(sql, params) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/firebird/base.py", line 262, in execute return self.cursor.execute(q, params) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3627, in execute self._ps._execute(parameters) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3308, in _execute self.__tuple2xsqlda(self._in_sqlda, parameters) File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3091, in __tuple2xsqlda len(value))) ValueError: Value of parameter (0) is too long, expected 16, found 32

When I debug http://fbcore.py line 3091, the value type is bytes with 32 alnum chars Feel free to ask if you need more details

[firebird-automations]

Modified by: Emmanuel Belair (ebelair)

description: Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: import uuid from django\.db import models class AgdeEtab\(models\.Model\): etab\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4, blank=False, null=False\) activite\_commerce = models\.ForeignKey\('AgdeActiviteCommerce', models\.DO\_NOTHING, blank=True, null=True\) class Meta: managed = False db\_table = 'agde\_etab' class AgdeActiviteCommerce\(models\.Model\): activite\_commerce\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4\) activite\_commerce\_lib = models\.CharField\(unique=True, max\_length=60\) class Meta: managed = False db\_table = 'agde\_activite\_commerce' \>\>\> from agde\.models import AgdeEtab \>\>\> etab = AgdeEtab\.objects\.get\(enseigne\_\_startswith='MIDAS'\) \>\>\> etab\.activite\_commerce Traceback \(most recent call last\): File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 158, in \_\_get\_\_ rel\_obj = self\.field\.get\_cached\_value\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/mixins\.py", line 13, in get\_cached\_value return instance\.\_state\.fields\_cache\[cache\_name\] KeyError: 'activite\_commerce' During handling of the above exception, another exception occurred: Traceback \(most recent call last\): File "", line 1, in File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 164, in \_\_get\_\_ rel\_obj = self\.get\_object\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 139, in get\_object return qs\.get\(self\.field\.get\_reverse\_related\_filter\(instance\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 397, in get num = len\(clone\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 254, in \_\_len\_\_ self\.\_fetch\_all\(\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 1182, in \_fetch\_all self\.\_result\_cache = list\(self\.\_iterable\_class\(self\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 53, in \_\_iter\_\_ results = compiler\.execute\_sql\(chunked\_fetch=self\.chunked\_fetch, chunk\_size=self\.chunk\_size\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/sql/compiler\.py", line 1068, in execute\_sql cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 100, in execute return super\(\)\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 68, in execute return self\.\_execute\_with\_wrappers\(sql, params, many=False, executor=self\.\_execute\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 77, in \_execute\_with\_wrappers return executor\(sql, params, many, context\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 85, in \_execute return self\.cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/firebird/base\.py", line 262, in execute return self\.cursor\.execute\(q, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3627, in execute self\.\_ps\.\_execute\(parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3308, in \_execute self\.\_\_tuple2xsqlda\(self\.\_in\_sqlda, parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3091, in \_\_tuple2xsqlda len\(value\)\)\) ValueError: Value of parameter \(0\) is too long, expected 16, found 32 =\> Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: import uuid from django\.db import models class AgdeEtab\(models\.Model\): etab\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4, blank=False, null=False\) activite\_commerce = models\.ForeignKey\('AgdeActiviteCommerce', models\.DO\_NOTHING, blank=True, null=True\) class Meta: managed = False db\_table = 'agde\_etab' class AgdeActiviteCommerce\(models\.Model\): activite\_commerce\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4\) activite\_commerce\_lib = models\.CharField\(unique=True, max\_length=60\) class Meta: managed = False db\_table = 'agde\_activite\_commerce' \>\>\> from agde\.models import AgdeEtab \>\>\> etab = AgdeEtab\.objects\.get\(enseigne\_\_startswith='MIDAS'\) \>\>\> etab\.activite\_commerce Traceback \(most recent call last\): File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 158, in \_\_get\_\_ rel\_obj = self\.field\.get\_cached\_value\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/mixins\.py", line 13, in get\_cached\_value return instance\.\_state\.fields\_cache\[cache\_name\] KeyError: 'activite\_commerce' During handling of the above exception, another exception occurred: Traceback \(most recent call last\): File "", line 1, in File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 164, in \_\_get\_\_ rel\_obj = self\.get\_object\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 139, in get\_object return qs\.get\(self\.field\.get\_reverse\_related\_filter\(instance\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 397, in get num = len\(clone\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 254, in \_\_len\_\_ self\.\_fetch\_all\(\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 1182, in \_fetch\_all self\.\_result\_cache = list\(self\.\_iterable\_class\(self\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 53, in \_\_iter\_\_ results = compiler\.execute\_sql\(chunked\_fetch=self\.chunked\_fetch, chunk\_size=self\.chunk\_size\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/sql/compiler\.py", line 1068, in execute\_sql cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 100, in execute return super\(\)\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 68, in execute return self\.\_execute\_with\_wrappers\(sql, params, many=False, executor=self\.\_execute\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 77, in \_execute\_with\_wrappers return executor\(sql, params, many, context\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 85, in \_execute return self\.cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/firebird/base\.py", line 262, in execute return self\.cursor\.execute\(q, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3627, in execute self\.\_ps\.\_execute\(parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3308, in \_execute self\.\_\_tuple2xsqlda\(self\.\_in\_sqlda, parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3091, in \_\_tuple2xsqlda len\(value\)\)\) ValueError: Value of parameter \(0\) is too long, expected 16, found 32 When I debug line 3091, the value type is bytes with 32 alnum chars Feel free to ask if you need more details

[firebird-automations]

Modified by: Emmanuel Belair (ebelair)

description: Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: import uuid from django\.db import models class AgdeEtab\(models\.Model\): etab\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4, blank=False, null=False\) activite\_commerce = models\.ForeignKey\('AgdeActiviteCommerce', models\.DO\_NOTHING, blank=True, null=True\) class Meta: managed = False db\_table = 'agde\_etab' class AgdeActiviteCommerce\(models\.Model\): activite\_commerce\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4\) activite\_commerce\_lib = models\.CharField\(unique=True, max\_length=60\) class Meta: managed = False db\_table = 'agde\_activite\_commerce' \>\>\> from agde\.models import AgdeEtab \>\>\> etab = AgdeEtab\.objects\.get\(enseigne\_\_startswith='MIDAS'\) \>\>\> etab\.activite\_commerce Traceback \(most recent call last\): File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 158, in \_\_get\_\_ rel\_obj = self\.field\.get\_cached\_value\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/mixins\.py", line 13, in get\_cached\_value return instance\.\_state\.fields\_cache\[cache\_name\] KeyError: 'activite\_commerce' During handling of the above exception, another exception occurred: Traceback \(most recent call last\): File "", line 1, in File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 164, in \_\_get\_\_ rel\_obj = self\.get\_object\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 139, in get\_object return qs\.get\(self\.field\.get\_reverse\_related\_filter\(instance\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 397, in get num = len\(clone\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 254, in \_\_len\_\_ self\.\_fetch\_all\(\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 1182, in \_fetch\_all self\.\_result\_cache = list\(self\.\_iterable\_class\(self\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 53, in \_\_iter\_\_ results = compiler\.execute\_sql\(chunked\_fetch=self\.chunked\_fetch, chunk\_size=self\.chunk\_size\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/sql/compiler\.py", line 1068, in execute\_sql cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 100, in execute return super\(\)\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 68, in execute return self\.\_execute\_with\_wrappers\(sql, params, many=False, executor=self\.\_execute\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 77, in \_execute\_with\_wrappers return executor\(sql, params, many, context\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 85, in \_execute return self\.cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/firebird/base\.py", line 262, in execute return self\.cursor\.execute\(q, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3627, in execute self\.\_ps\.\_execute\(parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3308, in \_execute self\.\_\_tuple2xsqlda\(self\.\_in\_sqlda, parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3091, in \_\_tuple2xsqlda len\(value\)\)\) ValueError: Value of parameter \(0\) is too long, expected 16, found 32 When I debug line 3091, the value type is bytes with 32 alnum chars Feel free to ask if you need more details =\> Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: import uuid from django\.db import models class AgdeEtab\(models\.Model\): etab\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4, blank=False, null=False\) activite\_commerce = models\.ForeignKey\('AgdeActiviteCommerce', models\.DO\_NOTHING, blank=True, null=True\) class Meta: managed = False db\_table = 'agde\_etab' class AgdeActiviteCommerce\(models\.Model\): activite\_commerce\_id = models\.UUIDField\(primary\_key=True, default=uuid\.uuid4\) activite\_commerce\_lib = models\.CharField\(unique=True, max\_length=60\) class Meta: managed = False db\_table = 'agde\_activite\_commerce' In console : \>\>\> from agde\.models import AgdeEtab \>\>\> etab = AgdeEtab\.objects\.get\(enseigne\_\_startswith='MIDAS'\) \>\>\> etab\.activite\_commerce Traceback \(most recent call last\): File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 158, in \_\_get\_\_ rel\_obj = self\.field\.get\_cached\_value\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/mixins\.py", line 13, in get\_cached\_value return instance\.\_state\.fields\_cache\[cache\_name\] KeyError: 'activite\_commerce' During handling of the above exception, another exception occurred: Traceback \(most recent call last\): File "", line 1, in File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 164, in \_\_get\_\_ rel\_obj = self\.get\_object\(instance\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/fields/related\_descriptors\.py", line 139, in get\_object return qs\.get\(self\.field\.get\_reverse\_related\_filter\(instance\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 397, in get num = len\(clone\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 254, in \_\_len\_\_ self\.\_fetch\_all\(\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 1182, in \_fetch\_all self\.\_result\_cache = list\(self\.\_iterable\_class\(self\)\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/query\.py", line 53, in \_\_iter\_\_ results = compiler\.execute\_sql\(chunked\_fetch=self\.chunked\_fetch, chunk\_size=self\.chunk\_size\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/models/sql/compiler\.py", line 1068, in execute\_sql cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 100, in execute return super\(\)\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 68, in execute return self\.\_execute\_with\_wrappers\(sql, params, many=False, executor=self\.\_execute\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 77, in \_execute\_with\_wrappers return executor\(sql, params, many, context\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/utils\.py", line 85, in \_execute return self\.cursor\.execute\(sql, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/django/db/backends/firebird/base\.py", line 262, in execute return self\.cursor\.execute\(q, params\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3627, in execute self\.\_ps\.\_execute\(parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3308, in \_execute self\.\_\_tuple2xsqlda\(self\.\_in\_sqlda, parameters\) File "/home/manu/env01/fbtest/venv/lib/python3\.6/site\-packages/fdb/fbcore\.py", line 3091, in \_\_tuple2xsqlda len\(value\)\)\) ValueError: Value of parameter \(0\) is too long, expected 16, found 32 When I debug line 3091, the value type is bytes with 32 alnum chars Feel free to ask if you need more details