On Thu, Nov 15, 2012 at 11:29 AM, Moti Asayag <span dir="ltr"><<a href="mailto:masayag@redhat.com" target="_blank">masayag@redhat.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">I tried same scenario but haven't got any error like this. However, I'm</div>
working on the latest version...<br>
<br>
Could you send the content of the vds_interface table ? even off-list so<br>
I can try to debug it on my system ?<br>
<div class="HOEnZb"><div class="h5"></div></div></blockquote></div><br><div>Be sure to read my other post before running with this as it may be a dead end, but here is the dump from last night's backup (just the one row):</div>
<div><br></div><div><div><font face="courier new, monospace">--</font></div><div><font face="courier new, monospace">-- Name: vds_interface; Type: TABLE; Schema: public; Owner: engine; Tablespace: </font></div><div><font face="courier new, monospace">--</font></div>
<div><font face="courier new, monospace"><br></font></div><div><font face="courier new, monospace">CREATE TABLE vds_interface (</font></div><div><font face="courier new, monospace"> id uuid NOT NULL,</font></div><div>
<font face="courier new, monospace"> name character varying(50) NOT NULL,</font></div>
<div><font face="courier new, monospace"> network_name character varying(50),</font></div><div><font face="courier new, monospace"> vds_id uuid,</font></div><div><font face="courier new, monospace"> mac_addr character varying(20),</font></div>
<div><font face="courier new, monospace"> is_bond boolean DEFAULT false,</font></div><div><font face="courier new, monospace"> bond_name character varying(50),</font></div><div><font face="courier new, monospace"> bond_type integer,</font></div>
<div><font face="courier new, monospace"> bond_opts character varying(4000),</font></div><div><font face="courier new, monospace"> vlan_id integer,</font></div><div><font face="courier new, monospace"> speed integer,</font></div>
<div><font face="courier new, monospace"> addr character varying(20),</font></div><div><font face="courier new, monospace"> subnet character varying(20),</font></div><div><font face="courier new, monospace"> gateway character varying(20),</font></div>
<div><font face="courier new, monospace"> boot_protocol integer,</font></div><div><font face="courier new, monospace"> type integer DEFAULT 0,</font></div><div><font face="courier new, monospace"> _create_date timestamp with time zone DEFAULT ('now'::text)::timestamp without time zone,</font></div>
<div><font face="courier new, monospace"> _update_date timestamp with time zone,</font></div><div><font face="courier new, monospace"> mtu integer,</font></div><div><font face="courier new, monospace"> bridged boolean DEFAULT true NOT NULL</font></div>
<div><font face="courier new, monospace">);</font></div></div><div><font face="courier new, monospace"><br></font></div><div><div><font face="courier new, monospace">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)</font></div>
<div><font face="courier new, monospace"> 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);</font></div>
<div><font face="courier new, monospace">END; $$;</font></div></div><div><br></div><div><br></div><div>Thanks!</div>