Professional Web Applications Themes

Out of memory (Needed 6693225 bytes) problem in mysql - MySQL

I have such mysq select queries: SELECT count( DISTINCT ( chart_number ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart FROM table_table WHERE category = 'LP LP LP' GROUP BY year_chart HAVING year_chart =2007 Unfortunately this select gives me an error. It used to work well before, but now it doesn`t work and gives me such error: #5 - Out of memory (Needed 6693225 bytes) Could you advise me what I should do? Is it a fault of admins? Is it an admin`s work? Should they fix this problem up? Kindest regards M. from Poland...

  1. #1

    Default Out of memory (Needed 6693225 bytes) problem in mysql

    I have such mysq select queries:

    SELECT count( DISTINCT (
    chart_number
    ) ) AS chart_number_qty, YEAR( chart_date ) AS year_chart
    FROM table_table
    WHERE category = 'LP LP LP'
    GROUP BY year_chart
    HAVING year_chart =2007

    Unfortunately this select gives me an error. It used to work well before,
    but now
    it doesn`t work and gives me such error:

    #5 - Out of memory (Needed 6693225 bytes)

    Could you advise me what I should do?
    Is it a fault of admins?
    Is it an admin`s work? Should they fix this problem up?

    Kindest regards
    M. from Poland


    K. Guest

  2. #2

    Default Re: Out of memory (Needed 6693225 bytes) problem in mysql

    == Quote from K. (onet.pl)'s article 


    if you're getting the error number 5, it signifies an input/output error. however,
    it would be helpfuel if you can post the error logs regarding this error or the
    actual error description and code.

    --
    POST BY: lark with PHP News Reader
    lark Guest

  3. #3

    Default Re: Out of memory (Needed 6693225 bytes) problem in mysql


    Użytkownik "lark" <net> napisał w wiadomości
    news:x%vdi.14879$news.prodigy.net... 
    >
    >
    > if you're getting the error number 5, it signifies an input/output error.
    > however,
    > it would be helpfuel if you can post the error logs regarding this error
    > or the
    > actual error description and code.
    >
    > --
    > POST BY: lark with PHP News Reader[/ref]


    I don`t know what exactly is wrong with it but I get such logs:

    82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
    /MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
    (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
    /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp" "Mozilla/4.0
    (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
    /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
    HTTP/1.1" 200 3712
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
    HTTP/1.1" 304 -
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    82.146.225.77 - - [18/Jun/2007:19:42:51 +0200] "GET
    /MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj
    HTTP/1.1" 200 31487
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki"
    "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"

    Thank you for help
    Marcin


    MZ Guest

  4. #4

    Default Re: Out of memory (Needed 6693225 bytes) problem in mysql

    == Quote from MZ (onet.pl)'s article 
    > >
    > >
    > > if you're getting the error number 5, it signifies an input/output error.
    > > however,
    > > it would be helpfuel if you can post the error logs regarding this error
    > > or the
    > > actual error description and code.
    > >
    > > --
    > > POST BY: lark with PHP News Reader[/ref]
    > I don`t know what exactly is wrong with it but I get such logs:
    > 82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
    > /MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
    > "http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
    > (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    > 82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
    > /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
    > "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp" "Mozilla/4.0
    > (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    > 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
    > /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
    > HTTP/1.1" 200 3712
    > "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
    > "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    > 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
    > HTTP/1.1" 304 -
    >[/ref]
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki" 
    /MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj 
    "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki" 

    i believe this is an apache log. i meant mysql server logs. if mysql is running on
    windows, it'll be helpful to have the windows own events logs.
    --
    POST BY: lark with PHP News Reader
    lark Guest

  5. #5

    Default Re: Out of memory (Needed 6693225 bytes) problem in mysql


    Użytkownik "lark" <net> napisał w wiadomości
    news:YBzdi.26053$news.prodigy.net... 
    >> I don`t know what exactly is wrong with it but I get such logs:
    >> 82.146.225.77 - - [18/Jun/2007:19:42:42 +0200] "GET
    >> /MZ_CRM/index.php?id_page=lp HTTP/1.1" 200 3215
    >> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php" "Mozilla/4.0
    >> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    >> 82.146.225.77 - - [18/Jun/2007:19:42:45 +0200] "GET
    >> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK HTTP/1.1" 200 3080
    >> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp"
    >> "Mozilla/4.0
    >> (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    >> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET
    >> /MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki
    >> HTTP/1.1" 200 3712
    >> "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK"
    >> "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
    >> 82.146.225.77 - - [18/Jun/2007:19:42:46 +0200] "GET /MZ_CRM/img/cal.gif
    >> HTTP/1.1" 304 -
    >>[/ref]
    > "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki" 
    > /MZ_CRM/index.php?subtytul2=szukajstatystyki&id_page=lp&su btytul=lp_Radio_PIK&nr_notowania_od_szukaj=&nr_not owania_do_szukaj=&data_notowania_od_szukaj=&data_n otowania_do_szukaj=&data_notowania_rok_szukaj=2007 &data_notowania_miesiac_szukaj=&data_notowania_dzi en_szukaj=&utwory_albumy=utwory&but=Szukaj 
    > "http://www.listaprzebojow.com.pl/MZ_CRM/index.php?id_page=lp&subtytul=lp_Radio_PIK&subtytu l2=szukajstatystyki" 
    >
    > i believe this is an apache log. i meant mysql server logs. if mysql is
    > running on
    > windows, it'll be helpful to have the windows own events logs.
    > --
    > POST BY: lark with PHP News Reader[/ref]


    Unfortunately I cannot find these mysql logs. Maybe my provider doesn`t
    provide
    me mysql logs. I have only phpmyadmin if we mean mysql server. I will
    contact with admin
    tomorrow, because today I cannot catch him.

    Thank you for help
    I will send post tomorrow
    Marcin


    MZ Guest

  6. #6

    Default Re: Out of memory (Needed 6693225 bytes) problem in mysql

    Hello after 2 days!

    I have checked today and mysql query works well.
    I didn`t reach admin that`s why I don`t know what they did.
    Maybe there were some admin work lately which I don`t know.

    The most interesting thing for me is that mysql query works well now.

    Thank everybody for help
    Marcin


    MZ Guest

Similar Threads

  1. Allowed memory size of 8388608 bytes exhausted
    By Paul in forum PHP Development
    Replies: 5
    Last Post: September 18th, 09:20 PM
  2. ORA-04031: unable to allocate 4096 bytes of shared memory
    By Vladimir M. Zakharychev in forum Oracle Server
    Replies: 0
    Last Post: December 27th, 07:33 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139