Change is required. Atlassian engineer's blog

  Hello community, Gonchik Tsymzhitov is in touch. Today, I would like to share with you a short story about postgresqltuner.pl in usage.  So from previous articles I hope you configured the PostgreSQL server and postgresqltuner.pl.  After executing command, ./postgresqltuner.pl --ssd for ssd disks server. You can see like this output: postgresqltuner.pl version 1.0.1 [OK]      I can invoke executables Connecting to /var/run/postgresql:5432 database template1 as user 'postgres'... [OK]      The user account used by me for reporting has superuser rights on this PostgreSQL instance =====  OS information  ===== [INFO]    OS: linux Version: 5.4.17-2036.102.0.2.el8uek.x86_64 Arch: x86_64-linux-thread-multi [INFO]    OS total memory: 41.03 GB [OK]      vm.overcommit_memory is adequate: no memory overcommitment [INFO]    Running under a vmware hypervisor [INFO]    Currently used I/O sc...

  Привет сообщество,  на связи Гончик Цымжитов. Сегодня, хочу поделиться с короткой историей, о том, как верный инструменты неожиданно ломают на новых ОС, и как легко чинятся. Итак, все мы знаем, что centos.rip , через очень промежуток времени, поэтому я перехожу везде на Oracle Linux 8.  Мой любимый инструмент по настройке серверов PostgreSQL, это postgresqltuner.pl, где я уже рассказывал в этой статье .  Настройка как обычно идет очень просто: # dnf install -y perl-DBD-Pg # wget -O postgresqltuner.pl https://postgresqltuner.pl # chmod +x postgresqltuner.pl Но в этом, раз когда запускал скрипт встретился с такой проблемой, # ./postgresqltuner.pl --ssd Can't locate Memoize.pm in @INC (you may need to install the Memoize module) (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at ./postgresqltuner.pl line 262. BEGIN failed--compilation aborted at ./postgresqltuner...

  Hello community, Gonchik Tsymzhitov is in touch. Today, I want to share with you a short story about how trustworthy tools unexpectedly break on new operating systems, and how easy they are to be repaired. So, we all know that  centos.rip , after a very period of time, so I am migrating everywhere to Oracle Linux 8. My favorite tool for setting up PostgreSQL servers is postgresqltuner.pl, which I have already covered  in this article . Setting up as usual is very simple: # dnf install -y perl-DBD-Pg # wget -O postgresqltuner.pl https://postgresqltuner.pl # chmod +x postgresqltuner.pl But this time, when I ran the script, I encountered such a problem after command, # ./postgresqltuner.pl --ssd Can't locate Memoize.pm in @INC (you may need to install the Memoize module) (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at ./postgresqltuner.pl line 262. BEGIN failed--co...

  Hi!  Today I would like to share a curious story related to the integration of Jira (adoptJDK 11) and the ERP system which works on old Java 6. You would say to me, welcome to the "blood enterprise systems". So during our security audit, IDS detected the non-secure protocol TLSv1.1 in that inter-connected communication Jira DC and that ERP system, correctly one of the cipher suites  TLS_RSA_WITH_AES_128_CBC_SHA . Yes, it's an old cipher suite, and that tutorial can be used for any other cipher suite as well.  How we can fix it?  Set string TLS protocol for all Jira (don’t forget for all nodes), TLS1.3 , TLS1.2. And please, keep in your mind the  bug  (JDK-8211806 : TLS 1.3 handshake server name indication is missing on a session resume) Adjust java.security configurations   Below table describe the small background and default protocols in your jdk/jre:    JDK 8 (March 2014 to present) JDK 7 (July 2011 to present) JDK 6 (2006 to  ...

  Today after updating browser, fortunately, my Github account start to use the dark mode, so I am so happy.  Long time ago it was a needy feature to me.  On-Prem: https://jira.atlassian.com/browse/JRASERVER-63150 Cloud:  https://jira.atlassian.com/browse/JRACLOUD-63150   So possible solutions, you can find below. Marketplace apps: https://marketplace.atlassian.com/search?query=dark%20mode Chrome app: https://chrome.google.com/webstore/detail/night-mode-for-jira/nlgcogdbamhmdbpaabmpklojolokodaa?hl=en https://github.com/aalvarado/JiraDarkTheme  via Stylus https://darkreader.org/   And last option is  chrome://flags/#enable-force-dark  , which is my favourite one.  Only one problem during browser upgrade of browser sometimes configs of dark mode can be changed. Fortunately, we can start to see more and more services start to use dark mode.  I hope soon Atlassian products will support and the community will be happy with that small fea...

  Hi!  Gonchik in touch.  As we know Garbage-First is quite a popular garbage collector nowadays. At least more and more articles, product documentation mention G1GC.  Today, I’d like to share a story about leaked Jira Service Desk DC (3 nodes) with more than 20 apps from the marketplace, quite a lot of groovy scripts (405 files), 6 in-house apps. Also, it's continue of  previous article . One of the instances every night do import files into the  “Insight” app , those asset management includes too many assets around 1 mln, as it’s daily import history of objects can grow as well. Let’s focus only on importing procedure, we had 1 dedicated instance with 32GB heap for jdk8u282-b08 and G1GC. During import find out the next behaviour: # cat atlassian-jira-gc.0.current| grep -i "full" 2021-03-30T21:13:19.462+0300: 934.828: [Full GC (Allocation Failure)  31309M->23165M(32768M), 58.7721842 secs ] 2021-03-30T21:14:31.997+0300: 1007.363: [Full GC (Allocatio...

  Hi!  Gonchik is in touch. Today I would like to get a little bit of help from you related SQL indexes on your Jira installation (Data Center, Server edition does not matter).    I would like to share a story about  PostgreSQL  and  Jira 8.13.3  ( JSD 4.13.3 )  release.  In that post I will be happy if you answer and comment about your instance indexes, as those info can help to improve the existing situation of heavy indexes.  Typically, it starts from improvement of configuration (e.g. using  https://postgresqltuner.pl/ ),  then query analyzing, adding indexes, after removing as heavy one (shortly  https://wiki.postgresql.org/wiki/Index_Maintenance ) :)    I use like this query in PostgreSQL: SELECT s.schemaname,        s.relname AS tablename,        s.indexrelname AS indexname,        pg_size_pretty(p...