
Database Reconnects Needed!
Reported by Dan Sully | June 20th, 2008 @ 02:08 PM
Not having automatic reconnects makes LOLcats sad.
~ MySQL server has gone away - (MysqlError)
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/adapters/data_objects_adapter.rb:367:in `execute_reader'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/adapters/data_objects_adapter.rb:367:in `read_set_with_sql'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/adapters/data_objects_adapter.rb:325:in `with_connection'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/adapters/data_objects_adapter.rb:362:in `read_set_with_sql'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/support/lazy_array.rb:86:in `[]'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/support/lazy_array.rb:86:in `lazy_load!'
/p/lib/gems/dm-core-0.9.1/lib/data_mapper/support/lazy_array.rb:22:in `each'
...
Comments and changes to this ticket
-
Dan Sully June 23rd, 2008 @ 12:34 PM
Any progress or thoughts here?
DM + Merb is completely unusable because of this.
-
Dan Sully June 23rd, 2008 @ 05:47 PM
Potential hack fix for do_mysql.c
@@ -429,6 +433,11 @@ static VALUE cConnection_initialize(VALUE self, VALUE uri) {
// mysql_ssl_set(db, key, cert, ca, capath, cipher)
// }
- if (1) {
- my_bool reconnect = 1;
- mysql_options(db, MYSQL_OPT_RECONNECT, &reconnect);
- }
+
result = (MYSQL *)mysql_real_connect(
db,
host,
Not sure if this should be a user configurable option or not. Hard to see why anyone wouldn't want it turned on.
-
Dan Sully July 14th, 2008 @ 04:19 PM
- Assigned user changed from Sam Smoot to Bernerd Schaefer
- Tag set to bug, dataobjects, do_mysql, mysql, priority
Ping?
-
Dan Sully September 8th, 2008 @ 04:06 PM
Ping? I've noticed some changes to do_mysql, but not this simple patch!
-
-
Adam French September 9th, 2008 @ 09:29 PM
- State changed from new to resolved
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »