Bug #15879

partition tables are limited to 4096 characters

Added by Tomáš Strachota 12 months ago. Updated 12 months ago.

Status:Duplicate
Priority:Normal
Assigned To:-
Category:Templates
Target version:Team Marek backlog
Difficulty: Bugzilla link:1321140
Found in release: Pull request:
Story points-
Velocity based estimate-

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1321140
Description of problem:

Satellite 6.1

The patch removes the limit varchar(4096) which will be released in 6.2. Can we have also a patch for the version 6.1.

foreman=# \d ptables
Table "public.ptables"
Column | Type | Modifiers
------------+-----------------------------+------------------------------------------------------
id | integer | not null default nextval('ptables_id_seq'::regclass)
name | character varying(255) | not null
layout | character varying(4096) | not null <=== it has a MAX varchar() limit on the table
created_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
os_family | character varying(255) |
Indexes:

Always, it is documented in the named foreman issues:
http://projects.theforeman.org/issues/12119
http://projects.theforeman.org/issues/3008

There is also a fix that has been committed for foreman 1.8:
https://github.com/theforeman/foreman/pull/2113/files

History

#1 Updated by Tomáš Strachota 12 months ago

  • Target version set to Team Marek backlog

#2 Updated by Dominic Cleal 12 months ago

  • Status changed from New to Need more information
  • Priority changed from Urgent to Normal

Can you expand on this please? It doesn't look like an issue in Foreman still.

The ptables table hasn't existed for many releases, and both of the associated tickets are resolved - extending the size of the existing table, and later moving partition tables.

#3 Updated by Marek Hulán 12 months ago

  • Status changed from Need more information to Closed

This has been fixed as #3008, sorry.

#4 Updated by Dominic Cleal 12 months ago

  • Status changed from Closed to Duplicate

Also available in: Atom PDF