The tungsten_skip_seqno Command

The tungsten_skip_seqno command allows events to be skipped based on filters, allowing the Tungsten Replicator to come back online with less manual intervention.

Usage

tungsten_skip_seqno [option]

Where:

Option	Description
--auto	Automatically skip if seqno is in an error state - ONLY USE THIS WHEN ASKED TO BY CONTINUENT SUPPORT.
--debug Aliases: -d	Debug mode if very chatty. Avoid it unless you really need to. Implies --verbose and --info
--filter Aliases: -f	Specify a single regex to match in the pendingExceptionMessage. If a filter is specified, then the new behavior will be to skip if the regex matches the pendingExceptionMessage, and do not not skip if there is no match. The regex will be matched against the pendingExceptionMessage like this: /yourRegexValue/gm. For example, to match foreign key errors in a specific table: foreign key constraint fails.*?`yourSchemaName`.`yourTableName`
--filters	Specify a plain text file with one or more regexes, one per line, to match in the pendingExceptionMessage
--help Aliases: -h	Show help text.
--info Aliases: -i	Displays additional information, but not fully verbose.
--max Aliases: -m	Specify the maimum number of iterations. Default: 100
--path Aliases: -p	Supply full path to trepctl and thl executables if NOT installed in default directory.
--quiet Aliases: -q
--service Aliases: -s	Supply service name to use - Required if more than one replication service running.
--tpm	Specify tpm executable name and path if changed from default, for example if executable-prefix has been set.
--trepctl	Supply name of trepctl executable if different from default, for example if executable-prefix has been set.
--verbose Aliases: -v	Displays additional information. Implies --info.

By default, the tungsten_skip_seqno command will:

• Gather a list of replicator service names using trepctl services| grep serviceName
• Start an infinite loop
• Loop through all services or use the service specified on the cli using the --service option
• Check the service status via trepctl status -json
• If the pendingErrorSeqno is not -1, then process the error state
• By default, if there is an error condition, a detailed message is displayed, and the user may skip the seqno interactively
• If the tungsten_skip_seqno command is called with --auto then the seqno with the error will be skipped automatically.
• If the maximum number of loops has been reached (default: 100), the script will exit. Use --max to adjust this value.
• Sleep for 3 seconds by default, then iterate