Synology-Forum.nl
Packages => 3rd party Packages => Spotweb => Topic gestart door: K!K op 24 september 2016, 09:31:59
-
Krijg deze melding bij het binnenhalen van Spots?
sudo /usr/local/bin/php56 /volume2/web/spotweb/retrieve.php --force
Removing Spot information which is beyond retention period,
SpotWeb v0.67.28.31 on PHP v5.6.23 crashed
Fatal error occured retrieving reports:
HY000: 1205: Lock wait timeout exceeded; try restarting transaction
#0 /volume2/web/spotweb/lib/dbeng/dbeng_pdo.php(74): dbeng_pdo->exec('DELETE FROM com...', Array)
#1 /volume2/web/spotweb/lib/dao/Base/Dao_Base_Comment.php(279): dbeng_pdo->modify('DELETE FROM com...', Array)
#2 /volume2/web/spotweb/retrieve.php(133): Dao_Base_Comment->expireCommentsFull('1500')
#3 {main}
PHP Notice: Undefined variable: retriever in /volume2/web/spotweb/retrieve.php on line 313
PHP Fatal error: Call to a member function quit() on null in /volume2/web/spotweb/retrieve.php on line 313
-
En zonder sudo?
-
usr/local/bin/php56 /volume2/web/spotweb/retrieve.php --force
Removing Spot information which is beyond retention period,
SpotWeb v0.67.28.31 on PHP v5.6.23 crashed
Fatal error occured retrieving reports:
HY000: 1206: The total number of locks exceeds the lock table size
#0 /volume2/web/spotweb/lib/dbeng/dbeng_pdo.php(74): dbeng_pdo->exec('DELETE FROM com...', Array)
#1 /volume2/web/spotweb/lib/dao/Base/Dao_Base_Comment.php(279): dbeng_pdo->modify('DELETE FROM com...', Array)
#2 /volume2/web/spotweb/retrieve.php(133): Dao_Base_Comment->expireCommentsFull('1500')
#3 {main}
PHP Notice: Undefined variable: retriever in /volume2/web/spotweb/retrieve.php on line 313
PHP Fatal error: Call to a member function quit() on null in /volume2/web/spotweb/retrieve.php on line 313
-
Ik had hetzelfde.
Bij mij kwam het door de update van MariaDB waardoor de instellingen weer op standaard zijn gesprongen.
In my.cnf file de innodb_buffer_pool_size verhogen (van 16 naar 512MB in mijn geval, geen andere waarde geprobeerd), en daarna MariaDB herstarten verhielp het probleem.
innodb_buffer_pool_size = 512M
/volume1/@appstore/MariaDB/etc/mysql/my.cnf
-
De foutmelding komt door het opschonen van database van oude posts, langer dan de retentie van je NewsGroup server. Als je die optie uit zet in Spotweb ben je ook van het probleem af.
-
Ik heb Niels zijn oplossing geprobeerd deze werkt inderdaad!
De andere heb ik niet geprobeerd omdat ik niet lokaal ben.
Last retrieve at Fri 23 Sep 2016 07:03:01 AM CEST
Retrieving new Spots from server ...
Appr. Message count: 2535314
First message number: 5698531
Last message number: 8233845
Current article number: 8233072
Retrieving 8233072 till 8233573 (parsed: 500, in DB: 1, signed: 354, invalid: 131, rtntn.skip: 0, mod: 15, full: 354, total: 501) in 129.31 seconds
Retrieving 8233573 till 8233846 (parsed: 273, in DB: 0, signed: 219, invalid: 47, rtntn.skip: 0, mod: 7, full: 219, total: 273) in 65.23 seconds
Processed a total of 774 spots
Finished retrieving spots.
Calculating how many spots are new, done.
Last retrieve at Sun 25 Sep 2016 08:29:33 AM CEST
Retrieving new comments from server ...
Appr. Message count: 17146771
First message number: 2406383
Last message number: 19553154
Current article number: 16921333
Retrieving 16921333 till 16921834, found 501 comments in 25.7 seconds
Retrieving 16921834 till 16922335, found 501 comments in 28.19 seconds
SpotWeb v0.67.28.31 on PHP v5.6.23 crashed
Fatal error occured retrieving reports:
23000: 1062: Duplicate entry 'Pu7KC3Bsh7kybCWVg4mty.0.0BPM2magFSoAvqaVg.Du6J@spot.net' for key 'idx_commentsxover_1'
#0 /volume2/web/spotweb/lib/dao/Base/Dao_Base_Comment.php(124): dbeng_pdo->batchInsert(Array, 'INSERT INTO com...', Array, Array)
#1 /volume2/web/spotweb/lib/services/Retriever/Services_Retriever_Comments.php(292): Dao_Base_Comment->addComments(Array, Array)
#2 /volume2/web/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Comments->process(Array, 16921834, 16922335, 1474785011.9745)
#3 /volume2/web/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('16921333', '500')
#4 /volume2/web/spotweb/retrieve.php(188): Services_Retriever_Base->perform()
#5 {main}
Finished retrieving comments.
-
Bedankt voor terugkoppeling.
-
Er is weer een MariaDB update geweest, en de parameters zijn dus weer terug gezet op 8 MB :-(
Spotweb update crasht dus weer in geval "opschonen oude posts" aan staat.