Skip to content

Instantly share code, notes, and snippets.

@wongster80
wongster80 / gist:66d988abe5ac2a5450f406e2c381695b
Created November 22, 2019 18:17
sstableloader exception on node3
ERROR 18:11:01,114 [Stream #6f7a3cb0-0d53-11ea-953a-0d9817d21dd4] Streaming error occurred on session with peer 172.31.27.177
java.lang.RuntimeException: java.nio.file.NoSuchFileException: /var/lib/cassandra/data/killr_video/user_by_email-8426a7410c8911ea8ad0b706d92db545/ac-26-bti-Data.db
at org.apache.cassandra.io.util.ChannelProxy.openChannel(ChannelProxy.java:50)
at org.apache.cassandra.io.util.ChannelProxy.<init>(ChannelProxy.java:61)
at org.apache.cassandra.io.util.AsynchronousChannelProxy.getBlockingChannel(AsynchronousChannelProxy.java:213)
at org.apache.cassandra.io.util.AsynchronousChannelProxy.transferTo(AsynchronousChannelProxy.java:218)
at org.apache.cassandra.streaming.compress.CompressedStreamWriter.lambda$write$0(CompressedStreamWriter.java:86)
at org.apache.cassandra.io.util.BufferedDataOutputStreamPlus.applyToChannel(BufferedDataOutputStreamPlus.java:344)
at org.apache.cassandra.streaming.compress.CompressedStreamWriter.write(CompressedStreamWriter.java:86)
at org.apache.cassandra.str
Salt-ssh command:
salt-ssh host1 state.sls mysql --extra-filerefs=salt://common/vars.sls -l debug
TemplateNotFound: common/vars.sls
; line 4
# Pillar looks like this:
mysql-configuration-settings:
global_buffers:
key_buffer_size: 8
innodb_log_buffer_size: 8000
innodb_additional_mem_pool_size: 8000
net_buffer_length: 1000
query_cache_size: 1000
{
"ORA_TS": [
[
"Mon Aug 07 16:30:35 2017"
]
],
"DAY": [
[
"Mon"
]
@wongster80
wongster80 / gist:77ccee824bef558d31f6678f6a0b5107
Created March 30, 2017 22:03
AbstractJsonArrayUnnestFactory - modified for long varchar
class AbstractJsonArrayUnnestFactory : public TransformFunctionFactory {
public:
virtual void getPrototype(Vertica::ServerInterface &,
Vertica::ColumnTypes &argTypes,
Vertica::ColumnTypes &resTypes)
{
//argTypes.addVarchar();
//resTypes.addVarchar();
argTypes.addLongVarchar(); /* Adding long varchar data type */
# ======================== Elasticsearch Configuration =========================
#
# NOTE: Elasticsearch comes with reasonable defaults for most settings.
# Before you set out to tweak and tune the configuration, make sure you
# understand what are you trying to accomplish and the consequences.
#
# The primary way of configuring a node is via this file. This template lists
# the most important settings you may want to configure for a production cluster.
#
# Please see the documentation for further information on configuration options:
# ======================== Elasticsearch Configuration =========================
#
# NOTE: Elasticsearch comes with reasonable defaults for most settings.
# Before you set out to tweak and tune the configuration, make sure you
# understand what are you trying to accomplish and the consequences.
#
# The primary way of configuring a node is via this file. This template lists
# the most important settings you may want to configure for a production cluster.
#
# Please see the documentation for further information on configuration options:
# If you are running more than one instances of graylog2-server you have to select one of these
# instances as master. The master will perform some periodical tasks that non-masters won't perform.
is_master = true
# The auto-generated node ID will be stored in this file and read after restarts. It is a good idea
# to use an absolute file path here if you are starting graylog2-server from init scripts or similar.
node_id_file = /etc/graylog/server/node-id
# You MUST set a secret to secure/pepper the stored user passwords here. Use at least 64 characters.
# Generate one by using for example: pwgen -N 1 -s 96
bash-4.1$ sudo -H -u hdfs /bin/sh -c "kinit -p hdfs -k -t ~/.keytab ; beeline -u 'jdbc:hive2://hd-sbx-support2.np.wc1.yellowpages.com:10000/default;principal=hive/_HOST@CORP.YP.COM' -n hdfs -f /home/t/sentry/conf/sentry_acls.sql"
scan complete in 6ms
Connecting to jdbc:hive2://hd-sbx-support2.np.wc1.yellowpages.com:10000/default;principal=hive/_HOST@CORP.YP.COM
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hd-sbx-support2.np.wc1.yellowpages.com:10000/default;principal=hive/_HOST@CORP.YP.COM: Peer indicated failure: GSS initiate failed (state=08S01,code=0)
0: jdbc:hive2://hd-sbx-support2.np.wc1.yellow (closed)> CREATE ROLE select_for_all ;
No current connection
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hd-sbx-support2.np.wc1.yellowpages.com:10000/default;principal=hive/_HOST@CORP.YP.COM: Peer indicated failure: GSS initiate failed (state=08S01,code=0)
This used to work on 2014.1.13 but fails on 2015.5.0 and 2015.5.2:
state init.sls file content:
{% set TEST_SYMLINK = '/opt/test_symlink' %}
{% if 0 == salt['cmd.retcode']('test -h '~ TEST_SYMLINK ~' ') %}
{{ TEST_SYMLINK }}:
file.symlink:
- target: /opt/yp