WordOps icon indicating copy to clipboard operation
WordOps copied to clipboard

`wo site update` ends up with `list index out of range` after backing up database

Open geoffreycrofte opened this issue 5 years ago • 4 comments

Hello there,

Me again, hoping I'm not becoming annoying. 😄 I updated all my domains on my OVH VPS after and thanks to the help during this issue: https://github.com/WordOps/WordOps/issues/128

I tried to update my main website build on WordPress using the same wo command: wo site update domain.tld --php73

And I ended up with:

Running pre-update checks, please wait...
Backup location : /var/www/domain.tld/backup/04Sep2019-19-49-47
Backing up database 		[Done]
Check the log for details: `tail /var/log/wo/wordops.log` and please try again

The tail gave me that:

2019-09-04 19:49:52,851 (DEBUG) wo : Copying file, Source:/etc/nginx/sites-available/domain.tld, Dest:/var/www/domain.tld/backup/04Sep2019-19-49-47
2019-09-04 19:49:52,853 (DEBUG) wo : Config files not found in /var/www/domain.tld/ 
2019-09-04 19:49:52,853 (DEBUG) wo : Searching wp-config.php in /var/www/domain.tld/htdocs/ 
2019-09-04 19:49:52,854 (INFO) wo : Backing up database 		
2019-09-04 19:49:52,854 (DEBUG) wo : Running command: mysqldump --single-transaction domain_tld | pigz -9 -p"$(nproc)" > /var/www/domain.tld/backup/04Sep2019-19-49-47/domain_tld.gz
2019-09-04 19:49:55,606 (DEBUG) wo : Command Output: , 
Command Error: 
2019-09-04 19:49:55,607 (INFO) wo : [Done]
2019-09-04 19:49:55,607 (DEBUG) wo : list index out of range

I entered the command Running command: mysqldump --single-transaction domain_tld | pigz -9 -p"$(nproc)" > /var/www/domain.tld/backup/04Sep2019-19-49-47/domain_tld.gz manually to test and it works perfectly. I don't understand the lines

2019-09-04 19:49:55,606 (DEBUG) wo : Command Output: , 
Command Error: 

following with a [Done] (done what? Oo if you've got an error) and the list index out of range doesn't talk to me.

Again thanks for your time and take it (the time, I'm not in stress) Have a good day. 😊

System Information

  • [ ] lsb_release -a : Debian GNU/Linux 8.11 (jessie)
  • [ ] wo info
NGINX (1.16.1 ):

user                             www-data
worker_processes                 auto
worker_connections               50000
keepalive_timeout                8
fastcgi_read_timeout             300
client_max_body_size             100m
allow                            127.0.0.1 

PHP (7.2.22-1):

user                             
expose_php                       Off
memory_limit                     128M
post_max_size                    100M
upload_max_filesize              100M
max_execution_time               300

Information about www.conf
ping.path                        /ping
pm.status_path                   /status
process_manager                  ondemand
pm.max_requests                  1500
pm.max_children                  50
pm.start_servers                 10
pm.min_spare_servers             5
pm.max_spare_servers             15
request_terminate_timeout        300
xdebug.profiler_enable_trigger   off
listen                           php72-fpm.sock

Information about debug.conf
ping.path                        /ping
pm.status_path                   /status
process_manager                  ondemand
pm.max_requests                  1500
pm.max_children                  50
pm.start_servers                 10
pm.min_spare_servers             5
pm.max_spare_servers             15
request_terminate_timeout        300
xdebug.profiler_enable_trigger   on
listen                           127.0.0.1:9172

PHP (7.3.9-1):

user                             
expose_php                       Off
memory_limit                     128M
post_max_size                    100M
upload_max_filesize              100M
max_execution_time               300

Information about www.conf
ping.path                        /ping
pm.status_path                   /status
process_manager                  ondemand
pm.max_requests                  1500
pm.max_children                  50
pm.start_servers                 10
pm.min_spare_servers             5
pm.max_spare_servers             15
request_terminate_timeout        300
xdebug.profiler_enable_trigger   off
listen                           php73-fpm.sock

Information about debug.conf
ping.path                        /ping
pm.status_path                   /status
process_manager                  ondemand
pm.max_requests                  1500
pm.max_children                  50
pm.start_servers                 10
pm.min_spare_servers             5
pm.max_spare_servers             15
request_terminate_timeout        300
xdebug.profiler_enable_trigger   on
listen                           127.0.0.1:9173

MySQL (10.1.37-MariaDB) on localhost:

port                             3306
wait_timeout                     600
interactive_timeout              28800
max_used_connections             34
datadir                          /var/lib/mysql/
socket                           /var/run/mysqld/mysqld.sock
my.cnf [PATH]                    /etc/mysql/conf.d/my.cnf
  • [ ] nginx -V
nginx/1.16.1 (WordOps Nginx-wo)
built with OpenSSL 1.1.1c  28 May 2019
TLS SNI support enabled
  • [ ] wo -v : WordOps v3.9.8.8
  • [ ] wp cli info --allow-root
OS:	Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64
Shell:	/usr/bin/zsh
PHP binary:	/usr/bin/php7.3
PHP version:	7.3.9-1+0~20190902.44+debian8~1.gbpf8534c
php.ini used:	/etc/php/7.3/cli/php.ini
WP-CLI root dir:	phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir:	phar://wp-cli.phar/vendor
WP_CLI phar path:	/var/www/creativejuiz.fr/backup
WP-CLI packages dir:	
WP-CLI global config:	
WP-CLI project config:	
WP-CLI version:	2.3.0
  • [ ] curl -sL git.io/fjAp3 | sudo -E bash - : https://transfer.sh/y2tQG/wordops.tar.gz

geoffreycrofte avatar Sep 04 '19 18:09 geoffreycrofte

Hello @geoffreycrofte, issue has been fixed with the release v3.9.8.10 published few seconds ago.

VirtuBox avatar Sep 04 '19 20:09 VirtuBox

Hello @VirtuBox I'm in 3.9.8.11 now (wow you publish new version quickly, that's awesome :p) but I still have exactly the same issue.

geoffreycrofte avatar Sep 07 '19 08:09 geoffreycrofte

Hello there :) I updated to the last version but the issue list index out of range is still here. Thanks a lot ;)

geoffreycrofte avatar Sep 23 '19 18:09 geoffreycrofte

Hello @VirtuBox , I think it is a regression, I have this problem on v3.13.2, trying to wo site update domain.ltd --php74

2021-02-23 14:08:35,274 (INFO) wo : Backing up Webroot
2021-02-23 14:08:35,274 (DEBUG) wo.core.logging : Copying files, Source:/var/www/domain.ltd/htdocs, Dest:/var/www/domain.ltd/backup/23Feb2021-14-08-31/htdocs
2021-02-23 14:08:38,683 (INFO) wo : [Done]
2021-02-23 14:08:38,684 (INFO) wo : Backing up database
2021-02-23 14:08:38,684 (DEBUG) wo.core.logging : Running command: mysqldump --single-transaction domain_ltd_Jfv6TNKr | zstd -T0 -c> /var/www/domain.ltd/backup/23Feb2021-14-08-31/domain_ltd_Jfv6TNKr.zst
2021-02-23 14:08:38,829 (DEBUG) wo.core.logging : Command Output: ,
Command Error:
2021-02-23 14:08:38,830 (INFO) wo : [Done]
2021-02-23 14:08:38,830 (DEBUG) wo.core.logging : 'php73'
2021-02-23 14:08:38,830 (INFO) wo : Check the log for details: `tail /var/log/wo/wordops.log` and please try again

cristian-milea avatar Feb 23 '21 14:02 cristian-milea

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions[bot] avatar Jan 01 '24 02:01 github-actions[bot]

This issue was closed because it has been stalled for 5 days with no activity.

github-actions[bot] avatar Jan 07 '24 02:01 github-actions[bot]