Humans have energy, but not water. What happens?












5












$begingroup$


Suppose that through a "hand-wavium" genetic engineering coupled with nanotechnology the humanity was able to develop a body battery.



How does this work? It provides enough energy for the human body. No need to use glycogen/glucose ATP mechanism.



Let's suppose that heat regulation is also solved by this technology.



I suppose humans would still need to feed themselves (because of proteins/vitamins/minerals) and drink water.



So what would happen if this battery-human is lost in a desert without access to water? Would he/she die as fast as a regular human? What would be the difference? How can this be circumvented?






technology humans energy-beings







share|improve this question









$endgroup$












  • $begingroup$
    Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
    $endgroup$
    – JBH
    5 hours ago










  • $begingroup$
    @JBH To my eyes, they are the same question asked 3 different ways...
    $endgroup$
    – Arkenstein XII
    5 hours ago










  • $begingroup$
    @ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
    $endgroup$
    – JBH
    5 hours ago






  • 4




    $begingroup$
    Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
    $endgroup$
    – Cadence
    5 hours ago










  • $begingroup$
    What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
    $endgroup$
    – Mazura
    2 hours ago


















5












$begingroup$


Suppose that through a "hand-wavium" genetic engineering coupled with nanotechnology the humanity was able to develop a body battery.



How does this work? It provides enough energy for the human body. No need to use glycogen/glucose ATP mechanism.



Let's suppose that heat regulation is also solved by this technology.



I suppose humans would still need to feed themselves (because of proteins/vitamins/minerals) and drink water.



So what would happen if this battery-human is lost in a desert without access to water? Would he/she die as fast as a regular human? What would be the difference? How can this be circumvented?






technology humans energy-beings







share|improve this question









$endgroup$












  • $begingroup$
    Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
    $endgroup$
    – JBH
    5 hours ago










  • $begingroup$
    @JBH To my eyes, they are the same question asked 3 different ways...
    $endgroup$
    – Arkenstein XII
    5 hours ago










  • $begingroup$
    @ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
    $endgroup$
    – JBH
    5 hours ago






  • 4




    $begingroup$
    Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
    $endgroup$
    – Cadence
    5 hours ago










  • $begingroup$
    What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
    $endgroup$
    – Mazura
    2 hours ago
















5












5








5


1



$begingroup$


Suppose that through a "hand-wavium" genetic engineering coupled with nanotechnology the humanity was able to develop a body battery.



How does this work? It provides enough energy for the human body. No need to use glycogen/glucose ATP mechanism.



Let's suppose that heat regulation is also solved by this technology.



I suppose humans would still need to feed themselves (because of proteins/vitamins/minerals) and drink water.



So what would happen if this battery-human is lost in a desert without access to water? Would he/she die as fast as a regular human? What would be the difference? How can this be circumvented?






technology humans energy-beings







share|improve this question









$endgroup$




Suppose that through a "hand-wavium" genetic engineering coupled with nanotechnology the humanity was able to develop a body battery.



How does this work? It provides enough energy for the human body. No need to use glycogen/glucose ATP mechanism.



Let's suppose that heat regulation is also solved by this technology.



I suppose humans would still need to feed themselves (because of proteins/vitamins/minerals) and drink water.



So what would happen if this battery-human is lost in a desert without access to water? Would he/she die as fast as a regular human? What would be the difference? How can this be circumvented?






technology humans energy-beings




technology humans energy-beings






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 5 hours ago









ChaoticChaotic

437414




437414












  • $begingroup$
    Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
    $endgroup$
    – JBH
    5 hours ago










  • $begingroup$
    @JBH To my eyes, they are the same question asked 3 different ways...
    $endgroup$
    – Arkenstein XII
    5 hours ago










  • $begingroup$
    @ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
    $endgroup$
    – JBH
    5 hours ago






  • 4




    $begingroup$
    Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
    $endgroup$
    – Cadence
    5 hours ago










  • $begingroup$
    What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
    $endgroup$
    – Mazura
    2 hours ago




















  • $begingroup$
    Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
    $endgroup$
    – JBH
    5 hours ago










  • $begingroup$
    @JBH To my eyes, they are the same question asked 3 different ways...
    $endgroup$
    – Arkenstein XII
    5 hours ago










  • $begingroup$
    @ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
    $endgroup$
    – JBH
    5 hours ago






  • 4




    $begingroup$
    Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
    $endgroup$
    – Cadence
    5 hours ago










  • $begingroup$
    What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
    $endgroup$
    – Mazura
    2 hours ago


















$begingroup$
Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
$endgroup$
– JBH
5 hours ago




$begingroup$
Hello Chaotic. Please remember that SE's model is one-specific-question/one-best-answer. I count 3 questions. Could you narrow your question to just one?
$endgroup$
– JBH
5 hours ago












$begingroup$
@JBH To my eyes, they are the same question asked 3 different ways...
$endgroup$
– Arkenstein XII
5 hours ago




$begingroup$
@JBH To my eyes, they are the same question asked 3 different ways...
$endgroup$
– Arkenstein XII
5 hours ago












$begingroup$
@ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
$endgroup$
– JBH
5 hours ago




$begingroup$
@ArkensteinXII,(a) would a person die as quickly as an unmodified person? is a yes/no question. (b) what's the difference? is similar and might be considered the same. (c) How can this be circumvented? is an entirely different question. Good question behavior is to ask just one question to remove ambiguity and reduce the likelihood of being closed as too-broad.
$endgroup$
– JBH
5 hours ago




4




4




$begingroup$
Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
$endgroup$
– Cadence
5 hours ago




$begingroup$
Could you explain what you mean by "suppose that heat regulation is also solved"? Do you mean that the human is completely immune to hot and cold environments, or just that we shouldn't worry about the heat generated by the battery itself?
$endgroup$
– Cadence
5 hours ago












$begingroup$
What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
$endgroup$
– Mazura
2 hours ago






$begingroup$
What happens is WWIII. How that can be circumvented is still up in the air. - What would happen to a human who doesn't need to eat food, lost in a desert without access to water? The average is three days without water, and a few weeks w/o food.
$endgroup$
– Mazura
2 hours ago












3 Answers
3






active

oldest

votes


















10












$begingroup$

They would die of thirst just like any other human.



Consider: an unmodified human can live about a month without food. You won't be living very well after a month with no food, but it can be done.



On the other hand, you will die after mere days without water.



Simply put, access to energy is not a limiting factor over the same timescales that access to water is. Human bodies already have tons of stored energy that could have kept us going long after we otherwise die of dehydration. So, for these purposes, the body battery is completely irrelevant.






share|improve this answer









$endgroup$









  • 3




    $begingroup$
    I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
    $endgroup$
    – Tim B II
    4 hours ago






  • 2




    $begingroup$
    The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
    $endgroup$
    – corsiKa
    2 hours ago



















3












$begingroup$

Water is used for other things besides the Krebbs cycle and respiration. It is structural. The citoplasma in human cells and blood plasma are mostly water. Water is also used in osmoregulation and thermoregulation.



Your superhero may endup dead faster than a regular person in a desert. When I think of batteries, I usually think of three things:




  • Chemical wastes, which need to be eliminated from the body through urine, sweat or feces (which will require some water);

  • Heat - the battery will be generating it, and guess what the body will use as a heat sink?

  • One of Metallica's best songs, but that's neither here nor there.


Bottom line being, this thing will not save you water. You've probably installed it to be able to draw more muscle power or whatever, so you are probably drying up faster as a consequence.






share|improve this answer











$endgroup$





















    1












    $begingroup$

    They would be fine.



    In the desert, it is hot, and there is no water. However since you're using hand-wavium, and apparently the "heat regulation" problem is solved, then there shouldn't be a problem with surviving in the desert.



    Unless:




    1. The heat regulation properties of the technology need water to operate. Like if they still sweat.

    2. The technology stops operating properly at high temperatures.

    3. They need water to survive for some other reason, like expelling liquid waste.






    share|improve this answer









    $endgroup$













      Your Answer





      StackExchange.ifUsing("editor", function () {
      return StackExchange.using("mathjaxEditing", function () {
      StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
      StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
      });
      });
      }, "mathjax-editing");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "579"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      noCode: true, onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fworldbuilding.stackexchange.com%2fquestions%2f141439%2fhumans-have-energy-but-not-water-what-happens%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      3 Answers
      3






      active

      oldest

      votes








      3 Answers
      3






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      10












      $begingroup$

      They would die of thirst just like any other human.



      Consider: an unmodified human can live about a month without food. You won't be living very well after a month with no food, but it can be done.



      On the other hand, you will die after mere days without water.



      Simply put, access to energy is not a limiting factor over the same timescales that access to water is. Human bodies already have tons of stored energy that could have kept us going long after we otherwise die of dehydration. So, for these purposes, the body battery is completely irrelevant.






      share|improve this answer









      $endgroup$









      • 3




        $begingroup$
        I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
        $endgroup$
        – Tim B II
        4 hours ago






      • 2




        $begingroup$
        The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
        $endgroup$
        – corsiKa
        2 hours ago
















      10












      $begingroup$

      They would die of thirst just like any other human.



      Consider: an unmodified human can live about a month without food. You won't be living very well after a month with no food, but it can be done.



      On the other hand, you will die after mere days without water.



      Simply put, access to energy is not a limiting factor over the same timescales that access to water is. Human bodies already have tons of stored energy that could have kept us going long after we otherwise die of dehydration. So, for these purposes, the body battery is completely irrelevant.






      share|improve this answer









      $endgroup$









      • 3




        $begingroup$
        I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
        $endgroup$
        – Tim B II
        4 hours ago






      • 2




        $begingroup$
        The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
        $endgroup$
        – corsiKa
        2 hours ago














      10












      10








      10





      $begingroup$

      They would die of thirst just like any other human.



      Consider: an unmodified human can live about a month without food. You won't be living very well after a month with no food, but it can be done.



      On the other hand, you will die after mere days without water.



      Simply put, access to energy is not a limiting factor over the same timescales that access to water is. Human bodies already have tons of stored energy that could have kept us going long after we otherwise die of dehydration. So, for these purposes, the body battery is completely irrelevant.






      share|improve this answer









      $endgroup$



      They would die of thirst just like any other human.



      Consider: an unmodified human can live about a month without food. You won't be living very well after a month with no food, but it can be done.



      On the other hand, you will die after mere days without water.



      Simply put, access to energy is not a limiting factor over the same timescales that access to water is. Human bodies already have tons of stored energy that could have kept us going long after we otherwise die of dehydration. So, for these purposes, the body battery is completely irrelevant.







      share|improve this answer












      share|improve this answer



      share|improve this answer










      answered 5 hours ago









      Logan R. KearsleyLogan R. Kearsley

      11k13056




      11k13056








      • 3




        $begingroup$
        I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
        $endgroup$
        – Tim B II
        4 hours ago






      • 2




        $begingroup$
        The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
        $endgroup$
        – corsiKa
        2 hours ago














      • 3




        $begingroup$
        I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
        $endgroup$
        – Tim B II
        4 hours ago






      • 2




        $begingroup$
        The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
        $endgroup$
        – corsiKa
        2 hours ago








      3




      3




      $begingroup$
      I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
      $endgroup$
      – Tim B II
      4 hours ago




      $begingroup$
      I don't know about tonnes, but I have around 20Kg more stored energy than I should have...
      $endgroup$
      – Tim B II
      4 hours ago




      2




      2




      $begingroup$
      The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
      $endgroup$
      – corsiKa
      2 hours ago




      $begingroup$
      The survival rule of 3 - 3 minutes without air, 3 days without water, 3 weeks without food. Might save your life someday!
      $endgroup$
      – corsiKa
      2 hours ago











      3












      $begingroup$

      Water is used for other things besides the Krebbs cycle and respiration. It is structural. The citoplasma in human cells and blood plasma are mostly water. Water is also used in osmoregulation and thermoregulation.



      Your superhero may endup dead faster than a regular person in a desert. When I think of batteries, I usually think of three things:




      • Chemical wastes, which need to be eliminated from the body through urine, sweat or feces (which will require some water);

      • Heat - the battery will be generating it, and guess what the body will use as a heat sink?

      • One of Metallica's best songs, but that's neither here nor there.


      Bottom line being, this thing will not save you water. You've probably installed it to be able to draw more muscle power or whatever, so you are probably drying up faster as a consequence.






      share|improve this answer











      $endgroup$


















        3












        $begingroup$

        Water is used for other things besides the Krebbs cycle and respiration. It is structural. The citoplasma in human cells and blood plasma are mostly water. Water is also used in osmoregulation and thermoregulation.



        Your superhero may endup dead faster than a regular person in a desert. When I think of batteries, I usually think of three things:




        • Chemical wastes, which need to be eliminated from the body through urine, sweat or feces (which will require some water);

        • Heat - the battery will be generating it, and guess what the body will use as a heat sink?

        • One of Metallica's best songs, but that's neither here nor there.


        Bottom line being, this thing will not save you water. You've probably installed it to be able to draw more muscle power or whatever, so you are probably drying up faster as a consequence.






        share|improve this answer











        $endgroup$
















          3












          3








          3





          $begingroup$

          Water is used for other things besides the Krebbs cycle and respiration. It is structural. The citoplasma in human cells and blood plasma are mostly water. Water is also used in osmoregulation and thermoregulation.



          Your superhero may endup dead faster than a regular person in a desert. When I think of batteries, I usually think of three things:




          • Chemical wastes, which need to be eliminated from the body through urine, sweat or feces (which will require some water);

          • Heat - the battery will be generating it, and guess what the body will use as a heat sink?

          • One of Metallica's best songs, but that's neither here nor there.


          Bottom line being, this thing will not save you water. You've probably installed it to be able to draw more muscle power or whatever, so you are probably drying up faster as a consequence.






          share|improve this answer











          $endgroup$



          Water is used for other things besides the Krebbs cycle and respiration. It is structural. The citoplasma in human cells and blood plasma are mostly water. Water is also used in osmoregulation and thermoregulation.



          Your superhero may endup dead faster than a regular person in a desert. When I think of batteries, I usually think of three things:




          • Chemical wastes, which need to be eliminated from the body through urine, sweat or feces (which will require some water);

          • Heat - the battery will be generating it, and guess what the body will use as a heat sink?

          • One of Metallica's best songs, but that's neither here nor there.


          Bottom line being, this thing will not save you water. You've probably installed it to be able to draw more muscle power or whatever, so you are probably drying up faster as a consequence.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 4 hours ago

























          answered 5 hours ago









          RenanRenan

          49.9k13115250




          49.9k13115250























              1












              $begingroup$

              They would be fine.



              In the desert, it is hot, and there is no water. However since you're using hand-wavium, and apparently the "heat regulation" problem is solved, then there shouldn't be a problem with surviving in the desert.



              Unless:




              1. The heat regulation properties of the technology need water to operate. Like if they still sweat.

              2. The technology stops operating properly at high temperatures.

              3. They need water to survive for some other reason, like expelling liquid waste.






              share|improve this answer









              $endgroup$


















                1












                $begingroup$

                They would be fine.



                In the desert, it is hot, and there is no water. However since you're using hand-wavium, and apparently the "heat regulation" problem is solved, then there shouldn't be a problem with surviving in the desert.



                Unless:




                1. The heat regulation properties of the technology need water to operate. Like if they still sweat.

                2. The technology stops operating properly at high temperatures.

                3. They need water to survive for some other reason, like expelling liquid waste.






                share|improve this answer









                $endgroup$
















                  1












                  1








                  1





                  $begingroup$

                  They would be fine.



                  In the desert, it is hot, and there is no water. However since you're using hand-wavium, and apparently the "heat regulation" problem is solved, then there shouldn't be a problem with surviving in the desert.



                  Unless:




                  1. The heat regulation properties of the technology need water to operate. Like if they still sweat.

                  2. The technology stops operating properly at high temperatures.

                  3. They need water to survive for some other reason, like expelling liquid waste.






                  share|improve this answer









                  $endgroup$



                  They would be fine.



                  In the desert, it is hot, and there is no water. However since you're using hand-wavium, and apparently the "heat regulation" problem is solved, then there shouldn't be a problem with surviving in the desert.



                  Unless:




                  1. The heat regulation properties of the technology need water to operate. Like if they still sweat.

                  2. The technology stops operating properly at high temperatures.

                  3. They need water to survive for some other reason, like expelling liquid waste.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 5 hours ago









                  MathaddictMathaddict

                  4,392532




                  4,392532






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Worldbuilding Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid …



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      Use MathJax to format equations. MathJax reference.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fworldbuilding.stackexchange.com%2fquestions%2f141439%2fhumans-have-energy-but-not-water-what-happens%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      -

                      Popular posts from this blog

                      SQL Server 17 - Attemping to backup to remote NAS but Access is denied

                      Image
                      .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0; } 0 I was attemping to use Ola Hallengrens scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the following error: TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476 ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The operating system returned the error '0x80070005(Access is denied.)&#
                      Read more

                      Always On Availability groups resolving state after failover - Remote harden of transaction...

                      Image
                      0 My explanation will be opinion based as it is based on my findings. If more information is needed, I am always happy to add it. The setup We have 4 SQL Server 2016 Instances, and all 4 underlying servers are in a WSFC (In my eyes a strange setup since Always On AG's are 2 by 2. But that is a different question.) 4 nodes + Fileshare witness Version: 13.0.5026.0 (all nodes) The instances that are having the failover issues are instances 1 & 2. They have 3 AG's between them. AG1 is primary on instance 1 and is having the issue. AG2 and AG3 are primary on instance 2. Instances 3 and 4 have their own separate AG's (2). AG1's settings The week before Last week, after checking for long running queries (none) and the synchronization state (green accross the board) we initiated a
                      Read more

                      Restoring from pg_dump with foreign key constraints

                      Image
                      5 2 In restoring a database from a pg_dump , a number of errors are being generated and the whole table is subsequently being ignored. An example: ERROR: insert or update on table "channelproducts" violates foreign key constraint "fk_rails_dfaae373a5" DETAIL: Key (channel_id)=(1) is not present in table "channels". Interestingly enough, I've noted that all these instances are popping up because of the sequence of loading. channels is after channelproducts both alphabetically and in the file and thus I can understand why postgres complains about having to create a child without a parent. caveat: the foreign key is being generated automatically by rails 4.2: I could remove the problem at the source but that still does not really solve the problem... version: PostgreSQL
                      Read more