mailtrain
mailtrain copied to clipboard
Published
20 hours ago •
Mailtrain-org
Mailtrain-org
How to import bdd from v1 to bdd in v2 beta (from one server to another one)
At present
I use Mailtrain V1 (with docker-compose) on one server and I want to import this db in another server where running v2 beta (with docker-compose).
What is the good solution to import all email we have stored in Mailtrain V1 ?
I have tried to export v1 db (mysqldump) and import in v2 but after restarting container I have this error:
mysql_1 | 2019-07-19 9:37:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190719 9:37:29
mailtrain_1 | info Using local auth
mailtrain_1 | info sql Database check completed
mailtrain_1 | ERR! Error: ER_BAD_FIELD_ERROR: Unknown column 'role' in 'field list'
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! { Error: ER_BAD_FIELD_ERROR: Unknown column 'role' in 'field list'
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! stack:
mailtrain_1 | ERR! 'Error: ER_BAD_FIELD_ERROR: Unknown column \'role\' in \'field list\'\n at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)\n at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)\n at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)\n at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)\n at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)\n at Socket.emit (events.js:182:13)\n at Socket.EventEmitter.emit (domain.js:441:20)\n at addChunk (_stream_readable.js:283:12)\n at readableAddChunk (_stream_readable.js:264:11)\n at Socket.Readable.push (_stream_readable.js:219:10)\n at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)\n --------------------\n at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)\n at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)\n at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18\n at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)\n at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)\n at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)\n at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)\n at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)\n at /app/server/node_modules/knex/lib/transaction.js:232:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)\n at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)\n at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)\n at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)\n at /app/server/node_modules/knex/lib/runner.js:47:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at /app/server/node_modules/bluebird/js/release/using.js:185:26\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)\n at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)\n at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)',
mailtrain_1 | ERR! code: 'ER_BAD_FIELD_ERROR',
mailtrain_1 | ERR! errno: 1054,
mailtrain_1 | ERR! sqlMessage: 'Unknown column \'role\' in \'field list\'',
mailtrain_1 | ERR! sqlState: '42S22',
mailtrain_1 | ERR! index: 0,
mailtrain_1 | ERR! sql: 'update `users` set `role` = \'master\' where `id` = 1' }
mysql_1 | 2019-07-19 9:37:30 10 [Warning] Aborted connection 10 to db: 'mailtrain' user: 'mailtrain' host: '172.18.0.5' (Got an error reading communication packets)
Did you completely clean up the database before the import? In particular, have you deleted the tables knex_... ?
No. I have just starting mailtrain v2 with docker-compose and make docker exec to mariadb:10.4 container.
After that cd /var/lib/mysql and mysql -u mailtrain -p mailtrain < dump.mailtrainv1.sql
You say that I need to cleanup db before import value of v1 db ? If yes I can try this.
You you need to completely clean it up. The easiest is to drop the DB and then to create it.
I have try this in v1 mysqldump -u mailtrain -p -q --databases mailtrain --add-drop-database > dump.mailtrainv1.sql and when I import in v2 with this command mysql -u mailtrain -p mailtrain < dump.mailtrainv1.sql I can just seen table from v1 db.
When I restart Mailtrain v2 containers I Have this error:
mysql_1 | 2019-07-19 10:27:45 0 [Note] InnoDB: Buffer pool(s) load completed at 190719 10:27:45
mailtrain_1 | info Using local auth
mailtrain_1 | info sql Database check completed
mailtrain_1 | migration file "20170506102634_v1_to_v2.js" failed
mailtrain_1 | migration failed with error: Unsupported DB schema version: 34
mailtrain_1 | ERR! Error: Unsupported DB schema version: 34
mailtrain_1 | ERR! at migrateBase (/app/server/setup/knex/migrations/20170506102634_v1_to_v2.js:82:15)
mailtrain_1 | ERR! { Error: Unsupported DB schema version: 34
mailtrain_1 | ERR! at migrateBase (/app/server/setup/knex/migrations/20170506102634_v1_to_v2.js:82:15)
mailtrain_1 | ERR! stack:
mailtrain_1 | ERR! 'Error: Unsupported DB schema version: 34\n at migrateBase (/app/server/setup/knex/migrations/20170506102634_v1_to_v2.js:82:15)' }
mysql_1 | 2019-07-19 10:27:47 10 [Warning] Aborted connection 10 to db: 'mailtrain' user: 'mailtrain' host: '172.18.0.2' (Got an error reading communication packets)
mailtrain_mailtrain_1 exited with code 1
If I look in Mariadb I can see all tables available in v2 with knex table.
Do you have an idea?
No, you have to delete the whole database. There are tables which are not part of v1 and thus they don't get dropped.
I have dropped Mailtrain v2 database in drop database mailtrain; and used this command mysql -u mailtrain -p < dump.mailtrainv1.sql to recreate database with v1 value.
I have verified that Mailtrain database is correctly created:
MariaDB [mailtrain]> show tables;
+---------------------+
| Tables_in_mailtrain |
+---------------------+
| attachments |
| blacklist |
| campaign |
| campaign__1 |
| campaign_tracker |
| campaign_tracker__1 |
| campaigns |
| confirmations |
| custom_fields |
| custom_forms |
| custom_forms_data |
| import_failed |
| importer |
| links |
| lists |
| queued |
| report_templates |
| reports |
| rss |
| segment_rules |
| segments |
| settings |
| subscription |
| subscription__2 |
| subscription__3 |
| subscription__5 |
| subscription__6 |
| templates |
| trigger |
| triggers |
| tzoffset |
| users |
+---------------------+
32 rows in set (0.000 sec)
But same error visible when I restart v2 containers.
I see. We don't have explicit support for migrating from the latest version of v1 yet. However, it should just work if you edit app/server/lib/dbcheck.js line 15 inside the container and change it from 33 -> 34.
How I can modify container because the container is automatically stop when error appear.
I have tried to start from scratch again to make modification in dbcheck.js (in this case Mailtrain starting and I can use docker exec command) and to commit this modification in new tag images. I have drop database, create new one with import from v1 and restarting Mailtrain with this new images (to make sure value is 34); but same error appear.
Its not necessary to modify this file 20170506102634_v1_to_v2.js ?
I have tried to modify also this file 20170506102634_v1_to_v2.js (replace 33 by 34)
if (!row || Number(row.value) !== 34) {
throw new Error('Unsupported DB schema version: ' + row.value);
But with that I have this error:
mysql_1 | 2019-07-19 14:12:17 0 [Note] InnoDB: Buffer pool(s) load completed at 190719 14:12:17
mailtrain_1 | info Using local auth
mailtrain_1 | info sql Database check completed
mailtrain_1 | migration file "20170506102634_v1_to_v2.js" failed
mailtrain_1 | migration failed with error: insert into `campaign_lists` (`campaign`, `list`, `segment`) values (1, 1, NULL) - ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! { Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! stack:
mailtrain_1 | ERR! 'Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))\n at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)\n at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)\n at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)\n at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)\n at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)\n at Socket.emit (events.js:182:13)\n at Socket.EventEmitter.emit (domain.js:441:20)\n at addChunk (_stream_readable.js:283:12)\n at readableAddChunk (_stream_readable.js:264:11)\n at Socket.Readable.push (_stream_readable.js:219:10)\n at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)\n --------------------\n at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)\n at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)\n at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18\n at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)\n at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)\n at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)\n at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)\n at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)\n at /app/server/node_modules/knex/lib/transaction.js:232:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)\n at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)\n at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)\n at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)\n at /app/server/node_modules/knex/lib/runner.js:47:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at /app/server/node_modules/bluebird/js/release/using.js:185:26\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)\n at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)\n at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)',
mailtrain_1 | ERR! code: 'ER_NO_REFERENCED_ROW_2',
mailtrain_1 | ERR! errno: 1452,
mailtrain_1 | ERR! sqlMessage:
mailtrain_1 | ERR! 'Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))',
mailtrain_1 | ERR! sqlState: '23000',
mailtrain_1 | ERR! index: 0,
mailtrain_1 | ERR! sql:
mailtrain_1 | ERR! 'insert into `campaign_lists` (`campaign`, `list`, `segment`) values (1, 1, NULL)' }
mysql_1 | 2019-07-19 14:13:37 10 [Warning] Aborted connection 10 to db: 'mailtrain' user: 'mailtrain' host: '172.18.0.5' (Got an error reading communication packets)
mailtrain_mailtrain_1 exited with code 1
Is it possible to downgrade database of Mailtrain v1 from 34 to 33? Do you know if its possible?
If its just possible to make migration from v1 "33" to v2, maybe its a good solution. We want to use v2 for some new feature you have developed :)
I have tried to change mailtrainv1 database to return to version 33:
alter table custom_fields drop description; and update settingssetvalue= "33" wherekey = "db_schema_version";
After that I delete mailtrain v2 database, import v1 database and stop and start mailtrainv2
But I have this message, do you have an idea about this error:
mailtrain_1 | info Using local auth
mailtrain_1 | info sql Database check completed
mailtrain_1 | migration file "20170506102634_v1_to_v2.js" failed
mailtrain_1 | migration failed with error: insert into `campaign_lists` (`campaign`, `list`, `segment`) values (1, 1, NULL) - ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! { Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:182:13)
mailtrain_1 | ERR! at Socket.EventEmitter.emit (domain.js:441:20)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:283:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:264:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:219:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at /app/server/node_modules/bluebird/js/release/using.js:185:26
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)
mailtrain_1 | ERR! at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)
mailtrain_1 | ERR! at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)
mailtrain_1 | ERR! stack:
mailtrain_1 | ERR! 'Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))\n at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)\n at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)\n at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)\n at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)\n at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)\n at Socket.emit (events.js:182:13)\n at Socket.EventEmitter.emit (domain.js:441:20)\n at addChunk (_stream_readable.js:283:12)\n at readableAddChunk (_stream_readable.js:264:11)\n at Socket.Readable.push (_stream_readable.js:219:10)\n at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)\n --------------------\n at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)\n at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)\n at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18\n at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:313:9)\n at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:483:18)\n at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:79:10)\n at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)\n at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)\n at /app/server/node_modules/knex/lib/transaction.js:232:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)\n at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)\n at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)\n at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)\n at /app/server/node_modules/knex/lib/runner.js:47:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at /app/server/node_modules/bluebird/js/release/using.js:185:26\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Promise._settlePromiseFromHandler (/app/server/node_modules/bluebird/js/release/promise.js:512:31)\n at Promise._settlePromise (/app/server/node_modules/bluebird/js/release/promise.js:569:18)\n at Promise._settlePromise0 (/app/server/node_modules/bluebird/js/release/promise.js:614:10)',
mailtrain_1 | ERR! code: 'ER_NO_REFERENCED_ROW_2',
mailtrain_1 | ERR! errno: 1452,
mailtrain_1 | ERR! sqlMessage:
mailtrain_1 | ERR! 'Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))',
mailtrain_1 | ERR! sqlState: '23000',
mailtrain_1 | ERR! index: 0,
mailtrain_1 | ERR! sql:
mailtrain_1 | ERR! 'insert into `campaign_lists` (`campaign`, `list`, `segment`) values (1, 1, NULL)' }
mysql_1 | 2019-07-22 8:44:28 10 [Warning] Aborted connection 10 to db: 'mailtrain' user: 'mailtrain' host: '172.18.0.2' (Got an error reading communication packets)
mailtrain_mailtrain_1 exited with code 1
So I have stopped to try this solution. I have exported Subscribers list in csv file directly from mailtrain v1 database and imported in v2.
You can close this issue if you don't have an idea about this error. If you find something, I'm interrested to understand solution ;)
I'm preparing a new version, which will be able to ingest the version 34 of Mailtrain v1 DB. However, it will take at least a few days before I stabilize the other features that are part of that.
I am getting the same error, when trying to import v1 database to v2 database
mailtrain_1 | Info: Waiting for Redis Server
mailtrain_1 | info sql Update 31 applied
mailtrain_1 | info sql Update 32 applied
mailtrain_1 | info sql Update 33 applied
mailtrain_1 | info sql Update 34 applied
mailtrain_1 | info sql Database check completed
mailtrain_1 | migration file "20170506102634_v1_to_v2.js" failed
mailtrain_1 | migration failed with error: insert into `campaign_lists` (`campaign`, `list`, `segment`) values (5, 5, NULL) - ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:198:13)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:288:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:269:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:224:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:384:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:518:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:103:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! { Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))
mailtrain_1 | ERR! at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
mailtrain_1 | ERR! at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
mailtrain_1 | ERR! at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
mailtrain_1 | ERR! at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)
mailtrain_1 | ERR! at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)
mailtrain_1 | ERR! at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)
mailtrain_1 | ERR! at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)
mailtrain_1 | ERR! at Socket.emit (events.js:198:13)
mailtrain_1 | ERR! at addChunk (_stream_readable.js:288:12)
mailtrain_1 | ERR! at readableAddChunk (_stream_readable.js:269:11)
mailtrain_1 | ERR! at Socket.Readable.push (_stream_readable.js:224:10)
mailtrain_1 | ERR! at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
mailtrain_1 | ERR! --------------------
mailtrain_1 | ERR! at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
mailtrain_1 | ERR! at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18
mailtrain_1 | ERR! at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:384:9)
mailtrain_1 | ERR! at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:518:18)
mailtrain_1 | ERR! at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:103:10)
mailtrain_1 | ERR! at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)
mailtrain_1 | ERR! at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/transaction.js:232:21
mailtrain_1 | ERR! at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)
mailtrain_1 | ERR! at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)
mailtrain_1 | ERR! at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)
mailtrain_1 | ERR! at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)
mailtrain_1 | ERR! at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)
mailtrain_1 | ERR! at /app/server/node_modules/knex/lib/runner.js:47:21
mailtrain_1 | ERR! stack:
mailtrain_1 | ERR! 'Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))\n at Query.Sequence._packetToError (/app/server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)\n at Query.ErrorPacket (/app/server/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)\n at Protocol._parsePacket (/app/server/node_modules/mysql/lib/protocol/Protocol.js:291:23)\n at Parser._parsePacket (/app/server/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/app/server/node_modules/mysql/lib/protocol/Parser.js:43:10)\n at Protocol.write (/app/server/node_modules/mysql/lib/protocol/Protocol.js:38:16)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:91:28)\n at Socket.<anonymous> (/app/server/node_modules/mysql/lib/Connection.js:525:10)\n at Socket.emit (events.js:198:13)\n at addChunk (_stream_readable.js:288:12)\n at readableAddChunk (_stream_readable.js:269:11)\n at Socket.Readable.push (_stream_readable.js:224:10)\n at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)\n --------------------\n at Protocol._enqueue (/app/server/node_modules/mysql/lib/protocol/Protocol.js:144:48)\n at Connection.query (/app/server/node_modules/mysql/lib/Connection.js:201:25)\n at /app/server/node_modules/knex/lib/dialects/mysql/index.js:144:18\n at Promise._execute (/app/server/node_modules/bluebird/js/release/debuggability.js:384:9)\n at Promise._resolveFromExecutor (/app/server/node_modules/bluebird/js/release/promise.js:518:18)\n at new Promise (/app/server/node_modules/bluebird/js/release/promise.js:103:10)\n at Client_MySQL._query (/app/server/node_modules/knex/lib/dialects/mysql/index.js:135:12)\n at Client_MySQL.query (/app/server/node_modules/knex/lib/client.js:192:17)\n at /app/server/node_modules/knex/lib/transaction.js:232:21\n at tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Function.Promise.attempt.Promise.try (/app/server/node_modules/bluebird/js/release/method.js:39:29)\n at Client_MySQL.trxClient.query (/app/server/node_modules/knex/lib/transaction.js:229:33)\n at Runner.<anonymous> (/app/server/node_modules/knex/lib/runner.js:138:36)\n at Runner.tryCatcher (/app/server/node_modules/bluebird/js/release/util.js:16:23)\n at Runner.query (/app/server/node_modules/bluebird/js/release/method.js:15:34)\n at /app/server/node_modules/knex/lib/runner.js:47:21',
mailtrain_1 | ERR! code: 'ER_NO_REFERENCED_ROW_2',
mailtrain_1 | ERR! errno: 1452,
mailtrain_1 | ERR! sqlMessage:
mailtrain_1 | ERR! 'Cannot add or update a child row: a foreign key constraint fails (`mailtrain`.`campaign_lists`, CONSTRAINT `campaign_lists_list_foreign` FOREIGN KEY (`list`) REFERENCES `lists` (`id`))',
mailtrain_1 | ERR! sqlState: '23000',
mailtrain_1 | ERR! index: 0,
mailtrain_1 | ERR! sql:
mailtrain_1 | ERR! 'insert into `campaign_lists` (`campaign`, `list`, `segment`) values (5, 5, NULL)' }
mysql_1 | 2022-03-28 14:25:10 5 [Warning] Aborted connection 5 to db: 'mailtrain' user: 'mailtrain' host: '172.18.0.2' (Got an error reading communication packets)
@saschafoerster did you check both databases first if they work? You cannot just import it and hope it works.
When you check out the error code you see that there is an issue with a foreign key.
I solved it! I had to delete some "campaigns", where the "list" didn't exist anymore. When I followed the information in my error messages, I could follow I had to delete all campaigns with list 5 and 4 (which where deleted earlier in v1). After that, import of the data base worked well.
Now I am wondering about attachments and files :D
We are going to start with the development and testing of mailtrain v3 in the next weeks.
You are welcome to help us with the testing as soon as the first release candidate is available.