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: Asset search error (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Mon, 17 Sep 2012 14:29:00 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] Asset search error
To: Karl Putland <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Karl,
I'm sorry that you are finding so many problems with Pg. We use mysql in
production and unfortunately have not had time to do exhaustive testing
on Pg.
I am saving all your reports and plan to fix these bugs soon.
Thank you,
cv
On 9/17/12 12:33 PM, Karl Putland wrote:
> Click Management/Assets,
> Click Search button
>
>
> This is likely a Pg query issue...
>
> *System error*
>
> *96:* local @CARP_NOT = $cgc ? $cgc->() :
> caller();*97:* shortmess_heavy(@_);*98:* }*99:* *100:* *101:* sub
> confess { die longmess @_ }*102:* sub carp { warn shortmess @_
> }*103:* sub cluck { warn longmess @_ }*104:* *...*
> *error:* Asset can't SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
> : DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown
> LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
> ^
> HINT: No operator matches the given name and argument type(s). *You
> might need to add explicit type casts*. [for Statement "SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
> " with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%',
> 7='%%'] 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.pm:1083]
> [/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
> [/usr/local/netdot/htdocs/management/asset_tasks.html:240]
> [/usr/local/netdot/htdocs/management/autohandler:81]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
> *context:* *...* sub croak { die shortmess @_ }
> *code 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.pm:1083
> /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33
> /usr/local/netdot/htdocs/management/asset_tasks.html:240
> /usr/local/netdot/htdocs/management/autohandler:81
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951
> /usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21
> /usr/local/netdot/htdocs/autohandler:76
>
> raw error
> <http://netdot.simplesignal.net/netdot/management/asset_tasks.html#raw>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Asset can't SELECT id, serial_number, product_id, inventory_number, physaddr,
> reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
> LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
> maint_contract LIKE ? ) )
> : DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown
> LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
> ^
> HINT: No operator matches the given name and argument type(s). You might
> need to add explicit type casts. [for Statement "SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
> LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
> maint_contract LIKE ? ) )
> " with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%', 7='%%']
> 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.pm:1083]
> [/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
> [/usr/local/netdot/htdocs/management/asset_tasks.html:240]
> [/usr/local/netdot/htdocs/management/autohandler:81]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
>
>
> Trace begun at /usr/local/share/perl/5.14.2/HTML/Mason/Exceptions.pm line 129
> HTML::Mason::Exceptions::rethrow_exception('Asset can\'t SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J: DBD::Pg::st
> execute failed: ERROR: operator does not exist: bigint ~~ unknown^JLINE 3:
> ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator
> matches the given name and argument type(s). You might need to add explicit
> type casts. [for Statement "SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J" with Pa!
ramValues:
1=\'%%\', 2=\'%%\', 3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] 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.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J at
/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.^J') called at
/usr/local/share/perl/5.14.2/Carp.pm line 100
> Carp::croak('Asset can\'t SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J: DBD::Pg::st execute failed: ERROR: operator
> does not exist: bigint ~~ unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6
> OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator matches the given name and argument
> type(s). You might need to add explicit type casts. [for Statement "SELECT
> id, serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with ParamValues:
> 1=\'%%\', 2=\'%%\', !
3=\'%%\',
4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] 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.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 169
> Class::DBI::_croak('Asset', 'Asset can\'t SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from,
> maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J: DBD::Pg::st
> execute failed: ERROR: operator does not exist: bigint ~~ unknown^JLINE 3:
> ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator
> matches the given name and argument type(s). You might need to add explicit
> type casts. [for Statement "SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J" with ParamValues: 1=\'!
%%\', 2=\'
%%\', 3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] 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.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
'HTML::Mason::Exception=HASH(0x7f67b8157c18)') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 1143
> Class::DBI::sth_to_objects('Asset',
> 'DBIx::ContextualFetch::st=HASH(0x7f67b8162de0)', 'ARRAY(0x7f67fd32c490)')
> called at /usr/local/share/perl/5.14.2/Class/DBI.pm line 1083
> Class::DBI::retrieve_from_sql('Asset', '( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )', '%%', '%%', '%%',
> '%%', '%%', '%%', '%%') called at
> /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33
> Class::DBI::AbstractSearch::search_where('Asset', 'ARRAY(0x7f67b8090b70)')
> called at /usr/local/netdot/htdocs/management/asset_tasks.html line 240
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67b80a0f78)',
> 'search', '', 'submit', 'Search', 'search_type', 'all', 'showheader', 1,
> 'page', 'ASSETS') 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, 'search', '', 'submit',
> 'Search', 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') 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(0x7f67ac037b50)',
> 'page', 'ASSETS') called at /usr/local/netdot/htdocs/management/autohandler
> line 81
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', '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(0x7f67ac00d760)',
> 'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
> '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(0x7f67ac037b50)',
> 'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at
> /usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj
> line 21
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', '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(0x7f67ac00d760)',
> 'search', '', 'submit', 'Search', 'search_type', 'all', '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, 'search', '', 'submit',
> 'Search', 'search_type', 'all', '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(0x7f67ac037b50)',
> 'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all') called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67ac0377a8)',
> 'search', '', 'submit', 'Search', 'search_type', 'all') 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, 'search', '', 'submit',
> 'Search', 'search_type', 'all') 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(0x7f67ac037b50)')
> 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(0x7f67ac037b50)')
> called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm line 825
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f67fc594c78)',
> 'Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)') called at
> /usr/local/netdot/lib/Netdot/Mason.pm line 40
> Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)') 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
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 66, Issue 14
********************************************
