[MCOL-627] Ubuntu 16 deb multi site installation (1.0.7) Created: 2017-03-17  Updated: 2018-05-01  Resolved: 2017-04-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.0.8

Type: Task Priority: Major
Reporter: joe piscitella Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Multi Site install on Ubuntu 16 via deb installation failures. Log shows it removed the deb from /root on pm2 and then tries to install without scp them over.

pm2_deb_install.log-

ssh root@pm2 'time'^M
^[]0;root@pm1: ^Groot@pm1:# ssh root@pm2 'time'^M

Erase MariaDB Columnstore Packages on Module ^M
real 0m0.000s^M
user 0m0.000s^M
sys 0m0.000s^M
^[]0;root@pm1: ^Groot@pm1:# ssh root@pm2 'dpkg -P $(dpkg --get-selections | grep '^mariadb-columnstore') ;dpkg -P dummy'^M
dpkg: error: --purge needs at least one package name argument^M
^M
Type dpkg --help for help about installing and deinstalling packages [*];^M
Use 'apt' or 'aptitude' for user-friendly package management;^M
Type dpkg -Dhelp for a list of dpkg debug flag values;^M
Type dpkg --force-help for a list of forcing options;^M
Type dpkg-deb --help for help about manipulating *.deb files;^M
^M
Options marked [*] produce a lot of output - pipe it through 'less' or 'more' !^M
dpkg: warning: ignoring request to remove dummy which isn't installed^M
^[]0;root@pm1: ^Groot@pm1:#
Copy new MariaDB Columnstore Packages to Module ssh root@pm2 'rm f /root/mariadb-columnstore*.deb'^M
^[]0;root@pm1: ^Groot@pm1:#
Install MariaDB ColumnStore Packages on Module ssh root@pm2 'dpkg -i --force-confnew mariadb-columnstore*1.0.7-1*deb ;dpkg -P dummy'^M
dpkg: error processing archive mariadb-columnstore*1.0.7-1*deb (--install):^M
cannot access archive: No such file or directory^M
Errors were encountered while processing:^M
mariadb-columnstore*1.0.7-1*deb^M
dpkg: warning: ignoring request to remove dummy which isn't installed^M
^[]0;root@pm1: ^Groot@pm1:#
Copy MariaDB Columnstore Config file to Module ERROR

      • Installation ERROR


 Comments   
Comment by David Hill (Inactive) [ 2017-03-17 ]

questions

1. do you have ssh-keys setup or use a root user password?
2. Can you provide some info about your servers, number of cpus?
The package should have been removed and copied on this line. It doesn't show the copy.
Just wonder if the command timed out for some reason.

Copy new MariaDB Columnstore Packages to Module ssh root@pm2 'rm f /root/mariadb-columnstore*.deb'^M
^[]0;root@pm1: ^Groot@pm1:#

----------------------------------------------

Here is an example of it working when using root password. will double check with using ssh-keys

Copy new MariaDB Columnstore Packages to Module ssh root@10.128.0.5 'rm f /root/mariadb-columnstore*.deb'
root@ubuntu16-pm1:~# scp /root/mariadb-columnstore*1.0.8-1*deb root@10.128.0.5:.;dpkg -P dummy
root@10.128.0.5's password:
mariadb-columnstore-1.0.8-1-x86_64-xenial-client.deb 100% 17MB 17.1MB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-common.deb 100% 129KB 128.9KB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-gssapi-client.deb 100% 16KB 15.8KB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-gssapi-server.deb 100% 35KB 35.3KB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-libs.deb 100% 5479KB 5.4MB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-platform.deb 100% 3765KB 3.7MB/s 00:01
mariadb-columnstore-1.0.8-1-x86_64-xenial-server.deb 100% 96MB 95.8MB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-shared.deb 100% 1788KB 1.8MB/s 00:00
mariadb-columnstore-1.0.8-1-x86_64-xenial-storage-engine.deb 100% 639KB 638.6KB/s 00:00
dpkg: warning: ignoring request to remove dummy which isn't installed
DONE
root@ubuntu16-pm1:~# Install MariaDB ColumnStore Packages on Module ssh root@10.128.0.5 'dpkg -i --fo

Comment by joe piscitella [ 2017-03-17 ]

testing build on 1 cpu, 4vcores system
used root passwd on install (but also have ssh keys installed)
other parts of the script show successful scp so I am not too sure what went wrong

After the remove completed I scp'd the deb over and the install appears to be more successful

ssh root@X.X.X.X 'time'^M
^[]0;root@pm1: ^Groot@pm1:# ssh root@X.X.X.X 'time'^M

Erase MariaDB Columnstore Packages on Module ^M
real 0m0.000s^M
user 0m0.000s^M
sys 0m0.000s^M
^[]0;root@pm1: ^Groot@pm1:# ssh root@X.X.X.X 'dpkg -P $(dpkg --get-selections | grep '^mariadb-columnstore') ;dpkg -P dummy'^M
dpkg: error: --purge needs at least one package name argument^M
^M
Type dpkg --help for help about installing and deinstalling packages [*];^M
Use 'apt' or 'aptitude' for user-friendly package management;^M
Type dpkg -Dhelp for a list of dpkg debug flag values;^M
Type dpkg --force-help for a list of forcing options;^M
Type dpkg-deb --help for help about manipulating *.deb files;^M
^M
Options marked [*] produce a lot of output - pipe it through 'less' or 'more' !^M
dpkg: warning: ignoring request to remove dummy which isn't installed^M
^[]0;root@pm1: ^Groot@pm1:#
Copy new MariaDB Columnstore Packages to Module ssh root@X.X.X.X 'rm f /root/mariadb-columnstore*.deb'^M
^[]0;root@pm1: ^Groot@pm1:#
Install MariaDB ColumnStore Packages on Module ssh root@X.X.X.X 'dpkg -i --force-confnew mariadb-columnstore*1.0.7-1*deb ;dpkg -P dummy'^M
Selecting previously unselected package mariadb-columnstore-client.^M
(Reading database ... 96115 files and directories currently installed.)^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-client.deb ...^M
Unpacking mariadb-columnstore-client (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-common.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-common.deb ...^M
Unpacking mariadb-columnstore-common (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-gssapi-client.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-gssapi-client.deb ...^M
Unpacking mariadb-columnstore-gssapi-client (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-libs.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-libs.deb ...^M
Unpacking mariadb-columnstore-libs (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-platform.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-platform.deb ...^M
Unpacking mariadb-columnstore-platform (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-server.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-server.deb ...^M
Unpacking mariadb-columnstore-server (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-shared.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-shared.deb ...^M
Unpacking mariadb-columnstore-shared (1.0.7) ...^M
Selecting previously unselected package mariadb-columnstore-storage-engine.^M
Preparing to unpack mariadb-columnstore-1.0.7-1-x86_64-xenial-storage-engine.deb ...^M
Unpacking mariadb-columnstore-storage-engine (1.0.7) ...^M
Setting up mariadb-columnstore-libs (1.0.7) ...^M
MariaDB ColumnStore install completed^M
Setting up mariadb-columnstore-platform (1.0.7) ...^M

Copy MariaDB Columnstore Config file to Module scp /usr/local/mariadb/columnstore/etc/* root@X.X.X.X:/usr/local/mariadb/columnstore/etc/.^M
The next step is:^M
^M
/usr/local/mariadb/columnstore/bin/postConfigure^M
^M
MariaDB ColumnStore install completed^M
Setting up mariadb-columnstore-storage-engine (1.0.7) ...^M
MariaDB ColumnStore install completed^M
Setting up mariadb-columnstore-common (1.0.7) ...^M
Setting up mariadb-columnstore-gssapi-client (1.0.7) ...^M
Setting up mariadb-columnstore-shared (1.0.7) ...^M
Setting up mariadb-columnstore-client (1.0.7) ...^M
Setting up mariadb-columnstore-server (1.0.7) ...^M
Processing triggers for libc-bin (2.23-0ubuntu3) ...^M
dpkg: warning: ignoring request to remove dummy which isn't installed^M
^[]0;root@pm1: ^Groot@pm1:# DONE
Copy Custom OS files to Module scp -r /usr/local/mariadb/columnstore/local/etc root@X.X.X.X:/usr/local/mariadb/columnstore/local/.^M
^Mrc.local.calpont 0% 0 0.0KB/s -:- ETA^Mrc.local.calpont 100% 159 0.2KB/s 00:00 ^M
^Mrc.local.calpont 0% 0 0.0KB/s -:- ETA^Mrc.local.calpont 100% 159 0.2KB/s 00:00 ^M
^Mmodule 0% 0 0.0KB/s -:- ETA^Mmodule 100% 4 0.0KB/s 00:00 ^M
^[]0;root@pm1: ^Groot@pm1:# DONE
Copy MariaDB Columnstore OS files to Module scp /usr/local/mariadb/columnstore/local/etc/pm2/* root@X.X.X.X:/usr/local/mariadb/columnstore/local/.^M
^Mmodule 0% 0 0.0KB/s -:- ETA^Mmodule 100% 4 0.0KB/s 00:00 ^M
^Mrc.local.calpont 0% 0 0.0KB/s -:- ETA^Mrc.local.calpont 100% 159 0.2KB/s 00:00 ^M
^[]0;root@pm1: ^Groot@pm1:# DONE
Run Module Installer ssh root@X.X.X.X '/bin/bash /usr/local/mariadb/columnstore/bin/module_installer.sh --module=um --port=3306'^M

Installation Successfully Completed on 'pm2'

Comment by David Hill (Inactive) [ 2017-03-17 ]

Thanks for the input... I was thinking that the install script timed out at that point when it was trying to run the scp command. so on a small system, it is more likely to take place. That is my thought..

Comment by David Hill (Inactive) [ 2017-03-20 ]

This is working in the current 1.0.8 release.. Changes to the user/performance installer script corrects this issue

Comment by Daniel Lee (Inactive) [ 2017-04-21 ]

It was verified in 1.0.8.

Generated at Thu Feb 08 02:22:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.