Self HostedFlutterDatabases

500Internal Error

Dec 27, 2023, 20:37

View on Discord

Votes

Replies

Participants

Unknown

Messages

SabitOriginal post

Rank 2: Process

Jun 27, 2023, 15:11

I can't access one database. Another collection that is inside this automaton database has been deleted. How to delete this database. I have already created another database. Now I can’t delete the old one, it says 500
Internal Error

Summary

The user is experiencing a 500 Internal Error while trying to delete a non-working database without using the console. They have provided some potential solutions: - Use the server-side API to delete the database. - Login directly to the Appwrite MariaDB and delete the database there. The user also mentions that the collection ID doesn't exist and asks for help with the docker logs. It is mentioned that the user is on Ubuntu and using Docker version 1.3.7. The container logs show an error related to an active transaction. Another user confirms they are getting the same error. The thread ends with the original user still unable to delete

Felipe Amaral

Rank 2: Process

Jun 27, 2023, 15:20

Im getting the same error!

Felipe Amaral

Rank 2: Process

Jun 27, 2023, 15:21

Containers logs

appwrite-realtime             | Connection close: 81
appwrite                      | [Error] Timestamp: 2023-06-27T15:21:19+00:00
appwrite                      | [Error] Method: POST
appwrite                      | [Error] URL: /v1/databases/:databaseId/collections
appwrite                      | [Error] Type: PDOException
appwrite                      | [Error] Message: There is already an active transaction
appwrite                      | [Error] File: @swoole-src/library/core/Database/PDOProxy.php
appwrite                      | [Error] Line: 43
appwrite-realtime             | Connection open (user: 82)
appwrite-usage                | [27-06-2023 15:21:21] Aggregating Timeseries Usage data every 30 seconds

Felipe Amaral

Rank 2: Process

Jun 27, 2023, 15:22

Appwrite Version: 1.3.7

Felipe Amaral

Rank 2: Process

Jun 27, 2023, 15:24

A few moments later the collection appears.

Drake

Jun 27, 2023, 18:50

Please create a separate #channel post rather than posting in an existing one

Drake

Jun 27, 2023, 18:50

Are you on cloud?

Sabit

Rank 2: Process

Jun 27, 2023, 19:00

I installed on ubuntu via docker. Version 1.3.7

Drake

Jun 27, 2023, 19:01

What do the docker logs say for the appwrite container?

Sabit

Rank 2: Process

Jun 27, 2023, 19:08

even look terrible

Drake

Jun 27, 2023, 23:23

According to this, the collection id doesn't exist 🧐

Sabit

Rank 2: Process

Jun 28, 2023, 04:03

Hello again! How can now delete this non-working database without the console?

Binyamin

Jun 28, 2023, 13:21

You can

Use server side API https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesDelete
You can login directly to Appwrite MariaDB, check this: https://gist.github.com/byawitz/885510a4d9789e97424337e9472276d7

500Internal Error

Need support?_