migrations are running, but two _sqlx_migrations tables are being created, and sqlx migrate run doesn't recognize migration as having previously run

[emptydiagram]

I cannot figure out what I'm doing wrong, any help would be appreciated. I have a postgres instance. I create a user and a database via psql:

postgres=# create user myapp with password 'myapp';
CREATE ROLE
postgres=# create database myapp;
CREATE DATABASE
postgres=# grant all privileges on database myapp to myapp;
GRANT

in a different terminal window, I have configured my DATABASE_URL env variable correctly I think:

$ echo $DATABASE_URL;
postgres://myapp:myapp@localhost:5432/myapp

I have two migrations already created in the migrations/ folder. I run sqlx migrate run:

$ sqlx migrate run
Applied 20250513173752/migrate create post tables (245.42377ms)
Applied 20250514150409/migrate create ingest state table (78.169631ms)

All seems well so far! I can verify the tables were created! But when i check the information, the migrations still show pending:

$ sqlx migrate info
20250513173752/pending create post tables
20250514150409/pending create ingest state table

I also see that there are two _sqlx_migrations tables: one under the public schema, and one under the myapp schema. The public one has the migration information, the myapp one is empty:

myapp=> select * from public._sqlx_migrations;
    version     |        description        |         installed_on          | success |                                              checksum                                              | execution_time 
----------------+---------------------------+-------------------------------+---------+----------------------------------------------------------------------------------------------------+----------------
 20250513173752 | create post tables        | 2025-05-14 11:04:11.497875-05 | t       | \xa70152f72a66a49b7c118a457eb197ae1897233e9a684d8112682fc5b09ea4db7cd2b42f14a8ef062d95206b5c697c58 |      245423770
 20250514150409 | create ingest state table | 2025-05-14 11:04:11.75164-05  | t       | \xff623296df4c8c8f63c3b55b59e962fd1fce0f75cb83e37009d7037f91b75044b809bb824e25aedc8508bba3a42aacd3 |       78169631
(2 rows)

myapp=> select * from myapp._sqlx_migrations;
 version | description | installed_on | success | checksum | execution_time 
---------+-------------+--------------+---------+----------+----------------
(0 rows)

Also, when i run migrate run again it tries to re-run the migrations and throws an error:

$ sqlx migrate run
error: while executing migration 20250513173752: error returned from database: relation "posts" already exists

Why is this happening? What am I doing wrong? I have already tried a cargo clean and dropping the myapp database / schema / user.