[Engine-devel] value too long for type character varying(20) in function "insertvds_interface"

[Itamar Heim]

On 05/11/2012 03:52 AM, Itzik Brown wrote:
> Hi,
>
> When running VDSM on host with Infiniband HCAs I get the following errors in /usr/share/jboss-as/standalone/log/server.log on the ovirt-engine host.
>
> WARN  [org.ovirt.engine.core.vdsbroker.VdsManager] (QuartzScheduler_Worker-17) ResourceManager::refreshVdsRunTimeInfo::Failed to refresh VDS , vds = 783eb0ac-9a91-11e1-a8e4-000c29de7759 : xena003, error = DataIntegrityViolationException: CallableStatementCallback; SQL [{call insertvds_interface(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: value too long for type character varying(20)
>    Where: SQL statement "INSERT INTO vds_interface(addr, bond_name, bond_type, gateway, id, is_bond, bond_opts, mac_addr, name, network_name, speed, subnet, boot_protocol, type, VDS_ID, vlan_id, mtu, bridged)
>          VALUES(v_addr, v_bond_name, v_bond_type, v_gateway, v_id, v_is_bond, v_bond_opts, v_mac_addr, v_name, v_network_name, v_speed, v_subnet, v_boot_protocol, v_type, v_vds_id, v_vlan_id, v_mtu, v_bridged)"
>
> More detailed log:
> http://pastebin.com/AHD3di5i
>
> VDSM: From git repository commit 8a14b63fbbafbdb9ee7f85a9b702bff310f4f668
> oVirt-engine: From git repository comit b24dddf094e08afa6a2032a487b37476318a872d
>
> Any suggestions?

in general, you would need to send a patch to upgrade the scheme to a 
value longer than 20 characters for a logical network name.
1. I think bridge name is linux is limited to 15 characters, so not
    sure actually why 20 are allowed today. danken?
2. if changing the db scheme of the engine, also need to remember to
    upgrade the history db as well.
3. if different network implementation can support varying lengths,
    need to add validations in engine ("CanDoAction") to check the
    length per type of network implementation.

>
> Regards,
> Itzik
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel