{"action":"created","issue":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/602","repository_url":"https://api.github.com/repos/dimitri/pgloader","labels_url":"https://api.github.com/repos/dimitri/pgloader/issues/602/labels{/name}","comments_url":"https://api.github.com/repos/dimitri/pgloader/issues/602/comments","events_url":"https://api.github.com/repos/dimitri/pgloader/issues/602/events","html_url":"https://github.com/dimitri/pgloader/issues/602","id":247528001,"number":602,"title":"pgloader gets killed, no errors issued","user":{"login":"yoxel","id":1057059,"avatar_url":"https://avatars3.githubusercontent.com/u/1057059?v=4","gravatar_id":"","url":"https://api.github.com/users/yoxel","html_url":"https://github.com/yoxel","followers_url":"https://api.github.com/users/yoxel/followers","following_url":"https://api.github.com/users/yoxel/following{/other_user}","gists_url":"https://api.github.com/users/yoxel/gists{/gist_id}","starred_url":"https://api.github.com/users/yoxel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoxel/subscriptions","organizations_url":"https://api.github.com/users/yoxel/orgs","repos_url":"https://api.github.com/users/yoxel/repos","events_url":"https://api.github.com/users/yoxel/events{/privacy}","received_events_url":"https://api.github.com/users/yoxel/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":46,"created_at":"2017-08-02T21:28:35Z","updated_at":"2018-04-06T22:03:10Z","closed_at":"2017-08-14T15:18:01Z","author_association":"NONE","body":"I am migrating a MySQL database to Postgres:\r\n\r\n```\r\npgloader -v --debug --on-error-stop pgloader.dsl\r\n```\r\n\r\npgloaded simply stops running with:\r\n\r\n```\r\nzsh: killed     pgloader -v --debug --on-error-stop pgloader.dsl\r\n```\r\n\r\nThe last debug messages are:\r\n\r\n```\r\n2017-08-02T20:43:16.313000+03:00 DATA < #(\"20870\" \"26\" NIL \"...\" NIL NIL \"51\" \"00160000018YQhzAAG\"\r\n    NIL NIL NIL \"0\")\r\n2017-08-02T20:43:16.313000+03:00 DATA < #(\"20871\" \"26\" NIL \"...\" NIL NIL \"51\"\r\n    \"00132000019U4DUAA0\" NIL NIL NIL \"0\")\r\n2017-08-02T20:43:16.313000+03:00 DATA < #(\"20872\" \"26\" NIL \"...\" NIL NIL \"51\" \"00132000019U4DeAAK\"\r\n    NIL NIL NIL \"0\")\r\n```\r\n\r\nAny ideas what may be going wrong?\r\n\r\nA small/test database migration went fine. This is one is a larger production database.\r\n"},"comment":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/comments/379397115","html_url":"https://github.com/dimitri/pgloader/issues/602#issuecomment-379397115","issue_url":"https://api.github.com/repos/dimitri/pgloader/issues/602","id":379397115,"user":{"login":"revolunet","id":124937,"avatar_url":"https://avatars0.githubusercontent.com/u/124937?v=4","gravatar_id":"","url":"https://api.github.com/users/revolunet","html_url":"https://github.com/revolunet","followers_url":"https://api.github.com/users/revolunet/followers","following_url":"https://api.github.com/users/revolunet/following{/other_user}","gists_url":"https://api.github.com/users/revolunet/gists{/gist_id}","starred_url":"https://api.github.com/users/revolunet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolunet/subscriptions","organizations_url":"https://api.github.com/users/revolunet/orgs","repos_url":"https://api.github.com/users/revolunet/repos","events_url":"https://api.github.com/users/revolunet/events{/privacy}","received_events_url":"https://api.github.com/users/revolunet/received_events","type":"User","site_admin":false},"created_at":"2018-04-06T22:03:10Z","updated_at":"2018-04-06T22:03:10Z","author_association":"NONE","body":"Hi, \r\n\r\nI'm getting the silents crashs with the docker images on OSX\r\n\r\nTried with pgloader brew version with the same DB, it works longer, but then i get another issue :\r\n\r\n```\r\n2018-04-06T16:23:03.301000+01:00 NOTICE CREATE INDEX idx_319726_liens_src_idx ON liens (src_id);\r\nKABOOM!\r\nFATAL error: There is no applicable method for the generic function\r\n               #<STANDARD-GENERIC-FUNCTION PGLOADER.CATALOG:FORMAT-TABLE-NAME (1)>\r\n             when called with arguments\r\n               (NIL).\r\nSee also:\r\n  The ANSI Standard, Section 7.6.6\r\nAn unhandled error condition has been signalled:\r\n   There is no applicable method for the generic function\r\n     #<STANDARD-GENERIC-FUNCTION PGLOADER.CATALOG:FORMAT-TABLE-NAME (1)>\r\n   when called with arguments\r\n     (NIL).\r\nSee also:\r\n  The ANSI Standard, Section 7.6.6\r\n\r\n2018-04-06T16:24:00.758000+01:00 NOTICE Complete PostgreSQL database.\r\n```\r\n\r\nhere my load file :\r\n\r\n```\r\nLOAD database\r\n    FROM '../tarballs/xxx.sqlite'\r\n    INTO postgresql://user:pass@127.0.0.1:5444/xxx\r\n\r\n    WITH include drop, create tables, create indexes, reset sequences, batch rows = 100, batch concurrency = 2\r\n\r\n    CAST type day to varchar\r\n    CAST type blob to varchar\r\n\r\n    INCLUDING ONLY TABLE NAMES LIKE 'articles', 'sommaires', 'textes_versions', 'db_meta', 'liens', 'sections'\r\n\r\n    AFTER LOAD DO\r\n    $$ CREATE INDEX textes_versions_cid_idx ON \"public\".textes_versions (cid); $$,\r\n    $$ CREATE INDEX textes_versions_date_debut_idx ON \"public\".textes_versions (date_debut); $$,\r\n    $$ CREATE INDEX textes_versions_date_fin_idx ON \"public\".textes_versions (date_fin); $$,\r\n    $$ CREATE INDEX sommaires_debut_idx ON \"public\".sommaires (debut); $$,\r\n    $$ CREATE INDEX sommaires_fin_idx ON \"public\".sommaires (fin); $$,\r\n    $$ CREATE INDEX articles_id_idx ON \"public\".articles (id); $$,\r\n    $$ CREATE INDEX articles_cid_idx ON \"public\".articles (cid); $$,\r\n    $$ CREATE INDEX articles_date_debut_idx ON \"public\".articles (date_debut); $$,\r\n    $$ CREATE INDEX articles_date_fin_idx ON \"public\".articles (date_fin); $$;\r\n```\r\n\r\nthis is public data so you can get the DB here : https://drive.google.com/file/d/1NQSL3AY62KH2I8fhlpJ8OHnnV4W7Lp2B/view?usp=sharing\r\n"}}
{"actor":{"display_login":"revolunet"}}