Re: [Maria-developers] Plugin 'PBXT' will be forced to shutdown

2009-11-26 Thread Kristian Nielsen 
Paul McCullagh  writes:

> I have seen this warning occasionally with other versions of MySQL.
>
> Since it also happens with MyISAM and sometimes other engines, I had
> not given it much thought before.

As I understand it, the reason for the message about MyISAM is that PBXT is
keeping references (directly or indirectly) to MyISAM.

> However, it would be good to track down exactly where this reference
> is being held.
>
> To repeat the error, do I just create an empty file called kn.test,
> and run:
>
> mysql-test-run.pl --suite=pbxt pbxt.kn

No, the file should contain a single line as follows:

-- cut here --
--skip "Test shutdown problem with skipped test"
-- cut here --

(eg. this is a test that is always skipped). At least for me this allowed to
repeat reliably.

 - Kristian.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Plugin 'PBXT' will be forced to shutdown

2009-11-27 Thread Paul McCullagh 

OK, thanks!

This has been reported as bug #489088 (https://bugs.launchpad.net/pbxt/+bug/489088 
)


We will have a look...

On Nov 26, 2009, at 7:45 PM, Kristian Nielsen wrote:


Paul McCullagh  writes:


I have seen this warning occasionally with other versions of MySQL.

Since it also happens with MyISAM and sometimes other engines, I had
not given it much thought before.


As I understand it, the reason for the message about MyISAM is that  
PBXT is

keeping references (directly or indirectly) to MyISAM.


However, it would be good to track down exactly where this reference
is being held.

To repeat the error, do I just create an empty file called kn.test,
and run:

mysql-test-run.pl --suite=pbxt pbxt.kn


No, the file should contain a single line as follows:

-- cut here --
--skip "Test shutdown problem with skipped test"
-- cut here --

(eg. this is a test that is always skipped). At least for me this  
allowed to

repeat reliably.

- Kristian.




--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com




___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

[Maria-developers] Plugin 'PBXT' will be forced to shutdown (was Re: Test failures in PBXT after merging with MySQL-5.1.41)

2009-11-26 Thread Paul McCullagh 

Hi Kristian,

I have seen this warning occasionally with other versions of MySQL.

Since it also happens with MyISAM and sometimes other engines, I had  
not given it much thought before.


However, it would be good to track down exactly where this reference  
is being held.


To repeat the error, do I just create an empty file called kn.test,  
and run:


mysql-test-run.pl --suite=pbxt pbxt.kn

Thanks,

Paul

On Nov 24, 2009, at 1:21 PM, Kristian Nielsen wrote:


Kristian Nielsen  writes:

PS. I now get this in the mysqld.err log after server shutdown in  
PBXT test

suite:

091124 13:09:45 [Warning] Plugin 'MyISAM' will be forced to shutdown
091124 13:09:45 [Warning] Plugin 'PBXT' will be forced to shutdown


Ok, some more details:

I can repeat this by running an empty test case
(mysql-test/suite/pbxt/t/kn.test):

-- cut here --
--skip "Test shutdown problem with skipped test"
-- cut here --

(cd mysql-test && perl mysql-test-run.pl --suite=pbxt pbxt.kn)

I get this in the mysqld.1.err:

CURRENT_TEST: pbxt.kn
091124 15:11:00 [Note] Plugin 'InnoDB' is disabled.
091124 15:11:00 [Note] PrimeBase XT (PBXT) Engine 1.0.08d RC loaded...
091124 15:11:00 [Note] Paul McCullagh, PrimeBase Technologies GmbH, 
http://www.primebase.org
091124 15:11:00 [Note] Event Scheduler: Loaded 0 events
091124 15:11:00 [Note] /home/knielsen/devel/maria/my/merge-5.1.41/ 
sql/mysqld: ready for connections.
Version: '5.1.41-mariadb-beta-valgrind-max-debug-log'  socket: '/ 
home/knielsen/devel/maria/my/merge-5.1.41/mysql-test/var/tmp/mysqld. 
1.sock'  port: 13000  Source distribution

091124 15:11:00 [Note] Got signal 15 to shutdown mysqld
091124 15:11:00 [Note] /home/knielsen/devel/maria/my/merge-5.1.41/ 
sql/mysqld: Normal shutdown


091124 15:11:00 [Note] Event Scheduler: Purging the queue. 0 events
091124 15:11:00 [Warning] Plugin 'MyISAM' will be forced to shutdown
091124 15:11:00 [Warning] Plugin 'PBXT' will be forced to shutdown
091124 15:11:00 [Note] PrimeBase XT Engine shutdown...
091124 15:11:00 [Note] Debug sync points hit:   50
091124 15:11:00 [Note] Debug sync points executed:  0
091124 15:11:00 [Note] Debug sync points max active per thread: 0
091124 15:11:00 [Note] /home/knielsen/devel/maria/my/merge-5.1.41/ 
sql/mysqld: Shutdown complete


This is from this tree on Launchpad containing the merge with MySQL  
5.1.41:


   lp:~maria-captains/maria/5.1-merge

The problem is that the ref_count of PBXT is 2 at shutdown time.

Maybe this is another problem with the way that PBXT has to do init  
in a
separate thread, I see you already had to solve some other possibly  
related
problems. Any ideas? It may be that this is something introduced in  
the merge
with MySQL 5.1.41, not 100% sure though as this particular warning  
was not

detected before in our Buildbot tests...

- Kristian.




--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com




___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp