Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. Re: error trying to add a comment to a circuit (Carlos Vicente)
2. [Netdot - Bug #1691] (Resolved) DeviceModule dups problem
([email protected])
----------------------------------------------------------------------
Message: 1
Date: Thu, 27 Sep 2012 10:13:53 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] error trying to add a comment to a circuit
To: Karl Putland <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
I'm trying to reproduce this, but I can't. I've added circuits and
sites, added long comments, nothing.
Also if I issue that SQL query manually, it works OK in Pg.
cv
On 9/19/12 6:20 PM, Karl Putland wrote:
> *edit.html* produced the following error:
>
> Transaction aborted: Circuit can't SELECT id, status, cid, type, linkid,
> vendor
> FROM circuit
> WHERE id = ?
> : DBD::Pg::st execute failed: ERROR: current transaction is aborted,
> commands ignored until end of transaction block [for Statement "SELECT id,
> status, cid, type, linkid, vendor
> FROM circuit
> WHERE id = ?
> " with ParamValues: 1='444'] at
> /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
>
> Stack:
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]
> [/usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm:169]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1094]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:669]
> [/usr/local/netdot/lib/Netdot/Model.pm:848]
> [/usr/local/netdot/htdocs/generic/edit.html:144]
> [/usr/local/netdot/htdocs/generic/edit.html:145]
> [/usr/local/netdot/htdocs/autohandler:110]
> [/usr/local/netdot/htdocs/cable_plant/dhandler:1]
> [/usr/local/netdot/htdocs/cable_plant/autohandler:353]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/cable_plant/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm line 169.
>
> Stack:
> [/usr/local/share/perl/5.14.2/Carp.pm:100]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:169]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1143]
> [/usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm:169]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1094]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:669]
> [/usr/local/netdot/lib/Netdot/Model.pm:848]
> [/usr/local/netdot/htdocs/generic/edit.html:144]
> [/usr/local/netdot/htdocs/generic/edit.html:145]
> [/usr/local/netdot/htdocs/autohandler:110]
> [/usr/local/netdot/htdocs/cable_plant/dhandler:1]
> [/usr/local/netdot/htdocs/cable_plant/autohandler:353]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/cable_plant/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
>
>
> This may be the result of invalid user input. However, if you believe
> this is a bug, please click here
> <http://netdot.simplesignal.net/netdot/cable_plant/edit.html#>, then
> copy the full error message and send it to [email protected]
> <mailto:[email protected]>
>
> Trace begun at /usr/local/netdot/lib/Netdot.pm line 83
> Netdot::throw_fatal('Netdot::Model', 'Transaction aborted: Circuit
> can\'t SELECT id, status, cid, type, linkid, vendor^JFROM circuit^JWHERE
> id = ?^J: DBD::Pg::st execute failed: ERROR: current transaction is
> aborted, commands ignored until end of transaction block [for Statement
> "SELECT id, status, cid, type, linkid, vendor^JFROM circuit^JWHERE id =
> ?^J" with ParamValues: 1=\'444\'] at
> /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line
> 52.^J^JStack:^J
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
> [/usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm:169]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1094]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:669]^J
> [/usr/local/netdot/lib/Netdot/Model.pm:848]^J
> [/usr/local/netdot/htdocs/generic/edit.html:144]^J
> [/usr/local/netdot/htdocs/generic/edit.html:145]^J
> [/usr/local/netdot/htdocs/autohandler:110]^J
> [/usr/local/netdot/htdocs/cable_plant/dhandler:1]^J
> [/usr/local/netdot/htdocs/cable_plant/autohandler:353]^J
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/cable_plant/autohandler.obj:21]^J
> [/usr/local/netdot/htdocs/autohandler:76]^J at
> /usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm line
> 169.^J^JStack:^J [/usr/local/share/perl/5.14.2/Carp.pm:100]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:169]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1143]^J
> [/usr/local/share/perl/5.14.2/Class/DBI/Search/Basic.pm:169]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1094]^J
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:669]^J
> [/usr/local/netdot/lib/Netdot/Model.pm:848]^J
> [/usr/local/netdot/htdocs/generic/edit.html:144]^J
> [/usr/local/netdot/htdocs/generic/edit.html:145]^J
> [/usr/local/netdot/htdocs/autohandler:110]^J
> [/usr/local/netdot/htdocs/cable_plant/dhandler:1]^J
> [/usr/local/netdot/htdocs/cable_plant/autohandler:353]^J
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/cable_plant/autohandler.obj:21]^J
> [/usr/local/netdot/htdocs/autohandler:76]^J') called at
> /usr/local/netdot/lib/Netdot/Model.pm line 763
> Netdot::Model::do_transaction('Netdot::Model', 'CODE(0x7f6ef80ec148)')
> called at /usr/local/netdot/htdocs/generic/edit.html line 145 eval {...}
> at /usr/local/netdot/htdocs/generic/edit.html line 138
> HTML::Mason::Commands::__ANON__('installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'request', 'edit.html',
> 'showheader', 1, 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type',
> '', 'selected', '', '_444_linkid_srch', 'Keywords', 'vendor', 33) called
> at /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f6ef006bcd8)',
> 'installdate', '', 'status', 1, 'submit', 'Update', 'table', 'Circuit',
> 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'request', 'edit.html', 'showheader', 1,
> 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type', '', 'selected',
> '', '_444_linkid_srch', 'Keywords', 'vendor', 33) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305 eval {...}
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
> HTML::Mason::Request::comp(undef, undef, 'installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'request', 'edit.html',
> 'showheader', 1, 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type',
> '', 'selected', '', '_444_linkid_srch', 'Keywords', 'vendor', 33) called
> at /usr/local/netdot/htdocs/autohandler line 110
> HTML::Mason::Commands::__ANON__('request', 'edit.html', 'installdate',
> '', 'status', 1, 'table', 'Circuit', 'submit', 'Update', 'linkid', '',
> 'select_id', '', 'state_digest', 'f3016c15999021bf06216693a907007a',
> 'speed', '', 'loss', '', 'id', 444, 'datetested', '', 'info',
> 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER NAME: Butterfly Pavilion
> ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO, 80020 ^M^JXO Circuit ID:
> DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID: 29.HCFX.098663..MS ^M^JLEC
> Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4
> OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc extended to server room /
> electrical room, RJ48X jack on back board next to adtran. Tagged.',
> 'showheader', 1, 'dowindow', 0, 'type', '', 'cid', 'DV/HCFS/831184/
> /TQW', '_444_linkid_srch', 'Keywords', 'selected', '', 'vendor', 33)
> called at /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::Subcomponent=HASH(0x7f6f080e2ee0)',
> 'request', 'edit.html', 'installdate', '', 'status', 1, 'table',
> 'Circuit', 'submit', 'Update', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'showheader', 1,
> 'dowindow', 0, 'type', '', 'cid', 'DV/HCFS/831184/ /TQW',
> '_444_linkid_srch', 'Keywords', 'selected', '', 'vendor', 33) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305 eval {...}
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
> HTML::Mason::Request::comp(undef, undef, 'request', 'edit.html',
> 'installdate', '', 'status', 1, 'table', 'Circuit', 'submit', 'Update',
> 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'type', '', 'cid',
> 'DV/HCFS/831184/ /TQW', '_444_linkid_srch', 'Keywords', 'selected', '',
> 'vendor', 33) called at /usr/local/netdot/htdocs/cable_plant/dhandler
> line 1 HTML::Mason::Commands::__ANON__('installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'showheader', 1,
> 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type', '', 'selected',
> '', '_444_linkid_srch', 'Keywords', 'vendor', 33, 'showheader', 1)
> called at /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f6f445f2788)',
> 'installdate', '', 'status', 1, 'submit', 'Update', 'table', 'Circuit',
> 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'cid',
> 'DV/HCFS/831184/ /TQW', 'type', '', 'selected', '', '_444_linkid_srch',
> 'Keywords', 'vendor', 33, 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305 eval {...}
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
> HTML::Mason::Request::comp(undef, undef, undef, 'installdate', '',
> 'status', 1, 'submit', 'Update', 'table', 'Circuit', 'linkid', '',
> 'select_id', '', 'state_digest', 'f3016c15999021bf06216693a907007a',
> 'speed', '', 'loss', '', 'id', 444, 'datetested', '', 'info',
> 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER NAME: Butterfly Pavilion
> ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO, 80020 ^M^JXO Circuit ID:
> DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID: 29.HCFX.098663..MS ^M^JLEC
> Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4
> OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc extended to server room /
> electrical room, RJ48X jack on back board next to adtran. Tagged.',
> 'showheader', 1, 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type',
> '', 'selected', '', '_444_linkid_srch', 'Keywords', 'vendor', 33,
> 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 958
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f6f445d11d0)')
> called at /usr/local/netdot/htdocs/cable_plant/autohandler line 353
> HTML::Mason::Commands::__ANON__('installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'showheader', 1,
> 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type', '', 'selected',
> '', '_444_linkid_srch', 'Keywords', 'vendor', 33, 'showheader', 1)
> called at /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 160
> HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f6f0824bec0)',
> 'main', 'installdate', '', 'status', 1, 'submit', 'Update', 'table',
> 'Circuit', 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'cid',
> 'DV/HCFS/831184/ /TQW', 'type', '', 'selected', '', '_444_linkid_srch',
> 'Keywords', 'vendor', 33, 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 951
> HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f6f445d11d0)',
> 'main', 'installdate', '', 'status', 1, 'submit', 'Update', 'table',
> 'Circuit', 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'cid',
> 'DV/HCFS/831184/ /TQW', 'type', '', 'selected', '', '_444_linkid_srch',
> 'Keywords', 'vendor', 33, 'showheader', 1) called at
> /usr/local/netdot/htdocs/masondata/obj/1292882063/cable_plant/autohandler.obj
> line 21 HTML::Mason::Commands::__ANON__('installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'showheader', 1,
> 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type', '', 'selected',
> '', '_444_linkid_srch', 'Keywords', 'vendor', 33, 'showheader', 1)
> called at /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f6f0824bec0)',
> 'installdate', '', 'status', 1, 'submit', 'Update', 'table', 'Circuit',
> 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'cid',
> 'DV/HCFS/831184/ /TQW', 'type', '', 'selected', '', '_444_linkid_srch',
> 'Keywords', 'vendor', 33, 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305 eval {...}
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
> HTML::Mason::Request::comp(undef, undef, undef, 'installdate', '',
> 'status', 1, 'submit', 'Update', 'table', 'Circuit', 'linkid', '',
> 'select_id', '', 'state_digest', 'f3016c15999021bf06216693a907007a',
> 'speed', '', 'loss', '', 'id', 444, 'datetested', '', 'info',
> 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER NAME: Butterfly Pavilion
> ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO, 80020 ^M^JXO Circuit ID:
> DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID: 29.HCFX.098663..MS ^M^JLEC
> Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4
> OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc extended to server room /
> electrical room, RJ48X jack on back board next to adtran. Tagged.',
> 'showheader', 1, 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type',
> '', 'selected', '', '_444_linkid_srch', 'Keywords', 'vendor', 33,
> 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 958
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f6f445d11d0)',
> 'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
> HTML::Mason::Commands::__ANON__('installdate', '', 'status', 1,
> 'submit', 'Update', 'table', 'Circuit', 'linkid', '', 'select_id', '',
> 'state_digest', 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss',
> '', 'id', 444, 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information:
> ^M^JCUSTOMER NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE,
> WESTMINSTER CO, 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC
> Circuit ID: 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC
> LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT
> EXTENDED. ^M^JDmarc extended to server room / electrical room, RJ48X
> jack on back board next to adtran. Tagged.', 'showheader', 1,
> 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type', '', 'selected',
> '', '_444_linkid_srch', 'Keywords', 'vendor', 33) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f6f080e3210)',
> 'installdate', '', 'status', 1, 'submit', 'Update', 'table', 'Circuit',
> 'linkid', '', 'select_id', '', 'state_digest',
> 'f3016c15999021bf06216693a907007a', 'speed', '', 'loss', '', 'id', 444,
> 'datetested', '', 'info', 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER
> NAME: Butterfly Pavilion ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO,
> 80020 ^M^JXO Circuit ID: DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID:
> 29.HCFX.098663..MS ^M^JLEC Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT
> MAIN IT, CABINET #1, SLOT 4 OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc
> extended to server room / electrical room, RJ48X jack on back board next
> to adtran. Tagged.', 'showheader', 1, 'dowindow', 0, 'cid',
> 'DV/HCFS/831184/ /TQW', 'type', '', 'selected', '', '_444_linkid_srch',
> 'Keywords', 'vendor', 33) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1300 eval {...}
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
> HTML::Mason::Request::comp(undef, undef, undef, 'installdate', '',
> 'status', 1, 'submit', 'Update', 'table', 'Circuit', 'linkid', '',
> 'select_id', '', 'state_digest', 'f3016c15999021bf06216693a907007a',
> 'speed', '', 'loss', '', 'id', 444, 'datetested', '', 'info',
> 'Z-LOCATION: Dmarc Information: ^M^JCUSTOMER NAME: Butterfly Pavilion
> ^M^JADDRESS: 6252 W 104TH AVE, WESTMINSTER CO, 80020 ^M^JXO Circuit ID:
> DV/HCFS/831184/ /TQW ^M^JLEC Circuit ID: 29.HCFX.098663..MS ^M^JLEC
> Order #: N28757722 ^M^JDEMARC LOC: 1ST FLOOT MAIN IT, CABINET #1, SLOT 4
> OF 4, RJ48C, TAGGED NOT EXTENDED. ^M^JDmarc extended to server room /
> electrical room, RJ48X jack on back board next to adtran. Tagged.',
> 'showheader', 1, 'dowindow', 0, 'cid', 'DV/HCFS/831184/ /TQW', 'type',
> '', 'selected', '', '_444_linkid_srch', 'Keywords', 'vendor', 33) called
> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484 eval
> {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484
> eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line
> 436
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f6f445d11d0)')
> called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm line
> 168
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f6f445d11d0)')
> called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm line
> 825
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f6f3e6463c8)',
> 'Apache2::RequestRec=SCALAR(0x7f6f084c5650)') called at
> /usr/local/netdot/lib/Netdot/Mason.pm line 40
> Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f6f084c5650)')
> called at -e line 0 eval {...} at -e line 0
>
>
> --Karl
>
> Karl Putland
> Senior VoIP Engineer
>
> *SimpleSignal*
> 3600 S Yosemite, Suite 150
> Denver, CO 80237
> One Number Rings All My Phones: 303-242-8608
>
> SimpleSignal.com <http://www.simplesignal.com/> | Blog
> <http://www.simplesignal.com/blog> | Facebook
> <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> <http://twitter.com/simplesignal>
>
>
>
> _______________________________________________
> Netdot-devel mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-devel
>
--
cv
------------------------------
Message: 2
Date: Thu, 27 Sep 2012 07:14:47 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1691] (Resolved) DeviceModule
dups problem
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1691 has been updated by Carlos Vicente.
Status changed from New to Resolved
Resolution set to fixed
----------------------------------------
Bug #1691: DeviceModule dups problem
https://osl.uoregon.edu/redmine/issues/1691#change-2968
Author: Carlos Vicente
Status: Resolved
Priority: High
Assignee: Carlos Vicente
Category: DeviceManagement
Target version: 1.0.2
Resolution: fixed
{{{
Sep 25 12:01:11 netdot: ERROR - Error while inserting DeviceModule: Some
values are duplicated Error details: Can't insert new DeviceModule:
DBD::mysql::st execute failed: Duplicate entry '3326-1000000' for key 2 [for
Statement "INSERT INTO devicemodule (last_updated, fru, date_installed, number,
device, description, contained_in, asset_id, type, class, pos) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?) " with ParamValues: 0='2012/09/25 12:01:11', 1=0,
2='2012/09/25 12:01:11', 3=1000000, 4='3326', 5='Juniper MX960 Internet
Backbone Router', 6='00000000', 7='673', 8='jnxChassisMX960', 9='chassis',
10='01000000'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line
52. at /usr/local/netdot/lib/Netdot/Model/Device.pm line 5475
Sep 25 12:01:11 netdot: ERROR - Error while inserting DeviceModule: Some
values are duplicated Error details: Can't insert new DeviceModule:
DBD::mysql::st execute failed: Duplicate entry '3326-1000000' for key 2 [for
Statement "INSERT INTO devicemodule (last_updated, fru, date_installed, number,
device, description, contained_in, asset_id, type, class, pos) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?) " with ParamValues: 0='2012/09/25 12:01:11', 1=0,
2='2012/09/25 12:01:11', 3=1000000, 4='3326', 5='Juniper MX960 Internet
Backbone Router', 6='00000000', 7='673', 8='jnxChassisMX960', 9='chassis',
10='01000000'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line
52. at /usr/local/netdot/lib/Netdot/Model/Device.pm line 5475
Sep 25 12:02:03 netdot: ERROR - Error while inserting DeviceModule: Some
values are duplicated Error details: Can't insert new DeviceModule:
DBD::mysql::st execut
e failed: Duplicate entry '2081-1000000' for key 2 [for Statement "INSERT INTO
devicemodule (last_updated, fru, date_installed, number, device, description,
contained_in, asset_i
d, type, class, pos) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) " with
ParamValues: 0='2012/09/25 12:02:03', 1=0, 2='2012/09/25 12:02:03', 3=1000000,
4='2081', 5='Juniper M120 Inte
rnet Backbone Router', 6='00000000', 7='1985', 8='jnxChassisM120', 9='chassis',
10='01000000'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line
52. at /usr/local/n
etdot/lib/Netdot/Model/Device.pm line 5475
Sep 25 12:02:03 netdot: ERROR - Error while inserting DeviceModule: Some
values are duplicated Error details: Can't insert new DeviceModule:
DBD::mysql::st execute failed: Duplicate entry '2081-1000000' for key 2 [for
Statement "INSERT INTO devicemodule (last_updated, fru, date_installed, number,
device, description, contained_in, asset_id, type, class, pos) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?) " with ParamValues: 0='2012/09/25 12:02:03', 1=0,
2='2012/09/25 12:02:03', 3=1000000, 4='2081', 5='Juniper M120 Internet Backbone
Router', 6='00000000', 7='1985', 8='jnxChassisM120', 9='chassis',
10='01000000'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line
52. at /usr/local/netdot/lib/Netdot/Model/Device.pm line 5475
}}}
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 66, Issue 23
********************************************
