[108716 views]

[]

[toggle ads]

Odi's astoundingly incomplete notes

New Entries

Oracle hangs on login of one user

I just troubleshooted the strangest Oracle issue. Logon with a certain user simply hangs and eventually returns with ORA-03135. In v$session you can see many sessions waiting on library cache lock. Their current sql statement is a select from sysauth$.

DBA and Oracle consultants were unable to find the problem.

Until I noticed that the password in my datasource was simply wrong. The application tried to open many connections at the same time (to populate its pool). Probably it's a deadlock in Oracle's Auditing for failed logons.

posted on 2016-06-28 10:59 CEST in Code | 0 comments | permalink

findutils atime, mtime, ctime have "interesting" semantics

How not to design a user interface:
       -atime n
              File  was  last accessed n*24 hours ago.  When find figures out how many 24-hour periods ago the file was last accessed, any fractional part is ignored, so to match -atime +1, a file has to have been accessed at least two days ago.


Even tough you say -atime +1, it actually behaves like "atime + 2 days >= now". It's not intuitive. It encourages people of shooting themselves in the foot.

posted on 2016-06-13 15:17 CEST in Code | 0 comments | permalink

Time to switch your Gentoo to Plasma-5

Gentoo has already announced that you should switch from KDE-4 to Plasma-5. Now is a good time to do that. Since yesterday KDE Apps 15.12.3 are marked stable on the amd64 architecture. That means you can upgrade now without adding tons of entries to /etc/portage/package.keywords.

To avoid confusion, please note that there is no KDE-5. There is only the Plasma-5 desktop on which KDE apps can run. Plasma is not KDE. KDE-4 apps will still work on Plasma-5. But most newer versions of KDE apps already support Plasma-5, so you get a consistent look-and-feel.

It's actually very nice once you stop this dreadful thing which happens to be baloo.

posted on 2016-05-26 10:23 CEST in Code | 0 comments | permalink

Grey background in Firefox 46

Firefox 46 has enabled GTK3 support on Linux. This affects the default background color of web pages that don't specify it. To resolve it, put a custom CSS into your profile folder.

~.mozilla/firefox/*.default/chrome/userContent.css:
body {
 background-color: white;
}
GTK3 also affects scrollbar behaviour and the size of form elements.

posted on 2016-04-28 12:37 CEST in Code | 0 comments | permalink

in software: old != stable

We have now all learned that Debian ships a horribly outdated xscreensaver. We have seen similar things in SuSE, so it's not just Debian. And we have also heard that the package maintainers rather paper over that fact instead of shipping a current version.

Debian has that concept where they bless some random version of a software as "stable". Everything else is automatically declared "unstable". Stable for them means: the package maintainers backport some patches they deem "important" to that old version.

Where does that paradigm come from?

From the last century. No, really! There was a point in software history where available system memory became large. So software started becoming larger, simply because you could do more stuff. At the same time the development environments and development processes lacked badly behind that evolution. Can you remember Pair Programming, eXtreme Programming? People were either using Visual C++ 3, or vi to write code. Some even Notepad. There was no infrastructure like static code analysis, continuous integration, basically no unit tests, no coverage analysis. The most you could get was syntax highlighting and CVS.

It was also the time of dial-up Internet, static web pages, no mobile phones, POP accounts, news on paper. No forums. Just mailing lists with no easy way to search. You were basically alone with an old book on the C language.

That basically meant, ever growing code bases became a mine field. It was unmaintainable. It started bitrotting everywhere. Litte changes here and there could easily break code in interesting places.

It was the time of Never Touch a Running System. It was the time of everybody being scared of updates. Change freezes over new years'. Extensive testing before some little change could make it into production. Literally months from writing code to deploying it into production! Then if something want wrong, exceptions to that rule to bring a dearly needed fix in quickly.

Fast-forward to today

We have so much infrastructure that crunches the hundreds of thousands of lines of code without us even looking, that points out when something breaks. We have found ways to manage stunning amounts of code without getting lost. We have continuous integration with solid code coverage.

Huge projects have finally become maintainable. Also structure intrinsic to a language like the package concept of Java, or namespaces in C# help enourmously with organizing large code bases so that you can find your way around. Garbage collection eliminates the need to think too much about memory allocation, which would otherwise be real PITA and a source of many problems in a large system.

This change also leads to greatly increased development speed. The amount of changes that go into projects each day has exploded in the last decade. If you look into a project like OpenStack, the sheer amount of concentrated development power is simply mind boggling.

Current is the new stable

Today bugs are fixed quickly. Often it takes mere minutes after a bug report until the bug is fixed in the code. And mere hours or days until it goes into production.

We have finally come to the conclusion that life is a lot easier if you can get changes into prod as fast as you can, instead of waiting for months. That's the complete opposite of the old paradigm. Yes, that will release bugs into production sometimes. But this way they also get noticed very quickly, and can be fixed speedily. No big deal. Everybody is happy. How many updates of your apps on your smart phone do you get per day? Notice something? Online services like Facebook or Netflix simply don't have maintenance windows. They are permanently online every single millisecond. They release new versions of code several times a day. Nobody even notices.

By the way
, have you noticed how people seem to be so much happier about a fixed bug than about a completely new feature? New feature means they need to adapt and learn something new. Fixed bug means they can finally do what they meant to do.

Suddenly those package maintainers find themselves in a situation where they need to decide which patch of possibly hundreds each day to backport. And they face a large code base that they are very unlikely to understand as they are not developers of that software. So how can they actually do this job? Short answer: they generally can't. There are also numerous examples of when package maintainers failed. They thought they could just "fix" something in OpenSSL better than the developers. Surprise, turns out it was a security disaster.

When software dies

Also software is not maintained forever. Sometimes development simply stalls. Because everybody left the project and had children. Or one of various other reasons. That's the time when also users of that software need to find something else. They will need to stop using it. Software is not alone. It runs embedded in a soup of other software. Sooner or later it will become incompatible with the rest of that soup and actually stop working anyway. Or security issues that were found pile up and make this piece of software a dangerous item.

Obviously that concept of keeping an old version forever is not useful anymore. It needs to be replaced. Some Linux distributions like Gentoo have long adopted a rolling release model with no major releases. This fits the new paradigm perfectly. It allows following upstream releases very closely.

Of course simply adopting a rolling release model is no guarantee for uptodate packages either. Also Gentoo has stable/unstable branches (keywords), which means whether integration of the package within the soup is considered complete. Gentoo took 6 years to deem Apache 2.4 "stable".

Who doesn't move dies

All the above has interesting consequences if software is never updated. Such as in embedded systems. Such systems become dangerous items with time and must be disposed of.
Also it is insufficient to update only certain packages of a system. Systems must keep current on all packages. For instance only updating apps and keeping an outdated kernel is therefore unsafe.
This has also immediate effects on backward compatibility. It should allow the kernel to break user space from time to time by introducing an incompatible change. Of course this would trigger a cascade of updates to user space. But in a rolling release model this should be a supported scenario. Either adapt to the change or become obsolete!

posted on 2016-04-14 10:18 CEST in Code | 0 comments | permalink

KDE clear baloo db

KDE Plasma 5 has this nice launcher that lets you simply start typing and will display search results. Unfortunately they are completely useless. Because they come from Baloo.

The first thing Baloo does is read your whole freaking hard drive and create a full text index from it. Well thanks. I never asked for that. Guess how long that takes for today's disk sizes. And guess how interesting results are from tons of Java API Doc that happens to be installed somewhere deep in a forgotten corner of the file system.

Well, you think, let's just clear the index and let it only index what seems to be useful. Then to your surprise the settings dialog provides no such controls to clear the index. There is a CLI tool called balooctl that even has a clear command. But that seems to accept only individual full path names. And is basically undocumented. Well thanks again for that.

Using strace I was able to find where baloo stores its index: ~/.local/share/baloo. Simply nuke this unfortunate thing out of existance.

posted on 2016-04-13 21:55 CEST in Code | 0 comments | permalink

Ancient Apache Version on SuSE EL 11

How can it be that such a modern Linux distribution ships such an outdated Apache version?!? Apache 2.4 is availably since 4 years. Are they crazy?
# cat /etc/SuSE-release
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3

# httpd2 -V | grep version
Server version: Apache/2.2.12 (Linux/SUSE)
If they have applied additional patches, then that is totally unclear from the version number.

Consequence? Customer's brave admin compiles Apache 2.4 manually. Of course he will then walk away and forget about that box that's completely exposed to the Internet. Very bright idea.

posted on 2016-04-05 10:07 CEST in Code | 0 comments | permalink

Installing Oracle 12c on x86_64 Gentoo

Installing Oracle 12c on an uptodate Gentoo system is no problem at all and a lot easier than installing 11g.

emerge the following additional packages: /dev/shm mount options need to be default and the size needs to be set to accomodate your SGA. NB that more shm is required than the size of your SGA. This seems to be due to busg in Oracle. The required additional space can be a lot. To be safe, just set it to all available memory:
/etc/fstab:
shm                     /dev/shm        tmpfs           defaults,size=64g        0 0
Then: mount -o remount,defaults,size=64g /dev/shm

/etc/sysctl.conf: Always overcommit seems to be the only working solution with dozens of GB SGA.
# there is no swap really
vm.swappiness=0
# 0: default overcommit
# 1: always overcommit
# 2: never overcommit. max = swap + ratio% * RAM
vm.overcommit_memory=1
# commit limit = (swap + ratio% * RAM)
vm.overcommit_ratio=100

Then sysctl -p

If remote installing: See Quick Install Guide.

./runInstaller

Disable password expiry




posted on 2016-03-22 12:03 CET in Code | 0 comments | permalink

Ultimate usability test: change your SMTP port

Ever wonder how much the vendor of your mail client cares about usability? Then try and change the SMTP port.

Outlook is horrible. Hidden behind a cascade of dialogs and inside a wizard.

Apple Mail is even worse. Note the hidden button inside a drop down (yuck!).

Thunderbird just requires 3 clicks.

All of them have in common that the setting is separated from your incoming (IMAP, POP3) account settings. While technically correct, this is not where I would look first.

posted on 2016-03-09 15:07 CET in Code | 0 comments | permalink

The sad state of GTK3 in Eclipse

This is what Eclipse looks like under Gentoo in KDE-4 with the Clearlooks GTK-2 Theme. NB: with Plasma-5 and Breeze Theme it now looks partially better.

Vast gray areas, a clumsy icon bar. It looks so broken you want to close Eclipse immediately.


Dialogs that are completely unusable. Note how the selected left item doesn't match the displayed settings. The Open Type dialog won't show any results. This makes it really unusable.


Missing buttons and checkboxes:


Missing borders in menus. Ok just ugly.


posted on 2016-03-04 18:07 CET in Code | 0 comments | permalink