[Plugin] [REL] MySQL Plugin (Now on github!)

How close is R40? It's been over a year now right?
Reply

I have a problem

i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens:

pawn Код:
[20:43:22] Unprocessed queries: 26285
[20:44:30] Unprocessed queries: 25808
[20:45:39] Unprocessed queries: 25253
[20:46:48] Unprocessed queries: 24671
[20:47:57] Unprocessed queries: 24171
[20:49:08] Unprocessed queries: 23568
[20:50:17] Unprocessed queries: 22950
[20:51:26] Unprocessed queries: 22404
[20:52:36] Unprocessed queries: 21851
[20:53:46] Unprocessed queries: 21282
[20:54:56] Unprocessed queries: 20752
[20:56:05] Unprocessed queries: 20237
[20:57:14] Unprocessed queries: 19687
[20:58:23] Unprocessed queries: 19174
[20:59:32] Unprocessed queries: 18629
[21:00:41] Unprocessed queries: 18081
[21:01:50] Unprocessed queries: 17555
[21:02:59] Unprocessed queries: 16996
[21:04:08] Unprocessed queries: 16410
[21:05:18] Unprocessed queries: 15808
[21:06:28] Unprocessed queries: 15153
[21:07:38] Unprocessed queries: 14486
[21:08:49] Unprocessed queries: 13825
[21:09:59] Unprocessed queries: 13143
[21:11:09] Unprocessed queries: 12488
[21:12:20] Unprocessed queries: 11855
[21:13:30] Unprocessed queries: 11234
[21:14:40] Unprocessed queries: 10601
[21:15:50] Unprocessed queries: 9966
[21:17:01] Unprocessed queries: 9512
[21:18:11] Unprocessed queries: 9512
[21:19:21] Unprocessed queries: 9512
[21:20:32] Unprocessed queries: 9512
[21:21:42] Unprocessed queries: 9512
[21:22:52] Unprocessed queries: 9512
[21:24:02] Unprocessed queries: 9512
[21:25:13] Unprocessed queries: 9512
[21:26:23] Unprocessed queries: 9512
Why? only half is successful...

Thanks.
Reply

Quote:
Originally Posted by Adoniiz
Посмотреть сообщение
I have a problem

i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens:

pawn Код:
[20:43:22] Unprocessed queries: 26285
[20:44:30] Unprocessed queries: 25808
[20:45:39] Unprocessed queries: 25253
[20:46:48] Unprocessed queries: 24671
[20:47:57] Unprocessed queries: 24171
[20:49:08] Unprocessed queries: 23568
[20:50:17] Unprocessed queries: 22950
[20:51:26] Unprocessed queries: 22404
[20:52:36] Unprocessed queries: 21851
[20:53:46] Unprocessed queries: 21282
[20:54:56] Unprocessed queries: 20752
[20:56:05] Unprocessed queries: 20237
[20:57:14] Unprocessed queries: 19687
[20:58:23] Unprocessed queries: 19174
[20:59:32] Unprocessed queries: 18629
[21:00:41] Unprocessed queries: 18081
[21:01:50] Unprocessed queries: 17555
[21:02:59] Unprocessed queries: 16996
[21:04:08] Unprocessed queries: 16410
[21:05:18] Unprocessed queries: 15808
[21:06:28] Unprocessed queries: 15153
[21:07:38] Unprocessed queries: 14486
[21:08:49] Unprocessed queries: 13825
[21:09:59] Unprocessed queries: 13143
[21:11:09] Unprocessed queries: 12488
[21:12:20] Unprocessed queries: 11855
[21:13:30] Unprocessed queries: 11234
[21:14:40] Unprocessed queries: 10601
[21:15:50] Unprocessed queries: 9966
[21:17:01] Unprocessed queries: 9512
[21:18:11] Unprocessed queries: 9512
[21:19:21] Unprocessed queries: 9512
[21:20:32] Unprocessed queries: 9512
[21:21:42] Unprocessed queries: 9512
[21:22:52] Unprocessed queries: 9512
[21:24:02] Unprocessed queries: 9512
[21:25:13] Unprocessed queries: 9512
[21:26:23] Unprocessed queries: 9512
Why? only half is successful...

Thanks.
If this happen when you close the server, then this is already a know issue. (This is fixed in R40)
https://github.com/pBlueG/SA-MP-MySQL/issues/64
Reply

Quote:
Originally Posted by Adoniiz
Посмотреть сообщение
I have a problem

i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens:

pawn Код:
[20:43:22] Unprocessed queries: 26285
[20:44:30] Unprocessed queries: 25808
[20:45:39] Unprocessed queries: 25253
[20:46:48] Unprocessed queries: 24671
[20:47:57] Unprocessed queries: 24171
[20:49:08] Unprocessed queries: 23568
[20:50:17] Unprocessed queries: 22950
[20:51:26] Unprocessed queries: 22404
[20:52:36] Unprocessed queries: 21851
[20:53:46] Unprocessed queries: 21282
[20:54:56] Unprocessed queries: 20752
[20:56:05] Unprocessed queries: 20237
[20:57:14] Unprocessed queries: 19687
[20:58:23] Unprocessed queries: 19174
[20:59:32] Unprocessed queries: 18629
[21:00:41] Unprocessed queries: 18081
[21:01:50] Unprocessed queries: 17555
[21:02:59] Unprocessed queries: 16996
[21:04:08] Unprocessed queries: 16410
[21:05:18] Unprocessed queries: 15808
[21:06:28] Unprocessed queries: 15153
[21:07:38] Unprocessed queries: 14486
[21:08:49] Unprocessed queries: 13825
[21:09:59] Unprocessed queries: 13143
[21:11:09] Unprocessed queries: 12488
[21:12:20] Unprocessed queries: 11855
[21:13:30] Unprocessed queries: 11234
[21:14:40] Unprocessed queries: 10601
[21:15:50] Unprocessed queries: 9966
[21:17:01] Unprocessed queries: 9512
[21:18:11] Unprocessed queries: 9512
[21:19:21] Unprocessed queries: 9512
[21:20:32] Unprocessed queries: 9512
[21:21:42] Unprocessed queries: 9512
[21:22:52] Unprocessed queries: 9512
[21:24:02] Unprocessed queries: 9512
[21:25:13] Unprocessed queries: 9512
[21:26:23] Unprocessed queries: 9512
Why? only half is successful...

Thanks.
Look into Mysql Transactions for sending bulk query's, transactions also offer the ability to rollback changes in case something went wrong during the transaction.
Reply

Quote:
Originally Posted by vannesenn
Посмотреть сообщение
Why I have poor load time on Windows 10 Pro(using WAMP server)? On Windows Pro 8.1 I didn't had poor load time.
<insert Windows10 rant here>
Maybe you forgot to configure something? Try setting everything up exactly as you did on Win8.1.

Quote:
Originally Posted by Kar
Посмотреть сообщение
How close is R40? It's been over a year now right?
Yep, it's been over a year and I still don't have an exact release date.

Quote:
Originally Posted by Adoniiz
Посмотреть сообщение
I have a problem

i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens:

pawn Код:
[20:43:22] Unprocessed queries: 26285
[20:44:30] Unprocessed queries: 25808
[20:45:39] Unprocessed queries: 25253
[20:46:48] Unprocessed queries: 24671
[20:47:57] Unprocessed queries: 24171
[20:49:08] Unprocessed queries: 23568
[20:50:17] Unprocessed queries: 22950
[20:51:26] Unprocessed queries: 22404
[20:52:36] Unprocessed queries: 21851
[20:53:46] Unprocessed queries: 21282
[20:54:56] Unprocessed queries: 20752
[20:56:05] Unprocessed queries: 20237
[20:57:14] Unprocessed queries: 19687
[20:58:23] Unprocessed queries: 19174
[20:59:32] Unprocessed queries: 18629
[21:00:41] Unprocessed queries: 18081
[21:01:50] Unprocessed queries: 17555
[21:02:59] Unprocessed queries: 16996
[21:04:08] Unprocessed queries: 16410
[21:05:18] Unprocessed queries: 15808
[21:06:28] Unprocessed queries: 15153
[21:07:38] Unprocessed queries: 14486
[21:08:49] Unprocessed queries: 13825
[21:09:59] Unprocessed queries: 13143
[21:11:09] Unprocessed queries: 12488
[21:12:20] Unprocessed queries: 11855
[21:13:30] Unprocessed queries: 11234
[21:14:40] Unprocessed queries: 10601
[21:15:50] Unprocessed queries: 9966
[21:17:01] Unprocessed queries: 9512
[21:18:11] Unprocessed queries: 9512
[21:19:21] Unprocessed queries: 9512
[21:20:32] Unprocessed queries: 9512
[21:21:42] Unprocessed queries: 9512
[21:22:52] Unprocessed queries: 9512
[21:24:02] Unprocessed queries: 9512
[21:25:13] Unprocessed queries: 9512
[21:26:23] Unprocessed queries: 9512
Why? only half is successful...

Thanks.
You can only queue up to 16876 queries per internal connection. So you either insert long enough delays between queries, execute e.g. 10000 queries in a transaction and execute the other ones in your last query's ("COMMIT") result callback or use mysql_pquery (since it uses multiple internal connections).
Reply

Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4?

pawn Код:
[21:14:11] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
I can't do much with warnings...
Reply

Quote:
Originally Posted by Kar
Посмотреть сообщение
Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4?

pawn Код:
[21:14:11] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
I can't do much with warnings...
Exactly what I'm thinking, I'm getting this error:

Quote:

[13:02:41] [WARNING] cache_get_row_count - no active cache

It took me ages of tests to find where I was getting this error, and after find it, I noticed that the cache_delete function is the reason of that warning, but there's nothing wrong on my code:





Код:
                        else 
			{
				new Float:OffX, Float:OffY,Float:OffZ, Float:RotX, Float:RotY, Float:RotZ, Float:SclX, Float:SclY, Float:SclZ, Color1, Color2;
				mysql_format(MySQL, query, 512, "SELECT * FROM `equiped_items` WHERE `playerid` = %d AND `slotid` = 8", PlayerInfo[playerid][pid]);
				new Cache:handle = mysql_query(MySQL, query, true);

				OffX = cache_get_field_content_float(0, "OffsetX");
				OffY = cache_get_field_content_float(0, "OffsetY");
				OffZ = cache_get_field_content_float(0, "OffsetZ");
				RotX = cache_get_field_content_float(0, "RotX");
				RotY = cache_get_field_content_float(0, "RotY");
				RotZ = cache_get_field_content_float(0, "RotZ");
				SclX = cache_get_field_content_float(0, "ScaleX");
				SclY = cache_get_field_content_float(0, "ScaleY");
				SclZ = cache_get_field_content_float(0, "ScaleZ");
				Color1 = cache_get_field_content_int(0, "Color1");
				Color2 = cache_get_field_content_int(0, "Color2");

				PlayerEquippedItem[playerid][EItemOffX][8] = OffX;
				PlayerEquippedItem[playerid][EItemOffY][8] = OffY;
				PlayerEquippedItem[playerid][EItemOffZ][8] = OffZ;
				PlayerEquippedItem[playerid][EItemRotX][8] = RotX;
				PlayerEquippedItem[playerid][EItemRotY][8] = RotY;
				PlayerEquippedItem[playerid][EItemRotZ][8] = RotZ;
				PlayerEquippedItem[playerid][EItemSclX][8] = SclX;
				PlayerEquippedItem[playerid][EItemSclY][8] = SclY;
				PlayerEquippedItem[playerid][EItemSclZ][8] = SclZ;
				PlayerEquippedItem[playerid][EItemCol1][8] = Color1;
				PlayerEquippedItem[playerid][EItemCol2][8] = Color2;

				SetPlayerAttachedObject(playerid, 8, 371, 1, OffX, OffY, OffZ, RotX, RotY, RotZ, SclX, SclY, SclZ, Color1, Color2);
				return cache_delete(handle);
			}
If I remove the cache_delete function from this code, I get no errors. I have no problem with the retrieved result from query, but this warning is quite annoying and I don't know why I'm getting it.
Reply

Have you actually tried threading your queries every now and then? Judging by the return statement there is absolutely nothing that relies on a value from the database, so you might as well thread the query.
Reply

Quote:
Originally Posted by AIl
Посмотреть сообщение
Can anyone compile R39-3 to work with CentOS 6.5 (And MySQL Server 5.1) ?

I get this error on running the server:
Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[...]
[21:24:11]  Loading plugin: mysql.so
[21:24:11]   Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
[21:24:11]  Loaded 2 plugins.
[...]
R39-2 works fine. (i have only libmysqlclient.so.16 but not libmysqlclient.so.18 :/)
The CentOS download for R39-3 is compiled for CentOS7 while the R39-2 download is compiled for CentOS6 (check the filenames of the archives).

Quote:
Originally Posted by Kar
Посмотреть сообщение
Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4?

pawn Код:
[21:14:11] [WARNING] cache_get_row_int - no active cache
[...]
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
I can't do much with warnings...
I'm already aware of this problem and this is already solved in R40. However, I'm not willing to release such a version (R39-4 as you called it), since this will only halt development on R40. Just wait a little longer.
If you want to help: there's a first beta version coming soon and I'll need some testers for this. I'll post more details when this first beta version is finished.

Quote:
Originally Posted by ipsLeon
Посмотреть сообщение
[...]
It took me ages of tests to find where I was getting this error, and after find it, I noticed that the cache_delete function is the reason of that warning, but there's nothing wrong on my code:

[...]

Код:
                        else 
			{
				new Float:OffX, Float:OffY,Float:OffZ, Float:RotX, Float:RotY, Float:RotZ, Float:SclX, Float:SclY, Float:SclZ, Color1, Color2;
				mysql_format(MySQL, query, 512, "SELECT * FROM `equiped_items` WHERE `playerid` = %d AND `slotid` = 8", PlayerInfo[playerid][pid]);
				new Cache:handle = mysql_query(MySQL, query, true);

				OffX = cache_get_field_content_float(0, "OffsetX");
				OffY = cache_get_field_content_float(0, "OffsetY");
				OffZ = cache_get_field_content_float(0, "OffsetZ");
				RotX = cache_get_field_content_float(0, "RotX");
				RotY = cache_get_field_content_float(0, "RotY");
				RotZ = cache_get_field_content_float(0, "RotZ");
				SclX = cache_get_field_content_float(0, "ScaleX");
				SclY = cache_get_field_content_float(0, "ScaleY");
				SclZ = cache_get_field_content_float(0, "ScaleZ");
				Color1 = cache_get_field_content_int(0, "Color1");
				Color2 = cache_get_field_content_int(0, "Color2");

				PlayerEquippedItem[playerid][EItemOffX][8] = OffX;
				PlayerEquippedItem[playerid][EItemOffY][8] = OffY;
				PlayerEquippedItem[playerid][EItemOffZ][8] = OffZ;
				PlayerEquippedItem[playerid][EItemRotX][8] = RotX;
				PlayerEquippedItem[playerid][EItemRotY][8] = RotY;
				PlayerEquippedItem[playerid][EItemRotZ][8] = RotZ;
				PlayerEquippedItem[playerid][EItemSclX][8] = SclX;
				PlayerEquippedItem[playerid][EItemSclY][8] = SclY;
				PlayerEquippedItem[playerid][EItemSclZ][8] = SclZ;
				PlayerEquippedItem[playerid][EItemCol1][8] = Color1;
				PlayerEquippedItem[playerid][EItemCol2][8] = Color2;

				SetPlayerAttachedObject(playerid, 8, 371, 1, OffX, OffY, OffZ, RotX, RotY, RotZ, SclX, SclY, SclZ, Color1, Color2);
				return cache_delete(handle);
			}
If I remove the cache_delete function from this code, I get no errors. I have no problem with the retrieved result from query, but this warning is quite annoying and I don't know why I'm getting it.
Well, of course you won't get the "no active cache" warning if you don't delete your active cache - it will stay active until another cache overwrites it.
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
The CentOS download for R39-3 is compiled for CentOS7 while the R39-2 download is compiled for CentOS6 (check the filenames of the archives).


I'm already aware of this problem and this is already solved in R40. However, I'm not willing to release such a version (R39-4 as you called it), since this will only halt development on R40. Just wait a little longer.
If you want to help: there's a first beta version coming soon and I'll need some testers for this. I'll post more details when this first beta version is finished.


Well, of course you won't get the "no active cache" warning if you don't delete your active cache - it will stay active until another cache overwrites it.
I'll search for non-deleted caches, I'm actually using few non-threaded queries, I probably missed to delete a cache in some of those queries then.

@Vince: I already changed that return, but I still get the warning, I maybe forgot something as I said above...

#Edit: Should I still get this warning even after use cache_set_active(0) before creating a new cache? Cause I still get it, also, cache_warning_count isn't called when I get the warning on mysql_log...
Reply

Okay but I only asked for that because I use cache_is_valid before EVERY single cache_delete except ONE.

and the code goes like this

pawn Код:
format(gQuery, sizeof(gQuery), "SELECT * FROM `Groups` WHERE `Groupid` = %d LIMIT 0,1", groupid);
    mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnGetGroupMemberData", "iii", playerid, groupid, pQueryQueue[playerid]);

THREAD:OnGetGroupMemberData(playerid, groupid, queryQueue)
{
    if(cache_get_row_count() > 0) {
        new Cache:cacheID = cache_save();

        format(gQuery, sizeof(gQuery), "SELECT `Username`, `pGroupRank` FROM `Accounts` WHERE `pGroupID` = %d ORDER BY `pLastLoginTimestamp` DESC", groupid);
        mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnListGroupMembers", "iiii", playerid, groupid, queryQueue, _:cacheID);
    }
    else SendClientMessage(playerid, WHITE, "Invalid Group ID!");
    return 1;
}

THREAD:OnListGroupMembers(playerid, groupid, queryQueue, Cache:cacheID)
{
    if(pQueryQueue[playerid] != queryQueue) return 1;
    new Cache:curCacheID = cache_save(), row, Username[MAX_PLAYER_NAME], groupRank,
        gRankNames[MAX_GROUP_RANK + 1][MAX_GROUP_RANK_LEN], groupName[MAX_GROUP_NAME_LEN], title[64], groupColour, groupMemCount = 0,
        groupMemLoaded = 0, gMemStr[2048+1], id, next = 0;

    if(cache_is_valid(cacheID)) {
        cache_set_active(cacheID);
    }
    cache_get_row(0, 1, groupName, mysqlConnHandle, MAX_GROUP_NAME_LEN);
    cache_get_row(0, 2, gRankNames[0], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 3, gRankNames[1], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 4, gRankNames[2], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 5, gRankNames[3], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 6, gRankNames[4], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 7, gRankNames[5], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 8, gRankNames[6], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    groupColour = cache_get_row_int(0, 11, mysqlConnHandle);

    cache_delete(cacheID);

    if(cache_is_valid(curCacheID)) {
        cache_set_active(curCacheID);
    }
There must always be a saved cache, so I'm just wondering why the hell would that return a warning.

Or maybe I'm miss understanding my other cache_deletes... is there only cache when rows are returned? or is it created nevertheless when you query something?

pawn Код:
new Cache:cacheID = mysql_query(mysqlConnHandle, gQuery);
        if(cache_is_valid(cacheID)) {
            if(cache_get_row_count()) {
                cache_get_row(0, 0, groupRankName, mysqlConnHandle, MAX_GROUP_RANK_LEN);
            }
            cache_delete(cacheID);
        }
All my other cache usages are EXACTLY like this ^.

So which one is the issue?
Reply

Quote:
Originally Posted by Kar
Посмотреть сообщение
Okay but I only asked for that because I use cache_is_valid before EVERY single cache_delete except ONE.

and the code goes like this

pawn Код:
format(gQuery, sizeof(gQuery), "SELECT * FROM `Groups` WHERE `Groupid` = %d LIMIT 0,1", groupid);
    mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnGetGroupMemberData", "iii", playerid, groupid, pQueryQueue[playerid]);

THREAD:OnGetGroupMemberData(playerid, groupid, queryQueue)
{
    if(cache_get_row_count() > 0) {
        new Cache:cacheID = cache_save();

        format(gQuery, sizeof(gQuery), "SELECT `Username`, `pGroupRank` FROM `Accounts` WHERE `pGroupID` = %d ORDER BY `pLastLoginTimestamp` DESC", groupid);
        mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnListGroupMembers", "iiii", playerid, groupid, queryQueue, _:cacheID);
    }
    else SendClientMessage(playerid, WHITE, "Invalid Group ID!");
    return 1;
}

THREAD:OnListGroupMembers(playerid, groupid, queryQueue, Cache:cacheID)
{
    if(pQueryQueue[playerid] != queryQueue) return 1;
    new Cache:curCacheID = cache_save(), row, Username[MAX_PLAYER_NAME], groupRank,
        gRankNames[MAX_GROUP_RANK + 1][MAX_GROUP_RANK_LEN], groupName[MAX_GROUP_NAME_LEN], title[64], groupColour, groupMemCount = 0,
        groupMemLoaded = 0, gMemStr[2048+1], id, next = 0;

    if(cache_is_valid(cacheID)) {
        cache_set_active(cacheID);
    }
    cache_get_row(0, 1, groupName, mysqlConnHandle, MAX_GROUP_NAME_LEN);
    cache_get_row(0, 2, gRankNames[0], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 3, gRankNames[1], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 4, gRankNames[2], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 5, gRankNames[3], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 6, gRankNames[4], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 7, gRankNames[5], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 8, gRankNames[6], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    groupColour = cache_get_row_int(0, 11, mysqlConnHandle);

    cache_delete(cacheID);

    if(cache_is_valid(curCacheID)) {
        cache_set_active(curCacheID);
    }
There must always be a saved cache, so I'm just wondering why the hell would that return a warning.

Or maybe I'm miss understanding my other cache_deletes... is there only cache when rows are returned? or is it created nevertheless when you query something?

pawn Код:
new Cache:cacheID = mysql_query(mysqlConnHandle, gQuery);
        if(cache_is_valid(cacheID)) {
            if(cache_get_row_count()) {
                cache_get_row(0, 0, groupRankName, mysqlConnHandle, MAX_GROUP_RANK_LEN);
            }
            cache_delete(cacheID);
        }
All my other cache usages are EXACTLY like this ^.

So which one is the issue?
Is it needed to delete caches at every threaded query? Cause if it is, I didn't made it and maybe that's why I'm getting that warning
Reply

"mysql_query" always creates a cache, unless its third parameter is set to "false" (by default it's "true").
More info at the wiki.

Also it's unnecessary to check if a cache is valid directly after creating it through "mysql_query". Calling "cache_delete" on an invalid cache will only generate a warning and return "false".
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
"mysql_query" always creates a cache, unless its third parameter is set to "false" (by default it's "true").
More info at the wiki.

Also it's unnecessary to check if a cache is valid directly after creating it through "mysql_query". Calling "cache_delete" on an invalid cache will only generate a warning and return "false".
I really don't understand what's going on, I've been checking my whole code and all the non-threaded queries has their cache deleted after used, I also did cache_set_active(Cache:0) before creating a new cache but even after unset the current (unknown?) cache by this way, I still get the warning in that code, everything goes well in query retrieved results but that's really strange.
Reply

maddinat0r do you gone add prepared statements on R40?
Reply

Quote:
Originally Posted by AIl
Посмотреть сообщение
It's too hard for you guys? i have a CentOS server that i can give you to do this it's important, thank you for supporting and helping
Quote:

[21:24:11] Loading plugin: mysql.so
[21:24:11] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)

Use mysql_static.so instead of mysql.so or try to find the archive "libmysqlclient.so.18" and put on your VPS.

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
Can't help you further here, sorry. Just wait until R40 is there.
It's okay, thank you sir, I'll remake the code using threaded queries.
Reply

Quote:
Originally Posted by AIl
Посмотреть сообщение
Bro, there isn't any static version binaries in R39-3 is fucked up i already tried static version that is in debian tgz file, doesn't work server just crashed without any log
Hey maddinat0r, can you see my post? Alo ?!
Maddin, your avatar is so beautiful, is that you ?
that's george costanza
Reply

Thanks, I did not know the tutorial for mySQL account system I read was outdated - I will try to start learning from the new one then
Reply

Quote:

Q: I get a Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) error, how do I fix this?
A: You don't have the MySQL client library installed. Install the "mysql-client" package.

How I can install mysql-client?
Reply

Hi, a little help with a query please?

SELECT COUNT(*) FROM `Table1` WHERE `rowid1` NOT IN (SELECT `rowid2` FROM `Table2`) AND `Timestamp` <= '60000' AND `Field2` < 3000 AND `Field3` = 0

It used to work without the ANDs, but its throwing me an error.

Nvm, its fixed.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)