This is a tricky one affecting MySql table updates which have views. Documentation about this error actually explains the cause, but doesn't connect the dots. I have a view V on table T and want to delete some rows from T. That works fine as long as the DELETE statement doesn't involve the view, so … Continue reading Mysql: the definition of table prevents operation … on table
Month: Aug 2021
Just asking questions
Sam Harris discusses in an episode of his podcast [1 ] the damage done by public discussions in which actors conceal their true motivation behind a series of orchestrated questions. For example, the statement "cars are responsible for climate change" is easily disguised as a series of straight, indirect or suggestive questions: "why are global … Continue reading Just asking questions
Ubuntu 20.04 getting wrong IP address
Yesterday (early August 2021) my Ubuntu 20.04 installation started configuring all network interfaces (wifi, ethernet) with IPv4 addresses from the wrong network segment block, namely 192.168.0.x. IPv6 still worked fine. I didn't figure out whether that's due to a change in the router or the OS (I suspect the router, because the situation improved when … Continue reading Ubuntu 20.04 getting wrong IP address
Extracting field with fluentd
While playing around with fluentd the need came up to extract data nested deep into the logging input and add it as a flat field to the output. If you're not familiar with fluentd (I'm not): it's similar to logstash in that it collects logs from a variety of sources, filters, transforms and categorises them … Continue reading Extracting field with fluentd