XF 2.2 Issue creating new forums

[rotpar]

Hi,

whenever I create a new forum (discussions) it copy and pastes 13 pages of existing threads from a random other forum into it and I have to delete all of them. Any idea what the cause might be?

Thank you

 

[Nicolas FR]

Any third party add-ons installed ?

 

[Hoffi]

I assume some AddOn is making trouble. Any AddOn installed which relates to nodes?

 

[rotpar]

Nope, no addons anymore since 2.2. All addons I used before are deleted/deactivated

 

[Hoffi]

Okay.

Do you imported your Forum? Maybe the Threads are already in your Database, and the new Forum makes them visible.

 

[rotpar]

Nope nothing imported. These threads exist already yes just in other parts of the forum and they are already visible and accessible. It copies them somehow over but no idea why.

 

[Hoffi]

Whow, thats strange. Are there entries in die Log?

 

[rotpar]

Yes indeed, I just saw it. I guess it is related to this one since it is the only one....but its just a guess

• MySQL statement prepare error [1213]: Deadlock found when trying to get lock; try restarting transaction
• src/XF/Db/AbstractStatement.php:230

SELECT
post_date - post_date % 86400 AS unixDate,
COUNT(*)
FROM xf_post
WHERE post_date BETWEEN ? AND ?
AND message_state = ?
GROUP BY unixDate

------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1213, '40001')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(177): XF\Db\AbstractAdapter->query('
SELECT
...', Array)
#5 src/XF/Stats/Post.php(21): XF\Db\AbstractAdapter->fetchPairs('
SELECT
...', Array)
#6 src/XF/Repository/Stats.php(63): XF\Stats\Post->getData(1656979200, 1657065600)
#7 src/XF/Cron/Counters.php(30): XF\Repository\Stats->build(1656979200, 1657065600)
#8 src/XF/Job/Cron.php(37): XF\Cron\Counters::recordDailyStats(Object(XF\Entity\CronEntry))
#9 src/XF/Job/Manager.php(260): XF\Job\Cron->run(8)
#10 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#11 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 8)
#12 job.php(43): XF\Job\Manager->runQueue(false, 8)
#13 {main}

 

[Hoffi]

That is only a SELECT, but a transaction issue. I am not sure. Maybe open a ticket for XF Support.

 

[briansol]

reboot your mysql server / restart the service. you might have a lock to kill