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

PostGIS trac at osgeo.org
Wed Apr 17 16:57:58 PDT 2013


#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):

 Correct, and I amd seeing the following in 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 7776) 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-16
 23:30:32 EDT
 FATAL:  the database system is in recovery mode
 LOG:  database system was not properly shut down; automatic recovery in
 progress
 LOG:  record with zero length at 0/57E89B8
 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:9>
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.


More information about the postgis-tickets mailing list