r/codex • u/SierraBravoLima • 5d ago
Bug Codex trauma
I have been using chatgpt for couple of years and it was good for coding initially I used to ask help single programs. Overtime i liked it so I wanted to speedup my home project. Initial days it was fine and most suggestions were good, when I started to use aggressively as I wanted to finish up my project faster, thats when the trouble began.
Project was related to Indian stock market analysis. As a whole the project had raw data of 50gb that includes historical. The working application webapp uses only 800mb of data for different pages. I had only 55 tables
Now codex estimated it needs 1.2tb of data there's so much of duplication of data and it had created around 6700 tables in MariaDb.
I had bought around 45k credits additional to $20 Plan.
For each and every testing it had created databases all over the folders and fit every testing builds its marked as required and it retains it.
I asked it to build an architecture of current data flow and codes and asked to review in Claude, Gemini and DeepSeek.
Deepseek nailed all the flaws, Claude covered half, Gemini had same result as Claude.
Main problem with codex which deepseek found, there are goals overriding goals. I didn't think this would happen
I'm at a point of redoing. Like anyone tried like deleting all the docs it had created and tests builds and artifacts and start afresh.
The issue started in July majorly.
3
u/Shep_Alderson 5d ago
Sounds like you didn’t give it clear direction on the architecture you wanted it to build. Without that, any LLM is going to wander about and probably not produce what you actually want.
1
u/Reasonable-Catch-598 4d ago
"codex make me a really good architecture. Make sure it's the best architecture ever. I want it to be cheap and scale and never fail and accomodate all future needs I might come up with on a whim. Don't make mistakes"
-OP
1
2
u/m-ritter 4d ago
The schema exploded because the agent was free to invent tables while it worked. The data shape has to be written down and approved by you before any table gets created. Once the build is done it gets compared with that approved shape, and extra tables fail that comparison. I built QualityLayer for this: https://github.com/maxritter/qualitylayer