An outage (in more ways than one)

Written By: - Date published: 1:50 pm, July 11th, 2021 - 22 comments
Categories: admin, The Standard - Tags:

First off – my apologies for letting the site drop out over the past days. We had several outages, computer and human.

Sometime on Wednesday (I think), the site started to die after a operating system update and during the same day (I think),  a automatic wordpress plugin update.

The system update was that (somehow) the database server got rolled back to an older version. This was the cause of the increasing levels of sluggishness in the site. The PHP was literally timing out on the database accesses because the some of the old default settings weren’t even close to optimal at even our base levels of traffic. Logged errors provided no easy diagnosis because it didn’t indicate what subsystem was causing the timeouts.

At roughly the same time an unwanted automatic update of WordPress plugins happened – something that was meant to have been a manual process that I pretest in a staging test site. This had the effect of effectively disabling what little access was there to the back end administration of WordPress by blowing up the javascript processing.

That was the computer outage.

Unfortunately I’d also had a bug from Monday onwards. Some kind of virus (probably) that pushed my lymph nodes into painful action, put me to sleep a lot, dropped my appetite to nil, and by Wednesday were making me vomit any solid food and in the last few days has eased off into diarrhea. It also pushed me into a bird brain lack of focus.

That was the human outage(s).

It wasn’t covid-19 as I have had my third (maybe fourth) unfortunate experience in getting tested – it never gets any better. I’ve lost 3kgs in a week, and I’m still on water, barley sugars, soup and soft scrambled eggs until I stop puking up solid food.

This week hasn’t been good times for me  exactly in a good condition to try to solve this. However I had a  crack at last night and found the data problem. This morning I managed to fix the other issues by detaching backend plugin to the point I could reactivate  the functionality.

Let me know if there are any obvious problems. But for now I’m going to sip soup and have a bit of a lie down…. I’d suggest avoiding this human bug. It rather takes the joy out of life.

lprent: Opps – that got published as my testing alter ego AncientGeek, who as a mere whatever privilege level he is on, could change the author of the post

22 comments on “An outage (in more ways than one) ”

  1. lprent 1

    If anyone is wondering (like I did) why the comments are bit sparse on the right hand side, it is because there is a 5 day cutout as well as a maximum number of comments.

    These were the comments that some detirmined people managed to push through despite the outrage.

    • weka 1.1

      Good to see the Replies list is still there (logged in).

      • lprent 1.1.1

        Replies just works off a number of replies that match the logged in or the current ’email’ secret in use on the cookies (the latter is there for those who aren’t logged in) – which are the ‘id’ of the user.

        The all comments gets expensive to pull up in database processing time. Limiting by time allowed the database to efficiently optimise the query. But comments change all of the time. So as an optimisation, as each comment is made it simply flags a change, that causes the page refresh of the author to trigger an update of the cached list from a database query. This means that everyone else who isn’t making comments doesn’t have to query for the list from the database.

        It is reasonably efficient and is one of the reason why leaving a comment takes longer than just switching a page. Everyone else just gets the most recent cached list of comments.

        I was willing to expend more database resources on replies because it only gets calculated when someone with an ‘id’ asks for a page and it isn’t cached. The first load, and whenever someone replies to them. When the person making the comment, the id of who they are replying to is looked up in the cache of replies. If it is there, then that cached list of replies to deleted. Causing the replies list for that id to be recalculated on their next page load.

        But being replied to is far rarer than having a comment made for everyone, so the server load isn’t irkcome.

        I tested those both logged off and logged on.

        Anyway nap time for the sysop.

  2. Ric 2

    testing to correct a comment
    adding to comment
    If this posts all working on windows with firefox
    Thanks for your work keeping the site running

    • lprent 2.1

      Yeah. I also changed the wysiwyg comment editor from CK editor to the more usual Javascript editor. It is the one we use in writing the posts.

    • lprent 2.2

      I have tested with Linux Chrome/ Firefox, current Android Chrome / Firefox and whatever Samsung browser is. Windows 10 Chrome / Edge.

      Haven’t looked at the Mac side yet. I will do that on the remote website testing tools or plead with my partner to touch her toys (and that will be a difficult bearing in mind the state of my health).

  3. lprent 3

    This editor seems to get around that issue of not being able to edit comments on Android inside the desktop (non mobile) theme.

  4. Stephen D 4

    Thanks LPrent for all you do.

  5. Cancel reply doesn’t work – latest opera version, and it also makes the ‘leave a comment’ disappear from the bottom of the page, which takes a page refresh to reappear.

    • AncientGeek 5.1

      Yep. Shows on Linux Chrome / Firefox as well. Probably everything.
      The javascript code appears to be doing a passive event handler that just ain’t working
      I’ll look at it when I wake up.

      Dang – AncientGeek – definitely a birdbrain today.

      • The Al1en 5.1.1

        Though bizarrely, if you right click on ‘cancel reply’ and open in a new tab, that tab will be as it should.

        • AncientGeek 5.1.1.1

          Yeah it breaks the javascript whilst setting up the action. The underlying link is still there.

          Can’t remember about Opera. But in Chrome (similar in Firefox) you can just right click the cancel, go Inspect and it will give you diag split screen defaulting to the object model at the object that will show the link at some expansion. If you go into the top menu item ‘console’ it will show you javascript errors after you open things up a bit. You can use the source link to see the problem code. Clicking Pretty Print will shift from minified code to something that is slightly more readable. That is the code that I have to track down and correct. If I had to guess, it is an old non-standard Internet Explorer action that hasn’t been isolated.

  6. McFlock 6

    That bug sounds pretty nasty. They sure hit you like a brick sometimes – a particularly disgusting brick.

  7. Anker 7

    What a week for you Iprent!

    so sorry you’ve been unwell. Take it easy and thanks for getting the site up and running again

  8. KJT 8

    Appreciate the work you put in.

    I’m sure everyone else that reads the standard does also.

  9. Anne 9

    Well lprent, there WAS a brief moment of excitement around 8pm last night. Muttonbird joined Adrian Thornton in the list of comments. Two of them instead of just one! Definitely a step in the right direction.laughing

  10. Jenny how to get there 10

    There is no doubt in my mind that you are running a valuable and important public service.
    I feel it would be churlish to simply go back into BAU commenting, and debating, and airing my views, that this site furnishes myself and others, without remarking on this remarkable act of public service that you provide.
    What more can I say, really.
    Other than saying, long may it last.

  11. Molly 11

    Appreciate your efforts in running and maintaining this site, and the stamina and doggedness in getting it back up when you were unwell.

    We could all have waited till you were back on form, but I was delighted to see The Standard back online again. Thanks.

  12. ianmac 12

    Missed the site. Hope your bug gives you a rest. Thanks so much for providing this site, even if the computer technology is way out of my understanding.

  13. Ad 13

    Very sorry to hear how poorly you have been Lyn. Still, 3 kgs is 3 kgs.

    Thanks again for your tireless work supporting this venue.

  14. left for dead 14

    I too wish you well and to your work keeping The Standard available.regards Alex

  15. Drowsy M. Kram 15

    Thanks for all your good works Lyn, really appreciated – be well soon.

Recent Comments

Recent Posts

  • $41m to support clean energy in South East Asia
    New Zealand is demonstrating its commitment to reducing global greenhouse emissions, and supporting clean energy transition in South East Asia, through a contribution of NZ$41 million (US$25 million) in climate finance to the Asian Development Bank (ADB)-led Energy Transition Mechanism (ETM). Prime Minister Christopher Luxon and Climate Change Minister Simon Watts announced ...
    BeehiveBy beehive.govt.nz
    3 hours ago
  • Minister releases Fast-track stakeholder list
    The Government is today releasing a list of organisations who received letters about the Fast-track applications process, says RMA Reform Minister Chris Bishop. “Recently Ministers and agencies have received a series of OIA requests for a list of organisations to whom I wrote with information on applying to have a ...
    BeehiveBy beehive.govt.nz
    5 hours ago
  • Judicial appointments announced
    Attorney-General Judith Collins today announced the appointment of Wellington Barrister David Jonathan Boldt as a Judge of the High Court, and the Honourable Justice Matthew Palmer as a Judge of the Court of Appeal. Justice Boldt graduated with an LLB from Victoria University of Wellington in 1990, and also holds ...
    BeehiveBy beehive.govt.nz
    5 hours ago
  • Education Minister heads to major teaching summit in Singapore
    Education Minister Erica Stanford will lead the New Zealand delegation at the 2024 International Summit on the Teaching Profession (ISTP) held in Singapore. The delegation includes representatives from the Post Primary Teachers’ Association (PPTA) Te Wehengarua and the New Zealand Educational Institute (NZEI) Te Riu Roa.  The summit is co-hosted ...
    BeehiveBy beehive.govt.nz
    6 hours ago
  • Value of stopbank project proven during cyclone
    A stopbank upgrade project in Tairawhiti partly funded by the Government has increased flood resilience for around 7000ha of residential and horticultural land so far, Regional Development Minister Shane Jones says. Mr Jones today attended a dawn service in Gisborne to mark the end of the first stage of the ...
    BeehiveBy beehive.govt.nz
    6 hours ago
  • Anzac commemorations, Türkiye relationship focus of visit
    Foreign Affairs Minister Winston Peters will represent the Government at Anzac Day commemorations on the Gallipoli Peninsula next week and engage with senior representatives of the Turkish government in Istanbul.    “The Gallipoli campaign is a defining event in our history. It will be a privilege to share the occasion ...
    BeehiveBy beehive.govt.nz
    7 hours ago
  • Minister to Europe for OECD meeting, Anzac Day
    Science, Innovation and Technology and Defence Minister Judith Collins will next week attend the OECD Science and Technology Ministerial conference in Paris and Anzac Day commemorations in Belgium. “Science, innovation and technology have a major role to play in rebuilding our economy and achieving better health, environmental and social outcomes ...
    BeehiveBy beehive.govt.nz
    9 hours ago
  • Comprehensive Partnership the goal for NZ and the Philippines
    Prime Minister Christopher Luxon held a bilateral meeting today with the President of the Philippines, Ferdinand Marcos Jr.  The Prime Minister was accompanied by MP Paulo Garcia, the first Filipino to be elected to a legislature outside the Philippines. During today’s meeting, Prime Minister Luxon and President Marcos Jr discussed opportunities to ...
    BeehiveBy beehive.govt.nz
    20 hours ago
  • Government commits $20m to Westport flood protection
    The Government has announced that $20 million in funding will be made available to Westport to fund much needed flood protection around the town. This measure will significantly improve the resilience of the community, says Local Government Minister Simeon Brown. “The Westport community has already been allocated almost $3 million ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Taupō takes pole position
    The Government is proud to support the first ever Repco Supercars Championship event in Taupō as up to 70,000 motorsport fans attend the Taupō International Motorsport Park this weekend, says Economic Development Minister Melissa Lee. “Anticipation for the ITM Taupō Super400 is huge, with tickets and accommodation selling out weeks ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Cost of living support for low-income homeowners
    Local Government Minister Simeon Brown has announced an increase to the Rates Rebate Scheme, putting money back into the pockets of low-income homeowners.  “The coalition Government is committed to bringing down the cost of living for New Zealanders. That includes targeted support for those Kiwis who are doing things tough, such ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Government backing mussel spat project
    The Coalition Government is investing in a project to boost survival rates of New Zealand mussels and grow the industry, Oceans and Fisheries Minister Shane Jones has announced. “This project seeks to increase the resilience of our mussels and significantly boost the sector’s productivity,” Mr Jones says. “The project - ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Government focused on getting people into work
    Benefit figures released today underscore the importance of the Government’s plan to rebuild the economy and have 50,000 fewer people on Jobseeker Support, Social Development and Employment Minister Louise Upston says. “Benefit numbers are still significantly higher than when National was last in government, when there was about 70,000 fewer ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Clean energy key driver to reducing emissions
    The Government’s commitment to doubling New Zealand’s renewable energy capacity is backed by new data showing that clean energy has helped the country reach its lowest annual gross emissions since 1999, Climate Change Minister Simon Watts says. New Zealand’s latest Greenhouse Gas Inventory (1990-2022) published today, shows gross emissions fell ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Earthquake-prone buildings review brought forward
    The Government is bringing the earthquake-prone building review forward, with work to start immediately, and extending the deadline for remediations by four years, Building and Construction Minister Chris Penk says. “Our Government is focused on rebuilding the economy. A key part of our plan is to cut red tape that ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Thailand and NZ to agree to Strategic Partnership
    Prime Minister Christopher Luxon and his Thai counterpart, Prime Minister Srettha Thavisin, have today agreed that New Zealand and the Kingdom of Thailand will upgrade the bilateral relationship to a Strategic Partnership by 2026. “New Zealand and Thailand have a lot to offer each other. We have a strong mutual desire to build ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Government consults on extending coastal permits for ports
    RMA Reform Minister Chris Bishop and Transport Minister Simeon Brown have today announced the Coalition Government’s intention to extend port coastal permits for a further 20 years, providing port operators with certainty to continue their operations. “The introduction of the Resource Management Act in 1991 required ports to obtain coastal ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Inflation coming down, but more work to do
    Today’s announcement that inflation is down to 4 per cent is encouraging news for Kiwis, but there is more work to be done - underlining the importance of the Government’s plan to get the economy back on track, acting Finance Minister Chris Bishop says. “Inflation is now at 4 per ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • School attendance restored as a priority in health advice
    Refreshed health guidance released today will help parents and schools make informed decisions about whether their child needs to be in school, addressing one of the key issues affecting school attendance, says Associate Education Minister David Seymour. In recent years, consistently across all school terms, short-term illness or medical reasons ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Unnecessary bureaucracy cut in oceans sector
    Oceans and Fisheries Minister Shane Jones is streamlining high-level oceans management while maintaining a focus on supporting the sector’s role in the export-led recovery of the economy. “I am working to realise the untapped potential of our fishing and aquaculture sector. To achieve that we need to be smarter with ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Patterson promoting NZ’s wool sector at International Congress
    Associate Agriculture Minister Mark Patterson is speaking at the International Wool Textile Organisation Congress in Adelaide, promoting New Zealand wool, and outlining the coalition Government’s support for the revitalisation the sector.    "New Zealand’s wool exports reached $400 million in the year to 30 June 2023, and the coalition Government ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Removing red tape to help early learners thrive
    The Government is making legislative changes to make it easier for new early learning services to be established, and for existing services to operate, Associate Education Minister David Seymour says. The changes involve repealing the network approval provisions that apply when someone wants to establish a new early learning service, ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • RMA changes to cut coal mining consent red tape
    Changes to the Resource Management Act will align consenting for coal mining to other forms of mining to reduce barriers that are holding back economic development, Resources Minister Shane Jones says. “The inconsistent treatment of coal mining compared with other extractive activities is burdensome red tape that fails to acknowledge ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • McClay reaffirms strong NZ-China trade relationship
    Trade, Agriculture and Forestry Minister Todd McClay has concluded productive discussions with ministerial counterparts in Beijing today, in support of the New Zealand-China trade and economic relationship. “My meeting with Commerce Minister Wang Wentao reaffirmed the complementary nature of the bilateral trade relationship, with our Free Trade Agreement at its ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Prime Minister Luxon acknowledges legacy of Singapore Prime Minister Lee
    Prime Minister Christopher Luxon today paid tribute to Singapore’s outgoing Prime Minister Lee Hsien Loong.   Meeting in Singapore today immediately before Prime Minister Lee announced he was stepping down, Prime Minister Luxon warmly acknowledged his counterpart’s almost twenty years as leader, and the enduring legacy he has left for Singapore and South East ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • PMs Luxon and Lee deepen Singapore-NZ ties
    Prime Minister Christopher Luxon held a bilateral meeting today with Singapore Prime Minister Lee Hsien Loong. While in Singapore as part of his visit to South East Asia this week, Prime Minister Luxon also met with Singapore President Tharman Shanmugaratnam and will meet with Deputy Prime Minister Lawrence Wong.  During today’s meeting, Prime Minister Luxon ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Antarctica New Zealand Board appointments
    Foreign Minister Winston Peters has made further appointments to the Board of Antarctica New Zealand as part of a continued effort to ensure the Scott Base Redevelopment project is delivered in a cost-effective and efficient manner.  The Minister has appointed Neville Harris as a new member of the Board. Mr ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Finance Minister travels to Washington DC
    Finance Minister Nicola Willis will travel to the United States on Tuesday to attend a meeting of the Five Finance Ministers group, with counterparts from Australia, the United States, Canada, and the United Kingdom.  “I am looking forward to meeting with our Five Finance partners on how we can work ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Pet bonds a win/win for renters and landlords
    The coalition Government has today announced purrfect and pawsitive changes to the Residential Tenancies Act to give tenants with pets greater choice when looking for a rental property, says Housing Minister Chris Bishop. “Pets are important members of many Kiwi families. It’s estimated that around 64 per cent of New ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Long Tunnel for SH1 Wellington being considered
    State Highway 1 (SH1) through Wellington City is heavily congested at peak times and while planning continues on the duplicate Mt Victoria Tunnel and Basin Reserve project, the Government has also asked NZ Transport Agency (NZTA) to consider and provide advice on a Long Tunnel option, Transport Minister Simeon Brown ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • New Zealand condemns Iranian strikes
    Prime Minister Christopher Luxon and Foreign Minister Winston Peters have condemned Iran’s shocking and illegal strikes against Israel.    “These attacks are a major challenge to peace and stability in a region already under enormous pressure," Mr Luxon says.    "We are deeply concerned that miscalculation on any side could ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Huge interest in Government’s infrastructure plans
    Hundreds of people in little over a week have turned out in Northland to hear Regional Development Minister Shane Jones speak about plans for boosting the regional economy through infrastructure. About 200 people from the infrastructure and associated sectors attended an event headlined by Mr Jones in Whangarei today. Last ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Health Minister thanks outgoing Health New Zealand Chair
    Health Minister Dr Shane Reti has today thanked outgoing Health New Zealand – Te Whatu Ora Chair Dame Karen Poutasi for her service on the Board.   “Dame Karen tendered her resignation as Chair and as a member of the Board today,” says Dr Reti.  “I have asked her to ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Roads of National Significance planning underway
    The NZ Transport Agency (NZTA) has signalled their proposed delivery approach for the Government’s 15 Roads of National Significance (RoNS), with the release of the State Highway Investment Proposal (SHIP) today, Transport Minister Simeon Brown says.  “Boosting economic growth and productivity is a key part of the Government’s plan to ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Navigating an unstable global environment
    New Zealand is renewing its connections with a world facing urgent challenges by pursuing an active, energetic foreign policy, Foreign Minister Winston Peters says.   “Our country faces the most unstable global environment in decades,” Mr Peters says at the conclusion of two weeks of engagements in Egypt, Europe and the United States.    “We cannot afford to sit back in splendid ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • NZ welcomes Australian Governor-General
    Prime Minister Christopher Luxon has announced the Australian Governor-General, His Excellency General The Honourable David Hurley and his wife Her Excellency Mrs Linda Hurley, will make a State visit to New Zealand from Tuesday 16 April to Thursday 18 April. The visit reciprocates the State visit of former Governor-General Dame Patsy Reddy ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Pseudoephedrine back on shelves for Winter
    Associate Health Minister David Seymour has announced that Medsafe has approved 11 cold and flu medicines containing pseudoephedrine. Pharmaceutical suppliers have indicated they may be able to supply the first products in June. “This is much earlier than the original expectation of medicines being available by 2025. The Government recognised ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • NZ and the US: an ever closer partnership
    New Zealand and the United States have recommitted to their strategic partnership in Washington DC today, pledging to work ever more closely together in support of shared values and interests, Foreign Minister Winston Peters says.    “The strategic environment that New Zealand and the United States face is considerably more ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Joint US and NZ declaration
    April 11, 2024 Joint Declaration by United States Secretary of State the Honorable Antony J. Blinken and New Zealand Minister of Foreign Affairs the Right Honourable Winston Peters We met today in Washington, D.C. to recommit to the historic partnership between our two countries and the principles that underpin it—rule ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • NZ and US to undertake further practical Pacific cooperation
    Foreign Minister Winston Peters has announced further New Zealand cooperation with the United States in the Pacific Islands region through $16.4 million in funding for initiatives in digital connectivity and oceans and fisheries research.   “New Zealand can achieve more in the Pacific if we work together more urgently and ...
    BeehiveBy beehive.govt.nz
    1 week ago

Page generated in The Standard by Wordpress at 2024-04-19T06:53:41+00:00