I submitted the test results for M96999043 and M96999083 but both still show up as assigned to me:
[url]https://www.mersenne.org/report_exponent/?exp_lo=96999043&full=1[/url]
[url]https://www.mersenne.org/report_exponent/?exp_lo=96999083&full=1[/url]
Also in the account assignment details. Weird...

[QUOTE=ramgeis;486679]I submitted the test results for M96999043 and M96999083 but both still show up as assigned to me:
[url]https://www.mersenne.org/report_exponent/?exp_lo=96999043&full=1[/url]
[url]https://www.mersenne.org/report_exponent/?exp_lo=96999083&full=1[/url]
Also in the account assignment details. Weird...[/QUOTE]

Were these done with mprime or with gpuOwL? Maybe this is an issue for manually submitting gpuOwL results?

The cure would be for someone to do PRP double checks, but those are big exponents.

Alternatively, you could try de-assigning them in your account assignment details page.

[QUOTE=GP2;487229]Were these done with mprime or with gpuOwL? Maybe this is an issue for manually submitting gpuOwL results?

The cure would be for someone to do PRP double checks, but those are big exponents.

Alternatively, you could try de-assigning them in your account assignment details page.[/QUOTE]

No, I manually submitted the results done by Prime95 from a machine with no connection to the outside world.
Of course I can delete my assignment, but that doesn't make the problem go away.
I just wanted to raise the awareness of an issue on the server side.
I'll definitely have a look at it again when I submit the next results...

PrimeNet Statistics page off
 

I wanted to find why there would be a lone unknown exponent in the 77 to 78M range.

- The [url=https://www.mersenne.org/report_exponent/?exp_lo=77000000&exp_hi=77000100&text=1]Detailed report / Exponent status[/url] is not outputing correctly in text-only format : when pasted the lines are missing an end of line character. One can use the text-only report if one goes through "view source". I abandoned the idea of doing this 56 times :-(

- Another query brought out an anomaly : I used the [url=https://www.mersenne.org/report_factors/?exp_lo=77000000&exp_hi=77000100&exp_date=&fac_len=&txt=1&dispdate=1&B1=Get+Factors]PrimeNet Known Factors of Mersenne Numbers[/url], counted the factored exponents and found 35813 and not 35812 as stated in the [url=https://www.mersenne.org/primenet/]PrimeNet statistics[/url] page. With 35813 the numbers tally.

Could it be that all the manipulations to hide new primes are the cause of that kind of errors ?
Since people get more and more adept at finding them as soon as the news of a new prime is out, the changes done to hide them have gotten more complex. Perhaps not all changes have been undone (in this range and in others...)

Jacob

[QUOTE=ramgeis;487273]No, I manually submitted the results done by Prime95 from a machine with no connection to the outside world.
Of course I can delete my assignment, but that doesn't make the problem go away.
I just wanted to raise the awareness of an issue on the server side.
I'll definitely have a look at it again when I submit the next results...[/QUOTE]

It happened again with M96999191 and M96999193. I can't imagine that it is supposed to work this way.

lingering PRP assignments
 

[QUOTE=ramgeis;487273]No, I manually submitted the results done by Prime95 from a machine with no connection to the outside world.
Of course I can delete my assignment, but that doesn't make the problem go away.
I just wanted to raise the awareness of an issue on the server side.
I'll definitely have a look at it again when I submit the next results...[/QUOTE]
It seems to be a generic issue; it's occurring when manually submitting gpuowl results.


Folks are busy, & I assume they'll get to fixing it eventually.

[QUOTE=kriesel;487571]Folks are busy, & I assume they'll get to fixing it eventually.[/QUOTE]

At the same time, it's a bit embarrassing.

The [URL="https://www.mersenne.org/report_milestones/"]Milestones report[/URL] says everything below 78,413,429 has been tested at least once.

And yet the [URL="https://www.mersenne.org/primenet/"]Work Distribution Map[/URL] shows there is still a 77M needing a first time check.

These are simple SQL queries.

Why is there still inconsistency?

lingering PRP assignments
 

[QUOTE=ramgeis;487273]No, I manually submitted the results done by Prime95 from a machine with no connection to the outside world.
Of course I can delete my assignment, but that doesn't make the problem go away.
I just wanted to raise the awareness of an issue on the server side.
I'll definitely have a look at it again when I submit the next results...[/QUOTE]
It seems to be a generic issue; it's occurring when manually submitting gpuowl results.


Folks are busy, & I assume they'll get to fixing it eventually.

[QUOTE=chalsall;487573]These are simple SQL queries.[/QUOTE]

That would be the case if the schema were correctly designed. But I have a feeling that's not the case, as usage has evolved over the years.

[QUOTE=Mark Rose;487579]That would be the case if the schema were correctly designed. But I have a feeling that's not the case, as usage has evolved over the years.[/QUOTE]

Please forgive me for this, but as you know SQL handles AND and OR statements really quite well.

"SELECT COUNT(*) FROM exponent WHERE (state=1 OR state=5) GROUP BY exponent%1000000" works fine, for example. And uses cached indexes.

I would swear to make my point, but there's little demonstrated upside....

[QUOTE=Mark Rose;487579]That would be the case if the schema were correctly designed. But I have a feeling that's not the case, as usage has evolved over the years.[/QUOTE]

It's not necessarily that it's hard to come up with queries that get the right results, it's just taking the time to do it... which, for me, means researching where the existing queries live, how they work, and then figuring out how to mod it to include the PRP results (which live in their own table... it's different work than LL and was added *way* after the fact, so yeah... it has its own home :smile:)

Since adding PRP to the site, I hope folks appreciate that adding a new feature like that and then going back through and fixing all kinds of reports behind the scenes is one of those things with lots of moving parts. Personally I didn't really mind thinking that it would be done here and there as time permitted. Y'all are just impatient. LOL