Debuggging day. The MySQL 5.0 server I tried to run as part of a MediaWiki installation under FreeBSD, crashed during initialization, and a Tomy Walkabout digital baby monitor started emitting a low beeping sound. I solved both cases through educated guesses.
The most tricky problem was the mySQL server crash.
The server starts up through two layers of shell scripts,
so I first had to untangle those by running them through
sh -x.
After I found how the actual server binary got executed I could
probe it with strace, to see whether it was correctly reading
its configuration files.
(The FreeBSD port installation
I used did not install a configuration file, so I installed
one by hand.
cp work/mysql-5.0.24/support-files/my-medium.cnf /var/db/mysql/my.cnf
--with-debug to config),
and run the code under gdb.
A stack trace at the point of crash showed me a fairly innocuous
line in C++.
Given that C++ can sometimes be tricky to compile correctly,
I guessed that the problem was a bug in the fairly
old (2.95.4) gcc installation on the FreeBSD 4.11 system
where MySQL got compiled.
I reinstalled the server from a precompiled binary
(pkg_add -r mysql50-server), and everything worked fine.
The baby monitor case was more tricky, mainly because I lacked proper diagnostic tools. An interesting symptom was that the beeping sound stopped once I put entirely fresh batteries in the transmitting unit. After verifying with a multimeter the voltage output of the power brick, I decided to try a bold move. I opened the transmitting unit, and replaced the 100μF electrolytic capacitor that was near the power supply cables with a new one. My hypothesis was that the capacitor was leaky and failed to filter the power supply voltage. Indeed, the unit worked flawlessly after the change. A lucky educated guess.
Comments Toot! Tweet
The hypocritical call to pause giant AI (2023-03-30)
AI deforests the knowledge’s ecosystem (2023-03-16)
How I fixed git-grep macOS UTF-8 support (2022-10-12)
The sorry state of software quality (2022-03-10)
Rather than alchemy, methodical troubleshooting (2021-11-27)
The Evolution of the Unix System Architecture (2021-06-18)
Reviving the 1973 Unix text to voice translator (2021-01-02)
Fast database UPDATE/DELETE operations (2020-12-10)
Raspberry Pi 400 vs ZX Spectrum (2020-11-02)
Last modified: Saturday, September 2, 2006 11:47 pm
Unless otherwise expressly stated, all original material on this page created by Diomidis Spinellis is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.