[postgis-tickets] [PostGIS] #2260: Benchmarking speed between built-in tiger normalizer and pagc_address_parser

[PostGIS]

#2260: Benchmarking speed between built-in tiger normalizer and
pagc_address_parser
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe         
     Type:  task                 |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.1.0
Component:  pagc_address_parser  |     Version:  trunk        
 Keywords:                       |  
---------------------------------+------------------------------------------

Comment(by woodbri):

 I just recompiled without cassert enabled and I'm still getting the TRAP
 in the logfile and it crashes.

 {{{
 $ ./config.status -V
 PostgreSQL config.status 9.2.2
 configured by ./configure, generated by GNU Autoconf 2.63,
   with options "'--prefix=/c/ming64/projects/pgx64/pg92' '--
 build=x86_64-w64-min
 gw32' '--host=x86_64-w64-mingw32' '--target=x86_64-w64-mingw32' '--with-
 pgport=5
 441' '--enable-debug' '--enable-integer-datetimes' '--disable-
 float8-byval' '--w
 ithout-zlib' 'build_alias=x86_64-w64-mingw32'
 'host_alias=x86_64-w64-mingw32' 't
 arget_alias=x86_64-w64-mingw32'"
 }}}

 And here is the logfile:

 {{{
 TRAP: FailedAssertion("!(context != CurrentMemoryContext)", File:
 "mcxt.c", Line
 : 172)
 ^M
 This application has requested the Runtime to terminate it in an unusual
 way.
 Please contact the application's support team for more information.^M
 LOG:  server process (PID 3632) exited with exit code 3^M
 DETAIL:  Failed process was running: select * from
 standardize_address('select *
  from lex', 'select * from gaz', 'select * from rules', 'select 1::integer
 as id
 , ''123 Main Street''::text as micro, ''Kansas City, MO 45678''::text as
 macro')
 ;^M
 LOG:  terminating any other active server processes^M
 WARNING:  terminating connection because of crash of another server
 process
 DETAIL:  The postmaster has commanded this server process to roll back the
 curre
 nt transaction and exit, because another server process exited abnormally
 and po
 ssibly corrupted shared memory.
 HINT:  In a moment you should be able to reconnect to the database and
 repeat yo
 ur command.
 LOG:  all server processes terminated; reinitializing^M
 LOG:  database system was interrupted; last known up at 2013-04-20
 20:47:35 EDT
 LOG:  database system was not properly shut down; automatic recovery in
 progress
 LOG:  record with zero length at 0/57EBD90
 LOG:  redo is not required
 LOG:  database system is ready to accept connections^M
 LOG:  autovacuum launcher started
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2260#comment:18>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.