Solved

Is that possible in Postgresql Multiple Stream

  • 26 October 2022
  • 2 replies
  • 101 views

Badge +1

When we backup FSbasebackup bakcup stream opened 1 stream. That reason our backup is going very slow. Is that possible the configure multiple stream ?

 

 

icon

Best answer by Sunil 26 October 2022, 14:18

View original

2 replies

Userlevel 5
Badge +12

Hi @Burak Kosker 

Multi-stream backup is available with Block level backup. Regular FS Based backups don’t have multi-stream capability right now. Support is on roadmap.

 

Thanks,

Sunil-

Userlevel 1
Badge +7

Multi-stream backup is available in 11.32 : 

 

https://documentation.commvault.com/2023e/essential/159108_modifying_number_of_streams_for_backups.html

 

 

@Sunil any chance you know if multi-stream is also supported with InteliSnap backup copy? So far we are using InteliSnap → Backup Copy (block, multi-stream) → Disk → LTO. I want to return to new Filesystem Based backup (without block level, multi-stream). Backup copy is working fine, but restore from disks ends with below error. Looks like it expects to do snap restore and not filesystem restore. 

 

91272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestoreClientConfig::processJobOptions(3291) - Destination client is not a distributed client. Multi-Streamed restore will be performed.
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestoreClientConfig::processJobOptions(3311) - Source client is not a distributed client. Indexing version check needs to be performed
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestoreClientConfig::parseArguments(3122) - RestoreStreamStarvationFactor: 2
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestoreClientConfig::parseArguments(3133) - MaxRestoreTasksPerAFile: 4
191272 2eb28 11/03 12:20:43 3716350 CLiveSyncReplication::InitLiveSyncRestore(557) - +++
191272 2eb28 11/03 12:20:43 3716350 CLiveSyncReplication::InitLiveSyncRestore(557) - --- 0:00.000255
191272 2eb28 11/03 12:20:43 3716350 DistributedIDA::CMaster::registerWithJM(911) - Use jm control role [1]
191272 2eb28 11/03 12:20:43 3716350 DistributedIDA::CMaster::initialize(459) - Threshold for stream failures per node is [3]
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestore::loadNodeConfiguration(1349) - <?xml version="1.0" encoding="UTF-8" standalone="no" ?><App_DistributedAppsRestoreOptions/>
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestore::loadNodeConfiguration(1402) - This is file system restore job, adding local node mysql-restore
191272 2eb28 11/03 12:20:43 3716350 CVDC_FileSystem::CRestore::loadNodeConfiguration(1507) - added [1] access nodes
191272 2eb28 11/03 12:20:43 3716350 DistributedIDA::ICoordinator::UpdateSubclientDirectory(666) - Subclient directory distribution is not enabled.
191272 2eb28 11/03 12:20:43 3716350 JOBRESCACHEDIR: Galaxy 6.1-style Index Cache is not supported. Any index located in the cache sub-folder [/opt/commvault/iDataAgent/jobResults/2] will be treat as 'not present'.
191272 2eb28 11/03 12:20:43 3716350 Postgres::PostgresFSRestoreCoordinator::PrepareRestoreParameters(133) - Attempting to restore a snap backup on a client without media agent installed.  Please either install the media agent package or specify a Proxy for Snap Clients.
191272 2eb28 11/03 12:20:43 3716350 DistributedIDA::CMaster::handleEventError(1143) - 0x8007065B:{DistributedIDA::CMaster::initialize(487)} + {Postgres::PostgresFSRestoreCoordinator::initialize(73)} + {CVDC_FileSystem::CRestore::initialize(265)} + {Postgres::PostgresFSRestoreCoordinator::PrepareRestoreParameters(138)/W32.1627.(Function failed during execution. (ERROR_FUNCTION_FAILED.1627))-Primary node [psql-restore] does not have Postgres installed. Please install Postgres package and try again}
191272 2eb28 11/03 12:20:43 3716350 DistributedIDA::CMaster::endPhaseTasks(4110) - m_jsStatus:2 m_jsStatusFor:2 m_jsPendingCause:4
191272 2eb28 11/03 12:20:43 3716350 Sending FAILED complete message to JM, 3716350

Reply