Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unhandled error condition with no information as to how to fix #88

Closed
jskitz opened this issue Jun 22, 2014 · 2 comments
Closed

Unhandled error condition with no information as to how to fix #88

jskitz opened this issue Jun 22, 2014 · 2 comments

Comments

@jskitz
Copy link

jskitz commented Jun 22, 2014

I've been messing with command.load for a couple hours now trying to figure out why the parser continues to fail. It fails with no more information then the following:

STYLE-WARNING: Undefined alien: "SSLv2_client_method"
An unhandled error condition has been signalled:
   Could not parse subexpression ";" when parsing

 Expression PGLOADER.PARSER::COMMANDS
    Subexpression (+ PGLOADER.PARSER::COMMAND)
    Subexpression PGLOADER.PARSER::COMMAND
    Subexpression (AND
               (OR PGLOADER.PARSER::LOAD-ARCHIVE
                   PGLOADER.PARSER::LOAD-CSV-FILE
                   PGLOADER.PARSER::LOAD-FIXED-COLS-FILE
                   PGLOADER.PARSER::LOAD-DBF-FILE
                   PGLOADER.PARSER::LOAD-MYSQL-DATABASE
                   PGLOADER.PARSER::LOAD-SQLITE-DATABASE
                   PGLOADER.PARSER::LOAD-SYSLOG-MESSAGES)
               PGLOADER.PARSER::END-OF-COMMAND)
   Subexpression PGLOADER.PARSER::END-OF-COMMAND
   Subexpression (AND PGLOADER.PARSER::IGNORE-WHITESPACE #\;
                   PGLOADER.PARSER::IGNORE-WHITESPACE)
    Subexpression ";"

  Encountered at:
    LOAD DATABASE
  FROM mys
  ^ (Line 1, Column 0, Position 0)


; 
; compilation unit aborted
;   caught 1 fatal ERROR condition

My command.load file is basically the example just trying to get this to run a little bit. It looks like the following:

LOAD DATABASE
  FROM mysql://root:mysql@localhost:3306/pf_prod INTO postgresql://pfuser:psql@localhost:5432/pf_prod

 WITH include drop, create tables, create indexes, reset sequences

 SET maintenance_work_mem to '128MB', work_mem to '12MB'

There is also nothing in the logs. I've also tried other solutions I've found from other issues that have been closed. I've tried working off of the master branch versus working off the tag. I can't seem to find any more information about how to fix. Any suggestions?

@jskitz
Copy link
Author

jskitz commented Jun 23, 2014

Figured out that I was missing a semicolon to end the command. This in conjunction with some other errors I had with BEFORE LOAD DO actually made me miss this. Closed as working.

@jskitz jskitz closed this as completed Jun 23, 2014
@dimitri
Copy link
Owner

dimitri commented Jun 24, 2014

See also nikodemus/esrap#26 for ongoing work on fixing that.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants