Can't deploy using target, but can using database

[mpkenn]

Hello,

I have a dozen Sqitch projects set up and running without an issue and recently came across a situation with a newer project that I have not been able to figure out.

I am using a MySQL database for each project and I have tried to run this both through the docker installation and through a windows installation and saw the same issue each time.

I have a sqtich.conf file set up with the below target information

[target "graves"]
    uri = db:mysql://user:password@:3307/graves
    top_dir = C:/Users/mk/Documents/Repositories/graves/sql/

When I attempt to deploy a change (pbi_graves_customers) on the plan using the target I get the below error

$ sqitch deploy graves
Deploying changes to graves
  + pbi_graves_customers .. mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR at line 1: Unknown command '\U'.
not ok
"C:/Program Files/MySQL/MySQL Workbench 8.0/mysql.exe" unexpectedly returned exit value 1

Deploy failed

I have checked my plan, config and all scripts and there isn't a single instance of a '\U' character.

If I attempt to deploy using the db connection everything works as expected.

$ sqitch deploy  db:mysql://user:password@:3307/graves
Deploying changes to db:mysql://user:@:3307/graves
  + pbi_graves_customers .. mysql: [Warning] Using a password on the command line interface can be insecure.
ok

None of my other projects (which are based on the same base database model) have this issue.

Has anyone seen this issue before or have any tips on troubleshooting?

Best,
Matt

[theory]

Weird! I note that in the second invocation, which works, you don't specify a top dir similar to the target. Does this work, too?

sqitch --top-dir C:/Users/mk/Documents/Repositories/graves/sql/ deploy  db:mysql://user:password@:3307/graves

[mpkenn]

I just tested your suggestion and I did get the same error when I added the --top-dir to the command.

$ sqitch --top-dir C:/Users/mk/Documents/Repositories/graves/sql/ deploy  db:mysql://user:password@:3307/graves
warning:   Option --top-dir is deprecated for deploy and other non-configuration commands.
warning:   Use --chdir instead.
Deploying changes to db:mysql://user:@:3307/graves
  + pbi_graves_customers .. mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR at line 1: Unknown command '\U'.
not ok
"C:/Program Files/MySQL/MySQL Workbench 8.0/mysql.exe" unexpectedly returned exit value 1

Deploy failed

I did notice the warning when I ran it with the --top-dir flag and when I updated the command with the --chdir flag instead of the --top-dir flag the change was successfully deployed.

$ sqitch --chdir C:/Users/mk/Documents/Repositories/graves/sql/ deploy  db:mysql://user:password@:3307/graves
Deploying changes to db:mysql://user:@:3307/graves
  + pbi_graves_customers .. mysql: [Warning] Using a password on the command line interface can be insecure.
ok

With this information I updated my config file to use chdir (see below) and everything looks to be working properly.

[target "graves"]
	uri = db:mysql://user:password@:3307/graves
	chdir = C:/Users/mk/Documents/Repositories/graves/sql/

Not sure why this fix worked as all of my other configurations are set up with the top-dir with similar directories, (eg. C:/Users/mk/Documents/Repositories/harbor/sql/) and they all work.

I appreciate your help on this and it looks like this should be fixed going forward as long as I use the correct flag.

Best,
Matt

[theory]

Seems like there might be something borked in the sqitch.conf in the default top directory (usually .) that is overridden in by the sqitch.conf in the subdirectory. What do your sqitch.conf files look like?

[mpkenn]

This is my USER sqitch.conf (original before the change to the top_dir)

[engine "mysql"]
	client = C:/Program Files/MySQL/MySQL Workbench 8.0/mysql.exe
[user]
	name = Matt K.
	email = mpkn@email.com
[target "graves"]
	uri = db:mysql://user:password@:3307/graves
	top_dir = C:/Users/mk/Documents/Repositories/graves/sql/

this is the sqitch.conf file located in the C:/Users/mk/Documents/Repositories/graves/sql/ directory

[core]
	engine = mysql
	# plan_file = sqitch.plan
	# top_dir = .
# [engine "mysql"]
	# target = db:mysql:
	# registry = sqitch
	# client = mysql

[theory]

Weird, I wonder where that \U is coming from…

[mpkenn]

I have looked everywhere for that \U and have had no success. I searched the code base looking for everything I could think of for a week before I reached out here.

I am not sure I'll ever find this needle. I really appreciate your guidance on this one and for identifying a work around that will allow me to keep moving forward.

All of my other projects are working as expected, and I appreciate the great application you have built.

[theory]

Only other place to look is in ~/.sqitch/sqitch.conf (sorry can't recall offhand where "home" is on Windows…)