pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

Fatal error when loading a data file - FATAL error: In context KW-LOAD: While parsing KW-LOAD

Open tsathis opened this issue 3 years ago • 0 comments

pgloader fails with a fatel error when trying pgloader <file>.

  • [x] pgloader --version

    pgloader version "3.6.3~devel"
    compiled with SBCL 2.2.4
    
  • [x] did you test a fresh compile from the source tree?

    Yes. Compiled from source. OS: Red Hat Enterprise Linux Server 7.9 (Maipo)

  • [x] did you search for other similar issues?

    Yes

  • [x] how can I reproduce the bug?

    wget https://github.com/dimitri/pgloader/raw/master/test/data/2013_Gaz_113CDs_national.txt
    pgloader 2013_Gaz_113CDs_national.txt
    
  • [x] pgloader output you obtain

    2022-05-17T11:23:14.009000Z LOG pgloader version "3.6.3~devel"
    KABOOM!
    FATAL error: At
    
      USPS	GEOID	ALAND	AWATER	
      ^ (Line 1, Column 0, Position 0)
    
    In context KW-LOAD:
    
    While parsing KW-LOAD. Expected:
    
         the character Tab
      or the character Newline
      or the character Return
      or the character Space
      or the string "--"
      or the string "/*"
      or the string "load"
    An unhandled error condition has been signalled: At
    
      USPS	GEOID	ALAND	AWATER	
      ^ (Line 1, Column 0, Position 0)
    
    In context KW-LOAD:
    
    While parsing KW-LOAD. Expected:
    
         the character Tab
      or the character Newline
      or the character Return
      or the character Space
      or the string "--"
      or the string "/*"
      or the string "load"
    
    
    What I am doing here?
    
    At
    
      USPS	GEOID	ALAND	AWATER	
      ^ (Line 1, Column 0, Position 0)
    
    In context KW-LOAD:
    
    While parsing KW-LOAD. Expected:
    
         the character Tab
      or the character Newline
      or the character Return
      or the character Space
      or the string "--"
      or the string "/*"
      or the string "load"
    
    
    

tsathis avatar May 17 '22 11:05 tsathis