server not starting

[AmirHM]

Hi
When I update my server to 1.4.13-beta-1
My server is not starting any more

Starting the TeaSpeak server..
Could not start TeaSpeak server.
Last log entries:
[2020-04-19 10:30:29] [CRITICAL]   GEN | Could not initialize SQL!
[2020-04-19 10:30:29] [CRITICAL]   GEN | failed to upgrade database: failed to insert data into the new clients table ( sql: INSERT INTO `clients_v2` (`serverId`, `cldbid`, `clientUid`, `firstConnect`, `lastConnect`, `connections`, `lastName`) SELECT `serverId`, `cldbid`, `clientUid`, `firstConnect`, `lastConnect`, `connections`, `lastName` FROM `clients`; returned -> 1/constraint failed)
[2020-04-19 10:30:29] [INFO ]   GEN | Stopping application
[2020-04-19 10:30:29] [INFO ]   GEN | Application suspend successful!

 

[grepher76]

1.4.13-beta-2

[2020-04-20 07:01:10] [INFO ] GEN | Upgrading database from version 11 to 12. This could take a moment!
[2020-04-20 07:01:10] [CRITICAL] GEN | Could not initialize SQL!
[2020-04-20 07:01:10] [CRITICAL] GEN | failed to upgrade database: failed to insert data into the new clients table ( sql: INSERT INTO `clients_v2` (`serverId`, `cldbid`, `clientUid`, `firstConnect`, `lastConnect`, `connections`, `lastName`) SELECT `serverId`, `cldbid`, `clientUid`, `firstConnect`, `lastConnect`, `connections`, `lastName` FROM `clients`; returned -> 1/constraint failed)
[2020-04-20 07:01:10] [INFO ] GEN | Stopping application
[2020-04-20 07:01:10] [INFO ] GEN | Application suspend successful!

 

[REDOSS]

@WolverinDEV As far as I know, there is no such table in the database, there is just a table "clients" without the prefix "_2"

 

[WolverinDEV]

No I modified the table and for that I need to create a temp table...
Seems like you're having duplicated entries within these tables.

NVM because the new snapshot system isn't within that release I'll remove this upgrade and may add some kind of recovery when your database is a bit messed up.

 

[grepher76]

for the moment I cannot update immediately?

 

[WolverinDEV]

Updated in 1.4.13-beta3 Out in 20 seconds

 

[grepher76]

Thanks

---- Automatically Merged Double Post ----

Update done 1.4.13-beta-3, no start-up problems.

you can close the problem.

 

[REDOSS]

// Closed