System-provided Tools Like Time Are Unavailable After Upgrading To Version 1.0.0

by ADMIN 81 views

System-provided tools like Time are unavailable after upgrading to version 1.0.0

Upgrading to a new version of an application can be a complex process, and sometimes, it may lead to unexpected issues. In this case, we are experiencing a problem where system-provided tools, such as the Time tool, are no longer functional after upgrading to version 1.0.0. In this article, we will investigate the issue and provide a detailed report of the problem.

Before submitting this bug report, we have performed the following self-checks to ensure that we are providing accurate and relevant information:

  • This is only for bug report, if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:)
  • Please do not modify this template :) and fill in all the required fields.

The version of Dify that we are using is 1.0.0.

Our Dify instance is self-hosted using Docker.

To reproduce the issue, we have followed these steps:

  1. Upgraded our application to version 1.0.0.
  2. Investigated the logs and found the following error message: 2025/03/09 09:44:44 /app/internal/db/pgsql.go:259 record not found[0.310ms] [rows:0] SELECT * FROM "tool_installations" WHERE tenant_id = '30f7868a-57a4-4857-b947-03d105e80f31' AND plugin_id = 'langgenius/time' ORDER BY "tool_installations"."id" LIMIT 1

We did not expect any response from the system-provided tools, as the issue is related to the unavailability of these tools.

The actual behavior is that the system-provided tools, such as the Time tool, are not available or not functioning correctly after the upgrade. The error message in the logs suggests that the application is unable to find the corresponding record in the tool_installations database table.

Based on the error message, it appears that the issue is related to the database table tool_installations. The application is unable to find the corresponding record for the Time tool, which is causing the system-provided tools to be unavailable.

There are several possible causes for this issue:

  • The database table tool_installations may be corrupted or missing.
  • The plugin_id 'langgenius/time' may be incorrect or not properly configured.
  • The tenant_id '30f7868a-57a4-4857-b947-03d105e80f31' may be incorrect or not properly configured.

In conclusion, the system-provided tools like Time are unavailable after upgrading to version 1.0.0. The error message in the logs suggests that the application is unable to find the corresponding record in the tool_installations database table. We have identified several possible causes for this issue and will investigate further to resolve the problem.

Based on our analysis, we recommend the following:

  • Check the database table tool_installations for any corruption or missing records.
  • Verify the plugin_id 'langgenius/time' and ensure that it is correctly configured.
  • Verify the tenant_id '30f7868a-57a4-4857-b947-03d105e80f31' and ensure that it is correctly configured.

We will continue to investigate this issue and provide updates on our progress. If you have any questions or would like to provide additional information, please feel free to comment below.
System-provided tools like Time are unavailable after upgrading to version 1.0.0: Q&A

In our previous article, we reported an issue where system-provided tools, such as the Time tool, are no longer functional after upgrading to version 1.0.0. In this article, we will provide a Q&A section to address some of the common questions and concerns related to this issue.

A: The cause of the issue is related to the database table tool_installations. The application is unable to find the corresponding record for the Time tool, which is causing the system-provided tools to be unavailable.

A: To check the database table tool_installations, you can follow these steps:

  1. Connect to your database using a tool like pgAdmin or psql.
  2. Run the following query to check the contents of the tool_installations table:

SELECT * FROM tool_installations;

3.  Verify that the record for the Time tool is present in the table.

**Q: What if the record for the Time tool is missing?**
=====================================================

A: If the record for the Time tool is missing, you can try the following:

1.  Check if the plugin_id 'langgenius/time' is correctly configured.
2.  Check if the tenant_id '30f7868a-57a4-4857-b947-03d105e80f31' is correctly configured.
3.  If the issue persists, you may need to recreate the record for the Time tool in the tool_installations table.

**Q: How do I recreate the record for the Time tool?**
=====================================================

A: To recreate the record for the Time tool, you can follow these steps:

1.  Connect to your database using a tool like pgAdmin or psql.
2.  Run the following query to recreate the record for the Time tool:
    ```sql
INSERT INTO tool_installations (tenant_id, plugin_id, id)
VALUES ('30f7868a-57a4-4857-b947-03d105e80f31', 'langgenius/time', 1);
  1. Verify that the record for the Time tool is present in the table.

A: If you are still experiencing issues after trying the above steps, you may need to contact our support team for further assistance. We will be happy to help you troubleshoot the issue and provide a solution.

A: To prevent this issue in the future, you can follow these best practices:

  1. Regularly back up your database to prevent data loss.
  2. Verify that the plugin_id and tenant_id are correctly configured.
  3. Test your application thoroughly after upgrading to a new version.

In conclusion, we hope that this Q&A section has provided you with the information you need to troubleshoot and resolve the issue with system-provided tools like Time. If you have any further questions or concerns, please feel free to contact us.