Site import stops node repair

maschad · October 19, 2016, 5:55pm

I am trying to import a new site but nothing seems to work, now when i run a ./flow node:repair
I am getting the following error:

Exception in line 128 of /home/wolfhaus2016/html/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occurred while executing 'UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?' with params ["d751713988987e9331980363e24189ce", "{}", "2016-10-19 19:50:15", "5b7f8f5d-ecf7-4b96-8155-8e2acca00a91", 1]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'dbd87ae51cbf5240fea77283585e69d5-live-d751713988987e9331980363e2' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

31 Doctrine\DBAL\Driver\AbstractMySQLDriver::convertException("An exception occurred while executing 'UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?' with params ["d751713988987e9331980363e24189ce", "{}", "2016-10-19 19:50:15", "5b7f8f5d-ecf7-4b96-8155-8e2acca00a91", 1]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'dbd87ae51cbf5240fea77283585e69d5-live-d751713988987e9331980363e2' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'", Doctrine\DBAL\Driver\PDOException)
30 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver, Doctrine\DBAL\Driver\PDOException, "UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?", array|5|)
29 Doctrine\DBAL\Connection::executeUpdate("UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?", array|5|, array|5|)
28 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::updateTable(TYPO3\TYPO3CR\Domain\Model\NodeData, "typo3_typo3cr_domain_model_nodedata", array|3|, TRUE)
27 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::update(TYPO3\TYPO3CR\Domain\Model\NodeData)
26 Doctrine\ORM\UnitOfWork::executeUpdates(TYPO3\Flow\Persistence\Doctrine\Mapping\ClassMetadata)
25 Doctrine\ORM\UnitOfWork::commit(NULL)
24 Doctrine\ORM\EntityManager::flush()
23 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::persistAll()
22 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::removeUndefinedProperties("live", FALSE, NULL)
21 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::invokeSubCommand("repair", TYPO3\Flow\Cli\ConsoleOutput, NULL, "live", FALSE, TRUE, NULL, NULL)
20 TYPO3\TYPO3CR\Command\NodeCommandController_Original::repairCommand(NULL, "live", FALSE, TRUE, NULL, NULL)
19 call_user_func_array(array|2|, array|6|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/home/wolfhaus2016/html/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Previous exception: Exception #23000 in line 987 of /home/wolfhaus2016/html/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Connection.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'dbd87ae51cbf5240fea77283585e69d5-live-d751713988987e9331980363e2' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

30 Doctrine\DBAL\Driver\PDOStatement::execute()
29 Doctrine\DBAL\Connection::executeUpdate("UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?", array|5|, array|5|)
28 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::updateTable(TYPO3\TYPO3CR\Domain\Model\NodeData, "typo3_typo3cr_domain_model_nodedata", array|3|, TRUE)
27 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::update(TYPO3\TYPO3CR\Domain\Model\NodeData)
26 Doctrine\ORM\UnitOfWork::executeUpdates(TYPO3\Flow\Persistence\Doctrine\Mapping\ClassMetadata)
25 Doctrine\ORM\UnitOfWork::commit(NULL)
24 Doctrine\ORM\EntityManager::flush()
23 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::persistAll()
22 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::removeUndefinedProperties("live", FALSE, NULL)
21 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::invokeSubCommand("repair", TYPO3\Flow\Cli\ConsoleOutput, NULL, "live", FALSE, TRUE, NULL, NULL)
20 TYPO3\TYPO3CR\Command\NodeCommandController_Original::repairCommand(NULL, "live", FALSE, TRUE, NULL, NULL)
19 call_user_func_array(array|2|, array|6|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/home/wolfhaus2016/html/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Previous exception: Exception #23000 in line 91 of /home/wolfhaus2016/html/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'dbd87ae51cbf5240fea77283585e69d5-live-d751713988987e9331980363e2' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

31 PDOStatement::execute(NULL)
30 Doctrine\DBAL\Driver\PDOStatement::execute()
29 Doctrine\DBAL\Connection::executeUpdate("UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ? AND version = ?", array|5|, array|5|)
28 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::updateTable(TYPO3\TYPO3CR\Domain\Model\NodeData, "typo3_typo3cr_domain_model_nodedata", array|3|, TRUE)
27 Doctrine\ORM\Persisters\Entity\BasicEntityPersister::update(TYPO3\TYPO3CR\Domain\Model\NodeData)
26 Doctrine\ORM\UnitOfWork::executeUpdates(TYPO3\Flow\Persistence\Doctrine\Mapping\ClassMetadata)
25 Doctrine\ORM\UnitOfWork::commit(NULL)
24 Doctrine\ORM\EntityManager::flush()
23 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::persistAll()
22 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::removeUndefinedProperties("live", FALSE, NULL)
21 TYPO3\TYPO3CR\Command\NodeCommandControllerPlugin_Original::invokeSubCommand("repair", TYPO3\Flow\Cli\ConsoleOutput, NULL, "live", FALSE, TRUE, NULL, NULL)
20 TYPO3\TYPO3CR\Command\NodeCommandController_Original::repairCommand(NULL, "live", FALSE, TRUE, NULL, NULL)
19 call_user_func_array(array|2|, array|6|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/home/wolfhaus2016/html/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Any ideas?

maschad · October 19, 2016, 6:00pm

Also inline editing no longer works, and there are some broke nodes that I am unable to repair as a result of ./flow node:repair not working.

bwaidelich · October 20, 2016, 10:55am

Sounds related to the post sent 3 days ago to this category: Flow site:import leads to an error

maschad · October 21, 2016, 12:43am

it was, my node:repair works fine now, I imported by ./flow kickstart:site --site-name and then I copy and pasted the project folder there (except the Sites.xml) and it seems like the order in which I did that messed it up… For some reason my html templates won’t pick up the languageDimensions now although I see them in the backend…