Deleting a bad changelog in Liquibase

1 – Identify the change set you need to remove (to run again) <changeSet author=“me” id=“2.1.0-x-table”> <sqlFile path=“/mycustomsql.sql” relativeToChangelogFile=“false” stripComments=“true” /> </changeSet> 2 – As your db instance owner, remove the change log entry [db2inst1@db myfolder]$ db2 “DELETE from myschema.DATABASECHANGELOG WHERE ID = ‘2.1.0-x-table’” DB20000I The SQL command completed successfully. 3 – Confirm the change […]

Logging using PQS lower than 4.6

To logging PQS, you can log using NGINX as a proxy that records the HTTP Request Body and the timing. On your Centos/RHEL machine, switch to root privileges sudo -s Add nginx.repo Install nginx packages, and you can setup a proxy yum install nginx.x86_64 -y Create the nginx configuration so you have a log_format that […]

Logging using PQS 4.7 and Higher

1 – Drop this into /tmp and chmod 755 on the file In practice, I’d probably put it in /opt/phoenix/config or /etc/hbase/phoenix 2 – Edit the queryserver.py (/opt/phoenix/bin/queryserver.py ) Around line 128 (hopefully not changed much from 4.7 to 4.8), add this ” -Dlog4j.configuration=file:///tmp/log4j.properties” + \ 3 – Restart phoenix /opt/phoenix/bin/queryserver.py stop /opt/phoenix/bin/queryserver.py start 4 […]

Hamcrest Matchers Issue

I’ve been using Rest-Assured as a simple Integration Test tool for the last few months, and suddenly I started seeing this issue. java.lang.SecurityException: class “org.hamcrest.Matchers”‘s signer information does not match signer information of other classes in the same package at java.lang.ClassLoader.checkCerts(ClassLoader.java:895) at java.lang.ClassLoader.preDefineClass(ClassLoader.java:665) at java.lang.ClassLoader.defineClass(ClassLoader.java:758) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) at java.net.URLClassLoader.defineClass(URLClassLoader.java:467) at java.net.URLClassLoader.access$100(URLClassLoader.java:73) at java.net.URLClassLoader$1.run(URLClassLoader.java:368) at java.net.URLClassLoader$1.run(URLClassLoader.java:362) […]