ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


missing mysql sock



  • 2004-01-22 13:28:55

    missing mysql sock

    I'm running ATutor 1.3.1 on Red Hat Linux with Apache 1.3.27
    and PHP 4.3.0 and MySQL 3.23.43.

    I logged in as a course instructor and clicked on the 'Delete' link under Properties in a course that I had created. It asked me if I was sure and then if I was really really sure. It hung there for a long time and something happened to the database. When I finally stopped it and tried to log in I got a message that I couldn't connect to the db.
    When I went in to phpmyadmin to try and see what was going on I got this error:
    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

    Apparently the mysql.sock file had completely disappeared. Once it was replace then everything came up normal again and works fine. However, I just went into phpmyadmin and tried to dump the contents of my database into a file and got this error:
    File '/var/lib/mysql/atutor/content.MYD' not found (Errcode: 2)

    Any idea what might be happening? Right now I'm afraid to go back and try to delete the course again (it's still there).

    Thanks,
    Christopher

    (any possibility of adding a search function to these forums?)


  • 2004-01-22 15:19:54

    missing mysql sock

    Try running mysqlcheck on your database to fix that table. You may need root access to your db. Once the table is fixed back it up (using phpmyadmin or mysqldump or mysqlhotcopy) and try deleting it again.

    How big was the course that you were trying to delete?

    These forums can be searched using the search box at the top left of the site. It searches through the whole site including the forums.

    .joel


  • 2004-01-23 13:31:29

    Hmmmm

    Thanks Joel-
    I tried running mysqlcheck and this is what I got:
    [quote][communityinclusion][/usr/local/mysql]$ ./bin/mysqlcheck --auto-repair --databases atutor;
    atutor.content
    error : File '/var/lib/mysql/atutor/content.MYD' not found (Errcode: 2)
    atutor.course_cats OK
    atutor.course_enrollment
    warning : 4 clients is using or hasn't closed the table properly
    status : OK
    atutor.course_stats
    warning : 2 clients is using or hasn't closed the table properly
    status : OK
    atutor.courses
    warning : 2 clients is using or hasn't closed the table properly
    status : OK
    atutor.forums
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.forums_accessed OK
    atutor.forums_subscriptions OK
    atutor.forums_threads OK
    atutor.g_click_data
    warning : 2 clients is using or hasn't closed the table properly
    status : OK
    atutor.g_refs OK
    atutor.glossary
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.instructor_approvals OK
    atutor.lang2 OK
    atutor.lang_base
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.lang_base_pages
    warning : 6 clients is using or hasn't closed the table properly
    status : OK
    atutor.learning_concepts
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.members
    warning : 3 clients is using or hasn't closed the table properly
    status : OK
    atutor.messages OK
    atutor.news
    warning : 4 clients is using or hasn't closed the table properly
    status : OK
    atutor.preferences
    warning : 3 clients is using or hasn't closed the table properly
    status : OK
    atutor.related_content OK
    atutor.resource_categories OK
    atutor.resource_links OK
    atutor.tests
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.tests_answers OK
    atutor.tests_questions
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.tests_results OK
    atutor.theme_settings
    warning : 1 clients is using or hasn't closed the table properly
    status : OK
    atutor.users_online
    error : The handler for the table doesn't support check/repair

    Repairing tables
    ./bin/mysqlcheck: Got error: 1103: Incorrect table name 'atutor.course_enrollment' when executing 'REPAIR TABLE ... [/quote]
    It gives me the message that the table was being used by multiple clients, but no one is using it, for some reason users aren't being logged out correctly.

    The course that I was trying to delete consisted of nothing put text on a couple of pages, very small.
    The course is actually fairly small, any ideas on where to go from here?


  • 2004-01-26 13:39:52

    Please Help

    After speaking with my hosting provider, it appears that what happened is when I clicked the button to delete a course, aTutor deleted the mysql.sock file for all of my databases (not just aTutor) so that I didn't have access to any of them. After the mysql.sock file has been replaced I am still having a problem- it is saying that the content.MYD file is missing. Any idea how I can replace it?
    Please let me know if you need access to my database, I'm happy to do whatever I need to do to get this worked out.
    Also, any ideas on what would have caused aTutor to delete the mysql.sock file?
    Christopher


  • 2004-01-26 14:10:38

    Please Help

    the content.MYD is the data for your content table. you will have to delete all the content.* files and recreate your content table. i think it would be a better idea to simply delete that database and start over since mysqlcheck can't seem to fix them (or try myisamcheck).

    atutor could not have deleted that socket. what may have happened was that mysql simply crashed while trying to delelte from the database. or something else might have happened un-related to atutor just when you tried to delete your course. when mysql crashes the sock would disappear as well.

    try checking your other databases as well as they could also be currupted during a mysql crash.

    you might also try upgrading mysql to the latest 3.23.58 version if possible.

    .joel


  • 2004-01-27 13:55:30

    Thanks Joel

    Joel,
    Thanks for all of your help. I remember that when I tried to delete the course I contacted my host and they said that they had just restarted the database- I was worried that I was the cause for the restart, but I guess it could have been that I tried to restart at the same time as the restart- and that's what caused my problems.

    I think I'll just start over with my installation. Currently I am able to access the content to one of the courses that I created, but not another one- there is simply nothing there besides the intro page- any idea how I might be able to get at that content?

    I'll be waiting a day or two to reinstall- let me know if you or someone else on the aTutor team would like to look at my tables or anything.

    Lastly, when I start over- will I just delete everything- including all the aTutor files and then reinstall from scratch?

    Thanks,
    Christopher


  • 2004-01-28 10:15:39

    .

    you should export whatever content you have if it's important to you. you can do that using phpmyadmin.

    you should then delete the database and recreate it when you do a fresh installation. seems like some of your tables are currupt, so they shouldn't be kept.

    .joel