cPanel importer stuck on Analyzing backup file

deydod

Hi All
I've migrated 80+ clients over the weekend to Enhance without any problems, however there is one single client that his backup cannot be analyzed for some reason (Importer is stuck at Analyzing step for like 30 min). Backup is about 3GB and should not be a problem since i've imported larger clients.

Do you know where and if I can get a log of what might be the problem?

Thank you

MediaServe

Same thing happens for me on 10.0.0 with a large (34GB) cpanel backup.

On the controller try "docker logs orchd" for log details and you might want to adjust the Enhance log level at /settings/platform.

The only thing I found was looking at the importer data at /var/local/enhance/orchd/importer and doing a "docker logs orchd |& grep 5d0d6719" with a partial GUID of the importer directory from the attempt, which showed:

2023-12-17T21:59:07.795543Z ERROR ThreadId(204) orchd::api::importers::post: cPanel analyzing step failed with: internal: diesel error: value too long for type character varying(32) org_id=5d0d6719-d855-4b6d-a8f3-009bfec1189a import_migration_id=316cc367-25f7-458e-a5c9-ecf5ac4d4e56

@Adam is looking into this sometime today.

I did successfully import a 14GB cpanel backup so it might not be size causing the problem.

deydod

I think I've found something:
2023-12-18T14:57:21.517305Z WARN ThreadId(44055) importer::cpanel::mysql: missing sql_init_path for db 'cptmpdb_passport_ymrhQM7AcmSOveHm'
2023-12-18T14:57:21.546630Z ERROR ThreadId(53) orchd::api::importers::post: cPanel analyzing step failed with: internal: diesel error: value too long for type character varying(32) org_id=b2f2dd7e-0311-45e0-a545-c2ab7dc6047d import_migration_id=c216c3b9-f0d6-4b22-8588-bf0132496fbc

missing sql_init_path, but right after this the error is same as yours.

MediaServe

deydod On my end I don't have the "missing sql_init_path" in the logs. What's your log level? I haven't tweaked that so it remains at warn.

deydod

It's WARN on my environment.

You should do just:docker logs orchd without grep part.

MediaServe

deydod Problem is finding the log entry after time has passed without grepping. There are 2,359 orchd log entries currently. If there was such a log entry it should show up. If I grep just for "sql" I get a few mysql transport errors related to backups. If there was a "sql_init_path" in the log it should have shown. I still have the original error in the orchd log.

Adam

We've found the cause of this. We recently fixed a bug in the cPanel importer which was causing some FTP accounts to be skipped however it's highlighted another issue where one of the field lengths is too short for longer FTP usernames. This will be fixed when we release 10.1.0 but in the meantime if you remove any FTP users > 32 characters before generating the cPanel backup, this should resolve the issue.

deydod

Adam

Thank you. That seems to fix the import. Tested and confirmed that all went smooth.