Skip to content
Back
DatabasesWeb

Ive got 80k rows to import into appwrite, migrating from supabase

View on Discord

Votes

0

Replies

20

Participants

Unknown

Messages

21

marioOriginal post

Rank 1: Thread

How do I import? Using the migration tool built in doesnt work and I have no idea why really. is there a better way than looping through 80k records and just adding them to the table? I tried data-migrator by tannermeade and the flutter app fails to build. someone else has a similar issue and they opened the issue in september of 2023 and got no response.

D5

What error are you getting with the migration tool?

D5

I think it got some fixes for supabase migrations recently

mario

Rank 1: Thread

i dont really know how to check to be honest

mario

Rank 1: Thread

can you tell me how to?

mario

Rank 1: Thread

its been like 5 hours

mario

Rank 1: Thread

and indexes is still processing

mario

Rank 1: Thread

and in logs

mario

Rank 1: Thread

it just shows the number of errors and stuff

mario

Rank 1: Thread

i dont see any errors in the workers-migrations service

D5

What do you have in logs?

D5

Do you can send me your project ID?

mario

Rank 1: Thread

nothing particularly useful

JSON
{
  "$id": "66d518112de4830d38df",
  "$createdAt": "2024-09-02T01:42:41.188+00:00",
  "$updatedAt": "2024-09-02T04:00:03.415+00:00",
  "status": "processing",
  "stage": "migrating",
  "source": "Supabase",
  "resources": [
    "user",
    "database",
    "collection",
    "attribute",
    "index",
    "document"
  ],
  "statusCounters": {
    "user": {
      "pending": 365,
      "success": 0,
      "error": 100,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "database": {
      "pending": 0,
      "success": 0,
      "error": 1,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "collection": {
      "pending": 0,
      "success": 0,
      "error": 12,
      "skip": 0,
      "processing": 0,
      "warning": 1
    },
    "attribute": {
      "pending": 0,
      "success": 0,
      "error": 95,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "index": {
      "pending": 16,
      "success": 0,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "document": {
      "pending": 0,
      "success": 0,
      "error": 20240,
      "skip": 0,
      "processing": 0,
      "warning": 0
    }
  },
  "resourceData": [],
  "errors": []
}```
mario

Rank 1: Thread

sure one second

mario

Rank 1: Thread

66d4c3b5002c42091dab

mario

Rank 1: Thread

these are the logs from appwrite-worker-migrations

mario

Rank 1: Thread

nothing

mario

Rank 1: Thread

not sure if i set up logging though

mario

Rank 1: Thread

its self hosted btw

D5

You're self-hosting, right?

D5

What are the logs for the appwrite main container?

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join DiscordGet premium support