Ilmar Kerm

@ilmarkerm.eu

Oracle ACE Pro, SYM42, injured runner, otherwise normal Database infrastructure, automation

Exceptionally slow coffee machine on Sõru-Triigi ferry, mine took like 1 min. The silent passive aggressive queue forms, the silence and looks… and the next 1 min brew starts.

I so much hate when someone (more managerial) send a page - "I generated this using AI, please fact check it". I always end up deleting all/most of it and rewriting since the information is just wrong and it uses so many words. Huge waste in time and resources.

The dreaded PostgreSQL "cached plan must not change result type" and connection pooling (pgBouncer). Looks like I have to build something that notifies pool that DDL has happened and reconnect backends. Or pgDog, but then I have a CREATE ROLE notification problem. Could contribute to pgDog.

Cool, managed to find the limit of bigfile tablespace (in 16k block size database). "alter tablespace dw_etl_data maxsize 65t" - ORA-740 datafiue size of xx blocks exceeds maximum file size

Has anyone used Percona MongoDB server? I think they just take MongoDB community edition source and merge their own features on top? I'm just interested in auditing.

Looks like etcd 3.5.28 breaks patroni - Failed to get list of machines - etcdserver: user name is empty. etcd is authenticated. 3.5.29 does not help, downgrade helps.

I saw a table in my old project "dual_replacement" and thought it must be veeery old. Now I see a comment in a view that did not compile anymore "Here it uses dual_replacement because since 19c it seems that when doing DML against view it checks that all referred tables have write privileges"

Amusement for today, letting LLM to rewrite internal documentation to style mixing Linkedin speak and Shakespeare. "A question worth synergizing upon!" "THE PLOT THICKENS: A STRATEGIC NARRATIVE"

Dear Microslop, you seem to be pushing the large slop generators everywhere, but could you please add one where is would actually be needed - search in Teams.