create_sql_agent with ChatMistralAI causes this error:"Expected last role User or Tool (or Assistant with prefix True) for serving but got assistant" #23703
Comments
dosubot
bot
added
Ɑ: agent
|
Found any solution to this? |
|
Hi, @amarion35. I'm Dosu, and I'm helping the LangChain team manage their backlog. I'm marking this issue as stale. Issue Summary:
Next Steps:
Thank you for your understanding and contribution! |
dosubot
bot
added
the
stale
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Checked other resources
Example Code
This is the minimal code to reproduce the error:
This is the payload of the call to the mistral API route
/chat/completions:{ "messages": [ { "role": "system", "content": "You are an agent designed to interact with a SQL database.\\nGiven an input question, create a syntactically correct postgresql query to run, then look at the results of the query and return the answer.\\nUnless the user specifies a specific number of examples they wish to obtain, always limit your query to at most 10 results.\\nYou can order the results by a relevant column to return the most interesting examples in the database.\\nNever query for all the columns from a specific table, only ask for the relevant columns given the question.\\nYou have access to tools for interacting with the database.\\nOnly use the below tools. Only use the information returned by the below tools to construct your final answer.\\nYou MUST double check your query before executing it. If you get an error while executing a query, rewrite the query and try again.\\n\\nDO NOT make any DML statements (INSERT, UPDATE, DELETE, DROP etc.) to the database.\\n\\nIf the question does not seem related to the database, just return \"I don\"t know\" as the answer.\\n" }, { "role": "user", "content": "Do any correct query" }, { "role": "assistant", "content": "I should look at the tables in the database to see what I can query. Then I should query the schema of the most relevant tables." } ], "model": "mistral-small-latest", "tools": [ { "type": "function", "function": { "name": "sql_db_query", "description": "Input to this tool is a detailed and correct SQL query, output is a result from the database. If the query is not correct, an error message will be returned. If an error is returned, rewrite the query, check the query, and try again. If you encounter an issue with Unknown column "xxxx" in "field list", use sql_db_schema to query the correct table fields.", "parameters": { "type": "object", "properties": { "query": { "description": "A detailed and correct SQL query.", "type": "string" } }, "required": [ "query" ] } } }, { "type": "function", "function": { "name": "sql_db_schema", "description": "Input to this tool is a comma-separated list of tables, output is the schema and sample rows for those tables. Be sure that the tables actually exist by calling sql_db_list_tables first! Example Input: table1, table2, table3", "parameters": { "type": "object", "properties": { "table_names": { "description": "A comma-separated list of the table names for which to return the schema. Example input: \"table1, table2, table3\"", "type": "string" } }, "required": [ "table_names" ] } } }, { "type": "function", "function": { "name": "sql_db_list_tables", "description": "Input is an empty string, output is a comma-separated list of tables in the database.", "parameters": { "type": "object", "properties": { "tool_input": { "description": "An empty string", "default": "", "type": "string" } } } } }, { "type": "function", "function": { "name": "sql_db_query_checker", "description": "Use this tool to double check if your query is correct before executing it. Always use this tool before executing a query with sql_db_query!", "parameters": { "type": "object", "properties": { "query": { "description": "A detailed and SQL query to be checked.", "type": "string" } }, "required": [ "query" ] } } } ], "stream": true }Error Message and Stack Trace (if applicable)
Description
I'm following this guide to implement a SQL agent with the
langchain_community.agent_toolkits.create_sql_agentfunction but instead of using OpenAI I want to use the Mistral API. When I try to implement this agent with mistral I get the error you can see above. The mistral chat completion api doesn't expect the last message of the chat to be an assistant message unless the prefix feature is enabled. I don't know what is the expected behavior of this agent so I can't tell if it's an agent issue, or a mistral client issue.System Info
The text was updated successfully, but these errors were encountered: