SQL Server Performance

Posting Error

Discussion in 'Please Tell Us What You Think' started by Madhivanan, Nov 24, 2005.

  1. Madhivanan Moderator

  2. FrankKalis Moderator

  3. ghemant Moderator

    Hi,
    i don't know why it happens to you its working nice.


    Regards


    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  4. satya Moderator

    It happens sometime to me also when using quick reply (as I always use), I will use the method referred by Frank to overcome the issue or close the browser and open the page in new window.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. ranjitjain New Member

    Hi,
    Even I was getting error two days back for diffrent thread when i was pasting a code.
    The error was "connection was rest by peer" but then when i posted only text message it got posted nicely without me being login and log out again.
    No idea Y ???????????
  6. Madhivanan Moderator

    No. Still I get the same error on that thread

    Madhivanan

    Failing to plan is Planning to fail
  7. ghemant Moderator

    Hi,
    are u getting error on that particular thread !? don't know y !? but the error i had got thrice was a DEAD LOCK ERROR else i didn't face problem with forum , what browser you are using ! if IE then is it patch with latest SP and hot fix !


    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  8. Madhivanan Moderator

    I get error only on that thread. I dont know why it happens only on that thread

    Madhivanan

    Failing to plan is Planning to fail
  9. ghemant Moderator

    Hi,
    its very strange !

    Regards


    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  10. Madhivanan Moderator

    Problem solved [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  11. ghemant Moderator

    Hi,
    so what is workaround ! delete cookies !?


    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  12. Madhivanan Moderator

    No Actually I copied his procedure,paste it in QA, modified it and paste it here. Thats the problem. I typed new procedure here itself and that worked [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  13. FrankKalis Moderator

    Strange indeed. We have some kind of policy here to cleans internet content on a regular basis. So it could happen that you move from page to page and when this service runs and deletes your cookie you suddenly have no access anymore. Not sure what that will do while typing a answer and trying to post, though.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  14. ranjitjain New Member

    Really strange!!!!!!!!!
    That dint work in my case though that day
  15. ranjitjain New Member

  16. Madhivanan Moderator

    Dont copy and paste when answering
    Type there itself

    Madhivanan

    Failing to plan is Planning to fail
  17. dineshasanka Moderator

  18. Madhivanan Moderator

    Probably you copied some scripts from QA and paste them here when replying [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  19. dineshasanka Moderator

  20. ghemant Moderator

    Hi,
    i got this error today at 5:53 IST .


    quote:There has been problema
    Sorry we have flood control activated
    You cannot post within 30 second of your last post.
    Please try again after this period of time elaspse.





    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  21. Madhivanan Moderator

    If you post a reply within 30 seconds of your previous reply, you may get this error.
    I also got this error previouly. I think all snitz forums have this

    Madhivanan

    Failing to plan is Planning to fail
  22. dineshasanka Moderator

  23. ghemant Moderator

    Hi,
    i face the same problem with this particular thread ! i dont understand y it happens ! i try a lot ,remove/re-set cookies , re-set security setting of IE,re-set NIS but no luck.

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11838





    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  24. Madhivanan Moderator

    Dont copy and paste and type the message here itself

    Madhivanan

    Failing to plan is Planning to fail
  25. ghemant Moderator

    Hi Madhivanan,
    nope i don't copy / paste message rather i typed the message thrice but no luck ,. Now i am vary curious to know WHY ? because at this moment i am sitting on Different System ,Different Browser (Tried IE 6 SP1+Fixs , Mozila FireFox )


    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  26. ghemant Moderator

    Hi,<br />this time i faced the same problem with this thread :<br /><br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11844>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11844</a> ,<br />i have re-load my browser with latest patches , tried with firefox , opera but no luck !? <br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br /><br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  27. Madhivanan Moderator

    If you post the links, then type them and dont paste when answering

    Madhivanan

    Failing to plan is Planning to fail
  28. ghemant Moderator

    Hi,
    nope their was not a link , but a message i was typed , its anoying , i can't understand what happend !

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  29. Madhivanan Moderator

    Well. Refresh the page and try typing

    Madhivanan

    Failing to plan is Planning to fail
  30. ghemant Moderator

    Madhivanan,
    i have do it several times , then re-set all the settings , clear up all cache (local + proxy) , install 3 new browser too (netscape,firefox,opera 9 ) but its hardluck , :-(





    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  31. satya Moderator

    Well this happened to me for one of the post recently under General DBA section, as mentioned by Hemant I have tried from other machine also and having same issues.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  32. Luis Martin Moderator

    I have no problem at all.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  33. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />I have no problem at all.<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important<br />Bertrand Russell<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Did you do any tricks to avoid error? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  34. gkrishn New Member

    quote:Originally posted by ghemant

    Hi,
    i got this error today at 5:53 IST .


    quote:There has been problema
    Sorry we have flood control activated
    You cannot post within 30 second of your last post.
    Please try again after this period of time elaspse.




    That is a flood control feature in most forums.Without that someone can continuously post in a row in a single thread .Some automated tools also there which does automatic posts in an interval.Flood control prevents that

    Rajiv
    Junior DBA-MSSQL

    My archived posts are better place for newbies to start with
  35. FrankKalis Moderator

    Right, that is no error, but a message. Nothing to worry about. Just wait 30 seconds and you can post again. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  36. FrankKalis Moderator

    This is a custom setting. The forum admin can choose to activate it or not. He can also set the time interval. Usually there should be no problem at all with it.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  37. FrankKalis Moderator

  38. bradmcgehee New Member

    Yes, I have the flood control set to prevent rampant spamming.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  39. Madhivanan Moderator

    Still the problem exists. I cant add any script that is copied from QA to here
    When I posted a question by copying the procedure and paste it here, I got the error The page cannot be found

    Madhivanan

    Failing to plan is Planning to fail
  40. FrankKalis Moderator

  41. FrankKalis Moderator

    This is really strange.<br /><br />Can you post the script that causes the error? [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />I mean, have you tried copying from some other app like Notepad or so?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  42. Madhivanan Moderator

    Test. I cant post reply here for long time. Dont know what happened to this topic. I didnt use Notepad

    Madhivanan

    Failing to plan is Planning to fail
  43. FrankKalis Moderator

  44. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Ever experienced this weird behaviour on SQL Team?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Never [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br /><br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  45. Madhivanan Moderator

  46. mmarovic Active Member

  47. mmarovic Active Member

    I've just tried to post the query here (in this topic) and I can't do it either.
  48. FrankKalis Moderator

    !!!Test !!! Directly pasted from QA


    CREATE TABLE t
    (
    k1 INT NOT NULL
    , c1 CHAR NOT NULL
    CONSTRAINT pk_t PRIMARY KEY(k1)
    )
    GO

    CREATE FUNCTION dbo.CloseMyGaps() RETURNS INT
    AS
    BEGIN
    RETURN
    CASE
    WHEN EXISTS
    (SELECT *
    FROM t
    WHERE k1 = 1)
    THEN (SELECT MIN(t1.k1) + 1
    FROM t t1
    LEFT OUTER JOIN t t2
    ON t1.k1 = t2.k1 - 1
    WHERE t2.k1 IS NULL)
    ELSE 1
    END
    END
    GO

    ALTER TABLE t ADD CONSTRAINT d_k1 DEFAULT dbo.CloseMyGaps() FOR k1
    GO

    INSERT INTO t(c1) VALUES('a')
    INSERT INTO t(c1) VALUES('b')
    INSERT INTO t(c1) VALUES('c')
    INSERT INTO t(c1) VALUES('d')

    SELECT *
    FROM t

    DELETE FROM t WHERE k1 IN (2,3)
    INSERT INTO t(c1) VALUES('d')
    INSERT INTO t(c1) VALUES('d')
    DELETE FROM t WHERE k1 =1
    INSERT INTO t(c1) VALUES('f')


    SELECT *
    FROM t

    DROP TABLE t
    DROP FUNCTION dbo.CloseMyGaps


    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  49. Madhivanan Moderator

  50. FrankKalis Moderator

  51. FrankKalis Moderator

  52. Madhivanan Moderator

    Yes tried. Same problem.


    Madhivanan

    Failing to plan is Planning to fail
  53. FrankKalis Moderator

  54. Madhivanan Moderator

    IE 6.0

    Madhivanan

    Failing to plan is Planning to fail
  55. FrankKalis Moderator

    Bummer. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />No explanation what happens.<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  56. mmarovic Active Member

    I use firefox.
  57. Chappy New Member

    Just a shot in the dark, but have you run a full spyware scan ?

    I have known some spyware to hook into your browser and actually modify what is being POSTed. Some worms will even attempt to deploy an exploit by piggybacking your POST

    What is the simplest script which fails ?
    Maybe there is some server side software which is preventing the post, by falsely identifying the SQL as some sort of injection attack?

    Like I say, just some ideas, Im sure this will all come up clean
  58. ghemant Moderator

    Hi Chappy,<br />i have also faced the same error earlier, i have tried IE 6.0 sp1,firefox,opera,mozilla and my system is uptodate with latest Virus Defination and updated spyware ... but with some threads i have problem posting , even i tried from different system ,different browser tooo but no luck ... but now dont experienced this ...<br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  59. ghemant Moderator

    Hi,<br />it happen again , i can not post in thread :<br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12337>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12337</a><br /><br />this is my home pc , Fresh Windows XP SP2 + hotfixs ,IE 6.0 SP1 , i tried after RE-Login to SSP Forum,restart system , clear temp but no luck . What could be a problem ! <br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  60. Luis Martin Moderator

    Something is for sure: I can post with some when others member not, and viceverza.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  61. ghemant Moderator

  62. derrickleggett New Member

    I tried to post into that first thread multiple times and it never succeeded. Not sure what was up with that.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  63. ghemant Moderator

    Hi,<br />now it wont let me post in the thread<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12395>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12395</a> , though i have post one , what could be the problem !? <br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  64. FrankKalis Moderator

  65. mmarovic Active Member

    There was also one thread yesterday I was not able to post the second answer. This time it was not copy/past from query analyzer, just one short, simple sentence.
  66. Madhivanan Moderator

    Yes. This happens atleast twice a week. Something goes wrong. Not able to understand fully [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  67. ghemant Moderator

  68. Madhivanan Moderator

    quote:Originally posted by ghemant

    Hi,
    i can't post into following thread :

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12638

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    Yes. I am also not able to post there. I think the problem is xp(underscore)cmdShell
    I cant use underscore symbol directly

    Madhivanan

    Failing to plan is Planning to fail
  69. Adriaan New Member

    Same here - I'm trying to start a new thread, and the forum doesn't seem to accept xp(underscore)cmdshell.
  70. Madhivanan Moderator


    But the following with underscore works
    SET ANSI_PADDING
    SET ANSI_DEFAULTS
    SET ANSI_WARNINGS

    I really wonder what goes wrong?

    Madhivanan

    Failing to plan is Planning to fail
  71. Adriaan New Member

    Somebody start a trace![<img src='/community/emoticons/emotion-2.gif' alt=':D' />]
  72. FrankKalis Moderator

  73. Adriaan New Member

    Frank,

    The problem appears to be when your post includes xp_cmdshell in plain text.
  74. Adriaan New Member

    ... and I managed to post that by applying bold to xp_ - then once more applying bold to cmdshell.
  75. FrankKalis Moderator

    Aah, now I've experienced this myself. The underscore is not working. However, I received
    a

    quote:
    ERROR
    The requested URL could not be retrieved

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  76. Adriaan New Member

    Yes Frank, correct - same error message in IE here, sorry I didn't mention that before.
  77. FrankKalis Moderator

  78. FrankKalis Moderator

  79. FrankKalis Moderator

  80. Madhivanan Moderator

    What may be the reason?

    Madhivanan

    Failing to plan is Planning to fail
  81. FrankKalis Moderator

    Since there are older threads where you could type in xp_cmdshll, there must have something changed to the server recently. And only Brad can answer this.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  82. FrankKalis Moderator

  83. ghemant Moderator

    not only in xpUnderScoreCMDSHELL but it happens with spUNDERSCOREhelptext , is this a problem with UNDERSCORE ?! with prefix of sp or xp ?!
    test_test

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  84. ghemant Moderator

    sp_ and xp_

    sp_who2 , sp_lock works but xpUNDERSCOREcmdshell not

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  85. Madhivanan Moderator

    Now when I tried to reply with xp(underscore)cmdshell I am getting the error
    ERROR
    The requested URL could not be retrieved

    --------------------------------------------------------------------------------

    While trying to retrieve the URL:http://sql-server-performance.com/forum/post_info.asp

    The following error was encountered:

    Read Error
    The system returned:

    (104) Connection reset by peer
    An error condition occurred while reading data from the network. Please retry your request.

    Your cache administrator is admin@giga.net.id.



    --------------------------------------------------------------------------------
    Generated Fri, 20 Oct 2006 12:56:18 GMT by casablanca (Squid/2.4.STABLE6)


    What does it mean?

    Madhivanan

    Failing to plan is Planning to fail
  86. bradmcgehee New Member

    I haven't seen this error before.

    -----------------------------
    Brad M. McGehee, SQL Server MVP
  87. Madhivanan Moderator

    The error seems very strange

    Madhivanan

    Failing to plan is Planning to fail
  88. FrankKalis Moderator

    Actually, I've given up thinking what be the root cause of this error. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  89. mmarovic Active Member

    Just a way to discourage using that sql server feature. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]
  90. Madhivanan Moderator

    >>Actually, I've given up thinking what be the root cause of this error.

    I also

    Madhivanan

    Failing to plan is Planning to fail
  91. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by mmarovic</i><br /><br />Just a way to discourage using that sql server feature. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  92. judehk New Member

    Looks a strange error all right. I'm not going to spend too much time on this one as I will be trying to move the forum over to an ASP.NET one.
  93. Madhivanan Moderator

    Thats good. If you have enough time try it to solve

    Madhivanan

    Failing to plan is Planning to fail

Share This Page