maria-developers team mailing list archive

[Paul McCullagh <paul.mccullagh@xxxxxxxxxxxxx>]

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 <knielsen@xxxxxxxxxxxxxxx> 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