Login | Register
My pages Projects Community openCollabNet

Discussions > dev > MySQL funness

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

current
Discussion topic

Back to topic list

MySQL funness

Reply

Author theslack
Full name Jack Neely
Date 2006-09-09 08:48:59 PDT
Message Pauline,

Don't you like being the MySQL expert around here? :-)

While testing with 5.0.22 on FC5 more I've found a couple more items
that are "fun." Apperently, after 8 hours MySQL will close
connections and Current gets error 2006 "MySQL server has gone away."
What google tells me is that my mysql client needs to support
reconnecting and that MySQL-python doesn't.

   http://www.mail-arch​ive.com/pylons-discu​ss at googlegroups dot com/​msg00776.html

Are there other ways around this?

What I also see is after changes to the database are committed,
apperently only connections opened AFTER that commit SEE the new data.
 Clients see different channels for each run of up2date...even running
simple cadmin commands are fun. You know what's going on here?

Jack

[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC login
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

Login: jjneely
Password:
Login successful.
Wrote config file: /home/slack/.cadmin
[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC search
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

[{'name': 'rk-test5.unity.ncsu.edu',
  'uuid': '1ef21404-2bbf-11db-​9b7c-00500483c385'}]​
[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC search
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

[{'name': 'rk-test5.unity.ncsu.edu',
  'uuid': '1ef21404-2bbf-11db-​9b7c-00500483c385'}]​
[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC search
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

A Server Fault occured: <Fault 17: 'Bad session. Please login.'>
[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC search
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

A Server Fault occured: <Fault 17: 'Bad session. Please login.'>
[slack@linux00b current]$ python cadmin.py -s https://localhost/XMLRPC search
CADMIN - Current Administration Text Interface
Licensed under the GNU GPL version 2.0 or greater.

[{'name': 'rk-test5.unity.ncsu.edu',
  'uuid': '1ef21404-2bbf-11db-​9b7c-00500483c385'}]​

« Previous message in topic | 1 of 2 | Next message in topic »

Messages

Show all messages in topic

MySQL funness theslack Jack Neely 2006-09-09 08:48:59 PDT
     Re: MySQL funness Pauline Middelink <middelink at polyware dot nl> Pauline Middelink <middelink at polyware dot nl> 2006-09-11 06:28:50 PDT
Messages per page: