Migration from 4.5.49 to 5.3.55 failed

Server error: POST https://invoice.domain.de/api/v1/migration/start resulted in a 500 Internal Server Error response: 500 Internal Server Error < (truncated…)

v5 Log:

[2022-02-06 14:58:49] production.INFO: Importing account
[2022-02-06 14:58:49] production.INFO: Importing company
[2022-02-06 14:58:49] production.INFO: Importing users
[2022-02-06 14:58:49] production.INFO: Importing payment_terms
[2022-02-06 14:58:49] production.INFO: Importing tax_rates
[2022-02-06 14:58:49] production.INFO: Importing clients
[2022-02-06 14:59:42] production.INFO: Importing company_gateways
[2022-02-06 14:59:42] production.INFO: Importing client_gateway_tokens
[2022-02-06 14:59:42] production.INFO: Importing vendors
[2022-02-06 14:59:42] production.INFO: Importing projects
[2022-02-06 14:59:42] production.INFO: Importing products
[2022-02-06 14:59:42] production.INFO: Importing credits
[2022-02-06 14:59:42] production.INFO: Importing recurring_invoices
[2022-02-06 14:59:42] production.INFO: Importing invoices
[2022-02-06 15:01:09] production.INFO: db fails
[2022-02-06 15:01:10] production.INFO: db fails
[2022-02-06 15:01:11] production.INFO: db fails
[2022-02-06 15:01:11] production.INFO: db fails
[2022-02-06 15:01:12] production.INFO: db fails
[2022-02-06 15:01:13] production.INFO: db fails
[2022-02-06 15:01:14] production.INFO: db fails
[2022-02-06 15:01:14] production.INFO: db fails
[2022-02-06 15:01:15] production.INFO: db fails

V4 Log
[2022-02-06T14:58:25.100906+00:00] production.INFO: get account [] []
[2022-02-06T14:58:25.179284+00:00] production.INFO: get company [] []
[2022-02-06T14:58:25.179953+00:00] production.INFO: get co settings [] []
[2022-02-06T14:58:25.194159+00:00] production.INFO: get users 3 [] []
[2022-02-06T14:58:25.199421+00:00] production.INFO: get tax rates => 2 [] []
[2022-02-06T14:58:25.203811+00:00] production.INFO: get payment terms => 9 [] []
[2022-02-06T14:58:25.210019+00:00] production.INFO: get clients => 151 [] []
[2022-02-06T14:58:25.221450+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.224994+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.228208+00:00] production.INFO: Importing contacts => 4 [] []
[2022-02-06T14:58:25.234072+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.237554+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.243067+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.246307+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.249561+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.253057+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.256896+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.260299+00:00] production.INFO: Importing contacts => 5 [] []
[2022-02-06T14:58:25.266227+00:00] production.INFO: Importing contacts => 5 [] []
[2022-02-06T14:58:25.270058+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.273023+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.276027+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.279079+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.285362+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.291959+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.295192+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.298372+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.301463+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.304825+00:00] production.INFO: Importing contacts => 4 [] []
[2022-02-06T14:58:25.308768+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.312084+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.316093+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.319473+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.322564+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.326039+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.331659+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.335037+00:00] production.INFO: Importing contacts => 4 [] []
[2022-02-06T14:58:25.339025+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.342765+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.346269+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.353880+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.363204+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.369373+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.375943+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.383118+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.391290+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.398321+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.404946+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.412122+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.419167+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.426937+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.439264+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.448127+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.454229+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.460464+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.466741+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.472139+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.478387+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.485300+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.492411+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.502814+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.508703+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.514573+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.520709+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.526859+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.533292+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.540113+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.547548+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.555410+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.563343+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.569598+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.577277+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.593936+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.600713+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.606671+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.612383+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.618423+00:00] production.INFO: Importing contacts => 4 [] []
[2022-02-06T14:58:25.625583+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.632150+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.640127+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.648822+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.655773+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.662508+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.669452+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.677129+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.686524+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.693722+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.700605+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.707708+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.714622+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.721597+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.728176+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.735672+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.743597+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.750559+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.757330+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.763563+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.772173+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.778190+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.785030+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:25.791318+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.798016+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.808388+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.815729+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.825032+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.832157+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.838544+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.845067+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.851532+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.857776+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.866190+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.874492+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.882437+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.889979+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.898750+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.905880+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.912881+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.921606+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.930513+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.937235+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.944433+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.950708+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.958633+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.966358+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:25.976398+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.982507+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.988833+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:25.995947+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.002441+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.011453+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.018538+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.026984+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.034175+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.041609+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.048325+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.054648+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.063044+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.069688+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.077956+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:26.085078+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.091686+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.098217+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.107307+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.113624+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.119452+00:00] production.INFO: Importing contacts => 3 [] []
[2022-02-06T14:58:26.126626+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.133221+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.140021+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.147128+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.153185+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.161656+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.167397+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.174668+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.181665+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.190019+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.196163+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.202987+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.210817+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.219108+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.225997+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.233516+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.242457+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.249252+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.257643+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.264086+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.270712+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.277338+00:00] production.INFO: Importing contacts => 1 [] []
[2022-02-06T14:58:26.284305+00:00] production.INFO: Importing contacts => 2 [] []
[2022-02-06T14:58:26.298610+00:00] production.INFO: get get company gateways => 8 [] []
[2022-02-06T14:58:26.298732+00:00] production.INFO: translating gateway ID = 17 [] []
[2022-02-06T14:58:26.332163+00:00] production.INFO: translating gateway ID = 17 [] []
[2022-02-06T14:58:26.332444+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.357150+00:00] production.INFO: translating gateway ID = 17 [] []
[2022-02-06T14:58:26.359675+00:00] production.INFO: translating gateway ID = 17 [] []
[2022-02-06T14:58:26.359934+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.362429+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.390205+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.390420+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.393201+00:00] production.INFO: translating gateway ID = 64 [] []
[2022-02-06T14:58:26.404800+00:00] production.INFO: translating gateway ID = 64 [] []
[2022-02-06T14:58:26.405055+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.407493+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.410394+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.410621+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.413004+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.415916+00:00] production.INFO: translating gateway ID = 23 [] []
[2022-02-06T14:58:26.416222+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.418524+00:00] production.INFO: translating gateway ID = 9 [] []
[2022-02-06T14:58:26.428317+00:00] production.INFO: translating gateway ID = 9 [] []
[2022-02-06T14:58:26.428583+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.431215+00:00] production.INFO: translating gateway ID = 64 [] []
[2022-02-06T14:58:26.433588+00:00] production.INFO: translating gateway ID = 64 [] []
[2022-02-06T14:58:26.433881+00:00] production.INFO: get transform fees and limits [] []
[2022-02-06T14:58:26.451910+00:00] production.INFO: get client gateway tokens => 2 [] []
[2022-02-06T14:58:26.468581+00:00] production.INFO: get converting payment method meta [] []
[2022-02-06T14:58:26.475258+00:00] production.INFO: get converting payment method meta [] []
[2022-02-06T14:58:26.487136+00:00] production.INFO: get vendors => 0 [] []
[2022-02-06T14:58:26.551522+00:00] production.INFO: get projects => [] [] []
[2022-02-06T14:58:26.556269+00:00] production.INFO: get products 27 [] []
[2022-02-06T14:58:26.577639+00:00] production.INFO: get credit notes => 0 [] []
[2022-02-06T14:58:26.622560+00:00] production.INFO: get invoices → 1781 [] []
[2022-02-06T14:58:38.234578+00:00] production.INFO: get recurring Expenses => 0 [] []
[2022-02-06T14:58:38.247253+00:00] production.INFO: get recurring invoices => 1 [] []
[2022-02-06T14:58:38.440233+00:00] production.INFO: get quotes => 3 [] []
[2022-02-06T14:58:38.492268+00:00] production.INFO: get payments => 1776 [] []
[2022-02-06T14:58:45.672501+00:00] production.INFO: get credits => 0 [] []
[2022-02-06T14:58:45.681560+00:00] production.INFO: get documents => 67 [] []
[2022-02-06T14:58:45.756537+00:00] production.INFO: get expense categories => 0 [] []
[2022-02-06T14:58:45.780271+00:00] production.INFO: get task statuses => 4 [] []
[2022-02-06T14:58:45.785477+00:00] production.INFO: get expenses => 0 [] []
[2022-02-06T14:58:45.789596+00:00] production.INFO: get tasks => 0 [] []
[2022-02-06T14:58:45.793098+00:00] production.INFO: get documents => 67 [] []
[2022-02-06T15:00:34.381681+00:00] production.INFO: Server error: POST https://invoice.domain.de/api/v1/migration/start resulted in a 500 Internal Server Error response: 500 Internal Server Error < (truncated…) [] []

Hi,

If a 500 error occurs there should be details about the error in either storage/logs or the web server error logs.

@david any thoughts to debug?

i put the error on the v4 and v5 log…on webserver i find nothing else…

@stefanm

It looks like there is an issue with the database during the migration? The db fails log rows indicates something is happening with your DB during the migration process?