Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Mickey Chandler 

At 02:39 PM 10/24/2005, Lee Koloszyc wrote:
>I didn't catch the beginning of this thread, but mythfilldatabase from
>0.18.1 doesn't seem to work with MySQL 5.0.  It has something to do with
>"repeat" being a keyword in the MySQL 5 I think.  I reverted back to 4
>and everything worked again. Not sure if this is your problem.

My problem is that the backend loses touch with the database, not 
that it's not filling.


My fix is documented here: 
http://mythtv.org/pipermail/mythtv-users/2005-May/088738.html .  I 
basically escape the reserved word using `.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: 
Our new site:  



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Lee Koloszyc 

Mickey Chandler wrote:


At 04:54 AM 10/23/2005, Nick Rosier wrote:
>What version of MySQL are you running?

I'm running 5.0.4-beta-standard

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: 
Our new site: 

I didn't catch the beginning of this thread, but mythfilldatabase from 
0.18.1 doesn't seem to work with MySQL 5.0.  It has something to do with 
"repeat" being a keyword in the MySQL 5 I think.  I reverted back to 4 
and everything worked again. Not sure if this is your problem.


Lee
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Mickey Chandler 

At 04:54 AM 10/23/2005, Nick Rosier wrote:
>What version of MySQL are you running?

I'm running 5.0.4-beta-standard

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: 
Our new site:  



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Peter Osterberg 

I've had this problem repetedly for about 3 weeks.

At 20:58 2005-10-21, you wrote:

On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
> I've had a peculiar problem pop up lately.  About once a day, my
> recorded programs listing goes away and starts reading "No recorded
> programs available."  Restarting the back end gets the listing back.
>
> The only error I'm seeing in the log is this:
>
> 2005-10-21 11:00:00.082 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
>
> Of course, the MySQL server hasn't gone away since restarting the
> backend (not the MySQL server) re-establishes that connection.
>
> Any ideas?

Strangely enough I had the same problem about 2h ago. Coincidence?

N.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-23 Thread Nick Rosier 
On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
> I've had a peculiar problem pop up lately.  About once a day, my
> recorded programs listing goes away and starts reading "No recorded
> programs available."  Restarting the back end gets the listing back.
>
> The only error I'm seeing in the log is this:
>
> 2005-10-21 11:00:00.082 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
>
> Of course, the MySQL server hasn't gone away since restarting the
> backend (not the MySQL server) re-establishes that connection.
>
> Any ideas?

What version of MySQL are you running?

N.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-23 Thread Nick Rosier 
On 10/23/05, Darryl Ross <[EMAIL PROTECTED]> wrote:
>
> >>>I've had a peculiar problem pop up lately.  About once a day, my
> >>>recorded programs listing goes away and starts reading "No recorded
> >>>programs available."  Restarting the back end gets the listing back.
>
> > This morning it happened again; restarted the backend en frontend and
> > everything worked again. So it's not MySQL that's causing the problem.
>
> Does it happen only in the morning or during the day as well?
>
> Perhaps log-rotate is restarting mysql and myth isn't reconnecting
> automatically?

It's happened to me 3 times now. Friday around 7pm, saturday around
11:15am and sunday (today) around 11am. Logrotate runs every day at
7am.

N.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-23 Thread Darryl Ross 



I've had a peculiar problem pop up lately.  About once a day, my
recorded programs listing goes away and starts reading "No recorded
programs available."  Restarting the back end gets the listing back.



This morning it happened again; restarted the backend en frontend and
everything worked again. So it's not MySQL that's causing the problem.


Does it happen only in the morning or during the day as well?

Perhaps log-rotate is restarting mysql and myth isn't reconnecting
automatically?

Regards
Darryl




signature.asc
Description: OpenPGP digital signature
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Kevin Kuphal 

Nick Rosier wrote:


On 10/22/05, Michael T. Dean <[EMAIL PROTECTED]> wrote:
 


Nick Rosier wrote:

   


On 10/21/05, Nick Rosier <[EMAIL PROTECTED]> wrote:


 


On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:


   


I've had a peculiar problem pop up lately.  About once a day, my
recorded programs listing goes away and starts reading "No recorded
programs available."  Restarting the back end gets the listing back.

The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since restarting the
backend (not the MySQL server) re-establishes that connection.

Any ideas?


 


Strangely enough I had the same problem about 2h ago. Coincidence?


   


This morning it happened again; restarted the backend en frontend and
everything worked again. So it's not MySQL that's causing the problem.

2005-10-22 11:07:41.148 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2005-10-22 11:07:41.202 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

 


Network problems?
   



FE/BE combo so I would doubt it. I'm recompiling Qt and kdelibs right
now. Maybe some fluke library issue...
 

I was going to say maybe a mysql-client issue where the client library 
bails leaving myth high and dry.


Kevin
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Meatwad 

Meatwad wrote:

Steve Pugh wrote:


--- Mickey Chandler <[EMAIL PROTECTED]> wrote:



I've had a peculiar problem pop up lately.  About
once a day, my recorded programs listing goes away and starts
reading "No recorded programs available."  Restarting the back end gets
the listing back.

The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since
restarting the backend (not the MySQL server) re-establishes that
connection.

Any ideas?

--
To clarify, I had meant to quote Nick, not Mickey. My backend goes out 
to lunch, FE shows No Recordings, mythweb breaks altogether. My fix is 
to exit the FE, scan the BE logs, restart BE -v all.


I don't have sufficient time this weekend to compile with debug as I've 
only compiled from source once, pre 18. Not something I'm terribly 
familiar with yet.

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Meatwad 

Steve Pugh wrote:

--- Mickey Chandler <[EMAIL PROTECTED]> wrote:



I've had a peculiar problem pop up lately.  About
once a day, my 
recorded programs listing goes away and starts
reading "No recorded 
programs available."  Restarting the back end gets

the listing back.

The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since
restarting the 
backend (not the MySQL server) re-establishes that

connection.

Any ideas?

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: 
Our new site:
 





___


mythtv-users mailing list
mythtv-users@mythtv.org



http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Hi Mickey,

I've had the same thing happen (I'd say twice in the
last couple of weeks) but *ONLY* in Mythweb.  My Myth
interface hasn't exhibited this yet - that'd be a
pretty unnerving thing to experience.

I didn't notice any errors in the backend log, but
there's every possibility that I just missed it in a
fit of newbieism.


I've been plagued with this for the last couple of weeks as well. Using 
ATRPMS 18.1, FC4. Happened with the 2.16.13 kernel and still does it 
with 2.16.12 I backed down to. Using an older air2pc and a pvr-250 with 
the 4.0 drivers. Seems to happen immediately after starting a recording 
on the 350.


No smoking gun when running the backend -v all, just the same "QMYSQL3: 
Unable to execute query" msg. MySQL is happy and healthy.


It stabilized itself two days ago but I'm sure it'll bork itself again.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Nick Rosier 
On 10/22/05, Michael T. Dean <[EMAIL PROTECTED]> wrote:
> Nick Rosier wrote:
>
> >On 10/21/05, Nick Rosier <[EMAIL PROTECTED]> wrote:
> >
> >
> >>On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
> >>
> >>
> >>>I've had a peculiar problem pop up lately.  About once a day, my
> >>>recorded programs listing goes away and starts reading "No recorded
> >>>programs available."  Restarting the back end gets the listing back.
> >>>
> >>>The only error I'm seeing in the log is this:
> >>>
> >>>2005-10-21 11:00:00.082 DB Error (KickDatabase):
> >>>Query was:
> >>>SELECT NULL;
> >>>Driver error was [2/2006]:
> >>>QMYSQL3: Unable to execute query
> >>>Database error was:
> >>>MySQL server has gone away
> >>>
> >>>Of course, the MySQL server hasn't gone away since restarting the
> >>>backend (not the MySQL server) re-establishes that connection.
> >>>
> >>>Any ideas?
> >>>
> >>>
> >>Strangely enough I had the same problem about 2h ago. Coincidence?
> >>
> >>
> >This morning it happened again; restarted the backend en frontend and
> >everything worked again. So it's not MySQL that's causing the problem.
> >
> >2005-10-22 11:07:41.148 DB Error (KickDatabase):
> >Query was:
> >SELECT NULL;
> >Driver error was [2/2006]:
> >QMYSQL3: Unable to execute query
> >Database error was:
> >MySQL server has gone away
> >
> >2005-10-22 11:07:41.202 DB Error (KickDatabase):
> >Query was:
> >SELECT NULL;
> >Driver error was [2/2006]:
> >QMYSQL3: Unable to execute query
> >Database error was:
> >MySQL server has gone away
> >
> Network problems?

FE/BE combo so I would doubt it. I'm recompiling Qt and kdelibs right
now. Maybe some fluke library issue...

N.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Michael T. Dean 

Nick Rosier wrote:


On 10/21/05, Nick Rosier <[EMAIL PROTECTED]> wrote:
 


On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
   


I've had a peculiar problem pop up lately.  About once a day, my
recorded programs listing goes away and starts reading "No recorded
programs available."  Restarting the back end gets the listing back.

The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since restarting the
backend (not the MySQL server) re-establishes that connection.

Any ideas?
 


Strangely enough I had the same problem about 2h ago. Coincidence?
   


This morning it happened again; restarted the backend en frontend and
everything worked again. So it's not MySQL that's causing the problem.

2005-10-22 11:07:41.148 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2005-10-22 11:07:41.202 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away


Network problems?

Mike
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-22 Thread Nick Rosier 
On 10/21/05, Nick Rosier <[EMAIL PROTECTED]> wrote:
> On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
> > I've had a peculiar problem pop up lately.  About once a day, my
> > recorded programs listing goes away and starts reading "No recorded
> > programs available."  Restarting the back end gets the listing back.
> >
> > The only error I'm seeing in the log is this:
> >
> > 2005-10-21 11:00:00.082 DB Error (KickDatabase):
> > Query was:
> > SELECT NULL;
> > Driver error was [2/2006]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > MySQL server has gone away
> >
> > Of course, the MySQL server hasn't gone away since restarting the
> > backend (not the MySQL server) re-establishes that connection.
> >
> > Any ideas?
>
> Strangely enough I had the same problem about 2h ago. Coincidence?

This morning it happened again; restarted the backend en frontend and
everything worked again. So it's not MySQL that's causing the problem.

2005-10-22 11:07:41.148 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2005-10-22 11:07:41.202 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-21 Thread Nick Rosier 
On 10/21/05, Mickey Chandler <[EMAIL PROTECTED]> wrote:
> I've had a peculiar problem pop up lately.  About once a day, my
> recorded programs listing goes away and starts reading "No recorded
> programs available."  Restarting the back end gets the listing back.
>
> The only error I'm seeing in the log is this:
>
> 2005-10-21 11:00:00.082 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
>
> Of course, the MySQL server hasn't gone away since restarting the
> backend (not the MySQL server) re-establishes that connection.
>
> Any ideas?

Strangely enough I had the same problem about 2h ago. Coincidence?

N.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Re: [mythtv-users] Backend loses the database

2005-10-21 Thread Steve Pugh 
--- Mickey Chandler <[EMAIL PROTECTED]> wrote:

> I've had a peculiar problem pop up lately.  About
> once a day, my 
> recorded programs listing goes away and starts
> reading "No recorded 
> programs available."  Restarting the back end gets
> the listing back.
> 
> The only error I'm seeing in the log is this:
> 
> 2005-10-21 11:00:00.082 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
> 
> Of course, the MySQL server hasn't gone away since
> restarting the 
> backend (not the MySQL server) re-establishes that
> connection.
> 
> Any ideas?
> 
> --
> Mickey Chandler
> Chief Operating Whizard
> Whizardries, Inc.: 
> Our new site:
>  
> 
> 
> > ___
> mythtv-users mailing list
> mythtv-users@mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 

Hi Mickey,

I've had the same thing happen (I'd say twice in the
last couple of weeks) but *ONLY* in Mythweb.  My Myth
interface hasn't exhibited this yet - that'd be a
pretty unnerving thing to experience.

I didn't notice any errors in the backend log, but
there's every possibility that I just missed it in a
fit of newbieism.

Best,
Steve



__ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

[mythtv-users] Backend loses the database

2005-10-21 Thread Mickey Chandler 
I've had a peculiar problem pop up lately.  About once a day, my 
recorded programs listing goes away and starts reading "No recorded 
programs available."  Restarting the back end gets the listing back.


The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since restarting the 
backend (not the MySQL server) re-establishes that connection.


Any ideas?

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: 
Our new site:  



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users