- Original Message -
From: "Rob Wultsch" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: "MYSQL General List"
Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:47 PM, <[EMAIL PROTECTED]> wrote:
> Still getting an
On Fri, May 23, 2008 at 1:47 PM, <[EMAIL PROTECTED]> wrote:
> Still getting and error on the last line
>
> SELECT
> p1.POPS AS `POPA`,
> p2.POPS AS `POPZ`
> FROM
> circuits
> INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
> INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.pop
Still getting and error on the last line
SELECT
p1.POPS AS `POPA`,
p2.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
Table-name = circuits
circuitID
popID_A (secondary key referencing p
On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Mike,
> Since i have done a fresh backup from master (with master db down), and
> copied over the same to slave. Then why is the slaving looking for old
> relay-log. I also did the "RESET SLAVE", bit still getting error
On Fri, May 23, 2008 at 12:04 PM, <[EMAIL PROTECTED]> wrote:
> Thanks for the quick reply, however i am getting a failure on line 2.
>
> SELECT
> 11.POPS AS `POPA`,
> 12.POPS AS `POPZ`
> FROM
> circuits
> INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
> INNER JOIN pops.POPS as 12 WHERE
Hi Mike,
Since i have done a fresh backup from master (with master db down), and
copied over the same to slave. Then why is the slaving looking for old
relay-log. I also did the "RESET SLAVE", bit still getting error.
I am wondering, why is the slave looking for old relay-logs
On 5/23/08, Mike <
Thanks for the quick reply, however i am getting a failure on line 2.
SELECT
11.POPS AS `POPA`,
12.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
INNER JOIN pops.POPS as 12 WHERE circuits.popZ = 12.popID
Table-name = circuits
circuitID
popA (secondary key
>
> On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> >I'm running a query :
> >
> > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
> >
> >But if there aren't any rows in "radacct" for the UserName of
> > "hotspot", it
On Fri, May 23, 2008 at 11:27 AM, <[EMAIL PROTECTED]> wrote:
> I have a table that has two has two secondary keys referencing the same
> primary key of another.
>
> Table-name =Circuits
> circuitID
> CircuitID
> A_loc
> Z_loc
>
> Table-name = Location
> locationID
>
On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote:
> Hi,
>
>I'm running a query :
>
> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
>
>But if there aren't any rows in "radacct" for the UserName of
> "hotspot", it returns a NULL. Is th
I have a table that has two has two secondary keys referencing the same primary
key of another.
Table-name =Circuits
circuitID
CircuitID
A_loc
Z_loc
Table-name = Location
locationID
location
circuits.A_locreferenceslocatioin.locationID
circuits.Z_
Hi,
I'm running a query :
SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
But if there aren't any rows in "radacct" for the UserName of
"hotspot", it returns a NULL. Is there a way to change it to return 0
instead? (I can't change the application, but I can cha
Ok, since you do not have the bin log you need to start over again with the
replication and do either a
mysqldump or get the rawdata. then once you have the data then you can
start replication again.
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldump.html
http://dev.my
RESET MASTER...delete all the bin logs. Infact i tried this on the slave as
it also a MASTER to itself, but the error kept on coming.
regards
anandkl
On 5/23/08, Mike <[EMAIL PROTECTED]> wrote:
>
>
>
> On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>> Files is owned b
On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Files is owned by mysql, but the point is, these relay-log files are not
> present.
> Before setting up the slave, i cleaned up all files.
>
If you want the logs back you could use RESET MASTER maybe.
http://dev.mysql
Files is owned by mysql, but the point is, these relay-log files are not
present.
Before setting up the slave, i cleaned up all files.
regards
anandkl
On 5/23/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Please check the ownership of the files copied on the slave.
>
> Give permis
Please check the ownership of the files copied on the slave.
Give permissions by chown -R mysql:mysql
On Fri, May 23, 2008 at 2:47 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Krishna,
> As i said, this is a complete copy from master db to slave.
> I have deleted all old files from slave and
Under 5.0.41 I have having problems of CPU sitting at exactly 100% load
on a single CPU for very long periods of time, like 10 hours.
I traced this command:
mysql> SHOW MUTEX STATUS;
Which returned 1281006 lines, ending with:
+-+--+--+
| File| Line | OS_waits |
Hi Krishna,
As i said, this is a complete copy from master db to slave.
I have deleted all old files from slave and setting up from scratch, by
taking a complete backup from master, copying over to slave and using the
change master command with BIN LOG and POSITION taken before taking a backup
copy
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.
thanks but this gave me a very similar error - I forget
check permissions
On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> I shutdown my master, took a db files backup. Copied it over to slave
> machine.
> I executed "change master" command, then when i start slave "slave start",
> i
> get the below error. I did "r
Hi All,
I shutdown my master, took a db files backup. Copied it over to slave
machine.
I executed "change master" command, then when i start slave "slave start", i
get the below error. I did "reset slave", but still getting same error, what
could be the reason, and how to fix it.
080522 23:04:05 [
22 matches
Mail list logo
