Thank a lot, Csaba!
Csaba E. Simon schrieb:
[client]
database = virtual_database_name
This was my problem. Leading to the next one:
PHPMyAdmin hangs endlessly at validating the login.
Controller node shows the following error:
ERROR sequoia.controller.recoverylog Recovery log was unable to update
request completion status: com.mysql.jdbc.ServerPreparedStatement[59] -
UPDATE RECOVERY SET
exec_status='F',update_count=0,exec_time=0,completion_log_id=0 WHERE
log_id=-1
Exception in thread "VirtualDatabaseWorkerThread-myDB"
java.lang.NullPointerException
at
org.continuent.sequoia.controller.scheduler.AbstractScheduler.scheduleOpenPersistentConnection(AbstractScheduler.java:786)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.openPersistentConnection(RequestManager.java:464)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.openPersistentConnection(VirtualDatabase.java:1046)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:378)
This ERROR is no wonder since
mysql> select * from RECOVERY;
Empty set (0.00 sec)
mysql> describe RECOVERY;
+-------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------------+------+-----+---------+-------+
| log_id | bigint(20) | NO | PRI | | |
| vlogin | text | NO | | | |
| sql2 | text | NO | | | |
| sql2_param | text | NO | | | |
| auto_conn_tran | char(1) | NO | | | |
| transaction_id | bigint(20) | NO | | | |
| request_id | bigint(20) | YES | | NULL | |
| exec_status | char(1) | NO | | | |
| exec_time | bigint(20) | YES | | NULL | |
| update_count | int(11) | YES | | NULL | |
| completion_log_id | bigint(20) | NO | | | |
+-------------------+------------+------+-----+---------+-------+
11 rows in set (0.00 sec)
This behavior is the same in sequoia 2.10 and 3.0Beta1 .
Any other things I forgot to configure? Is there an
PHP-libmysequoia-carob-sequoia-HOWTO from which I can learn all these
things?
Best Regards
Volker
--
====================================================
inqbus it-consulting +49 ( 341 ) 5643800
Dr. Volker Jaenisch http://www.inqbus.de
Herloßsohnstr. 12 0 4 1 5 5 Leipzig
N O T - F Ä L L E +49 ( 170 ) 3113748
====================================================
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
