MySQL to PostgreSQL migration with pgloader causes "undefined table" error #1

Open
opened 6 months ago by taha · 11 comments
taha commented 6 months ago
Owner

I don't know if this is due to the mysql -> psql migration, or due to the v2.3.8 -> v2.4.2 upgrade. I'll have to repeat the setup and do more testing.

This is rather embarrassing. I should have tested to add articles...

Adding any article results in a Wallabag GUI error page:

500: Internal Server Error
An exception occurred while executing 'SELECT NEXTVAL('"entry_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "entry_id_seq" does not exist LINE 1: SELECT NEXTVAL('"entry_id_seq"') ^

Other stuff seems to work fine, e.g., tagging an article.

I don't know if this is due to the mysql -> psql migration, or due to the v2.3.8 -> v2.4.2 upgrade. I'll have to repeat the setup and do more testing. This is rather embarrassing. I should have tested to add articles... Adding any article results in a Wallabag GUI error page: ``` 500: Internal Server Error An exception occurred while executing 'SELECT NEXTVAL('"entry_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "entry_id_seq" does not exist LINE 1: SELECT NEXTVAL('"entry_id_seq"') ^ ``` Other stuff seems to work fine, e.g., tagging an article.
Poster
Owner
  • On fresh 2.3.8 created with this role, adding articles works.
  • On 2.3.8, after migrating my database from MySQL, adding articles no longer works (with the observed error message).

So the problem is the MySQL -> PSQL migration. That's unfortunate.

+ On fresh 2.3.8 created with this role, adding articles works. + On 2.3.8, *after* migrating my database from MySQL, adding articles no longer works (with the observed error message). So the problem is the MySQL -> PSQL migration. That's unfortunate.
Poster
Owner

Possibilities?
Either the pgloader script (that converts from MySQL to PGSQL) is not high-fidelity, or, perhaps this is because I'm migrating from Wallabag installed from source to Wallabag installed from precompiled tarball?

Let's eliminate the latter first, because it's easier to do.

Ok, precompiled or source install does not matter. Same exact error when installed from source.

The problem is in the mysql -> pgsql migration then.

Possibilities? Either the `pgloader` script (that converts from MySQL to PGSQL) is not high-fidelity, or, perhaps this is because I'm migrating from Wallabag installed from source to Wallabag installed from precompiled tarball? Let's eliminate the latter first, because it's easier to do. Ok, precompiled or source install does not matter. Same exact error when installed from source. The problem is in the mysql -> pgsql migration then.
taha changed title from Adding articles to v2.4.2 does not work to Can't add articles on instance migrated from MySQL to PostgreSQL 6 months ago
Poster
Owner

I have been using pgloader v3.6.1 until now. Let's try v3.6.2 (the latest version). Same error.

I have been using pgloader v3.6.1 until now. Let's try v3.6.2 (the latest version). **Same error**.
Poster
Owner

Tested a different database migration tool: NMIG.

Although the migration reported no errors, attempting to login to Wallabag produced the following error in the log:

Undefined column: 7 ERROR: column t0.authcode does not exist
LINE 1: ...AS created_at_14, t0.updated_at AS updated_at_15, t0.authCod...

The web-GUI briefly shows a popup message: Authentication request could not be processed due to a system problem but is otherwise unaffected.

Tested a different database migration tool: [NMIG](https://github.com/AnatolyUss/nmig). Although the migration reported no errors, attempting to login to Wallabag produced the following error in the log: ``` Undefined column: 7 ERROR: column t0.authcode does not exist LINE 1: ...AS created_at_14, t0.updated_at AS updated_at_15, t0.authCod... ``` The web-GUI briefly shows a popup message: `Authentication request could not be processed due to a system problem` but is otherwise unaffected.
taha changed title from Can't add articles on instance migrated from MySQL to PostgreSQL to MySQL to PostgreSQL migration with pgloader causes "undefined table" error 6 months ago
Poster
Owner

Perhaps I should make sure this is not due to something weird in my existing database.
That is, setup a fresh v2.3.8 Wallabag (from source) using MySQL, populate it with some articles, and then perform this migration to PostgreSQL again.

Perhaps I should make sure this is not due to something weird in my existing database. That is, setup a fresh v2.3.8 Wallabag (from source) using MySQL, populate it with some articles, and then **perform this migration to PostgreSQL again.**
Poster
Owner

mysql-backed instance is up and running on shanghai.

mysql-backed instance is up and running on `shanghai`.
Poster
Owner

Ok, so here's the verdict.

Instance 1 shanghai: Wallabag v2.3.8 from source, MySQL database, populated with my user and a few articles.
Instance 2 taipei: Wallabag v2.3.8 from source, PostgreSQL database with only default user and no content.

The playbook ran the migration successfully (commit 2717f9f).
Process was as follows:

  • first, create/configure the LXD containers using the luxor playbook: ansible-playbook playbook-host.yml --ask-become-pass --ask-vault-pass --tags "lxd-server",
  • second, provision the shanghai instance: ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit shanghai (at this point, set database_postgresql: false and import_sql_database: false),
  • third, provision the taipei instance and import the mysql database (at this point, set database_postgresql: true and import_sql_database: true).

(During this testing I have imported the mysql database from shanghai, and not my real wallabag database from armant).

The fact that error 500 still shows up when trying to add a new article strongly indicates a problem with the mysql -> pgsql migration, and not with something due to my live mysql database. The created PGSQL database appears to be missing some table that Wallabag expects. Is there perhaps some pgsql database repair command I should run after import?

The full error message (as shown in the browser):

500: Internal Server Error
An exception occurred while executing 'SELECT NEXTVAL('"entry_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "entry_id_seq" does not exist LINE 1: SELECT NEXTVAL('"entry_id_seq"') ^

A similar error is shown when attempting to tag any existing article:

500: Internal Server Error
An exception occurred while executing 'SELECT NEXTVAL('"tag_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "tag_id_seq" does not exist LINE 1: SELECT NEXTVAL('"tag_id_seq"') ^

Stuff that works:

  • deleting entries works without complaint.
  • it's also possible to star existing entries, or edit the title etc. of existing entries.
Ok, so here's the verdict. Instance 1 `shanghai`: Wallabag v2.3.8 from source, MySQL database, populated with my user and a few articles. Instance 2 `taipei`: Wallabag v2.3.8 from source, PostgreSQL database with only default user and no content. The playbook ran the migration successfully (commit 2717f9f). Process was as follows: + first, create/configure the LXD containers using the `luxor` playbook: `ansible-playbook playbook-host.yml --ask-become-pass --ask-vault-pass --tags "lxd-server"`, + second, provision the `shanghai` instance: `ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit shanghai` (at this point, set `database_postgresql: false` and `import_sql_database: false`), + third, provision the `taipei` instance and import the mysql database (at this point, set `database_postgresql: true` and `import_sql_database: true`). (During this testing I have imported the mysql database from `shanghai`, and not my real wallabag database from `armant`). The fact that error 500 still shows up when trying to add a new article strongly indicates a problem with the mysql -> pgsql migration, and not with something due to my live mysql database. The created PGSQL database appears to be missing some table that Wallabag expects. Is there perhaps some pgsql database repair command I should run after import? ![](https://nextcloud.chepec.se/s/BxkgFGjYYM4fwwR/download) The full error message (as shown in the browser): ``` 500: Internal Server Error An exception occurred while executing 'SELECT NEXTVAL('"entry_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "entry_id_seq" does not exist LINE 1: SELECT NEXTVAL('"entry_id_seq"') ^ ``` A similar error is shown when attempting to tag any existing article: ``` 500: Internal Server Error An exception occurred while executing 'SELECT NEXTVAL('"tag_id_seq"')': SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "tag_id_seq" does not exist LINE 1: SELECT NEXTVAL('"tag_id_seq"') ^ ``` Stuff that works: + deleting entries works without complaint. + it's also possible to star existing entries, or edit the title etc. of existing entries.
taha commented 3 days ago
Poster
Owner

Same as above, but now for Wallabag v2.4.2 (the latest release) and with more detailed notes.

taha@luxor:~
$ lxc stop shanghai taipei
$ lxc delete shanghai taipei

Now re-create the fresh LXD containers with the host playbook:

taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor
$ ansible-playbook playbook-host.yml --ask-become-pass --ask-vault-pass --tags "lxd-server"

Next, reset the following variables in this role's default.yml for shanghai:

wlbg_install_from_source: yes
wlbg_version: "latest"
database_postgresql: false
import_sql_database: false

and provision shanghai using the containers playbook:

taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor
$ ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit shanghai

Now login on Wallabag on shanghai (use the wallabag account to create a regular account) and populate the regular account with some articles (also create some public shares, add some tags, stars, etc.).
(Reset /etc/apache2/sites-enabled/wlbg.chepec.se.conf to the proper IP address if necessary).

Next, reset the variables for taipei:

wlbg_install_from_source: yes
wlbg_version: "latest"
database_postgresql: true
import_sql_database: true
import_from:
  host: shanghai
  identityfile: "{{ ansible_env.HOME }}/.ssh/luxor-lxd"
  tunnel_port: 3306
import_ssh_config: |
  Host {{ import_from.host }}
  Hostname 10.252.116.2
  PreferredAuthentications publickey
  IdentityFile {{ import_from.identityfile }}
  IdentitiesOnly yes
  StrictHostKeyChecking no
  User {{ ansible_env.USER }}

and provision taipei using the containers playbook:

taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor
$ ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit taipei

Note: I have performed this migration both with PostgreSQL v12.9 and PostgreSQL v14.1 (on the migration target, obviously) and observed the same behaviour (see bullet list below).

Now reset /etc/apache2/sites-enabled/wlbg.chepec.se.conf on luxor to point to taipei again, and login and test our migrated Wallabag instance.

  • tagging an article with a new tag fails
  • tagging an article with a pre-existing tag works
  • adding a new article fails
  • starring an existing article works, and so does unstarring
  • editing an article title works
  • marking an article as read works
  • deleting an article works
  • existing public links work

Same error messages as above.

So in short, mysql -> pgsql migration appears to not be affected at all by using Wallabag v2.4.2 instead of v2.3.8.

Same as [above](https://codeberg.org/ansible/wallabag/issues/1#issuecomment-274447), but now for Wallabag v2.4.2 (the latest release) and with more detailed notes. ``` taha@luxor:~ $ lxc stop shanghai taipei $ lxc delete shanghai taipei ``` Now re-create the fresh LXD containers with the `host` playbook: ``` taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor $ ansible-playbook playbook-host.yml --ask-become-pass --ask-vault-pass --tags "lxd-server" ``` Next, reset the following variables in this role's `default.yml` for `shanghai`: ``` wlbg_install_from_source: yes wlbg_version: "latest" database_postgresql: false import_sql_database: false ``` and provision `shanghai` using the `containers` playbook: ``` taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor $ ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit shanghai ``` Now login on Wallabag on `shanghai` (use the `wallabag` account to create a regular account) and populate the regular account with some articles (also create some public shares, add some tags, stars, etc.). (Reset `/etc/apache2/sites-enabled/wlbg.chepec.se.conf` to the proper IP address if necessary). Next, reset the variables for `taipei`: ``` wlbg_install_from_source: yes wlbg_version: "latest" database_postgresql: true import_sql_database: true import_from: host: shanghai identityfile: "{{ ansible_env.HOME }}/.ssh/luxor-lxd" tunnel_port: 3306 import_ssh_config: | Host {{ import_from.host }} Hostname 10.252.116.2 PreferredAuthentications publickey IdentityFile {{ import_from.identityfile }} IdentitiesOnly yes StrictHostKeyChecking no User {{ ansible_env.USER }} ``` and provision `taipei` using the `containers` playbook: ``` taha@asks2:/media/bay/taha/projects/ansible/playbooks/luxor $ ansible-playbook playbook-containers.yml --ask-become-pass --ask-vault-pass --limit taipei ``` > Note: I have performed this migration both with PostgreSQL `v12.9` and PostgreSQL `v14.1` (on the migration target, obviously) and observed the same behaviour (see bullet list below). Now reset `/etc/apache2/sites-enabled/wlbg.chepec.se.conf` on `luxor` to point to `taipei` again, and login and test our migrated Wallabag instance. + tagging an article with a new tag **fails** + tagging an article with a pre-existing tag works + adding a new article **fails** + starring an existing article works, and so does unstarring + editing an article title works + marking an article as read works + deleting an article works + existing public links work Same error messages as [above](https://codeberg.org/ansible/wallabag/issues/1#issuecomment-274447). **So in short, mysql -> pgsql migration appears to not be affected at all by using Wallabag v2.4.2 instead of v2.3.8.**
taha commented 3 days ago
Poster
Owner

For reference, here is the output from the pgloader command (no errors):

LOG pgloader version 3.6.2
LOG Migrating from #<MYSQL-CONNECTION mysql://wallabag@localhost:3306/wallabag>
LOG Migrating into #<PGSQL-CONNECTION pgsql://taha@UNIX:5432/wallabag>
LOG report summary reset
                                   table name     errors       rows      bytes      total time
---------------------------------------------  ---------  ---------  ---------  --------------
                              fetch meta data          0         84                     0.061s
                               Create Schemas          0          0                     0.001s
                             Create SQL Types          0          0                     0.005s
                                Create tables          0         32                     0.173s
                               Set Table OIDs          0         16                     0.013s
---------------------------------------------  ---------  ---------  ---------  --------------
                  wallabag.migration_versions          0         52     0.8 kB          0.059s
                 wallabag.wallabag_annotation          0          0                     0.013s
                      wallabag.wallabag_entry          0          5   196.4 kB          0.130s
                     wallabag.wallabag_config          0          2     0.1 kB          0.052s
                  wallabag.wallabag_entry_tag          0          5     0.0 kB          0.063s
wallabag.wallabag_ignore_origin_instance_rule          0          3     0.1 kB          0.049s
    wallabag.wallabag_ignore_origin_user_rule          0          0                     0.045s
           wallabag.wallabag_internal_setting          0         33     0.9 kB          0.046s
       wallabag.wallabag_oauth2_access_tokens          0          0                     0.045s
          wallabag.wallabag_oauth2_auth_codes          0          0                     0.044s
             wallabag.wallabag_oauth2_clients          0          0                     0.045s
      wallabag.wallabag_oauth2_refresh_tokens          0          0                     0.045s
                        wallabag.wallabag_tag          0          3     0.0 kB          0.051s
            wallabag.wallabag_site_credential          0          0                     0.050s
                       wallabag.wallabag_user          0          2     0.6 kB          0.027s
               wallabag.wallabag_tagging_rule          0          0                     0.012s
---------------------------------------------  ---------  ---------  ---------  --------------
                      COPY Threads Completion          0          4                     0.373s
                               Create Indexes          0         52                     0.500s
                       Index Build Completion          0         52                     0.037s
                              Reset Sequences          0         13                     0.037s
                                 Primary Keys          0         16                     0.009s
                          Create Foreign Keys          0         16                     0.016s
                              Create Triggers          0          0                     0.000s
                              Set Search Path          0          1                     0.001s
                             Install Comments          0          6                     0.001s
---------------------------------------------  ---------  ---------  ---------  --------------
                            Total import time          ✓        105   198.9 kB          0.974s
For reference, here is the output from the `pgloader` command (no errors): ``` LOG pgloader version 3.6.2 LOG Migrating from #<MYSQL-CONNECTION mysql://wallabag@localhost:3306/wallabag> LOG Migrating into #<PGSQL-CONNECTION pgsql://taha@UNIX:5432/wallabag> LOG report summary reset table name errors rows bytes total time --------------------------------------------- --------- --------- --------- -------------- fetch meta data 0 84 0.061s Create Schemas 0 0 0.001s Create SQL Types 0 0 0.005s Create tables 0 32 0.173s Set Table OIDs 0 16 0.013s --------------------------------------------- --------- --------- --------- -------------- wallabag.migration_versions 0 52 0.8 kB 0.059s wallabag.wallabag_annotation 0 0 0.013s wallabag.wallabag_entry 0 5 196.4 kB 0.130s wallabag.wallabag_config 0 2 0.1 kB 0.052s wallabag.wallabag_entry_tag 0 5 0.0 kB 0.063s wallabag.wallabag_ignore_origin_instance_rule 0 3 0.1 kB 0.049s wallabag.wallabag_ignore_origin_user_rule 0 0 0.045s wallabag.wallabag_internal_setting 0 33 0.9 kB 0.046s wallabag.wallabag_oauth2_access_tokens 0 0 0.045s wallabag.wallabag_oauth2_auth_codes 0 0 0.044s wallabag.wallabag_oauth2_clients 0 0 0.045s wallabag.wallabag_oauth2_refresh_tokens 0 0 0.045s wallabag.wallabag_tag 0 3 0.0 kB 0.051s wallabag.wallabag_site_credential 0 0 0.050s wallabag.wallabag_user 0 2 0.6 kB 0.027s wallabag.wallabag_tagging_rule 0 0 0.012s --------------------------------------------- --------- --------- --------- -------------- COPY Threads Completion 0 4 0.373s Create Indexes 0 52 0.500s Index Build Completion 0 52 0.037s Reset Sequences 0 13 0.037s Primary Keys 0 16 0.009s Create Foreign Keys 0 16 0.016s Create Triggers 0 0 0.000s Set Search Path 0 1 0.001s Install Comments 0 6 0.001s --------------------------------------------- --------- --------- --------- -------------- Total import time ✓ 105 198.9 kB 0.974s ```
taha commented 2 days ago
Poster
Owner

For reference, output of pgloader --verbose ...:

NOTICE Starting pgloader, log system is ready.
LOG pgloader version "3.6.2"
LOG Migrating from #<MYSQL-CONNECTION mysql://wallabag@localhost:3306/wallabag {10055718A3}>
LOG Migrating into #<PGSQL-CONNECTION pgsql://taha@UNIX:5432/wallabag {10056B95A3}>
NOTICE Prepare PostgreSQL database.
NOTICE COPY wallabag.migration_versions
NOTICE COPY wallabag.wallabag_annotation
NOTICE COPY wallabag.wallabag_config
NOTICE COPY wallabag.wallabag_entry
NOTICE COPY wallabag.wallabag_entry_tag
NOTICE COPY wallabag.wallabag_ignore_origin_instance_rule
NOTICE COPY wallabag.wallabag_ignore_origin_user_rule
NOTICE COPY wallabag.wallabag_internal_setting
NOTICE COPY wallabag.wallabag_oauth2_access_tokens
NOTICE COPY wallabag.wallabag_oauth2_auth_codes
NOTICE COPY wallabag.wallabag_oauth2_clients
NOTICE COPY wallabag.wallabag_oauth2_refresh_tokens
NOTICE COPY wallabag.wallabag_site_credential
NOTICE COPY wallabag.wallabag_tag
NOTICE COPY wallabag.wallabag_tagging_rule
NOTICE COPY wallabag.wallabag_user
NOTICE DONE copying wallabag.wallabag_annotation
NOTICE DONE copying wallabag.migration_versions
NOTICE CREATE INDEX idx_16394_idx_a7aed006a76ed395 ON wallabag.wallabag_annotation (user_id);
NOTICE CREATE INDEX idx_16394_idx_a7aed006ba364942 ON wallabag.wallabag_annotation (entry_id);
NOTICE CREATE UNIQUE INDEX idx_16394_primary ON wallabag.wallabag_annotation (id);
NOTICE DONE copying wallabag.wallabag_config
NOTICE CREATE UNIQUE INDEX idx_16389_primary ON wallabag.migration_versions (version);
NOTICE CREATE UNIQUE INDEX idx_16403_uniq_87e64c53a76ed395 ON wallabag.wallabag_config (user_id);
NOTICE CREATE INDEX idx_16403_config_feed_token ON wallabag.wallabag_config (feed_token);
NOTICE CREATE UNIQUE INDEX idx_16403_primary ON wallabag.wallabag_config (id);
NOTICE DONE copying wallabag.wallabag_entry_tag
NOTICE DONE copying wallabag.wallabag_entry
NOTICE CREATE INDEX idx_16425_idx_c9f0dd7cbad26311 ON wallabag.wallabag_entry_tag (tag_id);
NOTICE CREATE UNIQUE INDEX idx_16425_primary ON wallabag.wallabag_entry_tag (entry_id, tag_id);
NOTICE CREATE INDEX idx_16425_idx_c9f0dd7cba364942 ON wallabag.wallabag_entry_tag (entry_id);
NOTICE CREATE INDEX idx_16415_hashed_given_url_user_id ON wallabag.wallabag_entry (user_id, hashed_given_url);
NOTICE CREATE INDEX idx_16415_idx_entry_archived ON wallabag.wallabag_entry (is_archived);
NOTICE CREATE INDEX idx_16415_idx_f4d18282a76ed395 ON wallabag.wallabag_entry (user_id);
NOTICE CREATE INDEX idx_16415_idx_entry_uid ON wallabag.wallabag_entry (uid);
NOTICE CREATE INDEX idx_16415_idx_entry_created_at ON wallabag.wallabag_entry (created_at);
NOTICE CREATE INDEX idx_16415_idx_entry_starred ON wallabag.wallabag_entry (is_starred);
NOTICE CREATE INDEX idx_16415_hashed_url_user_id ON wallabag.wallabag_entry (user_id, hashed_url);
NOTICE CREATE INDEX idx_16415_user_archived ON wallabag.wallabag_entry (user_id, is_archived, archived_at);
NOTICE CREATE INDEX idx_16415_user_starred ON wallabag.wallabag_entry (user_id, is_starred, starred_at);
NOTICE CREATE INDEX idx_16415_user_language ON wallabag.wallabag_entry (language, user_id);
NOTICE DONE copying wallabag.wallabag_ignore_origin_instance_rule
NOTICE DONE copying wallabag.wallabag_ignore_origin_user_rule
NOTICE DONE copying wallabag.wallabag_internal_setting
NOTICE CREATE UNIQUE INDEX idx_16430_primary ON wallabag.wallabag_ignore_origin_instance_rule (id);
NOTICE CREATE INDEX idx_16415_user_created ON wallabag.wallabag_entry (user_id, created_at);
NOTICE DONE copying wallabag.wallabag_oauth2_access_tokens
NOTICE CREATE UNIQUE INDEX idx_16436_primary ON wallabag.wallabag_ignore_origin_user_rule (id);
NOTICE CREATE UNIQUE INDEX idx_16415_primary ON wallabag.wallabag_entry (id);
NOTICE CREATE INDEX idx_16436_idx_config ON wallabag.wallabag_ignore_origin_user_rule (config_id);
NOTICE CREATE UNIQUE INDEX idx_16440_uniq_5d9649505e237e06 ON wallabag.wallabag_internal_setting (name);
NOTICE CREATE INDEX idx_16450_idx_368a420919eb6921 ON wallabag.wallabag_oauth2_access_tokens (client_id);
NOTICE CREATE INDEX idx_16450_idx_368a4209a76ed395 ON wallabag.wallabag_oauth2_access_tokens (user_id);
NOTICE CREATE UNIQUE INDEX idx_16450_uniq_368a42095f37a13b ON wallabag.wallabag_oauth2_access_tokens (token);
NOTICE CREATE UNIQUE INDEX idx_16450_primary ON wallabag.wallabag_oauth2_access_tokens (id);
NOTICE CREATE UNIQUE INDEX idx_16440_primary ON wallabag.wallabag_internal_setting (name);
NOTICE DONE copying wallabag.wallabag_oauth2_clients
NOTICE DONE copying wallabag.wallabag_oauth2_auth_codes
NOTICE CREATE INDEX idx_16467_idx_635d765ea76ed395 ON wallabag.wallabag_oauth2_clients (user_id);
NOTICE DONE copying wallabag.wallabag_site_credential
NOTICE CREATE UNIQUE INDEX idx_16457_primary ON wallabag.wallabag_oauth2_auth_codes (id);
NOTICE CREATE INDEX idx_16457_idx_ee52e3fa19eb6921 ON wallabag.wallabag_oauth2_auth_codes (client_id);
NOTICE CREATE UNIQUE INDEX idx_16457_uniq_ee52e3fa5f37a13b ON wallabag.wallabag_oauth2_auth_codes (token);
NOTICE DONE copying wallabag.wallabag_oauth2_refresh_tokens
NOTICE CREATE INDEX idx_16457_idx_ee52e3faa76ed395 ON wallabag.wallabag_oauth2_auth_codes (user_id);
NOTICE CREATE UNIQUE INDEX idx_16467_primary ON wallabag.wallabag_oauth2_clients (id);
NOTICE CREATE UNIQUE INDEX idx_16483_primary ON wallabag.wallabag_site_credential (id);
NOTICE DONE copying wallabag.wallabag_tagging_rule
NOTICE CREATE INDEX idx_16476_idx_20c9fb2419eb6921 ON wallabag.wallabag_oauth2_refresh_tokens (client_id);
NOTICE CREATE INDEX idx_16483_idx_user ON wallabag.wallabag_site_credential (user_id);
NOTICE CREATE INDEX idx_16476_idx_20c9fb24a76ed395 ON wallabag.wallabag_oauth2_refresh_tokens (user_id);
NOTICE CREATE UNIQUE INDEX idx_16476_primary ON wallabag.wallabag_oauth2_refresh_tokens (id);
NOTICE CREATE UNIQUE INDEX idx_16476_uniq_20c9fb245f37a13b ON wallabag.wallabag_oauth2_refresh_tokens (token);
NOTICE DONE copying wallabag.wallabag_tag
NOTICE CREATE UNIQUE INDEX idx_16502_primary ON wallabag.wallabag_tagging_rule (id);
NOTICE CREATE INDEX idx_16502_idx_2d9b3c5424db0683 ON wallabag.wallabag_tagging_rule (config_id);
NOTICE CREATE UNIQUE INDEX idx_16492_primary ON wallabag.wallabag_tag (id);
NOTICE CREATE UNIQUE INDEX idx_16492_uniq_4ca58a8c989d9b62 ON wallabag.wallabag_tag (slug);
NOTICE CREATE INDEX idx_16492_tag_label ON wallabag.wallabag_tag (label);
NOTICE DONE copying wallabag.wallabag_user
NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e5c05fb297 ON wallabag.wallabag_user (confirmation_token);
NOTICE CREATE UNIQUE INDEX idx_16511_primary ON wallabag.wallabag_user (id);
NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e5a0d96fbf ON wallabag.wallabag_user (email_canonical);
NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e592fc23a8 ON wallabag.wallabag_user (username_canonical);
NOTICE Completing PostgreSQL database.
NOTICE Reset sequences
NOTICE ALTER TABLE wallabag.wallabag_annotation ADD PRIMARY KEY USING INDEX idx_16394_primary;
NOTICE ALTER TABLE wallabag.migration_versions ADD PRIMARY KEY USING INDEX idx_16389_primary;
NOTICE ALTER TABLE wallabag.wallabag_config ADD PRIMARY KEY USING INDEX idx_16403_primary;
NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD PRIMARY KEY USING INDEX idx_16425_primary;
NOTICE ALTER TABLE wallabag.wallabag_entry ADD PRIMARY KEY USING INDEX idx_16415_primary;
NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_instance_rule ADD PRIMARY KEY USING INDEX idx_16430_primary;
NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_user_rule ADD PRIMARY KEY USING INDEX idx_16436_primary;
NOTICE ALTER TABLE wallabag.wallabag_internal_setting ADD PRIMARY KEY USING INDEX idx_16440_primary;
NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD PRIMARY KEY USING INDEX idx_16450_primary;
NOTICE ALTER TABLE wallabag.wallabag_oauth2_clients ADD PRIMARY KEY USING INDEX idx_16467_primary;
NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD PRIMARY KEY USING INDEX idx_16457_primary;
NOTICE ALTER TABLE wallabag.wallabag_site_credential ADD PRIMARY KEY USING INDEX idx_16483_primary;
NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD PRIMARY KEY USING INDEX idx_16476_primary;
NOTICE ALTER TABLE wallabag.wallabag_tagging_rule ADD PRIMARY KEY USING INDEX idx_16502_primary;
NOTICE ALTER TABLE wallabag.wallabag_tag ADD PRIMARY KEY USING INDEX idx_16492_primary;
NOTICE ALTER TABLE wallabag.wallabag_user ADD PRIMARY KEY USING INDEX idx_16511_primary;
NOTICE ALTER TABLE wallabag.wallabag_annotation ADD CONSTRAINT fk_a7aed006a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_annotation ADD CONSTRAINT fk_annotation_entry FOREIGN KEY(entry_id) REFERENCES wallabag.wallabag_entry(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_config ADD CONSTRAINT fk_87e64c53a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_entry ADD CONSTRAINT fk_f4d18282a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD CONSTRAINT fk_entry_tag_entry FOREIGN KEY(entry_id) REFERENCES wallabag.wallabag_entry(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD CONSTRAINT fk_entry_tag_tag FOREIGN KEY(tag_id) REFERENCES wallabag.wallabag_tag(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_user_rule ADD CONSTRAINT fk_config FOREIGN KEY(config_id) REFERENCES wallabag.wallabag_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD CONSTRAINT fk_368a420919eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD CONSTRAINT fk_368a4209a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD CONSTRAINT fk_ee52e3fa19eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD CONSTRAINT fk_ee52e3faa76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_oauth2_clients ADD CONSTRAINT fk_635d765ea76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD CONSTRAINT fk_20c9fb2419eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD CONSTRAINT fk_20c9fb24a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE
NOTICE ALTER TABLE wallabag.wallabag_site_credential ADD CONSTRAINT fk_user FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER TABLE wallabag.wallabag_tagging_rule ADD CONSTRAINT fk_2d9b3c5424db0683 FOREIGN KEY(config_id) REFERENCES wallabag.wallabag_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
NOTICE ALTER DATABASE "wallabag" SET search_path TO public, wallabag;
LOG report summary reset
                                   table name     errors       read   imported      bytes      total time       read      write
---------------------------------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
                              fetch meta data          0         84         84                     0.059s    
                               Create Schemas          0          0          0                     0.001s    
                             Create SQL Types          0          0          0                     0.004s    
                                Create tables          0         32         32                     0.094s    
                               Set Table OIDs          0         16         16                     0.017s    
---------------------------------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
                  wallabag.migration_versions          0         52         52     0.8 kB          0.016s     0.014s     0.001s
                 wallabag.wallabag_annotation          0          0          0                     0.013s     0.012s  
                      wallabag.wallabag_entry          0          5          5   196.4 kB          0.027s     0.007s     0.007s
                     wallabag.wallabag_config          0          2          2     0.1 kB          0.005s     0.003s  
                  wallabag.wallabag_entry_tag          0          5          5     0.0 kB          0.021s     0.005s  
wallabag.wallabag_ignore_origin_instance_rule          0          3          3     0.1 kB          0.040s     0.003s  
    wallabag.wallabag_ignore_origin_user_rule          0          0          0                     0.048s     0.048s  
           wallabag.wallabag_internal_setting          0         33         33     0.9 kB          0.052s     0.048s  
       wallabag.wallabag_oauth2_access_tokens          0          0          0                     0.006s     0.001s  
          wallabag.wallabag_oauth2_auth_codes          0          0          0                     0.048s     0.048s  
             wallabag.wallabag_oauth2_clients          0          0          0                     0.048s     0.048s  
            wallabag.wallabag_site_credential          0          0          0                     0.004s     0.001s  
      wallabag.wallabag_oauth2_refresh_tokens          0          0          0                     0.007s     0.001s  
               wallabag.wallabag_tagging_rule          0          0          0                     0.009s     0.002s  
                        wallabag.wallabag_tag          0          3          3     0.0 kB          0.014s     0.003s  
                       wallabag.wallabag_user          0          2          2     0.6 kB          0.047s     0.044s  
---------------------------------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
                      COPY Threads Completion          0          4          4                     0.169s    
                               Create Indexes          0         52         52                     0.405s    
                       Index Build Completion          0         52         52                     0.025s    
                              Reset Sequences          0         13         13                     0.015s    
                                 Primary Keys          0         16         16                     0.006s    
                          Create Foreign Keys          0         16         16                     0.013s    
                              Create Triggers          0          0          0                     0.000s    
                              Set Search Path          0          1          1                     0.000s    
                             Install Comments          0          6          6                     0.002s    
---------------------------------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
                            Total import time          ✓        105        105   198.9 kB          0.635s
For reference, output of `pgloader --verbose ...`: ``` NOTICE Starting pgloader, log system is ready. LOG pgloader version "3.6.2" LOG Migrating from #<MYSQL-CONNECTION mysql://wallabag@localhost:3306/wallabag {10055718A3}> LOG Migrating into #<PGSQL-CONNECTION pgsql://taha@UNIX:5432/wallabag {10056B95A3}> NOTICE Prepare PostgreSQL database. NOTICE COPY wallabag.migration_versions NOTICE COPY wallabag.wallabag_annotation NOTICE COPY wallabag.wallabag_config NOTICE COPY wallabag.wallabag_entry NOTICE COPY wallabag.wallabag_entry_tag NOTICE COPY wallabag.wallabag_ignore_origin_instance_rule NOTICE COPY wallabag.wallabag_ignore_origin_user_rule NOTICE COPY wallabag.wallabag_internal_setting NOTICE COPY wallabag.wallabag_oauth2_access_tokens NOTICE COPY wallabag.wallabag_oauth2_auth_codes NOTICE COPY wallabag.wallabag_oauth2_clients NOTICE COPY wallabag.wallabag_oauth2_refresh_tokens NOTICE COPY wallabag.wallabag_site_credential NOTICE COPY wallabag.wallabag_tag NOTICE COPY wallabag.wallabag_tagging_rule NOTICE COPY wallabag.wallabag_user NOTICE DONE copying wallabag.wallabag_annotation NOTICE DONE copying wallabag.migration_versions NOTICE CREATE INDEX idx_16394_idx_a7aed006a76ed395 ON wallabag.wallabag_annotation (user_id); NOTICE CREATE INDEX idx_16394_idx_a7aed006ba364942 ON wallabag.wallabag_annotation (entry_id); NOTICE CREATE UNIQUE INDEX idx_16394_primary ON wallabag.wallabag_annotation (id); NOTICE DONE copying wallabag.wallabag_config NOTICE CREATE UNIQUE INDEX idx_16389_primary ON wallabag.migration_versions (version); NOTICE CREATE UNIQUE INDEX idx_16403_uniq_87e64c53a76ed395 ON wallabag.wallabag_config (user_id); NOTICE CREATE INDEX idx_16403_config_feed_token ON wallabag.wallabag_config (feed_token); NOTICE CREATE UNIQUE INDEX idx_16403_primary ON wallabag.wallabag_config (id); NOTICE DONE copying wallabag.wallabag_entry_tag NOTICE DONE copying wallabag.wallabag_entry NOTICE CREATE INDEX idx_16425_idx_c9f0dd7cbad26311 ON wallabag.wallabag_entry_tag (tag_id); NOTICE CREATE UNIQUE INDEX idx_16425_primary ON wallabag.wallabag_entry_tag (entry_id, tag_id); NOTICE CREATE INDEX idx_16425_idx_c9f0dd7cba364942 ON wallabag.wallabag_entry_tag (entry_id); NOTICE CREATE INDEX idx_16415_hashed_given_url_user_id ON wallabag.wallabag_entry (user_id, hashed_given_url); NOTICE CREATE INDEX idx_16415_idx_entry_archived ON wallabag.wallabag_entry (is_archived); NOTICE CREATE INDEX idx_16415_idx_f4d18282a76ed395 ON wallabag.wallabag_entry (user_id); NOTICE CREATE INDEX idx_16415_idx_entry_uid ON wallabag.wallabag_entry (uid); NOTICE CREATE INDEX idx_16415_idx_entry_created_at ON wallabag.wallabag_entry (created_at); NOTICE CREATE INDEX idx_16415_idx_entry_starred ON wallabag.wallabag_entry (is_starred); NOTICE CREATE INDEX idx_16415_hashed_url_user_id ON wallabag.wallabag_entry (user_id, hashed_url); NOTICE CREATE INDEX idx_16415_user_archived ON wallabag.wallabag_entry (user_id, is_archived, archived_at); NOTICE CREATE INDEX idx_16415_user_starred ON wallabag.wallabag_entry (user_id, is_starred, starred_at); NOTICE CREATE INDEX idx_16415_user_language ON wallabag.wallabag_entry (language, user_id); NOTICE DONE copying wallabag.wallabag_ignore_origin_instance_rule NOTICE DONE copying wallabag.wallabag_ignore_origin_user_rule NOTICE DONE copying wallabag.wallabag_internal_setting NOTICE CREATE UNIQUE INDEX idx_16430_primary ON wallabag.wallabag_ignore_origin_instance_rule (id); NOTICE CREATE INDEX idx_16415_user_created ON wallabag.wallabag_entry (user_id, created_at); NOTICE DONE copying wallabag.wallabag_oauth2_access_tokens NOTICE CREATE UNIQUE INDEX idx_16436_primary ON wallabag.wallabag_ignore_origin_user_rule (id); NOTICE CREATE UNIQUE INDEX idx_16415_primary ON wallabag.wallabag_entry (id); NOTICE CREATE INDEX idx_16436_idx_config ON wallabag.wallabag_ignore_origin_user_rule (config_id); NOTICE CREATE UNIQUE INDEX idx_16440_uniq_5d9649505e237e06 ON wallabag.wallabag_internal_setting (name); NOTICE CREATE INDEX idx_16450_idx_368a420919eb6921 ON wallabag.wallabag_oauth2_access_tokens (client_id); NOTICE CREATE INDEX idx_16450_idx_368a4209a76ed395 ON wallabag.wallabag_oauth2_access_tokens (user_id); NOTICE CREATE UNIQUE INDEX idx_16450_uniq_368a42095f37a13b ON wallabag.wallabag_oauth2_access_tokens (token); NOTICE CREATE UNIQUE INDEX idx_16450_primary ON wallabag.wallabag_oauth2_access_tokens (id); NOTICE CREATE UNIQUE INDEX idx_16440_primary ON wallabag.wallabag_internal_setting (name); NOTICE DONE copying wallabag.wallabag_oauth2_clients NOTICE DONE copying wallabag.wallabag_oauth2_auth_codes NOTICE CREATE INDEX idx_16467_idx_635d765ea76ed395 ON wallabag.wallabag_oauth2_clients (user_id); NOTICE DONE copying wallabag.wallabag_site_credential NOTICE CREATE UNIQUE INDEX idx_16457_primary ON wallabag.wallabag_oauth2_auth_codes (id); NOTICE CREATE INDEX idx_16457_idx_ee52e3fa19eb6921 ON wallabag.wallabag_oauth2_auth_codes (client_id); NOTICE CREATE UNIQUE INDEX idx_16457_uniq_ee52e3fa5f37a13b ON wallabag.wallabag_oauth2_auth_codes (token); NOTICE DONE copying wallabag.wallabag_oauth2_refresh_tokens NOTICE CREATE INDEX idx_16457_idx_ee52e3faa76ed395 ON wallabag.wallabag_oauth2_auth_codes (user_id); NOTICE CREATE UNIQUE INDEX idx_16467_primary ON wallabag.wallabag_oauth2_clients (id); NOTICE CREATE UNIQUE INDEX idx_16483_primary ON wallabag.wallabag_site_credential (id); NOTICE DONE copying wallabag.wallabag_tagging_rule NOTICE CREATE INDEX idx_16476_idx_20c9fb2419eb6921 ON wallabag.wallabag_oauth2_refresh_tokens (client_id); NOTICE CREATE INDEX idx_16483_idx_user ON wallabag.wallabag_site_credential (user_id); NOTICE CREATE INDEX idx_16476_idx_20c9fb24a76ed395 ON wallabag.wallabag_oauth2_refresh_tokens (user_id); NOTICE CREATE UNIQUE INDEX idx_16476_primary ON wallabag.wallabag_oauth2_refresh_tokens (id); NOTICE CREATE UNIQUE INDEX idx_16476_uniq_20c9fb245f37a13b ON wallabag.wallabag_oauth2_refresh_tokens (token); NOTICE DONE copying wallabag.wallabag_tag NOTICE CREATE UNIQUE INDEX idx_16502_primary ON wallabag.wallabag_tagging_rule (id); NOTICE CREATE INDEX idx_16502_idx_2d9b3c5424db0683 ON wallabag.wallabag_tagging_rule (config_id); NOTICE CREATE UNIQUE INDEX idx_16492_primary ON wallabag.wallabag_tag (id); NOTICE CREATE UNIQUE INDEX idx_16492_uniq_4ca58a8c989d9b62 ON wallabag.wallabag_tag (slug); NOTICE CREATE INDEX idx_16492_tag_label ON wallabag.wallabag_tag (label); NOTICE DONE copying wallabag.wallabag_user NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e5c05fb297 ON wallabag.wallabag_user (confirmation_token); NOTICE CREATE UNIQUE INDEX idx_16511_primary ON wallabag.wallabag_user (id); NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e5a0d96fbf ON wallabag.wallabag_user (email_canonical); NOTICE CREATE UNIQUE INDEX idx_16511_uniq_1d63e7e592fc23a8 ON wallabag.wallabag_user (username_canonical); NOTICE Completing PostgreSQL database. NOTICE Reset sequences NOTICE ALTER TABLE wallabag.wallabag_annotation ADD PRIMARY KEY USING INDEX idx_16394_primary; NOTICE ALTER TABLE wallabag.migration_versions ADD PRIMARY KEY USING INDEX idx_16389_primary; NOTICE ALTER TABLE wallabag.wallabag_config ADD PRIMARY KEY USING INDEX idx_16403_primary; NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD PRIMARY KEY USING INDEX idx_16425_primary; NOTICE ALTER TABLE wallabag.wallabag_entry ADD PRIMARY KEY USING INDEX idx_16415_primary; NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_instance_rule ADD PRIMARY KEY USING INDEX idx_16430_primary; NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_user_rule ADD PRIMARY KEY USING INDEX idx_16436_primary; NOTICE ALTER TABLE wallabag.wallabag_internal_setting ADD PRIMARY KEY USING INDEX idx_16440_primary; NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD PRIMARY KEY USING INDEX idx_16450_primary; NOTICE ALTER TABLE wallabag.wallabag_oauth2_clients ADD PRIMARY KEY USING INDEX idx_16467_primary; NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD PRIMARY KEY USING INDEX idx_16457_primary; NOTICE ALTER TABLE wallabag.wallabag_site_credential ADD PRIMARY KEY USING INDEX idx_16483_primary; NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD PRIMARY KEY USING INDEX idx_16476_primary; NOTICE ALTER TABLE wallabag.wallabag_tagging_rule ADD PRIMARY KEY USING INDEX idx_16502_primary; NOTICE ALTER TABLE wallabag.wallabag_tag ADD PRIMARY KEY USING INDEX idx_16492_primary; NOTICE ALTER TABLE wallabag.wallabag_user ADD PRIMARY KEY USING INDEX idx_16511_primary; NOTICE ALTER TABLE wallabag.wallabag_annotation ADD CONSTRAINT fk_a7aed006a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_annotation ADD CONSTRAINT fk_annotation_entry FOREIGN KEY(entry_id) REFERENCES wallabag.wallabag_entry(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_config ADD CONSTRAINT fk_87e64c53a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_entry ADD CONSTRAINT fk_f4d18282a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD CONSTRAINT fk_entry_tag_entry FOREIGN KEY(entry_id) REFERENCES wallabag.wallabag_entry(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_entry_tag ADD CONSTRAINT fk_entry_tag_tag FOREIGN KEY(tag_id) REFERENCES wallabag.wallabag_tag(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_ignore_origin_user_rule ADD CONSTRAINT fk_config FOREIGN KEY(config_id) REFERENCES wallabag.wallabag_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD CONSTRAINT fk_368a420919eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_oauth2_access_tokens ADD CONSTRAINT fk_368a4209a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD CONSTRAINT fk_ee52e3fa19eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_oauth2_auth_codes ADD CONSTRAINT fk_ee52e3faa76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_oauth2_clients ADD CONSTRAINT fk_635d765ea76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD CONSTRAINT fk_20c9fb2419eb6921 FOREIGN KEY(client_id) REFERENCES wallabag.wallabag_oauth2_clients(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_oauth2_refresh_tokens ADD CONSTRAINT fk_20c9fb24a76ed395 FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE CASCADE NOTICE ALTER TABLE wallabag.wallabag_site_credential ADD CONSTRAINT fk_user FOREIGN KEY(user_id) REFERENCES wallabag.wallabag_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER TABLE wallabag.wallabag_tagging_rule ADD CONSTRAINT fk_2d9b3c5424db0683 FOREIGN KEY(config_id) REFERENCES wallabag.wallabag_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT NOTICE ALTER DATABASE "wallabag" SET search_path TO public, wallabag; LOG report summary reset table name errors read imported bytes total time read write --------------------------------------------- --------- --------- --------- --------- -------------- --------- --------- fetch meta data 0 84 84 0.059s Create Schemas 0 0 0 0.001s Create SQL Types 0 0 0 0.004s Create tables 0 32 32 0.094s Set Table OIDs 0 16 16 0.017s --------------------------------------------- --------- --------- --------- --------- -------------- --------- --------- wallabag.migration_versions 0 52 52 0.8 kB 0.016s 0.014s 0.001s wallabag.wallabag_annotation 0 0 0 0.013s 0.012s wallabag.wallabag_entry 0 5 5 196.4 kB 0.027s 0.007s 0.007s wallabag.wallabag_config 0 2 2 0.1 kB 0.005s 0.003s wallabag.wallabag_entry_tag 0 5 5 0.0 kB 0.021s 0.005s wallabag.wallabag_ignore_origin_instance_rule 0 3 3 0.1 kB 0.040s 0.003s wallabag.wallabag_ignore_origin_user_rule 0 0 0 0.048s 0.048s wallabag.wallabag_internal_setting 0 33 33 0.9 kB 0.052s 0.048s wallabag.wallabag_oauth2_access_tokens 0 0 0 0.006s 0.001s wallabag.wallabag_oauth2_auth_codes 0 0 0 0.048s 0.048s wallabag.wallabag_oauth2_clients 0 0 0 0.048s 0.048s wallabag.wallabag_site_credential 0 0 0 0.004s 0.001s wallabag.wallabag_oauth2_refresh_tokens 0 0 0 0.007s 0.001s wallabag.wallabag_tagging_rule 0 0 0 0.009s 0.002s wallabag.wallabag_tag 0 3 3 0.0 kB 0.014s 0.003s wallabag.wallabag_user 0 2 2 0.6 kB 0.047s 0.044s --------------------------------------------- --------- --------- --------- --------- -------------- --------- --------- COPY Threads Completion 0 4 4 0.169s Create Indexes 0 52 52 0.405s Index Build Completion 0 52 52 0.025s Reset Sequences 0 13 13 0.015s Primary Keys 0 16 16 0.006s Create Foreign Keys 0 16 16 0.013s Create Triggers 0 0 0 0.000s Set Search Path 0 1 1 0.000s Install Comments 0 6 6 0.002s --------------------------------------------- --------- --------- --------- --------- -------------- --------- --------- Total import time ✓ 105 105 198.9 kB 0.635s ```
taha commented 2 days ago
Poster
Owner

Let's use the Sequeler app to inspect our MySQL and PostgreSQL databases.

In Sequeler, we can inspect each table via three views: Structure, Content and Relations. It looks to my unfamiliar eyes that structure and content are equivalent across the mysql and pgsql databases, but any relations seem to be completely missing in the pgsql database.

relations missing in pgsql
In this screenshot, the MySQL database is up top, and the PostgreSQL on the bottom. I wonder if the empty Relations view in pgsql is indicative of the problem?

Let's use the [Sequeler app](https://github.com/Alecaddd/sequeler) to inspect our MySQL and PostgreSQL databases. In Sequeler, we can inspect each table via three views: `Structure`, `Content` and `Relations`. It looks to my unfamiliar eyes that structure and content are equivalent across the mysql and pgsql databases, but any relations seem to be completely missing in the pgsql database. + https://github.com/dimitri/pgloader/issues/309 + https://github.com/dimitri/pgloader/issues/713 ![relations missing in pgsql](https://nextcloud.chepec.se/s/Jkw6LCHW7FBzQdi/download) In this screenshot, the MySQL database is up top, and the PostgreSQL on the bottom. I wonder if the empty `Relations` view in pgsql is indicative of the problem?
Sign in to join this conversation.
No Label
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
There is no content yet.