API tools faq
paste
Advertisement
emilwojcik93

Database Migration Job Logs

emilwojcik93
Aug 14th, 2021
359
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 18.91 KB | None | 0 0
raw download clone embed print report
  1. [
  2.   {
  3.     "insertId": "2a800b96-631e-4427-9716-7e91a92a9468",
  4.     "jsonPayload": {
  5.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  6.       "migrationJob": {
  7.         "state": "DRAFT",
  8.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  9.         "duration": "0s",
  10.         "sourceDatabase": {
  11.           "engine": "MYSQL"
  12.         },
  13.         "type": "CONTINUOUS",
  14.         "displayName": "test5"
  15.       },
  16.       "occurrenceTimestamp": "2021-08-14T11:38:44.898494Z",
  17.       "textMessage": "Migration job test5 was created and is in status Draft."
  18.     },
  19.     "resource": {
  20.       "type": "datamigration.googleapis.com/MigrationJob",
  21.       "labels": {
  22.         "resource_container": "687211029173",
  23.         "location": "europe-west3",
  24.         "migration_job_id": "test5"
  25.       }
  26.     },
  27.     "timestamp": "2021-08-14T11:38:44.898674Z",
  28.     "severity": "NOTICE",
  29.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  30.     "receiveTimestamp": "2021-08-14T11:38:45.589789867Z"
  31.   },
  32.   {
  33.     "insertId": "33f7aa25-a238-4de1-8c92-224b0ce399be",
  34.     "jsonPayload": {
  35.       "migrationJob": {
  36.         "connectivityType": "STATIC_IP",
  37.         "state": "DRAFT",
  38.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  39.         "displayName": "test5",
  40.         "sourceDatabase": {
  41.           "engine": "MYSQL"
  42.         },
  43.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  44.         "duration": "0s",
  45.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  46.         "type": "CONTINUOUS"
  47.       },
  48.       "occurrenceTimestamp": "2021-08-14T11:43:44.636405Z",
  49.       "textMessage": "User initiated Verify on the migration job - test5.",
  50.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog"
  51.     },
  52.     "resource": {
  53.       "type": "datamigration.googleapis.com/MigrationJob",
  54.       "labels": {
  55.         "location": "europe-west3",
  56.         "migration_job_id": "test5",
  57.         "resource_container": "687211029173"
  58.       }
  59.     },
  60.     "timestamp": "2021-08-14T11:43:44.636566Z",
  61.     "severity": "NOTICE",
  62.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  63.     "receiveTimestamp": "2021-08-14T11:43:45.526164254Z"
  64.   },
  65.   {
  66.     "insertId": "1bb44384-83bf-4908-8a7e-1290ee98d702",
  67.     "jsonPayload": {
  68.       "occurrenceTimestamp": "2021-08-14T11:44:01.831065Z",
  69.       "originalMessage": "Incompatible database source and destination versions. Destination must be at most one version above source. Recreate the migration job with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  70.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  71.       "textMessage": "test5 - migration job test configuration has returned the following warnings: Incompatible database source and destination versions. Destination must be at most one version above source. Recreate the migration job with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  72.       "migrationJob": {
  73.         "state": "DRAFT",
  74.         "error": {
  75.           "message": "Incompatible database source and destination versions. Destination must be at most one version above source. Recreate the migration job with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  76.           "code": 9
  77.         },
  78.         "connectivityType": "STATIC_IP",
  79.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  80.         "sourceDatabase": {
  81.           "engine": "MYSQL"
  82.         },
  83.         "duration": "0s",
  84.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  85.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  86.         "type": "CONTINUOUS",
  87.         "displayName": "test5"
  88.       }
  89.     },
  90.     "resource": {
  91.       "type": "datamigration.googleapis.com/MigrationJob",
  92.       "labels": {
  93.         "migration_job_id": "test5",
  94.         "resource_container": "687211029173",
  95.         "location": "europe-west3"
  96.       }
  97.     },
  98.     "timestamp": "2021-08-14T11:44:01.831229Z",
  99.     "severity": "ERROR",
  100.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  101.     "receiveTimestamp": "2021-08-14T11:44:02.625678757Z"
  102.   },
  103.   {
  104.     "insertId": "92f02b36-b928-4f3d-9a60-21d1ce558211",
  105.     "jsonPayload": {
  106.       "textMessage": "Migration job test5 status changed from DRAFT to CREATING.",
  107.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  108.       "migrationJob": {
  109.         "sourceDatabase": {
  110.           "engine": "MYSQL"
  111.         },
  112.         "displayName": "test5",
  113.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  114.         "error": {
  115.           "message": "Incompatible database source and destination versions. Destination must be at most one version above source. Recreate the migration job with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  116.           "code": 9
  117.         },
  118.         "type": "CONTINUOUS",
  119.         "destinationDatabase": {
  120.           "provider": "CLOUDSQL",
  121.           "engine": "MYSQL"
  122.         },
  123.         "state": "CREATING",
  124.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  125.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  126.         "duration": "0.189258s",
  127.         "connectivityType": "STATIC_IP"
  128.       },
  129.       "occurrenceTimestamp": "2021-08-14T12:33:50.059441Z"
  130.     },
  131.     "resource": {
  132.       "type": "datamigration.googleapis.com/MigrationJob",
  133.       "labels": {
  134.         "migration_job_id": "test5",
  135.         "location": "europe-west3",
  136.         "resource_container": "687211029173"
  137.       }
  138.     },
  139.     "timestamp": "2021-08-14T12:33:50.059586Z",
  140.     "severity": "NOTICE",
  141.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  142.     "receiveTimestamp": "2021-08-14T12:33:50.189208026Z"
  143.   },
  144.   {
  145.     "insertId": "7490d60b-dfd2-422f-b7bf-615ef04d7bb3",
  146.     "jsonPayload": {
  147.       "occurrenceTimestamp": "2021-08-14T12:33:59.261427Z",
  148.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  149.       "textMessage": "Migration job test5 was updated successfully.\nField state changed from CREATING to NOT_STARTED.",
  150.       "migrationJob": {
  151.         "duration": "9.373469s",
  152.         "type": "CONTINUOUS",
  153.         "connectivityType": "STATIC_IP",
  154.         "state": "NOT_STARTED",
  155.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  156.         "displayName": "test5",
  157.         "sourceDatabase": {
  158.           "engine": "MYSQL"
  159.         },
  160.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  161.         "destinationDatabase": {
  162.           "provider": "CLOUDSQL",
  163.           "engine": "MYSQL"
  164.         },
  165.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb"
  166.       }
  167.     },
  168.     "resource": {
  169.       "type": "datamigration.googleapis.com/MigrationJob",
  170.       "labels": {
  171.         "migration_job_id": "test5",
  172.         "location": "europe-west3",
  173.         "resource_container": "687211029173"
  174.       }
  175.     },
  176.     "timestamp": "2021-08-14T12:33:59.261634Z",
  177.     "severity": "NOTICE",
  178.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  179.     "receiveTimestamp": "2021-08-14T12:33:59.629433821Z"
  180.   },
  181.   {
  182.     "insertId": "76d66163-1515-4ca9-afd0-1d513fcd3b6a",
  183.     "jsonPayload": {
  184.       "migrationJob": {
  185.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  186.         "type": "CONTINUOUS",
  187.         "duration": "9.373469s",
  188.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  189.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  190.         "state": "NOT_STARTED",
  191.         "displayName": "test5",
  192.         "connectivityType": "STATIC_IP",
  193.         "sourceDatabase": {
  194.           "engine": "MYSQL"
  195.         },
  196.         "destinationDatabase": {
  197.           "engine": "MYSQL",
  198.           "provider": "CLOUDSQL"
  199.         }
  200.       },
  201.       "textMessage": "Migration job test5 was created successfully.",
  202.       "occurrenceTimestamp": "2021-08-14T12:33:59.261565Z",
  203.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog"
  204.     },
  205.     "resource": {
  206.       "type": "datamigration.googleapis.com/MigrationJob",
  207.       "labels": {
  208.         "location": "europe-west3",
  209.         "migration_job_id": "test5",
  210.         "resource_container": "687211029173"
  211.       }
  212.     },
  213.     "timestamp": "2021-08-14T12:33:59.263901Z",
  214.     "severity": "NOTICE",
  215.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  216.     "receiveTimestamp": "2021-08-14T12:33:59.629433821Z"
  217.   },
  218.   {
  219.     "insertId": "a021b0c1-a11f-480f-9b91-af1943494f05",
  220.     "jsonPayload": {
  221.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  222.       "occurrenceTimestamp": "2021-08-14T12:34:01.158515Z",
  223.       "migrationJob": {
  224.         "state": "STARTING",
  225.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  226.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  227.         "type": "CONTINUOUS",
  228.         "sourceDatabase": {
  229.           "engine": "MYSQL"
  230.         },
  231.         "connectivityType": "STATIC_IP",
  232.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  233.         "displayName": "test5",
  234.         "destinationDatabase": {
  235.           "provider": "CLOUDSQL",
  236.           "engine": "MYSQL"
  237.         },
  238.         "duration": "9.478238s"
  239.       },
  240.       "textMessage": "User initiated Start on the migration job - test5."
  241.     },
  242.     "resource": {
  243.       "type": "datamigration.googleapis.com/MigrationJob",
  244.       "labels": {
  245.         "resource_container": "687211029173",
  246.         "migration_job_id": "test5",
  247.         "location": "europe-west3"
  248.       }
  249.     },
  250.     "timestamp": "2021-08-14T12:34:01.158846Z",
  251.     "severity": "NOTICE",
  252.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  253.     "receiveTimestamp": "2021-08-14T12:34:01.751101124Z"
  254.   },
  255.   {
  256.     "insertId": "cfc04169-7f95-4b40-8000-742e795b85c8",
  257.     "jsonPayload": {
  258.       "migrationJob": {
  259.         "destinationDatabase": {
  260.           "provider": "CLOUDSQL",
  261.           "engine": "MYSQL"
  262.         },
  263.         "sourceDatabase": {
  264.           "engine": "MYSQL"
  265.         },
  266.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  267.         "connectivityType": "STATIC_IP",
  268.         "type": "CONTINUOUS",
  269.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  270.         "displayName": "test5",
  271.         "duration": "9.478238s",
  272.         "state": "STARTING",
  273.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5"
  274.       },
  275.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  276.       "occurrenceTimestamp": "2021-08-14T12:34:01.167089Z",
  277.       "textMessage": "Migration job test5 status changed from NOT_STARTED to STARTING."
  278.     },
  279.     "resource": {
  280.       "type": "datamigration.googleapis.com/MigrationJob",
  281.       "labels": {
  282.         "resource_container": "687211029173",
  283.         "migration_job_id": "test5",
  284.         "location": "europe-west3"
  285.       }
  286.     },
  287.     "timestamp": "2021-08-14T12:34:01.167228Z",
  288.     "severity": "NOTICE",
  289.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  290.     "receiveTimestamp": "2021-08-14T12:34:01.751101124Z"
  291.   },
  292.   {
  293.     "insertId": "3bc3ac8d-5020-4b7b-bfce-38541f214e1a",
  294.     "jsonPayload": {
  295.       "migrationJob": {
  296.         "connectivityType": "STATIC_IP",
  297.         "displayName": "test5",
  298.         "state": "FAILED",
  299.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  300.         "type": "CONTINUOUS",
  301.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  302.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  303.         "duration": "26.584717s",
  304.         "destinationDatabase": {
  305.           "engine": "MYSQL",
  306.           "provider": "CLOUDSQL"
  307.         },
  308.         "error": {
  309.           "code": 9,
  310.           "message": "The migration job failed to start due to incompatible database source and destination versions. Destination must be at most one version above source. The migration job will need to be recreated with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported"
  311.         },
  312.         "sourceDatabase": {
  313.           "engine": "MYSQL"
  314.         }
  315.       },
  316.       "originalMessage": "The migration job failed to start due to incompatible database source and destination versions. Destination must be at most one version above source. The migration job will need to be recreated with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  317.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  318.       "textMessage": "Failed to Start migration job test5 - error code: 9, error message: The migration job failed to start due to incompatible database source and destination versions. Destination must be at most one version above source. The migration job will need to be recreated with a compatible destination. Details: replication from source database server (UNKNOWN_DATABASE_TYPE) is not supported",
  319.       "occurrenceTimestamp": "2021-08-14T12:34:18.291476Z"
  320.     },
  321.     "resource": {
  322.       "type": "datamigration.googleapis.com/MigrationJob",
  323.       "labels": {
  324.         "location": "europe-west3",
  325.         "resource_container": "687211029173",
  326.         "migration_job_id": "test5"
  327.       }
  328.     },
  329.     "timestamp": "2021-08-14T12:34:18.291635Z",
  330.     "severity": "ERROR",
  331.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  332.     "receiveTimestamp": "2021-08-14T12:34:18.356403842Z"
  333.   },
  334.   {
  335.     "insertId": "04ea3e5e-a57d-4cf6-8610-d6ef658b856b",
  336.     "jsonPayload": {
  337.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  338.       "occurrenceTimestamp": "2021-08-14T12:34:18.459960Z",
  339.       "migrationJob": {
  340.         "displayName": "test5",
  341.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  342.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  343.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  344.         "type": "CONTINUOUS",
  345.         "connectivityType": "STATIC_IP",
  346.         "duration": "26.586074s",
  347.         "sourceDatabase": {
  348.           "engine": "MYSQL"
  349.         },
  350.         "state": "RUNNING",
  351.         "destinationDatabase": {
  352.           "provider": "CLOUDSQL",
  353.           "engine": "MYSQL"
  354.         }
  355.       },
  356.       "textMessage": "Migration job test5 status changed from FAILED to RUNNING.\nFailure due to the following error:\n error code: 0,\n error message: "
  357.     },
  358.     "resource": {
  359.       "type": "datamigration.googleapis.com/MigrationJob",
  360.       "labels": {
  361.         "migration_job_id": "test5",
  362.         "location": "europe-west3",
  363.         "resource_container": "687211029173"
  364.       }
  365.     },
  366.     "timestamp": "2021-08-14T12:34:18.460091Z",
  367.     "severity": "ERROR",
  368.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  369.     "receiveTimestamp": "2021-08-14T12:34:19.263875453Z"
  370.   },
  371.   {
  372.     "insertId": "5e42cdfe-b17e-457d-b1c5-1eac569af2db",
  373.     "jsonPayload": {
  374.       "occurrenceTimestamp": "2021-08-14T12:36:25.827832Z",
  375.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  376.       "migrationJob": {
  377.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  378.         "type": "CONTINUOUS",
  379.         "sourceDatabase": {
  380.           "engine": "MYSQL"
  381.         },
  382.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  383.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  384.         "duration": "154.039104s",
  385.         "connectivityType": "STATIC_IP",
  386.         "displayName": "test5",
  387.         "state": "DELETING",
  388.         "destinationDatabase": {
  389.           "engine": "MYSQL",
  390.           "provider": "CLOUDSQL"
  391.         }
  392.       },
  393.       "textMessage": "User initiated Delete on the migration job - test5."
  394.     },
  395.     "resource": {
  396.       "type": "datamigration.googleapis.com/MigrationJob",
  397.       "labels": {
  398.         "migration_job_id": "test5",
  399.         "resource_container": "687211029173",
  400.         "location": "europe-west3"
  401.       }
  402.     },
  403.     "timestamp": "2021-08-14T12:36:25.827952Z",
  404.     "severity": "NOTICE",
  405.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  406.     "receiveTimestamp": "2021-08-14T12:36:26.640521719Z"
  407.   },
  408.   {
  409.     "insertId": "6eb211c0-fde5-4166-94b1-47e9232fe7e3",
  410.     "jsonPayload": {
  411.       "migrationJob": {
  412.         "type": "CONTINUOUS",
  413.         "destinationDatabase": {
  414.           "engine": "MYSQL",
  415.           "provider": "CLOUDSQL"
  416.         },
  417.         "sourceDatabase": {
  418.           "engine": "MYSQL"
  419.         },
  420.         "displayName": "test5",
  421.         "name": "projects/adardashboard/locations/europe-west3/migrationJobs/test5",
  422.         "state": "DELETING",
  423.         "source": "projects/adardashboard/locations/europe-west3/connectionProfiles/adardb",
  424.         "connectivityType": "STATIC_IP",
  425.         "destination": "projects/adardashboard/locations/europe-west3/connectionProfiles/test5",
  426.         "duration": "154.039104s"
  427.       },
  428.       "occurrenceTimestamp": "2021-08-14T12:36:25.831615Z",
  429.       "@type": "type.googleapis.com/google.cloud.clouddms.logging.v1.MigrationJobEventLog",
  430.       "textMessage": "Migration job test5 status changed from RUNNING to DELETING."
  431.     },
  432.     "resource": {
  433.       "type": "datamigration.googleapis.com/MigrationJob",
  434.       "labels": {
  435.         "migration_job_id": "test5",
  436.         "resource_container": "687211029173",
  437.         "location": "europe-west3"
  438.       }
  439.     },
  440.     "timestamp": "2021-08-14T12:36:25.831736Z",
  441.     "severity": "NOTICE",
  442.     "logName": "projects/adardashboard/logs/datamigration.googleapis.com%2Fmigration_job_event",
  443.     "receiveTimestamp": "2021-08-14T12:36:26.640521719Z"
  444.   }
  445. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!