[root@cs-test-mdb-cs-node-0 /]# for i in $(ls /var/log/mariadb/columnstore/); do
|
> echo "------"
|
> echo $i
|
> cat /var/log/mariadb/columnstore/$i
|
> echo
|
> done
|
------
|
archive
|
cat: /var/log/mariadb/columnstore/archive: Is a directory
|
|
------
|
cmapi_server.log
|
127.0.0.1 - - [20/Aug/2020 18:06:25] cmapi_server DEBUG Using container dispatcher module
|
127.0.0.1 - - [20/Aug/2020 18:06:25] cmapi_server INFO CMAPI Version: 1.5.3.1
|
[20/Aug/2020 18:06:25] root get_module_net_address Module 1 network address 127.0.0.1
|
[20/Aug/2020 18:06:25] root Loaded the config file, my name is None
|
[20/Aug/2020:18:06:25] ENGINE Bus STARTING
|
[20/Aug/2020 18:06:25] root Starting the heartbeat listener
|
[20/Aug/2020 18:06:25] root starting the monitor logic
|
[20/Aug/2020:18:06:25] ENGINE Serving on https://0.0.0.0:8640
|
[20/Aug/2020:18:06:25] ENGINE Bus STARTED
|
[20/Aug/2020 18:06:26] root Failover monitoring is inactive; requires at least 3 nodes and a shared storage system
|
10.0.0.166 - - [20/Aug/2020 18:08:06] cmapi_server DEBUG get_status starts
|
10.0.0.166 - - [20/Aug/2020 18:08:06] cmapi_server DEBUG get_status returns {'timestamp': '2020-08-20 18:08:06.374310', 'num_nodes': 0}
|
10.0.0.166 - - [20/Aug/2020:18:08:06] "GET /cmapi/0.4.0/cluster/status HTTP/1.1" 200 59 "" "curl/7.61.1"
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_add_node starts
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_begin starts
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_begin JSON body {'id': 26562, 'timeout': 299}
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_begin returns {'timestamp': '2020-08-20 18:08:12.806544'}
|
10.0.0.166 - - [20/Aug/2020:18:08:12] "PUT /cmapi/0.4.0/node/begin HTTP/1.1" 200 43 "" "python-requests/2.23.0"
|
[20/Aug/2020 18:08:12] root get_module_net_address Module 1 network address 127.0.0.1
|
[20/Aug/2020 18:08:12] root add_node(): replacing 127.0.0.1/localhost with 10.0.0.166/cs-test-mdb-cs-node-0.cs-test-mdb-clust as this node's name. Be sure cs-test-mdb-cs-node-0.cs-test-mdb-clust resolves to 10.0.0.166 on all other nodes in the cluster.
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_config starts
|
10.0.0.166 - - [20/Aug/2020 18:08:12] cmapi_server DEBUG put_config JSON body {'manager': 'cs-test-mdb-cs-node-0.cs-test-mdb-clust', 'revision': '1', 'timeout': 300, 'config': '<?xml version="1.0" ?>\n<Columnstore Version="V1.0.0">\n <ExeMgr1>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8601</Port>\n <Module>unassigned</Module>\n </ExeMgr1>\n <JobProc>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8602</Port>\n </JobProc>\n <ProcMgr>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8603</Port>\n </ProcMgr>\n <ProcMgr_Alarm>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8606</Port>\n </ProcMgr_Alarm>\n <ProcStatusControl>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8604</Port>\n </ProcStatusControl>\n <ProcStatusControlStandby>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8605</Port>\n </ProcStatusControlStandby>\n <localhost_ProcessMonitor>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8800</Port>\n </localhost_ProcessMonitor>\n <dm1_ProcessMonitor>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8800</Port>\n </dm1_ProcessMonitor>\n <um1_ProcessMonitor>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8800</Port>\n </um1_ProcessMonitor>\n <pm1_ProcessMonitor>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8800</Port>\n </pm1_ProcessMonitor>\n <dm1_ServerMonitor>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8622</Port>\n </dm1_ServerMonitor>\n <um1_ServerMonitor>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8622</Port>\n </um1_ServerMonitor>\n <pm1_ServerMonitor>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8622</Port>\n </pm1_ServerMonitor>\n <pm1_WriteEngineServer>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8630</Port>\n </pm1_WriteEngineServer>\n <DDLProc>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8612</Port>\n </DDLProc>\n <DMLProc>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8614</Port>\n </DMLProc>\n <BatchInsert>\n <RowsPerBatch>10000</RowsPerBatch>\n </BatchInsert>\n <PrimitiveServers>\n <Count>1</Count>\n <ConnectionsPerPrimProc>2</ConnectionsPerPrimProc>\n <ProcessorThreshold>128</ProcessorThreshold>\n <ProcessorQueueSize>10K</ProcessorQueueSize>\n <DebugLevel>0</DebugLevel>\n <LBID_Shift>13</LBID_Shift>\n <ColScanBufferSizeBlocks>512</ColScanBufferSizeBlocks>\n <ColScanReadAheadBlocks>512</ColScanReadAheadBlocks>\n <PrefetchThreshold>1</PrefetchThreshold>\n <PTTrace>0</PTTrace>\n <RotatingDestination>n</RotatingDestination>\n <DirectIO>y</DirectIO>\n <HighPriorityPercentage/>\n <MediumPriorityPercentage/>\n <LowPriorityPercentage/>\n </PrimitiveServers>\n <PMS1>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS1>\n <PMS2>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS2>\n <PMS3>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS3>\n <PMS4>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS4>\n <PMS5>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS5>\n <PMS6>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS6>\n <PMS7>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS7>\n <PMS8>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS8>\n <PMS9>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS9>\n <PMS10>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS10>\n <PMS11>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS11>\n <PMS12>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS12>\n <PMS13>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS13>\n <PMS14>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS14>\n <PMS15>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS15>\n <PMS16>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS16>\n <PMS17>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS17>\n <PMS18>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS18>\n <PMS19>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS19>\n <PMS20>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS20>\n <PMS21>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS21>\n <PMS22>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS22>\n <PMS23>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS23>\n <PMS24>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS24>\n <PMS25>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS25>\n <PMS26>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS26>\n <PMS27>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS27>\n <PMS28>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS28>\n <PMS29>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS29>\n <PMS30>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS30>\n <PMS31>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS31>\n <PMS32>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8620</Port>\n </PMS32>\n <SystemConfig>\n <SystemName>columnstore-1</SystemName>\n <ParentOAMModuleName>pm1</ParentOAMModuleName>\n <StandbyOAMModuleName>unassigned</StandbyOAMModuleName>\n <PrimaryUMModuleName>pm1</PrimaryUMModuleName>\n <ModuleHeartbeatPeriod>1</ModuleHeartbeatPeriod>\n <ModuleHeartbeatCount>3</ModuleHeartbeatCount>\n <ModuleProcMonWaitCount>12</ModuleProcMonWaitCount>\n \t// 2.5 minutes\n <DBRootCount>1</DBRootCount>\n <DBRoot1>/var/lib/columnstore/data1</DBRoot1>\n <DBRMRoot>/var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves</DBRMRoot>\n <TableLockSaveFile>/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks</TableLockSaveFile>\n <DBRMTimeOut>15</DBRMTimeOut>\n <DBRMSnapshotInterval>100000</DBRMSnapshotInterval>\n <ExternalCriticalThreshold>90</ExternalCriticalThreshold>\n <ExternalMajorThreshold>80</ExternalMajorThreshold>\n <ExternalMinorThreshold>70</ExternalMinorThreshold>\n <TransactionArchivePeriod>10</TransactionArchivePeriod>\n <NMSIPAddress>0.0.0.0</NMSIPAddress>\n <TempSaveSize>128M</TempSaveSize>\n <WaitPeriod>10</WaitPeriod>\n <ProcessRestartCount>10</ProcessRestartCount>\n <ProcessRestartPeriod>120</ProcessRestartPeriod>\n <SwapAction>restartSystem</SwapAction>\n <ActivePmFailoverDisabled>n</ActivePmFailoverDisabled>\n <MemoryCheckPercent>95</MemoryCheckPercent>\n <DataFileLog>OFF</DataFileLog>\n <hdfsRdwrScratch>/rdwrscratch</hdfsRdwrScratch>\n <TempFileDir>/columnstore_tmp_files</TempFileDir>\n <SystemTempFileDir>/tmp/columnstore_tmp_files</SystemTempFileDir>\n <DataFilePlugin>libcloudio.so</DataFilePlugin>\n </SystemConfig>\n <SystemModuleConfig>\n <ModuleType1>dm</ModuleType1>\n <ModuleDesc1>Director Module</ModuleDesc1>\n <RunType1>SIMPLEX</RunType1>\n <ModuleCount1>0</ModuleCount1>\n <ModuleIPAddr1-1-1>0.0.0.0</ModuleIPAddr1-1-1>\n <ModuleHostName1-1-1>unassigned</ModuleHostName1-1-1>\n <ModuleDisableState1-1>ENABLED</ModuleDisableState1-1>\n <ModuleCPUCriticalThreshold1>0</ModuleCPUCriticalThreshold1>\n <ModuleCPUMajorThreshold1>0</ModuleCPUMajorThreshold1>\n <ModuleCPUMinorThreshold1>0</ModuleCPUMinorThreshold1>\n <ModuleCPUMinorClearThreshold1>0</ModuleCPUMinorClearThreshold1>\n <ModuleDiskCriticalThreshold1>90</ModuleDiskCriticalThreshold1>\n <ModuleDiskMajorThreshold1>80</ModuleDiskMajorThreshold1>\n <ModuleDiskMinorThreshold1>70</ModuleDiskMinorThreshold1>\n <ModuleMemCriticalThreshold1>90</ModuleMemCriticalThreshold1>\n <ModuleMemMajorThreshold1>0</ModuleMemMajorThreshold1>\n <ModuleMemMinorThreshold1>0</ModuleMemMinorThreshold1>\n <ModuleSwapCriticalThreshold1>90</ModuleSwapCriticalThreshold1>\n <ModuleSwapMajorThreshold1>80</ModuleSwapMajorThreshold1>\n <ModuleSwapMinorThreshold1>70</ModuleSwapMinorThreshold1>\n <ModuleDiskMonitorFileSystem1-1>/</ModuleDiskMonitorFileSystem1-1>\n <ModuleDBRootCount1-1>unassigned</ModuleDBRootCount1-1>\n <ModuleDBRootID1-1-1>unassigned</ModuleDBRootID1-1-1>\n <ModuleType2>um</ModuleType2>\n <ModuleDesc2>User Module</ModuleDesc2>\n <RunType2>SIMPLEX</RunType2>\n <ModuleCount2>0</ModuleCount2>\n <ModuleIPAddr1-1-2>0.0.0.0</ModuleIPAddr1-1-2>\n <ModuleHostName1-1-2>unassigned</ModuleHostName1-1-2>\n <ModuleDisableState1-2>ENABLED</ModuleDisableState1-2>\n <ModuleCPUCriticalThreshold2>0</ModuleCPUCriticalThreshold2>\n <ModuleCPUMajorThreshold2>0</ModuleCPUMajorThreshold2>\n <ModuleCPUMinorThreshold2>0</ModuleCPUMinorThreshold2>\n <ModuleCPUMinorClearThreshold2>0</ModuleCPUMinorClearThreshold2>\n <ModuleDiskCriticalThreshold2>90</ModuleDiskCriticalThreshold2>\n <ModuleDiskMajorThreshold2>80</ModuleDiskMajorThreshold2>\n <ModuleDiskMinorThreshold2>70</ModuleDiskMinorThreshold2>\n <ModuleMemCriticalThreshold2>90</ModuleMemCriticalThreshold2>\n <ModuleMemMajorThreshold2>0</ModuleMemMajorThreshold2>\n <ModuleMemMinorThreshold2>0</ModuleMemMinorThreshold2>\n <ModuleSwapCriticalThreshold2>90</ModuleSwapCriticalThreshold2>\n <ModuleSwapMajorThreshold2>80</ModuleSwapMajorThreshold2>\n <ModuleSwapMinorThreshold2>70</ModuleSwapMinorThreshold2>\n <ModuleDiskMonitorFileSystem1-2>/</ModuleDiskMonitorFileSystem1-2>\n <ModuleDBRootCount1-2>unassigned</ModuleDBRootCount1-2>\n <ModuleDBRootID1-1-2>unassigned</ModuleDBRootID1-1-2>\n <ModuleType3>pm</ModuleType3>\n <ModuleDesc3>Performance Module</ModuleDesc3>\n <RunType3>SIMPLEX</RunType3>\n <ModuleCount3>1</ModuleCount3>\n <ModuleIPAddr1-1-3>10.0.0.166</ModuleIPAddr1-1-3>\n <ModuleHostName1-1-3>cs-test-mdb-cs-node-0.cs-test-mdb-clust</ModuleHostName1-1-3>\n <ModuleDisableState1-3>ENABLED</ModuleDisableState1-3>\n <ModuleCPUCriticalThreshold3>0</ModuleCPUCriticalThreshold3>\n <ModuleCPUMajorThreshold3>0</ModuleCPUMajorThreshold3>\n <ModuleCPUMinorThreshold3>0</ModuleCPUMinorThreshold3>\n <ModuleCPUMinorClearThreshold3>0</ModuleCPUMinorClearThreshold3>\n <ModuleDiskCriticalThreshold3>90</ModuleDiskCriticalThreshold3>\n <ModuleDiskMajorThreshold3>80</ModuleDiskMajorThreshold3>\n <ModuleDiskMinorThreshold3>70</ModuleDiskMinorThreshold3>\n <ModuleMemCriticalThreshold3>90</ModuleMemCriticalThreshold3>\n <ModuleMemMajorThreshold3>0</ModuleMemMajorThreshold3>\n <ModuleMemMinorThreshold3>0</ModuleMemMinorThreshold3>\n <ModuleSwapCriticalThreshold3>90</ModuleSwapCriticalThreshold3>\n <ModuleSwapMajorThreshold3>80</ModuleSwapMajorThreshold3>\n <ModuleSwapMinorThreshold3>70</ModuleSwapMinorThreshold3>\n <ModuleDiskMonitorFileSystem1-3>/</ModuleDiskMonitorFileSystem1-3>\n <ModuleDBRootCount1-3>1</ModuleDBRootCount1-3>\n <ModuleDBRootID1-1-3>1</ModuleDBRootID1-1-3>\n </SystemModuleConfig>\n <SystemExtDeviceConfig>\n <Count>0</Count>\n <Name1>unassigned</Name1>\n <IPAddr1>0.0.0.0</IPAddr1>\n <DisableState1>ENABLED</DisableState1>\n </SystemExtDeviceConfig>\n <SessionManager>\n <MaxConcurrentTransactions>1000</MaxConcurrentTransactions>\n <TxnIDFile>/var/lib/columnstore/data1/systemFiles/dbrm/SMTxnID</TxnIDFile>\n </SessionManager>\n <VersionBuffer>\n <VersionBufferFileSize>1GB</VersionBufferFileSize>\n </VersionBuffer>\n <OIDManager>\n <OIDBitmapFile>/var/lib/columnstore/data1/systemFiles/dbrm/oidbitmap</OIDBitmapFile>\n <FirstOID>3000</FirstOID>\n </OIDManager>\n <WriteEngine>\n <BulkRoot>/var/lib/columnstore/data/bulk</BulkRoot>\n <BulkRollbackDir>/var/lib/columnstore/data1/systemFiles/bulkRollback</BulkRollbackDir>\n <MaxFileSystemDiskUsagePct>98</MaxFileSystemDiskUsagePct>\n <CompressedPaddingBlocks>1</CompressedPaddingBlocks>\n </WriteEngine>\n <DBRM_Controller>\n <NumWorkers>1</NumWorkers>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8616</Port>\n </DBRM_Controller>\n <DBRM_Worker1>\n <IPAddr>cs-test-mdb-cs-node-0.cs-test-mdb-clust</IPAddr>\n <Port>8700</Port>\n <Module>pm1</Module>\n </DBRM_Worker1>\n <DBRM_Worker2>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker2>\n <DBRM_Worker3>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker3>\n <DBRM_Worker4>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker4>\n <DBRM_Worker5>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker5>\n <DBRM_Worker6>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker6>\n <DBRM_Worker7>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker7>\n <DBRM_Worker8>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker8>\n <DBRM_Worker9>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker9>\n <DBRM_Worker10>\n <IPAddr>0.0.0.0</IPAddr>\n <Port>8700</Port>\n <Module>unassigned</Module>\n </DBRM_Worker10>\n <DBBC>\n <NumCaches>1</NumCaches>\n <IOMTracing>0</IOMTracing>\n <BRPTracing>0</BRPTracing>\n <ReportFrequency>65536</ReportFrequency>\n <MaxOpenFiles>2K</MaxOpenFiles>\n <DecreaseOpenFilesCount>200</DecreaseOpenFilesCount>\n <FDCacheTrace>0</FDCacheTrace>\n <NumBlocksPct>50</NumBlocksPct>\n </DBBC>\n <Installation>\n <SystemStartupOffline>n</SystemStartupOffline>\n <InitialInstallFlag>y</InitialInstallFlag>\n <SingleServerInstall>y</SingleServerInstall>\n <ServerTypeInstall>2</ServerTypeInstall>\n <PMwithUM>n</PMwithUM>\n <MySQLRep>n</MySQLRep>\n <DBRootStorageType>StorageManager</DBRootStorageType>\n <UMStorageType>internal</UMStorageType>\n <EEPackageType>binary</EEPackageType>\n <SystemLogConfigFile>/etc/rsyslog.d/columnstore.conf</SystemLogConfigFile>\n <Cloud>unassigned</Cloud>\n <AmazonVPCNextPrivateIP>autoassign</AmazonVPCNextPrivateIP>\n <UMInstanceType>unassigned</UMInstanceType>\n <UMSecurityGroup>unassigned</UMSecurityGroup>\n <UMVolumeSize>unassigned</UMVolumeSize>\n <UMVolumeType>gp2</UMVolumeType>\n <UMVolumeIOPS>unassigned</UMVolumeIOPS>\n <PMInstanceType>unassigned</PMInstanceType>\n <PMVolumeSize>unassigned</PMVolumeSize>\n <PMVolumeType>gp2</PMVolumeType>\n <PMVolumeIOPS>unassigned</PMVolumeIOPS>\n <AmazonPMFailover>y</AmazonPMFailover>\n <AmazonAutoTagging>y</AmazonAutoTagging>\n <AmazonElasticIPCount>0</AmazonElasticIPCount>\n <AmazonElasticIPAddr1>unassigned</AmazonElasticIPAddr1>\n <AmazonElasticModule1>unassigned</AmazonElasticModule1>\n <DataRedundancyConfig>n</DataRedundancyConfig>\n <DataRedundancyCopies>0</DataRedundancyCopies>\n <DataRedundancyStorageType>unassigned</DataRedundancyStorageType>\n <CoreFileFlag>n</CoreFileFlag>\n <MySQLPort>3306</MySQLPort>\n <AmazonDeviceName>/dev/xvd</AmazonDeviceName>\n <LockFileDirectory>/var/lock/subsys</LockFileDirectory>\n <ProfileFile>/etc/profile.d/columnstoreAlias.sh</ProfileFile>\n <DataRedundancyNetworkType/>\n </Installation>\n <ExtentMap>\n <FilesPerColumnPartition>4</FilesPerColumnPartition>\n <ExtentsPerSegmentFile>2</ExtentsPerSegmentFile>\n <BRM_UID>0x0</BRM_UID>\n </ExtentMap>\n <HashJoin>\n <MaxBuckets>128</MaxBuckets>\n <MaxElems>128K</MaxElems>\n <FifoSizeLargeSide>64</FifoSizeLargeSide>\n <PmMaxMemorySmallSide>1G</PmMaxMemorySmallSide>\n <TotalUmMemory>25%</TotalUmMemory>\n <TotalPmUmMemory>100%</TotalPmUmMemory>\n <CPUniqueLimit>100</CPUniqueLimit>\n <AllowDiskBasedJoin>N</AllowDiskBasedJoin>\n <TempFileCompression>Y</TempFileCompression>\n </HashJoin>\n <JobList>\n <FlushInterval>16K</FlushInterval>\n <FifoSize>16</FifoSize>\n <RequestSize>1</RequestSize>\n <ThreadPoolSize>100</ThreadPoolSize>\n </JobList>\n <TupleWSDL>\n <MaxSize>1M</MaxSize>\n <InitialCapacity>1M</InitialCapacity>\n <MaxBuckets>512</MaxBuckets>\n </TupleWSDL>\n <RowAggregation>\n\t</RowAggregation>\n <CrossEngineSupport>\n <Host>cs-test-mdb-cs-node-0.cs-test-mdb-clust</Host>\n <Port>3306</Port>\n <User>cej</User>\n <Password>C0lumnStore!</Password>\n <TLSCA/>\n <TLSClientCert/>\n <TLSClientKey/>\n </CrossEngineSupport>\n <QueryStats>\n <Enabled>N</Enabled>\n </QueryStats>\n <UserPriority>\n <Enabled>N</Enabled>\n </UserPriority>\n <NetworkCompression>\n <Enabled>Y</Enabled>\n </NetworkCompression>\n <QueryTele>\n <Host>cs-test-mdb-cs-node-0.cs-test-mdb-clust</Host>\n <Port>0</Port>\n </QueryTele>\n <StorageManager>\n <MaxSockets>30</MaxSockets>\n <Enabled>Y</Enabled>\n </StorageManager>\n <DataRedundancyConfig>\n <DBRoot1PMs/>\n </DataRedundancyConfig>\n <ConfigRevision>1</ConfigRevision>\n <ClusterManager>cs-test-mdb-cs-node-0.cs-test-mdb-clust</ClusterManager>\n <ClusterName>MyCluster</ClusterName>\n <NextNodeId>2</NextNodeId>\n <NextDBRootId>2</NextDBRootId>\n <DesiredNodes>\n <Node>cs-test-mdb-cs-node-0.cs-test-mdb-clust</Node>\n </DesiredNodes>\n <ActiveNodes>\n <Node>cs-test-mdb-cs-node-0.cs-test-mdb-clust</Node>\n </ActiveNodes>\n <InactiveNodes/>\n <PrimaryNode>cs-test-mdb-cs-node-0.cs-test-mdb-clust</PrimaryNode>\n <SharedStorage>yes</SharedStorage>\n</Columnstore>', 'cs_config_filename': '/etc/columnstore/Columnstore.xml'}
|
[20/Aug/2020 18:08:12] root This node is not in the current ActiveNodes section. Not starting Columnstore.
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-dmlproc. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-dmlproc 0
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-ddlproc. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-ddlproc 0
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-primproc. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-primproc 0
|
[20/Aug/2020 18:08:12] root This node has no entry in the list of desired nodes
|
[20/Aug/2020 18:08:12] root Loaded the config file, my name is None
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-writeengineserver. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-writeengineserver 0
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-exemgr. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-exemgr 0
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-controllernode. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-controllernode 0
|
[20/Aug/2020 18:08:12] root apply Running stop on mcs-workernode. With sudo False and is_primary False
|
[20/Aug/2020 18:08:12] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-workernode 0
|
[20/Aug/2020 18:08:14] root apply Running stop on mcs-storagemanager. With sudo False and is_primary False
|
[20/Aug/2020 18:08:14] root stop running /opt/cmapi/mcs_node_control/custom_dispatchers/container.sh stop mcs-storagemanager 0
|
10.0.0.166 - - [20/Aug/2020:18:08:14] "PUT /cmapi/0.4.0/node/config HTTP/1.1" 200 43 "" "python-requests/2.23.0"
|
[20/Aug/2020 18:08:14] root broadcast_new_config(): successfully pushed the new config file to ['cs-test-mdb-cs-node-0.cs-test-mdb-clust']
|
10.0.0.166 - - [20/Aug/2020 18:08:14] cmapi_server DEBUG put_commit starts
|
10.0.0.166 - - [20/Aug/2020 18:08:14] cmapi_server DEBUG put_commit returns {'timestamp': '2020-08-20 18:08:14.211940'}
|
10.0.0.166 - - [20/Aug/2020:18:08:14] "PUT /cmapi/0.4.0/node/commit HTTP/1.1" 200 43 "" "python-requests/2.23.0"
|
10.0.0.166 - - [20/Aug/2020 18:08:14] cmapi_server DEBUG put_add_node returns {'timestamp': '2020-08-20 18:08:12.795427', 'node_id': 'cs-test-mdb-cs-node-0.cs-test-mdb-clust'}
|
10.0.0.166 - - [20/Aug/2020:18:08:14] "PUT /cmapi/0.4.0/cluster/add-node HTTP/1.1" 200 97 "" "curl/7.61.1"
|
10.0.0.166 - - [20/Aug/2020 18:10:41] cmapi_server DEBUG get_status starts
|
10.0.0.166 - - [20/Aug/2020 18:10:41] cmapi_server DEBUG get_status starts
|
[20/Aug/2020 18:10:41] root Cannot establish or use DBRM connection. [Errno 111] Connection refused
|
10.0.0.166 - - [20/Aug/2020 18:10:41] cmapi_server DEBUG get_status returns {'timestamp': '2020-08-20 18:10:41.515981', 'uptime': 1783, 'dbrm_mode': 'slave', 'cluster_mode': 'readonly', 'dbroots': [], 'module_id': 1, 'services': []}
|
10.0.0.166 - - [20/Aug/2020:18:10:41] "GET /cmapi/0.4.0/node/status HTTP/1.1" 200 156 "" "curl/7.61.1"
|
10.0.0.166 - - [20/Aug/2020 18:10:41] cmapi_server DEBUG get_status returns {'timestamp': '2020-08-20 18:10:41.507126', 'cs-test-mdb-cs-node-0.cs-test-mdb-clust': {'timestamp': '2020-08-20 18:10:41.515981', 'uptime': 1783, 'dbrm_mode': 'offline', 'cluster_mode': 'readonly', 'dbroots': [], 'module_id': 1, 'services': []}, 'num_nodes': 1}
|
10.0.0.166 - - [20/Aug/2020:18:10:41] "GET /cmapi/0.4.0/cluster/status HTTP/1.1" 200 262 "" "curl/7.61.1"
|
|
------
|
columnstore-init.log
|
Removing gs://mdb0002756-1595842761951-columnstore-db00005735-79658635/087b1561-a13e-4d19-ae01-70d375532e36_0_2097152_data1~000.dir~000.dir~008.dir~016.dir~000.dir~FILE000.cdf...
|
Removing gs://mdb0002756-1595842761951-columnstore-db00005735-79658635/00a05b2e-e403-4dbe-b9e1-50066a396af8_0_2097152_data1~000.dir~000.dir~008.dir~025.dir~000.dir~FILE000.cdf...
|
Removing gs://mdb0002756-1595842761951-columnstore-db00005735-79658635/007d515e-8e44-449d-98b2-c18dea916a9b_0_8_data1~systemFiles~dbrm~BRM_savesA_vss...
|
Removing gs://mdb0002756-1595842761951-columnstore-db00005735-79658635/00ceca06-c6ea-4377-af91-e69668a1e47e_0_3436_data1~systemFiles~dbrm~BRM_savesA_em...
|
Removing gs://mdb0002756-1595842761951-columnstore-db00005735-79658635/0252c561-d480-4b53-ac20-e22c20f0d781_0_1048576_data1~000.dir~000.dir~004.dir~007.dir~000.dir~FILE000.cdf...
|
CommandException: 5 files/objects could not be removed.
|
Starting Primary Node...
|
StorageManager PID = 318
|
loading BRM
|
Error reading data1/systemFiles/dbrm/BRM_saves_current: No such file or directory
|
workernode PID = 333
|
controllernode PID = 336
|
PrimProc PID = 339
|
ExeMgr PID = 371
|
WriteEngineServer PID = 374
|
DMLProc PID = 389
|
DDLProc PID = 392
|
Starting MariaDB.200820 18:06:17 mysqld_safe Logging to '/var/log/mariadb/columnstore/mariadb-error.log'.
|
200820 18:06:17 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
|
SUCCESS!
|
Cross engine join user created
|
Replication user created
|
MaxScale user created
|
Stopping Primary Node...
|
Shutting down MariaDB. SUCCESS!
|
Saved to /var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves
|
Multi-node with local-storage detected.
|
Sending SIGTERM to Columnstore processes
|
/usr/bin/columnstore-init: line 262: 339 Terminated $MCS_INSTALL_BIN/PrimProc &> $LOG_PREFIX/primproc.log
|
/usr/bin/columnstore-init: line 262: 371 Terminated $MCS_INSTALL_BIN/ExeMgr &> $LOG_PREFIX/exemgr.log
|
/usr/bin/columnstore-init: line 262: 374 Terminated $MCS_INSTALL_BIN/WriteEngineServer &> $LOG_PREFIX/writeengineserver.log
|
/usr/bin/columnstore-init: line 262: 389 Terminated $MCS_INSTALL_BIN/DMLProc &> $LOG_PREFIX/dmlproc.log
|
/usr/bin/columnstore-init: line 262: 392 Terminated $MCS_INSTALL_BIN/DDLProc &> $LOG_PREFIX/ddlproc.log
|
Sending SIGKILL to ColumnStore processes
|
Clearing shared memory...
|
|
------
|
controllernode.log
|
DBRM Controller: Waiting for threads to finish...
|
Exiting...
|
|
------
|
corefiles
|
cat: /var/log/mariadb/columnstore/corefiles: Is a directory
|
|
------
|
dbbuilder.log
|
Creating System Catalog...
|
|
Creating SYSTABLE
|
---------------------------------------
|
Creating TableName column OID: 1001
|
Creating TableName column dictionary
|
Creating Schema column OID: 1002
|
Creating Schema column dictionary
|
Creating ObjectId column OID: 1003
|
Creating CreateDate column OID: 1004
|
Creating LastUpdate column OID: 1005
|
Creating INIT column OID: 1006
|
Creating NEXT column OID: 1007
|
Creating NUMOFROWS column OID: 1008
|
Creating AVGROWLEN column OID: 1009
|
Creating NUMOFBLOCKS column OID: 1010
|
Creating AUTOINCREMENT column OID: 1011
|
|
Creating SYSCOLUMN
|
---------------------------------------
|
Creating Schema column OID: 1021
|
Creating Schema column dictionary...
|
Creating TableName column OID: 1022
|
Creating TableName column dictionary...
|
Creating ColumnName column OID: 1023
|
Creating ColumnName column dictionary...
|
Creating ObjectID column OID: 1024
|
Creating DictOID column OID: 1025
|
Creating ListOID column OID: 1026
|
Creating TreeOID column OID: 1027
|
Creating DataType column OID: 1028
|
Creating ColumnLength column OID: 1029
|
Creating ColumnPos column OID: 1030
|
Creating LastUpdate column OID: 1031
|
Creating DefaultValue column OID: 1032
|
Creating DefaultValue column dictionary...
|
Creating Nullable column OID: 1033
|
Creating Scale column OID: 1034
|
Creating Precision column OID: 1035
|
Creating AutoInc column OID: 1036
|
Creating DISTCOUNT column OID: 1037
|
Creating NULLCOUNT column OID: 1038
|
Creating MINVALUE column OID: 1039
|
Creating MINVALUE column dictionary...
|
Creating MAXVALUE column OID: 1040
|
Creating MAXVALUE column dictionary...
|
Creating CompressionType column OID: 1041
|
Creating NEXTVALUE column OID: 1042
|
System Catalog creation took: 0.452925 seconds to complete.
|
|
System Catalog created
|
|
Saved to /var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves
|
|
------
|
ddlproc.log
|
DDLProc is ready...
|
|
------
|
debug.log
|
Aug 20 18:05:57 cs-test-mdb-cs-node-0 StorageManager[318]: Using the config file found at /etc/columnstore/storagemanager.cnf
|
Aug 20 18:06:12 cs-test-mdb-cs-node-0 StorageManager[327]: Using the config file found at /etc/columnstore/storagemanager.cnf
|
Aug 20 18:06:12 cs-test-mdb-cs-node-0 IDBFile[333]: 12.941968 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:12 cs-test-mdb-cs-node-0 IDBFile[348]: 12.974113 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:12 cs-test-mdb-cs-node-0 StorageManager[318]: Ownership: taking ownership of data1
|
Aug 20 18:06:13 cs-test-mdb-cs-node-0 controllernode[348]: 13.034426 |0|0|0| D 29 CAL0000: TableLockServer::load(): could not open the save file/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks
|
Aug 20 18:06:13 cs-test-mdb-cs-node-0 IDBFile[339]: 13.036026 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:14 cs-test-mdb-cs-node-0 IDBFile[374]: 14.004685 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 IDBFile[389]: 16.047648 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 IDBFile[392]: 16.057264 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 IDBFile[393]: 16.067991 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 IDBFile[427]: 16.758494 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:19 cs-test-mdb-cs-node-0 IDBFile[831]: 19.771999 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
|
Aug 20 18:06:19 cs-test-mdb-cs-node-0 StorageManager[318]: SessionManager Caught Signal 15
|
Aug 20 18:06:19 cs-test-mdb-cs-node-0 StorageManager[318]: Shutdown StorageManager...
|
Aug 20 18:06:20 cs-test-mdb-cs-node-0 StorageManager[318]: Ownership: releasing ownership of data1
|
|
------
|
dmlproc.log
|
DMLProc is ready...
|
|
------
|
exemgr.log
|
Starting ExeMgr: st = 50, qs = 20, mx = 95, cf = /etc/columnstore/Columnstore.xml
|
|
------
|
info.log
|
Aug 20 18:05:57 cs-test-mdb-cs-node-0 StorageManager[318]: Cache/cache_size = 8589934592
|
Aug 20 18:05:58 cs-test-mdb-cs-node-0 StorageManager[318]: S3Storage: S3 connectivity & permissions are OK
|
Aug 20 18:05:58 cs-test-mdb-cs-node-0 StorageManager[318]: max_concurrent_downloads = 21
|
Aug 20 18:05:58 cs-test-mdb-cs-node-0 StorageManager[318]: max_concurrent_uploads = 21
|
Aug 20 18:05:58 cs-test-mdb-cs-node-0 StorageManager[318]: SessionManager waiting for sockets.
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 DMLProc[389]: 16.065888 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll.
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 DMLProc[389]: 16.154070 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables.
|
Aug 20 18:06:16 cs-test-mdb-cs-node-0 DMLProc[389]: 16.166109 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll.
|
Aug 20 18:06:20 cs-test-mdb-cs-node-0 StorageManager[318]: StorageManager Shutdown Complete.
|
|
------
|
mariadb-error.log
|
2020-08-20 18:06:17 0 [Warning] Plugin 'Columnstore' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:17 0 [Warning] Plugin 'COLUMNSTORE_COLUMNS' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:17 0 [Warning] Plugin 'COLUMNSTORE_TABLES' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:17 0 [Warning] Plugin 'COLUMNSTORE_FILES' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:17 0 [Warning] Plugin 'COLUMNSTORE_EXTENTS' is of maturity level gamma while the server is stable
|
200820 18:06:17 Columnstore: Started; Version: 1.5.4-1
|
2020-08-20 18:06:17 0 [Note] mariadbd: Aria engine: starting recovery
|
recovered pages: 0% 10% 20% 30% 43% 53% 88% 99% 100% (0.0 seconds); tables to flush: 2 1 0
|
(0.0 seconds);
|
2020-08-20 18:06:17 0 [Note] mariadbd: Aria engine: recovery done
|
2020-08-20 18:06:17 0 [Note] InnoDB: Using Linux native AIO
|
2020-08-20 18:06:17 0 [Note] InnoDB: Uses event mutexes
|
2020-08-20 18:06:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2020-08-20 18:06:17 0 [Note] InnoDB: Number of pools: 1
|
2020-08-20 18:06:17 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
|
2020-08-20 18:06:17 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
|
2020-08-20 18:06:17 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
2020-08-20 18:06:17 0 [Note] InnoDB: Completed initialization of buffer pool
|
2020-08-20 18:06:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2020-08-20 18:06:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56438
|
2020-08-20 18:06:17 0 [Note] InnoDB: 128 rollback segments are active.
|
2020-08-20 18:06:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2020-08-20 18:06:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2020-08-20 18:06:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2020-08-20 18:06:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2020-08-20 18:06:17 0 [Note] InnoDB: 10.5.6 started; log sequence number 56450; transaction id 49
|
2020-08-20 18:06:17 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2020-08-20 18:06:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
2020-08-20 18:06:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200820 18:06:17
|
2020-08-20 18:06:17 0 [Note] Server socket created on IP: '::'.
|
2020-08-20 18:06:17 0 [Note] Reading of all Master_info entries succeeded
|
2020-08-20 18:06:17 0 [Note] Added new Master_info '' to hash table
|
2020-08-20 18:06:17 0 [Note] /usr/sbin/mariadbd: ready for connections.
|
Version: '10.5.6-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
|
2020-08-20 18:06:18 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
|
2020-08-20 18:06:18 0 [Note] Event Scheduler: Purging the queue. 0 events
|
2020-08-20 18:06:18 0 [Note] InnoDB: FTS optimize thread exiting.
|
2020-08-20 18:06:18 0 [Note] InnoDB: Starting shutdown...
|
2020-08-20 18:06:18 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
|
2020-08-20 18:06:18 0 [Note] InnoDB: Buffer pool(s) dump completed at 200820 18:06:18
|
2020-08-20 18:06:19 0 [Note] InnoDB: Shutdown completed; log sequence number 56474; transaction id 52
|
2020-08-20 18:06:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2020-08-20 18:06:19 0 [Note] /usr/sbin/mariadbd: Shutdown complete
|
|
2020-08-20 18:06:24 0 [Warning] Plugin 'Columnstore' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:24 0 [Warning] Plugin 'COLUMNSTORE_COLUMNS' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:24 0 [Warning] Plugin 'COLUMNSTORE_TABLES' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:24 0 [Warning] Plugin 'COLUMNSTORE_FILES' is of maturity level gamma while the server is stable
|
2020-08-20 18:06:24 0 [Warning] Plugin 'COLUMNSTORE_EXTENTS' is of maturity level gamma while the server is stable
|
200820 18:06:24 Columnstore: Started; Version: 1.5.4-1
|
2020-08-20 18:06:24 0 [Note] InnoDB: Using Linux native AIO
|
2020-08-20 18:06:24 0 [Note] InnoDB: Uses event mutexes
|
2020-08-20 18:06:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2020-08-20 18:06:24 0 [Note] InnoDB: Number of pools: 1
|
2020-08-20 18:06:24 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
|
2020-08-20 18:06:24 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
|
2020-08-20 18:06:24 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
|
2020-08-20 18:06:24 0 [Note] InnoDB: Completed initialization of buffer pool
|
2020-08-20 18:06:24 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2020-08-20 18:06:24 0 [Note] InnoDB: 128 rollback segments are active.
|
2020-08-20 18:06:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2020-08-20 18:06:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2020-08-20 18:06:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2020-08-20 18:06:24 0 [Note] InnoDB: 10.5.6 started; log sequence number 56474; transaction id 49
|
2020-08-20 18:06:24 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2020-08-20 18:06:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
2020-08-20 18:06:24 0 [Note] InnoDB: Buffer pool(s) load completed at 200820 18:06:24
|
2020-08-20 18:06:24 0 [Note] Server socket created on IP: '::'.
|
2020-08-20 18:06:24 0 [Note] Reading of all Master_info entries succeeded
|
2020-08-20 18:06:24 0 [Note] Added new Master_info '' to hash table
|
2020-08-20 18:06:24 0 [Note] /usr/sbin/mariadbd: ready for connections.
|
Version: '10.5.6-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
|
2020-08-20 18:06:25 4 [Note] Start binlog_dump to slave_server(126), pos(, 4), using_gtid(1), gtid('')
|
2020-08-20 18:06:28 6 [Note] Start binlog_dump to slave_server(126), pos(mariadb-bin.000002, 344), using_gtid(1), gtid('0-125-11')
|
|
------
|
primproc.log
|
Starting PrimitiveServer: st = 1, sq = 10, pw = 128, pq = 10240, nb = 478531, nt = 4, nc = 1, ra = 512, db = 128, mb = 512, rd = 0, tr = 0, ss = 67108864, bp = 4
|
|
------
|
storagemanager.log
|
|
------
|
trace
|
cat: /var/log/mariadb/columnstore/trace: Is a directory
|
|
------
|
workernode.log
|
"/tmp/columnstore_tmp_files/rdwrscratch"
|
|
------
|
writeengineserver.log
|
WriteEngineServer is ready
|