This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 145277 - Sakila: org.netbeans.api.db.explorer.DatabaseException: Creation of Sakila sample database had errors. Please see the message log for details.
Summary: Sakila: org.netbeans.api.db.explorer.DatabaseException: Creation of Sakila sa...
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: John Baker
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-27 12:01 UTC by Roman Mostyka
Modified: 2008-09-12 12:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 99882

Attachments
stacktrace (830 bytes, text/plain)
2008-08-27 12:01 UTC, Roman Mostyka 		Details
TExt from Output window. (3.29 KB, text/plain)
2008-08-27 12:10 UTC, Roman Mostyka 		Details
Text from log file. (3.32 KB, text/plain)
2008-08-27 12:13 UTC, Roman Mostyka 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-08-27 12:01:20 UTC 
Build: NetBeans IDE Dev (Build 080826)
VM: Java HotSpot(TM) Client VM, 1.5.0_13-121, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_13-b05-241
OS: Mac OS X, 10.4.11, i386

User Comments: 
1. Registered remote MySQL.
2. Tried to create "sakila" database.

Result: DatabaseException arises.

Stacktrace: 
org.netbeans.api.db.explorer.DatabaseException: Creation of Sakila sample database had errors.  Please see the message log for details.
        at org.netbeans.modules.db.mysql.sakila.SakilaSampleProvider.executeSQL(SakilaSampleProvider.java:156)
        at org.netbeans.modules.db.mysql.sakila.SakilaSampleProvider.createTables(SakilaSampleProvider.java:140)
        at org.netbeans.modules.db.mysql.sakila.SakilaSampleProvider.create(SakilaSampleProvider.java:84)
        at org.netbeans.modules.db.mysql.impl.SampleManager.createSample(SampleManager.java:129)
        at org.netbeans.modules.db.mysql.ui.CreateDatabasePanel$1.run(CreateDatabasePanel.java:153)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
Comment 1 Roman Mostyka 2008-08-27 12:01:25 UTC 
Created attachment 68426 [details]
stacktrace
Comment 2 Roman Mostyka 2008-08-27 12:10:15 UTC 
Created attachment 68430 [details]
TExt from Output window.
Comment 3 Roman Mostyka 2008-08-27 12:13:20 UTC 
Created attachment 68433 [details]
Text from log file.
Comment 4 John Baker 2008-08-28 07:22:55 UTC 
I cannot reproduce this anymore

Did you Grant full access to any user ?
Comment 5 Roman Mostyka 2008-08-28 12:23:01 UTC 
No, I didn't. Because I didn't have necessary checkbox. I've sent you an email with details.
Comment 6 John Baker 2008-08-29 01:58:54 UTC 
It appears the system tables are not in sync on your server.

Try running this command

% bin\mysql -u root -p mysql
mysql> SOURCE share/mysql_fix_privilege_tables.sql


For more info, see http://dev.mysql.com/doc/refman/5.0/en/mysql-fix-privilege-tables.html

We should document this on some Database troubleshooting page, perhaps linked from the Release notes ?  This isn't just
specific to the sakila database.
Comment 7 Roman Mostyka 2008-09-12 12:12:46 UTC 
For this MySQL server checkbox "Grant Full Access" was absent (issue #145274). Now those issue is fixed and with this
checkbox checked everything is fine.
Comment 8 Roman Mostyka 2008-09-12 12:13:46 UTC 
Verified with build 080911.