Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] relation "conversations" does not exist #15

Open
2 tasks done
siddhijain47 opened this issue Jul 5, 2023 · 1 comment
Open
2 tasks done

[Bug] relation "conversations" does not exist #15

siddhijain47 opened this issue Jul 5, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@siddhijain47
Copy link

Is this a new bug?

  • I believe this is a new bug
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

When I run the command npm run dev, and redirected to UI, as I entered the text in textbox I am getting this error at backend terminal -
name: 'SequelizeDatabaseError',
parent: error: relation "conversations" does not exist
at Parser.parseErrorMessage (/home/chatbot-demo/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/home/chatbot-demo/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/home/chatbot-demo/node_modules/pg-protocol/dist/parser.js:39:38)
at TLSSocket. (/home/chatbot-demo/node_modules/pg-protocol/dist/index.js:11:42)
at TLSSocket.emit (node:events:511:28)
at addChunk (node:internal/streams/readable:332:12)
at readableAddChunk (node:internal/streams/readable:305:9)
at Readable.push (node:internal/streams/readable:242:10)
at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23) {
length: 110,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'errors.go',
line: '171',
routine: 'NewUndefinedRelationError',
sql: "SELECT entry, speaker, created_at FROM conversations WHERE user_id = 'roie' ORDER By created_at DESC LIMIT 10",
parameters: undefined
},
original: error: relation "conversations" does not exist

image

Expected Behavior

It should run smoothly

Steps To Reproduce

Run npm run dev

Relevant log output

No response

Environment

- **OS**: linux
- **Language version**:Python 3.8.10
- **Pinecone client version**:

Additional Context

No response

@siddhijain47 siddhijain47 added the bug Something isn't working label Jul 5, 2023
@PaulGwamanda
Copy link

The error means there is no schema named "conversations". You need to manually seed the migration in cockroachdb under data/migrations. Click Add Schema, Upload it as PostgresSQL, choose INT4 in INT type, then upload the file under ./db/dbinit.sql

After this, click migrate schema on top right then enter your database name

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants