mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > Conjectures 'R Us

Reply
 
Thread Tools
Old 2022-09-16, 12:04   #298
pokemonlover123
 
pokemonlover123's Avatar
 
Mar 2016

5×13 Posts
Default PRPNet server error.

Good morning. I'm trying to get back into contributing to the project, but I'm running into an issue. I've reached the point where I'm adding candidates to the server using prpadmin, but candidategroupstats isn't populating and tests aren't being sent out to my clients.



I'm also getting an error when trying to update server statistics.


I've enabled debug logs and attached the associated messages when trying to update server statistics.


Going through the executed statements manually shows that CandidateGroupStats IS populated. However, it isn't whenever the server shows the error. However, while the errorring statement DOES error when I run it manually, it doesn't clear candidategroupstats. Am I right in assuming this is due to the database transaction for the whole server statistics operation not being committed due to the error?


MySQL Version is 8.0.30
Attached Files
File Type: txt PRPServerSQLError.txt (6.7 KB, 35 views)
pokemonlover123 is offline   Reply With Quote
Old 2022-09-16, 12:46   #299
pokemonlover123
 
pokemonlover123's Avatar
 
Mar 2016

5×13 Posts
Default

Quote:
Originally Posted by pokemonlover123 View Post
Good morning. I'm trying to get back into contributing to the project, but I'm running into an issue. I've reached the point where I'm adding candidates to the server using prpadmin, but candidategroupstats isn't populating and tests aren't being sent out to my clients.



I'm also getting an error when trying to update server statistics.


I've enabled debug logs and attached the associated messages when trying to update server statistics.


Going through the executed statements manually shows that CandidateGroupStats IS populated. However, it isn't whenever the server shows the error. However, while the errorring statement DOES error when I run it manually, it doesn't clear candidategroupstats. Am I right in assuming this is due to the database transaction for the whole server statistics operation not being committed due to the error?


MySQL Version is 8.0.30
OK, so I found the problem. Somehow, the SierpinskiRieselPrimeN column of CandidateGroupStats was a varchar instead of an int. I'm not sure how this happened since I created these tables a long time ago, but I ran an ALTER TABLE and fixed that, now the error is gone.
pokemonlover123 is offline   Reply With Quote
Old 2022-09-16, 15:12   #300
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

2×34×43 Posts
Default

Quote:
Originally Posted by pokemonlover123 View Post
OK, so I found the problem. Somehow, the SierpinskiRieselPrimeN column of CandidateGroupStats was a varchar instead of an int. I'm not sure how this happened since I created these tables a long time ago, but I ran an ALTER TABLE and fixed that, now the error is gone.
Make sure you use the latest create_table scripts with the latest code. This column was changed in one of the more recent releases. I typically drop the database then recreate then run the .sql file to create the scripts.

Glad to know that others get use from PRPNet.
rogue is offline   Reply With Quote
Old 2022-09-16, 15:17   #301
pokemonlover123
 
pokemonlover123's Avatar
 
Mar 2016

5·13 Posts
Default

Quote:
Originally Posted by rogue View Post
Make sure you use the latest create_table scripts with the latest code. This column was changed in one of the more recent releases. I typically drop the database then recreate then run the .sql file to create the scripts.

Glad to know that others get use from PRPNet.

Yea - I figured out that I made that mistake.



But now I'm all set up and working on a base :)
pokemonlover123 is offline   Reply With Quote
Old 2022-09-17, 06:32   #302
gd_barnes
 
gd_barnes's Avatar
 
"Gary"
May 2007
Overland Park, KS

1183610 Posts
Default

Welcome back to CRUS, Pokemonlover!


I'm glad you got that figured out. Good luck!
gd_barnes is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Useless SSE instructions __HRB__ Programming 41 2012-07-07 17:43
Questions about software licenses... WraithX GMP-ECM 37 2011-10-28 01:04
Software/instructions/questions gd_barnes No Prime Left Behind 48 2009-07-31 01:44
Instructions to manual LLR? OmbooHankvald PSearch 3 2005-08-05 20:28
Instructions please? jasong Sierpinski/Riesel Base 5 10 2005-03-14 04:03

All times are UTC. The time now is 11:22.


Sun Feb 5 11:22:06 UTC 2023 up 171 days, 8:50, 1 user, load averages: 0.62, 0.64, 0.73

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.

≠ ± ∓ ÷ × · − √ ‰ ⊗ ⊕ ⊖ ⊘ ⊙ ≤ ≥ ≦ ≧ ≨ ≩ ≺ ≻ ≼ ≽ ⊏ ⊐ ⊑ ⊒ ² ³ °
∠ ∟ ° ≅ ~ ‖ ⟂ ⫛
≡ ≜ ≈ ∝ ∞ ≪ ≫ ⌊⌋ ⌈⌉ ∘ ∏ ∐ ∑ ∧ ∨ ∩ ∪ ⨀ ⊕ ⊗ 𝖕 𝖖 𝖗 ⊲ ⊳
∅ ∖ ∁ ↦ ↣ ∩ ∪ ⊆ ⊂ ⊄ ⊊ ⊇ ⊃ ⊅ ⊋ ⊖ ∈ ∉ ∋ ∌ ℕ ℤ ℚ ℝ ℂ ℵ ℶ ℷ ℸ 𝓟
¬ ∨ ∧ ⊕ → ← ⇒ ⇐ ⇔ ∀ ∃ ∄ ∴ ∵ ⊤ ⊥ ⊢ ⊨ ⫤ ⊣ … ⋯ ⋮ ⋰ ⋱
∫ ∬ ∭ ∮ ∯ ∰ ∇ ∆ δ ∂ ℱ ℒ ℓ
𝛢𝛼 𝛣𝛽 𝛤𝛾 𝛥𝛿 𝛦𝜀𝜖 𝛧𝜁 𝛨𝜂 𝛩𝜃𝜗 𝛪𝜄 𝛫𝜅 𝛬𝜆 𝛭𝜇 𝛮𝜈 𝛯𝜉 𝛰𝜊 𝛱𝜋 𝛲𝜌 𝛴𝜎𝜍 𝛵𝜏 𝛶𝜐 𝛷𝜙𝜑 𝛸𝜒 𝛹𝜓 𝛺𝜔