[MCOL-837] postConfigure - WARNING: Mismatch between FilesPerColumnPartition check should be removed Created: 2017-07-27  Updated: 2023-10-26  Resolved: 2017-09-14

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.0.9
Fix Version/s: 1.0.12, 1.1.0

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Sprint: 2017-18

 Description   

When adding a new pm and dbroot via postConfigure, the below warning gets issued and postConfigure exits. This warning and check is no long valid and should be removed from code. This was added in the arly days of the product where you couldn't add additional dbroots. So it no longer applies.

Enter number of Performance Modules [1,1024] (2) > 3

      • Parent OAM Module Performance Module #1 Configuration ***

Enter Nic Interface #1 Host Name (ip-172-30-0-92) >
Enter Nic Interface #1 IP Address of ip-172-30-0-92 (172.30.0.92) >
Enter Nic Interface #2 Host Name (unassigned) >
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) >

      • Performance Module #2 Configuration ***

Enter Nic Interface #1 Host Name (pm2) >
Enter Nic Interface #1 IP Address of pm2 (172.30.0.152) >
Enter Nic Interface #2 Host Name (unassigned) >
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm2' (2) >

      • Performance Module #3 Configuration ***

Enter Nic Interface #1 Host Name (unassigned) > pm3
Enter Nic Interface #1 IP Address of pm3 (0.0.0.0) > 172.30.0.161
Enter Nic Interface #2 Host Name (unassigned) >
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm3' () > 3

***************************************************************************
WARNING: Mismatch between FilesPerColumnPartition (4) and number of DBRoots (3)
Database already exist, going forward could corrupt the database
Please Contact Customer Support
***************************************************************************
[root@ip-172-30-0-92 bin]#



 Comments   
Comment by Andrew Ernst [ 2017-08-18 ]

I've just experienced this issue, as well.
Using 1.0.10-1 and started with a single host that was upgraded from 1.0.9 --> 1.0.10, then ran
the following sets of commands:

mcsadmin addmodule pm 1 mdbcs-db-d02
 
addmodule   Thu Aug 17 23:33:28 2017
 
 
 
Enter the 'User' Password or 'ssh' if configured with ssh-keys
 
           Please enter: ssh
 
 
 
Adding Modules pm2, please wait...
 
 
 
**** addModule Failed: API Failure return in addModule API


Select the type of Data Storage [1=internal, 2=external] (1) >
 
 
 
===== Setup Memory Configuration =====
 
 
 
 
 
NOTE: Setting 'NumBlocksPct' to 50%
 
      Setting 'TotalUmMemory' to 25%
 
 
 
===== Setup the Module Configuration =====
 
 
 
 
 
----- Performance Module Configuration -----
 
 
 
Enter number of Performance Modules [1,1024] (4) >
 
 
 
*** Parent OAM Module Performance Module #1 Configuration ***
 
 
 
Enter Nic Interface #1 Host Name (mdbcs-db-d01) >
 
Enter Nic Interface #1 IP Address of mdbcs-db-d01 (172.16.x.x) >
 
Enter Nic Interface #2 Host Name (unassigned) >
 
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1,2,3,4) >
 
 
 
*** Performance Module #2 Configuration ***
 
 
 
Module 'pm2' is Disabled, do you want to leave it Disabled? [y,n] (y) > n
 
 
 
Enter Nic Interface #1 Host Name (mdbcs-db-d02) >
 
Enter Nic Interface #1 IP Address of mdbcs-db-d02.(172.16.x.x) >
 
Enter Nic Interface #2 Host Name (unassigned) >
 
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm2' () > 5,6,7,8
 
 
 
*** Performance Module #3 Configuration ***
 
 
 
Module 'pm3' is Disabled, do you want to leave it Disabled? [y,n] (y) > n
 
 
 
Enter Nic Interface #1 Host Name (mdbcs-db-d03) >
 
Enter Nic Interface #1 IP Address of mdbcs-db-d03 (172.16.x.x) >
 
Enter Nic Interface #2 Host Name (unassigned) >
 
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm3' () > 9,10,11,12
 
 
 
*** Performance Module #4 Configuration ***
 
 
 
Enter Nic Interface #1 Host Name (mdbcs-db-d04) >
 
Enter Nic Interface #1 IP Address of mdbcs-db-d04 (172.16.x.x) >
 
Enter Nic Interface #2 Host Name (unassigned) >
 
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm4' (13,14,15,16) >
 
 
 
***************************************************************************
 
WARNING: Mismatch between FilesPerColumnPartition (8) and number of DBRoots (16)
 
         Database already exist, going forward could corrupt the database
 
         Please Contact Customer Support
 
***************************************************************************

Comment by David Hill (Inactive) [ 2017-08-23 ]

remove the check for this change, no longer needed

fixed in 1.0.x

commit 80aff1477a0f4ec1c144c96039e917270d29cb82
Author: david hill <david.hill@mariadb.com>
Date: Wed Aug 23 13:57:13 2017 -0500

MCOL-837 - removed change for partiion number

oamapps/postConfigure/postConfigure.cpp | 2 –

fixed in 1.1.0

commit ce6317995cc6791ea0d01faabf74e9e0d15ff7f7
Author: david hill <david.hill@mariadb.com>
Date: Wed Aug 23 13:56:46 2017 -0500

MCOL-837 - removed change for partiion number

oamapps/postConfigure/postConfigure.cpp | 2 –

Comment by Daniel Lee (Inactive) [ 2017-09-12 ]

Build tested: 1.1.0-1

I am still getting the warning.

Enter Nic Interface #1 Host Name (unassigned) > s2pm1
Enter Nic Interface #1 IP Address of s2pm1 (10.0.0.51) >
Enter Nic Interface #2 Host Name (unassigned) >
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm3' () > 3

***************************************************************************
WARNING: Mismatch between FilesPerColumnPartition (4) and number of DBRoots (3)
Database already exist, going forward could corrupt the database
Please Contact Customer Support
***************************************************************************

Comment by David Hill (Inactive) [ 2017-09-13 ]

fixed in 1.0 and and 1.1.

Commented out the call that checks FilesPerColumnPartition.

Comment by Daniel Lee (Inactive) [ 2017-09-14 ]

Builds verified: 1.1.0-1, 1.0.12 GitHub source

/root/columnstore/mariadb-columnstore-server
commit 2965fc8e72f9b2a28d43ee2e700bc430ceae038e
Author: david hill <david.hill@mariadb.com>
Date: Mon Aug 28 13:40:46 2017 -0500

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit d5a3cf1cf621fdcfe4e3d55df5511ad18e82b319
Author: david hill <david.hill@mariadb.com>
Date: Wed Sep 13 10:50:33 2017 -0500

For 1.0, I did run into an installation issue at the end of postConfigure. For the purpose of this test only, the warning message is no longer displayed.

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