https://pulp.plan.io/https://pulp.plan.io/favicon.ico2018-12-21T15:48:35ZPulpPulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=329552018-12-21T15:48:35Zdaviddavis
<ul><li><strong>Blocks</strong> <i><a class="issue tracker-2 status-11 priority-6 priority-default closed" href="/issues/4270">Task #4270</a>: Add support for MariaDB and MySQL</i> added</li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=329932019-01-02T15:53:45Zdaviddavis
<ul></ul><p>There are 5 instances in Pulp where we have TextFields with db indexes. They're all name fields. I noticed in some cases (e.g. ContentGuard, Distribution) we are using CharField. So to reiterate, the options are:</p>
<p>1. Change all names to use CharField and thus avoiding having to write raw SQL in our migrations<br>
2. Write a migration with some raw sql to create the key with a length. I am not sure how db agnostic this is though.</p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=329942019-01-02T15:59:30Zdaviddavis
<ul><li><strong>Blocks</strong> <i><a class="issue tracker-2 status-13 priority-6 priority-default closed" href="/issues/4290">Task #4290</a>: Investigate performance of Pulp with UUID PKs</i> added</li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=329992019-01-02T18:28:03Zttereshcttereshc@redhat.com
<ul></ul><p>+1 to option 1, CharField.</p>
<p>In my opinion, we don't have a real need for TextField for names. And it seems that it's easier to stay DB-agnostic with a CharField and for some DBs it will also mean a performance gain (not for PostgreSQL though, it doesn't matter for it, AFAIK)</p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330002019-01-02T18:29:32Zbmbouterbmbouter@redhat.com
<ul></ul><p>+1 to CharField</p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330012019-01-02T18:31:56Zdkliban@redhat.com
<ul></ul><p>we should go with the CharField</p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330052019-01-02T19:52:07Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>NEW</i> to <i>POST</i></li><li><strong>Assignee</strong> set to <i>daviddavis</i></li></ul><p><a href="https://github.com/pulp/pulp/pull/3817" class="external">https://github.com/pulp/pulp/pull/3817</a></p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330382019-01-03T21:43:55Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>POST</i> to <i>MODIFIED</i></li></ul><p>Applied in changeset <a class="changeset" title="MySQL doesn't support text fields as indexes Changing fields from text to char since MySQL doesn..." href="https://pulp.plan.io/projects/pulp/repository/pulp/revisions/ed49af030fcd78fb1d20aedd157b64951801d1ce">pulp|ed49af030fcd78fb1d20aedd157b64951801d1ce</a>.</p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330422019-01-03T21:58:55Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>MODIFIED</i> to <i>ASSIGNED</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330462019-01-03T22:51:10Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>ASSIGNED</i> to <i>MODIFIED</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330472019-01-03T22:53:30Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>MODIFIED</i> to <i>ASSIGNED</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=330482019-01-03T23:19:39Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>ASSIGNED</i> to <i>MODIFIED</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=333202019-01-16T21:09:36Zdalleydalley@redhat.com
<ul><li><strong>Blocks</strong> deleted (<i><a class="issue tracker-2 status-13 priority-6 priority-default closed" href="/issues/4290">Task #4290</a>: Investigate performance of Pulp with UUID PKs</i>)</li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=342242019-02-25T12:17:27Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>MODIFIED</i> to <i>POST</i></li></ul><p>Additional pulp_file PR:</p>
<p><a href="https://github.com/pulp/pulp_file/pull/153" class="external">https://github.com/pulp/pulp_file/pull/153</a></p> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=343012019-02-26T14:46:42Zdaviddavis
<ul><li><strong>Status</strong> changed from <i>POST</i> to <i>MODIFIED</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=413902019-04-25T16:44:56Zdaviddavis
<ul><li><strong>Sprint/Milestone</strong> set to <i>3.0.0</i></li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=421552019-04-26T20:32:42Zbmbouterbmbouter@redhat.com
<ul><li><strong>Tags</strong> deleted (<del><i>Pulp 3, Pulp 3 RC Blocker</i></del>)</li></ul> Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length")https://pulp.plan.io/issues/4288?journal_id=505732019-12-13T17:10:09Zbmbouterbmbouter@redhat.com
<ul><li><strong>Status</strong> changed from <i>MODIFIED</i> to <i>CLOSED - CURRENTRELEASE</i></li></ul>