Unexpected Error f55eec6de4a94b8d80cf450c7c75203c
Is anyone else getting this? I think it might be to the auto increment column causing an error but I can query data from it and add data into it. Yet I just cannot see the records in the tables section on neon.com
#❓｜questions-and-answers
17 Replies
optimistic-gold•2mo ago
Thanks for reporting! Sharing with the team. We recently updated our table view with a bigger update, so this may be a bug.
What's the project id? (Part of the URL in your project details)
rare-sapphireOP•2mo ago
Here is the url!
app/projects/icy-rice-08974082/branches/br-curly-bird-a84rbn55/tables
optimistic-gold•2mo ago
Can you share the schema/structure of Weatherdata?
Would help us replicate this 🙏
rare-sapphireOP•2mo ago
So the schema is named WeatherData
it has only 1 table named: 'formatted_weather_data'
this table has volumns and data types of
column_name data_type
1 id integer
2 File_name text
3 location_id text
4 temp_F real
5 cloud_cover_perc real
6 surface_pressure real
7 wind_speed_80m_mph real
8 wind_direction_80m_deg real
9 time timestamp with time zone
I believe I set id to an auto incrementing primary key
none of them can be null and there are no other constraints
optimistic-gold•2mo ago
Thank you. 🙏
Working with the Drizzle team and our oncall to track this down!
rare-sapphireOP•4w ago
I can see my tables again! Thank you so much!
optimistic-gold•4w ago
Love to hear it. Very sorry about this in the first place. 🙏
fascinating-indigo•4w ago
hello ! i m getting the same problem here(my project id is : br-misty-lake-a8duke6b/tables; hopefully waiting for your response
optimistic-gold•4w ago
Thanks for reporting. Let me forward to the team as well!
Chatted with team. We're bumping the Drizzle Studio version which should address a few more of these issues. Fix should be in by tomorrow. Please let me know if you still see the issue later this week, @BalumeGuy() 🙏
fascinating-indigo•4w ago
Hey ! Hope you're doing well ! Just to inform you that I'm still stuck in that same situation(problem ) and the thing I don't understand is that the problem happened with just one project, the other are still working !
optimistic-gold•4w ago
Sorry about this! We’re hunting several bugs in the Table View right now. It’s embedding Drizzle Studio and they just released a big update. They have already fixed some bugs but others still persist and we’re also tracking an issue on our end. I assume your one project triggered an edge case while the other didn’t. 🙏🏻
Let me ping the team again about your issue!
deep-jade•4w ago
Hey @BalumeGuy()! Can you please share your schema name, table name, and column name?
fascinating-indigo•4w ago
Hello! Sorry for the late answer, Here is my database schema: CREATE TABLE institution (
id SERIAL PRIMARY KEY,
nom VARCHAR(200) NOT NULL,
logo VARCHAR(100),
adresse TEXT,
contact VARCHAR(100)
);
CREATE TABLE direction (
id SERIAL PRIMARY KEY,
nom VARCHAR(100) NOT NULL,
abrege VARCHAR(20),
chef_id INT REFERENCES agent(id),
ordre INT DEFAULT 0
);
CREATE TABLE division (
id SERIAL PRIMARY KEY,
nom VARCHAR(100) NOT NULL,
abrege VARCHAR(20),
direction_id INT REFERENCES direction(id) ON DELETE CASCADE,
chef_id INT REFERENCES agent(id),
ordre INT DEFAULT 0
);
CREATE TABLE bureau (
id SERIAL PRIMARY KEY,
nom VARCHAR(100) NOT NULL,
abrege VARCHAR(20),
division_id INT REFERENCES division(id) ON DELETE CASCADE,
direction_id INT REFERENCES direction(id),
chef_id INT REFERENCES agent(id),
ordre INT DEFAULT 0
);
CREATE TABLE grade (
id SERIAL PRIMARY KEY,
nom VARCHAR(100) NOT NULL,
abrege VARCHAR(20)
);
CREATE TABLE agent (
id SERIAL PRIMARY KEY,
matricule VARCHAR(20) UNIQUE NOT NULL,
nom VARCHAR(100),
postnom VARCHAR(100),
prenom VARCHAR(100),
sexe CHAR(1) CHECK (sexe IN ('M','F')),
user_id INT UNIQUE REFERENCES auth_user(id),
idgrade_id INT REFERENCES grade(id),
bureau_id INT REFERENCES bureau(id),
division_id INT REFERENCES division(id),
direction_id INT REFERENCES direction(id)
);
CREATE TABLE presence (
id SERIAL PRIMARY KEY,
agent_id INT REFERENCES agent(id) ON DELETE CASCADE,
date DATE NOT NULL,
statut VARCHAR(2) CHECK (statut IN ('P','A','R','F')),
type_travail CHAR(1) DEFAULT 'P' CHECK (type_travail IN ('P','D','T')),
enregistre_par_id INT REFERENCES auth_user(id)
);
CREATE TABLE jourouvrable (
id SERIAL PRIMARY KEY,
jour INT UNIQUE CHECK (jour BETWEEN 0 AND 6),
est_ouvrable BOOLEAN DEFAULT TRUE
); ; I will stay up to give any needed details !
deep-jade•4w ago
Could you share a screenshot of the error you’re seeing?
fascinating-indigo•4w ago
In the dashboard we have this message(occur only when I click on Tables or execute an SQL query ) , and my Django app on render gives an error about being unable to access the database
deep-jade•4w ago
It seems this has happened before and there is a solution for it. https://discord.com/channels/1176467419317940276/1404678516527857694/1404922213500583966
fascinating-indigo•4w ago
Thank you, the solution given in that salon works , it was just about allowing traffic via the public internet! Thanks!