NATION

PASSWORD

[QUERY] N-Day6 archives?

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
Afo
Political Columnist
 
Posts: 3
Founded: Feb 12, 2017
Authoritarian Democracy

[QUERY] N-Day6 archives?

Postby Afo » Thu Sep 22, 2022 7:19 am

There are archived leaderboards for the first five N-Days, held between 2017 and 2020. For example, if you want the N-Day2 archives, you can go here, while if you'd rather remember N-Day5, you might want to go here.

But this page - which, according to page numbering precedent, should contain archived leaderboards for N-Day6 (September 2021) - does not exist. And no faction records from that N-Day are currently accessible, owing to faction pre-registration having opened for all, which has meant all previous faction pages and statistics being wiped off the books.

Is there any possibility that we could get N-Day6 leaderboards archived for posterity any time soon? Sorry, but thanks.
Last edited by Afo on Thu Sep 22, 2022 7:21 am, edited 1 time in total.
"Oh, God - not another puppet of Tinhampton!"
There was once a time when a repeating quatrain
Ensured that there was a perpetual refrain
But after so long, and after so much pain
They decided "Let's not write like that again!"

User avatar
The Church of Satan
Minister
 
Posts: 2022
Founded: Apr 15, 2013
Corrupt Dictatorship

Postby The Church of Satan » Thu Sep 22, 2022 9:03 am

Well, that's because two goliaths merged last year and dominated the leaderboard.
The Rejected Realms: Former Delegate | Former Vice Delegate | Longest Consecutively Serving Officer in TRR History - 824 Days
Free the WA gnomes!

Chanku: This isn't an election it's an assault on the eyes. | Ikania: Hear! The Gospel of... Satan. Erh...
Yuno: Not gonna yell, but CoS is one of the best delegates ever | Ever-Wandering Souls: In the liberal justice system, raiding-based offenses are considered especially heinous. In The South Pacific, the dedicated defenders who investigate these vicious felonies are members of an elite squad known as the Council on Regional Security. These are their proscriptions. DUN DUN.

User avatar
The Blaatschapen
Tech Modling
 
Posts: 61819
Founded: Antiquity
Anarchy

Postby The Blaatschapen » Thu Sep 22, 2022 9:08 am

Afo wrote:There are archived leaderboards for the first five N-Days, held between 2017 and 2020. For example, if you want the N-Day2 archives, you can go here, while if you'd rather remember N-Day5, you might want to go here.

But this page - which, according to page numbering precedent, should contain archived leaderboards for N-Day6 (September 2021) - does not exist. And no faction records from that N-Day are currently accessible, owing to faction pre-registration having opened for all, which has meant all previous faction pages and statistics being wiped off the books.

Is there any possibility that we could get N-Day6 leaderboards archived for posterity any time soon? Sorry, but thanks.


We're looking into this.

The Church of Satan wrote:Well, that's because two goliaths merged last year and dominated the leaderboard.


While it's true that last was dominated, I can already safely say that's not the reason why the leaderboard of Nday6 isn't there.
1. Tech modling. No idea what it means, but it has a fancy colour.
2.
3.
4.
5.
6.
7.
8. Size matters. Bigger is forbidden and won't give the mods pleasure.

User avatar
Tinhampton
Postmaster-General
 
Posts: 11076
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Fri Sep 23, 2022 2:49 pm

Thank you again and I await further updates on this.

(I would also appreciate the N-Day7 leaderboards going up after that event as well.)
The Self-Administrative City of TINHAMPTON (pop. 319,372): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415
Other achievements: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; possibly very controversial; *author of the most popular WA resolution ever
Who am I, really? 46yo Tory woman w/Asperger's; Cambridge graduate; currently reading nothing much

User avatar
Sedgistan
Senior Issues Moderator
 
Posts: 32381
Founded: Oct 20, 2006
Anarchy

Postby Sedgistan » Sat Sep 24, 2022 5:17 am

Sorry, but due to a database issue we don't have a viable record of N-Day6 stats to archive.

If anyone scraped a complete record of them, let us know.

User avatar
Tinhampton
Postmaster-General
 
Posts: 11076
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Sat Sep 24, 2022 6:23 am

That no permanent copy appears to have ever been made of the N-Day6 results is confusing as much as it is concerning:
  1. It is not as though the site shits itself into unusability whenever it sees a faction with 10,000 members or 1,000,000 score. From what I recall, the site did not crash during N-Day6 - although I was only up for the first ~16hrs of the event.
  2. NationStates has issued a daily dump of every nation and region in the world every day for the past several years. Data is available for every day of September 2021, when N-Day6 took place (and during the days of the Drewpocalypse, the worst site load event I can remember).
  3. A collection of eight datasets covering 100 factions each, never mind all 500ish of them, is far more compact than the daily dumps by nature, has historical importance, and - in the very worst case - could have been archived at any time for a year after the event. (N-Day4 logs weren't archived until November 2019.)
  4. How could "a database issue" have stopped N-Day6 results from being collected while both daily dumps were issued as normal?
Last edited by Tinhampton on Sat Sep 24, 2022 6:42 am, edited 5 times in total.
The Self-Administrative City of TINHAMPTON (pop. 319,372): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415
Other achievements: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; possibly very controversial; *author of the most popular WA resolution ever
Who am I, really? 46yo Tory woman w/Asperger's; Cambridge graduate; currently reading nothing much

User avatar
United Calanworie
Forum Moderator
 
Posts: 392
Founded: Dec 12, 2018
Democratic Socialists

Postby United Calanworie » Sat Sep 24, 2022 4:57 pm

Tinhampton wrote:That no permanent copy appears to have ever been made of the N-Day6 results is confusing as much as it is concerning:
  1. It is not as though the site shits itself into unusability whenever it sees a faction with 10,000 members or 1,000,000 score. From what I recall, the site did not crash during N-Day6 - although I was only up for the first ~16hrs of the event.
  2. NationStates has issued a daily dump of every nation and region in the world every day for the past several years. Data is available for every day of September 2021, when N-Day6 took place (and during the days of the Drewpocalypse, the worst site load event I can remember).
  3. A collection of eight datasets covering 100 factions each, never mind all 500ish of them, is far more compact than the daily dumps by nature, has historical importance, and - in the very worst case - could have been archived at any time for a year after the event. (N-Day4 logs weren't archived until November 2019.)
  4. How could "a database issue" have stopped N-Day6 results from being collected while both daily dumps were issued as normal?

NB: I do not have an explicit answer for (4), this are just my thoughts.

Not all database dumps are created equal. The daily dump is produced one way, N-Day is produced another. Databases are not one giant blob of data, they're separated into tables (presuming that all the data you're talking about is *in* a database to begin with), so an archival script may not necessarily retrieve all the data in a database at any given time. Server load does not necessarily have anything to do with it.
Discord: Aav#7564
She/Her/Hers
||||||||||||||||||||
HYPR: TG API software (GitHub) | Spyglass (forum) (GitHub) (Latest Release)
No legality guarantees are attached to software linked here. Just because I wrote it/am a maintainer does not mean that it will be rules compliant 100% of the time.


User avatar
The Web of Life and Destiny
Lobbyist
 
Posts: 14
Founded: Sep 17, 2022
Corporate Bordello

Postby The Web of Life and Destiny » Sat Sep 24, 2022 7:58 pm

I guess my question would be why no stats were recorded at the time? Generally the stats are published each year along with the end of the event. Even Z-day has recorded stats for last year despite the fact that no actual review of the event was ever made.

User avatar
[violet]
Site Admin
 
Posts: 15785
Founded: Antiquity

Postby [violet] » Sat Sep 24, 2022 11:46 pm

What happened: We neglected to run the archive utility - which turns raw numbers from the database into a page of archived stats - both at the end of last year's NDay and before the start of this one, and in the meantime, the backup utility responsible for NDay database tables was malfunctioning and no-one noticed. There might be other ways to reconstruct the stats, but as of right now, we don't have the raw data from NDay6, and we also don't have a backup of that data.

I'm very sorry about this. Normally I double-check the archive just before the start of each NDay event, but because this year we added Faction pre-registration, the tables were wiped three days earlier.

User avatar
Altmoras
Diplomat
 
Posts: 822
Founded: Jan 25, 2012
Inoffensive Centrist Democracy

Postby Altmoras » Sun Sep 25, 2022 1:34 pm

I expect nothing and still I'm disappointed.
Benevolent Thomas-Today at 11:15 AM
"I'm not sure if Altmoras has ever been wrong about anything."

Inhumanly good at the game according to official word of site staff.

User avatar
Tinhampton
Postmaster-General
 
Posts: 11076
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Mon Sep 26, 2022 10:34 am

One-upping my other request for an archived N-Day7 (2022) table.

I am Afo.
Last edited by Tinhampton on Mon Sep 26, 2022 10:40 am, edited 1 time in total.
The Self-Administrative City of TINHAMPTON (pop. 319,372): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415
Other achievements: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; possibly very controversial; *author of the most popular WA resolution ever
Who am I, really? 46yo Tory woman w/Asperger's; Cambridge graduate; currently reading nothing much

User avatar
[violet]
Site Admin
 
Posts: 15785
Founded: Antiquity

Postby [violet] » Mon Sep 26, 2022 6:31 pm

Tinhampton wrote:One-upping my other request for an archived N-Day7 (2022) table.

It's here.

User avatar
Tinhampton
Postmaster-General
 
Posts: 11076
Founded: Oct 05, 2016
Civil Rights Lovefest

Postby Tinhampton » Tue Sep 27, 2022 7:22 am

It's a bit more stripped-back than previous years' archives (only top 50 listed, not top 100; no stat-by-stat summary below each faction name; no record of Intercepts) but I can understand why - a relatively streamlined list of records are, of course, better than no records whatsoever. Thanks in any event.
Last edited by Tinhampton on Tue Sep 27, 2022 7:27 am, edited 3 times in total.
The Self-Administrative City of TINHAMPTON (pop. 319,372): Saffron Howard, Mayor (UCP); Alexander Smith, WA Delegate-Ambassador

Authorships & co-authorships: SC#250, SC#251, Issue #1115, SC#267, GA#484, GA#491, GA#533, GA#540, GA#549, SC#356, GA#559, GA#562, GA#567, GA#578, SC#374, GA#582, SC#375, GA#589, GA#590, SC#382, SC#385*, GA#597, GA#607, SC#415
Other achievements: Cup of Harmony 73 champions; Philosopher-Queen of Sophia; possibly very controversial; *author of the most popular WA resolution ever
Who am I, really? 46yo Tory woman w/Asperger's; Cambridge graduate; currently reading nothing much

User avatar
Caffeinated
Secretary
 
Posts: 28
Founded: May 02, 2020
Civil Rights Lovefest

Postby Caffeinated » Tue Sep 27, 2022 12:22 pm

I know this might be a tad late but the waybackmachine seems to have incomplete records of the top 50 factions. Here’s a link to all n-day faction related related links that I could find. https://web.archive.org/web/*/https://www.nationstates.net/page=factions* And a link to all the n-day nation related links I could find.https://web.archive.org/web/*/https://www.nationstates.net/page=nukes*
Not sure if this is useful but I’d figured I’d share. I also have some screenshots mostly of my nation and my faction.
Last edited by Caffeinated on Tue Sep 27, 2022 12:22 pm, edited 1 time in total.


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: No registered users

Advertisement

Remove ads