web analytics

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.

Leave a Comment

Recent Comments

Recent Posts

  • Government support screen industry with funding for sound stages in West Auckland
    Auckland Film Studios in West Auckland has received funding for a major expansion through the Government’s Infrastructure Reference Group’s (IRG) COVID-19 Response Fund. The Government is investing $30 million of a total $35 million project to construct two 2,000sqm sound stages and development of further workshops and offices, to expand ...
    BeehiveBy beehive.govt.nz
    11 hours ago
  • Protecting unique land for generation next
    The Government is boosting legal protection for critically important natural habitats on private land, Minister of Conservation Kiri Allan says. “An $8 million investment over four years will see Queen Elizabeth II National Trust Ngā Kairauhī Papa (QEII) work with government agencies, councils and others to provide legal protection of ...
    BeehiveBy beehive.govt.nz
    13 hours ago
  • New Zealand’s support for Fiji’s COVID-19 response continues with vaccine delivery, operational ...
    Foreign Minister Nanaia Mahuta has announced further support for Fiji, including funding support for nursing staff and 100,000 doses of vaccines due to arrive in country today. “Our thoughts remain with Fiji during this incredibly challenging period,” Nanaia Mahuta said. “New Zealand has funded 100,000 doses of the AstraZeneca vaccine ...
    BeehiveBy beehive.govt.nz
    13 hours ago
  • Poroporoaki: Dr Hōhepa (Joe) Mason
    Ko koe tēnā e te hurumanu e Hōhepa, te tōwenetanga a te iti, te māpihi herenga mahara o te tini, ka tauawhi tonuhia koe e to iwi ki te uma pupuri ai. Me pēhea he kupu kia koutou kua puta i nga ākinga a nga tau kua hori, kua waia ...
    BeehiveBy beehive.govt.nz
    17 hours ago
  • Finance Minister and RBNZ Governor agree to update MOU on macro-prudential policy
    Finance Minister Grant Robertson and Reserve Bank Governor Adrian Orr have updated the Memorandum of Understanding (MoU) on macro-prudential policy to further protect the financial system and support the Government’s housing objectives. “This change will ensure that the Reserve Bank has the flexibility to respond to emerging financial stability risks ...
    BeehiveBy beehive.govt.nz
    17 hours ago
  • Government commits further assistance for drought and flood-affected rural communities
    Farmers and growers affected by this year’s drought or floods in Marlborough, Tasman, West Coat, Canterbury, Otago and the Chatham Islands will have access to Rural Assistance Payments (RAPs) from today, Social Development and Employment Minister Carmel Sepuloni has announced. “The Government is committed to easing the financial pressures on ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Cook Islands youth lead Language Week
    The Cook Islands Language Week theme for 2021 highlights the vital role language plays in maintaining young people’s links to their Pacific home, said Minister for Pacific Peoples Aupito William Sio.  “The Epetoma o te reo Māori Kūki ‘Āirani – Cook Islands Language Week – theme is ‘Ātuitui’ia au ki ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Government offers formal apology for Dawn Raids
    A formal and unreserved apology for the Dawn Raids The Government will offer education scholarships as part of the apology Manaaki New Zealand Short Term Scholarship Training courses Support Pacific artists and historians to develop a comprehensive written and oral account of the Dawn Raids Prime Minister Jacinda Ardern has ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Speech to Dawn Raids Apology
    Tēnā koutou katoa, Kia orana kotou katoatoa, Fakaalofa lahi atu ki mutolu oti, Tālofa nī, Mālō nī koutou, Ni sa bula vinaka, Fakatalofa atu, Noa'ia 'e mauri, Kam na mauri, Malo e lelei, Sioto'ofa, Mālō lava le lagi e mamā ma le soifua maua, Oue tulou, tulou atu, tulouna lava ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Bridging the gap – last piece of Northcote Safe Cycle Route now complete
    The opening of two bridges over Auckland’s Northern Motorway is the last link of a cycling and walking route which provides a safe, active alternative for students and commuters, Transport Minister Michael Wood said today. Michael Wood cut the ribbon for the completion of the Northcote Safe Cycle Route, at ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Progress in establishment of Aged Care Commissioner
    Recruitment for an Aged Care Commissioner will start next month, to ensure greater oversight of New Zealand’s aged care sector. “This sector is responsible for supporting a large and often vulnerable population. While most people are able to access quality care, there have been cases where that care has fallen ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • New record number of homes consented
    In the year ended June 2021, the actual number of new dwellings consented was 44,299, up 18 percent from the June 2020 year. In June 2021, the seasonally adjusted number of new dwellings consented rose 3.8 percent. In June 2021, 4,310 new dwellings were consented, an increase of 3.8 per ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Communities backed to tackle wilding pines
    Twelve community projects across New Zealand will receive a share of $2 million to carry out wilding pine control, Biosecurity Minister Damien O’Connor announced as part of Biosecurity Week. “Wilding pines are a serious problem that threaten many of the unique landscapes that New Zealanders value. Community groups and trusts ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Health Minister Andrew Little responding to the New Zealand Nurses Organisation's rejection of ...
    I was advised last night that the result of the ballot of Tōpūtanga Tapuhi Kaitiaki o Aotearoa New Zealand Nurses Organisation members have rejected the latest proposal to settle their collective agreement. Let me be clear: the proposal was one they put to the Government. The Nurses Organisation rejected their ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Conversion Practices Prohibition Legislation introduced to Parliament
    Legislation has been introduced to Parliament to protect against practices intended to change or suppress someone’s sexual orientation, gender identity, or gender expression. Introducing the Conversion Practices Prohibition Legislation Bill, Minister of Justice, Kris Faafoi, said the measures proposed were aimed at ending conversion practices which don’t work, are widely ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • New kaupapa Māori mental health and addiction services to support people in central North Island
    New mental health and addiction services rolling out across the central North Island will improve outcomes and equity for Māori, Associate Minister of Health (Māori Health) Peeni Henare says. Today the Minister met with providers of the new kaupapa Māori primary mental health and addiction service, Poutama Ora, which will ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • New school site for booming West Auckland
    The Government will build on a new school site in West Auckland to cope with rapid population growth in the area, Education Minister Chris Hipkins says. The Ministry is working with existing local schools to determine how the 1.5-hectare site at 279 Hobsonville Point Road will be used to support ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Trans-Tasman travel window to close at midnight tomorrow
    A further 500 MIQ rooms released for managed returnees from NSW Further Government actions announced today are balanced to provide more certainty for Kiwis wanting to return from Australia, while continuing to protect New Zealand from COVID-19, acting Minister for COVID-19 Response Ayesha Verrall says. The actions were foreshadowed last ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Govt investing millions in Hawke's Bay and Tairāwhiti schools
    Napier Boys’ and Girls’ High Schools are among those set to benefit from a $16.5 million investment in the Hawke's Bay and Tairāwhiti region, Economic and Regional Development Minister Stuart Nash announced today. The Government has set aside money in Budget 2021 to accelerate five projects in Napier, Hastings, Havelock North ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Game changing Jobs for Nature investment for Northland
    Conservation Minister Kiri Allan has announced Jobs for Nature funding for a portfolio of projects that will create ‘game changing’ gains for nature and communities across Northland/Te Tai Tokerau as part of the Government’s acceleration of the economic recovery from COVID. “This portfolio of 12 projects will see over $20 ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Third COVID-19 vaccine receives provisional approval
    New Zealand’s regulatory authority Medsafe has granted provisional approval of the AstraZeneca COVID-19 vaccine for individuals 18 years of age and older, Acting Minister for COVID-19 Response Dr Ayesha Verrall announced today. New Zealand secured 7.6 million doses (enough for 3.8 million people) of the AstraZeneca COVID-19 vaccine through an ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Bowel-cancer screening programme is saving lives
    More than 1000 New Zealanders have had bowel cancer – New Zealand’s second-most-common cause of death from cancer - detected under the Government’s National Bowel Screening Programme, Health Minister Andrew Little said today. More than 1200 New Zealanders died from bowel cancer in 2017. The screening programme aims to save ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Govt welcomes draft report on the retail grocery sector
    The Commerce Commission’s draft report into the retail grocery sector is being welcomed by Government as a major milestone. “I asked the Commerce Commission to look at whether this sector is as competitive as it could be and today it has released its draft report for consultation,” Commerce and Consumer ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Christchurch’s Youth Hub ‘set to go’ thanks to further Government funding
    Construction of New Zealand’s first, purpose-built centre for youth well-being is ready to get underway thanks to an extra $2.5 million of COVID-19 response funding, Housing Minister and Associate Minister of Finance, Megan Woods announced today.  “The Christchurch Youth Hub is about bringing together all the things young people need ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Next step to protect Milford Sound Piopiotahi
    Expert group lays out plan to better protect iconic UNESCO World Heritage site Milford Sound Piopiotahi and its surrounds Funding confirmed for dedicated unit and Establishment Board to assess the recommendations and provide oversight of the process from here Milford Opportunities Project a test case for transformational change in tourism ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • Funding for projects to reduce waste from construction and demolition
    The Government has announced funding for projects in Auckland and the lower North Island to help reduce construction and demolition waste. “Construction is the main source of waste sent to landfill, and much of this could be reduced, reused and recovered,” Environment Minister David Parker said. “The Government is funding ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • Speech at the launch of the National Hepatitis C Action Plan
    Tēnā koutou katoa. Thank you Anglesea Pharmacy and Te Manawa Taki for hosting this event. As a doctor, I saw first hand the impact of hepatitis C. I met Moana in 2019; she came to the infectious diseases outpatient clinic at Wellington Hospital having tested positive for hepatitis C. Like ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • Plan to eliminate hepatitis C as a major health threat by 2030
    A plan to eliminate hepatitis C in New Zealand, reducing liver cancer and the need for liver transplants, has been released today by Associate Minister of Health Dr Ayesha Verrall. “Around 45,000 New Zealanders have hepatitis C, but only around half know they have it,” said Ayesha Verrall. “Symptoms often ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • School upgrades and new classrooms for West Coast, Tasman and Canterbury
    A funding injection from Budget 2021 to complete four shovel ready projects and new classrooms at six schools and kura will provide a real boost to local communities, Minister Dr Megan Woods announced today. “This Government has committed to providing quality fit for purpose learning environments and 100,000 new student ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • Warmer Kiwi Homes smashes annual target
    The Government's highly successful insulation and heating programme, Warmer Kiwi Homes, is celebrating a key milestone with the completion of more than 38,000 insulation and efficient heater installs in the year to the end of June, smashing its target of 25,000 installs for the year. “The Warmer Kiwi Homes scheme ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Exemption granted for Wallabies to enter NZ
    Bledisloe Cup rugby will be played in New Zealand after the Australian rugby team received an economic exemption to enter New Zealand. Travel between Australia and New Zealand was suspended on Friday for at least eight weeks following the worsening of the COVID outbreak across the Tasman. New Zealanders have ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Minister of Foreign Affairs makes three diplomatic appointments
    Foreign Affairs Minister Nanaia Mahuta today announced three New Zealand Head of Mission appointments. They are: Mike Walsh as Ambassador to Iran Michael Upton as Ambassador to Ethiopia and the African Union Kevin Burnett as Ambassador to Indonesia Iran “Aotearoa New Zealand has a long-standing and constructive relationship with Iran, despite a ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Enhanced Task Force Green Approved for West Coast and Marlborough
    The Government has activated Enhanced Task Force Green (ETFG) in response to the West Coast and Marlborough floods, Social Development and Employment Minister Carmel Sepuloni announced today. “To assist with the clean-up, up to $500,000 will be made available to support the recovery in Buller and Marlborough which has experienced ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Govt support for upgrade of Eden Park players facilities
    Minister for Sport and Recreation Hon Grant Robertson has announced funding to upgrade the players facilities at Eden Park ahead of upcoming Women’s World Cup events. Eden Park is a confirmed venue for the Rugby World Cup 2021, the ICC Women’s Cricket World Cup 2022, and a proposed venue for matches of ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • More jobs and quicker public transport motoring towards West Auckland
    Work to improve public transport for West Aucklanders and support the region’s economic recovery by creating hundreds of jobs has officially kicked off, Transport Minister Michael Wood announced today. Michael Wood and Auckland Mayor Phil Goff this morning marked the start of construction on the Northwestern Bus Improvements project. It ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Government backs critical health research
    Research into some of New Zealanders’ biggest health concerns including cancer, diabetes, and heart disease is getting crucial support in the latest round of health research funding, Health Minister Andrew Little announced today. The funding, awarded through the Health Research Council of New Zealand, covers 31 General Project grants ($36.64 ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • New Bay of Islands hospital facilities to bring services closer to home
    Prime Minister Jacinda Ardern and Health Minister Andrew Little have joined a ceremony to bless the site and workers for Phase Two of the redevelopment of the Bay of Islands Hospital in Kawakawa today. The new building will house outpatients and primary care facilities, as well as expanded renal care ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Raukokore re-imagined with ‘smart’ relocatable rent to own housing
    Iwi, Crown Partnership Relocatable, fully insulated housing, connected to a new solar plant Provides a pathway to home ownership New housing in the remote eastern Bay of Plenty community of Raukokore shows how iwi and Crown agencies can work together effectively to provide warm, dry, energy efficient homes in a ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Cabinet accepts Turkish authorities’ request for the managed return of three NZ citizens
    Cabinet has agreed to the managed return of a New Zealand citizen and her two young children from Turkey, Prime Minister Jacinda Ardern announced today. The three have been in immigration detention in Turkey since crossing the border from Syria earlier this year. Turkey has requested that New Zealand repatriate ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Govt delivers more classrooms so children can focus on learning
    Extra Government investment in classrooms and school building projects will enable students and teachers to focus on education rather than overcrowding as school rolls grow across the country, Prime Minister Jacinda Ardern and Associate Education Minister Kelvin Davis say. The pair visited Ruakākā School in Whangārei today to announce $100 ...
    BeehiveBy beehive.govt.nz
    1 week ago