DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: When I execute a query, filesystem / is full

  1. #1
    Join Date
    May 2003
    Location
    México, D.F.
    Posts
    2

    When I execute a query, filesystem / is full

    I'm running a query, but suddenly, filesystem / is full.
    I don't know which file is growing.

    Any idea?
    Thanks,

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Some helpful UNIX commands you can try/learn:

    ls -lat | more
    df -k
    du -k
    ls core
    find / -name core
    rm core

  3. #3
    Join Date
    May 2003
    Location
    México, D.F.
    Posts
    2
    Thanks, that was the first step, but my problem is more complicated.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  5. #5
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    Which is its problem? for they filesystem full or you it removes archives or you it increases filesystem it...
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  6. #6
    Join Date
    Oct 2002
    Posts
    182
    funny
    - Cookies

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Cookies
    funny
    I think Jeff was being serious (ouch!).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  8. #8
    Join Date
    Oct 2002
    Posts
    182
    Originally posted by DaPi
    I think Jeff was being serious (ouch!).
    That is EXACTLY why it was so funny.
    - Cookies

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I think I've been in IT too long; something's gone seriously wrong with my sense of humo(u)r
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  10. #10
    Join Date
    May 2002
    Posts
    2,645

    Re: When I execute a query, filesystem / is full

    Originally posted by citlali
    I'm running a query, but suddenly, filesystem / is full.
    I don't know which file is growing.

    Any idea?
    Thanks,
    find / -mtime -1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width