Last entries
-
postgres|postgresql > must be owner of type - [s]
SELECT typname, typowner::regrole, n.* FROM pg_type t LEFT JOIN pg_namespace n on t.typnamespace = n.oid
-
postgres > how to find which records or tables are locked on Postgresql - [s]
select pid, usename, pg_blocking_pids(pid) as blocked_by, query as blocked_query from pg_stat_activity where cardinality(pg_blocking_pids(pid)) > 0;
-
postgres - VACUUM FREEZE vs. VACUUM FULL - [s]
-
linux|centos7 > yum install createrepo - [s]
[root@node-nxrm2 yum.repos.d]# cat appstream.repo [appstream] name=CentOS Linux $releasever - AppStream #mirrorlist=http://#mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=AppStream&infra=$infra #baseurl=http://vault.centos.org/$contentdir/$releasever/AppStream/$basearch/os/ baseurl=http://vault.centos.org/centos/7.6.1810/os/x86_64/ gpgcheck=1 enabled=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial
-
linux|CentOS > Cannot prepare internal mirrorlist: No URLs in mirrorlist - [s]
sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-Linux-* sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-Linux-*
-
bash|wget > How To Find Broken Links (404: Not Found.) - [s]
wget --spider -r -nd -nv -l3 -w1 -t1 -e robots=off -o help.example.com.log https://help.example.com/en/
-
java|visualvm > BTrace : Troubleshooting tool for Java applications - [s]
-
java > VisualVM: Plugin Buffer Monitor - [s]
-
Fixing Java's ByteBuffer native memory "leak" (evanjones.ca) - [s]
-
java > Troubleshooting Problems With Native (Off-Heap|non-heap) - [s]
-XX:MaxDirectMemorySize vs. -Djdk.nio.maxCachedBufferSize java.lang.OutOfMemoryError: null at java.base/jdk.internal.misc.Unsafe.allocateMemory(Unsafe.java:616) at java.base/java.nio.DirectByteBuffer.
(DirectByteBuffer.java:122) at java.base/java.nio.ByteBuffer.allocateDirect(ByteBuffer.java:317) at java.base/sun.nio.ch.Util.getTemporaryDirectBuffer(Util.java:242) at java.base/sun.nio.ch.IOUtil.read(IOUtil.java:242) at java.base/sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:223) at java.base/sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:65) at java.base/sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:107) at java.base/sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:101) at java.base/java.nio.file.Files.read(Files.java:3159) at java.base/java.nio.file.Files.readAllBytes(Files.java:3213)