Bug #24271 #42S02Table 'mysql.PROC' doesn't exist
Submitted: 13 Nov 2006 17:52 Modified: 1 Dec 2006 12:38
Reporter: Beat Wuethrich Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Visual Studio Plugin Severity:S3 (Non-critical)
Version:Connector 5.0.2/Plugin 1.0.1-beta OS:Microsoft Windows (win xp sp2)
Assigned to: CPU Architecture:Any

[13 Nov 2006 17:52] Beat Wuethrich
Description:
"Status for engine InnoDB:"

=====================================
061113 18:52:36 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 4 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 53, signal count 53
Mutex spin waits 57, rounds 98, OS waits 0
RW-shared spins 18, OS waits 9; RW-excl spins 46, OS waits 44
------------
TRANSACTIONS
------------
Trx id counter 0 2158991
Purge done for trx's n:o < 0 2157445 undo n:o < 0 0
History list length 19
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 12809, OS thread id 1124367280
MySQL thread id 44, query id 2745 192.168.114.241 puzzle
SHOW ENGINE InnoDB STATUS
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
7746 OS file reads, 12 OS file writes, 11 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 107, seg size 109,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 881560483
Log flushed up to   0 881560483
Last checkpoint at  0 881560483
0 pending log writes, 0 pending chkp writes
12 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 18800780; in additional pool allocated 1031424
Buffer pool size   512
Free buffers       0
Database pages     511
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 8376, created 0, written 3
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 12809, id 1107168176, state: sleeping
Number of rows inserted 0, updated 0, deleted 0, read 136581
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

How to repeat:
Visual Studio 2005

use the wizard to add a new datasource, after choosing the connection string it should search for tables in the mysql database but does report an SQL Execution Error (MySql Number 1146).

Hope that's enough info
[14 Nov 2006 10:46] Tonci Grgin
Hi Beat and thanks for your problem report. It does not contain enough info for me to start testing...

Explanation:
  - What's MySQL server version? If it's 5.x, did you upgrade from 4.x? If so, was it done properly?
  - What's NET FW version?

Irrelevant but I would like to know why did you include innodb status in this report?
[14 Nov 2006 12:00] Beat Wuethrich
Hi Tonnci

Here the information you asked for:
- MySql Version is 5.0.27
- Database is an upgrade from 4.x to 5.x. Everything looked fine.
- Visual Studio Version is 8.0.50727.42

- Status report was included as I didn't know if you need it or not...

Thanks

Beat
[14 Nov 2006 12:20] Tonci Grgin
Hi Beat. Did you follow instructions in http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html especially regarding following:
  MySQL 5.0 adds support for stored procedures. This support requires the mysql.proc  table. To create this table, you should run the mysql_upgrade program as described in Section 5.6.2, “mysql_upgrade — Check Tables for MySQL Upgrade”?
[14 Nov 2006 13:03] Beat Wuethrich
Hi Tonci

I'm sure we did use the manual to updgrade to 5.x. Also mysql.proc, mysql.user, mysql.db tables exists in the database.

I have installed in the meantime xampp on my local machine and created a new schema to test it. This did not bring this error up but was not showing any tables from my schema. Is there another problem for that or are those two problems realted?

Thanks
[16 Nov 2006 9:26] Beat Wuethrich
We did check again the update and the message is that everything is done ok and finished.

Any news from your site?
[1 Dec 2006 12:26] Tonci Grgin
Hi Beat. This seems to be packaging bug in 5.0.27. See Bug#24750 for details.
[1 Dec 2006 12:38] Beat Wuethrich
Hi Tonci

I cannot see any details which could help me to solve the problem with Visual Studio Plugin! The only thing I know is that I get this error!

How can I solve this problem?
[4 Dec 2006 8:48] Tonci Grgin
Hi Beat, did you tried suggested fix from Bug#24750 ?